1 files changed, 2 insertions, 1 deletions
diff --git a/sql/mlpdb.sql b/sql/mlpdb.sql
index 02f69961..566242c6 100644
--- a/sql/mlpdb.sql
+++ b/sql/mlpdb.sql
@@ -89,7 +89,8 @@ CREATE TABLE tranche_quotes (
        TrancheDelta float,
        CorrAtDetachment float,
        Basis float,
-       QuoteSource varchar(4)
+       QuoteSource varchar(4),
+       PRIMARY KEY(QuoteDate, Index, Series, Version, Tenor, Attach, Detach, QuoteSource)
 );
 
 GRANT ALL ON quotes TO mlpdb_user;