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

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

Author: phd
Date: 2007-03-03 03:20:20 -0700 (Sat, 03 Mar 2007)
New Revision: 2381

Modified:
   SQLObject/trunk/sqlobject/mysql/mysqlconnection.py
Log:
ID columns are reverted back from INT UNSIGNED to INT for MySQL to be in accord with FOREIGN KEYs.


Modified: SQLObject/trunk/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/mysql/mysqlconnection.py	2007-03-03 10:19:59 UTC (rev 2380)
+++ SQLObject/trunk/sqlobject/mysql/mysqlconnection.py	2007-03-03 10:20:20 UTC (rev 2381)
@@ -169,7 +169,7 @@
     def createIDColumn(self, soClass):
         if soClass.sqlmeta.idType == str:
             return '%s TEXT PRIMARY KEY' % soClass.sqlmeta.idName
-        return '%s INT UNSIGNED PRIMARY KEY AUTO_INCREMENT' % soClass.sqlmeta.idName
+        return '%s INT PRIMARY KEY AUTO_INCREMENT' % soClass.sqlmeta.idName
 
     def joinSQLType(self, join):
         return 'INT NOT NULL'