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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 905-911 CREATE TABLE `deleteditems` ( Link Here
905 
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
 905 
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
906 
  `cn_sort` varchar(30) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
 906 
  `cn_sort` varchar(30) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
907 
  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
 907 
  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
908 
  `materials` varchar(10) default NULL, -- materials specified (MARC21 952$3)
 908 
  `materials` text default NULL, -- materials specified (MARC21 952$3)
909 
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
 909 
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
910 
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
 910 
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
911 
  `more_subfields_xml` longtext default NULL, -- additional 952 subfields in XML format
 911 
  `more_subfields_xml` longtext default NULL, -- additional 952 subfields in XML format
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +6 lines)
Lines 7750-7755 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
7750 
    SetVersion($DBversion);
 7750 
    SetVersion($DBversion);
7751 
}
 7751 
}
7752 

          7752
          

        

            

              
              
              7753
              
$DBversion = "3.13.00.XXX";

            

            

              7754
              
if(CheckVersion($DBversion)) {

            

            

              7755
              
    $dbh->do("ALTER TABLE deleteditems MODIFY materials text;");

            

            

              7756
              
    print "Upgrade to $DBversion done (Bug 11275: alter deleteditems.materials from varchar(10) to text)\n";

            

            

              7757
              
    SetVersion($DBversion);

            

            

              7758
              
}

            

        

          7753
          

          7759
          

        

        

          7754
          
=head1 FUNCTIONS

          7760
          
=head1 FUNCTIONS

        

        

          7755
          

          7761
          

        

            

              7756
              
- 

              
              
            






  

  Return to bug 11275