Changeset 9529
- Timestamp:
- 05/08/08 08:26:54 (3 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
r9485 r9529 83 83 84 84 85 DROP SCHEMA search CASCADE; 85 DROP VIEW reporter.overdue_reports; 86 DROP VIEW reporter.pending_reports; 87 DROP VIEW reporter.currently_running; 86 88 87 89 BEGIN; … … 91 93 ------------------------------------------------------------------- 92 94 93 DROP VIEW reporter.overdue_reports;94 95 CREATE OR REPLACE VIEW reporter.overdue_reports AS 95 96 SELECT s.id, c.barcode AS runner_barcode, r.name, s.run_time, s.run_time - now() AS scheduled_wait_time … … 100 101 WHERE s.start_time IS NULL AND s.run_time < now(); 101 102 102 DROP VIEW reporter.pending_reports;103 103 CREATE OR REPLACE VIEW reporter.pending_reports AS 104 104 SELECT s.id, c.barcode AS runner_barcode, r.name, s.run_time, s.run_time - now() AS scheduled_wait_time … … 109 109 WHERE s.start_time IS NULL; 110 110 111 DROP VIEW reporter.currently_running;112 111 CREATE OR REPLACE VIEW reporter.currently_running AS 113 112 SELECT s.id, c.barcode AS runner_barcode, r.name, s.run_time, s.run_time - now() AS scheduled_wait_time … … 149 148 my $txt = shift; 150 149 $txt =~ s/^\s+//o; 151 $txt =~ s/[\[\]\{\}\(\)`'"#<>\*\?\-\+\$\\]+//o; 150 $txt =~ s/[\[\]\{\}\(\)`'"#<>\*\?\-\+\$\\]+//o; #' To help vim in SQL mode 152 151 $txt =~ s/\s+$//o; 153 152 if ($txt =~ /(\d{3}(?:\.\d+)?)/o) { … … 158 157 $$ LANGUAGE 'plperlu' STRICT IMMUTABLE; 159 158 159 COMMIT; 160 161 DROP SCHEMA search CASCADE; 162 BEGIN; 160 163 161 164 -------------------------------------------------------------------
