From d64f6f978ec8d4ab83fe0363a870efba415eecb9 Mon Sep 17 00:00:00 2001 From: Jesse Luehrs Date: Mon, 26 Aug 2019 01:11:00 -0400 Subject: ordering --- data/schema.sql | 6 +++--- 1 file 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 ( -- cgit v1.2.3-54-g00ecf