5 description => "Extend datatypes in biblioitems and deletedbiblioitems tables to avoid import errors",
8 my ($dbh, $out) = @$args{qw(dbh out)};
10 ALTER TABLE `biblioitems`
11 MODIFY COLUMN `place` text DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)'
13 say $out "Updated biblioitems.place to text";
15 ALTER TABLE `deletedbiblioitems`
16 MODIFY COLUMN `place` text DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)'
18 say $out "Updated deletedbiblioitems.place to text";
21 ALTER TABLE `biblioitems`
22 MODIFY COLUMN `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)'
24 say $out "Updated biblioitems.publishercode to text";
26 ALTER TABLE `deletedbiblioitems`
27 MODIFY COLUMN `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)'
29 say $out "Updated deletedbiblioitems.publishercode to text";
32 ALTER TABLE `biblioitems`
33 MODIFY COLUMN `size` text DEFAULT NULL COMMENT 'material size (MARC21 300$c)'
35 say $out "Updated biblioitems.size to text";
37 ALTER TABLE `deletedbiblioitems`
38 MODIFY COLUMN `size` text DEFAULT NULL COMMENT 'material size (MARC21 300$c)'
40 say $out "Updated deletedbiblioitems.size to text";
43 ALTER TABLE `biblioitems`
44 MODIFY COLUMN `pages` text DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)'
46 say $out "Updated biblioitems.pages to text";
48 ALTER TABLE `deletedbiblioitems`
49 MODIFY COLUMN `pages` text DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)'
51 say $out "Updated deletedbiblioitems.pages to text";
54 ALTER TABLE `biblioitems`
55 MODIFY COLUMN `illus` text DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)'
57 say $out "Updated biblioitems.illus to text";
59 ALTER TABLE `deletedbiblioitems`
60 MODIFY COLUMN `illus` text DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)'
62 say $out "Updated deletedbiblioitems.illus to text";