View | Details | Raw Unified | Return to bug 26268
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_26268.perl (+10 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    if( !column_exists( 'items', 'paidfor' ) ) {
5
       $dbh->do(q|ALTER TABLE items DROP COLUMN paidfor|);
6
       $dbh->do(q|ALTER TABLE deleteditems DROP COLUMN paidfor|);
7
    }
8
9
    NewVersion( $DBversion, 26268, "Remove items.paidfor field");
10
}
(-)a/installer/data/mysql/kohastructure.sql (-3 lines)
Lines 648-654 CREATE TABLE `deleteditems` ( Link Here
648
  `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)
648
  `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)
649
  `itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)
649
  `itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)
650
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
650
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
651
  `paidfor` LONGTEXT,
652
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
651
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
653
  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
652
  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
654
  `permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location
653
  `permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location
Lines 856-862 CREATE TABLE `items` ( -- holdings/item information Link Here
856
  `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)
855
  `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)
857
  `itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)
856
  `itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)
858
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
857
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
859
  `paidfor` LONGTEXT,
860
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
858
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
861
  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
859
  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
862
  `permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location
860
  `permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location
863
- 

Return to bug 26268