Page MenuHomeWickedGov Phorge
Files F1425774

patch-cu_log-actor.sql
No OneTemporary
Actions

Size
2 KB
Referenced Files
None
Subscribers
None

patch-cu_log-actor.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: extensions/CheckUser/schema/abstractSchemaChanges/patch-cu_log-actor.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX cul_user;
DROP INDEX cul_type_target;
DROP INDEX cul_target_hex;
DROP INDEX cul_range_start;
DROP INDEX cul_timestamp;
CREATE TEMPORARY TABLE /*_*/__temp__cu_log AS
SELECT cul_id, cul_timestamp, cul_user, cul_user_text, cul_reason, cul_reason_id, cul_reason_plaintext_id, cul_type, cul_target_id, cul_target_text, cul_target_hex, cul_range_start, cul_range_end
FROM /*_*/cu_log;
DROP TABLE /*_*/cu_log;
CREATE TABLE /*_*/cu_log ( cul_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, cul_timestamp BLOB NOT NULL, cul_user INTEGER UNSIGNED NOT NULL, cul_user_text BLOB NOT NULL, cul_reason BLOB NOT NULL, cul_reason_id BIGINT UNSIGNED DEFAULT 0 NOT NULL, cul_reason_plaintext_id BIGINT UNSIGNED DEFAULT 0 NOT NULL, cul_type BLOB NOT NULL, cul_target_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, cul_target_text BLOB NOT NULL, cul_target_hex BLOB DEFAULT '' NOT NULL, cul_range_start BLOB DEFAULT '' NOT NULL, cul_range_end BLOB DEFAULT '' NOT NULL, cul_actor BIGINT UNSIGNED DEFAULT 0 NOT NULL );
INSERT INTO /*_*/cu_log ( cul_id, cul_timestamp, cul_user, cul_user_text, cul_reason, cul_reason_id, cul_reason_plaintext_id, cul_type, cul_target_id, cul_target_text, cul_target_hex, cul_range_start, cul_range_end )
SELECT cul_id, cul_timestamp, cul_user, cul_user_text, cul_reason, cul_reason_id, cul_reason_plaintext_id, cul_type, cul_target_id, cul_target_text, cul_target_hex, cul_range_start, cul_range_end
FROM /*_*/__temp__cu_log;
DROP TABLE /*_*/__temp__cu_log;
CREATE INDEX cul_user ON /*_*/cu_log (cul_user, cul_timestamp);
CREATE INDEX cul_type_target ON /*_*/cu_log ( cul_type, cul_target_id, cul_timestamp );
CREATE INDEX cul_target_hex ON /*_*/cu_log (cul_target_hex, cul_timestamp);
CREATE INDEX cul_range_start ON /*_*/cu_log (cul_range_start, cul_timestamp);
CREATE INDEX cul_timestamp ON /*_*/cu_log (cul_timestamp);
CREATE INDEX cul_actor_time ON /*_*/cu_log (cul_actor, cul_timestamp);

File Metadata

Mime Type
text/plain
Expires
Sat, May 16, 11:59 (19 h, 24 m)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
85/a6/1de01ea18c4064944791b7527ba9
Default Alt Text
patch-cu_log-actor.sql (2 KB)

Event Timeline