EBernhardson (WMF) has uploaded a new change for review.
https://gerrit.wikimedia.org/r/77919
Change subject: Update database
......................................................................
Update database
update flow.sql to match expected database structure
Change-Id: I3cea6898d40ed982d1f603357deb9ba29c9d4f35
---
M flow.sql
1 file changed, 10 insertions(+), 12 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Flow
refs/changes/19/77919/1
diff --git a/flow.sql b/flow.sql
index 25fa8b3..29acc52 100644
--- a/flow.sql
+++ b/flow.sql
@@ -31,8 +31,6 @@
PRIMARY KEY (workflow_id)
) /*$wgDBTableOptions*/;
-CREATE UNIQUE INDEX /*i*/flow_workflow_unique ON /*_*/flow_workflow (
workflow_title_text, workflow_namespace, workflow_definition_id, workflow_name
);
-
CREATE TABLE /*_*/flow_subscription (
subscription_workflow_id int unsigned not null,
subscription_user_id int unsigned not null,
@@ -42,13 +40,6 @@
CREATE UNIQUE INDEX /*i*/flow_subscription_unique_user_workflow ON
/*_*/flow_subscription (subscription_workflow_id, subscription_user_id);
CREATE INDEX /*i*/flow_subscription_lookup ON /*_*/flow_subscription
(subscription_user_id, subscription_last_updated, subscription_workflow_id);
-
-CREATE TABLE /*_*/flow_metadata (
- metadata_id decimal(39) unsigned not null,
- metadata_key varchar(32) binary not null,
- metadata_value varchar(255) binary null
-) /*$wgDBTableOptions*/;
-CREATE UNIQUE INDEX /*i*/flow_metadata_idx ON /*_*/flow_metadata (
metadata_id, metadata_key );
-- TopicList Tables
CREATE TABLE /*_*/flow_topic_list (
@@ -146,9 +137,8 @@
tree_depth smallint not null
) /*$wgDBTableOptions*/;
-CREATE UNIQUE INDEX /*i*/flow_tree_node_pk ON /*_*/flow_tree_node (ancestor,
descendant);
-
-CREATE UNIQUE INDEX /*i*/flow_tree_constraint ON /*_*/flow_tree_node
(descendant, depth);
+CREATE UNIQUE INDEX /*i*/flow_tree_node_pk ON /*_*/flow_tree_node
(tree_ancestor, tree_descendant);
+CREATE UNIQUE INDEX /*i*/flow_tree_constraint ON /*_*/flow_tree_node
(tree_descendant, tree_depth);
CREATE TABLE /*_*/flow_subscription (
subscrip_user_id binary(16) not null,
@@ -163,3 +153,11 @@
CREATE INDEX /*i*/flow_subscription_lookup
ON /*_*/flow_subscription (subscription_user_id,
subscription_last_updated, subscription_workflow_id);
+
+-- These dont belong here
+INSERT INTO flow_definition
+ ( definition_id, definition_wiki, definition_name, definition_type,
definition_options )
+ VALUES
+ ( 6645733872243863389540699858102420002, 'wiki', 'topic', 'topic', NULL
),
+ ( 6645733872272877609211450958295368226, 'wiki', 'discussion',
'discussion',
'a:2:{s:19:"topic_definition_id";s:37:"6645733872243863389540699858102420002";s:6:"unique";b:1;}'
);
+
--
To view, visit https://gerrit.wikimedia.org/r/77919
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I3cea6898d40ed982d1f603357deb9ba29c9d4f35
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/Flow
Gerrit-Branch: master
Gerrit-Owner: EBernhardson (WMF) <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
