Add notifications to ther userProfileData => user move.

perlDreamer · perlDreamer · commit d672c3a22128 · 2011-12-01T13:25:49.000-08:00
diff --git a/share/upgrades/7.10.23-8.0.0/moveRequiredProfileFields.pl b/share/upgrades/7.10.23-8.0.0/moveRequiredProfileFields.pl
@@ -12,6 +12,7 @@
     toolbar uiLevel versionTagMode );
 
 # Create the new columns
+report "Creating new columns in the user table";
 for my $fieldName ( @fields ) {
     my $field       = WebGUI::ProfileField->new( session, $fieldName );
     my $fieldClass  = $field->getFormControlClass;
@@ -21,13 +22,15 @@
 }
 
 # Update the table
+report "Copying data for all users, this could take a while";
 my @pairs   = map { q{`users`.`} . $_ . q{`=`userProfileData`.`} . $_ . q{`} } @fields;
 session->db->write(
     q{ UPDATE `users`,`userProfileData` SET } . join( ", ", @pairs ) .
     q{ WHERE `users`.`userId` = `userProfileData`.`userId` } 
 );
 
 # Drop the old tables
+report "Removing old columns";
 for my $fieldName ( @fields ) {
     session->db->write( qq{ ALTER TABLE userProfileData DROP COLUMN `$fieldName` } );
 }
