From: Alan Knowles Date: Fri, 15 Nov 2013 07:04:19 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=0f58815a147d5675bc75ba066bbcfbd4f3e060c6 DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 2b5fd6bd..43e8f1fb 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -29,8 +29,8 @@ ALTER TABLE Companies ADD COLUMN country varchar(4) NOT NULL DEFAULT ''; ALTER TABLE Companies ADD COLUMN comptype varchar(32) NOT NULL DEFAULT ''; --- not sure if this needs to change.. ---ALTER TABLE Companies ADD COLUMN comptype_id INT(11) DEFAULT 0; +-- not sure if this needs to change.. << there is code in core/update that fills this in?? +ALTER TABLE Companies ADD COLUMN comptype_id INT(11) DEFAULT 0; ALTER TABLE Companies CHANGE COLUMN isOwner isOwner int(11);