Index: openacs-4/packages/acs-subsite/tcl/group-type-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/group-type-procs-oracle.xql,v diff -u -r1.3.2.2 -r1.3.2.3 --- openacs-4/packages/acs-subsite/tcl/group-type-procs-oracle.xql 3 Mar 2020 16:11:12 -0000 1.3.2.2 +++ openacs-4/packages/acs-subsite/tcl/group-type-procs-oracle.xql 3 Mar 2020 16:13:59 -0000 1.3.2.3 @@ -1,55 +1,47 @@ - oracle8.1.6 + oracle8.1.6 - - - -begin acs_object_type.drop_type('$group_type'); end; - - + + + begin acs_object_type.drop_type('$group_type'); end; + - - - -BEGIN - acs_object_type.create_type ( - supertype => :supertype, - object_type => :group_type, - pretty_name => :pretty_name, - pretty_plural => :pretty_plural, - table_name => upper(:table_name), - id_column => :id_column, - package_name => :package_name - ); -END; - - + + + BEGIN + acs_object_type.create_type ( + supertype => :supertype, + object_type => :group_type, + pretty_name => :pretty_name, + pretty_plural => :pretty_plural, + table_name => upper(:table_name), + id_column => :id_column, + package_name => :package_name + ); + END; + - - - -update acs_object_types set dynamic_p='t' where object_type = :group_type - - + + + update acs_object_types set dynamic_p='t' where object_type = :group_type + - - - - insert into group_type_rels - (group_rel_type_id, rel_type, group_type) - select acs_object_id_seq.nextval, r.rel_type, :group_type - from group_type_rels r - where r.group_type = :supertype - - + + + insert into group_type_rels + (group_rel_type_id, rel_type, group_type) + select acs_object_id_seq.nextval, r.rel_type, :group_type + from group_type_rels r + where r.group_type = :supertype +