From ef9bee4f1c453dbbc285773f09c253cc6405f81e Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 11 Feb 2020 14:18:49 -0500 Subject: [PATCH] add state label views to seed data Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 717f620f76..3b70a6b752 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -2585,4 +2585,28 @@ CREATE OR REPLACE VIEW acq.lineitem_summary AS FROM acq.lineitem AS li; + +CREATE VIEW acq.li_state_label AS + SELECT * + FROM (VALUES + ('new', 'New'), + ('selector-ready', 'Selector-Ready'), + ('order-ready', 'Order-Ready'), + ('approved', 'Approved'), + ('pending-order', 'Pending-Order'), + ('on-order', 'On-Order'), + ('received', 'Received'), + ('cancelled', 'Cancelled') + ) AS t (id,label); + +CREATE VIEW acq.po_state_label AS + SELECT * + FROM (VALUES + ('new', 'New'), + ('pending', 'Pending'), + ('on-order', 'On-Order'), + ('received', 'Received'), + ('cancelled', 'Cancelled') + ) AS t (id,label); + COMMIT; -- 2.11.0