From: Chris <chris@roojs.com>
Date: Tue, 11 Dec 2012 11:43:28 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=a494a3ac8bb3ea4d6929493b01657972d722e56e

DataObjects/core.sql
---

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 707a5072..5a54b8dd 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -193,6 +193,8 @@ 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` ;
+
 
 
 # old mysql