AndyRussG has uploaded a new change for review.
https://gerrit.wikimedia.org/r/198267
Change subject: WIP Campaign-associated mixins: schema update
......................................................................
WIP Campaign-associated mixins: schema update
Bug: T90913
Change-Id: I7b6b67d37af83240a0768db06357f43637a6c302
---
M CentralNotice.sql
M patches/CNDatabasePatcher.php
A patches/patch-notice-mixins.sql
3 files changed, 25 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/CentralNotice
refs/changes/67/198267/1
diff --git a/CentralNotice.sql b/CentralNotice.sql
index 39a135b..41b0349 100644
--- a/CentralNotice.sql
+++ b/CentralNotice.sql
@@ -72,6 +72,15 @@
CREATE INDEX /*i*/tmxn_page_id ON /*_*/cn_template_mixins (page_id);
CREATE INDEX /*i*/tmxn_mixin_name ON /*_*/cn_template_mixins (mixin_name);
+CREATE TABLE IF NOT EXISTS /*_*/cn_notice_mixins (
+ `nmxn_id` int PRIMARY KEY AUTO_INCREMENT,
+ `nmxn_not_id` int(11) NOT NULL,
+ `nmxn_mixin_name` varchar(255) NOT NULL,
+ `nmxn_mixin_params` BLOB
+) /*$wgDBTableOptions*/;
+CREATE INDEX /*i*/nmxn_not_id_idx ON /*_*/cn_notice_mixins (nmxn_not_id);
+CREATE INDEX /*i*/nmxn_mixin_name_idx ON /*_*/cn_notice_mixins
(nmxn_mixin_name);
+
CREATE TABLE IF NOT EXISTS /*_*/cn_known_devices (
`dev_id` int PRIMARY KEY AUTO_INCREMENT,
`dev_name` varchar(255) NOT NULL,
diff --git a/patches/CNDatabasePatcher.php b/patches/CNDatabasePatcher.php
index da58e6e..10e0f21 100644
--- a/patches/CNDatabasePatcher.php
+++ b/patches/CNDatabasePatcher.php
@@ -148,6 +148,12 @@
$base .
'/patch-assignments_index.sql', true
)
);
+ $updater->addExtensionUpdate(
+ array(
+ 'addTable', 'cn_notice_mixins',
+ $base . '/patch-notice-mixins.sql',
true
+ )
+ );
} elseif ( $updater->getDB()->getType() == 'sqlite' ) {
// Add the entire schema...
$updater->addExtensionUpdate(
diff --git a/patches/patch-notice-mixins.sql b/patches/patch-notice-mixins.sql
new file mode 100644
index 0000000..f393d9d
--- /dev/null
+++ b/patches/patch-notice-mixins.sql
@@ -0,0 +1,10 @@
+-- Add a table and indexes for mixins associated with campaigns (a.k.a.
notices)
+
+CREATE TABLE IF NOT EXISTS /*_*/cn_notice_mixins (
+ `nmxn_id` int PRIMARY KEY AUTO_INCREMENT,
+ `nmxn_not_id` int(11) NOT NULL,
+ `nmxn_mixin_name` varchar(255) NOT NULL,
+ `nmxn_mixin_params` BLOB
+) /*$wgDBTableOptions*/;
+CREATE INDEX /*i*/nmxn_not_id_idx ON /*_*/cn_notice_mixins (nmxn_not_id);
+CREATE INDEX /*i*/nmxn_mixin_name_idx ON /*_*/cn_notice_mixins
(nmxn_mixin_name);
\ No newline at end of file
--
To view, visit https://gerrit.wikimedia.org/r/198267
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I7b6b67d37af83240a0768db06357f43637a6c302
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/CentralNotice
Gerrit-Branch: master
Gerrit-Owner: AndyRussG <andrew.green...@gmail.com>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
