Page MenuHomeWickedGov Phorge
Files F1427349

patch-cu_changes-drop-cuc_only_for_read_old.sql
No OneTemporary
Actions

Size
2 KB
Referenced Files
None
Subscribers
None

patch-cu_changes-drop-cuc_only_for_read_old.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: extensions/CheckUser/schema/abstractSchemaChanges/patch-cu_changes-drop-cuc_only_for_read_old.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TEMPORARY TABLE /*_*/__temp__cu_changes AS
SELECT
cuc_id,
cuc_namespace,
cuc_title,
cuc_actor,
cuc_actiontext,
cuc_comment_id,
cuc_minor,
cuc_page_id,
cuc_this_oldid,
cuc_last_oldid,
cuc_type,
cuc_timestamp,
cuc_ip,
cuc_ip_hex,
cuc_xff,
cuc_xff_hex,
cuc_agent,
cuc_agent_id,
cuc_private
FROM /*_*/cu_changes;
DROP TABLE /*_*/cu_changes;
CREATE TABLE /*_*/cu_changes (
cuc_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
cuc_namespace INTEGER DEFAULT 0 NOT NULL,
cuc_title BLOB DEFAULT '' NOT NULL,
cuc_actor BIGINT UNSIGNED NOT NULL,
cuc_actiontext BLOB DEFAULT '' NOT NULL,
cuc_comment_id BIGINT UNSIGNED NOT NULL,
cuc_minor SMALLINT DEFAULT 0 NOT NULL,
cuc_page_id INTEGER UNSIGNED DEFAULT 0 NOT NULL,
cuc_this_oldid INTEGER UNSIGNED DEFAULT 0 NOT NULL,
cuc_last_oldid INTEGER UNSIGNED DEFAULT 0 NOT NULL,
cuc_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL,
cuc_timestamp BLOB NOT NULL,
cuc_ip VARCHAR(255) DEFAULT '',
cuc_ip_hex VARCHAR(255) DEFAULT NULL,
cuc_xff BLOB DEFAULT '',
cuc_xff_hex VARCHAR(255) DEFAULT NULL,
cuc_agent BLOB DEFAULT NULL,
cuc_agent_id BIGINT UNSIGNED DEFAULT 0 NOT NULL,
cuc_private BLOB DEFAULT NULL
);
INSERT INTO /*_*/cu_changes (
cuc_id, cuc_namespace, cuc_title,
cuc_actor, cuc_actiontext, cuc_comment_id,
cuc_minor, cuc_page_id, cuc_this_oldid,
cuc_last_oldid, cuc_type, cuc_timestamp,
cuc_ip, cuc_ip_hex, cuc_xff, cuc_xff_hex,
cuc_agent, cuc_agent_id, cuc_private
)
SELECT
cuc_id,
cuc_namespace,
cuc_title,
cuc_actor,
cuc_actiontext,
cuc_comment_id,
cuc_minor,
cuc_page_id,
cuc_this_oldid,
cuc_last_oldid,
cuc_type,
cuc_timestamp,
cuc_ip,
cuc_ip_hex,
cuc_xff,
cuc_xff_hex,
cuc_agent,
cuc_agent_id,
cuc_private
FROM
/*_*/__temp__cu_changes;
DROP TABLE /*_*/__temp__cu_changes;
CREATE INDEX cuc_ip_hex_time ON /*_*/cu_changes (cuc_ip_hex, cuc_timestamp);
CREATE INDEX cuc_xff_hex_time ON /*_*/cu_changes (cuc_xff_hex, cuc_timestamp);
CREATE INDEX cuc_timestamp ON /*_*/cu_changes (cuc_timestamp);
CREATE INDEX cuc_actor_ip_time ON /*_*/cu_changes (cuc_actor, cuc_ip, cuc_timestamp);

File Metadata

Mime Type
text/plain
Expires
Sat, May 16, 14:32 (1 d, 7 h)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
9f/d8/f5331dbf3a472d39a5bb83aecd52
Default Alt Text
patch-cu_changes-drop-cuc_only_for_read_old.sql (2 KB)

Event Timeline