Paladox has uploaded a new change for review.
https://gerrit.wikimedia.org/r/318562
Change subject: Test do not submit
..
Test do not submit
Change-Id: I7325187fc5776c94815504510cd3107e4575a2a5
---
M maintenance/sqlite/archives/initial-indexes.sql
1 file changed, 496 insertions(+), 115 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/core
refs/changes/62/318562/1
diff --git a/maintenance/sqlite/archives/initial-indexes.sql
b/maintenance/sqlite/archives/initial-indexes.sql
index f322a03..6735261 100644
--- a/maintenance/sqlite/archives/initial-indexes.sql
+++ b/maintenance/sqlite/archives/initial-indexes.sql
@@ -50,19 +50,57 @@
user_email_token binary(32),
user_email_token_expires binary(14),
user_registration binary(14),
- user_editcount int
+ user_editcount int,
+ user_password_expires varbinary(14) DEFAULT NULL
);
CREATE UNIQUE INDEX /*i*/user_name ON /*_*/user_tmp (user_name);
CREATE INDEX /*i*/user_email_token ON /*_*/user_tmp (user_email_token);
-
+CREATE INDEX /*i*/user_email ON /*_*/user_tmp (user_email(50));
CREATE TABLE /*_*/user_groups_tmp (
ug_user int unsigned NOT NULL default 0,
- ug_group varbinary(16) NOT NULL default ''
+ ug_group varbinary(255) NOT NULL default ''
);
CREATE UNIQUE INDEX /*i*/ug_user_group ON /*_*/user_groups_tmp
(ug_user,ug_group);
CREATE INDEX /*i*/ug_group ON /*_*/user_groups_tmp (ug_group);
+
+
+CREATE TABLE /*_*/user_former_groups_tmp (
+ -- Key to user_id
+ ufg_user int unsigned NOT NULL default 0,
+ ufg_group varbinary(255) NOT NULL default ''
+);
+CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups_tmp
(ufg_user,ufg_group);
+
+
+CREATE TABLE /*_*/user_newtalk_tmp (
+ user_id int unsigned NOT NULL default 0,
+ user_ip varbinary(40) NOT NULL default '',
+ user_last_timestamp varbinary(14) NULL default NULL
+);
+CREATE INDEX /*i*/un_user_id ON /*_*/user_newtalk_tmp (user_id);
+CREATE INDEX /*i*/un_user_ip ON /*_*/user_newtalk_tmp (user_ip);
+
+
+CREATE TABLE /*_*/user_properties_tmp (
+ up_user int NOT NULL,
+ up_property varbinary(255) NOT NULL,
+ up_value blob
+);
+
+CREATE UNIQUE INDEX /*i*/user_properties_user_property ON
/*_*/user_properties_tmp (up_user,up_property);
+CREATE INDEX /*i*/user_properties_property ON /*_*/user_properties_tmp
(up_property);
+
+CREATE TABLE /*_*/bot_passwords_tmp (
+ bp_user int NOT NULL,
+ bp_app_id varbinary(32) NOT NULL,
+ bp_password tinyblob NOT NULL,
+ bp_token binary(32) NOT NULL default '',
+ bp_restrictions blob NOT NULL,
+ bp_grants blob NOT NULL,
+ PRIMARY KEY ( bp_user, bp_app_id )
+);
CREATE TABLE /*_*/page_tmp (
page_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
@@ -73,71 +111,121 @@
page_is_new tinyint unsigned NOT NULL default 0,
page_random real unsigned NOT NULL,
page_touched binary(14) NOT NULL default '',
+ page_links_updated varbinary(14) NULL default NULL,
page_latest int unsigned NOT NULL,
- page_len int unsigned NOT NULL
+ page_len int unsigned NOT NULL,
+ page_content_model varbinary(32) DEFAULT NULL,
+ page_lang varbinary(35) DEFAULT NULL
);
CREATE UNIQUE INDEX /*i*/name_title ON /*_*/page_tmp
(page_namespace,page_title);
CREATE INDEX /*i*/page_random ON /*_*/page_tmp (page_random);
CREATE INDEX /*i*/page_len ON /*_*/page_tmp (page_len);
+CREATE INDEX /*i*/page_redirect_namespace_len ON /*_*/page_tmp
(page_is_redirect, page_namespace, page_len);
CREATE TABLE /*_*/revision_tmp (
rev_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
rev_page int unsigned NOT NULL,
rev_text_id int unsigned NOT NULL,
- rev_comment tinyblob NOT NULL,
+ rev_comment varbinary(767) NOT NULL,
rev_user int unsigned NOT NULL default 0,
rev_user_text varchar(255) binary NOT NULL default '',
rev_timestamp binary(14) NOT NULL default '',
rev_minor_edit tinyint unsigned NOT NULL default 0,
rev_deleted tinyint unsigned NOT NULL default 0,
rev_len int unsigned,
- rev_parent_id int unsigned default NULL
+ rev_parent_id int unsigned default NULL,
+ rev_sha1 varbinary(32) NOT NULL default '',
+ rev_content_model varbinary(32) DEFAULT NULL,
+ rev_content_format varbinary(64) DEFAULT NULL
);
-CREATE UNIQUE INDEX /*i*/rev_page_id ON /*_*/revision_tmp (rev_page, rev_id);
+CREATE INDEX /*i*/rev_page_id ON /*_*/revision_tmp (rev_page, rev_id);
CREATE INDEX /*i*/rev_timestamp ON /*_*/revision_tmp (rev_timestamp);
CREATE INDEX /*i*/page_timestamp ON /*_*/revision_tmp (rev_page,rev_timestamp);
CREATE INDEX /*i*/user_timestamp ON /*_*/revision_tmp (rev_user,rev_timestamp);
CREATE INDEX /*i*/usertext_timestamp ON /*_*/revision_tmp
(rev_user_text,rev_timestamp);
+CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision_tmp
(rev_page,rev_user,rev_timestamp);
+
+CREATE TABLE /*_*/text_tmp (
+ old_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ old_text mediumblob NOT NULL,
+ old_flags tinyblob NOT NULL
+);
+