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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 750-756 CREATE TABLE `deleteditems` ( Link Here
750
  `uri` varchar(255) default NULL,
750
  `uri` varchar(255) default NULL,
751
  `itype` varchar(10) default NULL,
751
  `itype` varchar(10) default NULL,
752
  `more_subfields_xml` longtext default NULL,
752
  `more_subfields_xml` longtext default NULL,
753
  `enumchron` varchar(80) default NULL,
753
  `enumchron` text default NULL,
754
  `copynumber` varchar(32) default NULL,
754
  `copynumber` varchar(32) default NULL,
755
  `stocknumber` varchar(32) default NULL,
755
  `stocknumber` varchar(32) default NULL,
756
  `marc` longblob,
756
  `marc` longblob,
Lines 1015-1021 CREATE TABLE `items` ( Link Here
1015
  `uri` varchar(255) default NULL,
1015
  `uri` varchar(255) default NULL,
1016
  `itype` varchar(10) default NULL,
1016
  `itype` varchar(10) default NULL,
1017
  `more_subfields_xml` longtext default NULL,
1017
  `more_subfields_xml` longtext default NULL,
1018
  `enumchron` varchar(80) default NULL,
1018
  `enumchron` text default NULL,
1019
  `copynumber` varchar(32) default NULL,
1019
  `copynumber` varchar(32) default NULL,
1020
  `stocknumber` varchar(32) default NULL,
1020
  `stocknumber` varchar(32) default NULL,
1021
  PRIMARY KEY  (`itemnumber`),
1021
  PRIMARY KEY  (`itemnumber`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 3944-3949 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
3944
    SetVersion ($DBversion);
3944
    SetVersion ($DBversion);
3945
}
3945
}
3946
3946
3947
$DBversion = "3.03.00.XXX";
3948
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
3949
    $dbh->do("ALTER TABLE items MODIFY enumchron TEXT");
3950
    $dbh->do("ALTER TABLE deleteditems MODIFY enumchron TEXT");
3951
    print "Upgrade to $DBversion done (bug 5642: longer serial enumeration)\n";
3952
    SetVersion ($DBversion);
3953
}
3954
3947
=head1 FUNCTIONS
3955
=head1 FUNCTIONS
3948
3956
3949
=head2 DropAllForeignKeys($table)
3957
=head2 DropAllForeignKeys($table)
3950
- 

Return to bug 5642