Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv28907
Modified Files: migration_1.4_to_1.5.txt Log Message: CMSC-949, Blocking users: user status enhancements,add sql script See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-949 Index: migration_1.4_to_1.5.txt =================================================================== RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.4_to_1.5.txt,v retrieving revision 1.15 retrieving revision 1.16 diff -u -b -r1.15 -r1.16 --- migration_1.4_to_1.5.txt 9 Dec 2008 02:00:25 -0000 1.15 +++ migration_1.4_to_1.5.txt 10 Dec 2008 09:00:22 -0000 1.16 @@ -141,3 +141,31 @@ * * * + +* +* +* +Name: Add the active filed to the people table. +Goal: . +Type: sql-script +--- Start script --- +ALTER TABLE people ADD COLUMN active varchar(255) ; +--- End script --- +Exceptions/errors/other problems and what to do: +* +* +* + +* +* +* +Name: Moved users without a status to active . +Goal: . +Type: sql-script +--- Start script --- +UPDATE people SET active='Active' WHERE active is null or active='' ; +--- End script --- +Exceptions/errors/other problems and what to do: +* +* +* _______________________________________________ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs