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