projects
/
Pman.Core
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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 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
# old mysql
@@
-412,7
+414,7
@@
CREATE TABLE core_notify_recur (
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
-)
;
+);
ALTER TABLE core_notify_recur ADD COLUMN person_id int(11) NOT NULL;
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 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);
ALTER TABLE core_notify_recur ADD INDEX lookup(person_id, dtstart, dtend, tz, max_applied_dt, updated_dt, last_applied_dt);