X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=e9cbbef7639db6a3ab59844bd74abddeb6f56490;hb=40d3168697db4107aca35d617e704a0e032c4218;hp=5a54b8dd09f9760ffc8113f9fd9c5a145ae41849;hpb=a494a3ac8bb3ea4d6929493b01657972d722e56e;p=Pman.Core

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 5a54b8dd..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);
 
@@ -193,7 +198,10 @@ ALTER TABLE Person ADD COLUMN   deleted_dt DATETIME ;
 ALTER TABLE Person ADD COLUMN   firstname varchar(128) NOT NULL DEFAULT '';
 ALTER TABLE Person ADD COLUMN   lastname varchar(128) NOT NULL DEFAULT '';
 
-ALTER TABLE `clipping_dev`.`Person` ADD COLUMN `name_facebook` VARCHAR(128) NULL  AFTER `crm_type_id` , ADD COLUMN `url_blog` VARCHAR(256) NULL  AFTER `name_facebook` , ADD COLUMN `url_twitter` VARCHAR(256) NULL  AFTER `url_blog` , ADD COLUMN `url_linkedin` VARCHAR(256) NULL  AFTER `url_twitter` ;
+ALTER TABLE Person ADD COLUMN name_facebook VARCHAR(128) NULL;
+ALTER TABLE Person ADD COLUMN url_blog VARCHAR(256) NULL ;
+ALTER TABLE Person ADD COLUMN url_twitter VARCHAR(256) NULL ;
+ALTER TABLE Person ADD COLUMN url_linkedin VARCHAR(256) NULL ;