From 3febe395884e779991817cd68520e08765ad1a56 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Sun, 6 Mar 2011 16:04:32 -0500 Subject: [PATCH] Change datatypes from integer to serial where I forgot. --- tables/games.tab | 2 +- tables/maps.tab | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/tables/games.tab b/tables/games.tab index 3762240..7bb1e7b 100644 --- a/tables/games.tab +++ b/tables/games.tab @@ -4,7 +4,7 @@ CREATE TABLE xonstat.games start_dt timestamp with time zone NOT NULL, game_type_cd character varying(10) NOT NULL, server_id integer NOT NULL, - map_id serial NOT NULL, + map_id integer NOT NULL, duration interval, winner integer, create_dt timestamp with time zone NOT NULL DEFAULT now(), diff --git a/tables/maps.tab b/tables/maps.tab index df03657..dda0ff4 100644 --- a/tables/maps.tab +++ b/tables/maps.tab @@ -1,6 +1,6 @@ CREATE TABLE xonstat.maps ( - map_id integer NOT NULL, + map_id serial NOT NULL, "name" character varying(64) NOT NULL, "version" integer NOT NULL DEFAULT 1, pk3_name character varying(100), -- 2.39.2