Stop insanity with timestamps

still need to check the function which imports the old database

1 files changed, 4 insertions, 3 deletions

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,