diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/et_tables.sql | 13 |
1 files changed, 6 insertions, 7 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 886de109..d27b72d8 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -56,8 +56,9 @@ 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 ( + -- DEPRECATED (use markit_prices2) LoanXID varchar(8), Issuer text, DealName text, @@ -204,6 +205,7 @@ CREATE TABLE bloomberg_mtge ( GRANT ALL ON bloomberg_mtge TO et_user; CREATE TABLE clo_universe_old ( + -- DEPRECATED dealname varchar(10), "Deal Name" text, Manager text, @@ -342,17 +344,13 @@ $$ LANGUAGE plpgsql; GRANT ALL ON historical_cusip_universe TO et_user; - --- CREATE VIEW dealcusipmapping AS --- SELECT dealname, unnest("Deal Cusip List") AS Cusip from latest_clo_universe; - CREATE VIEW dealcusipmapping AS SELECT dealname, cusip from latest_cusip_universe; GRANT ALL ON dealcusipmapping TO et_user; --- latest_market_prices is deprecated, (use latest_market_prices2) CREATE VIEW latest_markit_prices AS + -- DEPRECATED (use latest_market_prices2) SELECT b.* FROM (SELECT MAX(pricingdate) AS latestdate, loanxid FROM markit_prices GROUP BY loanxid) a JOIN markit_prices b ON a.loanxid = b.loanxid AND a.latestdate= b.pricingdate; @@ -419,8 +417,8 @@ 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) + -- DEPRACATED (use historical_markit_prices2) RETURNS SETOF markit_prices AS $$ BEGIN RETURN QUERY SELECT b.* @@ -507,6 +505,7 @@ ALTER FUNCTION et_cusip_details(varchar(10)[]) OWNER TO et_user; CREATE OR REPLACE FUNCTION dealname_from_cusip(p_cusips VARIADIC varchar(10)[]) + -- NOT USED anymore, wasn't working very well RETURNS TABLE(p_dealname varchar(10)) AS $$ BEGIN RETURN QUERY SELECT dealname FROM dealcusipmapping a |