From: Alan Knowles Date: Sat, 12 Feb 2011 09:53:00 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=c4127515608a209828feb7d5fd00205b7f47efa8 DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 46cea56b..db7100cb 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -170,7 +170,8 @@ CREATE TABLE `Projects` ( PRIMARY KEY (`id`), KEY `plookup` (`code`) ) ; - alter table Projects add column active int(11) default 1; + +alter table Projects add column active int(11) default 1; alter table Projects add index plookup(code); ALTER TABLE Projects ADD COLUMN `type` varchar(1) NOT NULL DEFAULT 'P';