Lines 3566-3572
DROP TABLE IF EXISTS `item_groups`;
Link Here
|
3566 |
/*!40101 SET character_set_client = utf8 */; |
3566 |
/*!40101 SET character_set_client = utf8 */; |
3567 |
CREATE TABLE `item_groups` ( |
3567 |
CREATE TABLE `item_groups` ( |
3568 |
`item_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the items group', |
3568 |
`item_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the items group', |
3569 |
`biblio_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id for the bibliographic record the group belongs to', |
3569 |
`biblio_id` int(11) NOT NULL COMMENT 'id for the bibliographic record the group belongs to', |
3570 |
`display_order` int(4) NOT NULL DEFAULT 0 COMMENT 'The ''sort order'' for item_groups', |
3570 |
`display_order` int(4) NOT NULL DEFAULT 0 COMMENT 'The ''sort order'' for item_groups', |
3571 |
`description` mediumtext DEFAULT NULL COMMENT 'A group description', |
3571 |
`description` mediumtext DEFAULT NULL COMMENT 'A group description', |
3572 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the group was created', |
3572 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the group was created', |
Lines 4846-4852
CREATE TABLE `recalls` (
Link Here
|
4846 |
`recall_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for this recall', |
4846 |
`recall_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for this recall', |
4847 |
`patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for patron who requested recall', |
4847 |
`patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for patron who requested recall', |
4848 |
`created_date` datetime DEFAULT NULL COMMENT 'Date the recall was requested', |
4848 |
`created_date` datetime DEFAULT NULL COMMENT 'Date the recall was requested', |
4849 |
`biblio_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for bibliographic record that has been recalled', |
4849 |
`biblio_id` int(11) NOT NULL COMMENT 'Identifier for bibliographic record that has been recalled', |
4850 |
`pickup_library_id` varchar(10) DEFAULT NULL COMMENT 'Identifier for recall pickup library', |
4850 |
`pickup_library_id` varchar(10) DEFAULT NULL COMMENT 'Identifier for recall pickup library', |
4851 |
`completed_date` datetime DEFAULT NULL COMMENT 'Date the recall is completed (fulfilled, cancelled or expired)', |
4851 |
`completed_date` datetime DEFAULT NULL COMMENT 'Date the recall is completed (fulfilled, cancelled or expired)', |
4852 |
`notes` mediumtext DEFAULT NULL COMMENT 'Notes related to the recall', |
4852 |
`notes` mediumtext DEFAULT NULL COMMENT 'Notes related to the recall', |
4853 |
- |
|
|