DataObjects/core.sql

[Pman.Core] / DataObjects / core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index aa0b3ee..5a54b8d 100644 (file)
--- 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
@@ -412,7 +414,7 @@ CREATE TABLE core_notify_recur (
   id int(11)  NOT NULL AUTO_INCREMENT,
 
   PRIMARY KEY (id)
-) ;
+);
  
 
 ALTER TABLE  core_notify_recur  ADD COLUMN person_id int(11)  NOT NULL;
@@ -432,6 +434,7 @@ ALTER TABLE  core_notify_recur  ADD COLUMN ontable varchar(128)  NOT NULL defaul
 ALTER TABLE  core_notify_recur  ADD COLUMN last_event_id  int(11)  default 0;
 ALTER TABLE  core_notify_recur  ADD COLUMN method varchar(128) default '';     
 
+ALTER TABLE  core_notify_recur  ADD COLUMN method_id  int(11)  default 0;
 
 ALTER TABLE  core_notify_recur  ADD INDEX lookup(person_id, dtstart, dtend, tz, max_applied_dt, updated_dt, last_applied_dt);