Index: openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql	20 Aug 2001 21:52:31 -0000	1.9
+++ openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql	23 Feb 2002 02:43:45 -0000	1.10
@@ -412,123 +412,3 @@
 (group_rel_type_id, rel_type, group_type)
 values
 (acs_object_id_seq.nextval, 'composition_rel', 'group');
-
-
---------------
--- PACKAGES --
---------------
-
--- create or replace package composition_rel
--- as
--- 
---   function new (
---     rel_id              in composition_rels.rel_id%TYPE default null,
---     rel_type            in acs_rels.rel_type%TYPE default 'composition_rel',
---     object_id_one       in acs_rels.object_id_one%TYPE,
---     object_id_two       in acs_rels.object_id_two%TYPE,
---     creation_user       in acs_objects.creation_user%TYPE default null,
---     creation_ip         in acs_objects.creation_ip%TYPE default null
---   ) return composition_rels.rel_id%TYPE;
--- 
---   procedure delete (
---     rel_id      in composition_rels.rel_id%TYPE
---   );
--- 
---   function check_path_exists_p (
---     component_id        in groups.group_id%TYPE,
---     container_id        in groups.group_id%TYPE
---   ) return char;
--- 
---   function check_representation (
---     rel_id      in composition_rels.rel_id%TYPE
---   ) return char;
--- 
--- end composition_rel;
-
--- show errors
-
-
--- create or replace package membership_rel
--- as
--- 
---   function new (
---     rel_id              in membership_rels.rel_id%TYPE default null,
---     rel_type            in acs_rels.rel_type%TYPE default 'membership_rel',
---     object_id_one       in acs_rels.object_id_one%TYPE,
---     object_id_two       in acs_rels.object_id_two%TYPE,
---     member_state        in membership_rels.member_state%TYPE default 'approved',
---     creation_user       in acs_objects.creation_user%TYPE default null,
---     creation_ip         in acs_objects.creation_ip%TYPE default null
---   ) return membership_rels.rel_id%TYPE;
--- 
---   procedure ban (
---     rel_id      in membership_rels.rel_id%TYPE
---   );
--- 
---   procedure approve (
---     rel_id      in membership_rels.rel_id%TYPE
---   );
--- 
---   procedure reject (
---     rel_id      in membership_rels.rel_id%TYPE
---   );
--- 
---   procedure unapprove (
---     rel_id      in membership_rels.rel_id%TYPE
---   );
--- 
---   procedure deleted (
---     rel_id      in membership_rels.rel_id%TYPE
---   );
--- 
---   procedure delete (
---     rel_id      in membership_rels.rel_id%TYPE
---   );
--- 
---   function check_representation (
---     rel_id      in membership_rels.rel_id%TYPE
---   ) return char;
--- 
--- end membership_rel;
-
--- show errors
-
-
--- create or replace package acs_group
--- is
---  function new (
---   group_id              in groups.group_id%TYPE default null,
---   object_type           in acs_objects.object_type%TYPE
---                            default 'group',
---   creation_date         in acs_objects.creation_date%TYPE
---                            default sysdate,
---   creation_user         in acs_objects.creation_user%TYPE
---                            default null,
---   creation_ip           in acs_objects.creation_ip%TYPE default null,
---   email                 in parties.email%TYPE default null,
---   url                   in parties.url%TYPE default null,
---   group_name            in groups.group_name%TYPE,
---   join_policy           in groups.join_policy%TYPE default null,
---   context_id	in acs_objects.context_id%TYPE default null
---  ) return groups.group_id%TYPE;
--- 
---  procedure delete (
---    group_id     in groups.group_id%TYPE
---  );
--- 
---  function name (
---   group_id      in groups.group_id%TYPE
---  ) return varchar2;
--- 
---  function member_p (
---   party_id      in parties.party_id%TYPE
---  ) return char;
--- 
---  function check_representation (
---   group_id      in groups.group_id%TYPE
---  ) return char;
--- 
--- end acs_group;
-
--- show errors
-