CREATE TABLE users ( id SERIAL NOT NULL PRIMARY KEY, power_level INTEGER NOT NULL DEFAULT 0, name VARCHAR(32) UNIQUE NOT NULL, created timestamp NOT NULL DEFAULT current_timestamp(), hash CHAR(120) BINARY NOT NULL );