From: Alan Knowles Date: Sat, 12 Feb 2011 09:52:47 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=c1cdbb8c54a0ef88b7e0ba002c4fff699bf49fcc DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index d758df2a..46cea56b 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -167,7 +167,7 @@ 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 USING BTREE (`id`), + PRIMARY KEY (`id`), KEY `plookup` (`code`) ) ; alter table Projects add column active int(11) default 1;