[SQL-CVS] r2380 - in SQLObject/branches/0.8: docs sqlobject/mysql

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

Author: phd
Date: 2007-03-03 03:19:59 -0700 (Sat, 03 Mar 2007)
New Revision: 2380

Modified:
   SQLObject/branches/0.8/docs/News.txt
   SQLObject/branches/0.8/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/branches/0.8/docs/News.txt
===================================================================
--- SQLObject/branches/0.8/docs/News.txt	2007-03-02 16:29:21 UTC (rev 2379)
+++ SQLObject/branches/0.8/docs/News.txt	2007-03-03 10:19:59 UTC (rev 2380)
@@ -115,6 +115,15 @@
 
 * Fixed aggregators and accumulators with inheritance.
 
+SQLObject 0.8.1
+===============
+
+Bug Fixes
+---------
+
+* ID columns are reverted back from INT UNSIGNED to INT for MySQL to be in
+  accord with FOREIGN KEYs.
+
 SQLObject 0.7.4
 ===============
 

Modified: SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py	2007-03-02 16:29:21 UTC (rev 2379)
+++ SQLObject/branches/0.8/sqlobject/mysql/mysqlconnection.py	2007-03-03 10:19:59 UTC (rev 2380)
@@ -65,7 +65,7 @@
         except self.module.OperationalError, e:
             raise OperationalError(
                 "%s; used connection string: host=%s, port=%s, db=%s, user=%s, pwd=%s" % (
-                e, self.host, self.port, self.db, self.user, self.password)                
+                e, self.host, self.port, self.db, self.user, self.password)
             )
 
         if hasattr(conn, 'autocommit'):
@@ -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'