# HG changeset patch
# User jbe
# Date 1336683505 -7200
# Node ID dc644643db997ab88e029665a60bba0cdfe2f007
# Parent  8423373fbaddac53047d738258c73c552ced823f
Backported fix of future version to update script to v2.0.0 to be able to include unused invite codes in member table

diff -r 8423373fbadd -r dc644643db99 update/core-update.v1.4.0-v2.0.0.sql
--- a/update/core-update.v1.4.0-v2.0.0.sql	Thu May 10 22:44:13 2012 +0200
+++ b/update/core-update.v1.4.0-v2.0.0.sql	Thu May 10 22:58:25 2012 +0200
@@ -14,6 +14,9 @@
 ALTER TABLE "member" ALTER COLUMN "active" SET DEFAULT FALSE;
 ALTER TABLE "member" ADD COLUMN "formatting_engine" TEXT;
 
+-- Backported fix of future version to include unused invite codes in member table:
+ALTER TABLE "member" ALTER COLUMN "name" DROP NOT NULL;
+
 COMMENT ON COLUMN "member"."created"           IS 'Creation of member record and/or invite code';
 COMMENT ON COLUMN "member"."invite_code"       IS 'Optional invite code, to allow a member to initialize his/her account the first time';
 COMMENT ON COLUMN "member"."admin_comment"     IS 'Hidden comment for administrative purposes';