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));