[SQL-CVS] r2264 - SQLObject/branches/0.8/sqlobject/mysql

[<sub...@co...>]

Author: phd
Date: 2007-02-06 10:16:55 -0700 (Tue, 06 Feb 2007)
New Revision: 2264

Modified:
   SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py
Log:
A patch by Dan Pascu <da...@ag...> - ID columns are now INT UNSIGNED for MySQL.


Modified: SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py	2007-02-06 17:16:41 UTC (rev 2263)
+++ SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py	2007-02-06 17:16:55 UTC (rev 2264)
@@ -169,7 +169,7 @@
     def createIDColumn(self, soClass):
         if soClass.sqlmeta.idType == str:
             return '%s TEXT PRIMARY KEY' % soClass.sqlmeta.idName
-        return '%s INT PRIMARY KEY AUTO_INCREMENT' % soClass.sqlmeta.idName
+        return '%s INT UNSIGNED PRIMARY KEY AUTO_INCREMENT' % soClass.sqlmeta.idName
 
     def joinSQLType(self, join):
         return 'INT NOT NULL'