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

diff --git a/tables/achievements.tab b/tables/achievements.tab
index 1ce2cde69afceb77942506fb59e2b057fb0ac0e8..a5006a4ee03d0222dbc260c6283755bfb57aae33 100644 (file)
--- 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,
   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
   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 f67ce20a4044f81f1797833e513b3c333a84b203..90d895592f361a05937e2c20e589317e9b44f6f7 100644 (file)
--- 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,
 (
   "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 (
   CONSTRAINT db_version_pk PRIMARY KEY (version)
 )
 WITH (

diff --git a/tables/games.tab b/tables/games.tab
index 7bb1e7b58819576010b3f500157c4163527a1f2a..21e357e32ed8d9774d85b78434472aadfb1c8fb9 100644 (file)
--- a/tables/games.tab
+++ b/tables/games.tab
@@ -1,13 +1,13 @@
 CREATE TABLE xonstat.games
 (
   game_id bigserial NOT NULL,
 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,
   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
   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 b39409ae38236493353b7a6fe1c53319e45faf1a..0240c902624d30535a7098d25774e50d7a26273f 100644 (file)
--- 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,
   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
   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 9cdf17c8d2c0e4a59fbaeccf6bd5f133e2c976ef..19da7ff2a4cf099e008e0b8e366637e8dc2a1eec 100644 (file)
--- 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,
   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
   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 2e1990935d59075a824bbd2d82bcee51e054e0f7..1b3dee774252f0a6375bb79025ae8937f0cad475 100644 (file)
--- 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,
   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
   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 5f2e685c79453a7e8de211284ad4911c35428d37..ec984863695caf071be8d5172d94a74bf961e295 100644 (file)
--- 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),
   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 (
   CONSTRAINT players_pk PRIMARY KEY (player_id)
 )
 WITH (

diff --git a/tables/servers.tab b/tables/servers.tab
index c0eb3ae6688a898006dcca7d560ad77a6f4ead2e..22ee963e5e2bba9a8a852aefafe3b7fce87168b9 100644 (file)
--- 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,
   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 (
   CONSTRAINT servers_pk PRIMARY KEY (server_id)
 )
 WITH (