diff options
Diffstat (limited to 'data/schema.sql')
-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 |