diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 05aa078e..bd671454 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3305,8 +3305,8 @@ CREATE TABLE cds_tickets ( "Price (Dec)" float8 NULL, "CP" text NULL, "STP Status" text NULL, - "Trade Dt" text NULL, - "SetDt" text NULL, + "Trade Dt" date NULL, + "SetDt" date NULL, "Curncy" text NULL, "Principal" float8 NULL, "Net" float8 NULL, @@ -3388,7 +3388,7 @@ CREATE TABLE fx_tickets ( "Trader Name" text NULL, "Counterparty UUID" text NULL, "Counterparty Trader Name" text NULL, - "Date Of Deal" text NULL, + "Date Of Deal" date NULL, "Time Of Deal" text NULL, "Trade Date" text NULL, "Date Confirmed" text NULL, @@ -3417,7 +3417,7 @@ CREATE TABLE fx_tickets ( "New or Roll" text NULL, "Volume Of Interest" text NULL, "Exchange Rate Period 1" text NULL, - "Value Date Period 1 Currency 1" text NULL, + "Value Date Period 1 Currency 1" date NULL, "Tenor Period 1" text NULL, "Fixing Date Period 1" text NULL, "Fixing Source Period 1" text NULL, |