| 146 | | * badge_user |
| 147 | | * banishment_vote |
| 148 | | * credit_user |
| 149 | | * credited_job |
| 150 | | * donation_paypal |
| 151 | | * forum_logging |
| 152 | | * forum_preferences |
| 153 | | * friend (where either user_src or user_dest equals the deleted userid) |
| 154 | | * host_app_version (for each host the user owns) |
| 155 | | * msg_from_host (for each host the user owns) |
| 156 | | * msg_to_host (for each host the user owns) |
| 157 | | * host |
| 158 | | * notify |
| 159 | | * post_ratings (for each post the user created) |
| 160 | | * post_ratings (for each post the user rated) |
| 161 | | * post (for each post made by the user, find any posts that has that as a parent and set parent_post_id to null) |
| 162 | | * post (remove posts made by the user) |
| 163 | | * private_messages |
| 164 | | * sent_email |
| 165 | | * subscriptions |
| 166 | | * team_admin |
| 167 | | * team_delta |
| 168 | | * user |
| 169 | | * Problematic Tables |
| 170 | | * team (when user_id is for the user, how to remove since field is not null) |
| 171 | | * Note that rows in the following are not deleted because these will be deleted in due course and are necessary for technical operation of the system: |
| | 146 | * badge_user (delete from badge_user where user_id = ?) |
| | 147 | * banishment_vote (delete from banishment_vote where userid = ?) |
| | 148 | * credit_user (delete from credit_user where userid = ?) |
| | 149 | * credited_job (delete from credited_job where userid = ?) |
| | 150 | * donation_paypal (delete from donation_paypal where userid = ?) |
| | 151 | * forum_logging (delete from forum_logging where userid = ?) |
| | 152 | * forum_preferences (delete from forum_preferences where userid = ?) |
| | 153 | * friend (delete from friend where user_src = ? or user_dest = ?) |
| | 154 | * host_app_version (delete from host_app_version where host_id in (select id from host where userid = ?) ) |
| | 155 | * msg_from_host ( delete from msg_from_host where hostid in (select id from host where userid = ?) ) |
| | 156 | * msg_to_host ( delete from msg_to_host where hostid in (select id from host where userid = ?) ) |
| | 157 | * host (delete from host where userid = ?) |
| | 158 | * notify ( delete from notfiy where userid = ? ) |
| | 159 | * post_ratings ( delete from post_ratings where post in ( select id from post where user = ? ) ) |
| | 160 | * post_ratings ( delete from post_ratings where user = ? ) |
| | 161 | * post ( update post set parent_post = 0 where parent_post in (select id from post where user = ? ) ) |
| | 162 | * post ( delete from post where user = ? ) |
| | 163 | * sent_email ( delete from sent_email where userid = ? ) |
| | 164 | * subscriptions ( delete from subscriptions where userid = ? ) |
| | 165 | * team_admin ( delete from team_admin where userid = ? ) |
| | 166 | * team_delta ( delete from team_delta where userid = ? ) |
| | 167 | * team ( update team set userid = 0 where userid = ? ) |
| | 168 | * token ( delete from token where userid = ? ) |
| | 169 | * user ( delete from user where id = ? ) |
| | 170 | * Note that rows in the following are not deleted because these will be deleted in due course and are necessary for technical operation of the system: |
