Pastebin

CREATE TABLE paste
(
        id INTEGER NOT NULL DEFAULT nextval('paste_id_seq'),
        date_created TIMESTAMP NOT NULL DEFAULT now(),
        sender_ip TEXT NOT NULL,
        sender_name TEXT NOT NULL,
        title TEXT NOT NULL,
        value TEXT NOT NULL,
        num_hits INTEGER NOT NULL DEFAULT 0,
        date_last_hit TIMESTAMP NULL DEFAULT now(),
        sender_useragent TEXT NULL
);