From 40d3168697db4107aca35d617e704a0e032c4218 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 17 Dec 2012 12:24:02 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 5 +++++ 1 file changed, 5 insertions(+) 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); -- 2.39.2