Add a log table for merged servers.

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

diff --git a/tables/merged_servers.tab b/tables/merged_servers.tab
new file mode 100755 (executable)
index 0000000..ab7ec3f
--- /dev/null
+++ b/tables/merged_servers.tab
@@ -0,0 +1,13 @@
+CREATE TABLE xonstat.merged_servers
+(
+  winning_server_id integer NOT NULL,
+  losing_server_id integer NOT NULL,
+  unmerged_ind boolean NOT NULL DEFAULT false,
+  create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
+  CONSTRAINT merged_servers_pk PRIMARY KEY (winning_server_id, losing_server_id)
+)
+WITH (
+  OIDS=FALSE
+);
+
+ALTER TABLE xonstat.merged_servers OWNER TO xonstat;