aboutsummaryrefslogtreecommitdiffstats
path: root/sql/serenitasdb.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/serenitasdb.sql')
-rw-r--r--sql/serenitasdb.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index c8a4f953..844f1e40 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),
+ markit_id integer
UNIQUE (QuoteDate, Index, Series, Version, Tenor, Attach, Detach, QuoteSource, trancherunningmid)
);