From 8ab3ac64902e3216feaf6333a6ab93a0175b8b51 Mon Sep 17 00:00:00 2001
From: Thibaut Horel <thibaut.horel@gmail.com>
Date: Thu, 8 Nov 2012 22:22:36 +0100
Subject: User feature (view and edit profile)

---
 schema.sql | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 18ee95c..e0668c6 100644
--- a/schema.sql
+++ b/schema.sql
@@ -2,7 +2,16 @@ drop table if exists users;
 create table users (
     id integer primary key autoincrement,
     user_name string not null,
-    password string not null
+    password string not null,
+    last_seen string default (strftime('%Y-%m-%dT%H:%M:%SZ','now')),
+    birthday string,
+    nameday string,
+    notify boolean default 1,
+    email string,
+    phone string,
+    address_line1,
+    address_line2,
+    address_city_line
 );
 
 drop table if exists news;
-- 
cgit v1.2.3-70-g09d2

