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

(-)a/installer/data/mysql/db_revs/230600007.pl (-1 / +20 lines)
Lines 17-32 return { Link Here
17
        });
17
        });
18
        say $out "Updated deletedbiblioitems.place to text";
18
        say $out "Updated deletedbiblioitems.place to text";
19
19
20
        $dbh->do(q{
21
            ALTER TABLE `biblioitems`
22
            DROP INDEX `publishercode`
23
        });
24
        say $out "Remove index on biblioitems.publishercode";
20
        $dbh->do(q{
25
        $dbh->do(q{
21
            ALTER TABLE `biblioitems`
26
            ALTER TABLE `biblioitems`
22
            MODIFY COLUMN `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)'
27
            MODIFY COLUMN `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)'
23
        });
28
        });
24
        say $out "Updated biblioitems.publishercode to text";
29
        say $out "Updated biblioitems.publishercode to text";
30
        $dbh->do(q{
31
            ALTER TABLE `biblioitems`
32
            ADD INDEX `publishercode` (`publishercode`(191))
33
        });
34
        say $out "Create index on biblioitems.publishercode";
35
        $dbh->do(q{
36
            ALTER TABLE `deletedbiblioitems`
37
            DROP INDEX `publishercode`
38
        });
39
        say $out "Remove index on deletedbiblioitems.publishercode";
25
        $dbh->do(q{
40
        $dbh->do(q{
26
            ALTER TABLE `deletedbiblioitems`
41
            ALTER TABLE `deletedbiblioitems`
27
            MODIFY COLUMN `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)'
42
            MODIFY COLUMN `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)'
28
        });
43
        });
29
        say $out "Updated deletedbiblioitems.publishercode to text";
44
        say $out "Updated deletedbiblioitems.publishercode to text";
45
        $dbh->do(q{
46
            ALTER TABLE `deletedbiblioitems`
47
            ADD INDEX `publishercode` (`publishercode`(191))
48
        });
49
        say $out "Create index on deletedbiblioitems.publishercode";
30
50
31
        $dbh->do(q{
51
        $dbh->do(q{
32
            ALTER TABLE `biblioitems`
52
            ALTER TABLE `biblioitems`
33
- 

Return to bug 34516