- Timestamp:
- 04/29/08 13:47:57 (4 months ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
branches/rel_1_2/Open-ILS/src/sql/Pg/1.2.1-1.2.2-upgrade-db.sql
r9478 r9485 91 91 ------------------------------------------------------------------- 92 92 93 DROP VIEW reporter.overdue_reports; 93 94 CREATE OR REPLACE VIEW reporter.overdue_reports AS 94 95 SELECT s.id, c.barcode AS runner_barcode, r.name, s.run_time, s.run_time - now() AS scheduled_wait_time … … 99 100 WHERE s.start_time IS NULL AND s.run_time < now(); 100 101 102 DROP VIEW reporter.pending_reports; 101 103 CREATE OR REPLACE VIEW reporter.pending_reports AS 102 104 SELECT s.id, c.barcode AS runner_barcode, r.name, s.run_time, s.run_time - now() AS scheduled_wait_time … … 107 109 WHERE s.start_time IS NULL; 108 110 111 DROP VIEW reporter.currently_running; 109 112 CREATE OR REPLACE VIEW reporter.currently_running AS 110 113 SELECT s.id, c.barcode AS runner_barcode, r.name, s.run_time, s.run_time - now() AS scheduled_wait_time
