diff options
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 24eaf501..d6b660ea 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -151,10 +151,8 @@ CREATE TABLE bonds(id integer GENERATED ALWAYS AS IDENTITY PRIMARY KEY, allocated boolean NOT NULL DEFAULT false, stale bool NOT NULL DEFAULT true, emailed bool NULL DEFAULT false, - CONSTRAINT bonds_check CHECK (((cusip IS NOT NULL) OR (isin IS NOT NULL))), - CONSTRAINT bonds_pkey PRIMARY KEY (id), - CONSTRAINT bonds_cp_code_fkey1 FOREIGN KEY (cp_code) REFERENCES public.counterparties(code) ON UPDATE CASCADE, - CONSTRAINT bonds_fk FOREIGN KEY (bbg_ticket_id) REFERENCES public.bond_tickets(bbg_ticket_id) ON DELETE SET NULL + bbg_ticket_id text NULL REFERENCES public.bond_tickets(bbg_ticket_id) ON DELETE SET NULL, + CONSTRAINT bonds_check CHECK (((cusip IS NOT NULL) OR (isin IS NOT NULL))); CREATE OR REPLACE FUNCTION notify_id() |