From: Chris <chris@roojs.com>
Date: Fri, 10 Jan 2014 08:57:27 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=10d3ea4d2b205da9a8bee411103cbfbc04316708

DataObjects/core.sql
---

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 5d22232a..19cda271 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -43,11 +43,11 @@ ALTER TABLE Companies ALTER url SET DEFAULT '';
 ALTER TABLE Companies ADD COLUMN    address1 text ;
 ALTER TABLE Companies ADD COLUMN    address2 text ;
 ALTER TABLE Companies ADD COLUMN    address3 text ;
-
+ALTER TABLE Companies ADD COLUMN is_system INT(2) NOT NULL DEFAULT 0;
 
 
 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;