diff options
| author | thomascube <thomas@roundcube.net> | 2006-01-25 18:05:40 +0000 |
|---|---|---|
| committer | thomascube <thomas@roundcube.net> | 2006-01-25 18:05:40 +0000 |
| commit | b59474133a308182c69b2fd158b4f51aeffc87e4 (patch) | |
| tree | c31c3b00732c7ad0053e228fc8d21eae33b8dfda /SQL/sqlite.initial.sql | |
| parent | c6e808e90c67f08a821907053a83013a9213a021 (diff) | |
Add created date to message cache
Diffstat (limited to 'SQL/sqlite.initial.sql')
| -rw-r--r-- | SQL/sqlite.initial.sql | 1 |
1 files changed, 1 insertions, 0 deletions
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 '', |