diff options
Diffstat (limited to 'sql/serenitasdb.sql')
| -rw-r--r-- | sql/serenitasdb.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index 523cd2a4..c8a4f953 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -129,7 +129,8 @@ CREATE TABLE tranche_quotes ( TrancheDelta real,
CorrAtDetachment real,
Basis real,
- QuoteSource varchar(4),
+ QuoteSource varchar(4)
+ UNIQUE (QuoteDate, Index, Series, Version, Tenor, Attach, Detach, QuoteSource, trancherunningmid)
);
CREATE INDEX tranche_quotes_idx ON
|