diff options
Diffstat (limited to 'framework/Caching')
| -rw-r--r-- | framework/Caching/TDbCache.php | 5 |
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)';
|