From 7a488faf070d8605780d660c32a026dfe2eb6ed8 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Thu, 22 Mar 2007 16:50:38 +0000
Subject: [PATCH] - added explicit MSTimeStamp type which takes effect when
 using types.TIMESTAMP.

---
 CHANGES                           | 3 +++
 lib/sqlalchemy/databases/mysql.py | 8 +++++++-
 2 files changed, 10 insertions(+), 1 deletion(-)

diff --git a/CHANGES b/CHANGES
index 600350ca81..cd8e97ff1e 100644
--- a/CHANGES
+++ b/CHANGES
@@ -64,6 +64,9 @@
     - added a catchall **kwargs to MSString, to help reflection of 
       obscure types (like "varchar() binary" in MS 4.0)
 
+    - added explicit MSTimeStamp type which takes effect when using 
+    types.TIMESTAMP.
+    
 - orm:
     - the full featureset of the SelectResults extension has been merged
       into a new set of methods available off of Query.  These methods
diff --git a/lib/sqlalchemy/databases/mysql.py b/lib/sqlalchemy/databases/mysql.py
index e2784a1361..5fc63234a0 100644
--- a/lib/sqlalchemy/databases/mysql.py
+++ b/lib/sqlalchemy/databases/mysql.py
@@ -124,6 +124,10 @@ class MSTime(sqltypes.Time):
         else:
             return None
 
+class MSTimeStamp(sqltypes.TIMESTAMP):
+    def get_col_spec(self):
+        return "TIMESTAMP"
+
 class MSText(sqltypes.TEXT):
     def __init__(self, **kw):
         self.binary = 'binary' in kw
@@ -232,8 +236,10 @@ colspecs = {
     sqltypes.Boolean : MSBoolean,
     sqltypes.TEXT : MSText,
     sqltypes.CHAR: MSChar,
+    sqltypes.TIMESTAMP: MSTimeStamp
 }
 
+
 ischema_names = {
     'boolean':MSBoolean,
     'bigint' : MSBigInteger,
@@ -251,7 +257,7 @@ ischema_names = {
     'numeric' : MSNumeric,
     'float' : MSFloat,
     'double' : MSDouble,
-    'timestamp' : MSDateTime,
+    'timestamp' : MSTimeStamp,
     'datetime' : MSDateTime,
     'date' : MSDate,
     'time' : MSTime,
-- 
2.47.2