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

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

Return to bug 17234