Changeset 9457 for branches/rel_1_2/Open-ILS/src/sql/Pg/reporter-schema.sql

Timestamp:

04/26/08 12:48:27 (6 months ago)

Author:

miker

Message:

base materialized simple record on old super_simple_record

Files:

• branches/rel_1_2/Open-ILS/src/sql/Pg/reporter-schema.sql (modified) (3 diffs)

branches/rel_1_2/Open-ILS/src/sql/Pg/reporter-schema.sql

@@ -133 +133 @@
   GROUP BY 1,2,3,4,5,6,7,8,9,10,11,12,13,14;
 
-CREATE OR REPLACE VIEW reporter.super_simple_record AS
+CREATE OR REPLACE VIEW reporter.old_super_simple_record AS
 SELECT  r.id,
         r.fingerprint,
@@ -155 +155 @@
   GROUP BY 1,2,3,4,5,6,8,9;
 
-CREATE TABLE reporter.materialized_simple_record AS SELECT * FROM reporter.simple_record WHERE 1=0;
+CREATE TABLE reporter.materialized_simple_record AS SELECT * FROM reporter.old_super_simple_record WHERE 1=0;
 ALTER TABLE reporter.materialized_simple_record ADD PRIMARY KEY (id);
+
+CREATE VIEW reporter.super_simple_record AS SELECT * FROM reporter.materialized_simple_record;
 
 CREATE OR REPLACE FUNCTION reporter.simple_rec_sync () RETURNS TRIGGER AS $$
@@ -165 +167 @@
 
     IF TG_OP IN ('INSERT','UPDATE') AND NOT NEW.deleted THEN
-        INSERT INTO reporter.materialized_simple_record SELECT * FROM reporter.simple_record WHERE id = NEW.record;
+        INSERT INTO reporter.materialized_simple_record SELECT * FROM reporter.old_super_simple_record WHERE id = NEW.record;
     END IF;