jenkins-bot has submitted this change and it was merged. (
https://gerrit.wikimedia.org/r/370847 )
Change subject: Update nl_newsletters.sql and kill old files
......................................................................
Update nl_newsletters.sql and kill old files
Change-Id: I28d6996bcf583a7b56db0be737203b3d55f8750d
---
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..0000000
--- 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..0000000
--- 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/370847
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: master
Gerrit-Owner: Addshore <addshorew...@gmail.com>
Gerrit-Reviewer: Reedy <re...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
