Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.1d8-5.10.1d9.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/Attic/upgrade-5.10.1d8-5.10.1d9.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.1d8-5.10.1d9.sql	22 Jul 2022 17:37:25 -0000	1.1.2.1
@@ -0,0 +1,9 @@
+--
+-- Add membership "expired" to membership states.  "expired" can be
+-- used for "dormant" accounts, which are neither "banned" or
+-- "deleted".
+-- 
+ALTER TABLE membership_rels DROP CONSTRAINT membership_rels_member_state_ck;
+ALTER TABLE membership_rels ADD CONSTRAINT membership_rels_member_state_ck
+            CHECK (member_state in ('merged','approved', 'needs approval',
+                                    'banned', 'rejected', 'deleted', 'expired'));
