From bb269009db92c73d560c2afaae5b79a3c981bb82 Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Mon, 20 Aug 2012 21:28:58 -0400
Subject: [PATCH] Add the ladder code table.

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

diff --git a/tables/cd_ladder.tab b/tables/cd_ladder.tab
new file mode 100644
index 0000000..fbc9f00
--- /dev/null
+++ b/tables/cd_ladder.tab
@@ -0,0 +1,15 @@
+CREATE TABLE xonstat.cd_ladder
+(
+  ladder_cd serial NOT NULL,
+  title character varying(100) NOT NULL,
+  descr character varying(200) NOT NULL,
+  create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
+  start_dt date NOT NULL,
+  end_dt date NOT NULL,
+  active_ind boolean NOT NULL DEFAULT true,
+  CONSTRAINT cd_ladder_pk PRIMARY KEY (ladder_cd)
+)
+WITH (
+  OIDS=FALSE
+);
+ALTER TABLE xonstat.cd_ladder OWNER TO xonstat;
-- 
2.39.2