User feature (view and edit profile)

1 files changed, 10 insertions, 1 deletions

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;