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 649-655 CREATE TABLE `deleteditems` ( Link Here
649
  `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)
649
  `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)
650
  `itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)
650
  `itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)
651
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
651
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
652
  `paidfor` LONGTEXT,
653
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
652
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
654
  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
653
  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
655
  `permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location
654
  `permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location
Lines 858-864 CREATE TABLE `items` ( -- holdings/item information Link Here
858
  `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)
857
  `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)
859
  `itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)
858
  `itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)
860
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
859
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
861
  `paidfor` LONGTEXT,
862
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
860
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
863
  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
861
  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
864
  `permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location
862
  `permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location
865
- 

Return to bug 26268