CREATE TABLE users
(
    id SERIAL UNIQUE NOT NULL,
    url TEXT,
    name TEXT UNIQUE
);
CREATE UNIQUE INDEX users_id_idx ON users (id);


CREATE TABLE threads
(
    id SERIAL UNIQUE NOT NULL,
    url TEXT,
    createtime TIMESTAMP,
    aid INTEGER,
    hash BYTEA UNIQUE,
    name TEXT
);
CREATE UNIQUE INDEX threads_id_idx ON threads (id);
CREATE UNIQUE INDEX threads_hash_idx ON threads (hash);


CREATE TABLE messages
(
    id SERIAL UNIQUE NOT NULL,
    tid INTEGER,
    aid INTEGER,
    createtime TIMESTAMP,
    hash BYTEA UNIQUE,
    url TEXT,
    message TEXT
);

CREATE UNIQUE INDEX messages_id_idx ON messages (id);
CREATE UNIQUE INDEX messages_hash_idx ON messages (hash);

INSERT INTO messages (tid, aid, createtime, hash, url, message) VALUES (%s, %s, %s, decode(md5(%s), 'hex'), %s, %s);

SELECT id FROM users WHERE name = %s;

#checkpoint_segments = 3                # in logfile segments, min 1, 16MB each
#checkpoint_timeout = 5min              # range 30s-1h
#checkpoint_completion_target = 0.5     # checkpoint target duration, 0.0 - 1.0
#checkpoint_warning = 30s               # 0 disables