diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index e5ee9587..08150f01 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4839,7 +4839,8 @@ 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 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; +IMPORT FOREIGN SCHEMA crt LIMIT TO (priced_at_market, bond_types, beta_estimates) FROM SERVER mysql_server INTO public; +IMPORT FOREIGN SCHEMA fixed_income LIMIT TO (map_cusip) FROM SERVER mysql_server INTO public; CREATE TABLE bond_csv_upload( id int4 NOT NULL GENERATED ALWAYS AS IDENTITY, |