[MediaWiki-commits] [Gerrit] mediawiki...Newsletter[wmf/1.30.0-wmf.13]: Update nl_newsletters.sql and kill old files
jenkins-bot has submitted this change and it was merged. ( https://gerrit.wikimedia.org/r/371115 ) Change subject: Update nl_newsletters.sql and kill old files .. Update nl_newsletters.sql and kill old files Change-Id: I28d6996bcf583a7b56db0be737203b3d55f8750d (cherry picked from commit 49f60d532379cfec9aa1380ed9f109ab9a4e3ebf) --- D sql/nl_newsletter-add-nl-active_name.sql D sql/nl_newsletter-drop-nl-active.sql M sql/nl_newsletters.sql 3 files changed, 4 insertions(+), 5 deletions(-) Approvals: Reedy: Looks good to me, approved jenkins-bot: Verified diff --git a/sql/nl_newsletter-add-nl-active_name.sql b/sql/nl_newsletter-add-nl-active_name.sql deleted file mode 100644 index a92a40f..000 --- a/sql/nl_newsletter-add-nl-active_name.sql +++ /dev/null @@ -1,2 +0,0 @@ --- CREATE (nl_active, nl_name) INDEX to help in sorting on Special:Newsletters -CREATE INDEX /*i*/nl_active_name ON /*_*/nl_newsletters (nl_active, nl_name); diff --git a/sql/nl_newsletter-drop-nl-active.sql b/sql/nl_newsletter-drop-nl-active.sql deleted file mode 100644 index 7de1344..000 --- a/sql/nl_newsletter-drop-nl-active.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Drop index nl_active -DROP INDEX /*i*/nl_active ON /*_*/nl_newsletters; \ No newline at end of file diff --git a/sql/nl_newsletters.sql b/sql/nl_newsletters.sql index 5571416..63d3ea5 100644 --- a/sql/nl_newsletters.sql +++ b/sql/nl_newsletters.sql @@ -6,8 +6,11 @@ nl_name varchar(64) NOT NULL, nl_desc blob, nl_main_page_id int unsigned NOT NULL, - nl_active boolean NOT NULL DEFAULT 1 + nl_active TINYINT(1) NOT NULL DEFAULT 1, + nl_subscriber_count INTEGER NOT NULL DEFAULT 0 )/*$wgDBTableOptions*/; CREATE UNIQUE INDEX /*i*/nl_name ON /*_*/nl_newsletters (nl_name); CREATE UNIQUE INDEX /*i*/nl_main_page_active ON /*_*/nl_newsletters (nl_main_page_id, nl_active); +CREATE INDEX /*i*/nl_active ON /*_*/nl_newsletters (nl_active); +CREATE INDEX /*i*/nl_active_subscriber_name ON /*_*/nl_newsletters (nl_active, nl_subscriber_count, nl_name); \ No newline at end of file -- To view, visit https://gerrit.wikimedia.org/r/371115 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I28d6996bcf583a7b56db0be737203b3d55f8750d Gerrit-PatchSet: 1 Gerrit-Project: mediawiki/extensions/Newsletter Gerrit-Branch: wmf/1.30.0-wmf.13 Gerrit-Owner: ReedyGerrit-Reviewer: Addshore Gerrit-Reviewer: Reedy Gerrit-Reviewer: jenkins-bot <> ___ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
[MediaWiki-commits] [Gerrit] mediawiki...Newsletter[wmf/1.30.0-wmf.13]: Update nl_newsletters.sql and kill old files
Reedy has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/371115 ) Change subject: Update nl_newsletters.sql and kill old files .. Update nl_newsletters.sql and kill old files Change-Id: I28d6996bcf583a7b56db0be737203b3d55f8750d (cherry picked from commit 49f60d532379cfec9aa1380ed9f109ab9a4e3ebf) --- D sql/nl_newsletter-add-nl-active_name.sql D sql/nl_newsletter-drop-nl-active.sql M sql/nl_newsletters.sql 3 files changed, 4 insertions(+), 5 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Newsletter refs/changes/15/371115/1 diff --git a/sql/nl_newsletter-add-nl-active_name.sql b/sql/nl_newsletter-add-nl-active_name.sql deleted file mode 100644 index a92a40f..000 --- a/sql/nl_newsletter-add-nl-active_name.sql +++ /dev/null @@ -1,2 +0,0 @@ --- CREATE (nl_active, nl_name) INDEX to help in sorting on Special:Newsletters -CREATE INDEX /*i*/nl_active_name ON /*_*/nl_newsletters (nl_active, nl_name); diff --git a/sql/nl_newsletter-drop-nl-active.sql b/sql/nl_newsletter-drop-nl-active.sql deleted file mode 100644 index 7de1344..000 --- a/sql/nl_newsletter-drop-nl-active.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Drop index nl_active -DROP INDEX /*i*/nl_active ON /*_*/nl_newsletters; \ No newline at end of file diff --git a/sql/nl_newsletters.sql b/sql/nl_newsletters.sql index 5571416..63d3ea5 100644 --- a/sql/nl_newsletters.sql +++ b/sql/nl_newsletters.sql @@ -6,8 +6,11 @@ nl_name varchar(64) NOT NULL, nl_desc blob, nl_main_page_id int unsigned NOT NULL, - nl_active boolean NOT NULL DEFAULT 1 + nl_active TINYINT(1) NOT NULL DEFAULT 1, + nl_subscriber_count INTEGER NOT NULL DEFAULT 0 )/*$wgDBTableOptions*/; CREATE UNIQUE INDEX /*i*/nl_name ON /*_*/nl_newsletters (nl_name); CREATE UNIQUE INDEX /*i*/nl_main_page_active ON /*_*/nl_newsletters (nl_main_page_id, nl_active); +CREATE INDEX /*i*/nl_active ON /*_*/nl_newsletters (nl_active); +CREATE INDEX /*i*/nl_active_subscriber_name ON /*_*/nl_newsletters (nl_active, nl_subscriber_count, nl_name); \ No newline at end of file -- To view, visit https://gerrit.wikimedia.org/r/371115 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I28d6996bcf583a7b56db0be737203b3d55f8750d Gerrit-PatchSet: 1 Gerrit-Project: mediawiki/extensions/Newsletter Gerrit-Branch: wmf/1.30.0-wmf.13 Gerrit-Owner: ReedyGerrit-Reviewer: Addshore ___ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits