Fix naming convention.

[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 fcbbf58..75cdebd 100644 (file)
--- a/upgrade/account/20_naming_convention.sql
+++ b/upgrade/account/20_naming_convention.sql
@@ -16,8 +16,16 @@ 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
+# profile
   ALTER TABLE  profile_photos
 CHANGE COLUMN  uid pid INT(6) 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;
 
 # vim:set ft=mysql: