diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 2 | ||||
| -rw-r--r-- | sql/quantifi.sql | 3 |
2 files changed, 5 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index e8724f34..f07cce69 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3,6 +3,8 @@ CREATE TYPE bond_strat AS ENUM('M_STR_MAV', 'M_STR_MEZZ', 'CSO_TRANCH', 'M_CLO_BB20', 'M_CLO_AAA', 'M_CLO_BBB', 'M_MTG_IO', 'M_MTG_THRU', 'M_MTG_GOOD', 'M_MTG_B4PR', 'M_MTG_RW', 'M_MTG_FP', 'M_MTG_LMG', 'M_MTG_SD', 'M_MTG_PR', 'M_MTG_CRT_SD', 'CRT_LD', 'CRT_LD_JNR', + 'CRT_SD', + 'IGNORE' 'MTG_REPO'); CREATE TYPE cds_strat AS ENUM('HEDGE_CSO', 'HEDGE_CLO', 'HEDGE_MAC', 'HEDGE_MBS', diff --git a/sql/quantifi.sql b/sql/quantifi.sql index 1191c589..17fe1d95 100644 --- a/sql/quantifi.sql +++ b/sql/quantifi.sql @@ -1,3 +1,4 @@ + CREATE TABLE bespokes ( "date" date NOT NULL, "row" int8 NOT NULL, @@ -318,3 +319,5 @@ CREATE TABLE swaptions ( CONSTRAINT qf_swaptions_pk PRIMARY KEY (date, "row") ); + CREATE SERVER dawndb_server FOREIGN DATA WRAPPER postgres_fdw OPTIONS (dbname 'dawndb'); + CREATE USER MAPPING FOR quantifi_user SERVER dawndb_server OPTIONS (user 'dawn_user', password '****'); |