diff options
| -rw-r--r-- | sql/serenitasdb.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index 850b46d8..72d99914 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -140,8 +140,12 @@ CREATE TABLE tranche_quotes ( QuoteSource varchar(4),
markit_id integer UNIQUE,
deleted bool DEFAULT False NOT NULL,
- UNIQUE (QuoteDate, Index, Series, Version, Tenor, Attach, Detach, QuoteSource, trancheupfront)
+ UNIQUE (QuoteDate, Index, Series, Version, Tenor, Attach, Detach, QuoteSource, trancheupfrontmid)
);
+-- partial index constraint, didn't clean the db further back
+CREATE UNIQUE INDEX
+ON tranche_quotes(quotedate, index, series, version, tenor, attach, detach, quotesource, trancherunningmid)
+WHERE quotedate>='2018-11-01';
CREATE TABLE tranche_quotes_csv(
id serial PRIMARY KEY,
|