diff options
| -rw-r--r-- | sql/serenitasdb.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index dcbf01a3..d1e83e3a 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -447,3 +447,27 @@ newdetach:=LEAST(GREATEST((detach-100*cumulativeloss)/index_factor, 0), 1); RETURN (newdetach-newattach)/(detach-attach)*index_factor;
END;
$$ LANGUAGE plpgsql;
+
+
+CREATE TABLE USD_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)
|