1 files changed, 10 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 4c0d7e4e..f8a6f32c 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -353,6 +353,16 @@ CREATE TABLE spots (
 	CONSTRAINT spots_cp_code_fkey FOREIGN KEY (cp_code) REFERENCES counterparties(code)
 );
 
+CREATE TABLE terminations (
+    id int GENERATED BY default as identity primary KEY,
+    dealid varchar(28) NOT NULL,
+    termination_date date NOT NULL,
+    termination_cp varchar(12) REFERENCES counterparties(code),
+    termination_amount float8,
+    termination_fee float8 NOT NULL,
+    partial_termination bool NOT null default false
+);
+
 create
     trigger dealid after insert
         on