Lines 2643-2649
CREATE TABLE `deleteditems` (
Link Here
|
2643 |
`replacementprice` decimal(8,2) DEFAULT NULL COMMENT 'cost the library charges to replace the item if it has been marked lost (MARC21 952$v)', |
2643 |
`replacementprice` decimal(8,2) DEFAULT NULL COMMENT 'cost the library charges to replace the item if it has been marked lost (MARC21 952$v)', |
2644 |
`replacementpricedate` date DEFAULT NULL COMMENT 'the date the price is effective from (MARC21 952$w)', |
2644 |
`replacementpricedate` date DEFAULT NULL COMMENT 'the date the price is effective from (MARC21 952$w)', |
2645 |
`datelastborrowed` date DEFAULT NULL COMMENT 'the date the item was last checked out', |
2645 |
`datelastborrowed` date DEFAULT NULL COMMENT 'the date the item was last checked out', |
2646 |
`datelastseen` date DEFAULT NULL COMMENT 'the date the item was last see (usually the last time the barcode was scanned or inventory was done)', |
2646 |
`datelastseen` datetime DEFAULT NULL COMMENT 'the date the item was last see (usually the last time the barcode was scanned or inventory was done)', |
2647 |
`stack` tinyint(1) DEFAULT NULL, |
2647 |
`stack` tinyint(1) DEFAULT NULL, |
2648 |
`notforloan` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining why this item is not for loan (MARC21 952$7)', |
2648 |
`notforloan` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining why this item is not for loan (MARC21 952$7)', |
2649 |
`damaged` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining this item as damaged (MARC21 952$4)', |
2649 |
`damaged` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining this item as damaged (MARC21 952$4)', |
Lines 3612-3618
CREATE TABLE `items` (
Link Here
|
3612 |
`replacementprice` decimal(8,2) DEFAULT NULL COMMENT 'cost the library charges to replace the item if it has been marked lost (MARC21 952$v)', |
3612 |
`replacementprice` decimal(8,2) DEFAULT NULL COMMENT 'cost the library charges to replace the item if it has been marked lost (MARC21 952$v)', |
3613 |
`replacementpricedate` date DEFAULT NULL COMMENT 'the date the price is effective from (MARC21 952$w)', |
3613 |
`replacementpricedate` date DEFAULT NULL COMMENT 'the date the price is effective from (MARC21 952$w)', |
3614 |
`datelastborrowed` date DEFAULT NULL COMMENT 'the date the item was last checked out/issued', |
3614 |
`datelastborrowed` date DEFAULT NULL COMMENT 'the date the item was last checked out/issued', |
3615 |
`datelastseen` date DEFAULT NULL COMMENT 'the date the item was last see (usually the last time the barcode was scanned or inventory was done)', |
3615 |
`datelastseen` datetime DEFAULT NULL COMMENT 'the date the item was last see (usually the last time the barcode was scanned or inventory was done)', |
3616 |
`stack` tinyint(1) DEFAULT NULL, |
3616 |
`stack` tinyint(1) DEFAULT NULL, |
3617 |
`notforloan` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining why this item is not for loan (MARC21 952$7)', |
3617 |
`notforloan` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining why this item is not for loan (MARC21 952$7)', |
3618 |
`damaged` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining this item as damaged (MARC21 952$4)', |
3618 |
`damaged` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining this item as damaged (MARC21 952$4)', |