From a4724a9866bda7c0dd0ac40f8efdcdf61e7ab15a Mon Sep 17 00:00:00 2001 From: "ctrlaltca@gmail.com" <> Date: Thu, 10 Nov 2011 21:04:13 +0000 Subject: fix for #254 --- framework/Caching/TDbCache.php | 5 +---- 1 file changed, 1 insertion(+), 4 deletions(-) (limited to 'framework') diff --git a/framework/Caching/TDbCache.php b/framework/Caching/TDbCache.php index 90aa88c6..834d2eb4 100644 --- a/framework/Caching/TDbCache.php +++ b/framework/Caching/TDbCache.php @@ -217,10 +217,7 @@ class TDbCache extends TCache else $blob='BLOB'; - $sql='CREATE TABLE '.$this->_cacheTable." (itemkey CHAR(128), value $blob, expire INT)"; - $db->createCommand($sql)->execute(); - - $sql='CREATE INDEX IX_itemkey ON ' . $this->_cacheTable . ' (itemkey)'; + $sql='CREATE TABLE '.$this->_cacheTable." (itemkey CHAR(128) PRIMARY KEY, value $blob, expire INTEGER)"; $db->createCommand($sql)->execute(); $sql='CREATE INDEX IX_expire ON ' . $this->_cacheTable . ' (expire)'; -- cgit v1.2.3