From 1ae302ff76adcb188dad5383e73c5ade158ffd8a Mon Sep 17 00:00:00 2001
From: Guillaume Horel <guillaume.horel@gmail.com>
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

