diff options
| -rw-r--r-- | sql/dawn.sql | 24 |
1 files changed, 10 insertions, 14 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index f32a3a23..302edd3d 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -263,7 +263,7 @@ CREATE TABLE bond_submission( CREATE TABLE cds(id serial primary key, - dealid varchar(28) UNIQUE, + dealid varchar(28) NOT NULL, fund fund NOT NULL DEFAULT 'SERCGMAST', lastupdate timestamptz DEFAULT now(), action action NOT NULL DEFAULT 'NEW', @@ -312,7 +312,7 @@ CREATE TABLE cds(id serial primary key, ALTER TABLE cds OWNER TO dawn_user; -CREATE TRIGGER cds_dealid AFTER INSERT ON cds +CREATE TRIGGER cds_dealid BEFORE INSERT ON cds FOR EACH ROW EXECUTE PROCEDURE auto_dealid(); @@ -389,7 +389,7 @@ CREATE TABLE repos ( ALTER TABLE repo OWNER TO dawn_user; CREATE TABLE swaptions(id serial PRIMARY KEY, - dealid varchar(28) UNIQUE, + dealid varchar(28) NOT NULL UNIQUE, fund fund NOT NULL DEFAULT 'SERCGMAST', lastupdate timestamptz DEFAULT now(), action action NOT NULL, @@ -422,7 +422,7 @@ CREATE TABLE swaptions(id serial PRIMARY KEY, full_globeop_id text GENERATED ALWAYS AS ('SWO'||lpad(cast(globeop_id as text), 6, '0')|| 'K00SCLMA') STORED, ); -CREATE TRIGGER swaptions_dealid AFTER INSERT ON swaptions +CREATE TRIGGER swaptions_dealid BEFORE INSERT ON swaptions FOR EACH ROW EXECUTE PROCEDURE auto_dealid(); CREATE TABLE account_counterparty ( @@ -502,7 +502,8 @@ CREATE TABLE capfloors ( cpty_id text, globeop_id text ) -CREATE TRIGGER dealid AFTER INSERT ON capfloors + +CREATE TRIGGER dealid BEFORE INSERT ON capfloors FOR EACH ROW EXECUTE PROCEDURE auto_dealid(); CREATE TABLE futures ( @@ -531,7 +532,8 @@ CREATE TABLE futures ( ); ALTER TABLE futures OWNER TO dawn_user; -CREATE TRIGGER dealid AFTER + +CREATE TRIGGER dealid BEFORE INSERT ON futures FOR EACH ROW EXECUTE PROCEDURE auto_dealid(); @@ -547,7 +549,7 @@ EXECUTE PROCEDURE update_portf2(); CREATE TABLE wires ( id serial NOT NULL, fund fund NOT NULL, - dealid varchar(28) NULL, + dealid varchar(28) NOT NULL, lastupdate timestamp NULL DEFAULT now(), "action" action NOT NULL, folder cash_strat NOT NULL, @@ -580,7 +582,7 @@ EXECUTE PROCEDURE update_portf2(); CREATE TABLE spots ( id serial NOT NULL, fund fund NOT NULL DEFAULT 'SERCGMAST'::fund, - dealid varchar(28) NULL, + dealid varchar(28) NOT NULL, lastupdate timestamp NULL DEFAULT now(), "action" action NOT NULL, portfolio portfolio NOT NULL, @@ -703,12 +705,6 @@ CREATE OR REPLACE FUNCTION auto_dealid() END; $$ language plpgsql; -CREATE TRIGGER dealid AFTER INSERT ON capfloors -FOR EACH ROW EXECUTE PROCEDURE auto_dealid() ; - -CREATE TRIGGER swaptions_dealid AFTER INSERT ON swaptions -FOR EACH ROW EXECUTE PROCEDURE auto_dealid(); - ALTER TABLE swaptions OWNER TO dawn_user; CREATE TABLE securities(identifier varchar(12) PRIMARY KEY, |