diff options
author | Jesse Luehrs <doy@tozt.net> | 2019-08-26 01:08:48 -0400 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2019-08-26 01:08:48 -0400 |
commit | f9a347a0ef47c052fa1845b28de74fc0498b363c (patch) | |
tree | 9521ea1af5f3b568a782f0d3fe39d42a8ce54281 /data | |
parent | c5daf76196c0238d3286d8593fe0ba0f91bd2fba (diff) | |
download | ynab-export-f9a347a0ef47c052fa1845b28de74fc0498b363c.tar.gz ynab-export-f9a347a0ef47c052fa1845b28de74fc0498b363c.zip |
typos
Diffstat (limited to 'data')
-rw-r--r-- | data/schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/data/schema.sql b/data/schema.sql index d8115a4..dccf028 100644 --- a/data/schema.sql +++ b/data/schema.sql @@ -153,7 +153,7 @@ CREATE VIEW denorm_transactions AS ( ) ) SELECT - id, + transactions_with_subtransactions.id, subtransaction_id, date, amount / 1000.0 as amount, @@ -195,7 +195,7 @@ CREATE VIEW denorm_scheduled_transactions AS ( scheduled_transactions.account_id, coalesce(scheduled_subtransactions.payee_id, scheduled_transactions.payee_id) AS payee_id, coalesce(scheduled_subtransactions.category_id, scheduled_transactions.category_id) AS category_id, - coalesce(scheduled_subtransactions.transfer_account_id, scheduled_transactions.transfer_account_id) AS transfer_account_id, + coalesce(scheduled_subtransactions.transfer_account_id, scheduled_transactions.transfer_account_id) AS transfer_account_id FROM scheduled_transactions LEFT JOIN scheduled_subtransactions ON ( scheduled_transactions.id = scheduled_subtransactions.scheduled_transaction_id |