1 files changed, 3 insertions, 2 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 772411c3..ac0b6014 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -923,10 +923,11 @@ CREATE TABLE cds_curves(
        date date NOT NULL,
        company_id integer NOT NULL,
        seniority sen NOT NULL,
+       redcode text NOT NULL,
        curve bytea NOT NULL,
-       FOREIGN KEY (id, seniority) REFERENCES bbg_issuers
+       FOREIGN KEY (company_id, seniority) REFERENCES bbg_issuers,
        PRIMARY KEY (date, company_id, seniority)
-)
+);
 
 
 CREATE TABLE USD_swap_fixings(