From 1fa3692fa8552034c40a61b7df137c322f87446a Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 22 Feb 2007 03:44:31 +0000 Subject: [PATCH] dan spotted this one too -- miss-ordered view creation git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_0@6983 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/080.schema.money.sql | 13 +++++++------ 1 file changed, 7 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..fe974c5562 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, @@ -329,6 +323,7 @@ CREATE TABLE money.bnm_desk_payment ( ) INHERITS (money.bnm_payment); ALTER TABLE money.bnm_desk_payment ADD PRIMARY KEY (id); + CREATE OR REPLACE VIEW money.desk_payment_view AS SELECT p.*,c.relname AS payment_type FROM money.bnm_desk_payment p @@ -371,6 +366,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