Author: benj
Date: Tue May 10 11:46:51 2016
New Revision: 1678
URL: http://svn.gna.org/viewcvs/gdtc?rev=1678&view=rev
Log:
Update schema
Modified:
trunk/gdtc/sql/create-schema.sql
Modified: trunk/gdtc/sql/create-schema.sql
URL:
http://svn.gna.org/viewcvs/gdtc/trunk/gdtc/sql/create-schema.sql?rev=1678&r1=1677&r2=1678&view=diff
==============================================================================
--- trunk/gdtc/sql/create-schema.sql (original)
+++ trunk/gdtc/sql/create-schema.sql Tue May 10 11:46:51 2016
@@ -99,7 +99,9 @@
hackergotchi_file VARCHAR(200),
html_hackergotchi_size VARCHAR(200),
- last_update DATE,
+ mailing_level INT,
+
+ last_update TIMESTAMP,
CONSTRAINT person_primary_key
PRIMARY KEY (actor_id),
@@ -179,9 +181,11 @@
motivations TEXT,
+ mailing_level INT,
+
admin_info TEXT,
- last_update DATE,
+ last_update TIMESTAMP,
CONSTRAINT entity_primary_key
PRIMARY KEY (actor_id),
@@ -308,6 +312,8 @@
'virement',
'mandat',
'cbweb',
+ 'cbweb_recur',
+ 'cbweb_recur_expire',
'dispense',
'prelevement',
'prelevement_expire',
@@ -358,6 +364,7 @@
old_value VARCHAR(256),
new_value VARCHAR(256),
date_modification TIMESTAMP,
+ comment VARCHAR(256),
user VARCHAR(256),
_______________________________________________
Gdtc-commits mailing list
[email protected]
https://mail.gna.org/listinfo/gdtc-commits
