Lines 2622-2628
CREATE TABLE `deleteditems` (
Link Here
|
2622 |
`replacementprice` decimal(8,2) DEFAULT NULL COMMENT 'cost the library charges to replace the item if it has been marked lost (MARC21 952$v)', |
2622 |
`replacementprice` decimal(8,2) DEFAULT NULL COMMENT 'cost the library charges to replace the item if it has been marked lost (MARC21 952$v)', |
2623 |
`replacementpricedate` date DEFAULT NULL COMMENT 'the date the price is effective from (MARC21 952$w)', |
2623 |
`replacementpricedate` date DEFAULT NULL COMMENT 'the date the price is effective from (MARC21 952$w)', |
2624 |
`datelastborrowed` date DEFAULT NULL COMMENT 'the date the item was last checked out', |
2624 |
`datelastborrowed` date DEFAULT NULL COMMENT 'the date the item was last checked out', |
2625 |
`datelastseen` date DEFAULT NULL COMMENT 'the date the item was last see (usually the last time the barcode was scanned or inventory was done)', |
2625 |
`datelastseen` datetime DEFAULT NULL COMMENT 'the date the item was last see (usually the last time the barcode was scanned or inventory was done)', |
2626 |
`stack` tinyint(1) DEFAULT NULL, |
2626 |
`stack` tinyint(1) DEFAULT NULL, |
2627 |
`notforloan` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining why this item is not for loan (MARC21 952$7)', |
2627 |
`notforloan` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining why this item is not for loan (MARC21 952$7)', |
2628 |
`damaged` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining this item as damaged (MARC21 952$4)', |
2628 |
`damaged` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining this item as damaged (MARC21 952$4)', |
Lines 3590-3596
CREATE TABLE `items` (
Link Here
|
3590 |
`replacementprice` decimal(8,2) DEFAULT NULL COMMENT 'cost the library charges to replace the item if it has been marked lost (MARC21 952$v)', |
3590 |
`replacementprice` decimal(8,2) DEFAULT NULL COMMENT 'cost the library charges to replace the item if it has been marked lost (MARC21 952$v)', |
3591 |
`replacementpricedate` date DEFAULT NULL COMMENT 'the date the price is effective from (MARC21 952$w)', |
3591 |
`replacementpricedate` date DEFAULT NULL COMMENT 'the date the price is effective from (MARC21 952$w)', |
3592 |
`datelastborrowed` date DEFAULT NULL COMMENT 'the date the item was last checked out/issued', |
3592 |
`datelastborrowed` date DEFAULT NULL COMMENT 'the date the item was last checked out/issued', |
3593 |
`datelastseen` date DEFAULT NULL COMMENT 'the date the item was last see (usually the last time the barcode was scanned or inventory was done)', |
3593 |
`datelastseen` datetime DEFAULT NULL COMMENT 'the date the item was last see (usually the last time the barcode was scanned or inventory was done)', |
3594 |
`stack` tinyint(1) DEFAULT NULL, |
3594 |
`stack` tinyint(1) DEFAULT NULL, |
3595 |
`notforloan` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining why this item is not for loan (MARC21 952$7)', |
3595 |
`notforloan` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining why this item is not for loan (MARC21 952$7)', |
3596 |
`damaged` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining this item as damaged (MARC21 952$4)', |
3596 |
`damaged` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining this item as damaged (MARC21 952$4)', |