Bugzilla – Attachment 98658 Details for
Bug 20882
URI column in the items table is limited to 255 characters
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 20882: Move items.uri to mediumtext
Bug-20882-Move-itemsuri-to-mediumtext.patch (text/plain), 3.05 KB, created by
Marcel de Rooy
on 2020-02-10 14:31:49 UTC
(
hide
)
Description:
Bug 20882: Move items.uri to mediumtext
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2020-02-10 14:31:49 UTC
Size:
3.05 KB
patch
obsolete
>From 9111372e08b5a4dafe9d373d20ec7d97b391f7d1 Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Date: Mon, 10 Feb 2020 14:28:51 +0000 >Subject: [PATCH] Bug 20882: Move items.uri to mediumtext >Content-Type: text/plain; charset=utf-8 > >Applies to items and deleteditems. > >Test plan: >Run new install or upgrade. Check field size. > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > 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 > >diff --git a/installer/data/mysql/atomicupdate/bug20882.perl b/installer/data/mysql/atomicupdate/bug20882.perl >new file mode 100644 >index 0000000000..5cbe8520db >--- /dev/null >+++ b/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"; >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index a82a20830b..b41cd909b5 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/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) >-- >2.11.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 20882
:
98658
|
98661
|
98995