X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Faccount%2F20_naming_convention.sql;h=35a98dc753073d6473517665988951bae164c24a;hb=950c9968a3418444928e9ed0aa0b257b8b52634f;hp=5ef1dad385d984f915c55e16c5be14ffff28c9ef;hpb=257ae4081d1b5da12c4458f0642b9d2b7843abee;p=platal.git

diff --git a/upgrade/account/20_naming_convention.sql b/upgrade/account/20_naming_convention.sql
index 5ef1dad..35a98dc 100644
--- 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;
@@ -56,4 +63,19 @@ CHANGE COLUMN  user_id uid INT(11) NOT NULL;
   ALTER TABLE  requests_hidden
 CHANGE COLUMN  user_id uid INT(11) NOT NULL;
 
+# watch
+  ALTER TABLE  watch_profile
+CHANGE COLUMN  uid pid INT(11) NOT NULL;
+
+# search_name
+  ALTER TABLE  search_name
+CHANGE COLUMN  uid pid INT(11) NOT NULL;
+
+# group
+  ALTER TABLE  group_announces
+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;
+
 # vim:set ft=mysql: