[SQL-CVS] r2262 - SQLObject/trunk/sqlobject/mysql

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

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

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


Modified: SQLObject/trunk/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/mysql/mysqlconnection.py	2007-02-06 15:40:44 UTC (rev 2261)
+++ SQLObject/trunk/sqlobject/mysql/mysqlconnection.py	2007-02-06 17:16:11 UTC (rev 2262)
@@ -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'