From e4d9f05e4126501ce329fc4c36704375f6dfe681 Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Mon, 24 Nov 2008 02:59:10 -0500 Subject: [PATCH] - Added index on cache.created + small fixes in mssql DDL script --- SQL/sqlite.initial.sql | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql index 4b2c30f..e89f0d1 100644 --- a/SQL/sqlite.initial.sql +++ b/SQL/sqlite.initial.sql @@ -11,13 +11,13 @@ CREATE TABLE cache ( cache_id integer NOT NULL PRIMARY KEY, user_id integer NOT NULL default 0, - session_id varchar(40) default NULL, cache_key varchar(128) NOT NULL default '', created datetime NOT NULL default '0000-00-00 00:00:00', data longtext NOT NULL ); CREATE INDEX ix_cache_user_cache_key ON cache(user_id, cache_key); +CREATE INDEX ix_cache_created ON cache(created); -- -------------------------------------------------------- @@ -97,6 +97,7 @@ vars text NOT NULL ); +CREATE INDEX ix_session_changed ON session (changed); -- -------------------------------------------------------- -- Gitblit v1.9.1