Physikerwelt has uploaded a new change for review.
https://gerrit.wikimedia.org/r/256680
Change subject: Add database schema for user feedback
......................................................................
Add database schema for user feedback
Bug: T120213
Change-Id: I35d74c6e0a6fc01e08c835e5d168c4429172d369
---
M MathSearch.hooks.php
A db/math_mlp.sql
2 files changed, 14 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/MathSearch
refs/changes/80/256680/1
diff --git a/MathSearch.hooks.php b/MathSearch.hooks.php
index 32ab587..cbc00ed 100644
--- a/MathSearch.hooks.php
+++ b/MathSearch.hooks.php
@@ -32,6 +32,7 @@
$updater->addExtensionTable( 'mathperformance', $dir .
'mathperformance.sql' );
$updater->addExtensionTable( 'mathidentifier', $dir .
'mathidentifier.sql' );
$updater->addExtensionTable( 'mathlog', $dir .
'mathlog.sql' );
+ $updater->addExtensionTable( 'math_mlp', $dir .
'math_mlp.sql' );
if ( $wgMathWmcServer ) {
$wmcDir = $dir . 'wmc/persistent/';
$updater->addExtensionTable( 'math_wmc_ref',
$wmcDir . "math_wmc_ref.sql" );
diff --git a/db/math_mlp.sql b/db/math_mlp.sql
new file mode 100644
index 0000000..af2bee8
--- /dev/null
+++ b/db/math_mlp.sql
@@ -0,0 +1,13 @@
+CREATE TABLE /*_*/math_mlp (
+ id int(11) NOT NULL AUTO_INCREMENT,
+ user_id int(10) unsigned NOT NULL,
+ json_data blob,
+ comment varchar(255) DEFAULT NULL,
+ timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ fId varchar(50) DEFAULT NULL,
+ rev_id int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `mathsearch_mlp_revision_rev_id_fk` (rev_id),
+ KEY `mathsearch_mlp_user_user_id_fk` (user_id),
+ CONSTRAINT `mathsearch_mlp_user_user_id_fk` FOREIGN KEY (user_id) REFERENCES
`user` (user_id)
+) /*$wgDBTableOptions*/;
\ No newline at end of file
--
To view, visit https://gerrit.wikimedia.org/r/256680
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I35d74c6e0a6fc01e08c835e5d168c4429172d369
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/MathSearch
Gerrit-Branch: master
Gerrit-Owner: Physikerwelt <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
