Use UTC timestamps instead of local timestamps.

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

diff --git a/tables/maps.tab b/tables/maps.tab
old mode 100644 (file)
new mode 100755 (executable)
index dda0ff4..a186a4e
--- a/tables/maps.tab
+++ b/tables/maps.tab
@@ -5,6 +5,7 @@ CREATE TABLE xonstat.maps
   "version" integer NOT NULL DEFAULT 1,
   pk3_name character varying(100),
   curl_url character varying(300),
   "version" integer NOT NULL DEFAULT 1,
   pk3_name character varying(100),
   curl_url character varying(300),

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

   CONSTRAINT maps_pk PRIMARY KEY (map_id)
 )
 WITH (
   CONSTRAINT maps_pk PRIMARY KEY (map_id)
 )
 WITH (