[libgda] mysql: fixed meta data provider test

[Daniel Espinosa Ortiz <despinosa src gnome org>]

commit c5e3bcea173238a82b45fa1a0adfbff864191961
Author: Daniel Espinosa Ortiz <esodan gmail com>
Date:   Wed Jan 16 10:54:57 2019 -0600

    mysql: fixed meta data provider test
    
    * Information schema for MySQL no uses InnoDB and keys up to 100
      characteres

 libgda/information_schema.xml                   | 2 +-
 providers/mysql/mysql_specs_create_table.xml.in | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)
---
diff --git a/libgda/information_schema.xml b/libgda/information_schema.xml
index fbfe2af6d..b0d6fec8b 100644
--- a/libgda/information_schema.xml
+++ b/libgda/information_schema.xml
@@ -24,7 +24,7 @@
       <replace context="/FIELDS_A/@COLUMN_TYPE" expr="gint64" replace_with="int"/>
     </provider>
     <provider name="MySQL">
-      <replace context="/FIELDS_A/@COLUMN_TYPE" expr="string" replace_with="varchar(35)"/>
+      <replace context="/FIELDS_A/@COLUMN_TYPE" expr="string" replace_with="varchar(100)"/>
       <replace context="/FIELDS_A/@COLUMN_TYPE" expr="gint" replace_with="int"/>
       <replace context="/FIELDS_A/@COLUMN_TYPE" expr="gboolean" replace_with="boolean"/>
       <ignore context="/FKEY_S"/>
diff --git a/providers/mysql/mysql_specs_create_table.xml.in b/providers/mysql/mysql_specs_create_table.xml.in
index db934c9c5..f23170e0d 100644
--- a/providers/mysql/mysql_specs_create_table.xml.in
+++ b/providers/mysql/mysql_specs_create_table.xml.in
@@ -64,7 +64,7 @@
   <!-- other table options -->
   <parameters id="TABLE_OPTIONS_P" _name="Table's options">
     <parameter id="TABLE_ENGINE" _name="Engine" _descr="Table's engine (or type)" gdatype="gchararray" 
nullok="TRUE" source="engines:0">
-      <gda_value>MyISAM</gda_value>
+      <gda_value>InnoDB</gda_value>
     </parameter>
     <parameter id="TABLE_AUTOINC_VALUE" _name="Auto increment value" _descr="Counter for auto incremented 
fields is incremented by this value + 1 (DEFAULT: 0)" gdatype="gint" nullok="TRUE"/>
     <parameter id="TABLE_AVG_ROW_LENGTH" _name="Average row length" _descr="An approximation of the average 
row length for your table" gdatype="gint" nullok="TRUE"/>