Index: openacs-4/contrib/packages/room-reservation/sql/postgresql/facilities-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/room-reservation/sql/postgresql/facilities-create.sql,v diff -u -r1.1.4.1 -r1.1.4.2 --- openacs-4/contrib/packages/room-reservation/sql/postgresql/facilities-create.sql 12 Jul 2004 22:08:41 -0000 1.1.4.1 +++ openacs-4/contrib/packages/room-reservation/sql/postgresql/facilities-create.sql 12 Jul 2004 23:04:25 -0000 1.1.4.2 @@ -8,42 +8,7 @@ -- concepts were taken from the old -- ACS3.x Room Reservation package --- let's do the permissions stuff -begin; - select acs_privilege__create_privilege('room_reservation_view',null,null); - select acs_privilege__create_privilege('room_reservation_create',null,null); - select acs_privilege__create_privilege('room_reservation_delete',null,null); - select acs_privilege__create_privilege('room_reservation_modify',null,null); - select acs_privilege__create_privilege('room_reservation_admin','Room Reservations Administrator',null); - -- temporarily drop this trigger to avoid a data-change violation - -- on acs_privilege_hierarchy_index while updating the child privileges. - - drop trigger acs_priv_hier_ins_del_tr on acs_privilege_hierarchy; - - -- bind privileges to global names - select acs_privilege__add_child('create','room_reservation_create'); - select acs_privilege__add_child('write','room_reservation_modify'); - select acs_privilege__add_child('read','room_reservation_view'); - select acs_privilege__add_child('delete','room_reservation_delete'); - - select acs_privilege__add_child('admin','room_reservation_admin'); - - - select acs_privilege__add_child('room_reservation_admin','room_reservation_view'); - select acs_privilege__add_child('room_reservation_admin','room_reservation_create'); - select acs_privilege__add_child('room_reservation_admin','room_reservation_delete'); - - -- re-enable the trigger before the last insert to force the - -- acs_privilege_hierarchy_index table to be updated. - - create trigger acs_priv_hier_ins_del_tr after insert or delete - on acs_privilege_hierarchy for each row - execute procedure acs_priv_hier_ins_del_tr (); - - select acs_privilege__add_child('room_reservation_admin','room_reservation_modify'); -end; - -- let's do the table stuff create table rr_facilities ( facility_id integer