From: Chris Date: Fri, 10 Jan 2014 08:57:40 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=ef3663b5002d2c3e64e1ef1f655fe60c17aeb8ce DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 19cda271..09bddea2 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -43,7 +43,7 @@ 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 COLUMN is_system INT(2) NOT NULL DEFAULT 0;-- #2028 ALTER TABLE Companies ADD INDEX name_lookup (name);