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 | |
| parent | c5daf76196c0238d3286d8593fe0ba0f91bd2fba (diff) | |
| download | ynab-export-f9a347a0ef47c052fa1845b28de74fc0498b363c.tar.gz ynab-export-f9a347a0ef47c052fa1845b28de74fc0498b363c.zip | |
typos
| -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 |