forked from stadust/pointercrate
-
Notifications
You must be signed in to change notification settings - Fork 1
/
20190105154218_new_audit_log.down.sql
47 lines (31 loc) · 1.18 KB
/
20190105154218_new_audit_log.down.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
-- This file should undo anything in `up.sql`
DROP TABLE demon_additions;
DROP FUNCTION audit_demon_addition() CASCADE;
DROP TABLE demon_modifications;
DROP FUNCTION audit_demon_modification() CASCADE;
DROP TABLE record_additions;
DROP FUNCTION audit_record_addition() CASCADE;
DROP TABLE record_modifications;
DROP FUNCTION audit_record_modification() CASCADE;
DROP TABLE record_deletions;
DROP FUNCTION audit_record_deletion() CASCADE;
DROP TABLE player_additions;
DROP FUNCTION audit_player_addition() CASCADE;
DROP TABLE player_modifications;
DROP FUNCTION audit_player_modification() CASCADE;
DROP TABLE player_deletions;
DROP FUNCTION audit_player_deletion() CASCADE;
DROP TABLE creator_additions;
DROP FUNCTION audit_creator_addition() CASCADE;
DROP TABLE creator_deletions;
DROP FUNCTION audit_creator_deletion() CASCADE;
DROP TABLE submitter_modifications;
DROP FUNCTION audit_submitter_modification() CASCADE;
DROP TABLE user_additions;
DROP FUNCTION audit_user_addition() CASCADE;
DROP TABLE user_modifications;
DROP FUNCTION audit_user_modification() CASCADE;
DROP TABLE user_deletions;
DROP FUNCTION audit_user_deletion() CASCADE;
DROP TABLE audit_log2;
DROP TABLE active_user;