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

(-)a/installer/data/mysql/db_revs/230600007.pl (-19 / +9 lines)
Lines 21-33 return { Link Here
21
        );
21
        );
22
        say $out "Updated deletedbiblioitems.place to text";
22
        say $out "Updated deletedbiblioitems.place to text";
23
23
24
        $dbh->do(
24
        if ( index_exists( 'biblioitems', 'publishercode' ) ) {
25
            q{
25
            $dbh->do(q{ALTER TABLE `biblioitems` DROP INDEX `publishercode`});
26
            ALTER TABLE `biblioitems`
26
            say $out "Remove index on biblioitems.publishercode";
27
            DROP INDEX `publishercode`
28
        }
27
        }
29
        );
30
        say $out "Remove index on biblioitems.publishercode";
31
        $dbh->do(
28
        $dbh->do(
32
            q{
29
            q{
33
            ALTER TABLE `biblioitems`
30
            ALTER TABLE `biblioitems`
Lines 35-54 return { Link Here
35
        }
32
        }
36
        );
33
        );
37
        say $out "Updated biblioitems.publishercode to text";
34
        say $out "Updated biblioitems.publishercode to text";
38
        $dbh->do(
35
39
            q{
36
        $dbh->do(q{ALTER TABLE `biblioitems` ADD INDEX `publishercode` (`publishercode`(191))});
40
            ALTER TABLE `biblioitems`
41
            ADD INDEX `publishercode` (`publishercode`(191))
42
        }
43
        );
44
        say $out "Create index on biblioitems.publishercode";
37
        say $out "Create index on biblioitems.publishercode";
45
        $dbh->do(
38
46
            q{
39
        if ( index_exists( 'deletedbiblioitems', 'publishercode' ) ) {
47
            ALTER TABLE `deletedbiblioitems`
40
            $dbh->do(q{ALTER TABLE `deletedbiblioitems` DROP INDEX `publishercode`});
48
            DROP INDEX `publishercode`
41
            say $out "Remove index on deletedbiblioitems.publishercode";
49
        }
42
        }
50
        );
51
        say $out "Remove index on deletedbiblioitems.publishercode";
52
        $dbh->do(
43
        $dbh->do(
53
            q{
44
            q{
54
            ALTER TABLE `deletedbiblioitems`
45
            ALTER TABLE `deletedbiblioitems`
55
- 

Return to bug 36978