Page MenuHomeWickedGov Phorge
Files F1426298

patch-drop-afh_user.sql
No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

patch-drop-afh_user.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: db_patches/abstractSchemaChanges/patch-drop-afh_user.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TEMPORARY TABLE /*_*/__temp__abuse_filter_history AS
SELECT
afh_id,
afh_filter,
afh_actor,
afh_timestamp,
afh_pattern,
afh_comments,
afh_flags,
afh_public_comments,
afh_actions,
afh_deleted,
afh_changed_fields,
afh_group
FROM /*_*/abuse_filter_history;
DROP TABLE /*_*/abuse_filter_history;
CREATE TABLE /*_*/abuse_filter_history (
afh_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
afh_filter BIGINT UNSIGNED NOT NULL,
afh_actor BIGINT UNSIGNED NOT NULL,
afh_timestamp BLOB NOT NULL,
afh_pattern BLOB NOT NULL,
afh_comments BLOB NOT NULL,
afh_flags BLOB NOT NULL,
afh_public_comments BLOB DEFAULT NULL,
afh_actions BLOB DEFAULT NULL,
afh_deleted SMALLINT DEFAULT 0 NOT NULL,
afh_changed_fields VARCHAR(255) DEFAULT '' NOT NULL,
afh_group BLOB DEFAULT NULL
);
INSERT INTO /*_*/abuse_filter_history (
afh_id, afh_filter, afh_actor, afh_timestamp,
afh_pattern, afh_comments, afh_flags,
afh_public_comments, afh_actions,
afh_deleted, afh_changed_fields,
afh_group
)
SELECT
afh_id,
afh_filter,
afh_actor,
afh_timestamp,
afh_pattern,
afh_comments,
afh_flags,
afh_public_comments,
afh_actions,
afh_deleted,
afh_changed_fields,
afh_group
FROM
/*_*/__temp__abuse_filter_history;
DROP TABLE /*_*/__temp__abuse_filter_history;
CREATE INDEX afh_filter ON /*_*/abuse_filter_history (afh_filter);
CREATE INDEX afh_actor ON /*_*/abuse_filter_history (afh_actor);
CREATE INDEX afh_timestamp ON /*_*/abuse_filter_history (afh_timestamp);

File Metadata

Mime Type
text/plain
Expires
Sat, May 16, 13:00 (1 d, 6 h)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
d5/a9/203461323d1a0bf371e05df9fbca
Default Alt Text
patch-drop-afh_user.sql (1 KB)

Event Timeline