Update of /var/cvs/contributions/CMSContainer/migration
In directory james.mmbase.org:/tmp/cvs-serv29024
Modified Files:
Tag: b1_5
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.9.2.6
retrieving revision 1.9.2.7
diff -u -b -r1.9.2.6 -r1.9.2.7
--- migration_1.4_to_1.5.txt 9 Dec 2008 02:16:19 -0000 1.9.2.6
+++ migration_1.4_to_1.5.txt 10 Dec 2008 09:05:36 -0000 1.9.2.7
@@ -141,3 +141,31 @@
*
*
*
\ No newline at end of file
+
+*
+*
+*
+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:
+*
+*
+*
\ No newline at end of file
_______________________________________________
Cvs mailing list
Cvs@lists.mmbase.org
http://lists.mmbase.org/mailman/listinfo/cvs
