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

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
Lines 949-954 CREATE TABLE `deleteditems` ( Link Here
949
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
949
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
950
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
950
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
951
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
951
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
952
  `new` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.
952
  PRIMARY KEY  (`itemnumber`),
953
  PRIMARY KEY  (`itemnumber`),
953
  KEY `delitembarcodeidx` (`barcode`),
954
  KEY `delitembarcodeidx` (`barcode`),
954
  KEY `delitemstocknumberidx` (`stocknumber`),
955
  KEY `delitemstocknumberidx` (`stocknumber`),
Lines 1251-1256 CREATE TABLE `items` ( -- holdings/item information Link Here
1251
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
1252
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
1252
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
1253
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
1253
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
1254
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
1255
  `new` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.
1254
  PRIMARY KEY  (`itemnumber`),
1256
  PRIMARY KEY  (`itemnumber`),
1255
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1257
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1256
  KEY `itemstocknumberidx` (`stocknumber`),
1258
  KEY `itemstocknumberidx` (`stocknumber`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +13 lines)
Lines 10704-10709 if ( CheckVersion($DBversion) ) { Link Here
10704
    SetVersion($DBversion);
10704
    SetVersion($DBversion);
10705
}
10705
}
10706
10706
10707
$DBversion = "3.21.00.XXX";
10708
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
10709
    $dbh->do(q{
10710
        ALTER TABLE `items` ADD `new` VARCHAR(32) NULL AFTER `stocknumber`;
10711
    });
10712
    $dbh->do(q{
10713
        ALTER TABLE `deleteditems` ADD `new` VARCHAR(32) NULL AFTER `stocknumber`;
10714
    });
10715
    print "Upgrade to $DBversion done (Bug 11023: Adds field 'new' in items and deleteditems tables)\n";
10716
    SetVersion($DBversion);
10717
}
10718
10719
10707
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
10720
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
10708
# SEE bug 13068
10721
# SEE bug 13068
10709
# if there is anything in the atomicupdate, read and execute it.
10722
# if there is anything in the atomicupdate, read and execute it.
10710
- 

Return to bug 11023