From 948535f9f22b40545c337df376edccd319902b58 Mon Sep 17 00:00:00 2001 From: Chuck Hagenbuch Date: Thu, 5 Mar 2009 22:37:43 -0500 Subject: [PATCH] make primary keys unsigned --- framework/Db/lib/Horde/Db/Adapter/Mysql/Schema.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/framework/Db/lib/Horde/Db/Adapter/Mysql/Schema.php b/framework/Db/lib/Horde/Db/Adapter/Mysql/Schema.php index 9453c5982..03178dd97 100644 --- a/framework/Db/lib/Horde/Db/Adapter/Mysql/Schema.php +++ b/framework/Db/lib/Horde/Db/Adapter/Mysql/Schema.php @@ -72,7 +72,7 @@ class Horde_Db_Adapter_Mysql_Schema extends Horde_Db_Adapter_Abstract_Schema public function nativeDatabaseTypes() { return array( - 'primaryKey' => 'int(11) DEFAULT NULL auto_increment PRIMARY KEY', + 'primaryKey' => 'int(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY', 'string' => array('name' => 'varchar', 'limit' => 255), 'text' => array('name' => 'text', 'limit' => null), 'integer' => array('name' => 'int', 'limit' => 11), -- 2.11.0