From b59474133a308182c69b2fd158b4f51aeffc87e4 Mon Sep 17 00:00:00 2001
From: thomascube <thomas@roundcube.net>
Date: Wed, 25 Jan 2006 18:05:40 +0000
Subject: Add created date to message cache

---
 SQL/mysql.update.sql | 7 +++++++
 1 file changed, 7 insertions(+)

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

diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index 08ce92019..e140a94a3 100644
--- a/SQL/mysql.update.sql
+++ b/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

