| 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. |
| 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 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; |
| 45 | |
| 46 | -- Following tables all refer to accounts.uid, but they use a different name. |
| 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; |
| 58 | |
| 59 | -- Rename columns that should be called uid. |
| 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; |
| 63 | |
| 64 | -- Following tables all refer to profiles.pid. |
| 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; |
| 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; |
| 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; |
| 85 | |
| 86 | -- vim:set syntax=mysql: |