diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/serenitasdb.sql | 9 |
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,
|