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,
    kado string
);

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,
    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)
);
