diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/et_tables.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index ead2f1fd..842bd627 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -52,6 +52,7 @@ CREATE TABLE loanx_user_mapping ( ALTER TABLE cusip_user_mapping OWNER TO et_user; ALTER TABLE loanx_user_mapping OWNER TO et_user; +-- markit_prices is deprecated (use markit_prices2) CREATE TABLE markit_prices ( LoanXID varchar(8), Issuer text, @@ -289,6 +290,7 @@ CREATE VIEW dealcusipmapping AS GRANT ALL ON dealcusipmapping TO et_user; +-- latest_market_prices is deprecated, (use latest_market_prices2) CREATE VIEW latest_markit_prices AS SELECT b.* FROM (SELECT MAX(pricingdate) AS latestdate, loanxid FROM markit_prices GROUP BY loanxid) a @@ -384,6 +386,7 @@ CREATE OR REPLACE FUNCTION et_ReadMapped(p_issuername text, p_maturity date, p_s END; $$ LANGUAGE plpgsql; +-- historical_markit_prices id deprecated (use historical_markit_prices2) CREATE OR REPLACE FUNCTION historical_markit_prices(p_date date) RETURNS TABLE(loanxid varchar(8), issuer text, dealname text, facility text, industry text, sp varchar(4), moodys varchar(4), amount float, maturity date, |