20160531.pref.04.datecreateval.sql

UPDATE {$NAMESPACE}_user.user_preferences
  SET dateCreated = UNIX_TIMESTAMP() WHERE dateCreated = 0;