DataObjects/core.sql

[Pman.Core] / DataObjects / core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 5a266f5..27ba635 100644 (file)
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -193,6 +193,11 @@ 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 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 ;
+
 
 
 # old mysql
@@ -412,7 +417,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;