Lines 4-10
if( CheckVersion( $DBversion ) ) {
Link Here
|
4 |
$dbh->do(q{CREATE TABLE hold_group ( |
4 |
$dbh->do(q{CREATE TABLE hold_group ( |
5 |
hold_group_id int unsigned NOT NULL AUTO_INCREMENT, |
5 |
hold_group_id int unsigned NOT NULL AUTO_INCREMENT, |
6 |
PRIMARY KEY (hold_group_id) |
6 |
PRIMARY KEY (hold_group_id) |
7 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci}); |
7 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci}); |
8 |
$dbh->do(q{ALTER TABLE reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL}); |
8 |
$dbh->do(q{ALTER TABLE reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL}); |
9 |
$dbh->do(q{ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_6 FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) ON DELETE SET NULL ON UPDATE CASCADE}); |
9 |
$dbh->do(q{ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_6 FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) ON DELETE SET NULL ON UPDATE CASCADE}); |
10 |
$dbh->do(q{ALTER TABLE old_reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL}); |
10 |
$dbh->do(q{ALTER TABLE old_reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL}); |
11 |
- |
|
|