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
;
5 -- Following tables all refer to accounts.uid.
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;
35 ALTER TABLE profile_modifications
MODIFY COLUMN uid
INT(11) UNSIGNED
DEFAULT NULL;
36 ALTER TABLE register_marketing
MODIFY COLUMN uid
INT(11) UNSIGNED
DEFAULT NULL;
37 ALTER TABLE register_mstats
MODIFY COLUMN uid
INT(11) UNSIGNED
DEFAULT NULL;
38 ALTER TABLE register_pending
MODIFY COLUMN uid
INT(11) UNSIGNED
DEFAULT NULL;
39 ALTER TABLE register_subs
MODIFY COLUMN uid
INT(11) UNSIGNED
DEFAULT NULL;
40 ALTER TABLE reminder
MODIFY COLUMN uid
INT(11) UNSIGNED
DEFAULT NULL;
41 ALTER TABLE requests
MODIFY COLUMN uid
INT(11) UNSIGNED
DEFAULT NULL;
42 ALTER TABLE requests_hidden
MODIFY COLUMN uid
INT(11) UNSIGNED
DEFAULT NULL;
43 ALTER TABLE watch
MODIFY COLUMN uid
INT(11) UNSIGNED
DEFAULT NULL;
44 ALTER TABLE watch_nonins
MODIFY COLUMN uid
INT(11) UNSIGNED
DEFAULT NULL;
45 ALTER TABLE watch_promo
MODIFY COLUMN uid
INT(11) UNSIGNED
DEFAULT NULL;
47 -- Following tables all refer to accounts.uid, but they use a different name.
48 ALTER TABLE contacts
MODIFY COLUMN contact
INT(11) UNSIGNED
DEFAULT NULL;
49 ALTER TABLE email_list_moderate
MODIFY COLUMN mid
INT(11) UNSIGNED
DEFAULT NULL;
50 ALTER TABLE gapps_accounts
MODIFY COLUMN l_userid
INT(11) UNSIGNED
DEFAULT NULL;
51 ALTER TABLE gapps_queue
MODIFY COLUMN q_owner_id
INT(11) UNSIGNED
DEFAULT NULL;
52 ALTER TABLE gapps_queue
MODIFY COLUMN q_recipient_id
INT(11) UNSIGNED
DEFAULT NULL;
53 ALTER TABLE gapps_nicknames
MODIFY COLUMN l_userid
INT(11) UNSIGNED
DEFAULT NULL;
54 ALTER TABLE homonyms
MODIFY COLUMN homonyme_id
INT(11) UNSIGNED
DEFAULT NULL;
55 ALTER TABLE log_sessions
MODIFY COLUMN suid
INT(11) UNSIGNED
DEFAULT NULL;
56 ALTER TABLE register_marketing
MODIFY COLUMN sender
INT(11) UNSIGNED
DEFAULT NULL;
57 ALTER TABLE register_mstats
MODIFY COLUMN sender
INT(11) UNSIGNED
DEFAULT NULL;
58 ALTER TABLE watch_nonins
MODIFY COLUMN ni_id
INT(11) UNSIGNED
DEFAULT NULL;
60 -- Rename columns that should be called uid.
61 ALTER TABLE group_events CHANGE
COLUMN organisateur_uid uid
INT(11) UNSIGNED
DEFAULT NULL;
62 ALTER TABLE survey_votes CHANGE
COLUMN user_id uid
INT(11) UNSIGNED
DEFAULT NULL;
63 ALTER TABLE surveys CHANGE
COLUMN author_id uid
INT(11) UNSIGNED
DEFAULT NULL;
65 -- Following tables all refer to profiles.pid.
66 ALTER TABLE account_profiles
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
67 ALTER TABLE requests
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
68 ALTER TABLE search_name
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
69 ALTER TABLE watch_profile
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
70 ALTER TABLE profile_addresses
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
71 ALTER TABLE profile_binets
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
72 ALTER TABLE profile_corps
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
73 ALTER TABLE profile_display
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
74 ALTER TABLE profile_education
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
75 ALTER TABLE profile_job
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
76 ALTER TABLE profile_job_term
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
77 ALTER TABLE profile_langskills
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
78 ALTER TABLE profile_medals
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
79 ALTER TABLE profile_mentor
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
80 ALTER TABLE profile_mentor_country
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
81 ALTER TABLE profile_mentor_sector
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
82 ALTER TABLE profile_mentor_term
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
83 ALTER TABLE profile_modifications
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
84 ALTER TABLE profile_name
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
85 ALTER TABLE profile_networking
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
86 ALTER TABLE profile_phones
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
87 ALTER TABLE profile_photos
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
88 ALTER TABLE profile_skills
MODIFY COLUMN pid
INT(11) UNSIGNED
DEFAULT NULL;
90 -- vim:set syntax=mysql: