From dee3c8df476433c6e6078438168b89423e84d7f7 Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Fri, 25 Nov 2016 16:14:09 -0500
Subject: [PATCH] Add a log table for merged servers.

---
 tables/merged_servers.tab | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100755 tables/merged_servers.tab

diff --git a/tables/merged_servers.tab b/tables/merged_servers.tab
new file mode 100755
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;
-- 
2.39.2