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

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

diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
index 19ca6a578..147df7243 100644
--- a/SQL/sqlite.initial.sql
+++ b/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

