-- 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 `opportunities_cstm`
--
-- WHERE:  id_c IN (SELECT id FROM opportunities WHERE date_modified>='2024-06-28 00:00:00' AND date_modified<='2024-07-03 00:00:00')

LOCK TABLES `opportunities_cstm` WRITE;
/*!40000 ALTER TABLE `opportunities_cstm` DISABLE KEYS */;
REPLACE INTO `opportunities_cstm` (`id_c`, `expected_amount_c`, `rating_c`, `risks_c`, `strategy_c`, `authority_c`, `timeframe_c`, `budget_c`, `needs_c`, `close_plan_c`, `process_trigger_c`, `process_attributes_c`, `charge_amount_c`, `amount_charged_c`, `amount_remaining_c`, `amount_credited_c`, `progress_pc_c`) VALUES ('d5ce0fc2-34e1-11ef-9078-f9919171f80b',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=d5ce0fc2-34e1-11ef-9078-f9919171f80b','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('862bab66-34ee-11ef-9e1c-4124de7cb1eb',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=862bab66-34ee-11ef-9e1c-4124de7cb1eb','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('c7d13ec8-34f3-11ef-bb53-f512c445e988',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=c7d13ec8-34f3-11ef-bb53-f512c445e988','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('656ecca8-34f5-11ef-8cd8-ff0a29878c8f',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=656ecca8-34f5-11ef-8cd8-ff0a29878c8f','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('278e4ae4-374d-11ef-95bd-015b7d78564f',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=278e4ae4-374d-11ef-95bd-015b7d78564f','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('ca96e75a-3757-11ef-a05d-57588da09982',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=ca96e75a-3757-11ef-a05d-57588da09982','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('fab364de-3759-11ef-a426-636c4c00750e',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=fab364de-3759-11ef-a426-636c4c00750e','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('230a9736-375a-11ef-a534-69045c77ef03',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=230a9736-375a-11ef-a534-69045c77ef03','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('4a7e631a-375a-11ef-bca1-831d46db6481',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=4a7e631a-375a-11ef-bca1-831d46db6481','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('7c36e4b8-375a-11ef-aad8-758401045396',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=7c36e4b8-375a-11ef-aad8-758401045396','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('7ea102d2-375b-11ef-858f-11b31666191d',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=7ea102d2-375b-11ef-858f-11b31666191d','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('c92c186c-375d-11ef-8929-b13e5d7d8750',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=c92c186c-375d-11ef-8929-b13e5d7d8750','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('16608f32-375e-11ef-a0b7-51bd5aacea48',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=16608f32-375e-11ef-a0b7-51bd5aacea48','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('ed58ef48-375e-11ef-a9ce-ed2c6b309eec',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=ed58ef48-375e-11ef-a9ce-ed2c6b309eec','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('e0296d2e-375f-11ef-b4f8-d55703435a5b',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=e0296d2e-375f-11ef-b4f8-d55703435a5b','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL),('f7a1b350-3771-11ef-afd5-d1a566eabdb4',39.600000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Close Plan##@@@@##http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record=f7a1b350-3771-11ef-afd5-d1a566eabdb4','{}','{}',0.000000,0.000000,396.000000,0.000000,NULL);
/*!40000 ALTER TABLE `opportunities_cstm` 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:43
