X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;fp=DataObjects%2Fcore.sql;h=19cda271cdb66659e53c216114211d8c2153e467;hp=5d22232aed907cdc9ab4cb22f526ec8583665cb6;hb=10d3ea4d2b205da9a8bee411103cbfbc04316708;hpb=a1b31bf06c4248c56433c39f04e2ffd61835173b 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;