X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Faccount%2F20_naming_convention.sql;h=35a98dc753073d6473517665988951bae164c24a;hb=e12ab28529594b7814568ca282974b620cde3eb1;hp=fcbbf58a649c7e1caf99e33c559f8257b220470d;hpb=100e66fc8ab2b48621b287d50079558d83187278;p=platal.git

diff --git a/upgrade/account/20_naming_convention.sql b/upgrade/account/20_naming_convention.sql
index fcbbf58..35a98dc 100644
--- a/upgrade/account/20_naming_convention.sql
+++ b/upgrade/account/20_naming_convention.sql
@@ -16,8 +16,66 @@ CHANGE COLUMN  montant_max amount_max DECIMAL(10,2) NOT NULL DEFAULT 0.00;
 CHANGE COLUMN  montant amount VARCHAR(15) NOT NULL DEFAULT '0.00',
 CHANGE COLUMN  cle pkey VARCHAR(5) NOT NULL;
 
-# photo
+# emails
+  ALTER TABLE  aliases
+CHANGE COLUMN  id uid INT(11) not null;
+  ALTER TABLE  newsletter_ins
+CHANGE COLUMN  user_id uid INT(11) not null;
+  ALTER TABLE  axletter_ins
+CHANGE COLUMN  user_id uid INT(11) not null;
+  ALTER TABLE  axletter_rights
+CHANGE COLUMN  user_id uid INT(11) not null;
+  ALTER TABLE  homonyms
+CHANGE COLUMN  user_id uid INT(11) not null;
+
+# announces
+  ALTER TABLE  announces
+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(6) not null;
+CHANGE COLUMN  uid pid INT(11) not null;
+  ALTER TABLE  profile_skills
+CHANGE COLUMN  uid pid INT(11) not null;
+  ALTER TABLE  profile_langskills
+CHANGE COLUMN  uid pid INT(11) not null;
+  ALTER TABLE  profile_binets
+CHANGE COLUMN  user_id pid INT(11) not null;
+  ALTER TABLE  profile_medals
+CHANGE COLUMN  uid pid INT(11) not null;
+
+# account
+  ALTER TABLE  account_auth_openid
+CHANGE COLUMN  user_id uid INT(11) not null;
+
+# request
+  ALTER TABLE  requests
+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: