From 79fd489c1918c27564e0b73333cbc11abab900e5 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 18 Mar 2008 16:35:55 -0500 Subject: [PATCH] fixed create table statement for patroncards Signed-off-by: Joshua Ferraro --- installer/data/mysql/kohastructure.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 98c6ae1ff1..834bb1f6b2 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1456,7 +1456,7 @@ CREATE TABLE `overduerules` ( -- DROP TABLE IF EXISTS `patroncards`; -Create Table: CREATE TABLE `patroncards` ( +CREATE TABLE `patroncards` ( `cardid` int(11) NOT NULL auto_increment, `batch_id` varchar(10) NOT NULL default '1', `borrowernumber` int(11) NOT NULL, @@ -1464,7 +1464,7 @@ Create Table: CREATE TABLE `patroncards` ( PRIMARY KEY (`cardid`), KEY `patroncards_ibfk_1` (`borrowernumber`), CONSTRAINT `patroncards_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `patronimage` -- 2.39.5