summaryrefslogtreecommitdiff
path: root/roundcubemail/SQL/mysql.update.sql
diff options
context:
space:
mode:
authorroundcube <roundcube@208e9e7b-5314-0410-a742-e7e81cd9613c>2006-01-25 18:05:40 +0000
committerroundcube <roundcube@208e9e7b-5314-0410-a742-e7e81cd9613c>2006-01-25 18:05:40 +0000
commitd457084a66102a0913a1f3bc40a7cc52a14a5f1b (patch)
tree6b1aa6fc26a707c0dc2c5d99099c27425261c966 /roundcubemail/SQL/mysql.update.sql
parent137bf73aa007dde8f60ac072acefdb3d986c2311 (diff)
Add created date to message cache
git-svn-id: https://svn.roundcube.net/trunk@125 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/SQL/mysql.update.sql')
-rw-r--r--roundcubemail/SQL/mysql.update.sql7
1 files changed, 7 insertions, 0 deletions
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` ;