Addshore has uploaded a new change for review. ( 
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(-)


  git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Newsletter 
refs/changes/47/370847/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..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: newchange
Gerrit-Change-Id: I28d6996bcf583a7b56db0be737203b3d55f8750d
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/Newsletter
Gerrit-Branch: master
Gerrit-Owner: Addshore <addshorew...@gmail.com>

_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to