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 AFTER non_priority}); |
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} |
|
|
22 |
); |
22 |
$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)}); |
23 |
$dbh->do( |
24 |
$dbh->do( |
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} |
25 |
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} |
Lines 27-33
return {
Link Here
|
27 |
|
28 |
|
28 |
unless ( column_exists( 'old_reserves', 'hold_group_id' ) ) { |
29 |
unless ( column_exists( 'old_reserves', 'hold_group_id' ) ) { |
29 |
$dbh->do( |
30 |
$dbh->do( |
30 |
q{ALTER TABLE old_reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL AFTER non_priority}); |
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} |
|
|
32 |
); |
31 |
$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)}); |
32 |
$dbh->do( |
34 |
$dbh->do( |
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} |
35 |
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} |
34 |
- |
|
|