title: Why does Eclipse propose "Object" as default mapping type for datatype "Text"?
body: <p>When generating JPA Entities from tables with Eclipse (Juno 4.2 for Java EE Developers) it proposes <code>Object</code> as default mapping type for properties I set to be <code>Text</code>.<br>
  That is quite annoying as I would have to set them all to <code>String</code> manually.<br>
  Has someone encountered that kind of problem and knows what to do? Is this a bug? Eclipse Indigo does not behave like that.</p>
  
  <p>This is the <code>/runtime/vendors/MySql_5.1/MySql_5.1.xmi</code> from <code>org.eclipse.datatools.enablement.mysql.dbdefinition_1.0.4.v201109022331.jar</code>: (But as according to this file <code>Text</code> should be mapped to <code>String</code> this must be the wrong file - but how to find out the right one?)</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="ASCII"?&gt;
  &lt;DBDefinition:DatabaseVendorDefinition xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:DBDefinition="http:///org/eclipse/datatools/modelbase/dbdefinition/dbdefinition.ecore" vendor="MySql" version="5.1" maximumIdentifierLength="64" joinSupported="true" tablespacesSupported="false" maximumCommentLength="60" schemaSupported="false" aliasSupported="true" SQLStatementSupported="true"&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="BIT_1" keyConstraintSupported="true"
  maximumValue="1" minimumValue="0" primitiveType="SMALLINT" jdbcEnumType="-6"
  javaClassName="byte"&gt;
      &lt;defaultValueTypes&gt;0&lt;/defaultValueTypes&gt;
      &lt;name&gt;BIT&lt;/name&gt;
      &lt;name&gt;BOOL&lt;/name&gt;
      &lt;name&gt;BOOLEAN&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="TINYINT_UNSIGNED"
  keyConstraintSupported="true" maximumValue="255" minimumValue="0"
  primitiveType="SMALLINT" jdbcEnumType="-6" javaClassName="byte"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;TINYINT UNSIGNED&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="SMALLINT_UNSIGNED"
  keyConstraintSupported="true" maximumValue="65535" minimumValue="0"
  primitiveType="SMALLINT" jdbcEnumType="5" javaClassName="int"&gt;
      &lt;defaultValueTypes&gt;0&lt;/defaultValueTypes&gt;
      &lt;name&gt;SMALLINT UNSIGNED&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="MEDIUMINT_UNSIGNED"
  keyConstraintSupported="true" maximumValue="16777215" minimumValue="0"
  primitiveType="SMALLINT" jdbcEnumType="4" javaClassName="int"&gt;
      &lt;defaultValueTypes&gt;0&lt;/defaultValueTypes&gt;
      &lt;name&gt;MEDIUMINT UNSIGNED&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="INTEGER_UNSIGNED"
  keyConstraintSupported="true" maximumValue="4294967295" minimumValue="0"
  primitiveType="INTEGER" jdbcEnumType="4" javaClassName="int"&gt;
      &lt;defaultValueTypes&gt;0&lt;/defaultValueTypes&gt;
      &lt;name&gt;INTEGER UNSIGNED&lt;/name&gt;
      &lt;name&gt;INT UNSIGNED&lt;/name&gt;    
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="BIGINT_UNSIGNED"
  keyConstraintSupported="true" identitySupported="true" primitiveType="BIGINT"
  jdbcEnumType="-5" javaClassName="java.math.BigInteger"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;BIGINT UNSIGNED&lt;/name&gt;
      &lt;name&gt;SERIAL&lt;/name&gt;    
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="REAL_UNSIGNED"
  keyConstraintSupported="true" primitiveType="REAL" jdbcEnumType="7"
  javaClassName="float"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;REAL UNSIGNED&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="DOUBLE_UNSIGNED_PRECISION"
  keyConstraintSupported="true" primitiveType="DOUBLE_PRECISION" jdbcEnumType="8"
  javaClassName="double"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;DOUBLE UNSIGNED&lt;/name&gt;
      &lt;name&gt;DOUBLE UNSIGNED PRECISION&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="FLOAT_UNSIGNED"
  keyConstraintSupported="true" primitiveType="FLOAT" jdbcEnumType="6"
  javaClassName="float"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;FLOAT UNSIGNED&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="DECIMAL_UNSIGNED"
  scaleSupported="true" precisionSupported="true" maximumPrecision="64"
  keyConstraintSupported="true" primitiveType="DECIMAL" jdbcEnumType="3"
  javaClassName="java.math.BigDecimal"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;DECIMAL UNSIGNED&lt;/name&gt;
      &lt;name&gt;DEC UNSIGNED&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
      &lt;predefinedDataTypeDefinitions xmi:id="SMALLINT_2" keyConstraintSupported="true" maximumValue="127" minimumValue="-128" primitiveType="SMALLINT" jdbcEnumType="-6" javaClassName="byte"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;TINYINT&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="SMALLINT_1" keyConstraintSupported="true" maximumValue="32767" minimumValue="-32768" primitiveType="SMALLINT" jdbcEnumType="5" javaClassName="short"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;SMALLINT&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="INTEGER_2" keyConstraintSupported="true" maximumValue="8388607" minimumValue="-8388608" primitiveType="INTEGER" jdbcEnumType="4" javaClassName="int"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;MEDIUMINT&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="INTEGER_1" keyConstraintSupported="true" identitySupported="true" maximumValue="2147483647" minimumValue="-2147483648" primitiveType="INTEGER" jdbcEnumType="4" javaClassName="int"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;INT&lt;/name&gt;
      &lt;name&gt;INTEGER&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="BIGINT_1" keyConstraintSupported="true" identitySupported="true" primitiveType="BIGINT" jdbcEnumType="-5" javaClassName="java.math.BigInteger"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;BIGINT&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="REAL_1" keyConstraintSupported="true" primitiveType="REAL" jdbcEnumType="7" javaClassName="float"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;REAL&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="DOUBLE_PRECISION_1" keyConstraintSupported="true" primitiveType="DOUBLE_PRECISION" jdbcEnumType="8" javaClassName="double"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;DOUBLE&lt;/name&gt;
      &lt;name&gt;DOUBLE PRECISION&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="FLOAT_1" keyConstraintSupported="true" primitiveType="FLOAT" jdbcEnumType="6" javaClassName="float"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;FLOAT&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="DECIMAL_1" scaleSupported="true" precisionSupported="true" maximumPrecision="64" keyConstraintSupported="true" primitiveType="DECIMAL" jdbcEnumType="3" javaClassName="java.math.BigDecimal"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;DECIMAL&lt;/name&gt;
      &lt;name&gt;DEC&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="NUMERIC_1" scaleSupported="true" precisionSupported="true" maximumPrecision="64" keyConstraintSupported="true" primitiveType="NUMERIC" jdbcEnumType="2" javaClassName="java.math.BigDecimal"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;NUMERIC&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="DATE_1" keyConstraintSupported="true" primitiveType="DATE" jdbcEnumType="91" javaClassName="java.sql.Date"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;DATE&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="TIME_1" keyConstraintSupported="true" primitiveType="TIME" jdbcEnumType="92" javaClassName="java.sql.Time"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;TIME&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="TIMESTAMP_1" keyConstraintSupported="true" primitiveType="TIMESTAMP" jdbcEnumType="93" javaClassName="java.sql.Timestamp"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;TIMESTAMP&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="TIMESTAMP_2" keyConstraintSupported="true" primitiveType="TIMESTAMP" jdbcEnumType="93" javaClassName="java.util.Date"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;DATETIME&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="CHARACTER_1" lengthSupported="true" keyConstraintSupported="true" maximumLength="255" jdbcEnumType="1" javaClassName="java.lang.String"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;defaultValueTypes&gt;CURRENT_USER&lt;/defaultValueTypes&gt;
      &lt;name&gt;CHAR&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="CHARACTER_VARYING_1" lengthSupported="true" keyConstraintSupported="true" maximumLength="255" primitiveType="CHARACTER_VARYING" jdbcEnumType="12" javaClassName="java.lang.String"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;defaultValueTypes&gt;CURRENT_USER&lt;/defaultValueTypes&gt;
      &lt;name&gt;VARCHAR&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="BINARY_LARGE_OBJECT_1" defaultSupported="false" maximumLength="256" primitiveType="BINARY_LARGE_OBJECT" jdbcEnumType="2004" javaClassName="java.sql.Blob"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;TINYBLOB&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="BINARY_LARGE_OBJECT_2" defaultSupported="false" maximumLength="65536" primitiveType="BINARY_LARGE_OBJECT" jdbcEnumType="2004" javaClassName="java.sql.Blob"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;BLOB&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="BINARY_LARGE_OBJECT_3" defaultSupported="false" maximumLength="16777216" primitiveType="BINARY_LARGE_OBJECT" jdbcEnumType="2004" javaClassName="java.sql.Blob"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;MEDIUMBLOB&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="BINARY_LARGE_OBJECT_4" defaultSupported="false" primitiveType="BINARY_LARGE_OBJECT" jdbcEnumType="2004" javaClassName="java.sql.Blob"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;LONGBLOB&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="CHARACTER_LARGE_OBJECT_1" keyConstraintSupported="true" defaultSupported="false" maximumLength="256" primitiveType="CHARACTER_LARGE_OBJECT" jdbcEnumType="2005" javaClassName="java.lang.String"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;TINYTEXT&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="CHARACTER_LARGE_OBJECT_2" keyConstraintSupported="true" defaultSupported="false" maximumLength="65536" primitiveType="CHARACTER_LARGE_OBJECT" jdbcEnumType="2005" javaClassName="java.lang.String"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;TEXT&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="CHARACTER_LARGE_OBJECT_3" keyConstraintSupported="true" defaultSupported="false" maximumLength="16777216" primitiveType="CHARACTER_LARGE_OBJECT" jdbcEnumType="2005" javaClassName="java.lang.String"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;MEDIUMTEXT&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="CHARACTER_LARGE_OBJECT_4" keyConstraintSupported="true" defaultSupported="false" primitiveType="CHARACTER_LARGE_OBJECT" jdbcEnumType="2005" javaClassName="java.lang.String"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;LONGTEXT&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="ENUM" keyConstraintSupported="false" primitiveType="CHARACTER_VARYING" jdbcEnumType="12" javaClassName="java.lang.String"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;ENUM&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="DATE_2" keyConstraintSupported="true" primitiveType="DATE" jdbcEnumType="91" javaClassName="java.sql.Date"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;YEAR&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="BINARY_1" lengthSupported="true" keyConstraintSupported="true" maximumLength="255" lengthUnit="BYTE" primitiveType="BINARY" jdbcEnumType="-2" javaClassName="byte[]"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;BINARY&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;predefinedDataTypeDefinitions xmi:id="BINARY_VARYING_1" lengthSupported="true" keyConstraintSupported="true" maximumLength="255" primitiveType="BINARY_VARYING" lengthUnit="BYTE" jdbcEnumType="-3" javaClassName="byte[]"&gt;
      &lt;defaultValueTypes&gt;NULL&lt;/defaultValueTypes&gt;
      &lt;name&gt;VARBINARY&lt;/name&gt;
    &lt;/predefinedDataTypeDefinitions&gt;
    &lt;storedProcedureDefinition/&gt;
    &lt;triggerDefinition/&gt;
    &lt;columnDefinition maximumIdentifierLength="64" identitySupported="true" identityIncrementSupported="true"/&gt;
    &lt;constraintDefinition clusteredPrimaryKeySupported="true" clusteredUniqueConstraintSupported="true" primaryKeyNullable="true" uniqueKeyNullable="true"&gt;
      &lt;parentUpdateDRIRuleType&gt;RESTRICT&lt;/parentUpdateDRIRuleType&gt;
      &lt;parentUpdateDRIRuleType&gt;CASCADE&lt;/parentUpdateDRIRuleType&gt;
      &lt;parentUpdateDRIRuleType&gt;SET_NULL&lt;/parentUpdateDRIRuleType&gt;
      &lt;parentUpdateDRIRuleType&gt;NO_ACTION&lt;/parentUpdateDRIRuleType&gt;
      &lt;parentDeleteDRIRuleType&gt;RESTRICT&lt;/parentDeleteDRIRuleType&gt;
      &lt;parentDeleteDRIRuleType&gt;CASCADE&lt;/parentDeleteDRIRuleType&gt;
      &lt;parentDeleteDRIRuleType&gt;SET_NULL&lt;/parentDeleteDRIRuleType&gt;
      &lt;parentDeleteDRIRuleType&gt;NO_ACTION&lt;/parentDeleteDRIRuleType&gt;
    &lt;/constraintDefinition&gt;
    &lt;indexDefinition maximumIdentifierLength="64"/&gt;
    &lt;tableDefinition maximumIdentifierLength="64"/&gt;
    &lt;udtDefinition/&gt;
    &lt;queryDefinition identifierQuoteString="`" hostVariableMarker="@" hostVariableMarkerSupported="true"/&gt;
    &lt;viewDefinition maximumIdentifierLength="64" checkOptionLevelsSupported="true"/&gt;
    &lt;SQLSyntaxDefinition&gt;
      &lt;keywords&gt;ACCESSIBLE&lt;/keywords&gt;
      &lt;keywords&gt;ADD&lt;/keywords&gt;
      &lt;keywords&gt;ALGORITHM&lt;/keywords&gt;
      &lt;keywords&gt;ALL&lt;/keywords&gt;
      &lt;keywords&gt;ALTER&lt;/keywords&gt;
      &lt;keywords&gt;ANALYZE&lt;/keywords&gt;
      &lt;keywords&gt;AND&lt;/keywords&gt;
      &lt;keywords&gt;AS&lt;/keywords&gt;
      &lt;keywords&gt;ASC&lt;/keywords&gt;
      &lt;keywords&gt;ASENSITIVE&lt;/keywords&gt;
      &lt;keywords&gt;BEFORE&lt;/keywords&gt;
      &lt;keywords&gt;BETWEEN&lt;/keywords&gt;
      &lt;keywords&gt;BIGINT&lt;/keywords&gt;
      &lt;keywords&gt;BINARY&lt;/keywords&gt;
      &lt;keywords&gt;BLOB&lt;/keywords&gt;
      &lt;keywords&gt;BOTH&lt;/keywords&gt;
      &lt;keywords&gt;BY&lt;/keywords&gt;
      &lt;keywords&gt;CALL&lt;/keywords&gt;
      &lt;keywords&gt;CASCADE&lt;/keywords&gt;
      &lt;keywords&gt;CASE&lt;/keywords&gt;
      &lt;keywords&gt;CHANGE&lt;/keywords&gt;
      &lt;keywords&gt;CHAR&lt;/keywords&gt;
      &lt;keywords&gt;CHARACTER&lt;/keywords&gt;
      &lt;keywords&gt;CHECK&lt;/keywords&gt;
      &lt;keywords&gt;CHECKSUM&lt;/keywords&gt;
      &lt;keywords&gt;COLLATE&lt;/keywords&gt;
      &lt;keywords&gt;COLUMN&lt;/keywords&gt;
      &lt;keywords&gt;COMMENT&lt;/keywords&gt;
      &lt;keywords&gt;CONDITION&lt;/keywords&gt;
      &lt;keywords&gt;CONNECTION&lt;/keywords&gt;
      &lt;keywords&gt;CONSTRAINT&lt;/keywords&gt;
      &lt;keywords&gt;CONTINUE&lt;/keywords&gt;
      &lt;keywords&gt;CONVERT&lt;/keywords&gt;
      &lt;keywords&gt;CREATE&lt;/keywords&gt;
      &lt;keywords&gt;CROSS&lt;/keywords&gt;
      &lt;keywords&gt;CURRENT_DATE&lt;/keywords&gt;
      &lt;keywords&gt;CURRENT_TIME&lt;/keywords&gt;
      &lt;keywords&gt;CURRENT_TIMESTAMP&lt;/keywords&gt;
      &lt;keywords&gt;CURRENT_USER&lt;/keywords&gt;
      &lt;keywords&gt;CURSOR&lt;/keywords&gt;
      &lt;keywords&gt;DATABASE&lt;/keywords&gt;
      &lt;keywords&gt;DATABASES&lt;/keywords&gt;
      &lt;keywords&gt;DAY_HOUR&lt;/keywords&gt;
      &lt;keywords&gt;DAY_MICROSECOND&lt;/keywords&gt;
      &lt;keywords&gt;DAY_MINUTE&lt;/keywords&gt;
      &lt;keywords&gt;DAY_SECOND&lt;/keywords&gt;
      &lt;keywords&gt;DEC&lt;/keywords&gt;
      &lt;keywords&gt;DECIMAL&lt;/keywords&gt;
      &lt;keywords&gt;DECLARE&lt;/keywords&gt;
      &lt;keywords&gt;DEFAULT&lt;/keywords&gt;
      &lt;keywords&gt;DEFINER&lt;/keywords&gt;
      &lt;keywords&gt;DELAYED&lt;/keywords&gt;
      &lt;keywords&gt;DELETE&lt;/keywords&gt;
      &lt;keywords&gt;DESC&lt;/keywords&gt;
      &lt;keywords&gt;DESCRIBE&lt;/keywords&gt;
      &lt;keywords&gt;DETERMINISTIC&lt;/keywords&gt;
      &lt;keywords&gt;DISTINCT&lt;/keywords&gt;
      &lt;keywords&gt;DISTINCTROW&lt;/keywords&gt;
      &lt;keywords&gt;DIV&lt;/keywords&gt;
      &lt;keywords&gt;DOUBLE&lt;/keywords&gt;
      &lt;keywords&gt;DROP&lt;/keywords&gt;
      &lt;keywords&gt;DUAL&lt;/keywords&gt;
      &lt;keywords&gt;EACH&lt;/keywords&gt;
      &lt;keywords&gt;ELSE&lt;/keywords&gt;
      &lt;keywords&gt;ELSEIF&lt;/keywords&gt;
      &lt;keywords&gt;ENCLOSED&lt;/keywords&gt;
      &lt;keywords&gt;ESCAPED&lt;/keywords&gt;
      &lt;keywords&gt;EXISTS&lt;/keywords&gt;
      &lt;keywords&gt;EXIT&lt;/keywords&gt;
      &lt;keywords&gt;EXPLAIN&lt;/keywords&gt;
      &lt;keywords&gt;FALSE&lt;/keywords&gt;
      &lt;keywords&gt;FETCH&lt;/keywords&gt;
      &lt;keywords&gt;FLOAT&lt;/keywords&gt;
      &lt;keywords&gt;FLOAT4&lt;/keywords&gt;
      &lt;keywords&gt;FLOAT8&lt;/keywords&gt;
      &lt;keywords&gt;FOR&lt;/keywords&gt;
      &lt;keywords&gt;FORCE&lt;/keywords&gt;
      &lt;keywords&gt;FOREIGN&lt;/keywords&gt;
      &lt;keywords&gt;FROM&lt;/keywords&gt;
      &lt;keywords&gt;FULLTEXT&lt;/keywords&gt;
      &lt;keywords&gt;GOTO&lt;/keywords&gt;
      &lt;keywords&gt;GRANT&lt;/keywords&gt;
      &lt;keywords&gt;GROUP&lt;/keywords&gt;
      &lt;keywords&gt;HAVING&lt;/keywords&gt;
      &lt;keywords&gt;HIGH_PRIORITY&lt;/keywords&gt;
      &lt;keywords&gt;HOUR_MICROSECOND&lt;/keywords&gt;
      &lt;keywords&gt;HOUR_MINUTE&lt;/keywords&gt;
      &lt;keywords&gt;HOUR_SECOND&lt;/keywords&gt;
      &lt;keywords&gt;IF&lt;/keywords&gt;
      &lt;keywords&gt;IGNORE&lt;/keywords&gt;
      &lt;keywords&gt;IN&lt;/keywords&gt;
      &lt;keywords&gt;INDEX&lt;/keywords&gt;
      &lt;keywords&gt;INFILE&lt;/keywords&gt;
      &lt;keywords&gt;INNER&lt;/keywords&gt;
      &lt;keywords&gt;INOUT&lt;/keywords&gt;
      &lt;keywords&gt;INSENSITIVE&lt;/keywords&gt;
      &lt;keywords&gt;INSERT&lt;/keywords&gt;
      &lt;keywords&gt;INT&lt;/keywords&gt;
      &lt;keywords&gt;INT1&lt;/keywords&gt;
      &lt;keywords&gt;INT2&lt;/keywords&gt;
      &lt;keywords&gt;INT3&lt;/keywords&gt;
      &lt;keywords&gt;INT4&lt;/keywords&gt;
      &lt;keywords&gt;INT8&lt;/keywords&gt;
      &lt;keywords&gt;INTEGER&lt;/keywords&gt;
      &lt;keywords&gt;INTERVAL&lt;/keywords&gt;
      &lt;keywords&gt;INTO&lt;/keywords&gt;
      &lt;keywords&gt;INVOKER&lt;/keywords&gt;
      &lt;keywords&gt;IS&lt;/keywords&gt;
      &lt;keywords&gt;ITERATE&lt;/keywords&gt;
      &lt;keywords&gt;JOIN&lt;/keywords&gt;
      &lt;keywords&gt;KEY_BLOCK_SIZE&lt;/keywords&gt;
      &lt;keywords&gt;KEY&lt;/keywords&gt;
      &lt;keywords&gt;KEYS&lt;/keywords&gt;
      &lt;keywords&gt;KILL&lt;/keywords&gt;
      &lt;keywords&gt;LABEL&lt;/keywords&gt;
      &lt;keywords&gt;LEADING&lt;/keywords&gt;
      &lt;keywords&gt;LEAVE&lt;/keywords&gt;
      &lt;keywords&gt;LEFT&lt;/keywords&gt;
      &lt;keywords&gt;LIKE&lt;/keywords&gt;
      &lt;keywords&gt;LIMIT&lt;/keywords&gt;
      &lt;keywords&gt;LINEAR&lt;/keywords&gt;
      &lt;keywords&gt;LINES&lt;/keywords&gt;
      &lt;keywords&gt;LOAD&lt;/keywords&gt;
      &lt;keywords&gt;LOCALTIME&lt;/keywords&gt;
      &lt;keywords&gt;LOCALTIMESTAMP&lt;/keywords&gt;
      &lt;keywords&gt;LOCK&lt;/keywords&gt;
      &lt;keywords&gt;LONG&lt;/keywords&gt;
      &lt;keywords&gt;LONGBLOB&lt;/keywords&gt;
      &lt;keywords&gt;LONGTEXT&lt;/keywords&gt;
      &lt;keywords&gt;LOOP&lt;/keywords&gt;
      &lt;keywords&gt;LOW_PRIORITY&lt;/keywords&gt;
      &lt;keywords&gt;MASTER_SSL_VERIFY_SERVER_CERT&lt;/keywords&gt;
      &lt;keywords&gt;MATCH&lt;/keywords&gt;
      &lt;keywords&gt;MAX_ROWS&lt;/keywords&gt;
      &lt;keywords&gt;MEDIUMBLOB&lt;/keywords&gt;
      &lt;keywords&gt;MEDIUMINT&lt;/keywords&gt;
      &lt;keywords&gt;MEDIUMTEXT&lt;/keywords&gt;
      &lt;keywords&gt;MERGE&lt;/keywords&gt;
      &lt;keywords&gt;MIDDLEINT&lt;/keywords&gt;
      &lt;keywords&gt;MIN_ROWS&lt;/keywords&gt;
      &lt;keywords&gt;MINUTE_MICROSECOND&lt;/keywords&gt;
      &lt;keywords&gt;MINUTE_SECOND&lt;/keywords&gt;
      &lt;keywords&gt;MOD&lt;/keywords&gt;
      &lt;keywords&gt;MODIFIES&lt;/keywords&gt;
      &lt;keywords&gt;NATURAL&lt;/keywords&gt;
      &lt;keywords&gt;NO_WRITE_TO_BINLOG&lt;/keywords&gt;
      &lt;keywords&gt;NOT&lt;/keywords&gt;
      &lt;keywords&gt;NULL&lt;/keywords&gt;
      &lt;keywords&gt;NUMERIC&lt;/keywords&gt;
      &lt;keywords&gt;ON&lt;/keywords&gt;
      &lt;keywords&gt;OPTIMIZE&lt;/keywords&gt;
      &lt;keywords&gt;OPTION&lt;/keywords&gt;
      &lt;keywords&gt;OPTIONALLY&lt;/keywords&gt;
      &lt;keywords&gt;OR&lt;/keywords&gt;
      &lt;keywords&gt;ORDER&lt;/keywords&gt;
      &lt;keywords&gt;OUT&lt;/keywords&gt;
      &lt;keywords&gt;OUTER&lt;/keywords&gt;
      &lt;keywords&gt;OUTFILE&lt;/keywords&gt;
      &lt;keywords&gt;PRECISION&lt;/keywords&gt;
      &lt;keywords&gt;PRIMARY&lt;/keywords&gt;
      &lt;keywords&gt;PROCEDURE&lt;/keywords&gt;
      &lt;keywords&gt;PURGE&lt;/keywords&gt;
      &lt;keywords&gt;RANGE&lt;/keywords&gt;
      &lt;keywords&gt;READ&lt;/keywords&gt;
      &lt;keywords&gt;READ_ONLY&lt;/keywords&gt;
      &lt;keywords&gt;READ_WRITE&lt;/keywords&gt;
      &lt;keywords&gt;READ&lt;/keywords&gt;
      &lt;keywords&gt;READS&lt;/keywords&gt;
      &lt;keywords&gt;REAL&lt;/keywords&gt;
      &lt;keywords&gt;REFERENCES&lt;/keywords&gt;
      &lt;keywords&gt;REGEXP&lt;/keywords&gt;
      &lt;keywords&gt;RELEASE&lt;/keywords&gt;
      &lt;keywords&gt;RENAME&lt;/keywords&gt;
      &lt;keywords&gt;REPEAT&lt;/keywords&gt;
      &lt;keywords&gt;REPLACE&lt;/keywords&gt;
      &lt;keywords&gt;REQUIRE&lt;/keywords&gt;
      &lt;keywords&gt;RESTRICT&lt;/keywords&gt;
      &lt;keywords&gt;RETURN&lt;/keywords&gt;
      &lt;keywords&gt;REVOKE&lt;/keywords&gt;
      &lt;keywords&gt;RIGHT&lt;/keywords&gt;
      &lt;keywords&gt;RLIKE&lt;/keywords&gt;
      &lt;keywords&gt;ROW_FORMAT&lt;/keywords&gt;
      &lt;keywords&gt;SCHEMA&lt;/keywords&gt;
      &lt;keywords&gt;SCHEMAS&lt;/keywords&gt;
      &lt;keywords&gt;SECOND_MICROSECOND&lt;/keywords&gt;
      &lt;keywords&gt;SELECT&lt;/keywords&gt;
      &lt;keywords&gt;SENSITIVE&lt;/keywords&gt;
      &lt;keywords&gt;SEPARATOR&lt;/keywords&gt;
      &lt;keywords&gt;SET&lt;/keywords&gt;
      &lt;keywords&gt;SHOW&lt;/keywords&gt;
      &lt;keywords&gt;SMALLINT&lt;/keywords&gt;
      &lt;keywords&gt;SONAME&lt;/keywords&gt;
      &lt;keywords&gt;SPATIAL&lt;/keywords&gt;
      &lt;keywords&gt;SPECIFIC&lt;/keywords&gt;
      &lt;keywords&gt;SQL&lt;/keywords&gt;
      &lt;keywords&gt;SQL_BIG_RESULT&lt;/keywords&gt;
      &lt;keywords&gt;SQL_CALC_FOUND_ROWS&lt;/keywords&gt;
      &lt;keywords&gt;SQL_SECURITY&lt;/keywords&gt;
      &lt;keywords&gt;SQL_SMALL_RESULT&lt;/keywords&gt;
      &lt;keywords&gt;SQL&lt;/keywords&gt;
      &lt;keywords&gt;SQLEXCEPTION&lt;/keywords&gt;
      &lt;keywords&gt;SQLSTATE&lt;/keywords&gt;
      &lt;keywords&gt;SQLWARNING&lt;/keywords&gt;
      &lt;keywords&gt;SSL&lt;/keywords&gt;
      &lt;keywords&gt;STARTING&lt;/keywords&gt;
      &lt;keywords&gt;STRAIGHT_JOIN&lt;/keywords&gt;
      &lt;keywords&gt;TABLE&lt;/keywords&gt;
      &lt;keywords&gt;TEMPTABLE&lt;/keywords&gt;
      &lt;keywords&gt;TERMINATED&lt;/keywords&gt;
      &lt;keywords&gt;THEN&lt;/keywords&gt;
      &lt;keywords&gt;TINYBLOB&lt;/keywords&gt;
      &lt;keywords&gt;TINYINT&lt;/keywords&gt;
      &lt;keywords&gt;TINYTEXT&lt;/keywords&gt;
      &lt;keywords&gt;TO&lt;/keywords&gt;
      &lt;keywords&gt;TRAILING&lt;/keywords&gt;
      &lt;keywords&gt;TRIGGER&lt;/keywords&gt;
      &lt;keywords&gt;TRUE&lt;/keywords&gt;
      &lt;keywords&gt;UNDEFINED&lt;/keywords&gt;
      &lt;keywords&gt;UNDO&lt;/keywords&gt;
      &lt;keywords&gt;UNION&lt;/keywords&gt;
      &lt;keywords&gt;UNIQUE&lt;/keywords&gt;
      &lt;keywords&gt;UNLOCK&lt;/keywords&gt;
      &lt;keywords&gt;UNSIGNED&lt;/keywords&gt;
      &lt;keywords&gt;UPDATE&lt;/keywords&gt;
      &lt;keywords&gt;UPGRADE&lt;/keywords&gt;
      &lt;keywords&gt;USAGE&lt;/keywords&gt;
      &lt;keywords&gt;USE&lt;/keywords&gt;
      &lt;keywords&gt;USING&lt;/keywords&gt;
      &lt;keywords&gt;UTC_DATE&lt;/keywords&gt;
      &lt;keywords&gt;UTC_TIME&lt;/keywords&gt;
      &lt;keywords&gt;UTC_TIMESTAMP&lt;/keywords&gt;
      &lt;keywords&gt;VALUES&lt;/keywords&gt;
      &lt;keywords&gt;VARBINARY&lt;/keywords&gt;
      &lt;keywords&gt;VARCHAR&lt;/keywords&gt;
      &lt;keywords&gt;VARCHARACTER&lt;/keywords&gt;
      &lt;keywords&gt;VARYING&lt;/keywords&gt;
      &lt;keywords&gt;WHEN&lt;/keywords&gt;
      &lt;keywords&gt;WHERE&lt;/keywords&gt;
      &lt;keywords&gt;WHILE&lt;/keywords&gt;
      &lt;keywords&gt;WITH&lt;/keywords&gt;
      &lt;keywords&gt;WRITE&lt;/keywords&gt;
      &lt;keywords&gt;XOR&lt;/keywords&gt;
      &lt;keywords&gt;YEAR_MONTH&lt;/keywords&gt;
      &lt;keywords&gt;ZEROFILL&lt;/keywords&gt;
      &lt;operators&gt;:=&lt;/operators&gt;
      &lt;operators&gt;||&lt;/operators&gt;
      &lt;operators&gt;OR&lt;/operators&gt;
      &lt;operators&gt;XOR&lt;/operators&gt;
      &lt;operators&gt;&amp;amp;&amp;amp;&lt;/operators&gt;
      &lt;operators&gt;AND&lt;/operators&gt;
      &lt;operators&gt;NOT&lt;/operators&gt;
      &lt;operators&gt;BETWEEN&lt;/operators&gt;
      &lt;operators&gt;CASE&lt;/operators&gt;
      &lt;operators&gt;WHEN&lt;/operators&gt;
      &lt;operators&gt;THEN&lt;/operators&gt;
      &lt;operators&gt;ELSE&lt;/operators&gt;
      &lt;operators&gt;=&lt;/operators&gt;
      &lt;operators&gt;&amp;lt;=&gt;&lt;/operators&gt;
      &lt;operators&gt;&gt;=&lt;/operators&gt;
      &lt;operators&gt;&gt;&lt;/operators&gt;
      &lt;operators&gt;&amp;lt;=&lt;/operators&gt;
      &lt;operators&gt;&amp;lt;&lt;/operators&gt;
      &lt;operators&gt;&amp;lt;&gt;&lt;/operators&gt;
      &lt;operators&gt;!=&lt;/operators&gt;
      &lt;operators&gt;IS&lt;/operators&gt;
      &lt;operators&gt;LIKE&lt;/operators&gt;
      &lt;operators&gt;REGEXP&lt;/operators&gt;
      &lt;operators&gt;IN&lt;/operators&gt;
      &lt;operators&gt;|&lt;/operators&gt;
      &lt;operators&gt;&amp;amp;&lt;/operators&gt;
      &lt;operators&gt;&amp;lt;&amp;lt;&lt;/operators&gt;
      &lt;operators&gt;&gt;&gt;&lt;/operators&gt;
      &lt;operators&gt;-&lt;/operators&gt;
      &lt;operators&gt;+&lt;/operators&gt;
      &lt;operators&gt;*&lt;/operators&gt;
      &lt;operators&gt;/&lt;/operators&gt;
      &lt;operators&gt;DIV&lt;/operators&gt;
      &lt;operators&gt;%&lt;/operators&gt;
      &lt;operators&gt;MOD&lt;/operators&gt;
      &lt;operators&gt;^&lt;/operators&gt;
      &lt;operators&gt;~&lt;/operators&gt;
      &lt;operators&gt;!&lt;/operators&gt;
      &lt;operators&gt;BINARY&lt;/operators&gt;
      &lt;operators&gt;COLLATE&lt;/operators&gt;
    &lt;/SQLSyntaxDefinition&gt;
  &lt;/DBDefinition:DatabaseVendorDefinition&gt;
  </code></pre>
  
  <p>My SQL:</p>
  
  <pre><code>CREATE DATABASE  IF NOT EXISTS `mydb` /*!40100 DEFAULT CHARACTER SET latin1 */;
  USE `mydb`;
  -- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)
  --
  -- Host: localhost    Database: mydb
  -- ------------------------------------------------------
  -- Server version   5.5.28
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `flour`
  --
  
  DROP TABLE IF EXISTS `flour`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `flour` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` text,
    `grain_size` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `flour`
  --
  
  LOCK TABLES `flour` WRITE;
  /*!40000 ALTER TABLE `flour` DISABLE KEYS */;
  /*!40000 ALTER TABLE `flour` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `bread`
  --
  
  DROP TABLE IF EXISTS `bread`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `bread` (
    `name` text,
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `flour_id` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `fk_bread_flour_idx` (`flour_id`),
    CONSTRAINT `fk_bread_flour` FOREIGN KEY (`flour_id`) REFERENCES `flour` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `bread`
  --
  
  LOCK TABLES `bread` WRITE;
  /*!40000 ALTER TABLE `bread` DISABLE KEYS */;
  /*!40000 ALTER TABLE `bread` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2012-11-13  8:53:50
  </code></pre>