1 files changed, 4 insertions, 5 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 0e591d1d..358acf85 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -858,8 +858,7 @@ CREATE TABLE swaption_quotes(
        gamma float,
        tail float);
 
-ALTER TABLE swaption_quotes ADD CONSTRAINT swaption_quotes_unique_ref_id_strike
-UNIQUE (ref_id, strike);
+ALTER TABLE swaption_quotes ADD UNIQUE (ref_id, strike);
 
 CREATE TABLE swaption_ref_quotes(
        ref_id serial PRIMARY KEY,
@@ -871,11 +870,11 @@ CREATE TABLE swaption_ref_quotes(
        fwdprice float,
        fwdspread  float,
        fwdbpv float,
-       quote_source varchar(4));
+       quote_source varchar(4),
+       msg_id bigint);
 
 CREATE INDEX  ON swaption_ref_quotes (quotedate, index, series);
-ALTER TABLE swaption_ref_quotes ADD CONSTRAINT swaption_ref_quotes_unique_quotedate_index_series_expiry
-UNIQUE (quotedate, index, series, expiry);
+ALTER TABLE swaption_ref_quotes ADD UNIQUE(quotedate, index, series, expiry);
 
 CREATE TABLE swaption_calib(
        quote_id integer PRIMARY KEY REFERENCES swaption_quotes,