aboutsummaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql32
1 files changed, 16 insertions, 16 deletions
diff --git a/schema.sql b/schema.sql
index 0ce6e19..edf9a89 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,28 +1,28 @@
drop table if exists users;
create table users (
id integer primary key autoincrement,
- user_name string not null,
- password string not null,
+ user_name text not null,
+ password text not null,
last_seen timestamp default CURRENT_TIMESTAMP,
- birthday string,
- nameday string,
+ birthday text,
+ nameday text,
notify boolean default 1,
- email string,
- phone string,
- address_line1,
- address_line2,
- address_city_line,
- timezone string,
- kado string
+ email text,
+ phone text,
+ address_line1 text,
+ address_line2 text,
+ address_city_line text,
+ timezone text,
+ kado text
);
drop table if exists news;
create table news (
id integer primary key autoincrement,
- title string not null,
+ title text not null,
date timestamp default CURRENT_TIMESTAMP,
- content string not null,
- content_cache string not null,
+ content text not null,
+ content_cache text not null,
user_id integer,
FOREIGN KEY(user_id) REFERENCES users(id)
);
@@ -31,8 +31,8 @@ drop table if exists comments;
create table comments (
id integer primary key autoincrement,
date timestamp default CURRENT_TIMESTAMP,
- content string,
- content_cache string not null,
+ content text,
+ content_cache text not null,
user_id integer,
news_id integer,
FOREIGN KEY(user_id) REFERENCES users(id),