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