diff options
Diffstat (limited to 'sql/et_tables.sql')
| -rw-r--r-- | sql/et_tables.sql | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 362123c9..1ddeff67 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -277,22 +277,6 @@ CREATE TABLE clo_universe_old ( PRIMARY KEY (dealname, "Latest Update") ); -CREATE TABLE clo_universe ( - dealname varchar(10) REFERENCES deal_indicative, - "Curr Deal Bal" float, - "Curr Collat Bal" float, - "Tranche Factor" float, - "Principal Bal" float, - "Interest Bal" float, - "CDO Percentage" float, - "Defaulted Bal" float, - "Curr Coupon" float, - "Latest Update" date, - PRIMARY KEY (dealname, "Latest Update") -); - -GRANT ALL ON clo_universe TO et_user; - CREATE TABLE deal_indicative ( dealname varchar(10) PRIMARY KEY, "Deal Name" text, @@ -310,6 +294,22 @@ CREATE TABLE deal_indicative ( GRANT ALL ON deal_indicative TO et_user; +CREATE TABLE clo_universe ( + dealname varchar(10) REFERENCES deal_indicative, + "Curr Deal Bal" float, + "Curr Collat Bal" float, + "Tranche Factor" float, + "Principal Bal" float, + "Interest Bal" float, + "CDO Percentage" float, + "Defaulted Bal" float, + "Curr Coupon" float, + "Latest Update" date, + PRIMARY KEY (dealname, "Latest Update") +); + +GRANT ALL ON clo_universe TO et_user; + CREATE TABLE cusip_universe ( Cusip varchar(9), ISIN varchar(12), |