1 files changed, 7 insertions, 2 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 925e47c7..8b5b03d8 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -223,7 +223,9 @@ CREATE TABLE IF NOT EXISTS RefEntity(
        isdatransactiontypes jsonb,
        validto date,
        validfrom date,
-       events jsonb);
+       events jsonb,
+       holdco bool,
+       country varchar(3));
 
 CREATE TABLE IF NOT EXISTS RefObligation(
        id serial PRIMARY KEY,
@@ -257,7 +259,10 @@ CREATE TABLE IF NOT EXISTS RedPairMapping(
        indexconstituents text[],
        recorddate date NOT NULL,
        publiccomments text,
-       myticker text);
+       myticker text,
+       subordinationtype text,
+       holdco bool,
+       preferredremovaldate date);
 
 CREATE TYPE curr AS ENUM('USD', 'EUR', 'JPY', 'GBP', 'CAD');
 CREATE TYPE sen AS ENUM('Senior', 'Subordinated');