Page MenuHomeWickedGov Phorge
Files F5983054

patch-add-afh_actor.sql
No OneTemporary
Actions

Size
2 KB
Referenced Files
None
Subscribers
None

patch-add-afh_actor.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: db_patches/abstractSchemaChanges/patch-add-afh_actor.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX afh_filter;
DROP INDEX afh_user;
DROP INDEX afh_user_text;
DROP INDEX afh_timestamp;
CREATE TEMPORARY TABLE /*_*/__temp__abuse_filter_history AS
SELECT afh_id, afh_filter, afh_user, afh_user_text, 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_user BIGINT UNSIGNED DEFAULT 0 NOT NULL, afh_user_text BLOB DEFAULT '' 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, afh_actor BIGINT UNSIGNED DEFAULT 0 NOT NULL );
INSERT INTO /*_*/abuse_filter_history ( afh_id, afh_filter, afh_user, afh_user_text, 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_user, afh_user_text, 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_user ON /*_*/abuse_filter_history (afh_user);
CREATE INDEX afh_user_text ON /*_*/abuse_filter_history (afh_user_text);
CREATE INDEX afh_timestamp ON /*_*/abuse_filter_history (afh_timestamp);
CREATE INDEX afh_actor ON /*_*/abuse_filter_history (afh_actor);

File Metadata

Mime Type
text/plain
Expires
Sat, Oct 3, 22:41 (1 w, 4 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
a5/17/3ac964e4afb3e2e483cdb9e9b239
Default Alt Text
patch-add-afh_actor.sql (2 KB)

Event Timeline