Page MenuHomeWickedGov Phorge
Files F5984802

patch-cu_private_event-modify-cupe_actor-nullable.sql
No OneTemporary
Actions

Size
2 KB
Referenced Files
None
Subscribers
None

patch-cu_private_event-modify-cupe_actor-nullable.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: extensions/CheckUser/schema/abstractSchemaChanges/patch-cu_private_event-modify-cupe_actor-nullable.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TEMPORARY TABLE /*_*/__temp__cu_private_event AS
SELECT
cupe_id,
cupe_namespace,
cupe_title,
cupe_actor,
cupe_log_type,
cupe_log_action,
cupe_params,
cupe_comment_id,
cupe_page,
cupe_timestamp,
cupe_ip,
cupe_ip_hex,
cupe_xff,
cupe_xff_hex,
cupe_agent,
cupe_private
FROM /*_*/cu_private_event;
DROP TABLE /*_*/cu_private_event;
CREATE TABLE /*_*/cu_private_event (
cupe_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
cupe_namespace INTEGER DEFAULT 0 NOT NULL,
cupe_title BLOB DEFAULT '' NOT NULL,
cupe_actor BIGINT UNSIGNED DEFAULT 0,
cupe_log_type BLOB DEFAULT '' NOT NULL,
cupe_log_action BLOB DEFAULT '' NOT NULL,
cupe_params BLOB NOT NULL,
cupe_comment_id BIGINT UNSIGNED DEFAULT 0 NOT NULL,
cupe_page INTEGER UNSIGNED DEFAULT 0 NOT NULL,
cupe_timestamp BLOB NOT NULL,
cupe_ip VARCHAR(255) DEFAULT '',
cupe_ip_hex VARCHAR(255) DEFAULT NULL,
cupe_xff BLOB DEFAULT '',
cupe_xff_hex VARCHAR(255) DEFAULT NULL,
cupe_agent BLOB DEFAULT NULL,
cupe_private BLOB DEFAULT NULL
);
INSERT INTO /*_*/cu_private_event (
cupe_id, cupe_namespace, cupe_title,
cupe_actor, cupe_log_type, cupe_log_action,
cupe_params, cupe_comment_id, cupe_page,
cupe_timestamp, cupe_ip, cupe_ip_hex,
cupe_xff, cupe_xff_hex, cupe_agent,
cupe_private
)
SELECT
cupe_id,
cupe_namespace,
cupe_title,
cupe_actor,
cupe_log_type,
cupe_log_action,
cupe_params,
cupe_comment_id,
cupe_page,
cupe_timestamp,
cupe_ip,
cupe_ip_hex,
cupe_xff,
cupe_xff_hex,
cupe_agent,
cupe_private
FROM
/*_*/__temp__cu_private_event;
DROP TABLE /*_*/__temp__cu_private_event;
CREATE INDEX cupe_ip_hex_time ON /*_*/cu_private_event (cupe_ip_hex, cupe_timestamp);
CREATE INDEX cupe_xff_hex_time ON /*_*/cu_private_event (cupe_xff_hex, cupe_timestamp);
CREATE INDEX cupe_timestamp ON /*_*/cu_private_event (cupe_timestamp);
CREATE INDEX cupe_actor_ip_time ON /*_*/cu_private_event (
cupe_actor, cupe_ip, cupe_timestamp
);

File Metadata

Mime Type
text/plain
Expires
Sat, Oct 3, 23:32 (2 w, 2 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
5d/18/810c18c010adaa5e5068116ddd88
Default Alt Text
patch-cu_private_event-modify-cupe_actor-nullable.sql (2 KB)

Event Timeline