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 |
- |
|
|