From: Ant Zucaro <azucaro@gmail.com>
Date: Sun, 6 Mar 2011 21:09:39 +0000 (-0500)
Subject: Get rid of time zones. We do not need them.
X-Git-Url: http://git.xonotic.org/?p=xonotic%2Fxonstatdb.git;a=commitdiff_plain;h=bc41c1e2a7cfb9a6f9884130a88af9160cca03c4

Get rid of time zones. We do not need them.
---

diff --git a/tables/achievements.tab b/tables/achievements.tab
index 1ce2cde..a5006a4 100644
--- a/tables/achievements.tab
+++ b/tables/achievements.tab
@@ -3,7 +3,7 @@ CREATE TABLE xonstat.achievements
   achievement_id serial NOT NULL,
   achievement_cd integer NOT NULL,
   player_id integer NOT NULL,
-  create_dt timestamp with time zone NOT NULL DEFAULT now(),
+  create_dt timestamp without time zone NOT NULL DEFAULT now(),
   CONSTRAINT achievements_pk PRIMARY KEY (achievement_id),
   CONSTRAINT achievements_fk001 FOREIGN KEY (achievement_cd)
       REFERENCES xonstat.cd_achievement (achievement_cd) MATCH SIMPLE
diff --git a/tables/db_version.tab b/tables/db_version.tab
index f67ce20..90d8955 100644
--- a/tables/db_version.tab
+++ b/tables/db_version.tab
@@ -2,7 +2,7 @@ CREATE TABLE xonstat.db_version
 (
   "version" character varying(15) NOT NULL,
   descr character varying(100) NOT NULL,
-  create_dt timestamp with time zone NOT NULL DEFAULT now(),
+  create_dt timestamp without time zone NOT NULL DEFAULT now(),
   CONSTRAINT db_version_pk PRIMARY KEY (version)
 )
 WITH (
diff --git a/tables/games.tab b/tables/games.tab
index 7bb1e7b..21e357e 100644
--- a/tables/games.tab
+++ b/tables/games.tab
@@ -1,13 +1,13 @@
 CREATE TABLE xonstat.games
 (
   game_id bigserial NOT NULL,
-  start_dt timestamp with time zone NOT NULL,
+  start_dt timestamp without time zone NOT NULL,
   game_type_cd character varying(10) NOT NULL,
   server_id integer NOT NULL,
   map_id integer NOT NULL,
   duration interval,
   winner integer,
-  create_dt timestamp with time zone NOT NULL DEFAULT now(),
+  create_dt timestamp without time zone NOT NULL DEFAULT now(),
   CONSTRAINT games_pk PRIMARY KEY (game_id),
   CONSTRAINT games_fk001 FOREIGN KEY (game_type_cd)
       REFERENCES xonstat.cd_game_type (game_type_cd) MATCH SIMPLE
diff --git a/tables/hashkeys.tab b/tables/hashkeys.tab
index b39409a..0240c90 100644
--- a/tables/hashkeys.tab
+++ b/tables/hashkeys.tab
@@ -3,7 +3,7 @@ CREATE TABLE xonstat.hashkeys
   player_id integer NOT NULL,
   hashkey character varying(44) NOT NULL,
   active_ind boolean NOT NULL DEFAULT true,
-  create_dt timestamp with time zone NOT NULL DEFAULT now(),
+  create_dt timestamp without time zone NOT NULL DEFAULT now(),
   CONSTRAINT hashkeys_pk PRIMARY KEY (player_id, hashkey),
   CONSTRAINT hashkeys_fk001 FOREIGN KEY (player_id)
       REFERENCES xonstat.players (player_id) MATCH SIMPLE
diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab
index 9cdf17c..19da7ff 100644
--- a/tables/player_game_stats.tab
+++ b/tables/player_game_stats.tab
@@ -22,7 +22,7 @@ CREATE TABLE xonstat.player_game_stats
   pushes integer,
   pushed integer,
   carrier_frags integer,
-  create_dt timestamp with time zone NOT NULL,
+  create_dt timestamp without time zone NOT NULL,
   CONSTRAINT player_game_stats_pk PRIMARY KEY (player_game_stat_id),
   CONSTRAINT player_game_stats_fk001 FOREIGN KEY (player_id)
       REFERENCES xonstat.players (player_id) MATCH SIMPLE
diff --git a/tables/player_weapon_stats.tab b/tables/player_weapon_stats.tab
index 2e19909..1b3dee7 100644
--- a/tables/player_weapon_stats.tab
+++ b/tables/player_weapon_stats.tab
@@ -7,7 +7,7 @@ CREATE TABLE xonstat.player_weapon_stats
   actual integer NOT NULL,
   max integer NOT NULL,
   frags integer NOT NULL,
-  create_dt timestamp with time zone NOT NULL DEFAULT now(),
+  create_dt timestamp without time zone NOT NULL DEFAULT now(),
   CONSTRAINT player_weapon_stats_pk PRIMARY KEY (player_weapon_stats_id),
   CONSTRAINT player_weapon_stats_fk001 FOREIGN KEY (player_id)
       REFERENCES xonstat.players (player_id) MATCH SIMPLE
diff --git a/tables/players.tab b/tables/players.tab
index 5f2e685..ec98486 100644
--- a/tables/players.tab
+++ b/tables/players.tab
@@ -3,7 +3,7 @@ CREATE TABLE xonstat.players
   player_id serial NOT NULL,
   nick character varying(64),
   "location" character varying(100),
-  create_dt timestamp with time zone NOT NULL DEFAULT now(),
+  create_dt timestamp without time zone NOT NULL DEFAULT now(),
   CONSTRAINT players_pk PRIMARY KEY (player_id)
 )
 WITH (
diff --git a/tables/servers.tab b/tables/servers.tab
index c0eb3ae..22ee963 100644
--- a/tables/servers.tab
+++ b/tables/servers.tab
@@ -7,7 +7,7 @@ CREATE TABLE xonstat.servers
   max_players integer,
   pure_ind boolean NOT NULL DEFAULT true,
   active_ind boolean NOT NULL DEFAULT true,
-  create_dt timestamp with time zone NOT NULL,
+  create_dt timestamp without time zone NOT NULL,
   CONSTRAINT servers_pk PRIMARY KEY (server_id)
 )
 WITH (