diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 7 |
1 files changed, 4 insertions, 3 deletions
@@ -3,7 +3,7 @@ create table users ( id integer primary key autoincrement, user_name string not null, password string not null, - last_seen string default (strftime('%Y-%m-%dT%H:%M:%SZ','now')), + last_seen timestamp default CURRENT_TIMESTAMP, birthday string, nameday string, notify boolean default 1, @@ -12,6 +12,7 @@ create table users ( address_line1, address_line2, address_city_line, + timezone string, kado string ); @@ -19,7 +20,7 @@ drop table if exists news; create table news ( id integer primary key autoincrement, title string not null, - date string default (strftime('%Y-%m-%dT%H:%M:%SZ','now')), + date timestamp default CURRENT_TIMESTAMP, content string not null, content_cache string not null, user_id integer, @@ -29,7 +30,7 @@ create table news ( drop table if exists comments; create table comments ( id integer primary key autoincrement, - date string default (strftime('%Y-%m-%dT%H:%M:%SZ','now')), + date timestamp default CURRENT_TIMESTAMP, content string, content_cache string not null, user_id integer, |