|
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)', |