From b54363c13ab0bbb4403c92191f7b33e8fabfcf1c Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Mon, 17 Nov 2008 10:56:49 +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: Henri-Damien LAURENT --- 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 a7a710aabe..2363c9dd6f 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, -- 2.39.5