summaryrefslogtreecommitdiff
path: root/www/wiki/extensions/Translate/sql/translate_reviews-patch-01-primary-key.sql
diff options
context:
space:
mode:
Diffstat (limited to 'www/wiki/extensions/Translate/sql/translate_reviews-patch-01-primary-key.sql')
-rw-r--r--www/wiki/extensions/Translate/sql/translate_reviews-patch-01-primary-key.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/www/wiki/extensions/Translate/sql/translate_reviews-patch-01-primary-key.sql b/www/wiki/extensions/Translate/sql/translate_reviews-patch-01-primary-key.sql
new file mode 100644
index 00000000..9017fb53
--- /dev/null
+++ b/www/wiki/extensions/Translate/sql/translate_reviews-patch-01-primary-key.sql
@@ -0,0 +1,3 @@
+ALTER TABLE /*_*/translate_reviews
+ ADD PRIMARY KEY (trr_page, trr_revision, trr_user),
+ DROP INDEX /*i*/trr_user_page_revision;