rel-types-procs.xql
DB Query file
Related Files
- packages/acs-subsite/tcl/rel-types-procs.xql
- packages/acs-subsite/tcl/rel-types-procs.tcl
- packages/acs-subsite/tcl/rel-types-procs-postgresql.xql
- packages/acs-subsite/tcl/rel-types-procs-oracle.xql
[ hide source ] | [ make this the default ]
File Contents
<?xml version="1.0"?> <queryset> <fullquery name="new.parent_rel_type"> <querytext> select table_name as references_table, id_column as references_column from acs_object_types where object_type=:supertype </querytext> </fullquery> <fullquery name="rel_types::new.update_type"> <querytext> update acs_object_types set dynamic_p='t' where object_type = :rel_type </querytext> </fullquery> <fullquery name="rel_types::add_permissible.insert_rel_type"> <querytext> insert into group_type_rels (group_rel_type_id, group_type, rel_type) values (:group_rel_type_id, :group_type, :rel_type) </querytext> </fullquery> <fullquery name="rel_types::remove_permissible.delete_rel_type"> <querytext> delete from group_type_rels where group_type= :group_type and rel_type= :rel_type </querytext> </fullquery> <fullquery name="rel_types::create_role.get_roles"> <querytext> select role from acs_rel_roles </querytext> </fullquery> </queryset>