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