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