Lines 3582-3588
DROP TABLE IF EXISTS `item_groups`;
Link Here
|
3582 |
/*!40101 SET character_set_client = utf8 */; |
3582 |
/*!40101 SET character_set_client = utf8 */; |
3583 |
CREATE TABLE `item_groups` ( |
3583 |
CREATE TABLE `item_groups` ( |
3584 |
`item_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the items group', |
3584 |
`item_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the items group', |
3585 |
`biblio_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id for the bibliographic record the group belongs to', |
3585 |
`biblio_id` int(11) NOT NULL COMMENT 'id for the bibliographic record the group belongs to', |
3586 |
`display_order` int(4) NOT NULL DEFAULT 0 COMMENT 'The ''sort order'' for item_groups', |
3586 |
`display_order` int(4) NOT NULL DEFAULT 0 COMMENT 'The ''sort order'' for item_groups', |
3587 |
`description` mediumtext DEFAULT NULL COMMENT 'A group description', |
3587 |
`description` mediumtext DEFAULT NULL COMMENT 'A group description', |
3588 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the group was created', |
3588 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the group was created', |
Lines 4863-4869
CREATE TABLE `recalls` (
Link Here
|
4863 |
`recall_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for this recall', |
4863 |
`recall_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for this recall', |
4864 |
`patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for patron who requested recall', |
4864 |
`patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for patron who requested recall', |
4865 |
`created_date` datetime DEFAULT NULL COMMENT 'Date the recall was requested', |
4865 |
`created_date` datetime DEFAULT NULL COMMENT 'Date the recall was requested', |
4866 |
`biblio_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for bibliographic record that has been recalled', |
4866 |
`biblio_id` int(11) NOT NULL COMMENT 'Identifier for bibliographic record that has been recalled', |
4867 |
`pickup_library_id` varchar(10) DEFAULT NULL COMMENT 'Identifier for recall pickup library', |
4867 |
`pickup_library_id` varchar(10) DEFAULT NULL COMMENT 'Identifier for recall pickup library', |
4868 |
`completed_date` datetime DEFAULT NULL COMMENT 'Date the recall is completed (fulfilled, cancelled or expired)', |
4868 |
`completed_date` datetime DEFAULT NULL COMMENT 'Date the recall is completed (fulfilled, cancelled or expired)', |
4869 |
`notes` mediumtext DEFAULT NULL COMMENT 'Notes related to the recall', |
4869 |
`notes` mediumtext DEFAULT NULL COMMENT 'Notes related to the recall', |
4870 |
- |
|
|