Changes between Version 9 and Version 10 of RightToErasure

Timestamp:

May 3, 2018, 1:58:55 PM (6 years ago)

Author:

Kevin Reed

Comment:

--

RightToErasure

@@ -149 +149 @@
  * An entry will be inserted into the host_deleted table for each host record the user has.
  * All entries  for the user will be deleted from the following tables:
-   * badge_user (delete from badge_user where user_id = ?)
+   * user_submit - ( delete from user_submit where user_id = ? )
+   * user_submit_app - ( delete from user_submit_app where user_id = ? )   * badge_user (delete from badge_user where user_id = ?)
    * banishment_vote (delete from banishment_vote where userid = ?)
    * credit_user (delete from credit_user where userid = ?)
@@ -166 +167 @@
    * post ( update post set parent_post = 0 where parent_post in (select id from post where user = ? ) )
    * post ( delete from post where user = ? )
+   * thread ( update thread set owner = 0 where owner = ? ) - note that the query to return the threads needs to be updated to be an outerjoin so that when misses occur, the thread still shows
+   * private_messages ( delete from private_messages where userid = ? or senderid = ? )
    * sent_email ( delete from sent_email where userid = ? )
    * subscriptions ( delete from subscriptions where userid = ? )
@@ -174 +177 @@
    * user ( delete from user where id = ? )
  * 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:
-   * result
- * Questions.
-   * private_messages ( delete from private_messages where userid = ? or senderid = ? )  # Jord had asserted that we should only do this for userid = ?
-   * thread ( update thread set owner = 0 where owner = ? ) - note that the query to return the threads needs to be updated to be an outerjoin so that when misses occur, the thread still shows
-   * user_submit - don't know what to do with these
-   * user_submit_app - don't know what to do with these
+   * result (remove hostid from it though)
+