From: Chris Date: Tue, 11 Dec 2012 11:44:20 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=c720a4e7bb0c413b2970463945b976d08f558cae DataObjects/core.sql --- 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 ;