1 files changed, 3 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 96c14999..d7eab343 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -2145,6 +2145,8 @@ CREATE TABLE valuation_reports(
         strat strategy,
         row integer NOT NULL,
         counterparty varchar(12) REFERENCES counterparties(code),
+        invticker varchar(12) NULL,
+        pricelist text NULL,
         PRIMARY KEY(periodenddate, fund, row)
 );
 
@@ -3105,7 +3107,7 @@ CREATE TYPE "rate_calendar" AS ENUM (
 	'P US;R US',
 	'P US');
 
-CREATE TABLE public.trs (
+CREATE TABLE trs (
     id int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
     dealid text NULL GENERATED ALWAYS AS ('TRS'::text || id::text) STORED,
     "fund" "fund" NOT NULL DEFAULT 'SERCGMAST'::fund,