From 8cee9bac816f68e289fbcdcffd172f5800fb6b58 Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 22 Feb 2007 05:08:11 +0000 Subject: [PATCH] statement order bug found by dan scott git-svn-id: svn://svn.open-ils.org/ILS/trunk@6984 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/080.schema.money.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/080.schema.money.sql b/Open-ILS/src/sql/Pg/080.schema.money.sql index 448fae2486..0ffc89187a 100644 --- a/Open-ILS/src/sql/Pg/080.schema.money.sql +++ b/Open-ILS/src/sql/Pg/080.schema.money.sql @@ -59,12 +59,6 @@ CREATE OR REPLACE VIEW money.payment_view AS FROM money.payment p JOIN pg_class c ON (p.tableoid = c.oid); -CREATE OR REPLACE VIEW money.non_drawer_payment_view AS - SELECT p.*, c.relname AS payment_type - FROM money.bnm_payment p - JOIN pg_class c ON p.tableoid = c.oid - WHERE c.relname NOT IN ('cash_payment','check_payment','credit_card_payment'); - CREATE OR REPLACE VIEW money.transaction_billing_type_summary AS SELECT xact, billing_type AS last_billing_type, @@ -371,6 +365,12 @@ CREATE INDEX money_credit_card_payment_ts_idx ON money.credit_card_payment (paym CREATE INDEX money_credit_card_payment_accepting_usr_idx ON money.credit_card_payment (accepting_usr); CREATE INDEX money_credit_card_payment_cash_drawer_idx ON money.credit_card_payment (cash_drawer); +CREATE OR REPLACE VIEW money.non_drawer_payment_view AS + SELECT p.*, c.relname AS payment_type + FROM money.bnm_payment p + JOIN pg_class c ON p.tableoid = c.oid + WHERE c.relname NOT IN ('cash_payment','check_payment','credit_card_payment'); + CREATE OR REPLACE VIEW money.cashdrawer_payment_view AS SELECT ou.id AS org_unit, ws.id AS cashdrawer, -- 2.11.0