drop table if exists users;
create table users (
    id integer primary key autoincrement,
    name string not null,
    password string not null
);

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:%S','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:%S','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)
);