From 98933ba84d6618d5fba366e556932223964c7200 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Sat, 12 Aug 2006 20:28:17 +0000
Subject: [PATCH] added MSTinyInteger to MS-SQL [ticket:263]

---
 CHANGES                           | 1 +
 lib/sqlalchemy/databases/mssql.py | 6 +++++-
 2 files changed, 6 insertions(+), 1 deletion(-)

diff --git a/CHANGES b/CHANGES
index c5c2e81fa5..900f485d03 100644
--- a/CHANGES
+++ b/CHANGES
@@ -46,6 +46,7 @@ max, min, etc.) on a SelectResults that has an ORDER BY clause
 fixes to mysql text types to work with this methodology
 [ticket:269] 
 - some fixes to sqlite date type organization
+- added MSTinyInteger to MS-SQL [ticket:263]
 
 0.2.6
 - big overhaul to schema to allow truly composite primary and foreign
diff --git a/lib/sqlalchemy/databases/mssql.py b/lib/sqlalchemy/databases/mssql.py
index 414ca87e74..3c52c522ab 100644
--- a/lib/sqlalchemy/databases/mssql.py
+++ b/lib/sqlalchemy/databases/mssql.py
@@ -92,6 +92,10 @@ class MSInteger(sqltypes.Integer):
     def get_col_spec(self):
         return "INTEGER"
 
+class MSTinyInteger(sqltypes.Integer): 
+    def get_col_spec(self):
+        return "TINYINT"
+
 class MSSmallInteger(sqltypes.Smallinteger):
     def get_col_spec(self):
         return "SMALLINT"
@@ -174,7 +178,7 @@ colspecs = {
 ischema_names = {
     'int' : MSInteger,
     'smallint' : MSSmallInteger,
-    'tinyint' : MSSmallInteger,
+    'tinyint' : MSTinyInteger,
     'varchar' : MSString,
     'char' : MSChar,
     'text' : MSText,
-- 
2.47.2