-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: maintenance/abstractSchemaChanges/patch-recentchanges-rc_new_name_timestamp.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP  INDEX rc_timestamp;
DROP  INDEX rc_namespace_title_timestamp;
DROP  INDEX rc_cur_id;
DROP  INDEX new_name_timestamp;
DROP  INDEX rc_ip;
DROP  INDEX rc_ns_actor;
DROP  INDEX rc_actor;
DROP  INDEX rc_name_type_patrolled_timestamp;
DROP  INDEX rc_this_oldid;
CREATE TEMPORARY TABLE /*_*/__temp__recentchanges AS
SELECT  rc_id,  rc_timestamp,  rc_actor,  rc_namespace,  rc_title,  rc_comment_id,  rc_minor,  rc_bot,  rc_new,  rc_cur_id,  rc_this_oldid,  rc_last_oldid,  rc_type,  rc_source,  rc_patrolled,  rc_ip,  rc_old_len,  rc_new_len,  rc_deleted,  rc_logid,  rc_log_type,  rc_log_action,  rc_params
FROM  /*_*/recentchanges;
DROP  TABLE  /*_*/recentchanges;
CREATE TABLE  /*_*/recentchanges (    rc_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,    rc_timestamp BLOB NOT NULL, rc_actor BIGINT UNSIGNED NOT NULL,    rc_namespace INTEGER DEFAULT 0 NOT NULL,    rc_title BLOB DEFAULT '' NOT NULL, rc_comment_id BIGINT UNSIGNED NOT NULL,    rc_minor SMALLINT UNSIGNED DEFAULT 0 NOT NULL,    rc_bot SMALLINT UNSIGNED DEFAULT 0 NOT NULL,    rc_new SMALLINT UNSIGNED DEFAULT 0 NOT NULL,    rc_cur_id INTEGER UNSIGNED DEFAULT 0 NOT NULL,    rc_this_oldid INTEGER UNSIGNED DEFAULT 0 NOT NULL,    rc_last_oldid INTEGER UNSIGNED DEFAULT 0 NOT NULL,    rc_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL,    rc_source BLOB DEFAULT '' NOT NULL,    rc_patrolled SMALLINT UNSIGNED DEFAULT 0 NOT NULL,    rc_ip BLOB DEFAULT '' NOT NULL, rc_old_len INTEGER DEFAULT NULL,    rc_new_len INTEGER DEFAULT NULL, rc_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL,    rc_logid INTEGER UNSIGNED DEFAULT 0 NOT NULL,    rc_log_type BLOB DEFAULT NULL, rc_log_action BLOB DEFAULT NULL,    rc_params BLOB DEFAULT NULL  );
INSERT INTO  /*_*/recentchanges (    rc_id, rc_timestamp, rc_actor, rc_namespace,    rc_title, rc_comment_id, rc_minor,    rc_bot, rc_new, rc_cur_id, rc_this_oldid,    rc_last_oldid, rc_type, rc_source,    rc_patrolled, rc_ip, rc_old_len,    rc_new_len, rc_deleted, rc_logid,    rc_log_type, rc_log_action, rc_params  )
SELECT  rc_id,  rc_timestamp,  rc_actor,  rc_namespace,  rc_title,  rc_comment_id,  rc_minor,  rc_bot,  rc_new,  rc_cur_id,  rc_this_oldid,  rc_last_oldid,  rc_type,  rc_source,  rc_patrolled,  rc_ip,  rc_old_len,  rc_new_len,  rc_deleted,  rc_logid,  rc_log_type,  rc_log_action,  rc_params
FROM  /*_*/__temp__recentchanges;
DROP  TABLE /*_*/__temp__recentchanges;
CREATE INDEX rc_timestamp ON  /*_*/recentchanges (rc_timestamp);
CREATE INDEX rc_namespace_title_timestamp ON  /*_*/recentchanges (    rc_namespace, rc_title, rc_timestamp  );
CREATE INDEX rc_cur_id ON  /*_*/recentchanges (rc_cur_id);
CREATE INDEX rc_ip ON  /*_*/recentchanges (rc_ip);
CREATE INDEX rc_ns_actor ON  /*_*/recentchanges (rc_namespace, rc_actor);
CREATE INDEX rc_actor ON  /*_*/recentchanges (rc_actor, rc_timestamp);
CREATE INDEX rc_name_type_patrolled_timestamp ON  /*_*/recentchanges (    rc_namespace, rc_type, rc_patrolled,    rc_timestamp  );
CREATE INDEX rc_this_oldid ON  /*_*/recentchanges (rc_this_oldid);
CREATE INDEX rc_new_name_timestamp ON  /*_*/recentchanges (    rc_new, rc_namespace, rc_timestamp  );