View | Details | Raw Unified | Return to bug 20882
Collapse All | Expand All

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

Return to bug 20882