From 1ae302ff76adcb188dad5383e73c5ade158ffd8a Mon Sep 17 00:00:00 2001 From: Guillaume Horel Date: Fri, 9 Nov 2012 21:55:15 -0500 Subject: Stop insanity with timestamps still need to check the function which imports the old database --- schema.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index 0248ce7..0ce6e19 100644 --- a/schema.sql +++ b/schema.sql @@ -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, -- cgit v1.2.3-70-g09d2