|
Lines 10421-10433
if ( CheckVersion($DBversion) ) {
Link Here
|
| 10421 |
$DBversion = "3.19.00.041"; |
10421 |
$DBversion = "3.19.00.041"; |
| 10422 |
if ( CheckVersion($DBversion) ) { |
10422 |
if ( CheckVersion($DBversion) ) { |
| 10423 |
$dbh->do(q| |
10423 |
$dbh->do(q| |
| 10424 |
ALTER IGNORE TABLE suggestions ADD KEY status (STATUS) |
10424 |
ALTER TABLE suggestions ADD KEY status (STATUS) |
| 10425 |
|); |
10425 |
|); |
| 10426 |
$dbh->do(q| |
10426 |
$dbh->do(q| |
| 10427 |
ALTER IGNORE TABLE suggestions ADD KEY biblionumber (biblionumber) |
10427 |
ALTER TABLE suggestions ADD KEY biblionumber (biblionumber) |
| 10428 |
|); |
10428 |
|); |
| 10429 |
$dbh->do(q| |
10429 |
$dbh->do(q| |
| 10430 |
ALTER IGNORE TABLE suggestions ADD KEY branchcode (branchcode) |
10430 |
ALTER TABLE suggestions ADD KEY branchcode (branchcode) |
| 10431 |
|); |
10431 |
|); |
| 10432 |
print "Upgrade to $DBversion done (Bug 14132: suggestions table is missing indexes)\n"; |
10432 |
print "Upgrade to $DBversion done (Bug 14132: suggestions table is missing indexes)\n"; |
| 10433 |
SetVersion ($DBversion); |
10433 |
SetVersion ($DBversion); |
|
Lines 10443-10449
if ( CheckVersion($DBversion) ) {
Link Here
|
| 10443 |
}); |
10443 |
}); |
| 10444 |
|
10444 |
|
| 10445 |
$dbh->do(q{ |
10445 |
$dbh->do(q{ |
| 10446 |
ALTER IGNORE TABLE auth_subfield_structure |
10446 |
ALTER TABLE auth_subfield_structure |
| 10447 |
ADD CONSTRAINT auth_subfield_structure_ibfk_1 |
10447 |
ADD CONSTRAINT auth_subfield_structure_ibfk_1 |
| 10448 |
FOREIGN KEY (authtypecode) REFERENCES auth_types(authtypecode) |
10448 |
FOREIGN KEY (authtypecode) REFERENCES auth_types(authtypecode) |
| 10449 |
ON DELETE CASCADE ON UPDATE CASCADE |
10449 |
ON DELETE CASCADE ON UPDATE CASCADE |
|
Lines 10564-10578
if ( CheckVersion($DBversion) ) {
Link Here
|
| 10564 |
$DBversion = "3.21.00.007"; |
10564 |
$DBversion = "3.21.00.007"; |
| 10565 |
if ( CheckVersion($DBversion) ) { |
10565 |
if ( CheckVersion($DBversion) ) { |
| 10566 |
$dbh->do(q| |
10566 |
$dbh->do(q| |
| 10567 |
ALTER IGNORE TABLE aqbasket |
10567 |
ALTER TABLE aqbasket |
| 10568 |
ADD KEY authorisedby (authorisedby) |
10568 |
ADD KEY authorisedby (authorisedby) |
| 10569 |
|); |
10569 |
|); |
| 10570 |
$dbh->do(q| |
10570 |
$dbh->do(q| |
| 10571 |
ALTER IGNORE TABLE aqbooksellers |
10571 |
ALTER TABLE aqbooksellers |
| 10572 |
ADD KEY name (name(255)) |
10572 |
ADD KEY name (name(255)) |
| 10573 |
|); |
10573 |
|); |
| 10574 |
$dbh->do(q| |
10574 |
$dbh->do(q| |
| 10575 |
ALTER IGNORE TABLE aqbudgets |
10575 |
ALTER TABLE aqbudgets |
| 10576 |
ADD KEY budget_parent_id (budget_parent_id), |
10576 |
ADD KEY budget_parent_id (budget_parent_id), |
| 10577 |
ADD KEY budget_code (budget_code), |
10577 |
ADD KEY budget_code (budget_code), |
| 10578 |
ADD KEY budget_branchcode (budget_branchcode), |
10578 |
ADD KEY budget_branchcode (budget_branchcode), |
|
Lines 10580-10590
if ( CheckVersion($DBversion) ) {
Link Here
|
| 10580 |
ADD KEY budget_owner_id (budget_owner_id) |
10580 |
ADD KEY budget_owner_id (budget_owner_id) |
| 10581 |
|); |
10581 |
|); |
| 10582 |
$dbh->do(q| |
10582 |
$dbh->do(q| |
| 10583 |
ALTER IGNORE TABLE aqbudgets_planning |
10583 |
ALTER TABLE aqbudgets_planning |
| 10584 |
ADD KEY budget_period_id (budget_period_id) |
10584 |
ADD KEY budget_period_id (budget_period_id) |
| 10585 |
|); |
10585 |
|); |
| 10586 |
$dbh->do(q| |
10586 |
$dbh->do(q| |
| 10587 |
ALTER IGNORE TABLE aqorders |
10587 |
ALTER TABLE aqorders |
| 10588 |
ADD KEY parent_ordernumber (parent_ordernumber), |
10588 |
ADD KEY parent_ordernumber (parent_ordernumber), |
| 10589 |
ADD KEY orderstatus (orderstatus) |
10589 |
ADD KEY orderstatus (orderstatus) |
| 10590 |
|); |
10590 |
|); |
|
Lines 10821-10827
if ( CheckVersion($DBversion) ) {
Link Here
|
| 10821 |
$dbh->{PrintError} = $print_error; |
10821 |
$dbh->{PrintError} = $print_error; |
| 10822 |
|
10822 |
|
| 10823 |
$dbh->do(q{ |
10823 |
$dbh->do(q{ |
| 10824 |
ALTER IGNORE TABLE course_reserves |
10824 |
ALTER TABLE course_reserves |
| 10825 |
ADD CONSTRAINT course_reserves_ibfk_2 |
10825 |
ADD CONSTRAINT course_reserves_ibfk_2 |
| 10826 |
FOREIGN KEY (ci_id) REFERENCES course_items (ci_id) |
10826 |
FOREIGN KEY (ci_id) REFERENCES course_items (ci_id) |
| 10827 |
ON DELETE CASCADE ON UPDATE CASCADE |
10827 |
ON DELETE CASCADE ON UPDATE CASCADE |
|
Lines 10934-10940
if ( CheckVersion($DBversion) ) {
Link Here
|
| 10934 |
$DBversion = "3.21.00.029"; |
10934 |
$DBversion = "3.21.00.029"; |
| 10935 |
if ( CheckVersion($DBversion) ) { |
10935 |
if ( CheckVersion($DBversion) ) { |
| 10936 |
$dbh->do(q{ |
10936 |
$dbh->do(q{ |
| 10937 |
ALTER IGNORE TABLE discharges |
10937 |
ALTER TABLE discharges |
| 10938 |
ADD COLUMN discharge_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST |
10938 |
ADD COLUMN discharge_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST |
| 10939 |
}); |
10939 |
}); |
| 10940 |
print "Upgrade to $DBversion done (Bug 14368: Add discharges history)\n"; |
10940 |
print "Upgrade to $DBversion done (Bug 14368: Add discharges history)\n"; |
| 10941 |
- |
|
|