diff options
| author | Jesse Luehrs <doy@tozt.net> | 2019-08-26 01:11:00 -0400 |
|---|---|---|
| committer | Jesse Luehrs <doy@tozt.net> | 2019-08-26 01:11:00 -0400 |
| commit | d64f6f978ec8d4ab83fe0363a870efba415eecb9 (patch) | |
| tree | a1858b04f798471a84b8fab2bf464a3bf87b2e35 | |
| parent | ae336dec15670afe3b0cc74db83b5693aea0ad46 (diff) | |
| download | ynab-export-d64f6f978ec8d4ab83fe0363a870efba415eecb9.tar.gz ynab-export-d64f6f978ec8d4ab83fe0363a870efba415eecb9.zip | |
ordering
| -rw-r--r-- | data/schema.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/data/schema.sql b/data/schema.sql index fc905f4..ca5d47e 100644 --- a/data/schema.sql +++ b/data/schema.sql @@ -1,3 +1,6 @@ +DROP VIEW IF EXISTS denorm_transactions; +DROP VIEW IF EXISTS denorm_scheduled_transactions; +DROP VIEW IF EXISTS future_transactions; DROP TABLE IF EXISTS ints; DROP TABLE IF EXISTS scheduled_subtransactions; DROP TABLE IF EXISTS scheduled_transactions; @@ -130,7 +133,6 @@ CREATE TABLE ints ( i integer PRIMARY KEY ); -DROP VIEW IF EXISTS denorm_transactions; CREATE VIEW denorm_transactions AS ( WITH transactions_with_subtransactions AS ( @@ -180,7 +182,6 @@ CREATE VIEW denorm_transactions AS ( ) ); -DROP VIEW IF EXISTS denorm_scheduled_transactions; CREATE VIEW denorm_scheduled_transactions AS ( WITH scheduled_transactions_with_subtransactions AS ( @@ -228,7 +229,6 @@ CREATE VIEW denorm_scheduled_transactions AS ( ) ); -DROP VIEW IF EXISTS future_transactions; CREATE VIEW future_transactions AS ( WITH daily AS ( |