1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
drop table if exists users;
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')),
birthday string,
nameday string,
notify boolean default 1,
email string,
phone string,
address_line1,
address_line2,
address_city_line
);
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')),
content string not null,
content_cache string not null,
user_id integer,
FOREIGN KEY(user_id) REFERENCES users(id)
);
drop table if exists comments;
create table comments (
id integer primary key autoincrement,
date string default (strftime('%Y-%m-%dT%H:%M:%SZ','now')),
content string not null,
content_cache string not null,
user_id integer,
news_id integer,
FOREIGN KEY(user_id) REFERENCES users(id),
FOREIGN KEY(news_id) REFERENCES news(id)
);
|
