summaryrefslogtreecommitdiff
path: root/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sql
blob: 0cd7f07a01f5587a9c18076fb37c5a2ce19c4e99 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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*/;