Change datatypes from integer to serial where I forgot.

diff --git a/tables/games.tab b/tables/games.tab
index 37622400588e398c0fbb3613ee02975de583c1f6..7bb1e7b58819576010b3f500157c4163527a1f2a 100644 (file)
--- 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,
   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(),
   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 df0365771359a735aee8853a35a1be749c0e4e08..dda0ff47d86dcfb93c50508d29773ea608a05bd6 100644 (file)
--- a/tables/maps.tab
+++ b/tables/maps.tab
@@ -1,6 +1,6 @@
 CREATE TABLE xonstat.maps
 (
 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),
   "name" character varying(64) NOT NULL,
   "version" integer NOT NULL DEFAULT 1,
   pk3_name character varying(100),