diff options
| -rw-r--r-- | sql/et_tables.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 0fe7ab86..ae2ac882 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -83,12 +83,12 @@ CREATE TABLE markit_prices_old ( ALTER TABLE markit_prices_old OWNER TO et_user; CREATE TABLE markit_prices ( - LoanXID varchar(8), - Bid float, - Offer float, - Depth int, - PricingDate date, - PRIMARY KEY (LoanXID, PricingDate) + loanxid varchar(8), + bid float, + offer float, + depth int, + pricingdate date, + PRIMARY KEY (loanxid, pricingdate) ); ALTER TABLE markit_prices OWNER TO et_user; |