Modify column structure for better reuse.

diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab
index 90fd7bae9a434b36760255cb023237b9eb1ee0fb..e72e4d6b190c9c9192e8922eb27f6b8444e5d458 100755 (executable)
--- a/tables/player_game_stats.tab
+++ b/tables/player_game_stats.tab
@@ -13,22 +13,22 @@ CREATE TABLE xonstat.player_game_stats
   suicides integer,
   score integer,
   "time" interval,
   suicides integer,
   score integer,
   "time" interval,

-  held interval,

   captures integer,
   pickups integer,
   drops integer,
   "returns" integer,
   collects integer,
   destroys integer,
   captures integer,
   pickups integer,
   drops integer,
   "returns" integer,
   collects integer,
   destroys integer,

-  destroys_holding_key integer,

   pushes integer,
   pushes integer,

-  pushed integer,

   carrier_frags integer,
   elo_delta numeric,
   carrier_frags integer,
   elo_delta numeric,

-  fastest_cap interval,
+  fastest interval,

   avg_latency numeric,
   teamrank integer,
   scoreboardpos integer,
   avg_latency numeric,
   teamrank integer,
   scoreboardpos integer,

+  laps integer,
+  revivals integer,
+  lives integer,

   create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
   CONSTRAINT player_game_stats_pk PRIMARY KEY (player_game_stat_id),
   CONSTRAINT player_game_stats_fk001 FOREIGN KEY (player_id)
   create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
   CONSTRAINT player_game_stats_pk PRIMARY KEY (player_game_stat_id),
   CONSTRAINT player_game_stats_fk001 FOREIGN KEY (player_id)