From a494a3ac8bb3ea4d6929493b01657972d722e56e Mon Sep 17 00:00:00 2001 From: Chris Date: Tue, 11 Dec 2012 19:43:28 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 2 ++ 1 file changed, 2 insertions(+) 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 -- 2.39.2