View | Details | Raw Unified | Return to bug 17234
Collapse All | Expand All

(-)a/installer/data/mysql/updatedatabase.pl (-12 / +11 lines)
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
- 

Return to bug 17234