From 42598a6bfeb4f154425dc8eda993b3df8d22d36a Mon Sep 17 00:00:00 2001
From: roundcube <roundcube@208e9e7b-5314-0410-a742-e7e81cd9613c>
Date: Fri, 7 Oct 2005 14:17:08 +0000
Subject: Several bugfixes and feature improvements

git-svn-id: https://svn.roundcube.net/trunk@21 208e9e7b-5314-0410-a742-e7e81cd9613c
---
 roundcubemail/SQL/mysql.initial.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

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

diff --git a/roundcubemail/SQL/mysql.initial.sql b/roundcubemail/SQL/mysql.initial.sql
index 64d650867..7746f123d 100644
--- a/roundcubemail/SQL/mysql.initial.sql
+++ b/roundcubemail/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

