Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d23-0.1d24.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d23-0.1d24.sql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d23-0.1d24.sql	23 Jan 2006 08:04:42 -0000	1.2
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d23-0.1d24.sql	23 Jan 2006 09:16:56 -0000	1.3
@@ -56,6 +56,6 @@
 
 -- Change membership states to more appropriate names
 alter table membership_rels drop constraint membership_rel_mem_ck;
-update membership_rels set member_state = 'application sent' where member_state = 'application sent';
-update membership_rels set member_state = 'application approved' where member_state = 'application approved';
+update membership_rels set member_state = 'application sent' where member_state = 'awaiting payment';
+update membership_rels set member_state = 'application approved' where member_state = 'payment received';
 alter table membership_rels add constraint membership_rel_mem_ck check (member_state::text = 'merged'::text OR member_state::text = 'approved'::text OR member_state::text = 'needs approval'::text OR member_state::text = 'banned'::text OR member_state::text = 'rejected'::text OR member_state::text = 'deleted'::text OR member_state::text = 'request approval'::text OR member_state::text = 'request approved'::text OR member_state::text = 'waitinglist approved'::text or member_state::text = 'application sent' or member_state::text = 'application approved');
\ No newline at end of file