From c720a4e7bb0c413b2970463945b976d08f558cae Mon Sep 17 00:00:00 2001 From: Chris Date: Tue, 11 Dec 2012 19:44:20 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 5a54b8dd..e0a9248d 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -193,7 +193,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 ; -- 2.39.2