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

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 917-923 CREATE TABLE `deleteditems` ( Link Here
917
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
917
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
918
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
918
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
919
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
919
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
920
  `new` VARCHAR(32) DEFAULT NULL, -- new flag
920
  `new` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the toggle_new_status cronjob.
921
  PRIMARY KEY  (`itemnumber`),
921
  PRIMARY KEY  (`itemnumber`),
922
  KEY `delitembarcodeidx` (`barcode`),
922
  KEY `delitembarcodeidx` (`barcode`),
923
  KEY `delitemstocknumberidx` (`stocknumber`),
923
  KEY `delitemstocknumberidx` (`stocknumber`),
Lines 1212-1218 CREATE TABLE `items` ( -- holdings/item information Link Here
1212
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
1212
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
1213
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
1213
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
1214
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
1214
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
1215
  `new` VARCHAR(32) DEFAULT NULL, -- new flag
1215
  `new` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intended to be managed by the toggle_new_status cronjob.
1216
  PRIMARY KEY  (`itemnumber`),
1216
  PRIMARY KEY  (`itemnumber`),
1217
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1217
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1218
  KEY `itemstocknumberidx` (`stocknumber`),
1218
  KEY `itemstocknumberidx` (`stocknumber`),
1219
- 

Return to bug 11023