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

(-)a/installer/data/mysql/atomicupdate/Bug15108-OAI-PMH_provider_improvements.perl (-8 / +14 lines)
Lines 1-11 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do("ALTER TABLE biblioitems ADD KEY `timestamp` (`timestamp`);");
3
    if ( !index_exists( 'biblioitems', 'timestamp' ) ) {
4
    $dbh->do("ALTER TABLE deletedbiblioitems ADD KEY `timestamp` (`timestamp`);");
4
        $dbh->do("ALTER TABLE biblioitems ADD KEY `timestamp` (`timestamp`);");
5
    $dbh->do("ALTER TABLE items ADD KEY `timestamp` (`timestamp`);");
5
    }
6
    $dbh->do("ALTER TABLE deleteditems ADD KEY `timestamp` (`timestamp`);");
6
    if ( !index_exists( 'deletedbiblioitems', 'timestamp' ) ) {
7
        $dbh->do("ALTER TABLE deletedbiblioitems ADD KEY `timestamp` (`timestamp`);");
8
    }
9
    if ( !index_exists( 'items', 'timestamp' ) ) {
10
        $dbh->do("ALTER TABLE items ADD KEY `timestamp` (`timestamp`);");
11
    }
12
    if ( !index_exists( 'deleteditems', 'timestamp' ) ) {
13
        $dbh->do("ALTER TABLE deleteditems ADD KEY `timestamp` (`timestamp`);");
14
    }
7
15
8
    # Always end with this (adjust the bug info)
9
    SetVersion( $DBversion );
16
    SetVersion( $DBversion );
10
    print "Upgrade to $DBversion done (Bug 15108 - OAI-PMH provider improvements)\n";
17
    print "Upgrade to $DBversion done (Bug 15108: OAI-PMH provider improvements)\n";
11
}
18
}
12
- 

Return to bug 15108