Lines 3515-3520
CREATE TABLE `hold_fill_targets` (
Link Here
|
3515 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3515 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3516 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3516 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3517 |
|
3517 |
|
|
|
3518 |
-- |
3519 |
-- Table structure for table `hold_groups` |
3520 |
-- |
3521 |
DROP TABLE IF EXISTS `hold_groups`; |
3522 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
3523 |
/*!40101 SET character_set_client = utf8mb4 */; |
3524 |
CREATE TABLE hold_groups ( |
3525 |
`hold_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
3526 |
PRIMARY KEY (`hold_group_id`) |
3527 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3528 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3529 |
|
3518 |
-- |
3530 |
-- |
3519 |
-- Table structure for table `housebound_profile` |
3531 |
-- Table structure for table `housebound_profile` |
3520 |
-- |
3532 |
-- |
Lines 5068-5085
CREATE TABLE `old_issues` (
Link Here
|
5068 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5080 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5069 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5081 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5070 |
|
5082 |
|
5071 |
-- |
|
|
5072 |
-- Table structure for table `hold_groups` |
5073 |
-- |
5074 |
DROP TABLE IF EXISTS `hold_groups`; |
5075 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5076 |
/*!40101 SET character_set_client = utf8 */; |
5077 |
CREATE TABLE hold_groups ( |
5078 |
hold_group_id int unsigned NOT NULL AUTO_INCREMENT, |
5079 |
PRIMARY KEY (hold_group_id) |
5080 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5081 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5082 |
|
5083 |
-- |
5083 |
-- |
5084 |
-- Table structure for table `old_reserves` |
5084 |
-- Table structure for table `old_reserves` |
5085 |
-- |
5085 |
-- |
Lines 5114-5120
CREATE TABLE `old_reserves` (
Link Here
|
5114 |
`itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting', |
5114 |
`itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting', |
5115 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level', |
5115 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level', |
5116 |
`non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold', |
5116 |
`non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold', |
5117 |
`hold_group_id` int unsigned NULL DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked', |
5117 |
`hold_group_id` int(10) unsigned DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked', |
5118 |
PRIMARY KEY (`reserve_id`), |
5118 |
PRIMARY KEY (`reserve_id`), |
5119 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
5119 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
5120 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
5120 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
Lines 5128-5135
CREATE TABLE `old_reserves` (
Link Here
|
5128 |
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
5128 |
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
5129 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE SET NULL ON UPDATE SET NULL, |
5129 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE SET NULL ON UPDATE SET NULL, |
5130 |
CONSTRAINT `old_reserves_ibfk_branchcode` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
5130 |
CONSTRAINT `old_reserves_ibfk_branchcode` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
5131 |
CONSTRAINT `old_reserves_ibfk_ig` FOREIGN KEY (`item_group_id`) REFERENCES `item_groups` (`item_group_id`) ON DELETE SET NULL ON UPDATE SET NULL, |
5131 |
CONSTRAINT `old_reserves_ibfk_hg` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_groups` (`hold_group_id`) ON DELETE SET NULL ON UPDATE SET NULL, |
5132 |
CONSTRAINT `old_reserves_ibfk_hg` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_groups` (`hold_group_id`) ON DELETE SET NULL ON UPDATE SET NULL |
5132 |
CONSTRAINT `old_reserves_ibfk_ig` FOREIGN KEY (`item_group_id`) REFERENCES `item_groups` (`item_group_id`) ON DELETE SET NULL ON UPDATE SET NULL |
5133 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5133 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5134 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5134 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5135 |
|
5135 |
|
Lines 5686-5692
CREATE TABLE `reserves` (
Link Here
|
5686 |
`itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting', |
5686 |
`itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting', |
5687 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level', |
5687 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level', |
5688 |
`non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold', |
5688 |
`non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold', |
5689 |
`hold_group_id` int unsigned NULL DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked', |
5689 |
`hold_group_id` int(10) unsigned DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked', |
5690 |
PRIMARY KEY (`reserve_id`), |
5690 |
PRIMARY KEY (`reserve_id`), |
5691 |
KEY `priorityfoundidx` (`priority`,`found`), |
5691 |
KEY `priorityfoundidx` (`priority`,`found`), |
5692 |
KEY `borrowernumber` (`borrowernumber`), |
5692 |
KEY `borrowernumber` (`borrowernumber`), |
Lines 5703-5710
CREATE TABLE `reserves` (
Link Here
|
5703 |
CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
5703 |
CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
5704 |
CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
5704 |
CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
5705 |
CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
5705 |
CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
5706 |
CONSTRAINT `reserves_ibfk_ig` FOREIGN KEY (`item_group_id`) REFERENCES `item_groups` (`item_group_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
5706 |
CONSTRAINT `reserves_ibfk_hg` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_groups` (`hold_group_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
5707 |
CONSTRAINT `reserves_ibfk_hg` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_groups` (`hold_group_id`) ON DELETE SET NULL ON UPDATE CASCADE |
5707 |
CONSTRAINT `reserves_ibfk_ig` FOREIGN KEY (`item_group_id`) REFERENCES `item_groups` (`item_group_id`) ON DELETE SET NULL ON UPDATE CASCADE |
5708 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5708 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5709 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5709 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5710 |
|
5710 |
|
5711 |
- |
|
|