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

Return to bug 26268