From bf2f39ea6d2b49c7495a43cca19ab18f27f8292e Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Mon, 29 Sep 2008 09:02:02 -0400 Subject: [PATCH] - #1485290: Fix unread counter when displaying cached massage in preview panel - remove some empty lines in app.js --- SQL/mysql5.initial.sql | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/SQL/mysql5.initial.sql b/SQL/mysql5.initial.sql index 546eecd..f9d647b 100644 --- a/SQL/mysql5.initial.sql +++ b/SQL/mysql5.initial.sql @@ -54,6 +54,7 @@ `headers` text NOT NULL, `structure` text, PRIMARY KEY(`message_id`), + INDEX `created_index` (`created`), UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`), CONSTRAINT `user_id_fk_messages` FOREIGN KEY (`user_id`) REFERENCES `users`(`user_id`) @@ -111,7 +112,7 @@ `email` varchar(128) NOT NULL, `reply-to` varchar(128) NOT NULL DEFAULT '', `bcc` varchar(128) NOT NULL DEFAULT '', - `signature` text NOT NULL DEFAULT '', + `signature` text, `html_signature` tinyint(1) NOT NULL DEFAULT '0', `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY(`identity_id`), -- Gitblit v1.9.1