diff options
| -rw-r--r-- | sql/dawn.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index c29181ff..9a5ad97c 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3596,6 +3596,7 @@ CREATE TABLE fx_tickets ( CONSTRAINT fx_tickets_pk PRIMARY KEY (bbg_ticket_id) ); +CREATE TYPE roll_day AS ENUM ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', 'IMM'); CREATE TABLE irs ( id int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, @@ -3629,6 +3630,7 @@ CREATE TABLE irs ( upfront float8 not null, settle_date date not null, globeop_id int4 not null, + roll_day roll_day not null, bbg_ticket_id text null references irs_tickets(bbg_ticket_id) ON UPDATE CASCADE ); |