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_changes.pg.sql | |
parent | bda2edfb2799e73eaab83b775eda8afbe8bcb15d (diff) |
Add CheckUser extension
* revision 73143
* url: http://www.mediawiki.org/wiki/Extension:CheckUser
Diffstat (limited to 'extensions/CheckUser/cu_changes.pg.sql')
-rw-r--r-- | extensions/CheckUser/cu_changes.pg.sql | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/extensions/CheckUser/cu_changes.pg.sql b/extensions/CheckUser/cu_changes.pg.sql new file mode 100644 index 00000000..b62431e9 --- /dev/null +++ b/extensions/CheckUser/cu_changes.pg.sql @@ -0,0 +1,34 @@ +-- Tables for the CheckUser extension +-- vim: autoindent syn=pgsql sts=2 sw=2 +-- This is the Postgres version +-- See cu_changes.sql for details on each column + +BEGIN; + +CREATE SEQUENCE cu_changes_cu_id_seq; +CREATE TABLE cu_changes ( + cuc_id INTEGER NOT NULL DEFAULT nextval('cu_changes_cu_id_seq'), + cuc_namespace SMALLINT NOT NULL DEFAULT 0, + cuc_title TEXT NOT NULL DEFAULT '', + cuc_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, + cuc_user_text TEXT NOT NULL, + cuc_actiontext TEXT NOT NULL DEFAULT '', + cuc_comment TEXT NOT NULL DEFAULT '', + cuc_minor CHAR NOT NULL DEFAULT 0, + cuc_page_id INTEGER NULL REFERENCES page(page_id) ON DELETE SET NULL, + cuc_this_oldid INTEGER NOT NULL DEFAULT 0, + cuc_last_oldid INTEGER NOT NULL DEFAULT 0, + cuc_type SMALLINT NOT NULL DEFAULT 0, + cuc_timestamp TIMESTAMPTZ, + cuc_ip CIDR, + cuc_ip_hex TEXT, + cuc_xff TEXT, + cuc_xff_hex TEXT, + cuc_agent TEXT +); + +CREATE INDEX cuc_ip_hex_time ON cu_changes( cuc_ip_hex, cuc_timestamp ); +CREATE INDEX cuc_user_ip_time ON cu_changes( cuc_user, cuc_ip, cuc_timestamp ); +CREATE INDEX cuc_xff_hex_time ON cu_changes( cuc_xff_hex, cuc_timestamp ); + +COMMIT; |