added MSTinyInteger to MS-SQL [ticket:263]

2 files changed, 6 insertions, 1 deletions

diff --git a/CHANGES b/CHANGES
index c5c2e81fa..900f485d0 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 414ca87e7..3c52c522a 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,