From 1574e45d019dee00f9adbd1bc7abd86d343d1e5d Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Wed, 19 Nov 2008 14:58:26 +0100 Subject: [PATCH] bug fix 2765 Changing isbn data from 14 to 30 in order to manage friendlier, isbn with - inside, and multiple isbns. Signed-off-by: Galen Charlton --- installer/data/mysql/kohastructure.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index ec0f45d0b0..a75cb090f3 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, @@ -801,7 +801,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, @@ -1066,7 +1066,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`) @@ -1951,7 +1951,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, -- 2.39.2