1 files changed, 3 insertions, 3 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 3978500e..e69f239f 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -350,7 +350,7 @@ CREATE TABLE bbg_markit_mapping(
        markit_ticker text,
        markit_tier tier,
        spread integer,
-       FOREIGN KEY (company_id, seniority) REFERENCES bbg_issuers,
+       FOREIGN KEY (company_id, seniority) REFERENCES bbg_issuers ON UPDATE CASCADE,
        PRIMARY KEY (date, company_id, seniority));
 
 GRANT ALL ON  bbg_markit_mapping to serenitas_user;
@@ -360,7 +360,7 @@ CREATE TABLE basket_constituents(
        seniority sen,
        basketid integer REFERENCES index_version,
        weight float,
-       FOREIGN KEY (company_id, seniority) REFERENCES bbg_issuers,
+       FOREIGN KEY (company_id, seniority) REFERENCES bbg_issuers ON UPDATE CASCADE,
        PRIMARY KEY (company_id, seniority, basket_id));
 
 CREATE OR REPLACE VIEW basket_constituents_current AS
@@ -1047,7 +1047,7 @@ CREATE TABLE cds_curves(
        seniority sen NOT NULL,
        redcode text NOT NULL,
        curve bytea NOT NULL,
-       FOREIGN KEY (company_id, seniority) REFERENCES bbg_issuers,
+       FOREIGN KEY (company_id, seniority) REFERENCES bbg_issuers ON UPDATE CASCADE,
        PRIMARY KEY (date, company_id, seniority)
 );