From 3e71ab7a6c84583f23c33c733f606fa1b5d68d4d Mon Sep 17 00:00:00 2001
From: svncommit <devs@roundcube.net>
Date: Fri, 19 Oct 2007 10:04:43 -0400
Subject: [PATCH] Fix moving folders to root, bug introduces when using row id's instead of folder names.

---
 SQL/sqlite.initial.sql |    7 ++++---
 1 files changed, 4 insertions(+), 3 deletions(-)

diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
index 4ddc40d..4ae7529 100644
--- a/SQL/sqlite.initial.sql
+++ b/SQL/sqlite.initial.sql
@@ -1,5 +1,5 @@
 -- RoundCube Webmail initial database structure
--- Version 0.1-beta2
+-- Version 0.1-rc1
 -- 
 
 -- --------------------------------------------------------
@@ -58,7 +58,8 @@
   email varchar(128) NOT NULL default '',
   "reply-to" varchar(128) NOT NULL default '',
   bcc varchar(128) NOT NULL default '',
-  signature text NOT NULL default ''
+  signature text NOT NULL default '',
+  html_signature tinyint NOT NULL default '0'
 );
 
 CREATE INDEX ix_identities_user_id ON identities(user_id);
@@ -92,7 +93,7 @@
   sess_id varchar(40) NOT NULL PRIMARY KEY,
   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 '',
+  ip varchar(40) NOT NULL default '',
   vars text NOT NULL
 );
 

--
Gitblit v1.9.1