diff options
| -rw-r--r-- | sql/dawn.sql | 6 | ||||
| -rw-r--r-- | sql/serenitasdb.sql | 8 |
2 files changed, 7 insertions, 7 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index f5574558..2ddd365f 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -88,7 +88,7 @@ CREATE TRIGGER dealid CREATE TABLE cds(id serial primary key, dealid varchar(28), - lastupdate timestamp DEFAULT now(), + lastupdate timestamptz DEFAULT now(), action action, folder cds_strat NOT NULL, custodian varchar(12) NOT NULL, @@ -125,7 +125,7 @@ FOR EACH ROW EXECUTE PROCEDURE auto_dealid(); CREATE TABLE repo(id serial primary key, dealid varchar(28), - lastupdate timestamp DEFAULT now(), + lastupdate timestamptz DEFAULT now(), action action, folder bond_strat NOT NULL, custodian varchar(12) NOT NULL, @@ -160,7 +160,7 @@ ALTER TABLE repo OWNER TO dawn_user; CREATE TABLE swaptions(id serial PRIMARY KEY, dealid varchar(28) UNIQUE, - lastupdate timestamp DEFAULT now(), + lastupdate timestamptz DEFAULT now(), action action, folder swaption_strat NOT NULL, custodian varchar(12) NOT NULL, 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,
|