DATABASE UPDATE: change copynumber column to allow free text - [ bug 2223 ] - WARNING...

[koha_gimpoz] / installer / data / mysql / kohastructure.sql

diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 4785667..c48d3ec 100644 (file)
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -917,7 +917,7 @@ CREATE TABLE `deleteditems` (
   `itype` varchar(10) default NULL,
   `more_subfields_xml` longtext default NULL,
   `enumchron` varchar(80) default NULL,
-  `copynumber` smallint(6) default NULL,
+  `copynumber` varchar(32) default NULL,
   `marc` longblob,
   PRIMARY KEY  (`itemnumber`),
   KEY `delitembarcodeidx` (`barcode`),
@@ -1135,7 +1135,7 @@ CREATE TABLE `items` (
   `itype` varchar(10) default NULL,
   `more_subfields_xml` longtext default NULL,
   `enumchron` varchar(80) default NULL,
-  `copynumber` smallint(6) default NULL,
+  `copynumber` varchar(32) default NULL,
   PRIMARY KEY  (`itemnumber`),
   UNIQUE KEY `itembarcodeidx` (`barcode`),
   KEY `itembinoidx` (`biblioitemnumber`),