Use UTC timestamps instead of local timestamps.

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

diff --git a/tables/db_version.tab b/tables/db_version.tab
index 90d895592f361a05937e2c20e589317e9b44f6f7..967fcc6c7a34b61b2d7ccfff99718cf2c6c59bcb 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,
-  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 db_version_pk PRIMARY KEY (version)
 )
 WITH (