CREATE TABLE xonstat.players ( player_id serial NOT NULL, nick character varying(128), stripped_nick character varying(128), "location" character varying(100), email_addr character varying(255), active_ind boolean NOT NULL default true, create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'), CONSTRAINT players_pk PRIMARY KEY (player_id) ) WITH ( OIDS=FALSE ); ALTER TABLE xonstat.players OWNER TO xonstat;