Use UTC timestamps instead of local timestamps.

[xonotic/xonstatdb.git] / tables / servers.tab

diff --git a/tables/servers.tab b/tables/servers.tab
index 0bc4bbac54c336e4a32cae3c41c062b8d723d9be..fe3881e32a3513e9fd15418eb6129f82041fb2f1 100644 (file)
--- a/tables/servers.tab
+++ b/tables/servers.tab
@@ -9,7 +9,7 @@ CREATE TABLE xonstat.servers
   revision character varying(50),
   pure_ind boolean NOT NULL DEFAULT true,
   active_ind boolean NOT NULL DEFAULT true,
   revision character varying(50),
   pure_ind boolean NOT NULL DEFAULT true,
   active_ind boolean NOT NULL DEFAULT true,

-  create_dt timestamp without time zone NOT NULL DEFAULT now(),
+  create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),

   CONSTRAINT servers_pk PRIMARY KEY (server_id)
 )
 WITH (
   CONSTRAINT servers_pk PRIMARY KEY (server_id)
 )
 WITH (