From 42b11351497ce67e96a0465c76694632cdfb3ecb Mon Sep 17 00:00:00 2001
From: thomascube <thomas@roundcube.net>
Date: Fri, 7 Oct 2005 14:17:08 +0000
Subject: Several bugfixes and feature improvements

---
 SQL/mysql.initial.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'SQL/mysql.initial.sql')

diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql
index 64d650867..7746f123d 100644
--- a/SQL/mysql.initial.sql
+++ b/SQL/mysql.initial.sql
@@ -71,6 +71,7 @@ CREATE TABLE `session` (
   `sess_id` varchar(32) 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 `session` (
 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',
-- 
cgit v1.2.3

