Lines 930-935
CREATE TABLE `deleteditems` (
Link Here
|
930 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
930 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
931 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
931 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
932 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
932 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
|
|
933 |
`itemnotes_nonpublic` mediumtext default NULL, |
933 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
934 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
934 |
`paidfor` mediumtext, |
935 |
`paidfor` mediumtext, |
935 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
936 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
Lines 1229-1234
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
1229 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
1230 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
1230 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
1231 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
1231 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
1232 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
|
|
1233 |
`itemnotes_nonpublic` mediumtext default NULL, |
1232 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
1234 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
1233 |
`paidfor` mediumtext, |
1235 |
`paidfor` mediumtext, |
1234 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
1236 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |