From: Chris Date: Fri, 10 Jan 2014 08:57:21 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=a1b31bf06c4248c56433c39f04e2ffd61835173b DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 9f9750e1..5d22232a 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -47,7 +47,7 @@ ALTER TABLE Companies ADD COLUMN address3 text ; ALTER TABLE Companies ADD INDEX name_lookup (name); - +ALTER TABLE Companies ADD COLUMN is_system INT(2) NOT NULL DEFAULT 0; -- our new code should have this fixed now.. -- UPDATE Companies set comptype='OWNER' where isOwner=1;