diff options
| author | Amir Sarabadani <ladsgroup@gmail.com> | 2022-05-20 18:25:36 +0200 |
|---|---|---|
| committer | Ladsgroup <Ladsgroup@gmail.com> | 2022-05-23 15:37:42 +0000 |
| commit | 24115a8f4cc0f079f30894bc07eb7476f2dffb3e (patch) | |
| tree | ca8a2bc2d105c09244f9ede64a28d1e031efe6cb /maintenance/sqlite/tables-generated.sql | |
| parent | 384074a32a21902d63a0f87376190cb7c1dd1b54 (diff) | |
| download | mediawikicore-24115a8f4cc0f079f30894bc07eb7476f2dffb3e.tar.gz mediawikicore-24115a8f4cc0f079f30894bc07eb7476f2dffb3e.zip | |
Start clean up of revision_actor_temp table
It is being dropped in production
Bug: T215466
Change-Id: I66b2cb8653252e720c897351065978119f040ba7
Diffstat (limited to 'maintenance/sqlite/tables-generated.sql')
| -rw-r--r-- | maintenance/sqlite/tables-generated.sql | 19 |
1 files changed, 0 insertions, 19 deletions
diff --git a/maintenance/sqlite/tables-generated.sql b/maintenance/sqlite/tables-generated.sql index 38dd9b9cc227..2c1159909348 100644 --- a/maintenance/sqlite/tables-generated.sql +++ b/maintenance/sqlite/tables-generated.sql @@ -465,25 +465,6 @@ CREATE TABLE /*_*/revision_comment_temp ( CREATE UNIQUE INDEX revcomment_rev ON /*_*/revision_comment_temp (revcomment_rev); -CREATE TABLE /*_*/revision_actor_temp ( - revactor_rev INTEGER UNSIGNED NOT NULL, - revactor_actor BIGINT UNSIGNED NOT NULL, - revactor_timestamp BLOB NOT NULL, - revactor_page INTEGER UNSIGNED NOT NULL, - PRIMARY KEY(revactor_rev, revactor_actor) -); - -CREATE UNIQUE INDEX revactor_rev ON /*_*/revision_actor_temp (revactor_rev); - -CREATE INDEX actor_timestamp ON /*_*/revision_actor_temp ( - revactor_actor, revactor_timestamp -); - -CREATE INDEX page_actor_timestamp ON /*_*/revision_actor_temp ( - revactor_page, revactor_actor, revactor_timestamp -); - - CREATE TABLE /*_*/page_props ( pp_page INTEGER UNSIGNED NOT NULL, pp_propname BLOB NOT NULL, |