1 files changed, 10 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 1e49ed7b..9b3ded65 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -1256,7 +1256,7 @@ CREATE TYPE quote_firmness AS ENUM('FIRM', 'INDICATIVE');
 CREATE TABLE markit_singlename_quotes (
        quoteid int8 primary key,
        redcode text,
-       ticker text, 
+       ticker text,
        maturity date,
        tenor text,
        runningcoupon int,
@@ -1293,4 +1293,13 @@ CREATE TABLE hyg_option_quotes (
     option_type option_type NOT NULL,
     price float NOT NULL,
 	UNIQUE (date, expiry, strike, option_type)
+
+CREATE TYPE div_type AS ENUM ('Income');
+CREATE TABLE hyg_dvd_hist(
+    declared date,
+    ex date,
+    record date,
+    payable date PRIMARY KEY,
+    amount float,
+    dividend_type div_type
 );