diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 8d2c5b93..ba1b878b 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -910,7 +910,7 @@ CREATE TYPE strategy AS ENUM('CLOCDSCSH', 'CLO_AAA', 'CLO_BB20', 'CLO_BBB', 'CSH 'SERCGLLC__SERCGLLC', 'SERCGLTD__SERCGLTD', 'SERCGLTD__SERLTD_EXP', 'SER_TEST__SER_TEST', 'STR_MAV', 'STR_MEZZ') -CREATE TABLE val_reports( +CREATE TABLE valuation_reports( custacctname text, endbookcost float, endbookmv float, @@ -928,7 +928,7 @@ CREATE TABLE val_reports( invdesc text, invid text, invtype text, - knowledgedate date NOT NULL, + knowledgedate timestamp NOT NULL, periodenddate date NOT NULL, port portfolio, strat strategy, @@ -936,7 +936,7 @@ CREATE TABLE val_reports( PRIMARY KEY(periodenddate, row) ); -CREATE INDEX on val_reports (periodenddate); +CREATE INDEX on valuation_reports (periodenddate); CREATE TYPE longshort AS ENUM('L', 'S'); @@ -1010,8 +1010,8 @@ CREATE TABLE cds_reports( fund fund, gtid text, geneva_id text, - "independent_%" float, independent_amount float, + independent_perc float, maturity_date date, notional float, original_gtid text, @@ -1036,6 +1036,8 @@ CREATE TABLE cds_reports( upfront_fee_date date, PRIMARY KEY(date, row)); +CREATE INDEX on cds_reports (date); + CREATE TYPE mark_list AS (date date, identifier text, "BROKER" float, |