# 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
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: