From 951e3b3d2966f965b576bc493c084157f63f47ad Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Fri, 23 Jun 2023 16:07:10 +0000 Subject: [PATCH] Bug 34029: (QA follow-up) Change from longtext to text Can be squashed if needed. --- .../atomicupdate/bug_34029_biblioitems.pl | 40 +++++++++---------- installer/data/mysql/kohastructure.sql | 20 +++++----- 2 files changed, 30 insertions(+), 30 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_34029_biblioitems.pl b/installer/data/mysql/atomicupdate/bug_34029_biblioitems.pl index 701b7170c2..e2d7d926ef 100755 --- a/installer/data/mysql/atomicupdate/bug_34029_biblioitems.pl +++ b/installer/data/mysql/atomicupdate/bug_34029_biblioitems.pl @@ -8,58 +8,58 @@ return { my ($dbh, $out) = @$args{qw(dbh out)}; $dbh->do(q{ ALTER TABLE `biblioitems` - MODIFY COLUMN `place` longtext DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)' + MODIFY COLUMN `place` text DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)' }); - say $out "Updated biblioitems.place to longtext"; + say $out "Updated biblioitems.place to text"; $dbh->do(q{ ALTER TABLE `deletedbiblioitems` - MODIFY COLUMN `place` longtext DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)' + MODIFY COLUMN `place` text DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)' }); - say $out "Updated deletedbiblioitems.place to longtext"; + say $out "Updated deletedbiblioitems.place to text"; $dbh->do(q{ ALTER TABLE `biblioitems` - MODIFY COLUMN `publishercode` longtext DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)' + MODIFY COLUMN `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)' }); - say $out "Updated biblioitems.publishercode to longtext"; + say $out "Updated biblioitems.publishercode to text"; $dbh->do(q{ ALTER TABLE `deletedbiblioitems` - MODIFY COLUMN `publishercode` longtext DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)' + MODIFY COLUMN `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)' }); - say $out "Updated deletedbiblioitems.publishercode to longtext"; + say $out "Updated deletedbiblioitems.publishercode to text"; $dbh->do(q{ ALTER TABLE `biblioitems` - MODIFY COLUMN `size` longtext DEFAULT NULL COMMENT 'material size (MARC21 300$c)' + MODIFY COLUMN `size` text DEFAULT NULL COMMENT 'material size (MARC21 300$c)' }); - say $out "Updated biblioitems.size to longtext"; + say $out "Updated biblioitems.size to text"; $dbh->do(q{ ALTER TABLE `deletedbiblioitems` - MODIFY COLUMN `size` longtext DEFAULT NULL COMMENT 'material size (MARC21 300$c)' + MODIFY COLUMN `size` text DEFAULT NULL COMMENT 'material size (MARC21 300$c)' }); - say $out "Updated deletedbiblioitems.size to longtext"; + say $out "Updated deletedbiblioitems.size to text"; $dbh->do(q{ ALTER TABLE `biblioitems` - MODIFY COLUMN `pages` longtext DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)' + MODIFY COLUMN `pages` text DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)' }); - say $out "Updated biblioitems.pages to longtext"; + say $out "Updated biblioitems.pages to text"; $dbh->do(q{ ALTER TABLE `deletedbiblioitems` - MODIFY COLUMN `pages` longtext DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)' + MODIFY COLUMN `pages` text DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)' }); - say $out "Updated deletedbiblioitems.pages to longtext"; + say $out "Updated deletedbiblioitems.pages to text"; $dbh->do(q{ ALTER TABLE `biblioitems` - MODIFY COLUMN `illus` longtext DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)' + MODIFY COLUMN `illus` text DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)' }); - say $out "Updated biblioitems.illus to longtext"; + say $out "Updated biblioitems.illus to text"; $dbh->do(q{ ALTER TABLE `deletedbiblioitems` - MODIFY COLUMN `illus` longtext DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)' + MODIFY COLUMN `illus` text DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)' }); - say $out "Updated deletedbiblioitems.illus to longtext"; + say $out "Updated deletedbiblioitems.illus to text"; }, }; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index a5182e15c5..2807fcda36 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1123,7 +1123,7 @@ CREATE TABLE `biblioitems` ( `issn` longtext DEFAULT NULL COMMENT 'ISSN (MARC21 022$a)', `ean` longtext DEFAULT NULL, `publicationyear` mediumtext DEFAULT NULL, - `publishercode` longtext DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 246$b)', + `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 246$b)', `volumedate` date DEFAULT NULL, `volumedesc` mediumtext DEFAULT NULL COMMENT 'volume information (MARC21 362$a)', `collectiontitle` longtext DEFAULT NULL, @@ -1132,11 +1132,11 @@ CREATE TABLE `biblioitems` ( `editionstatement` mediumtext DEFAULT NULL, `editionresponsibility` mediumtext DEFAULT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), - `illus` longtext DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)', - `pages` longtext DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)', + `illus` text DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)', + `pages` text DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)', `notes` longtext DEFAULT NULL, - `size` longtext DEFAULT NULL COMMENT 'material size (MARC21 300$c)', - `place` longtext DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)', + `size` text DEFAULT NULL COMMENT 'material size (MARC21 300$c)', + `place` text DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)', `lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)', `url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)', `cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)', @@ -2526,7 +2526,7 @@ CREATE TABLE `deletedbiblioitems` ( `issn` longtext DEFAULT NULL COMMENT 'ISSN (MARC21 022$a)', `ean` longtext DEFAULT NULL, `publicationyear` mediumtext DEFAULT NULL, - `publishercode` longtext DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)', + `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)', `volumedate` date DEFAULT NULL, `volumedesc` mediumtext DEFAULT NULL COMMENT 'volume information (MARC21 362$a)', `collectiontitle` longtext DEFAULT NULL, @@ -2535,11 +2535,11 @@ CREATE TABLE `deletedbiblioitems` ( `editionstatement` mediumtext DEFAULT NULL, `editionresponsibility` mediumtext DEFAULT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), - `illus` longtext DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)', - `pages` longtext DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)', + `illus` text DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)', + `pages` text DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)', `notes` longtext DEFAULT NULL, - `size` longtext DEFAULT NULL COMMENT 'material size (MARC21 300$c)', - `place` longtext DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264§a)', + `size` text DEFAULT NULL COMMENT 'material size (MARC21 300$c)', + `place` text DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264§a)', `lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)', `url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)', `cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)', -- 2.30.2