Lines 904-909
CREATE TABLE `deleteditems` (
Link Here
|
904 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
904 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
905 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
905 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
906 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
906 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
|
|
907 |
`itemnotes_nonpublic` mediumtext default NULL, |
907 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
908 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
908 |
`paidfor` mediumtext, |
909 |
`paidfor` mediumtext, |
909 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
910 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
Lines 1202-1207
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
1202 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
1203 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
1203 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
1204 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
1204 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
1205 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
|
|
1206 |
`itemnotes_nonpublic` mediumtext default NULL, |
1205 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
1207 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
1206 |
`paidfor` mediumtext, |
1208 |
`paidfor` mediumtext, |
1207 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
1209 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |