Return-Path: Delivered-To: apmail-db-ddlutils-dev-archive@www.apache.org Received: (qmail 72668 invoked from network); 6 Sep 2005 18:44:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 6 Sep 2005 18:44:01 -0000 Received: (qmail 28920 invoked by uid 500); 6 Sep 2005 18:44:01 -0000 Delivered-To: apmail-db-ddlutils-dev-archive@db.apache.org Received: (qmail 28885 invoked by uid 500); 6 Sep 2005 18:44:01 -0000 Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-dev@db.apache.org Delivered-To: mailing list ddlutils-dev@db.apache.org Received: (qmail 28870 invoked by uid 500); 6 Sep 2005 18:44:00 -0000 Delivered-To: apmail-db-ddlutils-commits@db.apache.org Received: (qmail 28867 invoked by uid 99); 6 Sep 2005 18:44:00 -0000 X-ASF-Spam-Status: No, hits=-9.8 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received: from [209.237.227.194] (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 06 Sep 2005 11:44:00 -0700 Received: (qmail 72646 invoked by uid 65534); 6 Sep 2005 18:44:00 -0000 Message-ID: <20050906184400.72645.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r279060 - in /db/ddlutils/trunk/src: java/org/apache/ddlutils/platform/MySqlPlatform.java test/org/apache/ddlutils/builder/TestMySqlPlatform.java Date: Tue, 06 Sep 2005 18:44:00 -0000 To: ddlutils-commits@db.apache.org From: tomdz@apache.org X-Mailer: svnmailer-1.0.5 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Author: tomdz Date: Tue Sep 6 11:43:52 2005 New Revision: 279060 URL: http://svn.apache.org/viewcvs?rev=279060&view=rev Log: Improvement as specified in DDLUTILS-10 Modified: db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/MySqlPlatform.java db/ddlutils/trunk/src/test/org/apache/ddlutils/builder/TestMySqlPlatform.java Modified: db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/MySqlPlatform.java URL: http://svn.apache.org/viewcvs/db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/MySqlPlatform.java?rev=279060&r1=279059&r2=279060&view=diff ============================================================================== --- db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/MySqlPlatform.java (original) +++ db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/MySqlPlatform.java Tue Sep 6 11:43:52 2005 @@ -68,6 +68,10 @@ info.addNativeTypeMapping(Types.REAL, "FLOAT"); info.addNativeTypeMapping(Types.REF, "MEDIUMBLOB"); info.addNativeTypeMapping(Types.STRUCT, "LONGBLOB"); + // Since TIMESTAMP is not a stable datatype yet, and does not support a higher precision + // that DATETIME (year to seconds) as of MySQL 5, we map the JDBC type here to DATETIME + // TODO: Make this configurable + info.addNativeTypeMapping(Types.TIMESTAMP, "DATETIME"); info.addNativeTypeMapping(Types.VARBINARY, "VARCHAR"); info.addNativeTypeMapping("BOOLEAN", "TINYINT(1)"); info.addNativeTypeMapping("DATALINK", "MEDIUMBLOB"); Modified: db/ddlutils/trunk/src/test/org/apache/ddlutils/builder/TestMySqlPlatform.java URL: http://svn.apache.org/viewcvs/db/ddlutils/trunk/src/test/org/apache/ddlutils/builder/TestMySqlPlatform.java?rev=279060&r1=279059&r2=279060&view=diff ============================================================================== --- db/ddlutils/trunk/src/test/org/apache/ddlutils/builder/TestMySqlPlatform.java (original) +++ db/ddlutils/trunk/src/test/org/apache/ddlutils/builder/TestMySqlPlatform.java Tue Sep 6 11:43:52 2005 @@ -71,7 +71,7 @@ " COL_SMALLINT SMALLINT,\n"+ " COL_STRUCT LONGBLOB,\n"+ " COL_TIME TIME,\n"+ - " COL_TIMESTAMP TIMESTAMP,\n"+ + " COL_TIMESTAMP DATETIME,\n"+ " COL_TINYINT TINYINT,\n"+ " COL_VARBINARY VARCHAR(15) BINARY,\n"+ " COL_VARCHAR VARCHAR(15)\n"+