From 74775c6dcfaa1ca3976404477b935b6725d6df13 Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Tue, 25 Oct 2011 06:40:54 -0400
Subject: [PATCH] Add server hashkey table

---
 tables/server_hashkeys.tab | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 tables/server_hashkeys.tab

diff --git a/tables/server_hashkeys.tab b/tables/server_hashkeys.tab
new file mode 100644
index 0000000..f3d049c
--- /dev/null
+++ b/tables/server_hashkeys.tab
@@ -0,0 +1,15 @@
+CREATE TABLE xonstat.server_hashkeys
+(
+  server_id integer NOT NULL,
+  hashkey character varying(44) NOT NULL,
+  active_ind boolean NOT NULL DEFAULT true,
+  create_dt timestamp without time zone NOT NULL DEFAULT now(),
+  CONSTRAINT server_hashkeys_pk PRIMARY KEY (server_id, hashkey),
+  CONSTRAINT server_hashkeys_fk001 FOREIGN KEY (server_id)
+      REFERENCES xonstat.servers (server_id) MATCH SIMPLE
+      ON UPDATE NO ACTION ON DELETE NO ACTION
+)
+WITH (
+  OIDS=FALSE
+);
+ALTER TABLE xonstat.server_hashkeys OWNER TO xonstat;
-- 
2.39.2