 messaging_email_preference,
 messaging_email_urgent_all,
 messaging_email_ts)
-VALUES (4,'bob','bob.user@projectredcap.org','','',NULL,NULL,'Bob','User','',0,0,'2017-02-02 14:20:20','2017-02-02 14:28:33','2017-02-02 14:28:24','2017-02-02 14:28:33','2017-02-02 14:28:24',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'M/D/Y_12','.',',','5OMDTXHZYMX62IQJ',1,1,2,NULL,'X_HOURS',1,NULL);
+VALUES (4,'bob','bob.user@projectredcap.org','','',NULL,NULL,'Bob','User','',0,0,'2017-02-02 14:20:20','2017-02-02 14:28:33','2017-02-02 14:28:24','2017-02-02 14:28:33','2017-02-02 14:28:24',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'M/D/Y_12','.',',','5OMDTXHZYMX62IQJ',1,1,2,NULL,'NONE',1,NULL);
+
+REPLACE INTO `redcap_user_information`
+(ui_id,username,user_email,user_email2,user_email3,user_phone,user_phone_sms,user_firstname,user_lastname,user_inst_id,super_user,account_manager,user_creation,user_firstvisit,user_firstactivity,user_lastactivity,user_lastlogin,user_suspended_time,user_expiration,user_access_dashboard_view,user_access_dashboard_email_queued,user_sponsor,user_comments,allow_create_db,email_verify_code,email2_verify_code,email3_verify_code,datetime_format,number_format_decimal,number_format_thousands_sep,two_factor_auth_secret,display_on_email_users,two_factor_auth_twilio_prompt_phone,two_factor_auth_code_expiration,api_token,messaging_email_preference,messaging_email_urgent_all,messaging_email_ts)
+VALUES (5,'carol','carol.user@projectredcap.org','','',NULL,NULL,'Carol','User','',0,0,'2017-02-02 14:20:20','2017-02-02 14:28:33','2017-02-02 14:28:24','2017-02-02 14:28:33','2017-02-02 14:28:24',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'M/D/Y_12','.',',','5OMDTXHZYMX62IQJ',1,1,2,NULL,'NONE',1,NULL);
+
+REPLACE INTO `redcap_user_information`
+(ui_id,username,user_email,user_email2,user_email3,user_phone,user_phone_sms,user_firstname,user_lastname,user_inst_id,super_user,account_manager,user_creation,user_firstvisit,user_firstactivity,user_lastactivity,user_lastlogin,user_suspended_time,user_expiration,user_access_dashboard_view,user_access_dashboard_email_queued,user_sponsor,user_comments,allow_create_db,email_verify_code,email2_verify_code,email3_verify_code,datetime_format,number_format_decimal,number_format_thousands_sep,two_factor_auth_secret,display_on_email_users,two_factor_auth_twilio_prompt_phone,two_factor_auth_code_expiration,api_token,messaging_email_preference,messaging_email_urgent_all,messaging_email_ts)
+VALUES (6,'dan','dan.user@projectredcap.org','','',NULL,NULL,'Dan','User','',0,0,'2017-02-02 14:20:20','2017-02-02 14:28:33','2017-02-02 14:28:24','2017-02-02 14:28:33','2017-02-02 14:28:24',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'M/D/Y_12','.',',','5OMDTXHZYMX62IQJ',1,1,2,NULL,'NONE',1,NULL);

messaging_email_preference,
messaging_email_urgent_all,
messaging_email_ts)
VALUES (2,'admin','joe.admin@projectredcap.org','','',NULL,NULL,'Joe','Admin','',1,0,'2017-02-02 14:15:52','2017-02-02 14:23:03','2017-02-02 14:22:41','2017-02-02 14:23:03','2017-02-02 14:22:42',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'M/D/Y_12','.',',','7HXAGUD5HJD7QP3I',1,1,2,NULL,'X_HOURS',1,NULL);

REPLACE INTO `redcap_user_information`
(ui_id,

messaging_email_preference,
messaging_email_urgent_all,
messaging_email_ts)
VALUES (3,'alice','alice.manager@projectredcap.org','','',NULL,NULL,'Alice','Manager','',0,1,'2017-02-02 14:21:22','2017-02-02 14:26:49','2017-02-02 14:26:40','2017-02-02 14:26:49','2017-02-02 14:26:40',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'M/D/Y_12','.',',','64E2ESJTNTFAUYS4',1,1,2,NULL,'NONE',1,NULL);

REPLACE INTO `redcap_user_information`
(ui_id,
