From 64278fd6b3de8c5b072819ba0a82f9c0c391405b Mon Sep 17 00:00:00 2001 From: Paul POULAIN Date: Tue, 30 Oct 2007 13:02:44 -0500 Subject: [PATCH] #1505 Primary Key on borrowernumber Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- installer/kohastructure.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql index 58ed94ffbc..c20495de1c 100644 --- a/installer/kohastructure.sql +++ b/installer/kohastructure.sql @@ -475,7 +475,7 @@ CREATE TABLE `borrowers` ( `sort1` varchar(80) default NULL, `sort2` varchar(80) default NULL, UNIQUE KEY `cardnumber` (`cardnumber`), - KEY `borrowernumber` (`borrowernumber`), + PRIMARY KEY `borrowernumber` (`borrowernumber`), KEY `categorycode` (`categorycode`), KEY `branchcode` (`branchcode`), KEY `userid` (`userid`), -- 2.39.5