From e0ddd4e6c03d533cc3f8427624e026cc20c88fa6 Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Sun, 06 Nov 2005 11:37:45 -0500 Subject: [PATCH] Added 'changed' col to contacts table and support for 160-bit session hashes --- SQL/mysql.initial.sql | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index 64d6508..73905ca 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -68,9 +68,10 @@ -- CREATE TABLE `session` ( - `sess_id` varchar(32) NOT NULL default '', + `sess_id` varchar(40) NOT NULL default '', `created` datetime NOT NULL default '0000-00-00 00:00:00', `changed` datetime NOT NULL default '0000-00-00 00:00:00', + `ip` VARCHAR(15) NOT NULL default '', `vars` text NOT NULL, PRIMARY KEY (`sess_id`) ) TYPE=MyISAM; @@ -84,7 +85,8 @@ CREATE TABLE `users` ( `user_id` int(10) unsigned NOT NULL auto_increment, `username` varchar(128) NOT NULL default '', - `mail_host` varchar(255) NOT NULL default '', + `mail_host` varchar(128) NOT NULL default '', + `alias` varchar(128) NOT NULL default '', `created` datetime NOT NULL default '0000-00-00 00:00:00', `last_login` datetime NOT NULL default '0000-00-00 00:00:00', `language` varchar(5) NOT NULL default 'en', -- Gitblit v1.9.1