Mercurial > hg > savane-forge

annotate tables_savane_users.txt @ 337:af82331e34ca

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Python 2.5 compat
author Sylvain Beucler <beuc@beuc.net>
date Sun, 22 Aug 2010 23:45:00 +0200
parents b2d75b8b5fd2
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
100
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
1 -- Good reason to keep the user
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
2 -- Also: if the referenced user doesn't exist, it should be set to
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
3 -- 100/None (and converted to Null when migrate to the new frontend)
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
4 -- unless stated otherwise below
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
5 SELECT COUNT(DISTINCT user_id) FROM user_group;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
6 SELECT COUNT(DISTINCT mod_by) FROM group_history;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
7
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
8 SELECT COUNT(DISTINCT submitted_by) FROM support;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
9 SELECT COUNT(DISTINCT added_by) FROM support_cc;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
10 SELECT COUNT(DISTINCT mod_by) FROM support_history;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
11
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
12 SELECT COUNT(DISTINCT submitted_by) FROM bugs;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
13 SELECT COUNT(DISTINCT added_by) FROM bugs_cc;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
14 SELECT COUNT(DISTINCT mod_by) FROM bugs_history;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
15
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
16 SELECT COUNT(DISTINCT submitted_by) FROM task;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
17 SELECT COUNT(DISTINCT added_by) FROM task_cc;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
18 SELECT COUNT(DISTINCT mod_by) FROM task_history;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
19
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
20 SELECT COUNT(DISTINCT submitted_by) FROM patch;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
21 SELECT COUNT(DISTINCT added_by) FROM patch_cc;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
22 SELECT COUNT(DISTINCT mod_by) FROM patch_history;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
23
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
24 SELECT COUNT(DISTINCT submitted_by) FROM cookbook;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
25 SELECT COUNT(DISTINCT added_by) FROM cookbook_cc;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
26 SELECT COUNT(DISTINCT mod_by) FROM cookbook_history;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
27
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
28 SELECT COUNT(DISTINCT submitted_by) FROM trackers_file;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
29
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
30 SELECT COUNT(DISTINCT posted_by) FROM forum;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
31
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
32 SELECT COUNT(DISTINCT submitted_by) FROM news_bytes;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
33
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
34 SELECT COUNT(DISTINCT created_by) FROM people_job;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
35
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
36
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
37 -- Rows to also remove if we remove the user
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
38 DELETE FROM user WHERE user_id=...; -- hmmm
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
39 DELETE FROM people_skill_inventory WHERE user_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
40 DELETE FROM form WHERE user_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
41 DELETE FROM trackers_watcher WHERE user_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
42 DELETE FROM trackers_watcher WHERE watchee_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
43 DELETE FROM trackers_notification WHERE user_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
44 DELETE FROM user_bookmarks WHERE user_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
45 DELETE FROM user_preferences WHERE user_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
46 DELETE FROM user_squad WHERE user_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
47 DELETE FROM user_votes WHERE vote_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
48 DELETE FROM task_filter WHERE user_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
49 DELETE FROM trackers_spamscore WHERE reporter_user_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
50 DELETE FROM trackers_spamscore WHERE affected_user_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
51 SELECT COUNT(DISTINCT user_id) FROM forum_monitored_forums;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
52 SELECT COUNT(DISTINCT user_id) FROM forum_saved_place;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
53
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
54 DELETE FROM user_group WHERE user_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
55
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
56
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
57 -- Rows to reset to user 'None' if the user is removed
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
58 -- (user information is not crucial)
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
59 UPDATE task_report SET user_id=100 WHERE user_id=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
60 UPDATE mail_group_list SET list_admin=100 WHERE list_admin=...;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
61 SELECT COUNT(DISTINCT assigned_to) FROM support;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
62 SELECT COUNT(DISTINCT assigned_to) FROM bugs;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
63 SELECT COUNT(DISTINCT assigned_to) FROM task;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
64 SELECT COUNT(DISTINCT assigned_to) FROM patch;
b2d75b8b5fd2 Reference where user_id's are referenced in the old savane tables
Sylvain Beucler <beuc@beuc.net>
parents:
diff changeset
65 SELECT COUNT(DISTINCT assigned_to) FROM cookbook;