Tinaj1234 has uploaded a new change for review. https://gerrit.wikimedia.org/r/234281
Change subject: Add secondary indexes and some minor issues with database ...................................................................... Add secondary indexes and some minor issues with database Change-Id: I8c58d99ed1ec1f8be47b6d0acf22562652181e5f --- M sql/nl_newsletters.sql M sql/nl_publishers.sql 2 files changed, 8 insertions(+), 5 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Newsletter refs/changes/81/234281/1 diff --git a/sql/nl_newsletters.sql b/sql/nl_newsletters.sql index 257b0c4..8441921 100644 --- a/sql/nl_newsletters.sql +++ b/sql/nl_newsletters.sql @@ -3,9 +3,12 @@ CREATE TABLE /*_*/nl_newsletters( --Primary key nl_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, - nl_name VARCHAR (50) NOT NULL UNIQUE, - nl_desc VARCHAR (256), + nl_name varchar(50) NOT NULL UNIQUE, + nl_desc varbinary(767), nl_main_page_id int NOT NULL, - nl_frequency VARCHAR (50) NOT NULL, + nl_frequency varchar(50) NOT NULL, nl_owner_id int NOT NULL -)/*$wgDBTableOptions*/; \ No newline at end of file +)/*$wgDBTableOptions*/; + +CREATE INDEX /*i*/nl_id ON /*_*/nl_newsletters(nl_name); +CREATE INDEX /*i*/nl_owner_id ON /*_*/nl_newsletters(nl_owner_id); \ No newline at end of file diff --git a/sql/nl_publishers.sql b/sql/nl_publishers.sql index 2c5cef0..d6cef4b 100644 --- a/sql/nl_publishers.sql +++ b/sql/nl_publishers.sql @@ -4,5 +4,5 @@ --Primary key newsletter_id int REFERENCES nl_newsletter(nl_id), publisher_id int NOT NULL, - PRIMARY KEY (newsletter_id, publisher_id) + PRIMARY KEY (publisher_id, newsletter_id) )/*$wgDBTableOptions*/; -- To view, visit https://gerrit.wikimedia.org/r/234281 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I8c58d99ed1ec1f8be47b6d0acf22562652181e5f Gerrit-PatchSet: 1 Gerrit-Project: mediawiki/extensions/Newsletter Gerrit-Branch: master Gerrit-Owner: Tinaj1234 <tinajohnson.1...@gmail.com> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits