diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 9b9b7ce1..be7ea18e 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -809,7 +809,7 @@ CREATE FOREIGN TABLE index_maturity( issue_date date) SERVER postgresql_server; -CREATE FOREIGN TABLE index_quotes( +CREATE IF NOT EXISTS FOREIGN TABLE index_quotes( date date, index index_type, series smallint, @@ -822,7 +822,9 @@ CREATE FOREIGN TABLE index_quotes( adjcloseprice float, adjmodelprice float, duration float, - theta float) + theta float, + duration2 float, + theta2 float) SERVER postgresql_server; CREATE FOREIGN TABLE markit_tranche_quotes( |