From 3e48d2eee1d2af42aa777fd5e461fa570762732e Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Fri, 21 Nov 2008 13:19:30 -0500 Subject: [PATCH] - Increase speed of session destroy and garbage clean up - Fix session timeout when DB server got clock skew (#1485490) --- SQL/mysql.initial.sql | 10 ++++++---- 1 files changed, 6 insertions(+), 4 deletions(-) diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index 019675e..07f127c 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -50,12 +50,12 @@ `user_id` int(10) unsigned NOT NULL default '0', `del` tinyint(1) NOT NULL default '0', `standard` tinyint(1) NOT NULL default '0', - `name` varchar(128) NOT NULL default '', + `name` varchar(128) NOT NULL, `organization` varchar(128) NOT NULL default '', - `email` varchar(128) NOT NULL default '', + `email` varchar(128) NOT NULL, `reply-to` varchar(128) NOT NULL default '', `bcc` varchar(128) NOT NULL default '', - `signature` text NOT NULL, + `signature` text, `html_signature` tinyint(1) NOT NULL default '0', PRIMARY KEY (`identity_id`), KEY `user_id` (`user_id`) @@ -73,7 +73,8 @@ `changed` datetime NOT NULL default '0000-00-00 00:00:00', `ip` VARCHAR(40) NOT NULL default '', `vars` text NOT NULL, - PRIMARY KEY (`sess_id`) + PRIMARY KEY (`sess_id`), + INDEX `changed_index` (`changed`) ); -- -------------------------------------------------------- @@ -119,6 +120,7 @@ `headers` text NOT NULL, `structure` text, PRIMARY KEY (`message_id`), + INDEX `created_index` (`created`), UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`) ); -- Gitblit v1.9.1