diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index abe47ce6..ed452254 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -2929,8 +2929,8 @@ CREATE TABLE bond_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, @@ -2942,6 +2942,7 @@ CREATE TABLE bond_tickets ( "FIGI" text NULL, "Cusip" text NULL, "Curr Face" text NULL, + "Mat Dt" date NULL, CONSTRAINT bond_tickets_pk PRIMARY KEY (bbg_ticket_id) ); CREATE INDEX ix_bond_tickets_index ON bond_tickets USING btree (bbg_ticket_id); |