1 files changed, 18 insertions, 0 deletions
diff --git a/sql/mlpdb.sql b/sql/mlpdb.sql
index ffb67ae9..81380e86 100644
--- a/sql/mlpdb.sql
+++ b/sql/mlpdb.sql
@@ -97,3 +97,21 @@ GRANT ALL ON quotes TO mlpdb_user;
 --        162308	U+500
 
 -- All other tranches should have a unique trancheid for a given basketid, attach, detach combination
+
+CREATE TYPE curr AS ENUM('USD', 'EUR', 'JPY', 'GBP', 'CAD');
+CREATE TYPE sen AS ENUM('Senior', 'Subordinated');
+CREATE TYPE bbgSource AS ENUM('MSG1', 'CBIN', 'CBGN');
+CREATE TYPE DocClause AS ENUM('No Restructuring', 'Modified Modified Restructurin', 'Full Restructuring');
+CREATE TYPE tenor AS ENUM('6mo', '1yr', '2yr', '3yr', '4yr', '5yr', '7yr', '10yr');
+
+CREATE TABLE CDS_Issuers(
+       Name text,
+       company_id integer,
+       ticker text,
+       currency curr,
+       seniority sen,
+       doc_clause DocClause,
+       cds_curve text[8],
+       index_list integer[]);
+
+GRANT ALL ON  CDS_Issuers to mlpdb_user;