summaryrefslogtreecommitdiff
path: root/framework
diff options
context:
space:
mode:
authorctrlaltca@gmail.com <>2011-11-10 21:04:13 +0000
committerctrlaltca@gmail.com <>2011-11-10 21:04:13 +0000
commita4724a9866bda7c0dd0ac40f8efdcdf61e7ab15a (patch)
tree4a03a67ce200af1a8f8a9b71cea5d7a6deb3b056 /framework
parent8f023db4630d41dce3142d1bde5624dcad426f38 (diff)
fix for #254
Diffstat (limited to 'framework')
-rw-r--r--framework/Caching/TDbCache.php5
1 files changed, 1 insertions, 4 deletions
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)';