diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/serenitasdb.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index 0dfcdc20..2eb58df5 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -472,6 +472,29 @@ CREATE TABLE USD_rates( "25Y" real,
"30Y" real)
+CREATE TABLE EUR_rates(
+ effective_date date PRIMARY KEY,
+ "1M" real,
+ "2M" real,
+ "3M" real,
+ "6M" real,
+ "9M" real,
+ "1Y" real,
+ "2Y" real,
+ "3Y" real,
+ "4Y" real,
+ "5Y" real,
+ "6Y" real,
+ "7Y" real,
+ "8Y" real,
+ "9Y" real,
+ "10Y" real,
+ "12Y" real,
+ "15Y" real,
+ "20Y" real,
+ "25Y" real,
+ "30Y" real)
+
CREATE TABLE swaption_quotes(
quotedate timestamp,
index index_type,
|