diff options
author | Pierre Schmitz <pierre@archlinux.de> | 2010-09-16 21:49:19 +0200 |
---|---|---|
committer | Pierre Schmitz <pierre@archlinux.de> | 2010-09-16 21:49:19 +0200 |
commit | 91da036ca57d692fba4faad573aa4bca1435eda7 (patch) | |
tree | 97d4e9b74fc15dd9ff6cac4e023db04843375dbc /extensions/CheckUser/cu_log.pg.sql | |
parent | bda2edfb2799e73eaab83b775eda8afbe8bcb15d (diff) |
Add CheckUser extension
* revision 73143
* url: http://www.mediawiki.org/wiki/Extension:CheckUser
Diffstat (limited to 'extensions/CheckUser/cu_log.pg.sql')
-rw-r--r-- | extensions/CheckUser/cu_log.pg.sql | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/extensions/CheckUser/cu_log.pg.sql b/extensions/CheckUser/cu_log.pg.sql new file mode 100644 index 00000000..8ccf17d0 --- /dev/null +++ b/extensions/CheckUser/cu_log.pg.sql @@ -0,0 +1,25 @@ + +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; |