view-izing the base payment table and adding the "payment_type" field

[Evergreen.git] / Open-ILS / src / sql / Postgres / 080.schema.money.sql

diff --git a/Open-ILS/src/sql/Postgres/080.schema.money.sql b/Open-ILS/src/sql/Postgres/080.schema.money.sql
index 2328c33..19ee3b1 100644 (file)
--- a/Open-ILS/src/sql/Postgres/080.schema.money.sql
+++ b/Open-ILS/src/sql/Postgres/080.schema.money.sql
@@ -32,6 +32,12 @@ CREATE TABLE money.payment (
 );
 CREATE INDEX m_p_xact_idx ON money.payment (xact);
 
+CREATE OR REPLACE VIEW money.payment_view AS
+       SELECT  p.*,c.relname AS payment_type
+         FROM  money.payment p
+               JOIN pg_class c ON (p.tableoid = c.oid);
+
+
 CREATE OR REPLACE VIEW money.billable_xact_summary AS
        SELECT  xact.id AS id,
                xact.usr AS usr,