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 df03657..a186a4e
--- a/tables/maps.tab
+++ b/tables/maps.tab
@@ -1,10 +1,11 @@
 CREATE TABLE xonstat.maps
 (
-  map_id integer NOT NULL,
+  map_id serial NOT NULL,
   "name" character varying(64) NOT NULL,
   "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 (