diff options
| author | roundcube <roundcube@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2006-01-25 18:05:40 +0000 |
|---|---|---|
| committer | roundcube <roundcube@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2006-01-25 18:05:40 +0000 |
| commit | d457084a66102a0913a1f3bc40a7cc52a14a5f1b (patch) | |
| tree | 6b1aa6fc26a707c0dc2c5d99099c27425261c966 /roundcubemail/SQL/sqlite.initial.sql | |
| parent | 137bf73aa007dde8f60ac072acefdb3d986c2311 (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/sqlite.initial.sql')
| -rw-r--r-- | roundcubemail/SQL/sqlite.initial.sql | 1 |
1 files changed, 1 insertions, 0 deletions
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 '', |