-- MySQL dump 10.13  Distrib 8.0.37, for Linux (aarch64)
--
-- Host: supered-db-7-cluster.cluster-ro-cxvt2c6kvtqo.ap-southeast-2.rds.amazonaws.com    Database: retirementessentials_uat_mrm_supered_com_au
-- ------------------------------------------------------
-- Server version	5.7.12-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping data for table `pm_processmanagerstagetask`
--

LOCK TABLES `pm_processmanagerstagetask` WRITE;
/*!40000 ALTER TABLE `pm_processmanagerstagetask` DISABLE KEYS */;
REPLACE INTO `pm_processmanagerstagetask` (`id`, `name`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `description`, `deleted`, `team_id`, `team_set_id`, `assigned_user_id`, `task_order`, `stage_id`, `email_template_defs_id`, `calls_defs_id`, `project_task_defs_id`, `task_defs_id`, `task_type`, `trigger_process_name`, `start_delay_type`, `custom_script`, `meetings_defs_id`) VALUES ('173766b1-56b6-0493-dc7d-4e36d21f587b','Modify Contact - call custom script','2011-08-01 16:21:39','2011-08-01 16:21:39','1','1','',0,NULL,NULL,'1',0,'null',NULL,NULL,NULL,NULL,'Custom Script','','--None--','customScript.php',NULL),('17e0dc34-2324-1288-7377-4e36ecc8c51f','New Opp - 4th Task','2011-08-01 18:12:07','2011-08-01 18:12:07','1','1','This is the 4th task on opp create',0,NULL,NULL,'1',4,'null',NULL,NULL,NULL,'2909c76a-339a-2d58-a03e-4e36ec58dc49','Create Task','','From Completion of Previous Task',NULL,NULL),('1bc31a6a-fe06-e480-f922-4e36cdb97e35','Close Opp - 4th month - Send Email','2011-08-01 15:58:36','2011-08-01 15:58:36','1','1','Close Opp - 4th month - Send Email',0,NULL,NULL,'1',0,NULL,'2a458f35-6641-4575-6bf6-4e36cd35d3bb',NULL,NULL,NULL,'Send Email','','--None--',NULL,NULL),('1f86fddc-0906-d397-7f92-543731443739','Send email','2014-10-10 12:06:42','2014-10-10 12:39:57','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','Send Email','','','',''),('23002dd8-64fc-23e8-1c4c-5439af3c0ed7','Create task record','2014-10-12 09:32:00','2014-10-13 09:43:03','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',1,'','','','','','Create New Record','','--None--','',''),('345a596e-fc22-1541-d0dd-4e36cc386b55','Closed Opps - 2  month delay - send email ','2011-08-01 15:54:44','2011-08-01 15:54:44','1','1','Closed Opps - 2  month delay - send email ',0,NULL,NULL,'1',0,NULL,'441503ca-1a08-30a3-3daa-4e36cc8b3d7f',NULL,NULL,NULL,'Send Email','','--None--',NULL,NULL),('3c93ed34-6349-0ca4-9260-4e36cc1620b9','Closed Opp - 2nd call','2011-08-01 15:55:17','2011-08-01 15:55:17','1','1','Closed Opp - 2nd call',0,NULL,NULL,'1',0,NULL,NULL,'4ba737bf-7998-c552-08d2-4e36cc7c6a1c',NULL,NULL,'Schedule Call','','Modify',NULL,NULL),('3c9c3c01-d8d3-7db9-988d-5439b3c10453','Send Email','2014-10-12 09:47:37','2014-10-12 09:56:09','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','Send Email','','','',''),('3c9dfe0e-18f3-d6a7-8f18-5439b38e5b4d','Create task record','2014-10-12 09:47:37','2014-10-12 09:56:09','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',1,'','','','','','Create New Record','','--None--','',''),('3f63796a-6883-c71b-7da1-5437536af49e','Create record','2014-10-10 14:34:31','2014-10-10 14:34:31','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','','','','',''),('44e60eb8-f2a0-19c5-481f-4e36cc4d9c53','Closed Opps - 3rd email','2011-08-01 15:56:33','2011-08-01 15:56:33','1','1','3rd Email sent three months after the close of an opportunity',0,NULL,NULL,'1',0,NULL,'55be0d29-3467-00d5-0936-4e36cc13923e',NULL,NULL,NULL,'Send Email','','--None--',NULL,NULL),('4fee07ea-cceb-5410-3415-4e36cb50b026','Closed Opp - 1 month call back','2011-08-01 15:50:50','2011-08-01 15:53:10','1','1','Call the new account one month after the opportunity has been closed.',0,NULL,NULL,'1',0,NULL,NULL,'c97eecb6-e06e-a98c-009e-4e36cb74df6d',NULL,NULL,'Schedule Call','','Modify',NULL,NULL),('651c91ed-e149-8bee-bc09-5439bb68efdb','Consolidate super','2014-10-12 10:25:15','2014-10-12 10:25:15','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',1,'','','','','','Create New Record','','--None--','',''),('702da42b-db8c-c77d-cb7f-5439a4b7ed2e','Send Email','2014-10-12 08:45:07','2014-10-13 09:43:03','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','Send Email','','','',''),('712111c6-33f9-4b6c-a30c-543768f82481','Send Consolidation Email','2014-10-10 16:03:07','2014-10-10 16:23:31','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','Send Email','','','',''),('725abb65-342b-6411-d516-543996fb5fe1','Send Email','2014-10-12 07:46:29','2014-10-12 08:48:37','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','Send Email','','','',''),('7dab1865-82da-45d1-7c85-54375cb40122','Create record','2014-10-10 15:12:28','2014-10-10 16:34:42','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',1,'','','','','','Create New Record','','--None--','',''),('809e56da-e0f8-c76c-35e1-543995454b9b','Send Contributions Email','2014-10-12 07:38:29','2014-10-12 07:47:21','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','Send Email','','','',''),('80bba492-4266-f426-506a-4e36cb888c35','Closed Opps - 1 month delay - send email','2011-08-01 15:49:44','2011-08-01 15:49:44','1','1','One month after an opportunity is closed - send the first in a series of emails.',0,NULL,NULL,'1',0,NULL,'95c9b8d2-3d8e-a3b3-55df-4e36cb30f6bd',NULL,NULL,NULL,'Send Email','','--None--',NULL,NULL),('83aecee1-6c45-c28b-51c4-543995f9607c','Send Contributions Email','2014-10-12 07:40:45','2014-10-12 07:40:45','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','Send Email','','','',''),('8b59c777-bfcb-fa9c-e039-4e36c7222773','New Lead - 1st Email','2011-08-01 15:32:23','2011-08-01 15:32:23','1','1','',0,NULL,NULL,'1',0,NULL,'9ca479c2-90a0-81f0-761c-4e36c7fa59e5',NULL,NULL,NULL,'Send Email','','--None--',NULL,NULL),('91679df1-b9f6-69fd-6410-4e36e53b3071','Old Lead - Create Task','2011-08-01 17:42:20','2011-08-01 17:42:20','1','1','Old Lead - Create Task',0,NULL,NULL,'1',0,NULL,NULL,NULL,NULL,'a36c052a-5cdf-ab82-3301-4e36e51f6fe7','Create Task','','--None--',NULL,NULL),('95c4ea9c-0287-9e75-d90a-4e36eb02ccb1','Opps due to close this week','2011-08-01 18:06:49','2011-08-01 18:06:49','1','1','Opps due to close this week',0,NULL,NULL,'1',0,NULL,NULL,NULL,NULL,'a671ee17-284f-1c09-c1fe-4e36eb2b0ade','Create Task','','Modify',NULL,NULL),('98d2a19b-4d91-6a6c-6b40-5437281e43fb','Send email','2014-10-10 11:30:19','2014-10-10 11:30:19','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','Send Email','','','',''),('a097049e-4aec-38ac-18c7-54376fe0fa01','Create record','2014-10-10 16:33:58','2014-10-10 16:52:09','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',1,'','','','','','Create New Record','','--None--','',''),('a2b4e2ad-6424-963c-17c7-54363b7a1154','Send email','2014-10-09 18:43:47','2014-10-10 10:33:50','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','Send Email','','','',''),('a3d017fb-f031-d004-5bfa-4e36c7b7c803','New Lead - 1st Call','2011-08-01 15:32:51','2011-08-01 15:32:51','1','1','New Lead - 1st Call',0,NULL,NULL,'1',0,NULL,NULL,'b3bb578e-9615-ccf7-2cda-4e36c7c4cdce',NULL,NULL,'Schedule Call','','Create',NULL,NULL),('a57ab129-8df9-1b1f-ca59-4e36c7db8606','New Lead - 3rd Email','2011-08-01 15:34:29','2011-08-01 15:34:29','1','1','New Lead - 3rd Email',0,NULL,NULL,'1',0,NULL,'b4eb2270-4e05-5c21-186d-4e36c75b3ba1',NULL,NULL,NULL,'Send Email','','--None--',NULL,NULL),('a59dbd92-faab-fd2b-3725-5439bdb1ff8e','Create task','2014-10-12 10:33:14','2014-10-13 09:42:45','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',1,'','','','','','Create New Record','','--None--','',''),('aa1f090a-acfc-0dbb-e97e-5437655e4816','Create Consolidate Super taks','2014-10-10 15:50:29','2014-10-10 16:23:31','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',1,'','','','','','Create New Record','','--None--','',''),('ab3d0c1e-dfde-5037-52a5-54373b40d468','Send','2014-10-10 12:53:44','2014-10-10 14:28:13','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','Send Email','','','',''),('c39e709b-cb7a-5f01-809e-543774bb5dcc','Create task record','2014-10-10 16:54:06','2014-10-12 07:40:27','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',1,'','','','','','Create New Record','','--None--','',''),('c5482b0a-71e9-8b9f-38bc-4e36cd741bf5','Closed Case - follow up call','2011-08-01 16:01:24','2011-08-01 16:01:24','1','1','Closed Cases - follow up call. Call the customer and make sure all is well with their issue.',0,NULL,NULL,'1',0,NULL,NULL,'d53bfe53-264d-e42d-f2f2-4e36cd632f27',NULL,NULL,'Schedule Call','','Modify',NULL,NULL),('c707c07a-2244-5d96-c570-4e36c7efe008','New Lead - 3rd Call','2011-08-01 15:34:56','2011-08-01 15:34:56','1','1','New Lead - 3rd Call',0,NULL,NULL,'1',0,NULL,NULL,'d6738850-fd57-921d-66c2-4e36c78358f7',NULL,NULL,'Schedule Call','','Create',NULL,NULL),('cbdf0476-9143-9efa-da84-5437533970cc','Create record','2014-10-10 14:38:58','2014-10-10 14:54:23','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',1,'','','','','','Create New Record','','--None--','',''),('cd99262a-29ce-f8b0-c73d-54371ade24d5','Create Notes record','2014-10-10 10:33:50','2014-10-10 10:33:50','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','Create New Record','','','',''),('d643c44e-7bc3-a02f-8243-4e36c76ac65d','New Lead - 2nd Email','2011-08-01 15:33:26','2011-08-01 15:33:26','1','1','New Lead - 2nd Email',0,NULL,NULL,'1',0,NULL,'e62ad146-0c87-1bac-f0f5-4e36c7a82de6',NULL,NULL,NULL,'Send Email','','--None--',NULL,NULL),('d7134304-a948-c392-35e0-4e36e60as23w','Route CA Leads','2011-08-01 17:47:42','2011-08-01 17:47:42','1','1','Route CA Leads',0,NULL,NULL,'1',0,NULL,NULL,NULL,NULL,NULL,'Route Object','','--None--',NULL,NULL),('d7134304-a948-c392-35e0-4e36e60c9dde','Close Opp - Create New One 1 year later','2011-08-01 17:47:42','2011-08-01 17:47:42','1','1','Close Opp - Create New One 1 year later',0,NULL,NULL,'1',0,NULL,NULL,NULL,NULL,NULL,'Create New Record','','--None--',NULL,NULL),('d813d1f0-5df4-ded2-ef0d-5439bf8d62bf','Send email','2014-10-12 10:39:06','2014-10-13 09:42:45','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',0,'','','','','','Send Email','','','',''),('d8f265b1-d8bd-1dd0-dd9d-4e36cde95fa6','Closed Opp - 3rd month - create task','2011-08-01 15:57:56','2011-08-01 15:57:56','1','1','This process task will be to create a Sugar task for the owner of the opp to send the monthly newsletter to the account.',0,NULL,NULL,'1',0,NULL,NULL,NULL,NULL,'ea4ccf3a-238d-0ba9-b786-4e36cd5f4f45','Create Task','','Modify',NULL,NULL),('d9110459-9a01-0f03-b466-4e36ec8bf225','New Opp - 3rd Task in Series','2011-08-01 18:11:35','2011-08-01 18:11:35','1','1','This is the third task on opp create',0,NULL,NULL,'1',3,NULL,NULL,NULL,NULL,'e7f4b82c-fe96-1af7-1c92-4e36ecf05968','Create Task','','From Completion of Previous Task',NULL,NULL),('dd8652ad-9375-7ca3-f1c7-4e36ece7ab16','New Opp - First Task in the series','2011-08-01 18:10:12','2011-08-01 18:10:12','1','1','This is the first task on Opp Create',0,NULL,NULL,'1',1,NULL,NULL,NULL,NULL,'ed9666c9-3021-db2a-20a6-4e36ec18db45','Create Task','','Create',NULL,NULL),('e585f274-88cf-6884-ae66-4e36c7325277','New Lead - 2nd Call','2011-08-01 15:33:52','2011-08-01 15:33:52','1','1','New Lead - 2nd Call',0,NULL,NULL,'1',0,NULL,NULL,'56c307a0-cfb2-f504-9557-4e36c72a1231',NULL,NULL,'Schedule Call','','Create',NULL,NULL),('e6a4e6bd-352c-570d-d5f8-54376d6550fe','Create Task record','2014-10-10 16:23:53','2014-10-10 16:31:28','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff','',0,'1','1','87ae1c65-ce10-9ea5-2f4b-53f2a130e1ff',1,'','','','','','Create New Record','','--None--','',''),('e6bbf41d-fe83-b15f-e215-4e36ec225ab2','New Opp - 2nd Task in Series','2011-08-01 18:11:00','2011-08-01 18:11:00','1','1','This is the second task on opp create',0,NULL,NULL,'1',2,NULL,NULL,NULL,NULL,'342c0fd2-4a3f-4892-8666-4e36ec6f337b','Create Task','','From Completion of Previous Task',NULL,NULL),('e90e6546-5115-05e5-0810-4e36c8f392dc','Daily Birthday Campaign - Send Email','2011-08-01 15:37:55','2011-08-01 15:37:55','1','1','',0,NULL,NULL,'1',0,NULL,'71f40309-0225-7987-4639-4e36c8b410fa',NULL,NULL,NULL,'Send Email','','--None--',NULL,NULL),('fd2008be-92a8-80db-509e-4e36cb44a549','Closed Opp - 1 month call back','2011-08-01 15:51:09','2011-08-01 15:51:09','1','1','Call the new account one month after the opportunity has been closed.',0,NULL,NULL,'1',0,NULL,NULL,NULL,NULL,NULL,'Schedule Call','','Modify',NULL,NULL);
/*!40000 ALTER TABLE `pm_processmanagerstagetask` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-07-02 15:00:45
