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



commit cfd06f47b558585e1c9ddaeeb31a90345cb6496d
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 af9b80e..4018a5a 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"/>



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]