From b7f4b5152cc748ae10ef1e6a46eecc077a71d2b2 Mon Sep 17 00:00:00 2001
From: Ramin Moshiri <raminmoshiri@gmail.com>
Date: Mon, 29 Apr 2013 20:29:47 -0700
Subject: [PATCH] Improvements in the translation table building script, take
 2.

---
 .../util/language_translations/buildLanguageDatabase.pl  | 16 +++++++++++-----
 1 file changed, 11 insertions(+), 5 deletions(-)

diff --git a/contrib/util/language_translations/buildLanguageDatabase.pl b/contrib/util/language_translations/buildLanguageDatabase.pl
index d016e742f..bb51ce87e 100644
--- a/contrib/util/language_translations/buildLanguageDatabase.pl
+++ b/contrib/util/language_translations/buildLanguageDatabase.pl
@@ -392,14 +392,16 @@ sub createLanguages() {
  my @numberRow = split($de,$page[$languageNumRow]);
  my @idRow = split($de,$page[$languageIdRow]);
  my @nameRow = split($de,$page[$languageNameRow]);
+ $tempReturn .= "INSERT INTO `lang_languages`   (`lang_id`, `lang_code`, `lang_description`) VALUES\n";
  for (my $i = $constantColumn; $i < @numberRow; $i++) {
-  $tempReturn .= "INSERT INTO `lang_languages` VALUES (".$numberRow[$i].", '".$idRow[$i]."', '".$nameRow[$i]."');\n";
+  $tempReturn .= "(".$numberRow[$i].", '".$idRow[$i]."', '".$nameRow[$i]."'),\n";
   $tempCounter = $numberRow[$i];
      
   # set up for statistics later
   push (@languages, $nameRow[$i]);
   $numberConstantsLanguages[$numberRow[$i]-1] = 0;
  }
+ $tempReturn  =~ s/,\n$/;\n/;
  $tempCounter += 1;
 
  # create header
@@ -450,13 +452,15 @@ sub createConstants() {
  # create table input
  my $tempReturn;
  my $tempCounter; 
+ $tempReturn .= "INSERT INTO `lang_constants`   (`cons_id`, `constant_name`) VALUES\n";
  for (my $i = $constantRow; $i < @page; $i++) {
   my @tempRow = split($de,$page[$i]);
   my $tempId = $tempRow[$constantIdColumn];
   my $tempConstant = $tempRow[$constantColumn];
-  $tempReturn .= "INSERT INTO `lang_constants` VALUES (".$tempId.", '".$tempConstant."');\n";
+  $tempReturn .= "(".$tempId.", '".$tempConstant."'),\n";
   $tempCounter = $tempId;
  }
+ $tempReturn  =~ s/,\n$/;\n/;
  $tempCounter += 1; 
 
  # create header
@@ -514,6 +518,7 @@ sub createDefinitions() {
  my $tempCounter; 
  my @numberRow = split($de,$page[$languageNumRow]);
  my $counter = 1;
+ $tempReturn .= "INSERT INTO `lang_definitions` (`def_id`, `cons_id`, `lang_id`, `definition`) VALUES\n";
  for (my $i = $constantColumn + 1; $i < @numberRow; $i++) {
   for (my $j = $constantRow; $j < @page; $j++) {
    my @tempRow = split($de,$page[$j]);
@@ -521,15 +526,16 @@ sub createDefinitions() {
    my $tempDefinition = $tempRow[$i];
    my $tempLangNumber = $numberRow[$i];
    if ($tempDefinition !~ /^\s*$/) {
-    $tempReturn .= "INSERT INTO `lang_definitions` VALUES (".$counter.", ".$tempId.", ".$tempLangNumber.", '".$tempDefinition."');\n";
+ $tempReturn .= "(".$counter.", ".$tempId.", ".$tempLangNumber.", '".$tempDefinition."'),\n";
     $tempCounter = $counter;
     $counter += 1;
-       
+     
     # set up for statistics
     $numberConstantsLanguages[($tempLangNumber - 1)] += 1;
    }
   }
  }
+ $tempReturn  =~ s/,\n$/;\n/;
  $tempCounter += 1;
 
  # create header
@@ -543,7 +549,7 @@ CREATE TABLE `lang_definitions` (
   `def_id` int(11) NOT NULL auto_increment,
   `cons_id` int(11) NOT NULL default '0',
   `lang_id` int(11) NOT NULL default '0',
-  `definition` mediumtext,
+  `definition` mediumtext CHARACTER SET utf8,
   UNIQUE KEY `def_id` (`def_id`),
   KEY `cons_id` (`cons_id`) 
 ) ENGINE=MyISAM AUTO_INCREMENT=".$tempCounter." ;
-- 
2.11.4.GIT