diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 701c6452..5b79b887 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4594,8 +4594,7 @@ CREATE TABLE cash_balances ( CREATE TYPE priced_at_market_discounting_reference_rate_t AS enum('1-month LIBOR','SOFR'); CREATE TYPE priced_at_market_ccf_engine_t AS enum('btm','serenitas'); -CREATE TYPE beta_estimates_bond_type_t AS enum('FCF','pre-COVID LCF','post-COVID LCF','pre-SSRA B1','pre-COVID SSRA B1','early post-COVID B1','2021 non-5-year-call B1','5-year call B1','pre-COVID OGB and B2','early post-COVID B2','2021 non-5-year-call B2','5-year call B2','IO'); -CREATE TYPE bond_types_bond_type_t AS enum('FCF','pre-COVID LCF','post-COVID LCF','pre-SSRA B1','pre-COVID SSRA B1','early post-COVID B1','early post-COVID B2','2021 non-5-year-call B2','2021 non-5-year-call B1','5-year call B1','5-year call B2','pre-COVID OGB and B2','IO'); +CREATE TYPE crt_bond_type AS enum('FCF','pre-COVID LCF','post-COVID LCF','pre-SSRA B1','pre-COVID SSRA B1','early post-COVID B1','early post-COVID B2','2021 non-5-year-call B2','2021 non-5-year-call B1','5-year call B1','5-year call B2','pre-COVID OGB and B2','IO', 'MI CRT FCF', 'MI CRT mid-CF', 'MI CRT pre-COVID LCF', 'MI CRT post-COVID LCF', 'MI CRT pre-COVID B1', 'MI CRT post-COVID B1'); IMPORT FOREIGN SCHEMA crt LIMIT TO (priced_at_market, map_cusip, bond_types, beta_estimates) FROM SERVER mysql_server INTO public; CREATE TABLE bond_csv_upload( |