diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/quantifi.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/sql/quantifi.sql b/sql/quantifi.sql index 9ed574bf..d1dd9b85 100644 --- a/sql/quantifi.sql +++ b/sql/quantifi.sql @@ -102,13 +102,13 @@ CREATE TABLE cdxqf ( subfamily text NULL, currentnotional float8 NULL, riskyduration float8 NULL, - maturity text NULL, + maturity date NULL, beta float8 NULL, fxratequote float8 NULL, cs01 float8 NULL, cs10 float8 NULL, cs50 float8 NULL, - tradedate text NULL, + tradedate date NULL, substrategy text NULL, broker_longname text NULL, CONSTRAINT qf_cdxqf_pk PRIMARY KEY (date, "row") @@ -352,4 +352,6 @@ CREATE TABLE quantifi_submission( successes int, total int, UNIQUE (uploadtime, filename) -);
\ No newline at end of file +); + + |