Change player_*_stats to bigserial - there is going to be a lot of them.

diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab
index 01c702a87563f5fe5b11bf519ceadb83d2220b1c..9cdf17c8d2c0e4a59fbaeccf6bd5f133e2c976ef 100644 (file)
--- a/tables/player_game_stats.tab
+++ b/tables/player_game_stats.tab
@@ -1,6 +1,6 @@
 CREATE TABLE xonstat.player_game_stats
 (
-  player_game_stat_id serial NOT NULL,
+  player_game_stat_id bigserial NOT NULL,
   player_id integer NOT NULL,
   game_id bigint NOT NULL,
   stat_type character varying(1),

diff --git a/tables/player_weapon_stats.tab b/tables/player_weapon_stats.tab
index 07a8ca5136c48e1e31b89ca5bc43a7ee8dc488cc..2e1990935d59075a824bbd2d82bcee51e054e0f7 100644 (file)
--- a/tables/player_weapon_stats.tab
+++ b/tables/player_weapon_stats.tab
@@ -1,6 +1,6 @@
 CREATE TABLE xonstat.player_weapon_stats
 (
-  player_weapon_stats_id serial NOT NULL,
+  player_weapon_stats_id bigserial NOT NULL,
   player_id integer NOT NULL,
   game_id bigint NOT NULL,
   weapon_cd character varying(3) NOT NULL,