INSERT INTO `<<prefix>>languages` (`id`, `uid`, `name`, `code`, `region_code`, `status`, `is_default`, `created_at`, `updated_at`) VALUES
(1, '5781b681c1b34', 'English', 'en', 'us', 'active', 1, '2016-07-10 09:44:17', '2016-07-10 09:44:17'),
(2, '581b52d8acdca', 'Spanish', 'es', 'es', 'active', 0, '2016-07-10 09:44:17', '2016-07-10 09:44:17');

INSERT INTO `<<prefix>>layouts` (`uid`, `alias`, `subject`, `group_name`, `content`, `type`, `created_at`, `updated_at`) VALUES
('57639eb9715cf', 'sign_up_form', 'Sign up', 'Sign-up', '	<!-- Page container -->\r\n	<div class="page-container login-container" style="min-height:249px">\r\n\r\n		<!-- Page content -->\r\n		<div class="page-content">\r\n\r\n			<!-- Main content -->\r\n			<div class="content-wrapper">\r\n				<div class="row">\r\n					<div class="col-sm-2 col-md-3">\r\n						\r\n					</div>\r\n					<div class="col-sm-8 col-md-6">\r\n\r\n                    <!-- subscribe form -->\r\n				                  \r\n					<h2 class="text-semibold mt-40 text-white">{LIST_NAME}</h2>\r\n                        <div class="panel panel-body">						\r\n                                                \r\n                        <h4>Welcome to {CONTACT_NAME}</h4>\r\n                        <hr>\r\n                        {FIELDS}\r\n                        <br>\r\n                        {SUBSCRIBE_BUTTON}\r\n\r\n					</div>\r\n\r\n                    <!-- /subscribe form -->\r\n    \r\n						\r\n					</div>\r\n				</div>\r\n			</div>\r\n			<!-- /main content -->\r\n\r\n		</div>\r\n		<!-- /page content -->\r\n\r\n\r\n		<!-- Footer -->\r\n		<div class="footer text-white">\r\n			<span class="text-white">{CONTACT_NAME}</span>, <a href="{CONTACT_URL}" class="text-white" target="_blank">{CONTACT_URL}</a>			\r\n		</div>\r\n		<!-- /footer -->\r\n\r\n	</div>\r\n	<!-- /page container -->', 'page', '2016-06-19 00:54:49', '2016-06-19 00:54:49'),
('5763c01613687', 'sign_up_thankyou_page', 'Thank you', 'Sign-up', '<!-- Page container -->\r\n	<div class="page-container login-container" style="min-height:249px">\r\n\r\n		<!-- Page content -->\r\n		<div class="page-content">\r\n\r\n			<!-- Main content -->\r\n			<div class="content-wrapper">\r\n				<div class="row">\r\n					<div class="col-sm-2 col-md-3">\r\n						\r\n					</div>\r\n					<div class="col-sm-8 col-md-6">\r\n\r\n                    <!-- subscribe form -->\r\n				                  \r\n					<h2 class="text-semibold mt-40 text-white">{LIST_NAME}</h2>\r\n                        <div class="panel panel-body">						\r\n                                                \r\n                        <h4>Almost finished...</h4>\r\n                        <hr>\r\n						<p>We need to confirm your email address.</p>\r\n						<p>To complete the subscription process, please click the link in the email we just sent you.\r\n						</p>\r\n						--<br />\r\n						\r\n                        {CONTACT_NAME}\r\n\r\n					</div>\r\n\r\n                    <!-- /subscribe form -->\r\n    \r\n						\r\n					</div>\r\n				</div>\r\n			</div>\r\n			<!-- /main content -->\r\n\r\n		</div>\r\n		<!-- /page content -->\r\n\r\n\r\n		<!-- Footer -->\r\n		<div class="footer text-white">\r\n			<span class="text-white">{CONTACT_NAME}</span>, <a href="{CONTACT_URL}" class="text-white" target="_blank">{CONTACT_URL}</a>			\r\n		</div>\r\n		<!-- /footer -->\r\n\r\n	</div>\r\n	<!-- /page container -->', 'page', '2016-06-19 03:17:10', '2016-06-19 03:17:10'),
('5763c3ef7bb8e', 'sign_up_confirmation_email', 'Sign-up confirmation', 'Sign-up', '<!-- Page container -->\r\n<div class="page-container login-container" style="min-height: 249px;"><!-- Page content -->\r\n<div class="page-content"><!-- Main content -->\r\n<div class="content-wrapper">\r\n<div class="row">\r\n<div class="col-sm-2 col-md-3"></div>\r\n<div class="col-sm-8 col-md-6"><!-- subscribe form -->\r\n<h2 class="text-semibold mt-40 text-white">{LIST_NAME}</h2>\r\n<div class="panel panel-body">\r\n<h4>Please Confirm Subscription</h4>\r\n<hr />Click the link below to confirm your subscription:<br /> {SUBSCRIBE_CONFIRM_URL}<hr />\r\n<p>If you received this email by mistake, simply delete it. You won\'t be subscribed if you don\'t click the confirmation link above.</p>\r\n<p>For questions about this list, please contact: <br /> <a href="mailto:{CONTACT_EMAIL}">{CONTACT_EMAIL}</a></p>\r\n</div>\r\n<!-- /subscribe form --></div>\r\n</div>\r\n</div>\r\n<!-- /main content --></div>\r\n<!-- /page content --> <!-- Footer -->\r\n<div class="footer text-white">&copy; 2020. <span class="text-white">{CONTACT_NAME}</span>, <a href="{CONTACT_URL}" class="text-white" target="_blank">{CONTACT_URL}</a></div>\r\n<!-- /footer --></div>\r\n<!-- /page container -->', 'email', '2016-06-19 03:33:35', '2016-06-30 03:55:55'),
('5763cab0459c8', 'sign_up_confirmation_thankyou', 'Thank you', 'Sign-up', '<!-- Page container -->\r\n	<div class="page-container login-container" style="min-height:249px">\r\n\r\n		<!-- Page content -->\r\n		<div class="page-content">\r\n\r\n			<!-- Main content -->\r\n			<div class="content-wrapper">\r\n				<div class="row">\r\n					<div class="col-sm-2 col-md-3">\r\n						\r\n					</div>\r\n					<div class="col-sm-8 col-md-6">\r\n\r\n                    <!-- subscribe form -->\r\n				                  \r\n					<h2 class="text-semibold mt-40 text-white">{LIST_NAME}</h2>\r\n                        <div class="panel panel-body">						\r\n                                                \r\n                        <h4>Subscription Confirmed</h4>\r\n                        <hr>\r\n						<p>Your subscription to our list has been confirmed.\r\n</p>\r\n<p>Thank you for subscribing!</p>\r\n\r\n						\r\n                        <a href="{CONTACT_URL}" class="btn btn-info bg-teal-800">Continue to our website</a> or <a href="{UPDATE_PROFILE_URL}" class="btn btn-info bg-teal-800">Manage your preferences</a>\r\n\r\n					</div>\r\n\r\n                    <!-- /subscribe form -->\r\n    \r\n						\r\n					</div>\r\n				</div>\r\n			</div>\r\n			<!-- /main content -->\r\n\r\n		</div>\r\n		<!-- /page content -->\r\n\r\n\r\n		<!-- Footer -->\r\n		<div class="footer text-white">\r\n			<span class="text-white">{CONTACT_NAME}</span>, <a href="{CONTACT_URL}" class="text-white" target="_blank">{CONTACT_URL}</a>			\r\n		</div>\r\n		<!-- /footer -->\r\n\r\n	</div>\r\n	<!-- /page container -->', 'page', '2016-06-19 04:02:24', '2016-06-19 04:02:24'),
('5764b3c8bcf4a', 'sign_up_welcome_email', 'Welcome', 'Sign-up', '<!-- Page container -->\r\n<div class="page-container login-container" style="min-height: 249px;"><!-- Page content -->\r\n<div class="page-content"><!-- Main content -->\r\n<div class="content-wrapper">\r\n<div class="row">\r\n<div class="col-sm-2 col-md-3"></div>\r\n<div class="col-sm-8 col-md-6"><!-- subscribe form -->\r\n<h2 class="text-semibold mt-40 text-white">{LIST_NAME}</h2>\r\n<div class="panel panel-body">\r\n<h4>Your subscription to our list has been confirmed.</h4>\r\n<hr />\r\n<p>For your records, here is a copy of the information you submitted to us...</p>\r\n{SUBSCRIBER_SUMMARY}<hr />\r\n<p>If at any time you wish to stop receiving our emails, you can: <br /> <a href="{UNSUBSCRIBE_URL}" class="btn btn-info bg-teal-800">Unsubscribe here</a></p>\r\n<p>You may also contact us at: <br /> <a href="mailto:{CONTACT_EMAIL}">{CONTACT_EMAIL}</a></p>\r\n</div>\r\n<!-- /subscribe form --></div>\r\n</div>\r\n</div>\r\n<!-- /main content --></div>\r\n<!-- /page content --> <!-- Footer -->\r\n<div class="footer text-white">&copy; 2020. <span class="text-white">{CONTACT_NAME}</span>, <a href="{CONTACT_URL}" class="text-white" target="_blank">{CONTACT_URL}</a></div>\r\n<!-- /footer --></div>\r\n<!-- /page container -->', 'email', '2016-06-19 20:36:56', '2016-06-30 03:56:51'),
('5764bac04f223', 'unsubscribe_form', 'Unsubscribe', 'Unsubscribe', '<!-- Page container -->\r\n	<div class="page-container login-container" style="min-height:249px">\r\n\r\n		<!-- Page content -->\r\n		<div class="page-content">\r\n\r\n			<!-- Main content -->\r\n			<div class="content-wrapper">\r\n				<div class="row">\r\n					<div class="col-sm-2 col-md-3">\r\n						\r\n					</div>\r\n					<div class="col-sm-8 col-md-6">\r\n\r\n                    <!-- form -->\r\n				                  \r\n					<h2 class="text-semibold mt-40 text-white">{LIST_NAME}</h2>\r\n                        <div class="panel panel-body">						\r\n                                                \r\n                        <h4>Unsubscribe</h4>\r\n                        <hr>\r\n                        <p>You are going to opt out of mail list {LIST_NAME}, please click the button below to confirm. Really sorry to let you go!</p>\r\n                        \r\n                        \r\n\r\n\r\n<p>{UNSUBSCRIBE_BUTTON}</p>\r\n					</div>\r\n\r\n                    <!-- /form -->\r\n    \r\n						\r\n					</div>\r\n				</div>\r\n			</div>\r\n			<!-- /main content -->\r\n\r\n		</div>\r\n		<!-- /page content -->\r\n\r\n\r\n		<!-- Footer -->\r\n		<div class="footer text-white">\r\n			<span class="text-white">{CONTACT_NAME}</span>, <a href="{CONTACT_URL}" class="text-white" target="_blank">{CONTACT_URL}</a>			\r\n		</div>\r\n		<!-- /footer -->\r\n\r\n	</div>\r\n	<!-- /page container -->', 'page', '2016-06-19 21:06:40', '2016-06-19 21:06:40'),
('5764c2d612aea', 'unsubscribe_success_page', 'Unsubscribed', 'Unsubscribe', '	<!-- Page container -->\n	<div class="page-container login-container" style="min-height:249px">\n\n		<!-- Page content -->\n		<div class="page-content">\n\n			<!-- Main content -->\n			<div class="content-wrapper">\n				<div class="row">\n					<div class="col-sm-2 col-md-3">\n						\n					</div>\n					<div class="col-sm-8 col-md-6">\n\n                    <!-- form -->\n				                  \n					<h2 class="text-semibold mt-40 text-white">{LIST_NAME}</h2>\n                        <div class="panel panel-body">						\n                                                \n                        <h4>Unsubscribe Successful</h4>\n                        <hr>\n                        <p>You have been removed from {LIST_NAME}.</p>\n                        \n                        <br />\n					</div>\n\n                    <!-- /form -->\n    \n						\n					</div>\n				</div>\n			</div>\n			<!-- /main content -->\n\n		</div>\n		<!-- /page content -->\n\n\n		<!-- Footer -->\n		<div class="footer text-white">\n			<span class="text-white">{CONTACT_NAME}</span>, <a href="{CONTACT_URL}" class="text-white" target="_blank">{CONTACT_URL}</a>			\n		</div>\n		<!-- /footer -->\n\n	</div>\n	<!-- /page container -->', 'page', '2016-06-19 21:41:10', '2016-06-19 21:41:10'),
('5764c466641c7', 'unsubscribe_goodbye_email', 'Unsubscribed', 'Unsubscribe', '	<!-- Page container -->\n	<div class="page-container login-container" style="min-height:249px">\n\n		<!-- Page content -->\n		<div class="page-content">\n\n			<!-- Main content -->\n			<div class="content-wrapper">\n				<div class="row">\n					<div class="col-sm-2 col-md-3">\n						\n					</div>\n					<div class="col-sm-8 col-md-6">\n\n                    <!-- form -->\n				                  \n					<h2 class="text-semibold mt-40 text-white">{LIST_NAME}</h2>\n                        <div class="panel panel-body">						\n                                                \n                        <h4>We have removed your email address from our list.</h4>\n                        <hr>\n                        <p>We\'re sorry to see you go.</p>\n                        <p>Was this a mistake? Did you forward one of our emails to a friend, and they clicked the unsubscribe link not realizing they were in fact unsubscribing you from this list? If this was a mistake, you can re-subscribe at: <br />\n<a href="{SUBSCRIBE_URL}" class="btn btn-info bg-teal-800">Subscribe</a>\n</p>\n                        <br />\nFor questions or comments, please contact us at:<br />\n<a href="mailto:{CONTACT_EMAIL}">{CONTACT_EMAIL}</a>\n					</div>\n\n                    <!-- /form -->\n    \n						\n					</div>\n				</div>\n			</div>\n			<!-- /main content -->\n\n		</div>\n		<!-- /page content -->\n\n\n		<!-- Footer -->\n		<div class="footer text-white">\n			<span class="text-white">{CONTACT_NAME}</span>, <a href="{CONTACT_URL}" class="text-white" target="_blank">{CONTACT_URL}</a>			\n		</div>\n		<!-- /footer -->\n\n	</div>\n	<!-- /page container -->', 'email', '2016-06-19 21:47:50', '2016-06-19 21:47:50'),
('5764c710527b8', 'profile_update_email', 'Update profile', 'Update profile', '	<!-- Page container -->\r\n	<div class="page-container login-container" style="min-height:249px">\r\n\r\n		<!-- Page content -->\r\n		<div class="page-content">\r\n\r\n			<!-- Main content -->\r\n			<div class="content-wrapper">\r\n				<div class="row">\r\n					<div class="col-sm-2 col-md-3">\r\n						\r\n					</div>\r\n					<div class="col-sm-8 col-md-6">\r\n\r\n                    <!-- form -->\r\n				                  \r\n					<h2 class="text-semibold mt-40 text-white">{LIST_NAME}</h2>\r\n                        <div class="panel panel-body">						\r\n                                                \r\n                        <p>We received a request to change your subscription preferences for List 1.</p>\r\n\r\n<p>If you made this request, and would like to change your preferences, use the link below</p>\r\n\r\n<p><a href="{UPDATE_PROFILE_URL}">Update your preferences</a></p>\r\n\r\n<p>If you did not make this request, it was probably submitted by someone else by mistake. You can ignore this email, and no changes will be made to your subscription preferences.</p>\r\n\r\n<p>\r\nFor questions about this list, please contact: <br />\r\n<a href="{CONTACT_EMAIL}">{CONTACT_EMAIL}</a>\r\n</p>\r\n					</div>\r\n\r\n                    <!-- /form -->\r\n    \r\n						\r\n					</div>\r\n				</div>\r\n			</div>\r\n			<!-- /main content -->\r\n\r\n		</div>\r\n		<!-- /page content -->\r\n\r\n\r\n		<!-- Footer -->\r\n		<div class="footer text-white">\r\n			<span class="text-white">{CONTACT_NAME}</span>, <a href="{CONTACT_URL}" class="text-white" target="_blank">{CONTACT_URL}</a>			\r\n		</div>\r\n		<!-- /footer -->\r\n\r\n	</div>\r\n	<!-- /page container -->', 'email', '2016-06-19 21:59:12', '2016-06-19 21:59:12'),
('5764c87e6bad1', 'profile_update_form', 'Update profile', 'Update profile', '	<!-- Page container -->\r\n	<div class="page-container login-container" style="min-height:249px">\r\n\r\n		<!-- Page content -->\r\n		<div class="page-content">\r\n\r\n			<!-- Main content -->\r\n			<div class="content-wrapper">\r\n				<div class="row">\r\n					<div class="col-sm-2 col-md-3">\r\n						\r\n					</div>\r\n					<div class="col-sm-8 col-md-6">\r\n\r\n                    <!-- form -->\r\n				                  \r\n					<h2 class="text-semibold mt-40 text-white">{LIST_NAME}</h2>\r\n                        <div class="panel panel-body">						\r\n<h4>Update your preferences</h4>\r\n<hr />\r\n                        {FIELDS}<br />\r\n{UPDATE_PROFILE_BUTTON} or <a class="btn btn-info bg-grey" href="{UNSUBSCRIBE_URL}">Unsubscribe</a>\r\n\r\n\r\n					</div>\r\n\r\n                    <!-- /form -->\r\n    \r\n						\r\n					</div>\r\n				</div>\r\n			</div>\r\n			<!-- /main content -->\r\n\r\n		</div>\r\n		<!-- /page content -->\r\n\r\n\r\n		<!-- Footer -->\r\n		<div class="footer text-white">\r\n			<span class="text-white">{CONTACT_NAME}</span>, <a href="{CONTACT_URL}" class="text-white" target="_blank">{CONTACT_URL}</a>			\r\n		</div>\r\n		<!-- /footer -->\r\n\r\n	</div>\r\n	<!-- /page container -->', 'page', '2016-06-19 22:05:18', '2016-06-19 22:05:18'),
('5764c90505f1c', 'profile_update_success_page', 'Update profile', 'Update profile', '<!-- Page container -->\r\n	<div class="page-container login-container" style="min-height:249px">\r\n\r\n		<!-- Page content -->\r\n		<div class="page-content">\r\n\r\n			<!-- Main content -->\r\n			<div class="content-wrapper">\r\n				<div class="row">\r\n					<div class="col-sm-2 col-md-3">\r\n						\r\n					</div>\r\n					<div class="col-sm-8 col-md-6">\r\n\r\n                    <!-- subscribe form -->\r\n				                  \r\n					<h2 class="text-semibold mt-40 text-white">{LIST_NAME}</h2>\r\n                        <div class="panel panel-body">						\r\n                                                \r\n                        <h4>Profile Updated</h4>\r\n                        <hr>\r\n						<p>Your profile information has been updated. For your records, here is a copy of the information you submitted to us...</p>\r\n\r\n{SUBSCRIBER_SUMMARY}\r\n\r\n\r\n\r\n\r\n<hr />\r\n<a class="btn btn-info bg-teal-800" href="{CONTACT_URL}">Return to our website</a>\r\n\r\n					</div>\r\n\r\n                    <!-- /subscribe form -->\r\n    \r\n						\r\n					</div>\r\n				</div>\r\n			</div>\r\n			<!-- /main content -->\r\n\r\n		</div>\r\n		<!-- /page content -->\r\n\r\n\r\n		<!-- Footer -->\r\n		<div class="footer text-white">\r\n			<span class="text-white">{CONTACT_NAME}</span>, <a href="{CONTACT_URL}" class="text-white" target="_blank">{CONTACT_URL}</a>			\r\n		</div>\r\n		<!-- /footer -->\r\n\r\n	</div>\r\n	<!-- /page container -->', 'page', '2016-06-19 22:07:33', '2016-06-19 22:07:33'),
('5764c9812b0bc', 'profile_update_email_sent', 'Update profile', 'Update profile', '	<!-- Page container -->\r\n	<div class="page-container login-container" style="min-height:249px">\r\n\r\n		<!-- Page content -->\r\n		<div class="page-content">\r\n\r\n			<!-- Main content -->\r\n			<div class="content-wrapper">\r\n				<div class="row">\r\n					<div class="col-sm-2 col-md-3">\r\n						\r\n					</div>\r\n					<div class="col-sm-8 col-md-6">\r\n\r\n                    <!-- form -->\r\n				                  \r\n					<h2 class="text-semibold mt-40 text-white">{LIST_NAME}</h2>\r\n                        <div class="panel panel-body">						\r\n<h4>Email sent</h4>          \r\n<hr />\r\n                        <p>For security, we\'ve sent an email to your inbox that contains a link to update your preferences.</p>\r\n--<br />\r\n{CONTACT_NAME}\r\n					</div>\r\n\r\n                    <!-- /form -->\r\n    \r\n						\r\n					</div>\r\n				</div>\r\n			</div>\r\n			<!-- /main content -->\r\n\r\n		</div>\r\n		<!-- /page content -->\r\n\r\n\r\n		<!-- Footer -->\r\n		<div class="footer text-white">\r\n			<span class="text-white">{CONTACT_NAME}</span>, <a href="{CONTACT_URL}" class="text-white" target="_blank">{CONTACT_URL}</a>			\r\n		</div>\r\n		<!-- /footer -->\r\n\r\n	</div>\r\n	<!-- /page container -->', 'page', '2016-06-19 21:59:11', '2016-06-19 22:09:37'),
('58ac002f2e5c3', 'registration_confirmation_email', 'Registration confirmation', 'Subscription', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n<h2>Hello {CUSTOMER_NAME}, welcome to Acelle Mail</h2>\r\n<div class="page-container login-container" style="min-height: 249px;">\r\n<div class="page-content">\r\n<div class="content-wrapper">\r\n<div class="row">\r\n<div class="col-sm-8 col-md-6">\r\n<div class="panel panel-body">\r\n<h4>Please Confirm&nbsp;Registration</h4>\r\n<hr />Click the link below to activate your account:<br /><a href="{ACTIVATION_URL}">{ACTIVATION_URL}</a><br /><hr />\r\n<p>&nbsp;</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="footer text-white">\r\n<div class="footer text-muted">&copy; 2020. Acelle Email Marketing Application by <a class="" href="http://acellemail.com/" target="_blank">Acellemail.com</a></div>\r\n</div>\r\n<!-- /footer --></div>\r\n<!-- /page container -->\r\n<p>&nbsp;</p>\r\n</body>\r\n</html>', 'email', NULL, '2017-02-23 07:44:26');

INSERT INTO `<<prefix>>countries` (`id`, `name`, `code`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Afghanistan', 'AF', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(2, 'Albania', 'AL', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(3, 'Algeria', 'DZ', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(4, 'American Samoa', 'AS', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(5, 'Andorra', 'AD', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(6, 'Angola', 'AO', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(7, 'Anguilla', 'AI', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(8, 'Antigua', 'AG', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(9, 'Argentina', 'AR', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(10, 'Armenia', 'AM', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(11, 'Aruba', 'AW', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(12, 'Australia', 'AU', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(13, 'Austria', 'AT', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(14, 'Azerbaijan', 'AZ', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(15, 'Bahrain', 'BH', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(16, 'Bangladesh', 'BD', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(17, 'Barbados', 'BB', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(18, 'Belarus', 'BY', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(19, 'Belgium', 'BE', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(20, 'Belize', 'BZ', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(21, 'Benin', 'BJ', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(22, 'Bermuda', 'BM', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(23, 'Bhutan', 'BT', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(24, 'Bolivia', 'BO', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(25, 'Bosnia and Herzegovina', 'BA', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(26, 'Botswana', 'BW', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(27, 'Brazil', 'BR', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(28, 'British Indian Ocean Territory', 'IO', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(29, 'British Virgin Islands', 'VG', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(30, 'Brunei', 'BN', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(31, 'Bulgaria', 'BG', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(32, 'Burkina Faso', 'BF', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(33, 'Burma Myanmar', 'MM', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(34, 'Burundi', 'BI', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(35, 'Cambodia', 'KH', 'active', '2016-07-13 21:42:43', '2016-07-13 21:42:43'),
(36, 'Cameroon', 'CM', 'active', '2016-07-13 21:42:44', '2016-07-13 21:42:44'),
(37, 'Canada', 'CA', 'active', '2016-07-13 21:42:44', '2016-07-13 21:42:44'),
(38, 'Cape Verde', 'CV', 'active', '2016-07-13 21:42:44', '2016-07-13 21:42:44'),
(39, 'Cayman Islands', 'KY', 'active', '2016-07-13 21:42:44', '2016-07-13 21:42:44'),
(40, 'Central African Republic', 'CF', 'active', '2016-07-13 21:42:44', '2016-07-13 21:42:44'),
(41, 'Chad', 'TD', 'active', '2016-07-13 21:42:44', '2016-07-13 21:42:44'),
(42, 'Chile', 'CL', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(43, 'China', 'CN', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(44, 'Colombia', 'CO', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(45, 'Comoros', 'KM', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(46, 'Cook Islands', 'CK', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(47, 'Costa Rica', 'CR', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(48, 'Côte d\'Ivoire', 'CI', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(49, 'Croatia', 'HR', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(50, 'Cuba', 'CU', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(51, 'Cyprus', 'CY', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(52, 'Czech Republic', 'CZ', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(53, 'Democratic Republic of Congo', 'CD', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(54, 'Denmark', 'DK', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(55, 'Djibouti', 'DJ', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(56, 'Dominica', 'DM', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(57, 'Dominican Republic', 'DO', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(58, 'Ecuador', 'EC', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(59, 'Egypt', 'EG', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(60, 'El Salvador', 'SV', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(61, 'Equatorial Guinea', 'GQ', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(62, 'Eritrea', 'ER', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(63, 'Estonia', 'EE', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(64, 'Ethiopia', 'ET', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(65, 'Falkland Islands', 'FK', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(66, 'Faroe Islands', 'FO', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(67, 'Federated States of Micronesia', 'FM', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(68, 'Fiji', 'FJ', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(69, 'Finland', 'FI', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(70, 'France', 'FR', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(71, 'French Guiana', 'GF', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(72, 'French Polynesia', 'PF', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(73, 'Gabon', 'GA', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(74, 'Georgia', 'GE', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(75, 'Germany', 'DE', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(76, 'Ghana', 'GH', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(77, 'Gibraltar', 'GI', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(78, 'Greece', 'GR', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(79, 'Greenland', 'GL', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(80, 'Grenada', 'GD', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(81, 'Guadeloupe', 'GP', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(82, 'Guam', 'GU', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(83, 'Guatemala', 'GT', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(84, 'Guinea', 'GN', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(85, 'Guinea-Bissau', 'GW', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(86, 'Guyana', 'GY', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(87, 'Haiti', 'HT', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(88, 'Honduras', 'HN', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(89, 'Hong Kong', 'HK', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(90, 'Hungary', 'HU', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(91, 'Iceland', 'IS', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(92, 'India', 'IN', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(93, 'Indonesia', 'ID', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(94, 'Iran', 'IR', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(95, 'Iraq', 'IQ', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(96, 'Ireland', 'IE', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(97, 'Israel', 'IL', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(98, 'Italy', 'IT', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(99, 'Jamaica', 'JM', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(100, 'Japan', 'JP', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(101, 'Jordan', 'JO', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(102, 'Kazakhstan', 'KZ', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(103, 'Kenya', 'KE', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(104, 'Kiribati', 'KI', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(105, 'Kosovo', 'XK', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(106, 'Kuwait', 'KW', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(107, 'Kyrgyzstan', 'KG', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(108, 'Laos', 'LA', 'active', '2016-07-13 21:42:45', '2016-07-13 21:42:45'),
(109, 'Latvia', 'LV', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(110, 'Lebanon', 'LB', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(111, 'Lesotho', 'LS', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(112, 'Liberia', 'LR', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(113, 'Libya', 'LY', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(114, 'Liechtenstein', 'LI', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(115, 'Lithuania', 'LT', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(116, 'Luxembourg', 'LU', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(117, 'Macau', 'MO', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(118, 'Macedonia', 'MK', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(119, 'Madagascar', 'MG', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(120, 'Malawi', 'MW', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(121, 'Malaysia', 'MY', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(122, 'Maldives', 'MV', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(123, 'Mali', 'ML', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(124, 'Malta', 'MT', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(125, 'Marshall Islands', 'MH', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(126, 'Martinique', 'MQ', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(127, 'Mauritania', 'MR', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(128, 'Mauritius', 'MU', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(129, 'Mayotte', 'YT', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(130, 'Mexico', 'MX', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(131, 'Moldova', 'MD', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(132, 'Monaco', 'MC', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(133, 'Mongolia', 'MN', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(134, 'Montenegro', 'ME', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(135, 'Montserrat', 'MS', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(136, 'Morocco', 'MA', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(137, 'Mozambique', 'MZ', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(138, 'Namibia', 'NA', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(139, 'Nauru', 'NR', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(140, 'Nepal', 'NP', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(141, 'Netherlands', 'NL', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(142, 'Netherlands Antilles', 'AN', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(143, 'New Caledonia', 'NC', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(144, 'New Zealand', 'NZ', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(145, 'Nicaragua', 'NI', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(146, 'Niger', 'NE', 'active', '2016-07-13 21:42:46', '2016-07-13 21:42:46'),
(147, 'Nigeria', 'NG', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(148, 'Niue', 'NU', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(149, 'Norfolk Island', 'NF', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(150, 'North Korea', 'KP', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(151, 'Northern Mariana Islands', 'MP', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(152, 'Norway', 'NO', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(153, 'Oman', 'OM', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(154, 'Pakistan', 'PK', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(155, 'Palau', 'PW', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(156, 'Palestine', 'PS', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(157, 'Panama', 'PA', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(158, 'Papua New Guinea', 'PG', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(159, 'Paraguay', 'PY', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(160, 'Peru', 'PE', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(161, 'Philippines', 'PH', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(162, 'Poland', 'PL', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(163, 'Portugal', 'PT', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(164, 'Puerto Rico', 'PR', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(165, 'Qatar', 'QA', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(166, 'Republic of the Congo', 'CG', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(167, 'Réunion', 'RE', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(168, 'Romania', 'RO', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(169, 'Russia', 'RU', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(170, 'Rwanda', 'RW', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(171, 'Saint Barthélemy', 'BL', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(172, 'Saint Helena', 'SH', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(173, 'Saint Kitts and Nevis', 'KN', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(174, 'Saint Martin', 'MF', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(175, 'Saint Pierre and Miquelon', 'PM', 'active', '2016-07-13 21:42:47', '2016-07-13 21:42:47'),
(176, 'Saint Vincent and the Grenadines', 'VC', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(177, 'Samoa', 'WS', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(178, 'San Marino', 'SM', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(179, 'São Tomé and Príncipe', 'ST', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(180, 'Saudi Arabia', 'SA', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(181, 'Senegal', 'SN', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(182, 'Serbia', 'RS', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(183, 'Seychelles', 'SC', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(184, 'Sierra Leone', 'SL', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(185, 'Singapore', 'SG', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(186, 'Slovakia', 'SK', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(187, 'Slovenia', 'SI', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(188, 'Solomon Islands', 'SB', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(189, 'Somalia', 'SO', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(190, 'South Africa', 'ZA', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(191, 'South Korea', 'KR', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(192, 'Spain', 'ES', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(193, 'Sri Lanka', 'LK', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(194, 'St. Lucia', 'LC', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(195, 'Sudan', 'SD', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(196, 'Suriname', 'SR', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(197, 'Swaziland', 'SZ', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(198, 'Sweden', 'SE', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(199, 'Switzerland', 'CH', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(200, 'Syria', 'SY', 'active', '2016-07-13 21:42:48', '2016-07-13 21:42:48'),
(201, 'Taiwan', 'TW', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(202, 'Tajikistan', 'TJ', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(203, 'Tanzania', 'TZ', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(204, 'Thailand', 'TH', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(205, 'The Bahamas', 'BS', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(206, 'The Gambia', 'GM', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(207, 'Timor-Leste', 'TL', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(208, 'Togo', 'TG', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(209, 'Tokelau', 'TK', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(210, 'Tonga', 'TO', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(211, 'Trinidad and Tobago', 'TT', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(212, 'Tunisia', 'TN', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(213, 'Turkey', 'TR', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(214, 'Turkmenistan', 'TM', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(215, 'Turks and Caicos Islands', 'TC', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(216, 'Tuvalu', 'TV', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(217, 'Uganda', 'UG', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(218, 'Ukraine', 'UA', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(219, 'United Arab Emirates', 'AE', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(220, 'United Kingdom', 'GB', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(221, 'United States', 'US', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(222, 'Uruguay', 'UY', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(223, 'US Virgin Islands', 'VI', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(224, 'Uzbekistan', 'UZ', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(225, 'Vanuatu', 'VU', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(226, 'Vatican City', 'VA', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(227, 'Venezuela', 'VE', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(228, 'Vietnam', 'VN', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(229, 'Wallis and Futuna', 'WF', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(230, 'Yemen', 'YE', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(231, 'Zambia', 'ZM', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49'),
(232, 'Zimbabwe', 'ZW', 'active', '2016-07-13 21:42:49', '2016-07-13 21:42:49');

INSERT INTO `<<prefix>>admin_groups` (`id`, `name`, `options`, `permissions`, `custom_order`, `creator_id`, `created_at`, `updated_at`) VALUES
(1, 'Administrator', '', '{"admin_group_read":"all","admin_group_create":"yes","admin_group_update":"all","admin_group_delete":"all","admin_read":"all","admin_create":"yes","admin_update":"all","admin_delete":"all","admin_login_as":"all","customer_read":"all","customer_create":"yes","customer_update":"all","customer_delete":"all","customer_login_as":"all","subscription_read":"all","subscription_create":"yes","subscription_update":"all","subscription_disable":"all","subscription_enable":"all","subscription_delete":"all","subscription_paid":"all","subscription_unpaid":"all","plan_read":"all","plan_create":"yes","plan_update":"all","plan_delete":"all","payment_method_read":"all","payment_method_create":"yes","payment_method_update":"all","payment_method_delete":"all","sending_server_read":"all","sending_server_create":"yes","sending_server_update":"all","sending_server_delete":"all","bounce_handler_read":"all","bounce_handler_create":"yes","bounce_handler_update":"all","bounce_handler_delete":"all","fbl_handler_read":"all","fbl_handler_create":"yes","fbl_handler_update":"all","fbl_handler_delete":"all","sending_domain_read":"all","sending_domain_create":"yes","sending_domain_update":"all","sending_domain_delete":"all","template_read":"all","template_create":"yes","template_update":"all","template_delete":"all","layout_read":"yes","layout_update":"yes","setting_general":"yes","setting_sending":"yes","setting_system_urls":"yes","setting_access_when_offline":"yes","setting_background_job":"yes","setting_upgrade_manager":"yes","language_read":"yes","language_create":"yes","language_update":"yes","language_delete":"yes","currency_read":"all","currency_create":"yes","currency_update":"all","currency_delete":"all","report_blacklist":"yes","report_tracking_log":"yes","report_bounce_log":"yes","report_feedback_log":"yes","report_open_log":"yes","report_click_log":"yes","report_unsubscribe_log":"yes"}', 1, NULL, '2017-03-06 19:33:12', '2017-04-09 07:31:41'),
(2, 'Reseller', '', '{"admin_group_read":"no","admin_group_create":"no","admin_group_update":"no","admin_group_delete":"no","admin_read":"no","admin_create":"no","admin_update":"no","admin_delete":"no","admin_login_as":"no","customer_read":"own","customer_create":"yes","customer_update":"own","customer_delete":"own","customer_login_as":"own","subscription_read":"own","subscription_create":"yes","subscription_update":"no","subscription_disable":"own","subscription_enable":"own","subscription_delete":"own","subscription_paid":"no","subscription_unpaid":"no","plan_read":"all","plan_create":"no","plan_update":"no","plan_delete":"no","payment_method_read":"no","payment_method_create":"no","payment_method_update":"no","payment_method_delete":"no","sending_server_read":"no","sending_server_create":"no","sending_server_update":"no","sending_server_delete":"no","bounce_handler_read":"no","bounce_handler_create":"no","bounce_handler_update":"no","bounce_handler_delete":"no","fbl_handler_read":"no","fbl_handler_create":"no","fbl_handler_update":"no","fbl_handler_delete":"no","sending_domain_read":"no","sending_domain_create":"no","sending_domain_update":"no","sending_domain_delete":"no","template_read":"own","template_create":"yes","template_update":"own","template_delete":"own","layout_read":"no","layout_update":"no","setting_general":"no","setting_sending":"no","setting_system_urls":"no","setting_access_when_offline":"no","setting_background_job":"no","setting_upgrade_manager":"no","language_read":"no","language_create":"no","language_update":"no","language_delete":"no","currency_read":"no","currency_create":"no","currency_update":"no","currency_delete":"no","report_blacklist":"no","report_tracking_log":"no","report_bounce_log":"no","report_feedback_log":"no","report_open_log":"no","report_click_log":"no","report_unsubscribe_log":"no"}', 0, NULL, '2017-04-09 07:31:41', '2017-04-09 07:34:44');

INSERT INTO `<<prefix>>currencies` (`id`, `uid`, `admin_id`, `name`, `code`, `format`, `status`, `created_at`, `updated_at`) VALUES
(1, '58bd48f91f10b', NULL, 'US Dollar', 'USD', '${PRICE}', 'active', '2017-03-06 11:33:12', '2017-03-06 11:33:12');

INSERT INTO `<<prefix>>plans` (`id`, `uid`, `admin_id`, `currency_id`, `name`, `price`, `frequency_amount`, `frequency_unit`, `options`, `status`, `color`, `custom_order`, `created_at`, `updated_at`, `tax_billing_required`, `paddle_plan_id`, `description`) VALUES
(1, '58bd48f91fcab', NULL, 1, 'Free', '0.00', '1', 'month', '{\"email_max\":\"5000\",\"list_max\":\"10\",\"subscriber_max\":\"1000\",\"subscriber_per_list_max\":\"-1\",\"segment_per_list_max\":\"3\",\"campaign_max\":\"20\",\"automation_max\":\"10\",\"billing_cycle\":\"monthly\",\"sending_limit\":\"1000_per_hour\",\"sending_quota\":1000,\"sending_quota_time\":1,\"sending_quota_time_unit\":\"hour\",\"max_process\":\"1\",\"all_sending_servers\":\"yes\",\"max_size_upload_total\":\"500\",\"max_file_size_upload\":\"5\",\"unsubscribe_url_required\":\"yes\",\"access_when_offline\":\"no\",\"create_sending_domains\":\"no\",\"sending_servers_max\":\"-1\",\"sending_domains_max\":\"-1\",\"all_email_verification_servers\":\"yes\",\"create_email_verification_servers\":\"no\",\"email_verification_servers_max\":\"-1\",\"list_import\":\"yes\",\"list_export\":\"yes\",\"all_sending_server_types\":\"yes\",\"sending_server_types\":{\"amazon-smtp\":\"yes\",\"amazon-api\":\"yes\",\"sendgrid-smtp\":\"yes\",\"sendgrid-api\":\"yes\",\"mailgun-api\":\"yes\",\"mailgun-smtp\":\"yes\",\"elasticemail-api\":\"yes\",\"elasticemail-smtp\":\"yes\",\"sparkpost-api\":\"yes\",\"sparkpost-smtp\":\"yes\",\"smtp\":\"yes\",\"sendmail\":\"yes\",\"php-mail\":\"yes\"},\"sending_server_option\":\"system\",\"sending_server_subaccount_uid\":null,\"api_access\":\"yes\",\"email_footer_enabled\":\"yes\",\"email_footer_trial_period_only\":\"no\",\"html_footer\":\"\",\"plain_text_footer\":\"\",\"payment_gateway\":\"\"}', 'inactive', '#008c6e', 1, '2017-03-06 13:33:12', '2020-01-14 07:59:58', 0, NULL, 'All the basics for businesses or individual to get started with email marketing'),
(3, '58bd48f92088f', NULL, 1, 'Standard', '250.00', '1', 'month', '{\"email_max\":\"100000\",\"list_max\":\"50\",\"subscriber_max\":\"50000\",\"subscriber_per_list_max\":\"-1\",\"segment_per_list_max\":\"3\",\"campaign_max\":\"40\",\"automation_max\":\"20\",\"billing_cycle\":\"monthly\",\"sending_limit\":\"10000_per_hour\",\"sending_quota\":1000,\"sending_quota_time\":1,\"sending_quota_time_unit\":\"hour\",\"max_process\":\"1\",\"all_sending_servers\":\"yes\",\"max_size_upload_total\":\"10000\",\"max_file_size_upload\":\"50\",\"unsubscribe_url_required\":\"yes\",\"access_when_offline\":\"no\",\"create_sending_domains\":\"no\",\"sending_servers_max\":\"-1\",\"sending_domains_max\":\"-1\",\"all_email_verification_servers\":\"yes\",\"create_email_verification_servers\":\"no\",\"email_verification_servers_max\":\"-1\",\"list_import\":\"yes\",\"list_export\":\"yes\",\"all_sending_server_types\":\"yes\",\"sending_server_types\":{\"amazon-smtp\":\"yes\",\"amazon-api\":\"yes\",\"sendgrid-smtp\":\"yes\",\"sendgrid-api\":\"yes\",\"mailgun-api\":\"yes\",\"mailgun-smtp\":\"yes\",\"elasticemail-api\":\"yes\",\"elasticemail-smtp\":\"yes\",\"sparkpost-api\":\"yes\",\"sparkpost-smtp\":\"yes\",\"smtp\":\"yes\",\"sendmail\":\"yes\",\"php-mail\":\"yes\"},\"sending_server_option\":\"system\",\"sending_server_subaccount_uid\":null,\"api_access\":\"yes\",\"email_footer_enabled\":\"yes\",\"email_footer_trial_period_only\":\"no\",\"html_footer\":\"\",\"plain_text_footer\":\"\",\"payment_gateway\":\"\"}', 'inactive', '#1482a0', 3, '2017-03-06 13:33:12', '2020-01-14 08:01:05', 0, NULL, 'Powerful statistics & insight report for maximized sales & marketing performance'),
(4, '58bd4b4d0d4c3', NULL, 1, 'Premium', '895.00', '1', 'month', '{\"email_max\":\"1000000\",\"list_max\":\"-1\",\"subscriber_max\":\"-1\",\"subscriber_per_list_max\":\"-1\",\"segment_per_list_max\":\"3\",\"campaign_max\":\"-1\",\"automation_max\":\"-1\",\"billing_cycle\":\"monthly\",\"sending_limit\":\"50000_per_hour\",\"sending_quota\":1000,\"sending_quota_time\":1,\"sending_quota_time_unit\":\"hour\",\"max_process\":\"1\",\"all_sending_servers\":\"yes\",\"max_size_upload_total\":\"50000\",\"max_file_size_upload\":\"100\",\"unsubscribe_url_required\":\"yes\",\"access_when_offline\":\"no\",\"create_sending_domains\":\"yes\",\"sending_servers_max\":\"5\",\"sending_domains_max\":\"-1\",\"all_email_verification_servers\":\"yes\",\"create_email_verification_servers\":\"no\",\"email_verification_servers_max\":\"-1\",\"list_import\":\"yes\",\"list_export\":\"yes\",\"all_sending_server_types\":\"yes\",\"sending_server_types\":{\"amazon-smtp\":\"yes\",\"amazon-api\":\"yes\",\"sendgrid-smtp\":\"yes\",\"sendgrid-api\":\"yes\",\"mailgun-api\":\"yes\",\"mailgun-smtp\":\"yes\",\"elasticemail-api\":\"yes\",\"elasticemail-smtp\":\"yes\",\"sparkpost-api\":\"yes\",\"sparkpost-smtp\":\"yes\",\"smtp\":\"yes\",\"sendmail\":\"yes\",\"php-mail\":\"yes\"},\"sending_server_option\":\"system\",\"sending_server_subaccount_uid\":null,\"api_access\":\"yes\",\"email_footer_enabled\":\"yes\",\"email_footer_trial_period_only\":\"no\",\"html_footer\":\"\",\"plain_text_footer\":\"\",\"payment_gateway\":\"\"}', 'inactive', '#aa5064', 4, '2017-03-06 13:43:09', '2020-01-14 08:01:32', 0, NULL, 'Advanced features for professionals who need unlimited marketing capability'),
(2, '5cf8e24978ede', NULL, 1, 'Essentials', '19.00', '1', 'month', '{\"email_max\":\"1000\",\"list_max\":\"2\",\"subscriber_max\":\"5000\",\"subscriber_per_list_max\":\"1000\",\"segment_per_list_max\":\"0\",\"campaign_max\":\"10\",\"automation_max\":\"10\",\"billing_cycle\":\"monthly\",\"sending_limit\":\"100_per_minute\",\"sending_quota\":100,\"sending_quota_time\":1,\"sending_quota_time_unit\":\"minute\",\"max_process\":\"1\",\"all_sending_servers\":\"yes\",\"max_size_upload_total\":\"200\",\"max_file_size_upload\":\"5\",\"unsubscribe_url_required\":\"yes\",\"access_when_offline\":\"no\",\"create_sending_domains\":\"yes\",\"sending_servers_max\":\"-1\",\"sending_domains_max\":\"-1\",\"all_email_verification_servers\":\"yes\",\"create_email_verification_servers\":\"no\",\"email_verification_servers_max\":\"-1\",\"list_import\":\"yes\",\"list_export\":\"yes\",\"all_sending_server_types\":\"yes\",\"sending_server_types\":{\"amazon-smtp\":\"yes\",\"amazon-api\":\"yes\",\"sendgrid-smtp\":\"yes\",\"sendgrid-api\":\"yes\",\"mailgun-api\":\"yes\",\"mailgun-smtp\":\"yes\",\"elasticemail-api\":\"yes\",\"elasticemail-smtp\":\"yes\",\"sparkpost-api\":\"yes\",\"sparkpost-smtp\":\"yes\",\"smtp\":\"yes\",\"sendmail\":\"yes\",\"php-mail\":\"yes\"},\"sending_server_option\":\"system\",\"sending_server_subaccount_uid\":null,\"api_access\":\"no\",\"email_footer_enabled\":\"yes\",\"email_footer_trial_period_only\":\"no\",\"html_footer\":\"\",\"plain_text_footer\":\"\",\"payment_gateway\":\"\"}', 'inactive', '', 2, '2019-06-05 19:52:09', '2020-01-14 08:00:12', 0, NULL, 'Must-have features for marketing agency & individual to engage in email marketing');

INSERT INTO `<<prefix>>payment_methods` (`uid`, `admin_id`, `name`, `type`, `options`, `status`, `custom_order`, `created_at`, `updated_at`) VALUES
('58bf6e250782f', NULL, 'Pay in Cash', 'cash', 'null', 'active', 0, '2017-03-08 02:36:21', '2017-03-08 02:56:29'),
('58bf724e9789b', NULL, 'Pay with PayPal', 'braintree_paypal', '{"environment":"production","merchantId":"","publicKey":"","privateKey":""}', 'inactive', 2, '2017-03-08 02:54:06', '2017-03-08 02:55:20'),
('58bf7298565d0', NULL, 'Pay by Credit Card', 'braintree_credit_card', '{"environment":"production","merchantId":"","publicKey":"","privateKey":""}', 'inactive', 3, '2017-03-08 02:55:20', '2017-03-08 02:56:37'),
('58f0a900c19d3', NULL, 'Pay by Credit Card', 'stripe_credit_card', '{"api_key":"pk_test_6pRNASCoBOKtIshFeQd4XMUh"}', 'inactive', 4, '2017-04-14 10:48:32', '2017-04-14 12:17:00'),
('581b52d8acdca', NULL, 'Pay with PayPal', 'paypal', NULL, 'inactive', 1, '2017-04-14 10:48:32', '2017-04-14 12:17:00');
