AndyRussG has uploaded a new change for review.
https://gerrit.wikimedia.org/r/159403
Change subject: WIP Schema for persistent global allocation tracking
......................................................................
WIP Schema for persistent global allocation tracking
Change-Id: I5e5133560f3dc2f7861a74861182ec71c5500519
---
M CentralNotice.sql
1 file changed, 16 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/CentralNotice
refs/changes/03/159403/1
diff --git a/CentralNotice.sql b/CentralNotice.sql
index f1437e7..0c38b57 100644
--- a/CentralNotice.sql
+++ b/CentralNotice.sql
@@ -103,6 +103,22 @@
CREATE INDEX /*i*/nmc_not_id ON /*_*/cn_notice_mobile_carriers (not_id);
CREATE INDEX /*i*/nmc_carrier_id ON /*_*/cn_notice_mobile_carriers (mc_id);
+CREATE TABLE IF NOT EXISTS /*_*/cn_allocation_points (
+ `acp_id` int PRIMARY KEY AUTO_INCREMENT,
+ `acp_notice_id` int(10) unsigned NOT NULL,
+ `acp_language` varchar(32) NOT NULL,
+ `acp_project` varchar(32) NOT NULL,
+ `acp_country` varchar(32) NOT NULL
+) /*$wgDBTableOptions*/;
+CREATE INDEX /*i*/cn_allocation_pts_criteria ON /*_*/cn_allocation_points
(acp_notice_language, acp_project, acp_country);
+CREATE INDEX /*i*/cn_allocation_pts_notices ON /*_*/cn_allocation_points
(acp_notice_id);
+
+CREATE TABLE IF NOT EXISTS /*_*/cn_allocation_hashes (
+ `ach_id` int PRIMARY KEY AUTO_INCREMENT,
+ `ach_hash` varchar(255) NOT NULL
+) /*$wgDBTableOptions*/;
+CREATE INDEX /*i*/cn_allocation_hash ON /*_*/cn_allocation_hashes (ach_hash);
+
CREATE TABLE IF NOT EXISTS /*_*/cn_notice_log (
`notlog_id` int(10) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
`notlog_timestamp` binary(14) NOT NULL,
--
To view, visit https://gerrit.wikimedia.org/r/159403
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I5e5133560f3dc2f7861a74861182ec71c5500519
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/CentralNotice
Gerrit-Branch: master
Gerrit-Owner: AndyRussG <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
