Reedy has uploaded a new change for review. ( )

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:// 

diff --git a/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 
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
 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
To unsubscribe, visit

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: Reedy <>
Gerrit-Reviewer: Addshore <>

MediaWiki-commits mailing list

Reply via email to