create table active_players_mv(
	sort_order integer,
	player_id bigint,
	nick character varying(128),
	alivetime interval,
	create_dt timestamp without time zone default (now() at time zone 'UTC'),
    CONSTRAINT active_players_mv_pk PRIMARY KEY (sort_order)
);

ALTER TABLE xonstat.active_players_mv OWNER TO xonstat;