aboutsummaryrefslogtreecommitdiffstats
path: root/sql/serenitasdb.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/serenitasdb.sql')
-rw-r--r--sql/serenitasdb.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 3ef49d37..b95125c1 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -80,7 +80,7 @@ CREATE TABLE quotes (
);
CREATE TABLE tranche_quotes (
- QuoteDate timestamp,
+ QuoteDate timestamptz,
Index index_type,
Series smallint,
Version smallint,
@@ -496,7 +496,7 @@ CREATE TABLE EUR_rates(
"30Y" real)
CREATE TABLE swaption_quotes(
- quotedate timestamp,
+ quotedate timestamptz,
index index_type,
series smallint,
expiry date,
@@ -515,7 +515,7 @@ CREATE TABLE swaption_quotes(
PRIMARY KEY(quotedate, index, series, expiry, strike))
CREATE TABLE swaption_ref_quotes(
- quotedate timestamp,
+ quotedate timestamptz,
index index_type,
series smallint,
expiry date,
@@ -526,7 +526,7 @@ CREATE TABLE swaption_ref_quotes(
PRIMARY KEY(quotedate, index, series, expiry))
CREATE TABLE swaption_calib(
- quotedate timestamp,
+ quotedate timestamptz,
index index_type,
series smallint,
expiry date,