diff options
| author | Amir Sarabadani <Ladsgroup@gmail.com> | 2020-12-13 02:52:49 +0100 |
|---|---|---|
| committer | Ammarpad <ammarpad@yahoo.com> | 2020-12-21 07:39:50 +0000 |
| commit | 443c94de3f48a77cc53266689a48a632dcd9559a (patch) | |
| tree | 7f03b4f34e337dfa683cef6d6248d39ca836d7d2 /maintenance/sqlite/archives/patch-logging-rename-indexes.sql | |
| parent | d464f84182802cbde2733269393936e2951f8381 (diff) | |
| download | mediawikicore-443c94de3f48a77cc53266689a48a632dcd9559a.tar.gz mediawikicore-443c94de3f48a77cc53266689a48a632dcd9559a.zip | |
Rename four logging indexes to have log_ prefix
To follow database coding convention and avoid clashes in RDBMS engines
where indexes are global
Bug: T270033
Change-Id: I17028bba489d04b01d22c39dc8935a4f0f771c7e
Diffstat (limited to 'maintenance/sqlite/archives/patch-logging-rename-indexes.sql')
| -rw-r--r-- | maintenance/sqlite/archives/patch-logging-rename-indexes.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/maintenance/sqlite/archives/patch-logging-rename-indexes.sql b/maintenance/sqlite/archives/patch-logging-rename-indexes.sql new file mode 100644 index 000000000000..f2da25425437 --- /dev/null +++ b/maintenance/sqlite/archives/patch-logging-rename-indexes.sql @@ -0,0 +1,27 @@ +-- This file is automatically generated using maintenance/generateSchemaChangeSql.php. +-- Source: maintenance/abstractSchemaChanges/patch-logging-rename-indexes.json +-- Do not modify this file directly. +-- See https://www.mediawiki.org/wiki/Manual:Schema_changes +DROP INDEX type_time; +DROP INDEX actor_time; +DROP INDEX page_time; +DROP INDEX times; +DROP INDEX log_actor_type_time; +DROP INDEX log_page_id_time; +DROP INDEX log_type_action; +CREATE TEMPORARY TABLE /*_*/__temp__logging AS +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; +CREATE TABLE /*_*/logging ( log_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, log_type BLOB DEFAULT '' NOT NULL, log_action BLOB DEFAULT '' NOT NULL, log_timestamp BLOB DEFAULT '19700101000000' NOT NULL, log_actor BIGINT UNSIGNED NOT NULL, log_namespace INTEGER DEFAULT 0 NOT NULL, log_title BLOB DEFAULT '' NOT NULL, log_page INTEGER UNSIGNED DEFAULT NULL, log_comment_id BIGINT UNSIGNED NOT NULL, log_params BLOB NOT NULL, log_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL ); +INSERT INTO /*_*/logging ( 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 /*_*/__temp__logging; +DROP TABLE /*_*/__temp__logging; +CREATE INDEX log_actor_type_time ON /*_*/logging ( log_actor, log_type, log_timestamp ); +CREATE INDEX log_page_id_time ON /*_*/logging (log_page, log_timestamp); +CREATE INDEX log_type_action ON /*_*/logging ( log_type, log_action, log_timestamp ); +CREATE INDEX log_type_time ON /*_*/logging (log_type, log_timestamp); +CREATE INDEX log_actor_time ON /*_*/logging (log_actor, log_timestamp); +CREATE INDEX log_page_time ON /*_*/logging ( log_namespace, log_title, log_timestamp ); +CREATE INDEX log_times ON /*_*/logging (log_timestamp);
\ No newline at end of file |