From bb85623f8ab1eb263cb0bfac6e1758438eaa5bd2 Mon Sep 17 00:00:00 2001 From: svncommit <devs@roundcube.net> Date: Sun, 07 Jan 2007 21:26:47 -0500 Subject: [PATCH] fixed display of HTML attachments --- SQL/mysql.initial.sql | 9 +++++---- 1 files changed, 5 insertions(+), 4 deletions(-) diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index 7546e52..f49fd70 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -1,5 +1,5 @@ -- RoundCube Webmail initial database structure --- Version 0.1beta2 +-- Version 0.1-beta2 -- -- -------------------------------------------------------- @@ -58,6 +58,7 @@ `reply-to` varchar(128) NOT NULL default '', `bcc` varchar(128) NOT NULL default '', `signature` text NOT NULL, + `html_signature` tinyint(1) NOT NULL default '0', PRIMARY KEY (`identity_id`), KEY `user_id` (`user_id`) ); @@ -116,12 +117,12 @@ `date` datetime NOT NULL default '0000-00-00 00:00:00', `size` int(11) unsigned NOT NULL default '0', `headers` text NOT NULL, - `body` longtext, + `structure` text, PRIMARY KEY (`message_id`), KEY `user_id` (`user_id`), - KEY `cache_key` (`cache_key`), KEY `idx` (`idx`), - KEY `uid` (`uid`) + KEY `uid` (`uid`), + UNIQUE `uniqueness` (`cache_key`, `uid`) ); -- Gitblit v1.9.1