Author: jfuerth
Date: Wed May 20 10:10:56 2009
New Revision: 3057
Modified:
trunk/src/ca/sqlpower/architect/ddl/MySqlDDLGenerator.java
Log:
Timestamp is a useless type in MySQL (it only supports UNIX times
1970-2035, and the JDBC driver can't even cope with selecting the default
value for timestamp (which is 0000-00-00 00:00:00). We now forward engineer
timestamp values as datetime, which is much more flexible.
Modified: trunk/src/ca/sqlpower/architect/ddl/MySqlDDLGenerator.java
==============================================================================
--- trunk/src/ca/sqlpower/architect/ddl/MySqlDDLGenerator.java (original)
+++ trunk/src/ca/sqlpower/architect/ddl/MySqlDDLGenerator.java Wed May 20
10:10:56 2009
@@ -322,7 +322,7 @@
null, DatabaseMetaData.columnNullable, true, false));
typeMap.put(Integer.valueOf(Types.TIME), new
GenericTypeDescriptor("TIME", Types.TIME, 0, "'", "'",
DatabaseMetaData.columnNullable, false, false));
- typeMap.put(Integer.valueOf(Types.TIMESTAMP), new
GenericTypeDescriptor("TIMESTAMP", Types.TIMESTAMP, 0, "'",
+ typeMap.put(Integer.valueOf(Types.TIMESTAMP), new
GenericTypeDescriptor("DATETIME", Types.TIMESTAMP, 0, "'",
"'", DatabaseMetaData.columnNullable, false, false));
typeMap.put(Integer.valueOf(Types.TINYINT), new
GenericTypeDescriptor("TINYINT", Types.TINYINT, 38, null, null,
DatabaseMetaData.columnNullable, true, false));
