1 CREATE TABLE xonstat.summary_stats
3 summary_stats_id bigserial NOT NULL,
4 total_players bigint NOT NULL,
5 total_servers bigint NOT NULL,
6 total_games bigint NOT NULL,
7 total_dm_games bigint NOT NULL,
8 total_duel_games bigint NOT NULL,
9 total_ctf_games bigint NOT NULL,
10 create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
11 CONSTRAINT summary_stats_pk PRIMARY KEY (summary_stats_id)
17 ALTER TABLE xonstat.summary_stats OWNER TO xonstat;