diff options
Diffstat (limited to 'sql/et_tables.sql')
| -rw-r--r-- | sql/et_tables.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 4c4c9fae..5bd1aca4 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -27,8 +27,10 @@ CREATE TABLE et_collateral ( DefaultedFlag boolean, CovLite text, isCDO boolean, + Liborfloor float, PRIMARY KEY (updatedate, Name, dealname) ); + CREATE INDEX dealname_idx ON et_collateral(dealname, updatedate); ALTER TABLE et_collateral OWNER TO et_user; @@ -332,7 +334,7 @@ CREATE OR REPLACE FUNCTION et_historicaldealinfo (p_dealname varchar(10), p_date secondlien boolean, loanxid varchar(10), et_loanxid varchar(10), cusip varchar(9), et_cusip varchar(10), intexprice float, intexpricesource text, intexpricedate date, userprice float, userpricedate date, fixedorfloat intex_fixedorfloat, - defaultedflag boolean, covlite text, iscdo boolean) AS $$ + defaultedflag boolean, covlite text, iscdo boolean, liborfloor float) AS $$ DECLARE latestdate date; BEGIN SELECT max(et_collateral.updatedate) INTO latestdate FROM et_collateral @@ -350,7 +352,7 @@ CREATE OR REPLACE FUNCTION et_latestdealinfo (p_dealname varchar(10)) secondlien boolean, loanxid varchar(10), et_loanxid varchar(10), cusip varchar(9), et_cusip varchar(10), intexprice float, intexpricesource text, intexpricedate date, userprice float, userpricedate date, fixedorfloat intex_fixedorfloat, - defaultedflag boolean, covlite text, iscdo boolean) AS $$ + defaultedflag boolean, covlite text, iscdo boolean, liborfloor float) AS $$ DECLARE latestdate date; BEGIN SELECT max(et_collateral.updatedate) INTO latestdate FROM et_collateral |