From d457084a66102a0913a1f3bc40a7cc52a14a5f1b Mon Sep 17 00:00:00 2001
From: roundcube <roundcube@208e9e7b-5314-0410-a742-e7e81cd9613c>
Date: Wed, 25 Jan 2006 18:05:40 +0000
Subject: Add created date to message cache

git-svn-id: https://svn.roundcube.net/trunk@125 208e9e7b-5314-0410-a742-e7e81cd9613c
---
 roundcubemail/SQL/mysql.update.sql | 7 +++++++
 1 file changed, 7 insertions(+)

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

diff --git a/roundcubemail/SQL/mysql.update.sql b/roundcubemail/SQL/mysql.update.sql
index 08ce92019..e140a94a3 100644
--- a/roundcubemail/SQL/mysql.update.sql
+++ b/roundcubemail/SQL/mysql.update.sql
@@ -48,3 +48,10 @@ CREATE TABLE `messages` (
   KEY `idx` (`idx`),
   KEY `uid` (`uid`)
 ) TYPE=MyISAM;
+
+
+
+-- RoundCube Webmail update script for MySQL databases
+-- Version 0.1-20051216
+
+ALTER TABLE `messages` ADD `created` DATETIME NOT NULL AFTER `cache_key` ;
-- 
cgit v1.2.3