1 CREATE VIEW mod_remove_post_view AS
10 mrp.mod_user_id = u.id) AS mod_user_name,
17 mrp.post_id = p.id) AS post_name,
26 AND p.community_id = c.id) AS community_id,
35 AND p.community_id = c.id) AS community_name
39 CREATE VIEW mod_lock_post_view AS
48 mlp.mod_user_id = u.id) AS mod_user_name,
55 mlp.post_id = p.id) AS post_name,
64 AND p.community_id = c.id) AS community_id,
73 AND p.community_id = c.id) AS community_name
77 CREATE VIEW mod_remove_comment_view AS
86 mrc.mod_user_id = u.id) AS mod_user_name,
93 mrc.comment_id = c.id) AS comment_user_id,
101 mrc.comment_id = c.id
102 AND u.id = c.creator_id) AS comment_user_name,
109 mrc.comment_id = c.id) AS comment_content,
117 mrc.comment_id = c.id
118 AND c.post_id = p.id) AS post_id,
126 mrc.comment_id = c.id
127 AND c.post_id = p.id) AS post_name,
136 mrc.comment_id = c.id
138 AND p.community_id = co.id) AS community_id,
147 mrc.comment_id = c.id
149 AND p.community_id = co.id) AS community_name
151 mod_remove_comment mrc;
153 CREATE VIEW mod_remove_community_view AS
162 mrc.mod_user_id = u.id) AS mod_user_name,
169 mrc.community_id = c.id) AS community_name
171 mod_remove_community mrc;
173 CREATE VIEW mod_ban_from_community_view AS
182 mb.mod_user_id = u.id) AS mod_user_name,
189 mb.other_user_id = u.id) AS other_user_name,
196 mb.community_id = c.id) AS community_name
198 mod_ban_from_community mb;
200 CREATE VIEW mod_ban_view AS
209 mb.mod_user_id = u.id) AS mod_user_name,
216 mb.other_user_id = u.id) AS other_user_name
220 CREATE VIEW mod_add_community_view AS
229 ma.mod_user_id = u.id) AS mod_user_name,
236 ma.other_user_id = u.id) AS other_user_name,
243 ma.community_id = c.id) AS community_name
245 mod_add_community ma;
247 CREATE VIEW mod_add_view AS
256 ma.mod_user_id = u.id) AS mod_user_name,
263 ma.other_user_id = u.id) AS other_user_name