Changeset 175

Timestamp:

Jan 30, 2007 2:15:51 AM (6 years ago)

Author:

dkg

Message:

JPDD: added INSERT/DELETE rules for audience and presenter views.

File:

• trunk/jpdd/sql/db.sql (modified) (3 diffs)

trunk/jpdd/sql/db.sql

@@ -448 +448 @@
 
 --
+-- Name: audience_delete; Type: RULE; Schema: public; Owner: dkg
+--
+
+CREATE RULE audience_delete AS ON DELETE TO audience DO INSTEAD DELETE FROM attendance WHERE (((attendance.person_id = old.person_id) AND (attendance.workshop_id = old.workshop_id)) AND ((attendance.flavor)::text = 'audience'::text));
+
+
+--
+-- Name: audience_insert; Type: RULE; Schema: public; Owner: dkg
+--
+
+CREATE RULE audience_insert AS ON INSERT TO audience DO INSTEAD INSERT INTO attendance (person_id, workshop_id, flavor) VALUES (new.person_id, new.workshop_id, 'audience'::character varying);
+
+
+--
+-- Name: presenter_delete; Type: RULE; Schema: public; Owner: dkg
+--
+
+CREATE RULE presenter_delete AS ON DELETE TO presenter DO INSTEAD DELETE FROM attendance WHERE (((attendance.person_id = old.person_id) AND (attendance.workshop_id = old.workshop_id)) AND ((attendance.flavor)::text = 'presenter'::text));
+
+
+--
+-- Name: presenter_insert; Type: RULE; Schema: public; Owner: dkg
+--
+
+CREATE RULE presenter_insert AS ON INSERT TO presenter DO INSTEAD INSERT INTO attendance (person_id, workshop_id, flavor) VALUES (new.person_id, new.workshop_id, 'presenter'::character varying);
+
+
+--
 -- Name: affiliation_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dkg
 --
@@ -600 +628 @@
 REVOKE ALL ON TABLE audience FROM dkg;
 GRANT ALL ON TABLE audience TO dkg;
-GRANT SELECT ON TABLE audience TO "www-data";
+GRANT INSERT,SELECT,DELETE ON TABLE audience TO "www-data";
 
 
@@ -740 +768 @@
 REVOKE ALL ON TABLE presenter FROM dkg;
 GRANT ALL ON TABLE presenter TO dkg;
-GRANT SELECT ON TABLE presenter TO "www-data";
+GRANT INSERT,SELECT,DELETE ON TABLE presenter TO "www-data";