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.6 -r1.7
--- openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql	22 Mar 2001 00:09:24 -0000	1.6
+++ openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql	14 Apr 2001 05:12:22 -0000	1.7
@@ -29,8 +29,8 @@
                         constraint membership_rel_rel_id_pk
                         primary key,
         -- null means waiting for admin approval
-        member_state    varchar(20) constraint membership_rel_mem_ck
-                        check (member_state in ('approved', 'needs approval',
+        member_state    varchar(20) default '' not null constraint membership_rel_mem_ck
+                        check (member_state in ('', 'approved', 'needs approval',
                                               'banned', 'rejected', 'deleted'))
 );