also populate subtransactions

1 files changed, 11 insertions, 0 deletions

diff --git a/data/schema.sql b/data/schema.sql
index fe690be..8a9fc3b 100644
--- a/data/schema.sql
+++ b/data/schema.sql
@@ -1,3 +1,4 @@
+DROP TABLE IF EXISTS subtransactions;
 DROP TABLE IF EXISTS transactions;
 DROP TABLE IF EXISTS payees;
 DROP TABLE IF EXISTS categories;
@@ -54,3 +55,13 @@ CREATE TABLE transactions (
     category_id text REFERENCES categories(id),
     transfer_account_id text REFERENCES accounts(id)
 );
+
+CREATE TABLE subtransactions (
+    id text PRIMARY KEY,
+    transaction_id text REFERENCES transactions(id) NOT NULL,
+    amount bigint NOT NULL,
+    memo text,
+    payee_id text REFERENCES payees(id),
+    category_id text REFERENCES categories(id),
+    transfer_account_id text REFERENCES accounts(id)
+);