[Koha-patches] [PATCH] bug fix 2765
Henri-Damien LAURENT
henridamien.laurent at biblibre.com
Wed Nov 19 14:58:26 CET 2008
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
More information about the Koha-patches
mailing list