Merge remote branch 'origin/platal-1.0.0'

[platal.git] / upgrade / account / 20_naming_convention.sql

diff --git a/upgrade/account/20_naming_convention.sql b/upgrade/account/20_naming_convention.sql
index d3bcd7b..35a98dc 100644 (file)
--- a/upgrade/account/20_naming_convention.sql
+++ b/upgrade/account/20_naming_convention.sql
@@ -30,10 +30,17 @@ CHANGE COLUMN  user_id uid INT(11) not null;
 
 # announces
   ALTER TABLE  announces
-CHANGE COLUMN  user_id uid INT(11) not null;
+CHANGE COLUMN  user_id uid INT(11) not null,
+CHANGE COLUMN  peremption expiration DATE NOT NULL;
+
   ALTER TABLE  announce_read
 CHANGE COLUMN  user_id uid INT(11) not null;
 
+  ALTER TABLE  reminder_tips
+CHANGE COLUMN  peremption expiration DATE NOT NULL,
+CHANGE COLUMN  titre title VARCHAR(64) NOT NULL,
+CHANGE COLUMN  priorite priority TINYINT(2) UNSIGNED NOT NULL DEFAULT 127;
+
 # profile
   ALTER TABLE  profile_photos
 CHANGE COLUMN  uid pid INT(11) not null;
@@ -66,7 +73,8 @@ CHANGE COLUMN  uid pid INT(11) NOT NULL;
 
 # group
   ALTER TABLE  group_announces
-CHANGE COLUMN  user_id uid INT(11) NOT NULL;
+CHANGE COLUMN  user_id uid INT(11) NOT NULL,
+CHANGE COLUMN  peremption expiration DATE NOT NULL;
   ALTER TABLE  group_announces_read
 CHANGE COLUMN  user_id uid INT(11) NOT NULL;