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