first commit

16 files changed, 146 insertions, 0 deletions

diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.pg.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.pg.sql
new file mode 100644
index 00000000..fbc27584
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.pg.sql
@@ -0,0 +1,29 @@
+-- Patch to add abuse_filter_history table (Postgres version)
+
+BEGIN;
+
+
+CREATE SEQUENCE abuse_filter_history_afh_id_seq;
+CREATE TABLE abuse_filter_history (
+    afh_id               INTEGER      NOT NULL PRIMARY KEY DEFAULT nextval('abuse_filter_history_afh_id_seq'),
+    afh_filter           INTEGER      NOT NULL,
+    afh_user             INTEGER      NOT NULL,
+    afh_user_text        TEXT         NOT NULL,
+    afh_timestamp        TIMESTAMPTZ  NOT NULL,
+    afh_pattern          TEXT         NOT NULL,
+    afh_comments         TEXT         NOT NULL,
+    afh_flags            TEXT         NOT NULL,
+    afh_public_comments  TEXT         NOT NULL,
+    afh_actions          TEXT         NOT NULL,
+    afh_deleted          SMALLINT     NOT NULL             DEFAULT 0,
+    afh_changed_fields   TEXT         NOT NULL             DEFAULT ''
+);
+CREATE INDEX abuse_filter_history_filter    ON abuse_filter_history(afh_filter);
+CREATE INDEX abuse_filter_history_user      ON abuse_filter_history(afh_user);
+CREATE INDEX abuse_filter_history_user_text ON abuse_filter_history(afh_user_text);
+CREATE INDEX abuse_filter_history_timestamp ON abuse_filter_history(afh_timestamp);
+
+
+COMMIT;
+
+
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sql
new file mode 100644
index 00000000..0cd7f07a
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sql
@@ -0,0 +1,20 @@
+-- Patch to add abuse_filter_history table
+
+CREATE TABLE /*$wgDBprefix*/abuse_filter_history (
+	afh_id BIGINT unsigned NOT NULL AUTO_INCREMENT,
+	afh_filter BIGINT unsigned NOT NULL,
+	afh_user BIGINT unsigned NOT NULL,
+	afh_user_text varchar(255) binary NOT NULL,
+	afh_timestamp binary(14) NOT NULL,
+	afh_pattern BLOB NOT NULL,
+	afh_comments BLOB NOT NULL,
+	afh_flags TINYBLOB NOT NULL,
+	afh_public_comments TINYBLOB,
+	afh_actions BLOB,
+	
+	PRIMARY KEY (afh_id),
+	KEY (afh_filter),
+	KEY (afh_user),
+	KEY (afh_user_text),
+	KEY (afh_timestamp)
+) /*$wgDBTableOptions*/;
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sqlite.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sqlite.sql
new file mode 100644
index 00000000..c1d26508
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sqlite.sql
@@ -0,0 +1,18 @@
+-- Patch to add abuse_filter_history table
+
+CREATE TABLE /*$wgDBprefix*/abuse_filter_history (
+	afh_id BIGINT unsigned NOT NULL AUTO_INCREMENT,
+	afh_filter BIGINT unsigned NOT NULL,
+	afh_user BIGINT unsigned NOT NULL,
+	afh_user_text varchar(255) binary NOT NULL,
+	afh_timestamp binary(14) NOT NULL,
+	afh_pattern BLOB NOT NULL,
+	afh_comments BLOB NOT NULL,
+	afh_flags TINYBLOB NOT NULL,
+	afh_public_comments TINYBLOB,
+	afh_actions BLOB
+) /*$wgDBTableOptions*/;
+CREATE INDEX afh_filter ON /*$wgDBprefix*/abuse_filter_history (afh_filter);
+CREATE INDEX afh_user ON /*$wgDBprefix*/abuse_filter_history (afh_user);
+CREATE INDEX afh_user_text ON /*$wgDBprefix*/abuse_filter_history (afh_user_text);
+CREATE INDEX afh_timestamp ON /*$wgDBprefix*/abuse_filter_history (afh_timestamp);
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-af_actions.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-af_actions.sql
new file mode 100644
index 00000000..e1662dfe
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-af_actions.sql
@@ -0,0 +1,4 @@
+--- Adds an af_actions field to the abuse_filter table, so we don't need to LEFT JOIN on abuse_filter_action and use a GROUP_CONCAT, which isn't compatible with mysql 4.0
+--- Andrew Garrett, 2009-01-27
+
+ALTER TABLE /*_*/abuse_filter add column af_actions varchar(255) NOT NULL DEFAULT '';
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-af_deleted.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-af_deleted.sql
new file mode 100644
index 00000000..bde61633
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-af_deleted.sql
@@ -0,0 +1,2 @@
+ALTER TABLE /*_*/abuse_filter ADD COLUMN af_deleted tinyint(1) NOT NULL DEFAULT 0;
+ALTER TABLE /*_*/abuse_filter_history ADD COLUMN afh_deleted tinyint(1) NOT NULL DEFAULT 0;
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-af_group.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-af_group.sql
new file mode 100644
index 00000000..40e3ada4
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-af_group.sql
@@ -0,0 +1,5 @@
+-- Add af_group field to abuse_filter table
+ALTER TABLE /*_*/abuse_filter add column af_group varchar(64) binary NOT NULL DEFAULT 'default';
+ALTER TABLE /*_*/abuse_filter_history add column afh_group varchar(64) binary NULL;
+
+CREATE INDEX /*i*/af_group ON /*_*/abuse_filter (af_group,af_enabled,af_id);
\ No newline at end of file
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-afh_changed_fields.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-afh_changed_fields.sql
new file mode 100644
index 00000000..6f1360b3
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-afh_changed_fields.sql
@@ -0,0 +1,3 @@
+--- 2009-01-26, Andrew Garrett
+--- Adds a 'changed fields' field to the abuse filter history, so that we can highlight fields which changed!
+ALTER TABLE /*_*/abuse_filter_history add column afh_changed_fields varchar(255) NOT NULL DEFAULT '';
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-afl-namespace_int.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-afl-namespace_int.sql
new file mode 100644
index 00000000..418cab91
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-afl-namespace_int.sql
@@ -0,0 +1 @@
+ALTER TABLE /*_*/abuse_filter_log MODIFY afl_namespace INT NOT NULL;
\ No newline at end of file
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-afl_action_id.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-afl_action_id.sql
new file mode 100644
index 00000000..85eab834
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-afl_action_id.sql
@@ -0,0 +1,8 @@
+-- Store the ID of successful actions in the abuse_filter_log table.
+ALTER TABLE /*_*/abuse_filter_log
+	ADD COLUMN afl_rev_id int unsigned;
+CREATE INDEX /*i*/afl_rev_id ON /*_*/abuse_filter_log (afl_rev_id);
+
+ALTER TABLE /*_*/abuse_filter_log
+	ADD COLUMN afl_log_id int unsigned;
+CREATE INDEX /*i*/afl_log_id ON /*_*/abuse_filter_log (afl_log_id);
\ No newline at end of file
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-afl_change_deleted_patrolled.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-afl_change_deleted_patrolled.sql
new file mode 100644
index 00000000..e96ab95f
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-afl_change_deleted_patrolled.sql
@@ -0,0 +1,3 @@
+ALTER TABLE /*_*/abuse_filter_log MODIFY afl_deleted tinyint(1) NOT NULL DEFAULT 0;
+ALTER TABLE /*_*/abuse_filter_log MODIFY afl_patrolled_by int unsigned NOT NULL DEFAULT 0;
+
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sql
new file mode 100644
index 00000000..16dea669
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sql
@@ -0,0 +1,18 @@
+-- Fixes abuse_filter_log indices.
+
+--# 	PRIMARY KEY (afl_id),
+--# 	KEY (afl_filter,afl_timestamp),
+--# 	KEY (afl_user,afl_user_text,afl_timestamp),
+--# 	KEY (afl_timestamp),
+--# 	KEY (afl_namespace, afl_title, afl_timestamp),
+--# 	KEY (afl_ip, afl_timestamp)
+
+ALTER TABLE /*_*/abuse_filter_log ADD KEY filter_timestamp (afl_filter,afl_timestamp);
+ALTER TABLE /*_*/abuse_filter_log ADD KEY user_timestamp (afl_user,afl_user_text,afl_timestamp);
+ALTER TABLE /*_*/abuse_filter_log ADD KEY page_timestamp (afl_namespace, afl_title, afl_timestamp);
+ALTER TABLE /*_*/abuse_filter_log ADD KEY ip_timestamp (afl_ip, afl_timestamp);
+
+ALTER TABLE /*_*/abuse_filter_log DROP KEY afl_filter;
+ALTER TABLE /*_*/abuse_filter_log DROP KEY afl_user;
+ALTER TABLE /*_*/abuse_filter_log DROP KEY afl_namespace;
+ALTER TABLE /*_*/abuse_filter_log DROP KEY afl_ip;
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sqlite.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sqlite.sql
new file mode 100644
index 00000000..f490bf9c
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sqlite.sql
@@ -0,0 +1,18 @@
+-- Fixes abuse_filter_log indices.
+
+--# 	PRIMARY KEY (afl_id),
+--# 	KEY (afl_filter,afl_timestamp),
+--# 	KEY (afl_user,afl_user_text,afl_timestamp),
+--# 	KEY (afl_timestamp),
+--# 	KEY (afl_namespace, afl_title, afl_timestamp),
+--# 	KEY (afl_ip, afl_timestamp)
+
+CREATE INDEX afl_filter_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_filter,afl_timestamp);
+CREATE INDEX afl_user_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_user,afl_user_text,afl_timestamp);
+CREATE INDEX afl_page_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_namespace, afl_title, afl_timestamp);
+CREATE INDEX afl_ip_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_ip, afl_timestamp);
+
+ALTER TABLE /*_*/abuse_filter_log DROP KEY afl_filter;
+ALTER TABLE /*_*/abuse_filter_log DROP KEY afl_user;
+ALTER TABLE /*_*/abuse_filter_log DROP KEY afl_namespace;
+ALTER TABLE /*_*/abuse_filter_log DROP KEY afl_ip;
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-global_filters.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-global_filters.sql
new file mode 100644
index 00000000..7706015e
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-global_filters.sql
@@ -0,0 +1,6 @@
+-- Patch to add support for global filters
+
+ALTER TABLE /*_*/abuse_filter ADD COLUMN af_global tinyint(1) NOT NULL DEFAULT 0;
+
+ALTER TABLE /*_*/abuse_filter_log ADD COLUMN afl_wiki varchar(64) binary NULL;
+ALTER TABLE /*_*/abuse_filter_log CHANGE COLUMN afl_filter afl_filter varchar(64) binary NOT NULL;
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-global_logging_wiki-index.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-global_logging_wiki-index.sql
new file mode 100644
index 00000000..690d034e
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-global_logging_wiki-index.sql
@@ -0,0 +1,3 @@
+-- Add abuse_filter_log idex for afl_wiki.
+
+ALTER TABLE /*_*/abuse_filter_log ADD KEY wiki_timestamp (afl_wiki, afl_timestamp);
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-global_logging_wiki-index.sqlite.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-global_logging_wiki-index.sqlite.sql
new file mode 100644
index 00000000..45c619c6
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-global_logging_wiki-index.sqlite.sql
@@ -0,0 +1,3 @@
+-- Add abuse_filter_log idex for afl_wiki.
+
+CREATE INDEX afl_wiki_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_wiki, afl_timestamp);
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-hide_patrol.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-hide_patrol.sql
new file mode 100644
index 00000000..0bc34ad8
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-hide_patrol.sql
@@ -0,0 +1,5 @@
+-- Add hiding and patrolling ability to abuse filter log
+-- Andrew Garrett, June 2009
+
+ALTER TABLE /*_*/abuse_filter_log ADD COLUMN afl_deleted tinyint(1) NOT NULL DEFAULT 0;
+ALTER TABLE /*_*/abuse_filter_log ADD COLUMN afl_patrolled_by int unsigned NOT NULL DEFAULT 0;