Viewing File: /home/omtekel/www/wp-content/upgrade/backup/sqlite.tar
archives/patch-protected_titles-pt_title-varbinary.sql 0000666 00000001243 15133471777 0017403 0 ustar 00 CREATE TABLE /*_*/protected_titles_tmp (
pt_namespace INTEGER NOT NULL,
pt_title BLOB NOT NULL,
pt_user INTEGER UNSIGNED NOT NULL,
pt_reason_id BIGINT UNSIGNED NOT NULL,
pt_timestamp BLOB NOT NULL,
pt_expiry BLOB DEFAULT '' NOT NULL,
pt_create_perm BLOB NOT NULL,
PRIMARY KEY(pt_namespace, pt_title)
);
INSERT INTO /*_*/protected_titles_tmp
SELECT pt_namespace, pt_title, pt_user, pt_reason_id, pt_timestamp, pt_expiry, pt_create_perm
FROM /*_*/protected_titles;
DROP TABLE /*_*/protected_titles;
ALTER TABLE /*_*/protected_titles_tmp RENAME TO /*_*/protected_titles;
CREATE INDEX pt_timestamp ON /*_*/protected_titles (pt_timestamp); archives/patch-redirect-rd_title-varbinary.sql 0000666 00000001032 15133471777 0015605 0 ustar 00 CREATE TABLE /*_*/redirect_tmp (
rd_from INTEGER UNSIGNED DEFAULT 0 NOT NULL,
rd_namespace INTEGER DEFAULT 0 NOT NULL,
rd_title BLOB DEFAULT '' NOT NULL,
rd_interwiki VARCHAR(32) DEFAULT NULL,
rd_fragment BLOB DEFAULT NULL,
PRIMARY KEY(rd_from)
);
INSERT INTO /*_*/redirect_tmp
SELECT rd_from, rd_namespace, rd_title, rd_interwiki, rd_fragment
FROM /*_*/redirect;
DROP TABLE /*_*/redirect;
ALTER TABLE /*_*/redirect_tmp RENAME TO /*_*/redirect;
CREATE INDEX rd_ns_title ON /*_*/redirect (rd_namespace, rd_title, rd_from);
archives/patch-categorylinks-cl_to-varbinary.sql 0000666 00000001665 15133471777 0016170 0 ustar 00 CREATE TABLE /*_*/categorylinks_tmp (
cl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL,
cl_to BLOB DEFAULT '' NOT NULL,
cl_sortkey BLOB DEFAULT '' NOT NULL,
cl_sortkey_prefix BLOB DEFAULT '' NOT NULL,
cl_timestamp DATETIME NOT NULL,
cl_collation BLOB DEFAULT '' NOT NULL,
cl_type TEXT DEFAULT 'page' NOT NULL,
PRIMARY KEY(cl_from, cl_to)
);
INSERT INTO /*_*/categorylinks_tmp (cl_from, cl_to, cl_sortkey, cl_sortkey_prefix, cl_timestamp, cl_collation, cl_type)
SELECT cl_from, cl_to, cl_sortkey, cl_sortkey_prefix, cl_timestamp, cl_collation, cl_type
FROM /*_*/categorylinks;
DROP TABLE /*_*/categorylinks;
ALTER TABLE /*_*/categorylinks_tmp RENAME TO /*_*/categorylinks;
CREATE INDEX cl_sortkey ON /*_*/categorylinks (
cl_to, cl_type, cl_sortkey, cl_from
);
CREATE INDEX cl_timestamp ON /*_*/categorylinks (cl_to, cl_timestamp);
CREATE INDEX cl_collation_ext ON /*_*/categorylinks (
cl_collation, cl_to, cl_type, cl_from
);
archives/patch-filearchive-drop-fa_actor-DEFAULT.sql 0000666 00000004126 15133471777 0016275 0 ustar 00 --
-- patch-filearchive-drop-fa_actor-DEFAULT.sql
--
-- T246077. Drop DEFAULT from fa_actor (forgotten in patch-filearchive-drop-fa_user.sql).
BEGIN;
DROP TABLE IF EXISTS /*_*/filearchive_tmp;
CREATE TABLE /*_*/filearchive_tmp (
fa_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
fa_name TEXT NOT NULL default '',
fa_archive_name TEXT default '',
fa_storage_group BLOB,
fa_storage_key BLOB default '',
fa_deleted_user INTEGER,
fa_deleted_timestamp BLOB default '',
fa_deleted_reason_id INTEGER NOT NULL,
fa_size INTEGER default 0,
fa_width INTEGER default 0,
fa_height INTEGER default 0,
fa_metadata BLOB,
fa_bits INTEGER default 0,
fa_media_type TEXT default NULL,
fa_major_mime TEXT default "unknown",
fa_minor_mime BLOB default "unknown",
fa_description_id INTEGER NOT NULL,
fa_actor INTEGER NOT NULL,
fa_timestamp BLOB default '',
fa_deleted INTEGER NOT NULL default 0,
fa_sha1 BLOB NOT NULL default ''
) /*$wgDBTableOptions*/;
INSERT OR IGNORE INTO /*_*/filearchive_tmp (
fa_id, fa_name, fa_archive_name, fa_storage_group, fa_storage_key,
fa_deleted_user, fa_deleted_timestamp, fa_deleted_reason_id,
fa_size, fa_width, fa_height, fa_metadata, fa_bits,
fa_media_type, fa_major_mime, fa_minor_mime, fa_description_id,
fa_actor, fa_timestamp, fa_deleted, fa_sha1
) SELECT
fa_id, fa_name, fa_archive_name, fa_storage_group, fa_storage_key,
fa_deleted_user, fa_deleted_timestamp, fa_deleted_reason_id,
fa_size, fa_width, fa_height, fa_metadata, fa_bits,
fa_media_type, fa_major_mime, fa_minor_mime, fa_description_id,
fa_actor, fa_timestamp, fa_deleted, fa_sha1
FROM /*_*/filearchive;
DROP TABLE /*_*/filearchive;
ALTER TABLE /*_*/filearchive_tmp RENAME TO /*_*/filearchive;
CREATE INDEX /*i*/fa_name ON /*_*/filearchive (fa_name, fa_timestamp);
CREATE INDEX /*i*/fa_storage_group ON /*_*/filearchive (fa_storage_group, fa_storage_key);
CREATE INDEX /*i*/fa_deleted_timestamp ON /*_*/filearchive (fa_deleted_timestamp);
CREATE INDEX /*i*/fa_actor_timestamp ON /*_*/filearchive (fa_actor,fa_timestamp);
CREATE INDEX /*i*/fa_sha1 ON /*_*/filearchive (fa_sha1);
COMMIT;
archives/patch-page-rename-name_title-index.sql 0000666 00000003554 15133471777 0015625 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: maintenance/abstractSchemaChanges/patch-page-rename-name_title-index.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX name_title;
DROP INDEX page_random;
DROP INDEX page_len;
DROP INDEX page_redirect_namespace_len;
CREATE TEMPORARY TABLE /*_*/__temp__page AS
SELECT page_id, page_namespace, page_title, page_is_redirect, page_is_new, page_random, page_touched, page_links_updated, page_latest, page_len, page_content_model, page_lang
FROM /*_*/page;
DROP TABLE /*_*/page;
CREATE TABLE /*_*/page ( page_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, page_namespace INTEGER NOT NULL, page_title BLOB NOT NULL, page_is_redirect SMALLINT DEFAULT 0 NOT NULL, page_is_new SMALLINT DEFAULT 0 NOT NULL, page_random DOUBLE PRECISION NOT NULL, page_touched BLOB NOT NULL, page_links_updated BLOB DEFAULT NULL, page_latest INTEGER UNSIGNED NOT NULL, page_len INTEGER UNSIGNED NOT NULL, page_content_model BLOB DEFAULT NULL, page_lang BLOB DEFAULT NULL );
INSERT INTO /*_*/page ( page_id, page_namespace, page_title, page_is_redirect, page_is_new, page_random, page_touched, page_links_updated, page_latest, page_len, page_content_model, page_lang )
SELECT page_id, page_namespace, page_title, page_is_redirect, page_is_new, page_random, page_touched, page_links_updated, page_latest, page_len, page_content_model, page_lang
FROM /*_*/__temp__page;
DROP TABLE /*_*/__temp__page;
CREATE INDEX page_random ON /*_*/page (page_random);
CREATE INDEX page_len ON /*_*/page (page_len);
CREATE INDEX page_redirect_namespace_len ON /*_*/page ( page_is_redirect, page_namespace, page_len );
CREATE UNIQUE INDEX page_name_title ON /*_*/page (page_namespace, page_title);
archives/patch-oldimage-oi_size_to_bigint.sql 0000666 00000004000 15133471777 0015461 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: abstractSchemaChanges/patch-oldimage-oi_size_to_bigint.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TEMPORARY TABLE /*_*/__temp__oldimage AS
SELECT oi_name, oi_archive_name, oi_size, oi_width, oi_height, oi_bits, oi_description_id, oi_actor, oi_timestamp, oi_metadata, oi_media_type, oi_major_mime, oi_minor_mime, oi_deleted, oi_sha1
FROM /*_*/oldimage;
DROP TABLE /*_*/oldimage;
CREATE TABLE /*_*/oldimage ( oi_name BLOB DEFAULT '' NOT NULL, oi_archive_name BLOB DEFAULT '' NOT NULL, oi_size BIGINT UNSIGNED DEFAULT 0 NOT NULL, oi_width INTEGER DEFAULT 0 NOT NULL, oi_height INTEGER DEFAULT 0 NOT NULL, oi_bits INTEGER DEFAULT 0 NOT NULL, oi_description_id BIGINT UNSIGNED NOT NULL, oi_actor BIGINT UNSIGNED NOT NULL, oi_timestamp BLOB NOT NULL, oi_metadata BLOB NOT NULL, oi_media_type TEXT DEFAULT NULL, oi_major_mime TEXT DEFAULT 'unknown' NOT NULL, oi_minor_mime BLOB DEFAULT 'unknown' NOT NULL, oi_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, oi_sha1 BLOB DEFAULT '' NOT NULL );
INSERT INTO /*_*/oldimage ( oi_name, oi_archive_name, oi_size, oi_width, oi_height, oi_bits, oi_description_id, oi_actor, oi_timestamp, oi_metadata, oi_media_type, oi_major_mime, oi_minor_mime, oi_deleted, oi_sha1 )
SELECT oi_name, oi_archive_name, oi_size, oi_width, oi_height, oi_bits, oi_description_id, oi_actor, oi_timestamp, oi_metadata, oi_media_type, oi_major_mime, oi_minor_mime, oi_deleted, oi_sha1
FROM /*_*/__temp__oldimage;
DROP TABLE /*_*/__temp__oldimage;
CREATE INDEX oi_actor_timestamp ON /*_*/oldimage (oi_actor, oi_timestamp);
CREATE INDEX oi_name_timestamp ON /*_*/oldimage (oi_name, oi_timestamp);
CREATE INDEX oi_name_archive_name ON /*_*/oldimage (oi_name, oi_archive_name);
CREATE INDEX oi_sha1 ON /*_*/oldimage (oi_sha1);
CREATE INDEX oi_timestamp ON /*_*/oldimage (oi_timestamp);archives/patch-ip_changes-pc_rev_timestamp-drop-default.sql 0000666 00000001016 15133471777 0020232 0 ustar 00 CREATE TABLE /*_*/ip_changes_tmp (
ipc_rev_id INTEGER UNSIGNED DEFAULT 0 NOT NULL,
ipc_rev_timestamp BLOB NOT NULL,
ipc_hex BLOB DEFAULT '' NOT NULL,
PRIMARY KEY(ipc_rev_id)
);
INSERT INTO /*_*/ip_changes_tmp
SELECT ipc_rev_id, ipc_rev_timestamp, ipc_hex
FROM /*_*/ip_changes;
DROP TABLE /*_*/ip_changes;
ALTER TABLE /*_*/ip_changes_tmp RENAME TO /*_*/ip_changes;
CREATE INDEX ipc_rev_timestamp ON /*_*/ip_changes (ipc_rev_timestamp);
CREATE INDEX ipc_hex_time ON /*_*/ip_changes (ipc_hex, ipc_rev_timestamp);
archives/patch-revision-rev_timestamp-drop-default.sql 0000666 00000002164 15133471777 0017313 0 ustar 00 CREATE TABLE /*_*/revision_tmp (
rev_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
rev_page INTEGER UNSIGNED NOT NULL,
rev_comment_id BIGINT UNSIGNED DEFAULT 0 NOT NULL,
rev_actor BIGINT UNSIGNED DEFAULT 0 NOT NULL,
rev_timestamp BLOB NOT NULL,
rev_minor_edit SMALLINT UNSIGNED DEFAULT 0 NOT NULL,
rev_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL,
rev_len INTEGER UNSIGNED DEFAULT NULL,
rev_parent_id INTEGER UNSIGNED DEFAULT NULL,
rev_sha1 BLOB DEFAULT '' NOT NULL
);
INSERT INTO /*_*/revision_tmp
SELECT rev_id, rev_page, rev_comment_id, rev_actor, rev_timestamp, rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_sha1
FROM /*_*/revision;
DROP TABLE /*_*/revision;
ALTER TABLE /*_*/revision_tmp RENAME TO /*_*/revision;
CREATE INDEX rev_page_id ON /*_*/revision (rev_page, rev_id);
CREATE INDEX rev_timestamp ON /*_*/revision (rev_timestamp);
CREATE INDEX rev_page_timestamp ON /*_*/revision (rev_page, rev_timestamp);
CREATE INDEX rev_actor_timestamp ON /*_*/revision (rev_actor, rev_timestamp, rev_id);
CREATE INDEX rev_page_actor_timestamp ON /*_*/revision (
rev_page, rev_actor, rev_timestamp
);
archives/patch-recentchanges-drop-rc_actor-DEFAULT.sql 0000666 00000005043 15133471777 0016642 0 ustar 00 --
-- patch-recentchanges-drop-rc_actor-DEFAULT.sql
--
-- T246077. Drop DEFAULT from rc_actor (forgotten in patch-filearchive-drop-rc_user.sql).
BEGIN;
DROP TABLE IF EXISTS /*_*/recentchanges_tmp;
CREATE TABLE /*_*/recentchanges_tmp (
rc_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
rc_timestamp BLOB NOT NULL default '',
rc_actor INTEGER NOT NULL,
rc_namespace INTEGER NOT NULL default 0,
rc_title TEXT NOT NULL default '',
rc_comment_id INTEGER NOT NULL,
rc_minor INTEGER NOT NULL default 0,
rc_bot INTEGER NOT NULL default 0,
rc_new INTEGER NOT NULL default 0,
rc_cur_id INTEGER NOT NULL default 0,
rc_this_oldid INTEGER NOT NULL default 0,
rc_last_oldid INTEGER NOT NULL default 0,
rc_type INTEGER NOT NULL default 0,
rc_source TEXT not null default '',
rc_patrolled INTEGER NOT NULL default 0,
rc_ip BLOB NOT NULL default '',
rc_old_len INTEGER,
rc_new_len INTEGER,
rc_deleted INTEGER NOT NULL default 0,
rc_logid INTEGER NOT NULL default 0,
rc_log_type BLOB NULL default NULL,
rc_log_action BLOB NULL default NULL,
rc_params BLOB NULL
) /*$wgDBTableOptions*/;
INSERT OR IGNORE INTO /*_*/recentchanges_tmp (
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 /*_*/recentchanges;
DROP TABLE /*_*/recentchanges;
ALTER TABLE /*_*/recentchanges_tmp RENAME TO /*_*/recentchanges;
CREATE INDEX /*i*/rc_timestamp ON /*_*/recentchanges (rc_timestamp);
CREATE INDEX /*i*/rc_namespace_title_timestamp ON /*_*/recentchanges (rc_namespace, rc_title, rc_timestamp);
CREATE INDEX /*i*/rc_cur_id ON /*_*/recentchanges (rc_cur_id);
CREATE INDEX /*i*/new_name_timestamp ON /*_*/recentchanges (rc_new,rc_namespace,rc_timestamp);
CREATE INDEX /*i*/rc_ip ON /*_*/recentchanges (rc_ip);
CREATE INDEX /*i*/rc_ns_actor ON /*_*/recentchanges (rc_namespace, rc_actor);
CREATE INDEX /*i*/rc_actor ON /*_*/recentchanges (rc_actor, rc_timestamp);
CREATE INDEX /*i*/rc_name_type_patrolled_timestamp ON /*_*/recentchanges (rc_namespace, rc_type, rc_patrolled, rc_timestamp);
CREATE INDEX /*i*/rc_this_oldid ON /*_*/recentchanges (rc_this_oldid);
COMMIT;
archives/patch-change_tag-rename-indexes.sql 0000666 00000002635 15133471777 0015201 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: maintenance/abstractSchemaChanges/patch-change_tag-rename-indexes.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX change_tag_rc_tag_id;
DROP INDEX change_tag_log_tag_id;
DROP INDEX change_tag_rev_tag_id;
DROP INDEX change_tag_tag_id_id;
CREATE TEMPORARY TABLE /*_*/__temp__change_tag AS
SELECT ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id
FROM /*_*/change_tag;
DROP TABLE /*_*/change_tag;
CREATE TABLE /*_*/change_tag ( ct_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, ct_rc_id INTEGER UNSIGNED DEFAULT NULL, ct_log_id INTEGER UNSIGNED DEFAULT NULL, ct_rev_id INTEGER UNSIGNED DEFAULT NULL, ct_params BLOB DEFAULT NULL, ct_tag_id INTEGER UNSIGNED NOT NULL );
INSERT INTO /*_*/change_tag ( ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id )
SELECT ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id
FROM /*_*/__temp__change_tag;
DROP TABLE /*_*/__temp__change_tag;
CREATE UNIQUE INDEX ct_rc_tag_id ON /*_*/change_tag (ct_rc_id, ct_tag_id);
CREATE UNIQUE INDEX ct_log_tag_id ON /*_*/change_tag (ct_log_id, ct_tag_id);
CREATE UNIQUE INDEX ct_rev_tag_id ON /*_*/change_tag (ct_rev_id, ct_tag_id);
CREATE INDEX ct_tag_id_id ON /*_*/change_tag ( ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id ); archives/patch-archive-rename-name_title_timestamp-index.sql 0000666 00000000175 15133471777 0020411 0 ustar 00 DROP INDEX name_title_timestamp;
CREATE INDEX ar_name_title_timestamp ON /*_*/archive (ar_namespace,ar_title,ar_timestamp);
archives/patch-content_models-model_id-fix_not_null.sql 0000666 00000000601 15133471777 0017473 0 ustar 00 CREATE TABLE /*_*/content_models_tmp (
model_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
model_name BLOB NOT NULL
);
INSERT INTO /*_*/content_models_tmp
SELECT model_id, model_name
FROM /*_*/content_models;
DROP TABLE /*_*/content_models;
ALTER TABLE /*_*/content_models_tmp RENAME TO /*_*/content_models;
CREATE UNIQUE INDEX model_name ON /*_*/content_models (model_name);
archives/patch-image-img_size_to_bigint.sql 0000666 00000003574 15133471777 0015146 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: abstractSchemaChanges/patch-image-img_size_to_bigint.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TEMPORARY TABLE /*_*/__temp__image AS
SELECT img_name, img_size, img_width, img_height, img_metadata, img_bits, img_media_type, img_major_mime, img_minor_mime, img_description_id, img_actor, img_timestamp, img_sha1
FROM /*_*/image;
DROP TABLE /*_*/image;
CREATE TABLE /*_*/image ( img_name BLOB DEFAULT '' NOT NULL, img_size BIGINT UNSIGNED DEFAULT 0 NOT NULL, img_width INTEGER DEFAULT 0 NOT NULL, img_height INTEGER DEFAULT 0 NOT NULL, img_metadata BLOB NOT NULL, img_bits INTEGER DEFAULT 0 NOT NULL, img_media_type TEXT DEFAULT NULL, img_major_mime TEXT DEFAULT 'unknown' NOT NULL, img_minor_mime BLOB DEFAULT 'unknown' NOT NULL, img_description_id BIGINT UNSIGNED NOT NULL, img_actor BIGINT UNSIGNED NOT NULL, img_timestamp BLOB NOT NULL, img_sha1 BLOB DEFAULT '' NOT NULL, PRIMARY KEY(img_name) );
INSERT INTO /*_*/image ( img_name, img_size, img_width, img_height, img_metadata, img_bits, img_media_type, img_major_mime, img_minor_mime, img_description_id, img_actor, img_timestamp, img_sha1 )
SELECT img_name, img_size, img_width, img_height, img_metadata, img_bits, img_media_type, img_major_mime, img_minor_mime, img_description_id, img_actor, img_timestamp, img_sha1
FROM /*_*/__temp__image;
DROP TABLE /*_*/__temp__image;
CREATE INDEX img_actor_timestamp ON /*_*/image (img_actor, img_timestamp);
CREATE INDEX img_size ON /*_*/image (img_size);
CREATE INDEX img_timestamp ON /*_*/image (img_timestamp);
CREATE INDEX img_sha1 ON /*_*/image (img_sha1);
CREATE INDEX img_media_mime ON /*_*/image ( img_media_type, img_major_mime, img_minor_mime ); archives/patch-logging-drop-log_actor-DEFAULT.sql 0000666 00000003167 15133471777 0015641 0 ustar 00 --
-- patch-logging-drop-log_actor-DEFAULT.sql
--
-- T246077. Drop DEFAULT from log_actor (forgotten in patch-filearchive-drop-log_user.sql).
BEGIN;
DROP TABLE IF EXISTS /*_*/logging_tmp;
CREATE TABLE /*_*/logging_tmp (
log_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
log_type BLOB NOT NULL default '',
log_action BLOB NOT NULL default '',
log_timestamp BLOB NOT NULL default '19700101000000',
log_actor INTEGER NOT NULL,
log_namespace INTEGER NOT NULL default 0,
log_title TEXT NOT NULL default '',
log_page INTEGER NULL,
log_comment_id INTEGER NOT NULL,
log_params BLOB NOT NULL,
log_deleted INTEGER NOT NULL default 0
) /*$wgDBTableOptions*/;
INSERT OR IGNORE INTO /*_*/logging_tmp (
log_id, log_type, log_action, log_timestamp, log_actor,
log_namespace, log_title, log_page, log_comment_id, log_params, log_deleted
) SELECT
log_id, log_type, log_action, log_timestamp, log_actor,
log_namespace, log_title, log_page, log_comment_id, log_params, log_deleted
FROM /*_*/logging;
DROP TABLE /*_*/logging;
ALTER TABLE /*_*/logging_tmp RENAME TO /*_*/logging;
CREATE INDEX /*i*/type_time ON /*_*/logging (log_type, log_timestamp);
CREATE INDEX /*i*/actor_time ON /*_*/logging (log_actor, log_timestamp);
CREATE INDEX /*i*/page_time ON /*_*/logging (log_namespace, log_title, log_timestamp);
CREATE INDEX /*i*/times ON /*_*/logging (log_timestamp);
CREATE INDEX /*i*/log_actor_type_time ON /*_*/logging (log_actor, log_type, log_timestamp);
CREATE INDEX /*i*/log_page_id_time ON /*_*/logging (log_page,log_timestamp);
CREATE INDEX /*i*/log_type_action ON /*_*/logging (log_type, log_action, log_timestamp);
COMMIT;
archives/patch-drop-page_restrictions-pr_user.sql 0000666 00000002465 15133471777 0016363 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: maintenance/abstractSchemaChanges/patch-drop-page_restrictions-pr_user.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX pr_pagetype;
DROP INDEX pr_typelevel;
DROP INDEX pr_level;
DROP INDEX pr_cascade;
CREATE TEMPORARY TABLE /*_*/__temp__page_restrictions AS
SELECT pr_id, pr_page, pr_type, pr_level, pr_cascade, pr_expiry
FROM /*_*/page_restrictions;
DROP TABLE /*_*/page_restrictions;
CREATE TABLE /*_*/page_restrictions ( pr_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pr_page INTEGER NOT NULL, pr_type BLOB NOT NULL, pr_level BLOB NOT NULL, pr_cascade SMALLINT NOT NULL, pr_expiry BLOB DEFAULT NULL );
INSERT INTO /*_*/page_restrictions ( pr_id, pr_page, pr_type, pr_level, pr_cascade, pr_expiry )
SELECT pr_id, pr_page, pr_type, pr_level, pr_cascade, pr_expiry
FROM /*_*/__temp__page_restrictions;
DROP TABLE /*_*/__temp__page_restrictions;
CREATE UNIQUE INDEX pr_pagetype ON /*_*/page_restrictions (pr_page, pr_type);
CREATE INDEX pr_typelevel ON /*_*/page_restrictions (pr_type, pr_level);
CREATE INDEX pr_level ON /*_*/page_restrictions (pr_level);
CREATE INDEX pr_cascade ON /*_*/page_restrictions (pr_cascade);
archives/patch-recentchanges-rc_new_name_timestamp.sql 0000666 00000006470 15133471777 0017367 0 ustar 00 -- 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 ); archives/patch-slot_roles-role_id-fix_not_null.sql 0000666 00000000537 15133471777 0016514 0 ustar 00 CREATE TABLE /*_*/slot_roles_tmp (
role_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
role_name BLOB NOT NULL
);
INSERT INTO /*_*/slot_roles_tmp
SELECT role_id, role_name
FROM /*_*/slot_roles;
DROP TABLE /*_*/slot_roles;
ALTER TABLE /*_*/slot_roles_tmp RENAME TO /*_*/slot_roles;
CREATE UNIQUE INDEX role_name ON /*_*/slot_roles (role_name);
archives/patch-watchlist-wl_title-varbinary.sql 0000666 00000001324 15133471777 0016027 0 ustar 00 CREATE TABLE /*_*/watchlist_tmp (
wl_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
wl_user INTEGER UNSIGNED NOT NULL,
wl_namespace INTEGER DEFAULT 0 NOT NULL,
wl_title BLOB DEFAULT '' NOT NULL,
wl_notificationtimestamp BLOB DEFAULT NULL
);
INSERT INTO /*_*/watchlist_tmp
SELECT wl_id, wl_user, wl_namespace, wl_title, wl_notificationtimestamp
FROM /*_*/watchlist;
DROP TABLE /*_*/watchlist;
ALTER TABLE /*_*/watchlist_tmp RENAME TO /*_*/watchlist;
CREATE UNIQUE INDEX wl_user ON /*_*/watchlist (wl_user, wl_namespace, wl_title);
CREATE INDEX namespace_title ON /*_*/watchlist (wl_namespace, wl_title);
CREATE INDEX wl_user_notificationtimestamp ON /*_*/watchlist (
wl_user, wl_notificationtimestamp
); archives/patch-ipblocks-fix-ipb_address_unique.sql 0000666 00000000211 15133471777 0016440 0 ustar 00 DROP INDEX /*i*/ipb_address_unique;
CREATE UNIQUE INDEX /*i*/ipb_address_unique ON /*_*/ipblocks (ipb_address(255), ipb_user, ipb_auto);
archives/patch-ipblocks_restrictions-ir_ipb_id.sql 0000666 00000001671 15133471777 0016552 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: maintenance/abstractSchemaChanges/patch-ipblocks_restrictions-ir_ipb_id.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX ir_type_value;
CREATE TEMPORARY TABLE /*_*/__temp__ipblocks_restrictions AS
SELECT ir_ipb_id, ir_type, ir_value
FROM /*_*/ipblocks_restrictions;
DROP TABLE /*_*/ipblocks_restrictions;
CREATE TABLE /*_*/ipblocks_restrictions ( ir_ipb_id INTEGER UNSIGNED NOT NULL, ir_type SMALLINT NOT NULL, ir_value INTEGER UNSIGNED NOT NULL, PRIMARY KEY(ir_ipb_id, ir_type, ir_value) );
INSERT INTO /*_*/ipblocks_restrictions (ir_ipb_id, ir_type, ir_value)
SELECT ir_ipb_id, ir_type, ir_value
FROM /*_*/__temp__ipblocks_restrictions;
DROP TABLE /*_*/__temp__ipblocks_restrictions;
CREATE INDEX ir_type_value ON /*_*/ipblocks_restrictions (ir_type, ir_value); archives/patch-protected_titles-pt_expiry-drop-default.sql 0000666 00000001206 15133471777 0020172 0 ustar 00 CREATE TABLE /*_*/protected_titles_tmp (
pt_namespace INTEGER NOT NULL,
pt_title BLOB NOT NULL,
pt_user INTEGER UNSIGNED NOT NULL,
pt_reason_id BIGINT UNSIGNED NOT NULL,
pt_timestamp BLOB NOT NULL,
pt_expiry BLOB NOT NULL,
pt_create_perm BLOB NOT NULL,
PRIMARY KEY(pt_namespace, pt_title)
);
INSERT INTO /*_*/protected_titles_tmp
SELECT pt_namespace, pt_title, pt_user, pt_reason_id, pt_timestamp, pt_expiry, pt_create_perm
FROM /*_*/protected_titles;
DROP TABLE /*_*/protected_titles;
ALTER TABLE /*_*/protected_titles_tmp RENAME TO /*_*/protected_titles;
CREATE INDEX pt_timestamp ON /*_*/protected_titles (pt_timestamp);
archives/patch-uploadstash-us_size_to_bigint.sql 0000666 00000003750 15133471777 0016262 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: abstractSchemaChanges/patch-uploadstash-us_size_to_bigint.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TEMPORARY TABLE /*_*/__temp__uploadstash AS
SELECT us_id, us_user, us_key, us_orig_path, us_path, us_source_type, us_timestamp, us_status, us_chunk_inx, us_props, us_size, us_sha1, us_mime, us_media_type, us_image_width, us_image_height, us_image_bits
FROM /*_*/uploadstash;
DROP TABLE /*_*/uploadstash;
CREATE TABLE /*_*/uploadstash ( us_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, us_user INTEGER UNSIGNED NOT NULL, us_key VARCHAR(255) NOT NULL, us_orig_path VARCHAR(255) NOT NULL, us_path VARCHAR(255) NOT NULL, us_source_type VARCHAR(50) DEFAULT NULL, us_timestamp BLOB NOT NULL, us_status VARCHAR(50) NOT NULL, us_chunk_inx INTEGER UNSIGNED DEFAULT NULL, us_props BLOB DEFAULT NULL, us_size BIGINT UNSIGNED NOT NULL, us_sha1 VARCHAR(31) NOT NULL, us_mime VARCHAR(255) DEFAULT NULL, us_media_type TEXT DEFAULT NULL, us_image_width INTEGER UNSIGNED DEFAULT NULL, us_image_height INTEGER UNSIGNED DEFAULT NULL, us_image_bits SMALLINT UNSIGNED DEFAULT NULL );
INSERT INTO /*_*/uploadstash ( us_id, us_user, us_key, us_orig_path, us_path, us_source_type, us_timestamp, us_status, us_chunk_inx, us_props, us_size, us_sha1, us_mime, us_media_type, us_image_width, us_image_height, us_image_bits )
SELECT us_id, us_user, us_key, us_orig_path, us_path, us_source_type, us_timestamp, us_status, us_chunk_inx, us_props, us_size, us_sha1, us_mime, us_media_type, us_image_width, us_image_height, us_image_bits
FROM /*_*/__temp__uploadstash;
DROP TABLE /*_*/__temp__uploadstash;
CREATE INDEX us_user ON /*_*/uploadstash (us_user);
CREATE UNIQUE INDEX us_key ON /*_*/uploadstash (us_key);
CREATE INDEX us_timestamp ON /*_*/uploadstash (us_timestamp); archives/patch-ipblocks-ipb_timestamp-drop-default.sql 0000666 00000003552 15133471777 0017243 0 ustar 00 CREATE TABLE /*_*/ipblocks_tmp (
ipb_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
ipb_address BLOB NOT NULL, ipb_user INTEGER UNSIGNED DEFAULT 0 NOT NULL,
ipb_by_actor BIGINT UNSIGNED NOT NULL,
ipb_reason_id BIGINT UNSIGNED NOT NULL,
ipb_timestamp BLOB NOT NULL, ipb_auto SMALLINT DEFAULT 0 NOT NULL,
ipb_anon_only SMALLINT DEFAULT 0 NOT NULL,
ipb_create_account SMALLINT DEFAULT 1 NOT NULL,
ipb_enable_autoblock SMALLINT DEFAULT 1 NOT NULL,
ipb_expiry BLOB NOT NULL, ipb_range_start BLOB NOT NULL,
ipb_range_end BLOB NOT NULL, ipb_deleted SMALLINT DEFAULT 0 NOT NULL,
ipb_block_email SMALLINT DEFAULT 0 NOT NULL,
ipb_allow_usertalk SMALLINT DEFAULT 0 NOT NULL,
ipb_parent_block_id INTEGER DEFAULT NULL,
ipb_sitewide SMALLINT DEFAULT 1 NOT NULL
);
INSERT INTO /*_*/ipblocks_tmp (
ipb_id, ipb_address, ipb_user, ipb_by_actor, ipb_reason_id, ipb_timestamp,
ipb_auto, ipb_anon_only, ipb_create_account, ipb_enable_autoblock, ipb_expiry,
ipb_range_start, ipb_range_end, ipb_deleted, ipb_block_email, ipb_allow_usertalk,
ipb_parent_block_id, ipb_sitewide
)
SELECT
ipb_id, ipb_address, ipb_user, ipb_by_actor, ipb_reason_id, ipb_timestamp,
ipb_auto, ipb_anon_only, ipb_create_account, ipb_enable_autoblock, ipb_expiry,
ipb_range_start, ipb_range_end, ipb_deleted, ipb_block_email, ipb_allow_usertalk,
ipb_parent_block_id, ipb_sitewide
FROM /*_*/ipblocks;
DROP TABLE /*_*/ipblocks;
ALTER TABLE /*_*/ipblocks_tmp RENAME TO /*_*/ipblocks;
CREATE UNIQUE INDEX ipb_address_unique ON /*_*/ipblocks (ipb_address, ipb_user, ipb_auto);
CREATE INDEX ipb_user ON /*_*/ipblocks (ipb_user);
CREATE INDEX ipb_range ON /*_*/ipblocks (ipb_range_start, ipb_range_end);
CREATE INDEX ipb_timestamp ON /*_*/ipblocks (ipb_timestamp);
CREATE INDEX ipb_expiry ON /*_*/ipblocks (ipb_expiry);
CREATE INDEX ipb_parent_block_id ON /*_*/ipblocks (ipb_parent_block_id);
archives/patch-filearchive-fa_size_to_bigint.sql 0000666 00000005103 15133471777 0016145 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: abstractSchemaChanges/patch-filearchive-fa_size_to_bigint.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TEMPORARY TABLE /*_*/__temp__filearchive AS
SELECT fa_id, fa_name, fa_archive_name, fa_storage_group, fa_storage_key, fa_deleted_user, fa_deleted_timestamp, fa_deleted_reason_id, fa_size, fa_width, fa_height, fa_metadata, fa_bits, fa_media_type, fa_major_mime, fa_minor_mime, fa_description_id, fa_actor, fa_timestamp, fa_deleted, fa_sha1
FROM /*_*/filearchive;
DROP TABLE /*_*/filearchive;
CREATE TABLE /*_*/filearchive ( fa_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, fa_name BLOB DEFAULT '' NOT NULL, fa_archive_name BLOB DEFAULT '', fa_storage_group BLOB DEFAULT NULL, fa_storage_key BLOB DEFAULT '', fa_deleted_user INTEGER DEFAULT NULL, fa_deleted_timestamp BLOB DEFAULT NULL, fa_deleted_reason_id BIGINT UNSIGNED NOT NULL, fa_size BIGINT UNSIGNED DEFAULT 0, fa_width INTEGER DEFAULT 0, fa_height INTEGER DEFAULT 0, fa_metadata BLOB DEFAULT NULL, fa_bits INTEGER DEFAULT 0, fa_media_type TEXT DEFAULT NULL, fa_major_mime TEXT DEFAULT 'unknown', fa_minor_mime BLOB DEFAULT 'unknown', fa_description_id BIGINT UNSIGNED NOT NULL, fa_actor BIGINT UNSIGNED NOT NULL, fa_timestamp BLOB DEFAULT NULL, fa_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, fa_sha1 BLOB DEFAULT '' NOT NULL );
INSERT INTO /*_*/filearchive ( fa_id, fa_name, fa_archive_name, fa_storage_group, fa_storage_key, fa_deleted_user, fa_deleted_timestamp, fa_deleted_reason_id, fa_size, fa_width, fa_height, fa_metadata, fa_bits, fa_media_type, fa_major_mime, fa_minor_mime, fa_description_id, fa_actor, fa_timestamp, fa_deleted, fa_sha1 )
SELECT fa_id, fa_name, fa_archive_name, fa_storage_group, fa_storage_key, fa_deleted_user, fa_deleted_timestamp, fa_deleted_reason_id, fa_size, fa_width, fa_height, fa_metadata, fa_bits, fa_media_type, fa_major_mime, fa_minor_mime, fa_description_id, fa_actor, fa_timestamp, fa_deleted, fa_sha1
FROM /*_*/__temp__filearchive;
DROP TABLE /*_*/__temp__filearchive;
CREATE INDEX fa_name ON /*_*/filearchive (fa_name, fa_timestamp);
CREATE INDEX fa_storage_group ON /*_*/filearchive ( fa_storage_group, fa_storage_key );
CREATE INDEX fa_deleted_timestamp ON /*_*/filearchive (fa_deleted_timestamp);
CREATE INDEX fa_actor_timestamp ON /*_*/filearchive (fa_actor, fa_timestamp);
CREATE INDEX fa_sha1 ON /*_*/filearchive (fa_sha1); archives/patch-content-content_id-fix_not_null.sql 0000666 00000000700 15133471777 0016502 0 ustar 00 CREATE TABLE /*_*/content_tmp (
content_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
content_size INTEGER UNSIGNED NOT NULL,
content_sha1 BLOB NOT NULL,
content_model SMALLINT UNSIGNED NOT NULL,
content_address BLOB NOT NULL
);
INSERT INTO /*_*/content_tmp
SELECT content_id, content_size, content_sha1, content_model, content_address
FROM /*_*/content;
DROP TABLE /*_*/content;
ALTER TABLE /*_*/content_tmp RENAME TO /*_*/content;
archives/patch-watchlist-namespace_title-rename-index.sql 0000666 00000002436 15133471777 0017725 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: maintenance/abstractSchemaChanges/patch-watchlist-namespace_title-rename-index.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX wl_user;
DROP INDEX namespace_title;
DROP INDEX wl_user_notificationtimestamp;
CREATE TEMPORARY TABLE /*_*/__temp__watchlist AS
SELECT wl_id, wl_user, wl_namespace, wl_title, wl_notificationtimestamp
FROM /*_*/watchlist;
DROP TABLE /*_*/watchlist;
CREATE TABLE /*_*/watchlist ( wl_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, wl_user INTEGER UNSIGNED NOT NULL, wl_namespace INTEGER DEFAULT 0 NOT NULL, wl_title BLOB DEFAULT '' NOT NULL, wl_notificationtimestamp BLOB DEFAULT NULL );
INSERT INTO /*_*/watchlist ( wl_id, wl_user, wl_namespace, wl_title, wl_notificationtimestamp )
SELECT wl_id, wl_user, wl_namespace, wl_title, wl_notificationtimestamp
FROM /*_*/__temp__watchlist;
DROP TABLE /*_*/__temp__watchlist;
CREATE UNIQUE INDEX wl_user ON /*_*/watchlist (wl_user, wl_namespace, wl_title);
CREATE INDEX wl_user_notificationtimestamp ON /*_*/watchlist ( wl_user, wl_notificationtimestamp );
CREATE INDEX wl_namespace_title ON /*_*/watchlist (wl_namespace, wl_title); archives/patch-category-cat_title-varbinary.sql 0000666 00000001041 15133471777 0015763 0 ustar 00 CREATE TABLE /*_*/category_tmp (
cat_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
cat_title BLOB NOT NULL,
cat_pages INTEGER DEFAULT 0 NOT NULL,
cat_subcats INTEGER DEFAULT 0 NOT NULL,
cat_files INTEGER DEFAULT 0 NOT NULL
);
INSERT INTO /*_*/category_tmp
SELECT cat_id, cat_title, cat_pages, cat_subcats, cat_files
FROM /*_*/category;
DROP TABLE /*_*/category;
ALTER TABLE /*_*/category_tmp RENAME TO /*_*/category;
CREATE UNIQUE INDEX cat_title ON /*_*/category (cat_title);
CREATE INDEX cat_pages ON /*_*/category (cat_pages);
patch-drop_afl_log_id.sql 0000666 00000003313 15133477433 0011503 0 ustar 00 -- This monster is just an `ALTER TABLE abuse_filter_log DROP COLUMN afl_log_id`
BEGIN;
DROP TABLE IF EXISTS /*_*/abuse_filter_log_tmp;
CREATE TABLE /*_*/abuse_filter_log_tmp (
afl_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
afl_filter varbinary(64) NOT NULL,
afl_user BIGINT unsigned NOT NULL,
afl_user_text varbinary(255) NOT NULL,
afl_ip varbinary(255) not null,
afl_action varbinary(255) not null,
afl_actions varbinary(255) not null,
afl_var_dump BLOB NOT NULL,
afl_timestamp varbinary(14) NOT NULL,
afl_namespace int NOT NULL,
afl_title varbinary(255) NOT NULL,
afl_wiki varbinary(64) NULL,
afl_deleted tinyint(1) NOT NULL DEFAULT 0,
afl_patrolled_by int unsigned NULL,
afl_rev_id int unsigned
) /*$wgDBTableOptions*/;
INSERT INTO abuse_filter_log_tmp
SELECT afl_id, afl_filter, afl_user, afl_user_text, afl_ip, afl_action, afl_actions, afl_var_dump,
afl_timestamp, afl_namespace, afl_title, afl_wiki, afl_deleted, afl_patrolled_by, afl_rev_id
FROM /*_*/abuse_filter_log;
DROP TABLE /*_*/abuse_filter_log;
ALTER TABLE /*_*/abuse_filter_log_tmp RENAME TO /*_*/abuse_filter_log;
CREATE INDEX /*i*/afl_filter_timestamp ON /*_*/abuse_filter_log (afl_filter,afl_timestamp);
CREATE INDEX /*i*/afl_user_timestamp ON /*_*/abuse_filter_log (afl_user,afl_user_text,afl_timestamp);
CREATE INDEX /*i*/afl_timestamp ON /*_*/abuse_filter_log (afl_timestamp);
CREATE INDEX /*i*/afl_page_timestamp ON /*_*/abuse_filter_log (afl_namespace, afl_title, afl_timestamp);
CREATE INDEX /*i*/afl_ip_timestamp ON /*_*/abuse_filter_log (afl_ip, afl_timestamp);
CREATE INDEX /*i*/afl_wiki_timestamp ON /*_*/abuse_filter_log (afl_wiki, afl_timestamp);
CREATE INDEX /*i*/afl_rev_id ON /*_*/abuse_filter_log (afl_rev_id);
COMMIT; patch-add-afh_actor.sql 0000666 00000004147 15133477433 0011062 0 ustar 00 -- 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); tables-generated.sql 0000666 00000006747 15133477433 0010527 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaSql.php.
-- Source: db_patches/tables.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TABLE /*_*/abuse_filter (
af_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
af_pattern BLOB NOT NULL,
af_user BIGINT UNSIGNED DEFAULT 0 NOT NULL,
af_user_text BLOB DEFAULT '' NOT NULL,
af_actor BIGINT UNSIGNED DEFAULT 0 NOT NULL,
af_timestamp BLOB NOT NULL,
af_enabled SMALLINT DEFAULT 1 NOT NULL,
af_comments BLOB DEFAULT NULL,
af_public_comments BLOB DEFAULT NULL,
af_hidden SMALLINT DEFAULT 0 NOT NULL,
af_hit_count BIGINT DEFAULT 0 NOT NULL,
af_throttled SMALLINT DEFAULT 0 NOT NULL,
af_deleted SMALLINT DEFAULT 0 NOT NULL,
af_actions VARCHAR(255) DEFAULT '' NOT NULL,
af_global SMALLINT DEFAULT 0 NOT NULL,
af_group BLOB DEFAULT 'default' NOT NULL
);
CREATE INDEX af_user ON /*_*/abuse_filter (af_user);
CREATE INDEX af_actor ON /*_*/abuse_filter (af_actor);
CREATE INDEX af_group_enabled ON /*_*/abuse_filter (af_group, af_enabled, af_id);
CREATE TABLE /*_*/abuse_filter_action (
afa_filter BIGINT UNSIGNED NOT NULL,
afa_consequence VARCHAR(255) NOT NULL,
afa_parameters BLOB NOT NULL,
PRIMARY KEY(afa_filter, afa_consequence)
);
CREATE INDEX afa_consequence ON /*_*/abuse_filter_action (afa_consequence);
CREATE TABLE /*_*/abuse_filter_log (
afl_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
afl_global SMALLINT NOT NULL,
afl_filter_id BIGINT UNSIGNED NOT NULL,
afl_user BIGINT UNSIGNED NOT NULL,
afl_user_text BLOB NOT NULL,
afl_ip VARCHAR(255) NOT NULL,
afl_action BLOB NOT NULL,
afl_actions BLOB NOT NULL,
afl_var_dump BLOB NOT NULL,
afl_timestamp BLOB NOT NULL,
afl_namespace INTEGER NOT NULL,
afl_title BLOB NOT NULL,
afl_wiki BLOB DEFAULT NULL,
afl_deleted SMALLINT DEFAULT 0 NOT NULL,
afl_patrolled_by INTEGER UNSIGNED DEFAULT 0 NOT NULL,
afl_rev_id INTEGER UNSIGNED DEFAULT NULL
);
CREATE INDEX afl_filter_timestamp_full ON /*_*/abuse_filter_log (
afl_global, afl_filter_id, afl_timestamp
);
CREATE INDEX afl_user_timestamp ON /*_*/abuse_filter_log (
afl_user, afl_user_text, afl_timestamp
);
CREATE INDEX afl_timestamp ON /*_*/abuse_filter_log (afl_timestamp);
CREATE INDEX afl_page_timestamp ON /*_*/abuse_filter_log (
afl_namespace, afl_title, afl_timestamp
);
CREATE INDEX afl_ip_timestamp ON /*_*/abuse_filter_log (afl_ip, afl_timestamp);
CREATE INDEX afl_rev_id ON /*_*/abuse_filter_log (afl_rev_id);
CREATE INDEX afl_wiki_timestamp ON /*_*/abuse_filter_log (afl_wiki, afl_timestamp);
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_actor BIGINT UNSIGNED DEFAULT 0 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
);
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_actor ON /*_*/abuse_filter_history (afh_actor);
CREATE INDEX afh_timestamp ON /*_*/abuse_filter_history (afh_timestamp);
patch-split-afl_filter.sql 0000666 00000004112 15133477433 0011636 0 ustar 00 -- Split afl_filter into afl_filter_id and afl_global
BEGIN;
DROP TABLE IF EXISTS /*_*/abuse_filter_log_tmp;
CREATE TABLE /*_*/abuse_filter_log_tmp (
afl_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
afl_filter varbinary(64) NOT NULL DEFAULT '',
afl_global tinyint(1) NOT NULL DEFAULT 0,
afl_filter_id INTEGER NOT NULL DEFAULT 0,
afl_user BIGINT unsigned NOT NULL,
afl_user_text varbinary(255) NOT NULL,
afl_ip varbinary(255) not null,
afl_action varbinary(255) not null,
afl_actions varbinary(255) not null,
afl_var_dump BLOB NOT NULL,
afl_timestamp varbinary(14) NOT NULL,
afl_namespace int NOT NULL,
afl_title varbinary(255) NOT NULL,
afl_wiki varbinary(64) NULL,
afl_deleted tinyint(1) NOT NULL DEFAULT 0,
afl_patrolled_by int unsigned NULL,
afl_rev_id int unsigned
) /*$wgDBTableOptions*/;
INSERT OR IGNORE INTO /*_*/abuse_filter_log_tmp (
afl_id, afl_filter, afl_user, afl_user_text, afl_ip,
afl_action, afl_actions, afl_var_dump, afl_timestamp, afl_namespace, afl_title,
afl_wiki, afl_deleted, afl_patrolled_by, afl_rev_id )
SELECT
afl_id, afl_filter, afl_user, afl_user_text, afl_ip,
afl_action, afl_actions, afl_var_dump, afl_timestamp, afl_namespace, afl_title,
afl_wiki, afl_deleted, afl_patrolled_by, afl_rev_id
FROM /*_*/abuse_filter_log;
DROP TABLE /*_*/abuse_filter_log;
ALTER TABLE /*_*/abuse_filter_log_tmp RENAME TO /*_*/abuse_filter_log;
CREATE INDEX /*i*/afl_filter_timestamp ON /*_*/abuse_filter_log (afl_filter,afl_timestamp);
CREATE INDEX /*i*/afl_filter_timestamp_full ON /*_*/abuse_filter_log (afl_global,afl_filter_id,afl_timestamp);
CREATE INDEX /*i*/afl_user_timestamp ON /*_*/abuse_filter_log (afl_user,afl_user_text,afl_timestamp);
CREATE INDEX /*i*/afl_timestamp ON /*_*/abuse_filter_log (afl_timestamp);
CREATE INDEX /*i*/afl_page_timestamp ON /*_*/abuse_filter_log (afl_namespace, afl_title, afl_timestamp);
CREATE INDEX /*i*/afl_ip_timestamp ON /*_*/abuse_filter_log (afl_ip, afl_timestamp);
CREATE INDEX /*i*/afl_wiki_timestamp ON /*_*/abuse_filter_log (afl_wiki, afl_timestamp);
CREATE INDEX /*i*/afl_rev_id ON /*_*/abuse_filter_log (afl_rev_id);
COMMIT; patch-add-af_actor.sql 0000666 00000003764 15133477433 0010716 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: db_patches/abstractSchemaChanges/patch-add-af_actor.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX af_user;
DROP INDEX af_group_enabled;
CREATE TEMPORARY TABLE /*_*/__temp__abuse_filter AS
SELECT af_id, af_pattern, af_user, af_user_text, af_timestamp, af_enabled, af_comments, af_public_comments, af_hidden, af_hit_count, af_throttled, af_deleted, af_actions, af_global, af_group
FROM /*_*/abuse_filter;
DROP TABLE /*_*/abuse_filter;
CREATE TABLE /*_*/abuse_filter ( af_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, af_pattern BLOB NOT NULL, af_user BIGINT UNSIGNED DEFAULT 0 NOT NULL, af_user_text BLOB DEFAULT '' NOT NULL, af_timestamp BLOB NOT NULL, af_enabled SMALLINT DEFAULT 1 NOT NULL, af_comments BLOB DEFAULT NULL, af_public_comments BLOB DEFAULT NULL, af_hidden SMALLINT DEFAULT 0 NOT NULL, af_hit_count BIGINT DEFAULT 0 NOT NULL, af_throttled SMALLINT DEFAULT 0 NOT NULL, af_deleted SMALLINT DEFAULT 0 NOT NULL, af_actions VARCHAR(255) DEFAULT '' NOT NULL, af_global SMALLINT DEFAULT 0 NOT NULL, af_group BLOB DEFAULT 'default' NOT NULL, af_actor BIGINT UNSIGNED DEFAULT 0 NOT NULL );
INSERT INTO /*_*/abuse_filter ( af_id, af_pattern, af_user, af_user_text, af_timestamp, af_enabled, af_comments, af_public_comments, af_hidden, af_hit_count, af_throttled, af_deleted, af_actions, af_global, af_group )
SELECT af_id, af_pattern, af_user, af_user_text, af_timestamp, af_enabled, af_comments, af_public_comments, af_hidden, af_hit_count, af_throttled, af_deleted, af_actions, af_global, af_group
FROM /*_*/__temp__abuse_filter;
DROP TABLE /*_*/__temp__abuse_filter;
CREATE INDEX af_user ON /*_*/abuse_filter (af_user);
CREATE INDEX af_group_enabled ON /*_*/abuse_filter (af_group, af_enabled, af_id);
CREATE INDEX af_actor ON /*_*/abuse_filter (af_actor); patch-remove-afl_filter.sql 0000666 00000003336 15133477433 0012007 0 ustar 00 BEGIN;
DROP TABLE IF EXISTS /*_*/abuse_filter_log_tmp;
CREATE TABLE /*_*/abuse_filter_log_tmp (
afl_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
afl_global tinyint(1) NOT NULL,
afl_filter_id INTEGER NOT NULL,
afl_user BIGINT unsigned NOT NULL,
afl_user_text varbinary(255) NOT NULL,
afl_ip varbinary(255) not null,
afl_action varbinary(255) not null,
afl_actions varbinary(255) not null,
afl_var_dump BLOB NOT NULL,
afl_timestamp varbinary(14) NOT NULL,
afl_namespace int NOT NULL,
afl_title varbinary(255) NOT NULL,
afl_wiki varbinary(64) NULL,
afl_deleted tinyint(1) NOT NULL DEFAULT 0,
afl_patrolled_by int unsigned NOT NULL DEFAULT 0,
afl_rev_id int unsigned
) /*$wgDBTableOptions*/;
INSERT INTO abuse_filter_log_tmp
-- all but afl_filter
SELECT afl_id, afl_global, afl_filter_id, afl_user, afl_user_text, afl_ip, afl_action,
afl_actions, afl_var_dump, afl_timestamp, afl_namespace, afl_title, afl_wiki,
afl_deleted, afl_patrolled_by, afl_rev_id
FROM /*_*/abuse_filter_log;
DROP TABLE /*_*/abuse_filter_log;
ALTER TABLE /*_*/abuse_filter_log_tmp RENAME TO /*_*/abuse_filter_log;
CREATE INDEX /*i*/afl_filter_timestamp_full ON /*_*/abuse_filter_log (afl_global,afl_filter_id,afl_timestamp);
CREATE INDEX /*i*/afl_user_timestamp ON /*_*/abuse_filter_log (afl_user,afl_user_text,afl_timestamp);
CREATE INDEX /*i*/afl_timestamp ON /*_*/abuse_filter_log (afl_timestamp);
CREATE INDEX /*i*/afl_page_timestamp ON /*_*/abuse_filter_log (afl_namespace, afl_title, afl_timestamp);
CREATE INDEX /*i*/afl_ip_timestamp ON /*_*/abuse_filter_log (afl_ip, afl_timestamp);
CREATE INDEX /*i*/afl_wiki_timestamp ON /*_*/abuse_filter_log (afl_wiki, afl_timestamp);
CREATE INDEX /*i*/afl_rev_id ON /*_*/abuse_filter_log (afl_rev_id);
COMMIT; patch-linter-template-tag-fields.sql 0000666 00000003221 15133503622 0013507 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: abstractSchemaChanges/patch-linter-add-template-tag-fields.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX linter_page;
DROP INDEX linter_cat_namespace;
DROP INDEX linter_cat_page_position;
CREATE TEMPORARY TABLE /*_*/__temp__linter AS
SELECT linter_id, linter_page, linter_namespace, linter_cat, linter_start, linter_end, linter_params
FROM /*_*/linter;
DROP TABLE /*_*/linter;
CREATE TABLE /*_*/linter ( linter_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, linter_page INTEGER UNSIGNED NOT NULL, linter_namespace INTEGER DEFAULT NULL, linter_cat INTEGER UNSIGNED NOT NULL, linter_start INTEGER UNSIGNED NOT NULL, linter_end INTEGER UNSIGNED NOT NULL, linter_params BLOB DEFAULT NULL, linter_template BLOB DEFAULT '' NOT NULL, linter_tag BLOB DEFAULT '' NOT NULL );
INSERT INTO /*_*/linter ( linter_id, linter_page, linter_namespace, linter_cat, linter_start, linter_end, linter_params )
SELECT linter_id, linter_page, linter_namespace, linter_cat, linter_start, linter_end, linter_params
FROM /*_*/__temp__linter;
DROP TABLE /*_*/__temp__linter;
CREATE INDEX linter_page ON /*_*/linter (linter_page);
CREATE INDEX linter_cat_namespace ON /*_*/linter (linter_cat, linter_namespace);
CREATE UNIQUE INDEX linter_cat_page_position ON /*_*/linter ( linter_cat, linter_page, linter_start, linter_end );
CREATE INDEX linter_cat_template ON /*_*/linter (linter_cat, linter_template);
CREATE INDEX linter_cat_tag ON /*_*/linter (linter_cat, linter_tag); patch-linter-fix-params-null-definition.sql 0000666 00000003215 15133503622 0015027 0 ustar 00 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: abstractSchemaChanges/patch-linter-fix-params-null-definition.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TEMPORARY TABLE /*_*/__temp__linter AS
SELECT linter_id, linter_page, linter_namespace, linter_cat, linter_start, linter_end, linter_params, linter_template, linter_tag
FROM /*_*/linter;
DROP TABLE /*_*/linter;
CREATE TABLE /*_*/linter ( linter_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, linter_page INTEGER UNSIGNED NOT NULL, linter_namespace INTEGER DEFAULT NULL, linter_cat INTEGER UNSIGNED NOT NULL, linter_start INTEGER UNSIGNED NOT NULL, linter_end INTEGER UNSIGNED NOT NULL, linter_params BLOB NOT NULL, linter_template BLOB DEFAULT '' NOT NULL, linter_tag BLOB DEFAULT '' NOT NULL );
INSERT INTO /*_*/linter ( linter_id, linter_page, linter_namespace, linter_cat, linter_start, linter_end, linter_params, linter_template, linter_tag )
SELECT linter_id, linter_page, linter_namespace, linter_cat, linter_start, linter_end, linter_params, linter_template, linter_tag
FROM /*_*/__temp__linter;
DROP TABLE /*_*/__temp__linter;
CREATE INDEX linter_page ON /*_*/linter (linter_page);
CREATE INDEX linter_cat_namespace ON /*_*/linter (linter_cat, linter_namespace);
CREATE UNIQUE INDEX linter_cat_page_position ON /*_*/linter ( linter_cat, linter_page, linter_start, linter_end );
CREATE INDEX linter_cat_template ON /*_*/linter (linter_cat, linter_template);
CREATE INDEX linter_cat_tag ON /*_*/linter (linter_cat, linter_tag); patch-cleanup-push_subscription-foreign-keys-indexes.sql 0000666 00000002253 15133505731 0017640 0 ustar 00 -- Drop foreign keys from echo_push_subscription and rename index to match table prefix - T306473
DROP TABLE IF EXISTS /*_*/echo_push_subscription_tmp;
CREATE TABLE /*_*/echo_push_subscription_tmp (
eps_id INT UNSIGNED NOT NULL PRIMARY KEY auto_increment,
eps_user INT UNSIGNED NOT NULL,
eps_token BLOB NOT NULL,
eps_token_sha256 CHAR(64) NOT NULL,
eps_provider TINYINT UNSIGNED NOT NULL,
eps_updated TIMESTAMP NOT NULL,
eps_data BLOB,
eps_topic TINYINT UNSIGNED
) /*$wgDBTableOptions*/;
INSERT INTO /*_*/echo_push_subscription_tmp
SELECT eps_id, eps_user, eps_token, eps_token_sha256, eps_provider, eps_updated, eps_data, eps_topic
FROM /*_*/echo_push_subscription;
DROP TABLE /*_*/echo_push_subscription;
ALTER TABLE /*_*/echo_push_subscription_tmp RENAME TO /*_*/echo_push_subscription;
CREATE UNIQUE INDEX /*i*/eps_token_sha256 ON /*_*/echo_push_subscription (eps_token_sha256);
CREATE INDEX /*i*/eps_provider ON /*_*/echo_push_subscription (eps_provider);
CREATE INDEX /*i*/eps_topic ON /*_*/echo_push_subscription (eps_topic);
CREATE INDEX /*i*/eps_user ON /*_*/echo_push_subscription (eps_user);
CREATE INDEX /*i*/eps_token ON /*_*/echo_push_subscription (eps_token(10));
patch-drop-ct_tag.sql 0000666 00000002412 15133511401 0010562 0 ustar 00 DROP INDEX change_tag_rc_tag_id;
DROP INDEX change_tag_log_tag_id;
DROP INDEX change_tag_rev_tag_id;
DROP INDEX change_tag_rc_tag_nonuniq;
DROP INDEX change_tag_log_tag_nonuniq;
DROP INDEX change_tag_rev_tag_nonuniq;
DROP INDEX change_tag_tag_id;
DROP INDEX change_tag_tag_id_id;
CREATE TEMPORARY TABLE __temp__/*_*/change_tag AS SELECT ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id FROM /*_*/change_tag;
DROP TABLE /*_*/change_tag;
CREATE TABLE /*_*/change_tag (ct_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, ct_rc_id INTEGER UNSIGNED DEFAULT NULL, ct_log_id INTEGER UNSIGNED DEFAULT NULL, ct_rev_id INTEGER UNSIGNED DEFAULT NULL, ct_params BLOB DEFAULT NULL, ct_tag_id INTEGER UNSIGNED NOT NULL);
INSERT INTO /*_*/change_tag (ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id) SELECT ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id FROM __temp__/*_*/change_tag;
DROP TABLE __temp__/*_*/change_tag;
CREATE UNIQUE INDEX change_tag_rc_tag_id ON /*_*/change_tag (ct_rc_id, ct_tag_id);
CREATE UNIQUE INDEX change_tag_log_tag_id ON /*_*/change_tag (ct_log_id, ct_tag_id);
CREATE UNIQUE INDEX change_tag_rev_tag_id ON /*_*/change_tag (ct_rev_id, ct_tag_id);
CREATE INDEX change_tag_tag_id_id ON /*_*/change_tag (ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id);
Back to Directory
File Manager