Amire80 has uploaded a new change for review.
https://gerrit.wikimedia.org/r/172218
Change subject: Fix contenttranslation.sql
......................................................................
Fix contenttranslation.sql
As this file was, it was failing with SLQ syntax errors.
In this patch:
* Remove extra comma.
* Clarify documentation.
* Fix whitespace.
Change-Id: I8ce73a789470087606aead0b5883a02def942253
---
M sql/contenttranslation.sql
1 file changed, 13 insertions(+), 11 deletions(-)
git pull
ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/ContentTranslation
refs/changes/18/172218/1
diff --git a/sql/contenttranslation.sql b/sql/contenttranslation.sql
index 16edfbe..3fe8ed2 100644
--- a/sql/contenttranslation.sql
+++ b/sql/contenttranslation.sql
@@ -1,8 +1,10 @@
-- Some example steps for creating a new database for testing this:
--- CREATE DATABASE contenttranslation;
--- USE contenttranslation;
--- GRANT ALL ON contenttranslation.* to 'wikiuser'@'localhost';
--- SOURCE contenttranslation.sql
+-- mysql> CREATE DATABASE contenttranslation;
+-- mysql> USE contenttranslation;
+-- In the next line replace "USER" with the value of $wgDBuser from your
LocalSettings.php,
+-- and replace localhost with your hostname if needed.
+-- mysql> GRANT ALL ON contenttranslation.* to 'USER'@'localhost';
+-- mysql> SOURCE contenttranslation.sql
CREATE TABLE /*_*/translations (
-- translation id. Autogenerated.
@@ -23,9 +25,9 @@
-- There is no final status. A published translation can be draft again
to update again
translation_status enum('draft', 'published' ) default null,
-- Start date of this translation
- translation_start_timestamp varchar(14) binary not null,
+ translation_start_timestamp varchar(14) binary not null,
-- Last updated date of this translation
- translation_last_updated_timestamp varchar(14) binary not null,
+ translation_last_updated_timestamp varchar(14) binary not null,
-- Progress of the translation - json dump
translation_progress TINYBLOB not null,
-- Who started this translation? User id
@@ -35,10 +37,10 @@
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/translators (
- -- Translators id - global user id?
- translator_user_id int not null,
- -- Translation id - foreign key to translations.translation_id
- translator_translation_id int not null,
+ -- Translators id - global user id?
+ translator_user_id int not null,
+ -- Translation id - foreign key to translations.translation_id
+ translator_translation_id int not null
) /*$wgDBTableOptions*/;
-CREATE UNIQUE INDEX /*i*/translation_translators ON /*_*/translators
(translator_user_id, translator_translation_id);
\ No newline at end of file
+CREATE UNIQUE INDEX /*i*/translation_translators ON /*_*/translators
(translator_user_id, translator_translation_id);
--
To view, visit https://gerrit.wikimedia.org/r/172218
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I8ce73a789470087606aead0b5883a02def942253
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/ContentTranslation
Gerrit-Branch: master
Gerrit-Owner: Amire80 <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
