View | Details | Raw Unified | Return to bug 15516
Collapse All | Expand All

(-)a/installer/data/mysql/db_revs/250600012.pl (-3 / +3 lines)
Lines 10-16 return { Link Here
10
        unless ( TableExists('hold_groups') ) {
10
        unless ( TableExists('hold_groups') ) {
11
            $dbh->do(
11
            $dbh->do(
12
                q{CREATE TABLE hold_groups (
12
                q{CREATE TABLE hold_groups (
13
                hold_group_id int unsigned NOT NULL AUTO_INCREMENT,
13
                hold_group_id int(10) unsigned NOT NULL AUTO_INCREMENT,
14
                PRIMARY KEY (hold_group_id)
14
                PRIMARY KEY (hold_group_id)
15
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci}
15
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci}
16
            );
16
            );
Lines 18-24 return { Link Here
18
18
19
        unless ( column_exists( 'reserves', 'hold_group_id' ) ) {
19
        unless ( column_exists( 'reserves', 'hold_group_id' ) ) {
20
            $dbh->do(
20
            $dbh->do(
21
                q{ALTER TABLE reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked' AFTER non_priority}
21
                q{ALTER TABLE reserves ADD COLUMN hold_group_id int(10) unsigned NULL DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked' AFTER non_priority}
22
            );
22
            );
23
            $dbh->do(q{ALTER TABLE reserves ADD KEY reserves_ibfk_hg (hold_group_id)});
23
            $dbh->do(q{ALTER TABLE reserves ADD KEY reserves_ibfk_hg (hold_group_id)});
24
            $dbh->do(
24
            $dbh->do(
Lines 28-34 return { Link Here
28
28
29
        unless ( column_exists( 'old_reserves', 'hold_group_id' ) ) {
29
        unless ( column_exists( 'old_reserves', 'hold_group_id' ) ) {
30
            $dbh->do(
30
            $dbh->do(
31
                q{ALTER TABLE old_reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked' AFTER non_priority}
31
                q{ALTER TABLE old_reserves ADD COLUMN hold_group_id int(10) unsigned NULL DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked' AFTER non_priority}
32
            );
32
            );
33
            $dbh->do(q{ALTER TABLE old_reserves ADD KEY old_reserves_ibfk_hg (hold_group_id)});
33
            $dbh->do(q{ALTER TABLE old_reserves ADD KEY old_reserves_ibfk_hg (hold_group_id)});
34
            $dbh->do(
34
            $dbh->do(
(-)a/installer/data/mysql/kohastructure.sql (-19 / +19 lines)
Lines 3542-3547 CREATE TABLE `hold_fill_targets` ( Link Here
3542
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3542
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3543
/*!40101 SET character_set_client = @saved_cs_client */;
3543
/*!40101 SET character_set_client = @saved_cs_client */;
3544
3544
3545
--
3546
-- Table structure for table `hold_groups`
3547
--
3548
3549
DROP TABLE IF EXISTS `hold_groups`;
3550
/*!40101 SET @saved_cs_client     = @@character_set_client */;
3551
/*!40101 SET character_set_client = utf8mb4 */;
3552
CREATE TABLE `hold_groups` (
3553
  `hold_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3554
  PRIMARY KEY (`hold_group_id`)
3555
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3556
/*!40101 SET character_set_client = @saved_cs_client */;
3557
3545
--
3558
--
3546
-- Table structure for table `housebound_profile`
3559
-- Table structure for table `housebound_profile`
3547
--
3560
--
Lines 5095-5112 CREATE TABLE `old_issues` ( Link Here
5095
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5108
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5096
/*!40101 SET character_set_client = @saved_cs_client */;
5109
/*!40101 SET character_set_client = @saved_cs_client */;
5097
5110
5098
--
5099
-- Table structure for table `hold_groups`
5100
--
5101
DROP TABLE IF EXISTS `hold_groups`;
5102
/*!40101 SET @saved_cs_client     = @@character_set_client */;
5103
/*!40101 SET character_set_client = utf8 */;
5104
CREATE TABLE hold_groups (
5105
    hold_group_id int unsigned NOT NULL AUTO_INCREMENT,
5106
    PRIMARY KEY (hold_group_id)
5107
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5108
/*!40101 SET character_set_client = @saved_cs_client */;
5109
5110
--
5111
--
5111
-- Table structure for table `old_reserves`
5112
-- Table structure for table `old_reserves`
5112
--
5113
--
Lines 5141-5147 CREATE TABLE `old_reserves` ( Link Here
5141
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting',
5142
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting',
5142
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level',
5143
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level',
5143
  `non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold',
5144
  `non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold',
5144
  `hold_group_id` int unsigned NULL DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked',
5145
  `hold_group_id` int(10) unsigned DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked',
5145
  PRIMARY KEY (`reserve_id`),
5146
  PRIMARY KEY (`reserve_id`),
5146
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
5147
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
5147
  KEY `old_reserves_biblionumber` (`biblionumber`),
5148
  KEY `old_reserves_biblionumber` (`biblionumber`),
Lines 5155-5162 CREATE TABLE `old_reserves` ( Link Here
5155
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5156
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5156
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE SET NULL ON UPDATE SET NULL,
5157
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE SET NULL ON UPDATE SET NULL,
5157
  CONSTRAINT `old_reserves_ibfk_branchcode` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE,
5158
  CONSTRAINT `old_reserves_ibfk_branchcode` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE,
5158
  CONSTRAINT `old_reserves_ibfk_ig` FOREIGN KEY (`item_group_id`) REFERENCES `item_groups` (`item_group_id`) ON DELETE SET NULL ON UPDATE SET NULL,
5159
  CONSTRAINT `old_reserves_ibfk_hg` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_groups` (`hold_group_id`) ON DELETE SET NULL ON UPDATE SET NULL,
5159
  CONSTRAINT `old_reserves_ibfk_hg` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_groups` (`hold_group_id`) ON DELETE SET NULL ON UPDATE SET NULL
5160
  CONSTRAINT `old_reserves_ibfk_ig` FOREIGN KEY (`item_group_id`) REFERENCES `item_groups` (`item_group_id`) ON DELETE SET NULL ON UPDATE SET NULL
5160
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5161
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5161
/*!40101 SET character_set_client = @saved_cs_client */;
5162
/*!40101 SET character_set_client = @saved_cs_client */;
5162
5163
Lines 5713-5719 CREATE TABLE `reserves` ( Link Here
5713
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting',
5714
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting',
5714
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level',
5715
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level',
5715
  `non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold',
5716
  `non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold',
5716
  `hold_group_id` int unsigned NULL DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked',
5717
  `hold_group_id` int(10) unsigned DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked',
5717
  PRIMARY KEY (`reserve_id`),
5718
  PRIMARY KEY (`reserve_id`),
5718
  KEY `priorityfoundidx` (`priority`,`found`),
5719
  KEY `priorityfoundidx` (`priority`,`found`),
5719
  KEY `borrowernumber` (`borrowernumber`),
5720
  KEY `borrowernumber` (`borrowernumber`),
Lines 5730-5737 CREATE TABLE `reserves` ( Link Here
5730
  CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
5731
  CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
5731
  CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE,
5732
  CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE,
5732
  CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE,
5733
  CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE,
5733
  CONSTRAINT `reserves_ibfk_ig` FOREIGN KEY (`item_group_id`) REFERENCES `item_groups` (`item_group_id`) ON DELETE SET NULL ON UPDATE CASCADE,
5734
  CONSTRAINT `reserves_ibfk_hg` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_groups` (`hold_group_id`) ON DELETE SET NULL ON UPDATE CASCADE,
5734
  CONSTRAINT `reserves_ibfk_hg` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_groups` (`hold_group_id`) ON DELETE SET NULL ON UPDATE CASCADE
5735
  CONSTRAINT `reserves_ibfk_ig` FOREIGN KEY (`item_group_id`) REFERENCES `item_groups` (`item_group_id`) ON DELETE SET NULL ON UPDATE CASCADE
5735
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5736
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5736
/*!40101 SET character_set_client = @saved_cs_client */;
5737
/*!40101 SET character_set_client = @saved_cs_client */;
5737
5738
5738
- 

Return to bug 15516