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 |
- |
|
|