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

(-)a/installer/data/mysql/kohastructure.sql (-5 / +4 lines)
Lines 679-686 CREATE TABLE `deleteditems` ( Link Here
679
  `renewals` smallint(6) default NULL, -- number of times this item has been renewed
679
  `renewals` smallint(6) default NULL, -- number of times this item has been renewed
680
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
680
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
681
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
681
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
682
  `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$x)
682
  `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)
683
  `itemnotes_nonpublic` LONGTEXT default NULL,
683
  `itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)
684
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
684
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
685
  `paidfor` LONGTEXT,
685
  `paidfor` LONGTEXT,
686
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
686
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
Lines 942-949 CREATE TABLE `items` ( -- holdings/item information Link Here
942
  `renewals` smallint(6) default NULL, -- number of times this item has been renewed
942
  `renewals` smallint(6) default NULL, -- number of times this item has been renewed
943
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
943
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
944
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
944
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
945
  `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$x)
945
  `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)
946
  `itemnotes_nonpublic` LONGTEXT default NULL,
946
  `itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)
947
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
947
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
948
  `paidfor` LONGTEXT,
948
  `paidfor` LONGTEXT,
949
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
949
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
950
- 

Return to bug 20544