From bc41c1e2a7cfb9a6f9884130a88af9160cca03c4 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Sun, 6 Mar 2011 16:09:39 -0500 Subject: [PATCH] Get rid of time zones. We do not need them. --- tables/achievements.tab | 2 +- tables/db_version.tab | 2 +- tables/games.tab | 4 ++-- tables/hashkeys.tab | 2 +- tables/player_game_stats.tab | 2 +- tables/player_weapon_stats.tab | 2 +- tables/players.tab | 2 +- tables/servers.tab | 2 +- 8 files changed, 9 insertions(+), 9 deletions(-) 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 ( -- 2.39.2