text: INSERT INTO `Client` VALUES (1,'382nwsdkpl44gs84s448w8g00s4okkksc880og40wgkswcgw0s','a:0:{}','3lmdg9u1qj40wkgc0w088o0c00gcwgcgcggwssogccwgk8w480','a:1:{i:0;s:8:\"password\";}');
  
  INSERT INTO `language_master` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'en_US','US English',1);
  
  INSERT INTO `organization` VALUES (1,NULL,NULL,NULL,'2014-10-14 10:02:48',NULL,NULL,'Northwest','A','http://www.northwest.org',NULL,'Pacific','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAdxJREFUeNq0lj1Lw1AUhpOggrtfU9ytClpwEkFwVXDR4gdOiqhQHER/gVrwA0XFwUFRUavgP7AOXW1F66ptdPDrF7RDfQ+8gRiSJtH2wMMl7T3vuffk3nOihsNhpYTpYAT0ghZQDwrgDeTALbgAL24CqksAEV4FQzIHZMAd+OT/DUAcW/ksQZaAYReqchAfACdAA2tgz8nRspAZMAf6wRQ4s07QbA5RcA3uQchtVRYzOEfmpsEpmHcLMAw2wRXoY479Wo4+l2CdWr8CyFYPQBKMg7wS3PL0TVJLtwZY4Tj6R3F7kGoQMwM0gwjYAa8eAkXila5dnsBmjeJyFPeV8tk2x4jGS/QQ8KX6eemPoq3xsqSV8ltKtOWi1YH3Ejn387vqMOdDSoumVM6KZqn4Bk1utcpl5aqPAKL5JTt4Ah0V2EGnFEkJcAPaeB/KZTo1ExpLrdh0GQNEzTIuAbIgzpKreziqPvIvmZilZtY8RYscpQ/U/GPltcxIwdTULHV9EnSDYxaroCY+h6CLWoa9o52DRrDBcSJA+ZC0HIEesEAtx462BQbNIwaWPd6LzjkZ9ugxNhxfTT/GkquwGKZsTV8W0c7nOHNu+P2qcPpsCVFYYSC5oAmKP7sJ/AgwALtpZgbqLN7jAAAAAElFTkSuQmCC','#423131','#540521','EBI confidential statement','<br/><div><b><i></i></b><p><b><u><i><br/></i></u></b></p><p><b><u><i>hello</i></u></b></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p></div>');
  
  INSERT INTO `organization_lang` VALUES (1,1,1,NULL,NULL,NULL,'2014-10-13 15:18:47',NULL,NULL,'Northwest','North westUniversity');
  
  INSERT INTO `person` (`id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`,`firstname`,`lastname`,`title`,`date_of_birth`,`external_id`,`username`,`password`,`activation_token`,`confidentiality_stmt_accept_date`,`organization_id`,`token_expiry_date`,`welcome_email_sent_date`,`risk_level`,`risk_update_date`,`intent_to_leave`,`intent_to_leave_update_date`) VALUES (1,NULL,NULL,NULL,'2014-10-15 07:44:53',NULL,NULL,'Ramesh','Kumhar','Mr','0000-00-00','123456','ramesh.kumhar@techmahindra.com','$2y$13$f6bnaUYhaIO0qzJ0krqrIeUDnxJxWYYEyB3L6qDDK/1ln5CsHKEca','0d7bb70f71f58f0966429e41411d8b36','2014-10-14 12:01:02',1,NULL,'2014-10-15',NULL,NULL,NULL,NULL);
  
  INSERT INTO `person` (`id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`,`firstname`,`lastname`,`title`,`date_of_birth`,`external_id`,`username`,`password`,`activation_token`,`confidentiality_stmt_accept_date`,`organization_id`,`token_expiry_date`,`welcome_email_sent_date`,`risk_level`,`risk_update_date`,`intent_to_leave`,`intent_to_leave_update_date`) VALUES (2,NULL,NULL,NULL,'2014-10-15 07:44:53',NULL,NULL,'Bipin','P','Mr','0000-00-00','123456','bipinbihari.pradhan@techmahindra.com','$2y$13$f6bnaUYhaIO0qzJ0krqrIeUDnxJxWYYEyB3L6qDDK/1ln5CsHKEca','0d7bb70f71f58f0966429e41411d8b36','2014-10-14 12:01:02',1,NULL,'2014-10-15',NULL,NULL,NULL,NULL);
  
  INSERT INTO `person` (`id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`,`firstname`,`lastname`,`title`,`date_of_birth`,`external_id`,`username`,`password`,`activation_token`,`confidentiality_stmt_accept_date`,`organization_id`,`token_expiry_date`,`welcome_email_sent_date`,`risk_level`,`risk_update_date`,`intent_to_leave`,`intent_to_leave_update_date`) VALUES (3,NULL,NULL,NULL,'2014-10-15 07:44:53',NULL,NULL,'Devadoss','P','Mr','0000-00-00','123456','devadoss.poornachari@techmahindra.com','$2y$13$f6bnaUYhaIO0qzJ0krqrIeUDnxJxWYYEyB3L6qDDK/1ln5CsHKEca','0d7bb70f71f58f0966429e41411d8b36','2014-10-14 12:01:02',1,NULL,'2014-10-15',NULL,NULL,NULL,NULL);
  
  INSERT INTO `synapse`.`org_person_faculty`(`id`,`organization_id`,`person_id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`)VALUES(NULL,1,1,NULL,'2015-01-12 07:44:53',NULL,'2015-01-12 07:44:53',NULL,NULL);
  INSERT INTO `synapse`.`org_person_faculty`(`id`,`organization_id`,`person_id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`)VALUES(NULL,1,2,NULL,'2015-01-12 07:44:53',NULL,'2015-01-12 07:44:53',NULL,NULL);
  INSERT INTO `synapse`.`org_person_faculty`(`id`,`organization_id`,`person_id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`)VALUES(NULL,1,3,NULL,'2015-01-12 07:44:53',NULL,'2015-01-12 07:44:53',NULL,NULL);
  
  
  
  INSERT INTO `AccessToken` VALUES (1,1,1,'M2VmNGNmMWNkZjE2N2JjMjdiOTZhYzRhNjhmODFlZjMxMTMyZjVmOTQwMmQ1ZGM0ZDY0YTgyZDJmYzVjMGZjMA',1409263029,'user');
  
  
  
  
  
  INSERT INTO `RefreshToken` VALUES (1,1,1,'OGU3MTUwNTQxMzc4OTQwY2RlZjMxZTY5MmM5YTIxNzE2ZWU4NWEzODhmN2IxYTg2YjM2MzJmZTZiZmQ2NmM2ZA',1410469029,'user');
  
  
  
  
  INSERT INTO `Teams` (`id`,`organization_id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`,`team_name`,`team_description`) VALUES (1,1,NULL,'2014-09-13 13:21:03',NULL,NULL,NULL,NULL,'QATeam',NULL);
  INSERT INTO `Teams` (`id`,`organization_id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`,`team_name`,`team_description`) VALUES (2,1,NULL,NULL,NULL,NULL,NULL,NULL,'Dev Team',NULL);
  INSERT INTO `Teams` (`id`,`organization_id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`,`team_name`,`team_description`) VALUES (3,1,NULL,NULL,NULL,NULL,NULL,NULL,'Front End Team',NULL);
  
  
  INSERT INTO `team_members` (`id`,`person_id`,`organization_id`,`teams_id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`,`is_team_leader`) VALUES (1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `team_members` (`id`,`person_id`,`organization_id`,`teams_id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`,`is_team_leader`) VALUES (2,2,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `team_members` (`id`,`person_id`,`organization_id`,`teams_id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`,`is_team_leader`) VALUES (3,3,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `team_members` (`id`,`person_id`,`organization_id`,`teams_id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`,`is_team_leader`) VALUES (4,1,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `team_members` (`id`,`person_id`,`organization_id`,`teams_id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`,`is_team_leader`) VALUES (5,2,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `team_members` (`id`,`person_id`,`organization_id`,`teams_id`,`created_by`,`created_at`,`modified_by`,`modified_at`,`deleted_by`,`deleted_at`,`is_team_leader`) VALUES (6,3,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  
  
  
  
  INSERT INTO `activity_reference` VALUES (1,'Academic Concerns',NULL,NULL),(2,'Personal Issue',NULL,NULL),(3,'Financial Issues',NULL,NULL);
  
  
  INSERT INTO `activity_reference_lang` VALUES (1,1,1,'Academic Concerns',NULL),(2,1,2,'Personal Issue',NULL),(3,1,3,'Financial Issues',NULL);
  
  INSERT INTO `contact_info` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'9591900663',NULL,NULL,NULL,'ramesh.kumhar@techmahindra.com',NULL,'9224852114',NULL,NULL,NULL,NULL,'2014-10-15 12:34:01',NULL,NULL);
  
  INSERT INTO `contact_info` VALUES (2,NULL,NULL,NULL,NULL,NULL,NULL,'7781900665',NULL,NULL,NULL,'bipinbihari.pradhan@techmahindra.com',NULL,'9224852114',NULL,NULL,NULL,NULL,'2014-10-15 12:34:01',NULL,NULL);
  
  INSERT INTO `contact_info` VALUES (3,NULL,NULL,NULL,NULL,NULL,NULL,'77819440665',NULL,NULL,NULL,'devadoss.poornachari@techmahindra.com',NULL,'9224852114',NULL,NULL,NULL,NULL,'2014-10-15 12:34:01',NULL,NULL);
  
  
  INSERT INTO `ebi_config` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'Coordinator_First_Password_Expiry_Hrs','0'),(2,NULL,NULL,NULL,NULL,NULL,NULL,'Coordinator_Support_Helpdesk_Email_Address','support@map-works.com'),(3,NULL,NULL,NULL,NULL,NULL,NULL,'Staff_Support_Helpdesk_Email_Address','support@map-works.com'),(4,NULL,NULL,NULL,NULL,NULL,NULL,'Coordinator_Activation_URL_Prefix','http://synapse-dev.mnv-tech.com/#/activate/'),(5,NULL,NULL,NULL,NULL,NULL,NULL,'Staff_Activation_URL_Prefix','http://synapse-dev.mnv-tech.com/#/activate/'),(6,NULL,NULL,NULL,NULL,NULL,NULL,'Staff_First_Password_Expiry_Hrs','24'),(7,NULL,NULL,NULL,NULL,NULL,NULL,'Coordinator_Reset_Password_Expiry_Hrs','24'),(8,NULL,NULL,NULL,NULL,NULL,NULL,'Staff_Reset_Password_Expiry_Hrs','24'),(9,NULL,NULL,NULL,NULL,NULL,NULL,'Student_Reset_Password_Expiry_Hrs','24'),(10,NULL,NULL,NULL,NULL,NULL,NULL,'System_URL','http://synapse-dev.mnv-tech.com/'),(11,NULL,NULL,NULL,NULL,NULL,NULL,'Coordinator_ResetPwd_URL_Prefix','http://synapse-dev.mnv-tech.com/#/resetPassword/'),(12,NULL,NULL,NULL,NULL,NULL,NULL,'Staff_ResetPwd_URL_Prefix','http://synapse-dev.mnv-tech.com/#/resetPassword/');
  
  
  INSERT INTO `email_template` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'Welcome_Email_Staff',NULL,'no-reply@mapworks.com','ramesh.kumhar@techmahindra.com,SP00345364@TechMahindra.com,devadoss.poornachari@techmahindra.com,Amith.Kishore@TechMahindra.com'),(2,NULL,NULL,NULL,NULL,NULL,NULL,'Forgot_Password_Staff',NULL,'no-reply@mapworks.com','ramesh.kumhar@techmahindra.com,SP00345364@TechMahindra.com,devadoss.poornachari@techmahindra.com,Amith.Kishore@TechMahindra.com'),(3,NULL,NULL,NULL,NULL,NULL,NULL,'MyAccount_Updated_Staff',NULL,'no-reply@mapworks.com','ramesh.kumhar@techmahindra.com,SP00345364@TechMahindra.com,devadoss.poornachari@techmahindra.com,Amith.Kishore@TechMahindra.com'),(4,NULL,NULL,NULL,NULL,NULL,NULL,'Create_Password_Coordinator',NULL,'no-reply@mapworks.com','ramesh.kumhar@techmahindra.com,SP00345364@TechMahindra.com,devadoss.poornachari@techmahindra.com,Amith.Kishore@TechMahindra.com'),(5,NULL,NULL,NULL,NULL,NULL,NULL,'Forgot_Password_Coordinator',NULL,'no-reply@mapworks.com','ramesh.kumhar@techmahindra.com,SP00345364@TechMahindra.com,devadoss.poornachari@techmahindra.com,Amith.Kishore@TechMahindra.com'),(6,NULL,NULL,NULL,NULL,NULL,NULL,'Welcome_Email_Coordinator',NULL,'no-reply@mapworks.com','ramesh.kumhar@techmahindra.com,SP00345364@TechMahindra.com,devadoss.poornachari@techmahindra.com,Amith.Kishore@TechMahindra.com'),(7,NULL,NULL,NULL,NULL,NULL,NULL,'Sucessful_Password_Reset_Staff',NULL,'no-reply@mapworks.com','ramesh.kumhar@techmahindra.com,SP00345364@TechMahindra.com,devadoss.poornachari@techmahindra.com,Amith.Kishore@TechMahindra.com'),(8,NULL,NULL,NULL,NULL,NULL,NULL,'Sucessful_Password_Reset_Coordinator',NULL,'no-reply@mapworks.com','ramesh.kumhar@techmahindra.com,SP00345364@TechMahindra.com,devadoss.poornachari@techmahindra.com,Amith.Kishore@TechMahindra.com');
  
  INSERT INTO `email_template_lang` VALUES (1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'<html>\n<div style=\"margin: 10px 0px 0px; padding: 0px; color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; background-color: rgb(255, 255, 255);\">\nHi $$firstname$$,<br/><br/>\n\nA MAP-Works password was successfully created for your account.If this was not you or you believe this is an error,\nplease contact MAP-Works support at &nbsp;<a class=\"external-link\" href=\"mailto:$$Support_Helpdesk_Email_Address$$\" rel=\"nofollow\" style=\"color: rgb(41, 114, 155); text-decoration: underline;\">$$Support_Helpdesk_Email_Address$$</a><br/><br/>\n\nWe\'re very happy to have you on board, and are here to support you!<br/><br/>\nThank you from the MAP-Works team!\n\n</div>\n</html>','MAP-Works password created [Welcome_Email_Staff]'),(2,2,1,NULL,NULL,NULL,NULL,NULL,NULL,'<html>\n<div style=\"margin: 10px 0px 0px; padding: 0px; color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; background-color: rgb(255, 255, 255);\">\nHi $$firstname$$,<br/></br>\n\nPlease use the link below and follow the displayed instructions to create your new password. This link will expire after $$Reset_Password_Expiry_Hrs$$ hours.<br />\n<br/>\n$$activation_token$$<br/><br/>\n\nIf you believe that you received this email in error or if you have any questions,please contact MAP-works support at <span style=\"color: #99ccff;\">$$Support_Helpdesk_Email_Address$$</span>.<br/><br/>\nThank you from the MAP-Works team!\n </div>\n</html>\n\n','MAP-Works - how to reset your password [Forgot_Password_Staff]'),(3,3,1,NULL,NULL,NULL,NULL,NULL,NULL,'<html>\n 	\n 		<div style=\"margin: 10px 0px 0px; padding: 0px; color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; background-color: rgb(255, 255, 255);\">\n 			Hi $$firstname$$,<br/><br/>\n 		\n 			An update to your MAP-Works account was successfully made. The following information was updated: <br/><br/> \n 		\n 			$$Updated_MyAccount_fields$$\n 		<br/>\n 		\n 			If this was not you or you believe this is an error, please contact MAP-Works support at&nbsp;<a class=\"external-link\" href=\"mailto:support@map-works.com\" rel=\"nofollow\" style=\"color: rgb(41, 114, 155); text-decoration: underline;\">support@map-works.com</a></p>\n 		\n 			<br>Thank you from the MAP-Works team!</br>\n 	</div>\n </html>\n ','MAP-Works profile updated [MyAccount_Updated_Staff]'),(4,4,1,NULL,NULL,NULL,NULL,NULL,NULL,'<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\n    \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<!--[if lte IE 7]> <html class=\"ie7\">\n<style>\n    .ie7 div.forIE7{ margin-left:0px !important;}\n</style>\n <![endif]-->\n<html>\n<head>\n<meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge, chrome=1\" />\n\n</head>\n\n<body>\n	<table cellpadding=\"58\" height=\"337px\" style=\"font-family:helvetica,arial,verdana,san-serif;font-weight:normal;width:900px; text-align:center;\">\n		<tr bgcolor=\"#eeeeee\" style=\"width:900px;padding:0px;\"><td style=\"width:900px;padding:0px;\" >\n		<table style=\"text-align:center;\" style=\"width:100%\">\n		<tr>\n		<td>\n		<table style=\"padding-top:58px;\" style=\"width:100%\">\n		<tr>\n		<td>\n		<div style=\"text-align:center;padding-top:58px;font-size: 33px;height:80px;width:900px;font-family:helvetica,arial,verdana,san-serif;font-weight:normal;color:#000000\">\n			<br>Welcome to MAP-Works.\n		</div>\n		</td>\n		</tr>\n		</table>\n		</td></tr>\n		<tr>\n		<td>\n		<div style=\"text-align:center;font-family:helvetica,arial,verdana,san-serif;font-weight:normal;color:#333333;font-size: 16px;height:16px;padding-top:10px;\">\n			Use the link below to create your password and start using MAP-Works.\n		</div>\n		</td></tr>\n		<tr><table  cellpadding=\"40\" style=\"width:100%\">\n		<td>\n		<div style=\"text-align:center;color: #000000;font-weight:normal;font-size: 20px;\">\n		\n		<div class=\"forIE7\" style=\"margin-left: 322px;\">\n		\n		<table style=\"border-radius:2px;width:175px;font-size:20px;font-family:helvetica,arial,verdana,san-serif;font-weight:normal;text-align:center;padding:15px 0px\">\n		<tbody><tr><td style=\"background-color:#4673a7; height:60px;\"><div style=\"line-height:60px; text-decoration: none; vertical-align: middle;\"><a href=\"$$activation_token$$\" style=\"background-color: #4673a7; color: #ffffff;display: block;height: 60px;text-decoration: none;width:175px \"target=\"_blank\">Sign In Now</a></div></td></tr></tbody></table>\n		</div>\n		\n			<div style=\"margin-left:auto; margin-right:auto;width:100%;font-size: 14px;height:14px;padding-bottom:47px;font-family:helvetica,arial,verdana,san-serif;font-weight:medium;color:#333333;link:#1e73d5;padding-top:10px;\">\n				<span>Use this link to <a target=\"_blank\" style=\"link:#1e73d5;\" href=\"$$activation_token$$\">sign in.</a><span>  \n			</div>\n		</div>\n		</td></table></tr></table>\n		</td></tr>\n\n		<tr><td>\n		<div style=\"text-align:left;margin-left:10px;font-family:helvetica,arial,verdana,san-serif;font-weight:normal;\n			margin-right:18px;font-size: 13px;color: #333333;margin-top:30px;link:#1e73d5;font-weight:normal;\" >\n				<p>Thank you for participating in the spring 2015 pilot. We look forward to hearing your feedback as\n				it will inform future releases of our new student retention and success solution.\n				\n				<br><br>\n				If you have any questions, please contact us here.<br>\n				<a href=\"mailto:$$Support_Helpdesk_Email_Address$$\" style=\"link:#1e73d5;\">$$Support_Helpdesk_Email_Address$$</a> \n				<br><br>\n				Sincerely,\n				<div style=\"text-align:left;font-weight:bold;font-size: 14px;color:#333333\" >\n					<b>The EBI MAP-Works Client Services Team</b> \n					</p>\n				</div>\n		</div>\n		</td></tr>\n\n	</table>\n	</body>\n</html>\n','Map-Works - SignIn Instructions [Create_Password_Coordinator]'),(5,5,1,NULL,NULL,NULL,NULL,NULL,NULL,'<html>\n<div style=\"margin: 10px 0px 0px; padding: 0px; color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; background-color: rgb(255, 255, 255);\">\nHi $$firstname$$,<br/></br>\n\nPlease use the link below and follow the displayed instructions to create your new password. This link will expire after $$Reset_Password_Expiry_Hrs$$ hours.<br />\n<br/>\n$$activation_token$$<br/><br/>\n\nIf you believe that you received this email in error or if you have any questions,please contact MAP-works support at <span style=\"color: #99ccff;\">$$Support_Helpdesk_Email_Address$$</span>.<br/><br/>\nThank you from the MAP-Works team!\n </div>\n</html>\n\n','MAP-Works - how to reset your password [Forgot_Password_Coordinator]'),(6,6,1,NULL,NULL,NULL,NULL,NULL,NULL,'<html>\n<div style=\"margin: 10px 0px 0px; padding: 0px; color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; background-color: rgb(255, 255, 255);\">\nHi $$firstname$$,<br/><br/>\n\nA MAP-Works password was successfully created for your account. If this was not you or you believe this is an error,\nplease contact MAP-Works support at &nbsp;<a class=\"external-link\" href=\"mailto:support@map-works.com\" rel=\"nofollow\" style=\"color: rgb(41, 114, 155); text-decoration: underline;\">support@map-works.com</a><br/><br/>\n\nWe\'re very happy to have you on board, and are here to support you!<br/><br/>\nThank you from the MAP-Works team!\n\n</div>\n</html>','MAP-Works password created [Welcome_Email_Coordinator]'),(7,7,1,NULL,NULL,NULL,NULL,NULL,NULL,'<html>\n<div style=\"margin: 10px 0px 0px; padding: 0px; color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; background-color: rgb(255, 255, 255);\">\nHi $$firstname$$,<br/><br/>\n\nYour MAP-Works password has been changed. If this was not you or you believe this is an error, please contact MAP-Works support at &nbsp;<a class=\"external-link\" href=\"mailto:support@map-works.com\" rel=\"nofollow\" style=\"color: rgb(41, 114, 155); text-decoration: none;\">support@map-works.com</a>\n<br/><br/>\nThank you from the MAP-Works team!\n\n</div>\n</html>','MAP-Works password reset [Sucessful_Password_Reset_Staff]'),(8,8,1,NULL,NULL,NULL,NULL,NULL,NULL,'<html>\n<div style=\"margin: 10px 0px 0px; padding: 0px; color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; background-color: rgb(255, 255, 255);\">\nHi $$firstname$$,<br/><br/>\n\nYour MAP-Works password has been changed. If this was not you or you believe this is an error, please contact MAP-Works support at &nbsp;<a class=\"external-link\" href=\"mailto:support@map-works.com\" rel=\"nofollow\" style=\"color: rgb(41, 114, 155); text-decoration: underline;\">support@map-works.com</a>\n<br/><br/>\nThank you from the MAP-Works team!\n\n</div>\n</html>','MAP-Works password reset [Sucessful_Password_Reset_Coordinator]');
  
  
  INSERT INTO `entity` VALUES (1,'organization',NULL,NULL,NULL,NULL,NULL,NULL),(2,'Student',NULL,NULL,NULL,NULL,NULL,NULL),(3,'Faculty',NULL,NULL,NULL,NULL,NULL,NULL);
  
  
  
  INSERT INTO `metadata_master` VALUES (1,1,NULL,NULL,'2014-09-02 19:16:24',NULL,'2014-09-03 04:52:03',NULL,NULL,'System_timezones','O','S',NULL,NULL,NULL,NULL,0);
  
  
  
  
  INSERT INTO `metadata_master_lang` VALUES (1,1,1,NULL,'2014-09-02 19:16:24',NULL,'2014-09-02 19:16:24',NULL,NULL,'System_timezones','System_timezones');
  
  
  INSERT INTO `metadata_list_values` VALUES (NULL,1,1,NULL,'2014-09-03 04:21:13',NULL,'2014-09-03 04:21:13',NULL,NULL,'India','India',0);
  INSERT INTO `metadata_list_values` VALUES (NULL,1,1,NULL,'2014-09-03 04:21:13',NULL,'2014-09-03 04:21:13',NULL,NULL,'Asia','Asia',0);
  
  
  
  INSERT INTO `org_group` VALUES (1,1,NULL,NULL,'2014-09-12 12:56:56',NULL,'2014-09-13 13:56:56',NULL,'2014-09-16 10:55:19','Resident Assistants');
  
  INSERT INTO `org_permissionset` VALUES (1,1,NULL,NULL,NULL,NULL,NULL,NULL,'Permission Alpha',NULL,NULL,NULL,NULL,NULL),(2,1,NULL,NULL,NULL,NULL,NULL,NULL,'Permission Charlie',NULL,NULL,NULL,NULL,NULL);
  
  
  INSERT INTO `role` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'A'),(2,NULL,NULL,NULL,NULL,NULL,NULL,'A'),(3,NULL,NULL,NULL,NULL,NULL,NULL,'A');
  
  
  INSERT INTO `role_lang` VALUES (1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'Primary coordinator'),(2,2,1,NULL,NULL,NULL,NULL,NULL,NULL,'Technical coordinator'),(3,3,1,NULL,NULL,NULL,NULL,NULL,NULL,'Non Technical coordinator');
  
  INSERT INTO `organization_role` VALUES (1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `organization_role` VALUES (2,1,2,1,NULL,NULL,NULL,NULL,NULL,NULL);
  
  INSERT INTO `person_entity` VALUES (1,3);
  INSERT INTO `person_entity` VALUES (2,3);
  INSERT INTO `person_entity` VALUES (3,3);
  
  INSERT INTO `person_contact_info`(`person_id`,`contact_id`,`status`) VALUES (1,1,"A");
  INSERT INTO `person_contact_info` (`person_id`,`contact_id`,`status`)VALUES (2,2,"A");
  INSERT INTO `person_contact_info` (`person_id`,`contact_id`,`status`)VALUES (3,3,"A");
  
  
  
  
  
  