Changing isbn data from 14 to 30 in order to manage friendlier, isbn with - inside, and multiple isbns. --- installer/data/mysql/kohastructure.sql | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index a7a710a..2363c9d 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -388,7 +388,7 @@ CREATE TABLE `biblioitems` ( `volume` mediumtext, `number` mediumtext, `itemtype` varchar(10) default NULL, - `isbn` varchar(14) default NULL, + `isbn` varchar(30) default NULL, `issn` varchar(9) default NULL, `publicationyear` text, `publishercode` varchar(255) default NULL, @@ -774,7 +774,7 @@ CREATE TABLE `deletedbiblioitems` ( `volume` mediumtext, `number` mediumtext, `itemtype` varchar(10) default NULL, - `isbn` varchar(14) default NULL, + `isbn` varchar(30) default NULL, `issn` varchar(9) default NULL, `publicationyear` text, `publishercode` varchar(255) default NULL, @@ -1015,7 +1015,7 @@ CREATE TABLE `import_biblios` ( `original_source` varchar(25) default NULL, `title` varchar(128) default NULL, `author` varchar(80) default NULL, - `isbn` varchar(14) default NULL, + `isbn` varchar(30) default NULL, `issn` varchar(9) default NULL, `has_items` tinyint(1) NOT NULL default 0, CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`) @@ -1898,7 +1898,7 @@ CREATE TABLE `suggestions` ( `volumedesc` varchar(255) default NULL, `publicationyear` smallint(6) default 0, `place` varchar(255) default NULL, - `isbn` varchar(10) default NULL, + `isbn` varchar(30) default NULL, `mailoverseeing` smallint(1) default 0, `biblionumber` int(11) default NULL, `reason` text, -- 1.6.0.2
_______________________________________________ Koha-patches mailing list Koha-patches@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-patches