From 32efb0b6313641b29e24ba8cbad7a297e223a430 Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Wed, 10 Sep 2008 10:57:07 -0400 Subject: [PATCH] Trigger SELECT command to restore connection status after reconnect (#1485330) --- SQL/mysql.update.sql | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index 2a9603f..ae6fb75 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -19,9 +19,14 @@ -- Updates from version 0.1.1 ALTER TABLE `identities` - MODIFY `signature` text NOT NULL DEFAULT '', + MODIFY `signature` text, MODIFY `bcc` varchar(128) NOT NULL DEFAULT '', MODIFY `reply-to` varchar(128) NOT NULL DEFAULT '', MODIFY `organization` varchar(128) NOT NULL DEFAULT '', MODIFY `name` varchar(128) NOT NULL, MODIFY `email` varchar(128) NOT NULL; + +-- Updates from version 0.2-alpha + +ALTER TABLE `messages` + ADD INDEX `created_index` (`created`); -- Gitblit v1.9.1