diff options
Diffstat (limited to 'sql/serenitasdb.sql')
| -rw-r--r-- | sql/serenitasdb.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index d661d0ca..b2a8660b 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -46,11 +46,12 @@ CREATE TABLE index_maturity( tenor tenor,
maturity date,
coupon integer,
+ issue_date date,
PRIMARY KEY(index, series, tenor)
);
CREATE OR REPLACE VIEW index_desc AS
- SELECT b.*, a.tenor, a.maturity, a.coupon
+ SELECT b.*, a.tenor, a.maturity, a.coupon, a.issue_date
FROM index_maturity a
JOIN index_version b USING (index, series);
|