From: Alan Knowles Date: Mon, 17 Dec 2012 04:24:02 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=40d3168697db4107aca35d617e704a0e032c4218 DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 27ba6357..e9cbbef7 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -36,6 +36,11 @@ ALTER TABLE Companies ALTER isOwner TYPE int(11); ALTER TABLE Companies ALTER owner_id SET DEFAULT 0; 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 INDEX name_lookup (name);