@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug20882.perl | 8 ++++++++ installer/data/mysql/kohastructure.sql | 4 ++-- 2 files changed, 10 insertions(+), 2 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug20882.perl --- a/installer/data/mysql/atomicupdate/bug20882.perl +++ a/installer/data/mysql/atomicupdate/bug20882.perl @@ -0,0 +1,8 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do( "ALTER TABLE items MODIFY COLUMN uri MEDIUMTEXT" ); + $dbh->do( "ALTER TABLE deleteditems MODIFY COLUMN uri MEDIUMTEXT" ); + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 20882 - items.uri to MEDIUMTEXT)\n"; +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -639,7 +639,7 @@ CREATE TABLE `deleteditems` ( `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) `materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3) - `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) + `uri` MEDIUMTEXT default NULL, -- URL for the item (MARC21 952$u) `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) `more_subfields_xml` LONGTEXT default NULL, -- additional 952 subfields in XML format `enumchron` MEDIUMTEXT default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) @@ -844,7 +844,7 @@ CREATE TABLE `items` ( -- holdings/item information `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) `materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3) - `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) + `uri` MEDIUMTEXT default NULL, -- URL for the item (MARC21 952$u) `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) `more_subfields_xml` LONGTEXT default NULL, -- additional 952 subfields in XML format `enumchron` MEDIUMTEXT default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) --