From 2bbd36049ff0b374659ab294cbc08bcda755c0d4 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@akkbhome.com>
Date: Sun, 13 Feb 2011 23:24:25 +0800
Subject: [PATCH] DataObjects/core.sql

---
 DataObjects/core.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 8c5d0077..56022673 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -169,9 +169,10 @@ CREATE TABLE `Projects` (
   `file_location` varchar(254)    NOT NULL default '',
   `open_date` date default NULL,
   `open_by` int(11) NOT NULL default '0',
-  PRIMARY KEY  (`id`),
-  KEY `plookup` (`code`)
+  PRIMARY KEY  (`id`)
+  
 ) ;
+ALTER TABLE `Projects` ADD INDEX `plookup` (`code`);
 
 alter table Projects add column active int(11) default 1;
 alter table Projects add index plookup(code);
-- 
2.39.2