From b59474133a308182c69b2fd158b4f51aeffc87e4 Mon Sep 17 00:00:00 2001 From: thomascube 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