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;
+ ALTER TABLE announce_read
+CHANGE COLUMN user_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
+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;
# vim:set ft=mysql: