Add default to servers table.

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

diff --git a/tables/servers.tab b/tables/servers.tab
index 22ee963e5e2bba9a8a852aefafe3b7fce87168b9..4be3b2f8c75cef41418f62ee8152448df397ad61 100644 (file)
--- 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 without time zone NOT NULL,
+  create_dt timestamp without time zone NOT NULL DEFAULT now(),
   CONSTRAINT servers_pk PRIMARY KEY (server_id)
 )
 WITH (