From: Alan Knowles Date: Thu, 17 Mar 2011 14:34:19 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=5242cb89ba9b9c68fb48e501cde26ddef1020e9e DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 2d326849..55cb2fe9 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -191,6 +191,8 @@ ALTER TABLE `Projects` ADD COLUMN `languages` varchar(128) NOT NULL; ALTER TABLE Projects ADD COLUMN agency_id int(11) NOT NULL DEFAULT 0 ; +#-- we duplicate office_id and company_id here... +#-- not sure if we should keep doing that in the new design... CREATE TABLE `ProjectDirectory` ( `id` int(11) NOT NULL auto_increment,