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

(-)a/installer/data/mysql/atomicupdate/bug_28972.pl (+15 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "28972",
5
    description => "Add missing foreign key constraints to holds queue table",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{
10
            ALTER TABLE tmp_holdsqueue
11
            ADD CONSTRAINT `tmp_holdsqueue_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
12
            ADD CONSTRAINT `tmp_holdsqueue_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
13
        });
14
    },
15
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +3 lines)
Lines 5103-5109 CREATE TABLE `tmp_holdsqueue` ( Link Here
5103
  `notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5103
  `notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5104
  `item_level_request` tinyint(4) NOT NULL DEFAULT 0,
5104
  `item_level_request` tinyint(4) NOT NULL DEFAULT 0,
5105
  KEY `tmp_holdsqueue_ibfk_1` (`itemnumber`),
5105
  KEY `tmp_holdsqueue_ibfk_1` (`itemnumber`),
5106
  CONSTRAINT `tmp_holdsqueue_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
5106
  CONSTRAINT `tmp_holdsqueue_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
5107
  CONSTRAINT `tmp_holdsqueue_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
5108
  CONSTRAINT `tmp_holdsqueue_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
5107
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5109
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5108
/*!40101 SET character_set_client = @saved_cs_client */;
5110
/*!40101 SET character_set_client = @saved_cs_client */;
5109
5111
5110
- 

Return to bug 28972