1 files changed, 7 insertions, 7 deletions
diff --git a/sql/mlpdb.sql b/sql/mlpdb.sql
index 566242c6..113735bf 100644
--- a/sql/mlpdb.sql
+++ b/sql/mlpdb.sql
@@ -82,13 +82,13 @@ CREATE TABLE tranche_quotes (
        Detach smallint,
        TrancheUpfront float,
        TrancheRunning float,
-       IndexRefPrice float,
-       IndexRefSpread float,
-       IndexDuration float,
-       TrancheDuration float,
-       TrancheDelta float,
-       CorrAtDetachment float,
-       Basis float,
+       IndexRefPrice real,
+       IndexRefSpread smallint,
+       IndexDuration real,
+       TrancheDuration real,
+       TrancheDelta real,
+       CorrAtDetachment real,
+       Basis real,
        QuoteSource varchar(4),
        PRIMARY KEY(QuoteDate, Index, Series, Version, Tenor, Attach, Detach, QuoteSource)
 );