X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Faccount%2F20_naming_convention.sql;h=3dfadf4f2f5c255a3f078131c60dde29f5de0464;hb=fe13bc1d7ba9f72d452ec07baf8538a74b7c67b8;hp=75cdebd4e874ed0d6172039fc95eea40d998fecb;hpb=1d49ff4ae684f13250408798f4b0a945797a5229;p=platal.git

diff --git a/upgrade/account/20_naming_convention.sql b/upgrade/account/20_naming_convention.sql
index 75cdebd..3dfadf4 100644
--- a/upgrade/account/20_naming_convention.sql
+++ b/upgrade/account/20_naming_convention.sql
@@ -16,9 +16,13 @@ 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;
 
+# emails
+  ALTER TABLE  aliases
+CHANGE COLUMN  id uid INT(11) not null;
+
 # 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