Merge commit 'origin/master' into hruid
[platal.git] / upgrade / 0.9.17 / 01_smallint_to_int.sql
CommitLineData
7fe2cd86
VZ
1ALTER TABLE adresses MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
2ALTER TABLE aliases MODIFY COLUMN id INT NOT NULL DEFAULT 0;
3ALTER TABLE applis_ins MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
4ALTER TABLE auth_user_md5 MODIFY COLUMN user_id INT NOT NULL AUTO_INCREMENT;
5ALTER TABLE auth_user_quick MODIFY COLUMN user_id INT NOT NULL DEFAULT 0;
6ALTER TABLE axletter_ins MODIFY COLUMN user_id INT NOT NULL DEFAULT 0;
7ALTER TABLE axletter_rights MODIFY COLUMN user_id INT NOT NULL DEFAULT 0;
8ALTER TABLE binets_ins MODIFY COLUMN user_id INT NOT NULL DEFAULT 0;
9ALTER TABLE competences_ins MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
10ALTER TABLE contacts MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
11ALTER TABLE email_send_save MODIFY COLUMN uid INT NOT NULL;
12ALTER TABLE emails_watch MODIFY COLUMN uid INT DEFAULT NULL;
13ALTER TABLE entreprises MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
14ALTER TABLE evenements MODIFY COLUMN user_id INT NOT NULL DEFAULT 0;
15ALTER TABLE evenements_vus MODIFY COLUMN user_id INT NOT NULL DEFAULT 0;
16ALTER TABLE gapps_accounts MODIFY COLUMN l_userid INT DEFAULT NULL;
17ALTER TABLE gapps_queue MODIFY COLUMN q_owner_id INT DEFAULT NULL;
18ALTER TABLE gapps_queue MODIFY COLUMN q_recipient_id INT DEFAULT NULL;
19ALTER TABLE groupesx_ins MODIFY COLUMN guid INT NOT NULL DEFAULT 0;
20ALTER TABLE homonymes MODIFY COLUMN user_id INT NOT NULL DEFAULT 0;
21ALTER TABLE ip_watch MODIFY COLUMN uid INT DEFAULT NULL;
22ALTER TABLE langues_ins MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
23ALTER TABLE mentor MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
24ALTER TABLE mentor_pays MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
25ALTER TABLE mentor_secteurs MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
26ALTER TABLE ml_moderate MODIFY COLUMN mid INT NOT NULL;
27ALTER TABLE ml_moderate MODIFY COLUMN uid INT NOT NULL;
28ALTER TABLE newsletter_ins MODIFY COLUMN user_id INT NOT NULL DEFAULT 0;
29ALTER TABLE perte_pass MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
30ALTER TABLE photo MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
31ALTER TABLE profile_medals_sub MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
32ALTER TABLE register_subs MODIFY COLUMN uid INT NOT NULL;
33ALTER TABLE survey_surveys MODIFY COLUMN author_id INT NOT NULL;
34ALTER TABLE survey_votes MODIFY COLUMN user_id INT NOT NULL;
35ALTER TABLE tels MODIFY COLUMN uid INT NOT NULL DEFAULT 0;
36ALTER TABLE user_changes MODIFY COLUMN user_id INT NOT NULL DEFAULT 0;
37ALTER TABLE watch_profile MODIFY COLUMN uid INT NOT NULL;
38
514f0c2e 39# vim:set syntax=mysql: