From 816f0dee1dbedc26c1104edde7594038b587a574 Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Sun, 30 Aug 2009 22:28:29 +0200 Subject: [PATCH] Fixing kohastructure.sql : some fields were duplicated Signed-off-by: Henri-Damien LAURENT --- installer/data/mysql/kohastructure.sql | 2 -- 1 file changed, 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 5d88d05e78..c4c1bbaee6 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -421,7 +421,6 @@ CREATE TABLE `biblioitems` ( KEY `isbn` (`isbn`), KEY `issn` (`issn`), KEY `publishercode` (`publishercode`), - KEY `issn` (`issn`), CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -837,7 +836,6 @@ CREATE TABLE `deletedborrowers` ( `phonepro` text, `B_streetnumber` varchar(10) default NULL, `B_streettype` varchar(50) default NULL, - `smsalertnumber` varchar(50) default NULL, `B_address` varchar(100) default NULL, `B_city` mediumtext, `B_zipcode` varchar(25) default NULL, -- 2.39.5