From fdc05eb7f97220dbcaf7febb2184e684d9ff4d63 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Sat, 15 Dec 2012 10:17:44 -0500 Subject: [PATCH] Add primary key to summary stats. SQLAlchemy requires it. --- tables/summary_stats.tab | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/tables/summary_stats.tab b/tables/summary_stats.tab index 8e20da9..46c25a5 100755 --- a/tables/summary_stats.tab +++ b/tables/summary_stats.tab @@ -1,12 +1,14 @@ CREATE TABLE xonstat.summary_stats ( + summary_stats_id bigserial NOT NULL, total_players bigint NOT NULL, total_servers bigint NOT NULL, total_games bigint NOT NULL, total_dm_games bigint NOT NULL, total_duel_games bigint NOT NULL, total_ctf_games bigint NOT NULL, - create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC') + create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'), + CONSTRAINT summary_stats_pk PRIMARY KEY (summary_stats_id) ) WITH ( OIDS=FALSE -- 2.39.2