[Koha-patches] [[reconciliation]] Fixing kohastructure.sql : some fields were duplicated
Henri-Damien LAURENT
henridamien.laurent at biblibre.com
Mon Aug 31 12:13:54 CEST 2009
---
installer/data/mysql/kohastructure.sql | 2 --
1 files changed, 0 insertions(+), 2 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 434cfb1..f5b62ed 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -422,7 +422,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;
@@ -864,7 +863,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,
--
1.6.0.4
More information about the Koha-patches
mailing list