CREATE TABLE news ( id SERIAL NOT NULL PRIMARY KEY, title VARCHAR(256) NOT NULL, content TEXT NOT NULL, content_nomarkup TEXT NOT NULL, author VARCHAR(32) NOT NULL REFERENCES accounts(username), created TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP );