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/sqlite.initial.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'roundcubemail/SQL/sqlite.initial.sql')

diff --git a/roundcubemail/SQL/sqlite.initial.sql b/roundcubemail/SQL/sqlite.initial.sql
index 19ca6a578..147df7243 100644
--- a/roundcubemail/SQL/sqlite.initial.sql
+++ b/roundcubemail/SQL/sqlite.initial.sql
@@ -108,6 +108,7 @@ CREATE TABLE messages (
   user_id integer NOT NULL default '0',
   del tinyint NOT NULL default '0',
   cache_key varchar(128) NOT NULL default '',
+  created datetime NOT NULL default '0000-00-00 00:00:00',
   idx integer NOT NULL default '0',
   uid integer NOT NULL default '0',
   subject varchar(255) NOT NULL default '',
-- 
cgit v1.2.3