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 fe03e1ce..90d4cd22 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -110,10 +110,11 @@ CREATE TABLE cds(id serial primary key, (attach IS NOT NULL AND detach IS NOT NULL))); ALTER TABLE cds OWNER TO dawn_user; + CREATE OR REPLACE FUNCTION auto_cds_dealid() RETURNS TRIGGER AS $$ BEGIN - UPDATE cds SET dealid = 'SCCDS' ||id WHERE bonds.id = NEW.id AND dealid is Null; + UPDATE cds SET dealid = 'SCCDS' ||id WHERE cds.id = NEW.id AND dealid is Null; RETURN NEW; END; $$ language plpgsql; @@ -143,7 +144,7 @@ CREATE TABLE securities(identifier varchar(12) PRIMARY KEY, ALTER TABLE securities OWNER TO dawn_user; CREATE TABLE marks(date date, - identifier varchar(12) REFERENCES securities(identifier), + identifier varchar(12) REFERENCES securities(identifier) ON DELETE CASCADE, price float, PRIMARY KEY(identifier, date)); |