-- 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`
--
-- WHERE:  date_modified>='2024-06-28 00:00:00' AND date_modified<='2024-07-03 00:00:00'

LOCK TABLES `opportunities` WRITE;
/*!40000 ALTER TABLE `opportunities` DISABLE KEYS */;
REPLACE INTO `opportunities` (`id`, `name`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `description`, `deleted`, `assigned_user_id`, `team_id`, `team_set_id`, `opportunity_type`, `campaign_id`, `lead_source`, `amount`, `base_rate`, `amount_usdollar`, `currency_id`, `date_closed`, `date_closed_timestamp`, `next_step`, `sales_stage`, `sales_status`, `probability`, `best_case`, `worst_case`, `commit_stage`, `mkto_sync`, `mkto_id`, `total_revenue_line_items`, `closed_revenue_line_items`, `included_revenue_line_items`, `acl_team_set_id`, `dri_workflow_template_id`, `renewal_parent_id`, `renewal`, `service_start_date`, `service_open_revenue_line_items`, `service_duration_value`, `service_duration_unit`, `service_open_flex_duration_rlis`, `sync_key`, `forecasted_likely`, `closed_won_revenue_line_items`, `ai_opp_conv_score_enum`, `is_escalated`, `denorm_account_name`) VALUES ('d5ce0fc2-34e1-11ef-9078-f9919171f80b','Centrelink Application','2024-06-28 00:03:22','2024-06-28 00:03:22','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Hesta - No 2FA'),('862bab66-34ee-11ef-9e1c-4124de7cb1eb','Centrelink Application','2024-06-28 01:34:12','2024-06-28 01:34:12','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Hesta - No 2FA'),('c7d13ec8-34f3-11ef-bb53-f512c445e988','Centrelink Application','2024-06-28 02:11:50','2024-06-28 02:11:50','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Hesta - No 2FA'),('656ecca8-34f5-11ef-8cd8-ff0a29878c8f','Centrelink Application','2024-06-28 02:23:24','2024-06-28 02:23:24','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Hesta - No 2FA'),('278e4ae4-374d-11ef-95bd-015b7d78564f','Centrelink Application','2024-07-01 01:56:38','2024-07-01 01:56:38','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Hesta - No 2FA'),('ca96e75a-3757-11ef-a05d-57588da09982','Centrelink Application','2024-07-01 03:12:46','2024-07-01 03:12:46','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Vanguard Investments Australia Ltd'),('fab364de-3759-11ef-a426-636c4c00750e','Centrelink Application','2024-07-01 03:28:26','2024-07-01 03:28:26','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Vanguard Investments Australia Ltd'),('230a9736-375a-11ef-a534-69045c77ef03','Centrelink Application','2024-07-01 03:29:34','2024-07-01 03:29:34','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Vanguard Investments Australia Ltd'),('4a7e631a-375a-11ef-bca1-831d46db6481','Centrelink Application','2024-07-01 03:30:40','2024-07-01 03:30:40','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Vanguard Investments Australia Ltd'),('7c36e4b8-375a-11ef-aad8-758401045396','Centrelink Application','2024-07-01 03:32:03','2024-07-01 03:32:03','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Vanguard Investments Australia Ltd'),('7ea102d2-375b-11ef-858f-11b31666191d','Centrelink Application','2024-07-01 03:39:17','2024-07-01 03:39:17','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Vanguard Investments Australia Ltd'),('c92c186c-375d-11ef-8929-b13e5d7d8750','Centrelink Application','2024-07-01 03:55:41','2024-07-01 03:55:41','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Hesta - No 2FA'),('16608f32-375e-11ef-a0b7-51bd5aacea48','Centrelink Application','2024-07-01 03:57:51','2024-07-01 03:57:51','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Hesta - No 2FA'),('ed58ef48-375e-11ef-a9ce-ed2c6b309eec','Centrelink Application','2024-07-01 04:03:51','2024-07-01 04:03:51','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Hesta - No 2FA'),('e0296d2e-375f-11ef-b4f8-d55703435a5b','Centrelink Application','2024-07-01 04:10:39','2024-07-01 04:10:39','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Vanguard Investments Australia Ltd'),('f7a1b350-3771-11ef-afd5-d1a566eabdb4','Centrelink Application','2024-07-01 06:20:09','2024-07-01 06:20:09','5bf30999-1fe2-472a-e454-526d8d46a4eb','5bf30999-1fe2-472a-e454-526d8d46a4eb',NULL,0,NULL,'1','f02fc0e6-6ce4-280b-9723-555ed56c9f0a','Age Pension Membership',NULL,NULL,396.000000,1.000000,396.000000,'-99',NULL,0,NULL,'Prospecting','New',10,396.000000,396.000000,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0.000000,0,NULL,0,'Hesta - No 2FA');
/*!40000 ALTER TABLE `opportunities` 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:42
