Page MenuHomeWickedGov Phorge
Files F5978624

patch-drop-afl_ip.sql
No OneTemporary
Actions

Size
2 KB
Referenced Files
None
Subscribers
None

patch-drop-afl_ip.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: db_patches/abstractSchemaChanges/patch-drop-afl_ip.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TEMPORARY TABLE /*_*/__temp__abuse_filter_log AS
SELECT
afl_id,
afl_global,
afl_filter_id,
afl_user,
afl_user_text,
afl_ip_hex,
afl_action,
afl_actions,
afl_var_dump,
afl_timestamp,
afl_namespace,
afl_title,
afl_wiki,
afl_deleted,
afl_rev_id
FROM /*_*/abuse_filter_log;
DROP TABLE /*_*/abuse_filter_log;
CREATE TABLE /*_*/abuse_filter_log (
afl_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
afl_global SMALLINT NOT NULL,
afl_filter_id BIGINT UNSIGNED NOT NULL,
afl_user BIGINT UNSIGNED NOT NULL,
afl_user_text BLOB NOT NULL,
afl_ip_hex VARCHAR(255) NOT NULL,
afl_action BLOB NOT NULL,
afl_actions BLOB NOT NULL,
afl_var_dump BLOB NOT NULL,
afl_timestamp BLOB NOT NULL,
afl_namespace INTEGER NOT NULL,
afl_title BLOB NOT NULL,
afl_wiki BLOB DEFAULT NULL,
afl_deleted SMALLINT DEFAULT 0 NOT NULL,
afl_rev_id INTEGER UNSIGNED DEFAULT NULL
);
INSERT INTO /*_*/abuse_filter_log (
afl_id, afl_global, afl_filter_id,
afl_user, afl_user_text, afl_ip_hex,
afl_action, afl_actions, afl_var_dump,
afl_timestamp, afl_namespace, afl_title,
afl_wiki, afl_deleted, afl_rev_id
)
SELECT
afl_id,
afl_global,
afl_filter_id,
afl_user,
afl_user_text,
afl_ip_hex,
afl_action,
afl_actions,
afl_var_dump,
afl_timestamp,
afl_namespace,
afl_title,
afl_wiki,
afl_deleted,
afl_rev_id
FROM
/*_*/__temp__abuse_filter_log;
DROP TABLE /*_*/__temp__abuse_filter_log;
CREATE INDEX afl_filter_timestamp_full ON /*_*/abuse_filter_log (
afl_global, afl_filter_id, afl_timestamp
);
CREATE INDEX afl_user_timestamp ON /*_*/abuse_filter_log (
afl_user, afl_user_text, afl_timestamp
);
CREATE INDEX afl_timestamp ON /*_*/abuse_filter_log (afl_timestamp);
CREATE INDEX afl_page_timestamp ON /*_*/abuse_filter_log (
afl_namespace, afl_title, afl_timestamp
);
CREATE INDEX afl_ip_hex_timestamp ON /*_*/abuse_filter_log (afl_ip_hex, afl_timestamp);
CREATE INDEX afl_rev_id ON /*_*/abuse_filter_log (afl_rev_id);
CREATE INDEX afl_wiki_timestamp ON /*_*/abuse_filter_log (afl_wiki, afl_timestamp);
CREATE INDEX afl_var_dump_timestamp ON /*_*/abuse_filter_log (afl_var_dump, afl_timestamp);

File Metadata

Mime Type
text/plain
Expires
Sat, Oct 3, 20:29 (3 d, 21 h ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
45/aa/9090a413bca1af6eed65793094a0
Default Alt Text
patch-drop-afl_ip.sql (2 KB)

Event Timeline