[libgda] Use strings limited to 30 chars. when the meta store is held in a MySQL database

[Vivien Malerba <vivien src gnome org>]

commit b072cac007737f49883cd837a3e7fd95ae46532c
Author: Vivien Malerba <malerba gnome-db org>
Date:   Wed Jul 28 17:38:08 2010 +0200

    Use strings limited to 30 chars. when the meta store is held in a MySQL database
    
    because MySQL fails to create primary keys if the size of the strings
    is undefined or if the size is too big (it says 1000 chars but it's not
    really 100, and 30 for each string seems to be Ok)

 libgda/information_schema.xml |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/libgda/information_schema.xml b/libgda/information_schema.xml
index ea09e0d..31f10f5 100644
--- a/libgda/information_schema.xml
+++ b/libgda/information_schema.xml
@@ -23,7 +23,7 @@
       <replace context="/FIELDS_A/@COLUMN_TYPE" expr="gint" replace_with="int"/>
     </provider>
     <provider name="MySQL">
-      <replace context="/FIELDS_A/@COLUMN_TYPE" expr="string" replace_with="text"/>
+      <replace context="/FIELDS_A/@COLUMN_TYPE" expr="string" replace_with="varchar (30)"/>
       <replace context="/FIELDS_A/@COLUMN_TYPE" expr="gint" replace_with="int"/>
       <ignore context="/FKEY_S"/>
       <ignore context="/FIELDS_A/@COLUMN_PKEY"/>