From 951e3b3d2966f965b576bc493c084157f63f47ad Mon Sep 17 00:00:00 2001
From: Katrin Fischer <katrin.fischer@bsz-bw.de>
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