X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=upgrade%2Faccount%2F20_naming_convention.sql;h=35a98dc753073d6473517665988951bae164c24a;hb=c76545c351fae4e2298624ff9ee5bf854dc5a5b6;hp=b2458773eaaac9e48bffbb1a95625c4ea0ecdde8;hpb=340d765f4204f5dea3fe3cb1604853a896654e6f;p=platal.git

diff --git a/upgrade/account/20_naming_convention.sql b/upgrade/account/20_naming_convention.sql
index b245877..35a98dc 100644
--- a/upgrade/account/20_naming_convention.sql
+++ b/upgrade/account/20_naming_convention.sql
@@ -30,12 +30,16 @@ 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  tips
-CHANGE COLUMN  peremption expiration DATE 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
@@ -69,7 +73,7 @@ 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;