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

(-)a/installer/data/mysql/atomicupdate/bug_15516_-_hold_group_table.pl (-1 / +3 lines)
Lines 19-24 return { Link Here
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 AFTER non_priority});
21
                q{ALTER TABLE reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL AFTER non_priority});
22
            $dbh->do(q{ALTER TABLE reserves ADD KEY reserves_ibfk_hg (hold_group_id)});
22
            $dbh->do(
23
            $dbh->do(
23
                q{ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_hg FOREIGN KEY (hold_group_id) REFERENCES hold_groups (hold_group_id) ON DELETE SET NULL ON UPDATE CASCADE}
24
                q{ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_hg FOREIGN KEY (hold_group_id) REFERENCES hold_groups (hold_group_id) ON DELETE SET NULL ON UPDATE CASCADE}
24
            );
25
            );
Lines 27-34 return { Link Here
27
        unless ( column_exists( 'old_reserves', 'hold_group_id' ) ) {
28
        unless ( column_exists( 'old_reserves', 'hold_group_id' ) ) {
28
            $dbh->do(
29
            $dbh->do(
29
                q{ALTER TABLE old_reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL AFTER non_priority});
30
                q{ALTER TABLE old_reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL AFTER non_priority});
31
            $dbh->do(q{ALTER TABLE old_reserves ADD KEY old_reserves_ibfk_hg (hold_group_id)});
30
            $dbh->do(
32
            $dbh->do(
31
                q{ALTER TABLE old_reserves ADD CONSTRAINT old_reserves_ibfk_hg FOREIGN KEY (hold_group_id) REFERENCES hold_groups (hold_group_id) ON DELETE SET NULL ON UPDATE CASCADE}
33
                q{ALTER TABLE old_reserves ADD CONSTRAINT old_reserves_ibfk_hg FOREIGN KEY (hold_group_id) REFERENCES hold_groups (hold_group_id) ON DELETE SET NULL ON UPDATE SET NULL}
32
            );
34
            );
33
        }
35
        }
34
    },
36
    },
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 5112-5117 CREATE TABLE `old_reserves` ( Link Here
5112
  KEY `old_reserves_branchcode` (`branchcode`),
5112
  KEY `old_reserves_branchcode` (`branchcode`),
5113
  KEY `old_reserves_itemtype` (`itemtype`),
5113
  KEY `old_reserves_itemtype` (`itemtype`),
5114
  KEY `old_reserves_ibfk_ig` (`item_group_id`),
5114
  KEY `old_reserves_ibfk_ig` (`item_group_id`),
5115
  KEY `old_reserves_ibfk_hg` (`hold_group_id`),
5115
  CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5116
  CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5116
  CONSTRAINT `old_reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5117
  CONSTRAINT `old_reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5117
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5118
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
Lines 5686-5691 CREATE TABLE `reserves` ( Link Here
5686
  KEY `desk_id` (`desk_id`),
5687
  KEY `desk_id` (`desk_id`),
5687
  KEY `itemtype` (`itemtype`),
5688
  KEY `itemtype` (`itemtype`),
5688
  KEY `reserves_ibfk_ig` (`item_group_id`),
5689
  KEY `reserves_ibfk_ig` (`item_group_id`),
5690
  KEY `reserves_ibfk_hg` (`hold_group_id`),
5689
  CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
5691
  CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
5690
  CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
5692
  CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
5691
  CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
5693
  CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
5692
- 

Return to bug 15516