Index: openacs-4/packages/acs-kernel/sql/oracle/acs-install.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-install.sql,v diff -u -r1.15 -r1.16 --- openacs-4/packages/acs-kernel/sql/oracle/acs-install.sql 25 Sep 2003 07:35:56 -0000 1.15 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-install.sql 10 Oct 2003 11:35:54 -0000 1.16 @@ -44,12 +44,23 @@ set object_type = 'application_group' where object_id = -2; + insert into group_rels + (group_rel_id, group_id, rel_type) + select acs_object_id_seq.nextval, -2, 'admin_rel' + from dual; + segment_id := rel_segment.new( segment_name => 'Main Site Members', group_id => -2, rel_type => 'membership_rel' ); + segment_id := rel_segment.new( + segment_name => 'Main Site Administrators', + group_id => -2, + rel_type => 'admin_rel' + ); + select user into schema_user from dual; dbms_job.submit ( Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-install.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-install.sql,v diff -u -r1.23 -r1.24 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-install.sql 25 Sep 2003 07:35:56 -0000 1.23 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-install.sql 10 Oct 2003 11:35:54 -0000 1.24 @@ -26,6 +26,9 @@ acs__magic_object_id(''default_context'') ); + + -- Make the -2 registered users group an application_group + insert into application_groups (group_id, package_id) values @@ -35,6 +38,13 @@ set object_type = ''application_group'' where object_id = -2; + insert into group_rels + (group_rel_id, group_id, rel_type) + select nextval(''t_acs_object_id_seq''), -2, ''admin_rel''; + + + -- Create the members and admins rel segments + perform rel_segment__new( null, ''rel_segment'', @@ -49,6 +59,20 @@ null ); + perform rel_segment__new( + null, + ''rel_segment'', + now(), + null, + null, + null, + null, + ''Main Site Administrators'', + -2, + ''admin_rel'', + null + ); + node_id := site_node__new ( null, null,