Add a log table for merged servers.
authorAnt Zucaro <azucaro@gmail.com>
Fri, 25 Nov 2016 21:14:09 +0000 (16:14 -0500)
committerAnt Zucaro <azucaro@gmail.com>
Fri, 25 Nov 2016 21:14:09 +0000 (16:14 -0500)
tables/merged_servers.tab [new file with mode: 0755]

diff --git a/tables/merged_servers.tab b/tables/merged_servers.tab
new file mode 100755 (executable)
index 0000000..ab7ec3f
--- /dev/null
@@ -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;