Commit | Line | Data |
---|---|---|
7f376ae0 SJ |
1 | -- accounts and profiles are the tables where uid and pid are defined through an auto increment. |
2 | ALTER TABLE accounts MODIFY COLUMN uid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT; | |
3 | ALTER TABLE profiles MODIFY COLUMN pid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT; | |
4 | ||
5 | -- Following tables all refer to accounts.uid. | |
becfe71d SJ |
6 | ALTER TABLE account_auth_openid MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; |
7 | ALTER TABLE account_lost_passwords MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
8 | ALTER TABLE account_profiles MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
9 | ALTER TABLE aliases MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
10 | ALTER TABLE announce_read MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
11 | ALTER TABLE announces MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
12 | ALTER TABLE axletter_ins MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
13 | ALTER TABLE axletter_rights MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
14 | ALTER TABLE carvas MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
15 | ALTER TABLE contacts MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
16 | ALTER TABLE email_list_moderate MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
17 | ALTER TABLE email_options MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
18 | ALTER TABLE email_send_save MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
19 | ALTER TABLE email_watch MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
20 | ALTER TABLE emails MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
21 | ALTER TABLE forum_innd MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
22 | ALTER TABLE forum_profiles MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
23 | ALTER TABLE forum_subs MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
24 | ALTER TABLE group_announces MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
25 | ALTER TABLE group_announces_read MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
26 | ALTER TABLE group_event_participants MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
27 | ALTER TABLE group_member_sub_requests MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
28 | ALTER TABLE group_members MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
29 | ALTER TABLE homonyms MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
30 | ALTER TABLE ip_watch MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
31 | ALTER TABLE log_last_sessions MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
32 | ALTER TABLE log_sessions MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
33 | ALTER TABLE newsletter_ins MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
34 | ALTER TABLE payment_transactions MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
becfe71d SJ |
35 | ALTER TABLE register_marketing MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; |
36 | ALTER TABLE register_mstats MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
37 | ALTER TABLE register_pending MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
38 | ALTER TABLE register_subs MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
39 | ALTER TABLE reminder MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
40 | ALTER TABLE requests MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
41 | ALTER TABLE requests_hidden MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
42 | ALTER TABLE watch MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
43 | ALTER TABLE watch_nonins MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
44 | ALTER TABLE watch_promo MODIFY COLUMN uid INT(11) UNSIGNED DEFAULT NULL; | |
7f376ae0 SJ |
45 | |
46 | -- Following tables all refer to accounts.uid, but they use a different name. | |
becfe71d SJ |
47 | ALTER TABLE contacts MODIFY COLUMN contact INT(11) UNSIGNED DEFAULT NULL; |
48 | ALTER TABLE email_list_moderate MODIFY COLUMN mid INT(11) UNSIGNED DEFAULT NULL; | |
49 | ALTER TABLE gapps_accounts MODIFY COLUMN l_userid INT(11) UNSIGNED DEFAULT NULL; | |
50 | ALTER TABLE gapps_queue MODIFY COLUMN q_owner_id INT(11) UNSIGNED DEFAULT NULL; | |
51 | ALTER TABLE gapps_queue MODIFY COLUMN q_recipient_id INT(11) UNSIGNED DEFAULT NULL; | |
52 | ALTER TABLE gapps_nicknames MODIFY COLUMN l_userid INT(11) UNSIGNED DEFAULT NULL; | |
53 | ALTER TABLE homonyms MODIFY COLUMN homonyme_id INT(11) UNSIGNED DEFAULT NULL; | |
54 | ALTER TABLE log_sessions MODIFY COLUMN suid INT(11) UNSIGNED DEFAULT NULL; | |
55 | ALTER TABLE register_marketing MODIFY COLUMN sender INT(11) UNSIGNED DEFAULT NULL; | |
56 | ALTER TABLE register_mstats MODIFY COLUMN sender INT(11) UNSIGNED DEFAULT NULL; | |
57 | ALTER TABLE watch_nonins MODIFY COLUMN ni_id INT(11) UNSIGNED DEFAULT NULL; | |
7f376ae0 SJ |
58 | |
59 | -- Rename columns that should be called uid. | |
becfe71d SJ |
60 | ALTER TABLE group_events CHANGE COLUMN organisateur_uid uid INT(11) UNSIGNED DEFAULT NULL; |
61 | ALTER TABLE survey_votes CHANGE COLUMN user_id uid INT(11) UNSIGNED DEFAULT NULL; | |
62 | ALTER TABLE surveys CHANGE COLUMN author_id uid INT(11) UNSIGNED DEFAULT NULL; | |
7f376ae0 SJ |
63 | |
64 | -- Following tables all refer to profiles.pid. | |
becfe71d SJ |
65 | ALTER TABLE account_profiles MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; |
66 | ALTER TABLE requests MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
67 | ALTER TABLE search_name MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
68 | ALTER TABLE watch_profile MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
69 | ALTER TABLE profile_addresses MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
70 | ALTER TABLE profile_binets MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
71 | ALTER TABLE profile_corps MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
72 | ALTER TABLE profile_display MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
73 | ALTER TABLE profile_education MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
74 | ALTER TABLE profile_job MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
becfe71d SJ |
75 | ALTER TABLE profile_langskills MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; |
76 | ALTER TABLE profile_medals MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
77 | ALTER TABLE profile_mentor MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
78 | ALTER TABLE profile_mentor_country MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
79 | ALTER TABLE profile_mentor_sector MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
becfe71d SJ |
80 | ALTER TABLE profile_name MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; |
81 | ALTER TABLE profile_networking MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
82 | ALTER TABLE profile_phones MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
83 | ALTER TABLE profile_photos MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
84 | ALTER TABLE profile_skills MODIFY COLUMN pid INT(11) UNSIGNED DEFAULT NULL; | |
7f376ae0 SJ |
85 | |
86 | -- vim:set syntax=mysql: |