From dfba8d69b791b59c26032e70df80c2fb132f3037 Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 29 Apr 2008 17:47:57 +0000 Subject: [PATCH] protecting against existing views git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_2@9485 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.2.1-1.2.2-upgrade-db.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/Open-ILS/src/sql/Pg/1.2.1-1.2.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.2.1-1.2.2-upgrade-db.sql index 5141a65010..00d9f49701 100644 --- a/Open-ILS/src/sql/Pg/1.2.1-1.2.2-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.2.1-1.2.2-upgrade-db.sql @@ -90,6 +90,7 @@ BEGIN; /* convenience views for report management */ ------------------------------------------------------------------- +DROP VIEW reporter.overdue_reports; CREATE OR REPLACE VIEW reporter.overdue_reports AS SELECT s.id, c.barcode AS runner_barcode, r.name, s.run_time, s.run_time - now() AS scheduled_wait_time FROM reporter.schedule s @@ -98,6 +99,7 @@ CREATE OR REPLACE VIEW reporter.overdue_reports AS JOIN actor.card c ON c.id = u.card WHERE s.start_time IS NULL AND s.run_time < now(); +DROP VIEW reporter.pending_reports; CREATE OR REPLACE VIEW reporter.pending_reports AS SELECT s.id, c.barcode AS runner_barcode, r.name, s.run_time, s.run_time - now() AS scheduled_wait_time FROM reporter.schedule s @@ -106,6 +108,7 @@ CREATE OR REPLACE VIEW reporter.pending_reports AS JOIN actor.card c ON c.id = u.card WHERE s.start_time IS NULL; +DROP VIEW reporter.currently_running; CREATE OR REPLACE VIEW reporter.currently_running AS SELECT s.id, c.barcode AS runner_barcode, r.name, s.run_time, s.run_time - now() AS scheduled_wait_time FROM reporter.schedule s -- 2.11.0