--
-- Host: mrm-uat-proxy.proxy-cxvt2c6kvtqo.ap-southeast-2.rds.amazonaws.com    Database: dev_mrm_supered_com_au
-- ------------------------------------------------------


--
-- Table structure for table `outbound_email`
--

CREATE TABLE `outbound_email` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'user',
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `mail_sendtype` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'SMTP',
  `mail_smtptype` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'other',
  `mail_smtpserver` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mail_smtpport` int DEFAULT '0',
  `mail_smtpuser` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mail_smtppass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mail_smtpauth_req` tinyint(1) DEFAULT '0',
  `mail_smtpssl` int DEFAULT '0',
  `email_address_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT '0',
  `reply_to_email_address_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reply_to_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `team_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `team_set_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `acl_team_set_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eapm_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `authorized_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mail_authtype` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `preferred_sending_account` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_outbound_email_tmst_id` (`team_set_id`,`deleted`),
  KEY `idx_outbound_email_acl_tmst_id` (`acl_team_set_id`,`deleted`),
  KEY `oe_type_idx` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `outbound_email`
--

INSERT INTO `outbound_email` VALUES ('01ac571e-e2fe-11ea-b5aa-06fdd77df510','Vijay Nagarajan','system-override','1e8ae350-cd5f-11ea-ae4b-06fdd77df510','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,NULL,NULL,1,2,'1f286138-e5ec-11eb-9765-06fdd77df510',2,NULL,NULL,'1e9b0f8c-cd5f-11ea-89d4-06fdd77df510','1e9b0f8c-cd5f-11ea-89d4-06fdd77df510',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('1274c347-73f2-de21-7344-5551ca23eb1b','system','system-override','94b2e076-8192-27d4-da5c-5472bda703aa','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'a9e55a8d-a055-16c8-cbe6-5472bd4027b5','a9e55a8d-a055-16c8-cbe6-5472bd4027b5',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('14e4f6a5-e1cf-5e5c-3a9e-537ec981c7f5','system','system-override','4255588b-f1cc-93b8-fb92-531e80fb2bf3','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'35ccf36e-12d3-b77e-c6c8-555185bad82e','35ccf36e-12d3-b77e-c6c8-555185bad82e',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('18405858-851e-11ed-bdba-93c99cff750b','Nivedita CSR - RE Upgrade','user','95161d7c-6f11-11ed-b496-3f1c146a6de2','SMTP','google','smtp.gmail.com',587,'re.upgrade.mrm@gmail.com','AVsBr5+da9aDfsu8QI9qZg==',1,2,'955ba324-6f11-11ed-ba55-d3ab43f642e4',1,'7dcb41e2-850f-11ed-878d-87ab48b61551',NULL,'952eb134-6f11-11ed-b2eb-698115660a65','952eb134-6f11-11ed-b2eb-698115660a65',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('21740b28-38fe-11ef-833d-e5055d9f68d2','MRM Admin','system-override','1','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'AKIA2IRYZFGT4PZZD2G3','NgQ1jodNfb6hRVWJYidQB2sqRM6C8QBHvRzVmI2h6sQQE+pisn8oUgrl0Zo4+uQ/j1M0dVKgh+o=',1,2,'e06d1210-f155-11ec-952a-a5acfa66f1f5',0,NULL,NULL,'93a74f8d-5827-8424-061b-5323084d03a3','93a74f8d-5827-8424-061b-5323084d03a3',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('2457a679-47c8-f081-1dcd-536068d4c7da','system','system-override','3e3aa85c-ab7d-908d-6a56-536067270b5a','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'a87df0b9-8f3c-d12b-5697-536067d7a3e4','a87df0b9-8f3c-d12b-5697-536067d7a3e4',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('2505fd7e-d723-b78d-30f2-536837381c8b','system','system-override','2b7b86be-0501-5b2d-da70-536837f93eb5','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'58cb4f76-209c-adaf-edfd-536837360107','58cb4f76-209c-adaf-edfd-536837360107',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('2c14bec0-e339-11ea-9d4b-06fdd77df510','Retirement Essentials','user','b89adde0-99cc-11ea-9f17-06fdd77df510','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'AKIA2IRYZFGT3RJ44VZF','bVIwpC8fKTUGkIt1QXaLOawoqImhzmsaczChE7Ow6N5leHOZTtWqhleuD+ecgu+g',1,2,'34c9e783-017e-9cae-3ed7-510284a33247',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('322beafe-98b3-11ed-bb8d-f92ada13d973','Test Re-Upgrade-2-MRM','user','a96d88a0-66dd-11ed-8a50-29935aae3f7f','SMTP','other','smtp.mailtrap.io',587,'ec670c75b20097','',1,2,'a978db74-66dd-11ed-9302-b11003cd3c3b',1,NULL,'Test Re-Upgrade-2-MRM','1','1',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('3dba8c6a-5d43-11ec-a1b3-06fdd77df510','Retirement Essentials','user','1c84509c-5ba6-11ec-b871-06fdd77df510','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'AKIA2IRYZFGT3RJ44VZF','bVIwpC8fKTUGkIt1QXaLOawoqImhzmsaczChE7Ow6N5leHOZTtWqhleuD+ecgu+g',1,2,'4e516ef4-2bf1-11e8-8072-069940e16132',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('42d55708-851e-11ed-9fe2-ebbe63d2a654','MRM Admin - RE Upgrade','user','1','SMTP','google','smtp.gmail.com',587,'re.upgrade.mrm@gmail.com','AVsBr5+da9aDfsu8QI9qZg==',1,2,'e06d1210-f155-11ec-952a-a5acfa66f1f5',1,'7dcb41e2-850f-11ed-878d-87ab48b61551','RE Upgrade','93a74f8d-5827-8424-061b-5323084d03a3','93a74f8d-5827-8424-061b-5323084d03a3',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('439e3ae2-d438-11ed-be9d-ef831f78f6f2','MRM Admin','system-override','1','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'AKIA2IRYZFGT4PZZD2G3','NgQ1jodNfb6hRVWJYidQB2sqRM6C8QBHvRzVmI2h6sQQE+pisn8oUgrl0Zo4+uQ/j1M0dVKgh+o=',1,2,'e06d1210-f155-11ec-952a-a5acfa66f1f5',9,NULL,NULL,'93a74f8d-5827-8424-061b-5323084d03a3','93a74f8d-5827-8424-061b-5323084d03a3',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('48bd23d2-136e-11ef-a8a8-09b5359fd1a4','MRM Admin','system-override','1','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'AKIA2IRYZFGT4PZZD2G3','NgQ1jodNfb6hRVWJYidQB2sqRM6C8QBHvRzVmI2h6sQQE+pisn8oUgrl0Zo4+uQ/j1M0dVKgh+o=',1,2,'e06d1210-f155-11ec-952a-a5acfa66f1f5',0,NULL,NULL,'93a74f8d-5827-8424-061b-5323084d03a3','93a74f8d-5827-8424-061b-5323084d03a3',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('59e4d849-80b3-2981-ed03-53fff468d5bf','system','system-override','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'96b6dbf8-20e4-904e-d9a3-53f2a10bd286','96b6dbf8-20e4-904e-d9a3-53f2a10bd286',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('685f2629-6592-5863-2635-537da1f9909a','Web Portal','system-override','5bf30999-1fe2-472a-e454-526d8d46a4eb','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,NULL,NULL,1,2,'627c4a29-a3a6-cbed-ab07-5356145238fa',2,NULL,NULL,'4cf1ea6b-0521-f679-0dac-5551854a9128','4cf1ea6b-0521-f679-0dac-5551854a9128',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('71b15f8e-a0e1-5bb1-8c53-56b2cb80742a','Alexandre Prate','system-override','160cf834-0a0d-fb26-ef4d-531e805aabab','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,NULL,NULL,1,2,'1d42dff9-6562-7744-010a-531e804b0b02',2,NULL,NULL,'1de83b91-a2ea-7338-8b41-555185ab0232','1de83b91-a2ea-7338-8b41-555185ab0232',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('756897c5-eb68-f638-8e02-563ad2bebb98','system','system-override','94be6038-4392-711d-b22d-55e797ef952e','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'e803cfa3-2d08-e75a-2f13-55e797ab722b','e803cfa3-2d08-e75a-2f13-55e797ab722b',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('76bce2ec-5058-2a10-6674-53e4cd342f78','Loaded Support','system-override','26402598-50be-ec49-1490-51028469b0e9','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,NULL,NULL,1,2,'e5b490e4-db88-eda5-6004-5369d9d199a2',2,NULL,NULL,'2b4946e1-a3c6-2ab4-0e67-5551850ae464','2b4946e1-a3c6-2ab4-0e67-5551850ae464',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('77df3d0e-0445-e5eb-8ef5-532308177b28','MRM Admin','system-override','1','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'AKIA2IRYZFGT4PZZD2G3','NgQ1jodNfb6hRVWJYidQB2sqRM6C8QBHvRzVmI2h6sQQE+pisn8oUgrl0Zo4+uQ/j1M0dVKgh+o=',1,2,'447b1346-b74d-11ea-bf19-06fdd77df510',2,NULL,NULL,'93a74f8d-5827-8424-061b-5323084d03a3','93a74f8d-5827-8424-061b-5323084d03a3',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('7ccd53a6-2c4f-98d5-b3d7-584a18059048','Justin Lew','system-override','6625f082-60b4-af8c-9805-58410f759379','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,NULL,NULL,1,2,'7669eb0c-7370-b149-4347-58410fac53c4',2,NULL,NULL,'7c55f632-9be3-2765-b28f-58410f5c638a','7c55f632-9be3-2765-b28f-58410f5c638a',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('7dd9ea3c-bbf2-11ea-8094-06fdd77df510','Vijay Nagarajan_old','system-override','3dba95ee-aa1f-11ea-8ed6-06fdd77df510','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,NULL,NULL,1,2,'7664c5d4-c01a-11ea-9be1-06fdd77df510',2,NULL,NULL,'3dc2f4c8-aa1f-11ea-8ecc-06fdd77df510','3dc2f4c8-aa1f-11ea-8ecc-06fdd77df510',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('801a562a-8fd4-11ed-b246-3f89a8f1aa1e','RE Upgrade Test','user','043e917c-4df3-11ea-b19b-06fdd77df510','SMTP','google','smtp.gmail.com',587,'re.upgrade.mrm@gmail.com','',1,2,'7dcb41e2-850f-11ed-878d-87ab48b61551',1,'7dcb41e2-850f-11ed-878d-87ab48b61551','RE Upgrade Test','1','1',NULL,NULL,NULL,NULL,1);
INSERT INTO `outbound_email` VALUES ('8aaf824a-9b0a-11ed-95b5-fff8b1114d20','Retirement Essentials','user','39ee1bce-3330-11ed-b6ba-ed9f7e5549f5','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'AKIA2IRYZFGT3RJ44VZF','bVIwpC8fKTUGkIt1QXaLOawoqImhzmsaczChE7Ow6N5leHOZTtWqhleuD+ecgu+g',1,2,'447b1346-b74d-11ea-bf19-06fdd77df510',0,'447b1346-b74d-11ea-bf19-06fdd77df510','Retirement Essentials','1','1',NULL,NULL,NULL,NULL,1);
INSERT INTO `outbound_email` VALUES ('8e093e6c-cb9e-b58d-111f-5369efeebdb3','Hugh Morrow','system-override','56b26ecb-8bda-3fbd-00d6-50c9af4ac5a5','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,NULL,'',1,2,'78f5e6c4-9bea-872e-dce8-50c9af4eed2d',2,NULL,NULL,'4334033a-8a8a-873c-4c77-555185fe70cd','4334033a-8a8a-873c-4c77-555185fe70cd',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('8f4b0d74-68ac-63c3-6555-5874573369bb','system','system-override','bf48d2a9-eaa1-52c4-6026-524a08b19040','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'a121f743-a540-dbff-76e8-5551854c2d08','a121f743-a540-dbff-76e8-5551854c2d08',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('929c71bf-e87c-c64c-9a07-53634aedb66b','system','system-override','d4b70cfc-51f6-bd9d-d475-5363446c4726','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'f266f050-27c8-f671-0aa0-5363446c0dd9','f266f050-27c8-f671-0aa0-5363446c0dd9',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('9ba28932-cf50-5786-0451-566776101840','system','system-override','94e412d1-ce43-653c-da2d-54d19a0bad53','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'ca125823-510c-afe8-575d-54d19ab78893','ca125823-510c-afe8-575d-54d19ab78893',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('9d241d0b-c45d-d9bc-5018-56bd4ddf759f','Mikhail Tupitsyn','system-override','af5144b0-eb88-8e04-a182-569859ee1769','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,NULL,NULL,1,2,'cac70b24-fc87-ac31-a3a6-5692de5d36ad',2,NULL,NULL,'bfe5195f-251b-54ed-568c-569859291678','bfe5195f-251b-54ed-568c-569859291678',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('ab0b759a-9e15-11ed-aa2e-6b2a961e9cc3','MRM Admin','system-override','1','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'AKIA2IRYZFGT4PZZD2G3','NgQ1jodNfb6hRVWJYidQB2sqRM6C8QBHvRzVmI2h6sQQE+pisn8oUgrl0Zo4+uQ/j1M0dVKgh+o=',1,2,'34c9e783-017e-9cae-3ed7-510284a33247',9,'447b1346-b74d-11ea-bf19-06fdd77df510','Retirement Essentials','93a74f8d-5827-8424-061b-5323084d03a3','93a74f8d-5827-8424-061b-5323084d03a3',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('ad76d426-252e-c448-1757-536ab727fb2a','system','system-override','766c2859-e84e-368b-0da8-51fba4e45c7f','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'52f57fb6-f362-9adb-32f8-555185aedc2d','52f57fb6-f362-9adb-32f8-555185aedc2d',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('b7e7f4f3-03b5-1696-c67f-53eaae98f388','system','system-override','1a449430-5c7e-5406-dd04-53e47809c802','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'2d83c53e-f2a7-d283-2587-53e478b21108','2d83c53e-f2a7-d283-2587-53e478b21108',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('c19906a0-b5f8-4c84-0622-536af7ac29c0','system','system-override','e1eeb8b1-f4fe-f904-c7c6-51fba449dc1a','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'bb9df2d0-95af-1c80-48a4-555185b7b23f','bb9df2d0-95af-1c80-48a4-555185b7b23f',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('c2f99a6b-92be-c96d-f42f-535ded51c4ec','system','system-override','8eb199dd-00f4-71e4-af94-535de04b472a','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'c816899c-b56d-80df-bbd9-535de084781c','c816899c-b56d-80df-bbd9-535de084781c',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('c6ea9144-44d3-11eb-ab37-06fdd77df510','Hugh Morrow','user','56b26ecb-8bda-3fbd-00d6-50c9af4ac5a5','SMTP','google','smtp.gmail.com',587,'Hugh.morrow@supered.com.au','o3nAqskKSLO7brkrcSM0tg==',1,2,'835e60a6-3a9f-2d39-6f04-536067bd6e11',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('cbaf9688-cf38-11ed-951e-b7eddcd6329b','DEV MRM','system','1','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'AKIA2IRYZFGT4PZZD2G3','DSgNBbjSMQUzuSSTny3pUd2NXS/do89MWqekXREaNcBKksvSSYeu5g==',1,2,'34c9e783-017e-9cae-3ed7-510284a33247',0,NULL,NULL,'1','1',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('d6895099-f4e2-530e-25c0-589958271cb4','system','system-override','a4ea485c-52c2-bff9-3665-5897f98585e6','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'b97d4a66-080b-895d-9a80-5897f94bc822','b97d4a66-080b-895d-9a80-5897f94bc822',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('d91cf174-78d1-5ebc-dedb-535f20c3713d','system','system-override','f195fbf0-4924-fc5c-a364-535ddf2996a7','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,'42150611-b623-b921-76aa-535ddf77409d','42150611-b623-b921-76aa-535ddf77409d',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('da4af370-9245-11ed-a694-937c6a5d8e1c','Nivedita CSR - RE Upgrade','user','76e975ce-66dd-11ed-b9ff-1b3f43ea39a6','SMTP','google','smtp.gmail.com',587,'re.upgrade.mrm@gmail.com','AVsBr5+da9aDfsu8QI9qZg==',1,2,'955ba324-6f11-11ed-ba55-d3ab43f642e4',1,'7dcb41e2-850f-11ed-878d-87ab48b61551',NULL,'952eb134-6f11-11ed-b2eb-698115660a65','dbb32d40-9245-11ed-a17d-732c01480f2d',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('e3cb3bf1-5495-9772-6900-535615a6f008','system','system-override','ef418465-b7bd-3e34-b8bf-535614a49c94','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'','',1,2,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('f9f27a1e-86c5-11eb-a30f-06fdd77df510','Retirement Essentials','user','57169146-82fa-11eb-8059-06fdd77df510','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'AKIA2IRYZFGT3RJ44VZF','bVIwpC8fKTUGkIt1QXaLOawoqImhzmsaczChE7Ow6N5leHOZTtWqhleuD+ecgu+g',1,2,'34c9e783-017e-9cae-3ed7-510284a33247',1,NULL,NULL,'1','1',NULL,NULL,NULL,NULL,0);
INSERT INTO `outbound_email` VALUES ('ffffffff-7d6d-c5a5-c679-532308387711','MRM Admin','system','1','SMTP','other','email-smtp.ap-southeast-2.amazonaws.com',587,'AKIA2IRYZFGT3RJ44VZF','bVIwpC8fKTUGkIt1QXaLOawoqImhzmsaczChE7Ow6N5leHOZTtWqhleuD+ecgu+g',1,2,'34c9e783-017e-9cae-3ed7-510284a33247',9,'447b1346-b74d-11ea-bf19-06fdd77df510','Retirement Essentials','1','1',NULL,NULL,NULL,NULL,0);


