diff options
Diffstat (limited to 'extensions/CheckUser/cu_log.pg.sql')
-rw-r--r-- | extensions/CheckUser/cu_log.pg.sql | 25 |
1 files changed, 0 insertions, 25 deletions
diff --git a/extensions/CheckUser/cu_log.pg.sql b/extensions/CheckUser/cu_log.pg.sql deleted file mode 100644 index 8ccf17d0..00000000 --- a/extensions/CheckUser/cu_log.pg.sql +++ /dev/null @@ -1,25 +0,0 @@ - -BEGIN; - -CREATE SEQUENCE cu_log_cul_id_seq; -CREATE TABLE cu_log ( - cul_id INTEGER NOT NULL DEFAULT nextval('cu_log_cul_id_seq'), - cul_timestamp TIMESTAMPTZ, - cul_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, - cul_user_text TEXT NOT NULL, - cul_reason TEXT NOT NULL DEFAULT '', - cul_type TEXT NOT NULL DEFAULT '', - cul_target_id INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, - cul_target_text TEXT NOT NULL DEFAULT '', - cul_target_hex TEXT NOT NULL DEFAULT '', - cul_range_start TEXT NOT NULL DEFAULT '', - cul_range_end TEXT NOT NULL DEFAULT '' -); - -CREATE INDEX cul_timestamp ON cu_log (cul_timestamp); -CREATE INDEX cul_user ON cu_log (cul_user); -CREATE INDEX cul_type_target ON cu_log (cul_type,cul_target_id); -CREATE INDEX cul_target_hex ON cu_log (cul_target_hex); -CREATE INDEX cul_range_start ON cu_log (cul_range_start); - -COMMIT; |