From c01827c3e4105d990e7e3c7a0266df78b5c7db28 Mon Sep 17 00:00:00 2001
From: Jesse Luehrs <doy@tozt.net>
Date: Fri, 23 Aug 2019 01:06:02 -0400
Subject: also populate subtransactions

---
 data/schema.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'data/schema.sql')

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)
+);
-- 
cgit v1.2.3-54-g00ecf

