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

(-)a/installer/data/mysql/db_revs/230600013.pl (-2 / +7 lines)
Lines 8-15 return { Link Here
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
9
10
        unless ( primary_key_exists( 'tmp_holdsqueue', 'itemnumber' ) ) {
10
        unless ( primary_key_exists( 'tmp_holdsqueue', 'itemnumber' ) ) {
11
            $dbh->do(q{ALTER TABLE tmp_holdsqueue DROP CONSTRAINT `tmp_holdsqueue_ibfk_1`});
12
            $dbh->do(q{ALTER TABLE tmp_holdsqueue ADD PRIMARY KEY (itemnumber)});
11
            $dbh->do(
13
            $dbh->do(
12
                q{ALTER TABLE tmp_holdsqueue ADD PRIMARY KEY (itemnumber)}
14
                q{
15
                    ALTER TABLE tmp_holdsqueue ADD CONSTRAINT `tmp_holdsqueue_ibfk_1`
16
                    FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
17
                    ON DELETE CASCADE ON UPDATE CASCADE
18
                }
13
            );
19
            );
14
        }
20
        }
15
21
16
- 

Return to bug 35687