(1171,NULL,NULL,NULL,4689,2979,2198,'2023-05-24 17:47:05',NULL,'','','','','',404,'http://news.gelamor.de/old','https://news.gelamor.com/old',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','zk6058jnviyrur6fr0m12nm',NULL,NULL,'a:1:{s:8:\"page_url\";s:28:\"https://news.gelamor.com/old\";}'),(1172,NULL,NULL,NULL,4690,2979,2199,'2023-05-24 17:47:06',NULL,'','','','','',404,'http://news.gelamor.com/new','https://news.gelamor.com/new',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','floexaqs11g9pacx5nmjlua',NULL,NULL,'a:1:{s:8:\"page_url\";s:28:\"https://news.gelamor.com/new\";}'),(1173,NULL,NULL,NULL,4691,2979,2200,'2023-05-24 17:47:07',NULL,'','','','','',404,'http://news.gelamor.de/new','https://news.gelamor.com/new',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','mueo91zqj2toy7zdwpe2aou',NULL,NULL,'a:1:{s:8:\"page_url\";s:28:\"https://news.gelamor.com/new\";}'),(1174,NULL,NULL,NULL,4692,2979,2201,'2023-05-24 17:47:09',NULL,'','','','','',404,'http://news.gelamor.com/main','https://news.gelamor.com/main',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','viq78oup8ghwv6tqu98bkss',NULL,NULL,'a:1:{s:8:\"page_url\";s:29:\"https://news.gelamor.com/main\";}'),(1175,NULL,NULL,NULL,4693,2979,2202,'2023-05-24 17:47:09',NULL,'','','','','',404,'http://news.gelamor.de/main','https://news.gelamor.com/main',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','bjcpjszbm6pfm9tnwrjer5m',NULL,NULL,'a:1:{s:8:\"page_url\";s:29:\"https://news.gelamor.com/main\";}'),(1176,NULL,NULL,NULL,4694,2979,2203,'2023-05-24 17:47:11',NULL,'','','','','',404,'http://news.gelamor.de/home','https://news.gelamor.com/home',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','tkv6i8bf7e03wrnh3xu83f8',NULL,NULL,'a:1:{s:8:\"page_url\";s:29:\"https://news.gelamor.com/home\";}'),(1177,NULL,NULL,NULL,4695,2979,2204,'2023-05-24 17:47:11',NULL,'','','','','',404,'http://news.gelamor.com/home','https://news.gelamor.com/home',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','6nzrfzp66phyqp7pp12pwgy',NULL,NULL,'a:1:{s:8:\"page_url\";s:29:\"https://news.gelamor.com/home\";}'),(1178,NULL,NULL,NULL,4696,2968,2206,'2023-05-28 15:32:42',NULL,'','','','','',404,'https://news.gelamor.com/_ignition/health-check/','https://news.gelamor.com/_ignition/health-check',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36',NULL,NULL,'a:2:{i:0;s:5:\"en-US\";i:1;s:8:\"en;q=0.9\";}','kir3mjxbmt702q4tuqbenvv',NULL,NULL,'a:1:{s:8:\"page_url\";s:47:\"https://news.gelamor.com/_ignition/health-check\";}'),(1179,NULL,NULL,NULL,4697,2968,2207,'2023-05-28 15:32:46',NULL,'','','','','',404,'https://news.gelamor.com/public/_ignition/health-check/','https://news.gelamor.com/public/_ignition/health-check',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36',NULL,NULL,'a:2:{i:0;s:5:\"en-US\";i:1;s:8:\"en;q=0.9\";}','7p2h5h3nuiz46jvcnsvoqsg',NULL,NULL,'a:1:{s:8:\"page_url\";s:54:\"https://news.gelamor.com/public/_ignition/health-check\";}'),(1180,NULL,NULL,NULL,4698,2968,2208,'2023-05-28 15:32:48',NULL,'','','','','',404,'http://news.gelamor.com/wp-includes/wlwmanifest.xml','https://news.gelamor.com/wp-includes/wlwmanifest.xml',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36',NULL,NULL,'a:2:{i:0;s:5:\"en-US\";i:1;s:8:\"en;q=0.9\";}','o05rqi9vew1praocx2roprb',NULL,NULL,'a:1:{s:8:\"page_url\";s:52:\"https://news.gelamor.com/wp-includes/wlwmanifest.xml\";}'),(1181,NULL,NULL,NULL,4699,3565,2209,'2023-05-30 19:38:27',NULL,'','','','','',404,'http://news.gelamor.com/wordpress','https://news.gelamor.com/wordpress',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','sl53xwbda2xaztbmh2dq3it',NULL,NULL,'a:1:{s:8:\"page_url\";s:34:\"https://news.gelamor.com/wordpress\";}'),(1182,NULL,NULL,NULL,4700,3566,2210,'2023-05-30 19:38:27',NULL,'','','','','',404,'http://news.gelamor.de/wordpress','https://news.gelamor.com/wordpress',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','whi92nc03t06q8jge7srqec',NULL,NULL,'a:1:{s:8:\"page_url\";s:34:\"https://news.gelamor.com/wordpress\";}'),(1183,NULL,NULL,NULL,4701,3565,2211,'2023-05-30 19:38:31',NULL,'','','','','',404,'http://news.gelamor.de/wp','https://news.gelamor.com/wp',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','e92br51zr7a5hy6k4junzaf',NULL,NULL,'a:1:{s:8:\"page_url\";s:27:\"https://news.gelamor.com/wp\";}'),(1184,NULL,NULL,NULL,4702,3565,2212,'2023-05-30 19:38:31',NULL,'','','','','',404,'http://news.gelamor.com/wp','https://news.gelamor.com/wp',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','lp1ir4dyjsopuo1tvwrmjjv',NULL,NULL,'a:1:{s:8:\"page_url\";s:27:\"https://news.gelamor.com/wp\";}'),(1185,NULL,NULL,NULL,4703,3565,2213,'2023-05-30 19:38:33',NULL,'','','','','',404,'http://news.gelamor.de/bc','https://news.gelamor.com/bc',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','0p3sw9vxyk29mlvj4u36c1i',NULL,NULL,'a:1:{s:8:\"page_url\";s:27:\"https://news.gelamor.com/bc\";}'),(1186,NULL,NULL,NULL,4704,3565,2214,'2023-05-30 19:38:33',NULL,'','','','','',404,'http://news.gelamor.com/bc','https://news.gelamor.com/bc',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','d6wam0jhoyh3wqe7jkptt37',NULL,NULL,'a:1:{s:8:\"page_url\";s:27:\"https://news.gelamor.com/bc\";}'),(1187,NULL,NULL,NULL,4705,3565,2215,'2023-05-30 19:38:34',NULL,'','','','','',404,'http://news.gelamor.de/bk','https://news.gelamor.com/bk',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','nc5obodgcnyui3midwotwyw',NULL,NULL,'a:1:{s:8:\"page_url\";s:27:\"https://news.gelamor.com/bk\";}'),(1188,NULL,NULL,NULL,4706,3565,2216,'2023-05-30 19:38:34',NULL,'','','','','',404,'http://news.gelamor.com/bk','https://news.gelamor.com/bk',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','b3ajwuov40mhckr30i39949',NULL,NULL,'a:1:{s:8:\"page_url\";s:27:\"https://news.gelamor.com/bk\";}'),(1189,NULL,NULL,NULL,4707,3565,2217,'2023-05-30 19:38:36',NULL,'','','','','',404,'http://news.gelamor.com/backup','https://news.gelamor.com/backup',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','g9txj3ck3lkpe3q705f7xcq',NULL,NULL,'a:1:{s:8:\"page_url\";s:31:\"https://news.gelamor.com/backup\";}'),(1190,NULL,NULL,NULL,4708,3565,2218,'2023-05-30 19:38:36',NULL,'','','','','',404,'http://news.gelamor.de/backup','https://news.gelamor.com/backup',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','qe738hsptjjheohfbvlremw',NULL,NULL,'a:1:{s:8:\"page_url\";s:31:\"https://news.gelamor.com/backup\";}'),(1191,NULL,NULL,NULL,4709,3565,2219,'2023-05-30 19:38:37',NULL,'','','','','',404,'http://news.gelamor.com/old','https://news.gelamor.com/old',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','u7dunrt5s4ivoktafghs77z',NULL,NULL,'a:1:{s:8:\"page_url\";s:28:\"https://news.gelamor.com/old\";}'),(1192,NULL,NULL,NULL,4710,3565,2220,'2023-05-30 19:38:37',NULL,'','','','','',404,'http://news.gelamor.de/old','https://news.gelamor.com/old',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','h5kzai43avcpqnet4i2hpv1',NULL,NULL,'a:1:{s:8:\"page_url\";s:28:\"https://news.gelamor.com/old\";}'),(1193,NULL,NULL,NULL,4711,3565,2221,'2023-05-30 19:38:38',NULL,'','','','','',404,'http://news.gelamor.com/new','https://news.gelamor.com/new',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','ixg4eqs2mk9hn0htb04sjff',NULL,NULL,'a:1:{s:8:\"page_url\";s:28:\"https://news.gelamor.com/new\";}'),(1194,NULL,NULL,NULL,4712,3565,2222,'2023-05-30 19:38:38',NULL,'','','','','',404,'http://news.gelamor.de/new','https://news.gelamor.com/new',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','35gbtc15hh1m3aysvggxfpe',NULL,NULL,'a:1:{s:8:\"page_url\";s:28:\"https://news.gelamor.com/new\";}'),(1195,NULL,NULL,NULL,4713,3565,2223,'2023-05-30 19:38:39',NULL,'','','','','',404,'http://news.gelamor.com/main','https://news.gelamor.com/main',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','0labvxsym7eego6mcv3em77',NULL,NULL,'a:1:{s:8:\"page_url\";s:29:\"https://news.gelamor.com/main\";}'),(1196,NULL,NULL,NULL,4714,3565,2224,'2023-05-30 19:38:39',NULL,'','','','','',404,'http://news.gelamor.de/main','https://news.gelamor.com/main',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','y445khab73qu54q7q7mnf4i',NULL,NULL,'a:1:{s:8:\"page_url\";s:29:\"https://news.gelamor.com/main\";}'),(1197,NULL,NULL,NULL,4715,3565,2225,'2023-05-30 19:38:40',NULL,'','','','','',404,'http://news.gelamor.com/home','https://news.gelamor.com/home',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','uf5xjsv41oylugfrep5hs6v',NULL,NULL,'a:1:{s:8:\"page_url\";s:29:\"https://news.gelamor.com/home\";}'),(1198,NULL,NULL,NULL,4716,3565,2226,'2023-05-30 19:38:41',NULL,'','','','','',404,'http://news.gelamor.de/home','https://news.gelamor.com/home',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',NULL,NULL,'a:0:{}','lwshv9ismgfcq7akt1pvn22',NULL,NULL,'a:1:{s:8:\"page_url\";s:29:\"https://news.gelamor.com/home\";}'),(1199,NULL,NULL,NULL,4717,3567,2227,'2023-05-30 20:33:15',NULL,'','','','','',404,NULL,'https://news.gelamor.com/wp-content/plugins/mstore-api/assets/js/mstore-inspireui.js',NULL,'Mozilla/5.0 (iPhone; CPU iPhone OS 14_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/92.0.4515.90 Mobile/15E148 Safari/604.1',NULL,NULL,'a:0:{}','k60kxcs41juty30smhqryhe',NULL,NULL,'a:1:{s:8:\"page_url\";s:84:\"https://news.gelamor.com/wp-content/plugins/mstore-api/assets/js/mstore-inspireui.js\";}'),(1200,NULL,NULL,NULL,4740,3594,2266,'2023-05-31 10:20:35','2023-05-31 10:20:37','','','','','',404,NULL,'https://news.gelamor.com/apple-touch-icon-precomposed.png',NULL,'Safari/18615.2.9.11.4 CFNetwork/1408.0.4 Darwin/22.5.0',NULL,NULL,'a:2:{i:0;s:5:\"de-DE\";i:1;s:8:\"de;q=0.9\";}','xv728nwc032s84htw90ivqi',NULL,NULL,'a:1:{s:8:\"page_url\";s:57:\"https://news.gelamor.com/apple-touch-icon-precomposed.png\";}'),(1201,NULL,NULL,NULL,4740,3594,2266,'2023-05-31 10:20:37',NULL,'','','','','',404,NULL,'https://news.gelamor.com/apple-touch-icon.png',NULL,'Safari/18615.2.9.11.4 CFNetwork/1408.0.4 Darwin/22.5.0',NULL,NULL,'a:2:{i:0;s:5:\"de-DE\";i:1;s:8:\"de;q=0.9\";}','xv728nwc032s84htw90ivqi',NULL,NULL,'a:1:{s:8:\"page_url\";s:45:\"https://news.gelamor.com/apple-touch-icon.png\";}'),(1202,NULL,NULL,NULL,4741,3706,2418,'2023-06-01 09:36:43',NULL,'','','','','',404,NULL,'https://news.gelamor.com/sitemap.xml',NULL,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_0) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11',NULL,NULL,'a:0:{}','iff3yiw8re51fq84mihfail',NULL,NULL,'a:1:{s:8:\"page_url\";s:36:\"https://news.gelamor.com/sitemap.xml\";}'),(1203,NULL,NULL,NULL,4742,3708,2420,'2023-06-01 10:10:03',NULL,'','','','','',404,'http://news.gelamor.com/sitemap.xml','https://news.gelamor.com/sitemap.xml',NULL,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_0) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11',NULL,NULL,'a:0:{}','7mdkbjf5f4n4wh26tivi4tz',NULL,NULL,'a:1:{s:8:\"page_url\";s:36:\"https://news.gelamor.com/sitemap.xml\";}'),(1204,NULL,NULL,NULL,4753,3741,2453,'2023-06-04 13:17:16','2023-06-04 13:17:17','','','','','',404,NULL,'https://news.gelamor.com/apple-touch-icon-120x120-precomposed.png',NULL,'MobileSafari/8615.2.9.10.3 CFNetwork/1408.0.4 Darwin/22.5.0',NULL,NULL,'a:2:{i:0;s:5:\"de-DE\";i:1;s:8:\"de;q=0.9\";}','72ko8671w69bbbt76uwut18',NULL,NULL,'a:1:{s:8:\"page_url\";s:65:\"https://news.gelamor.com/apple-touch-icon-120x120-precomposed.png\";}'),(1205,NULL,NULL,NULL,4753,3741,2453,'2023-06-04 13:17:17','2023-06-04 13:17:18','','','','','',404,NULL,'https://news.gelamor.com/apple-touch-icon-120x120.png',NULL,'MobileSafari/8615.2.9.10.3 CFNetwork/1408.0.4 Darwin/22.5.0',NULL,NULL,'a:2:{i:0;s:5:\"de-DE\";i:1;s:8:\"de;q=0.9\";}','72ko8671w69bbbt76uwut18',NULL,NULL,'a:1:{s:8:\"page_url\";s:53:\"https://news.gelamor.com/apple-touch-icon-120x120.png\";}'),(1206,NULL,NULL,NULL,4753,3741,2453,'2023-06-04 13:17:18','2023-06-04 13:17:19','','','','','',404,NULL,'https://news.gelamor.com/apple-touch-icon-precomposed.png',NULL,'MobileSafari/8615.2.9.10.3 CFNetwork/1408.0.4 Darwin/22.5.0',NULL,NULL,'a:2:{i:0;s:5:\"de-DE\";i:1;s:8:\"de;q=0.9\";}','72ko8671w69bbbt76uwut18',NULL,NULL,'a:1:{s:8:\"page_url\";s:57:\"https://news.gelamor.com/apple-touch-icon-precomposed.png\";}'),(1207,NULL,NULL,NULL,4753,3741,2453,'2023-06-04 13:17:19',NULL,'','','','','',404,NULL,'https://news.gelamor.com/apple-touch-icon.png',NULL,'MobileSafari/8615.2.9.10.3 CFNetwork/1408.0.4 Darwin/22.5.0',NULL,NULL,'a:2:{i:0;s:5:\"de-DE\";i:1;s:8:\"de;q=0.9\";}','72ko8671w69bbbt76uwut18',NULL,NULL,'a:1:{s:8:\"page_url\";s:45:\"https://news.gelamor.com/apple-touch-icon.png\";}'),(1208,NULL,NULL,NULL,4754,2968,2497,'2023-06-14 07:39:03',NULL,'','','','','',404,'https://news.gelamor.com/_ignition/health-check/','https://news.gelamor.com/_ignition/health-check',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36',NULL,NULL,'a:2:{i:0;s:5:\"en-US\";i:1;s:8:\"en;q=0.9\";}','n8a5mwclvnckjl6guc7r7g7',NULL,NULL,'a:1:{s:8:\"page_url\";s:47:\"https://news.gelamor.com/_ignition/health-check\";}'),(1209,NULL,NULL,NULL,4755,2968,2498,'2023-06-14 07:39:07',NULL,'','','','','',404,'https://news.gelamor.com/public/_ignition/health-check/','https://news.gelamor.com/public/_ignition/health-check',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36',NULL,NULL,'a:2:{i:0;s:5:\"en-US\";i:1;s:8:\"en;q=0.9\";}','roqqd43tscnh0g9dclg3sd3',NULL,NULL,'a:1:{s:8:\"page_url\";s:54:\"https://news.gelamor.com/public/_ignition/health-check\";}'),(1210,NULL,NULL,NULL,4756,2968,2499,'2023-06-14 07:39:11',NULL,'','','','','',404,'http://news.gelamor.com/wp-includes/wlwmanifest.xml','https://news.gelamor.com/wp-includes/wlwmanifest.xml',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36',NULL,NULL,'a:2:{i:0;s:5:\"en-US\";i:1;s:8:\"en;q=0.9\";}','i27o8hixnu421pype41693a',NULL,NULL,'a:1:{s:8:\"page_url\";s:52:\"https://news.gelamor.com/wp-includes/wlwmanifest.xml\";}'),(1211,NULL,NULL,NULL,4757,3894,2505,'2023-06-21 22:57:05',NULL,'','','','','',404,NULL,'https://news.gelamor.com/.env',NULL,'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Maxthon/4.4.6.2000 Chrome/30.0.1599.101 Safari/537.36',NULL,NULL,'a:0:{}','eb0cb5ra8sb7khew3tlc5wu',NULL,NULL,'a:1:{s:8:\"page_url\";s:29:\"https://news.gelamor.com/.env\";}'),(1212,NULL,NULL,NULL,4758,3894,2506,'2023-06-21 22:57:13',NULL,'','','','','',404,NULL,'https://news.gelamor.com/wp-config.php.bak',NULL,'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Maxthon/4.4.6.2000 Chrome/30.0.1599.101 Safari/537.36',NULL,NULL,'a:0:{}','fd0dss7ctohx0smitoym85l',NULL,NULL,'a:1:{s:8:\"page_url\";s:42:\"https://news.gelamor.com/wp-config.php.bak\";}'),(1213,NULL,NULL,NULL,4759,3894,2507,'2023-06-21 22:57:23',NULL,'','','','','',404,NULL,'https://news.gelamor.com/wp-config.php~',NULL,'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Maxthon/4.4.6.2000 Chrome/30.0.1599.101 Safari/537.36',NULL,NULL,'a:0:{}','ndhwjcyideie9weqngrnwea',NULL,NULL,'a:1:{s:8:\"page_url\";s:39:\"https://news.gelamor.com/wp-config.php~\";}'),(1214,NULL,NULL,NULL,4760,3894,2508,'2023-06-21 22:57:44',NULL,'','','','','',404,NULL,'https://news.gelamor.com/.vscode/sftp.json',NULL,'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Maxthon/4.4.6.2000 Chrome/30.0.1599.101 Safari/537.36',NULL,NULL,'a:0:{}','d5wyn0rrdbhf7h6w1jumr6w',NULL,NULL,'a:1:{s:8:\"page_url\";s:42:\"https://news.gelamor.com/.vscode/sftp.json\";}'),(1215,NULL,NULL,NULL,4761,3894,2509,'2023-06-21 22:57:50',NULL,'','','','','',404,NULL,'https://news.gelamor.com/sftp-config.json',NULL,'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Maxthon/4.4.6.2000 Chrome/30.0.1599.101 Safari/537.36',NULL,NULL,'a:0:{}','kd2lrztmkt110vrnfw02w3z',NULL,NULL,'a:1:{s:8:\"page_url\";s:41:\"https://news.gelamor.com/sftp-config.json\";}');

--
-- Table structure for table `page_redirects`
--

CREATE TABLE `page_redirects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect_id` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `hits` int(11) NOT NULL,
  `unique_hits` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `page_redirects`
--


--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `translation_parent_id` int(10) unsigned DEFAULT NULL,
  `variant_parent_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_html` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `hits` int(11) NOT NULL,
  `unique_hits` int(11) NOT NULL,
  `variant_hits` int(11) NOT NULL,
  `revision` int(11) NOT NULL,
  `meta_description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect_url` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_preference_center` tinyint(1) DEFAULT NULL,
  `no_index` tinyint(1) DEFAULT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `variant_settings` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `variant_start_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_2074E57512469DE2` (`category_id`),
  KEY `IDX_2074E5759091A2FB` (`translation_parent_id`),
  KEY `IDX_2074E57591861123` (`variant_parent_id`),
  KEY `page_alias_search` (`alias`),
  CONSTRAINT `FK_2074E57512469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_2074E5759091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_2074E57591861123` FOREIGN KEY (`variant_parent_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `pages`
--


--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(10) unsigned NOT NULL,
  `bundle` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bitwise` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_perm` (`bundle`,`name`,`role_id`),
  KEY `IDX_2DEDCC6FD60322AC` (`role_id`),
  CONSTRAINT `FK_2DEDCC6FD60322AC` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,2,'asset','categories',4),(2,2,'asset','assets',6),(3,2,'campaign','categories',4),(4,2,'campaign','campaigns',6),(5,2,'category','categories',4),(6,2,'channel','categories',4),(7,2,'channel','messages',6),(8,2,'lead','leads',6),(9,2,'lead','lists',2),(10,2,'lead','fields',1),(11,2,'lead','imports',4),(12,2,'core','themes',4),(13,2,'dynamiccontent','categories',4),(14,2,'dynamiccontent','dynamiccontents',6),(15,2,'email','categories',4),(16,2,'email','emails',6),(17,2,'focus','categories',4),(18,2,'focus','items',6),(19,2,'form','categories',4),(20,2,'form','forms',6),(21,2,'page','categories',4),(22,2,'page','pages',6),(23,2,'page','preference_center',2),(24,2,'notification','categories',4),(25,2,'notification','notifications',6),(26,2,'notification','mobile_notifications',6),(27,2,'point','categories',4),(28,2,'point','points',4),(29,2,'point','triggers',4),(30,2,'report','reports',6),(31,2,'mauticSocial','categories',4),(32,2,'mauticSocial','monitoring',4),(33,2,'mauticSocial','tweets',6),(34,2,'stage','categories',4),(35,2,'stage','stages',4),(36,2,'sms','categories',4),(37,2,'sms','smses',6),(38,2,'user','users',4),(39,2,'user','roles',4),(40,2,'webhook','categories',4),(41,2,'webhook','webhooks',6);

--
-- Table structure for table `plugin_citrix_events`
--

CREATE TABLE `plugin_citrix_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned NOT NULL,
  `product` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_desc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D77731055458D` (`lead_id`),
  KEY `citrix_event_email` (`product`,`email`),
  KEY `citrix_event_name` (`product`,`event_name`,`event_type`),
  KEY `citrix_event_type` (`product`,`event_type`,`event_date`),
  KEY `citrix_event_product` (`product`,`email`,`event_type`),
  KEY `citrix_event_product_name` (`product`,`email`,`event_type`,`event_name`),
  KEY `citrix_event_product_name_lead` (`product`,`event_type`,`event_name`,`lead_id`),
  KEY `citrix_event_product_type_lead` (`product`,`event_type`,`lead_id`),
  KEY `citrix_event_date` (`event_date`),
  CONSTRAINT `FK_D77731055458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `plugin_citrix_events`
--


--
-- Table structure for table `plugin_crm_pipedrive_owners`
--

CREATE TABLE `plugin_crm_pipedrive_owners` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `email` (`email`),
  KEY `owner_id` (`owner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `plugin_crm_pipedrive_owners`
--


--
-- Table structure for table `plugin_integration_settings`
--

CREATE TABLE `plugin_integration_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_published` tinyint(1) NOT NULL,
  `supported_features` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `api_keys` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `feature_settings` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_941A2CE0EC942BCF` (`plugin_id`),
  CONSTRAINT `FK_941A2CE0EC942BCF` FOREIGN KEY (`plugin_id`) REFERENCES `plugins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `plugin_integration_settings`
--

INSERT INTO `plugin_integration_settings` VALUES (1,NULL,'OneSignal',0,'a:4:{i:0;s:6:\"mobile\";i:1;s:20:\"landing_page_enabled\";i:2;s:28:\"welcome_notification_enabled\";i:3;s:21:\"tracking_page_enabled\";}','a:0:{}','a:0:{}'),(2,NULL,'Twilio',0,'a:0:{}','a:0:{}','a:0:{}'),(3,1,'Gmail',0,'a:0:{}','a:0:{}','a:0:{}'),(4,3,'Mailchimp',0,'a:1:{i:0;s:9:\"push_lead\";}','a:0:{}','a:0:{}'),(5,3,'ConstantContact',0,'a:1:{i:0;s:9:\"push_lead\";}','a:0:{}','a:0:{}'),(6,3,'Icontact',0,'a:1:{i:0;s:9:\"push_lead\";}','a:0:{}','a:0:{}'),(7,4,'Outlook',0,'a:0:{}','a:0:{}','a:0:{}'),(8,5,'Clearbit',0,'a:0:{}','a:0:{}','a:0:{}'),(9,6,'Gototraining',0,'a:0:{}','a:0:{}','a:0:{}'),(10,6,'Gotomeeting',0,'a:0:{}','a:0:{}','a:0:{}'),(11,6,'Gotoassist',0,'a:0:{}','a:0:{}','a:0:{}'),(12,6,'Gotowebinar',0,'a:0:{}','a:0:{}','a:0:{}'),(13,7,'FullContact',0,'a:0:{}','a:0:{}','a:0:{}'),(14,8,'AmazonS3',0,'a:1:{i:0;s:13:\"cloud_storage\";}','a:0:{}','a:0:{}'),(15,9,'Foursquare',0,'a:2:{i:0;s:14:\"public_profile\";i:1;s:15:\"public_activity\";}','a:0:{}','a:0:{}'),(16,9,'Twitter',0,'a:4:{i:0;s:14:\"public_profile\";i:1;s:15:\"public_activity\";i:2;s:12:\"share_button\";i:3;s:12:\"login_button\";}','a:0:{}','a:0:{}'),(17,9,'Facebook',0,'a:3:{i:0;s:12:\"share_button\";i:1;s:12:\"login_button\";i:2;s:14:\"public_profile\";}','a:0:{}','a:0:{}'),(18,9,'LinkedIn',0,'a:3:{i:0;s:12:\"share_button\";i:1;s:12:\"login_button\";i:2;s:14:\"public_profile\";}','a:0:{}','a:0:{}'),(19,9,'Instagram',0,'a:2:{i:0;s:14:\"public_profile\";i:1;s:15:\"public_activity\";}','a:0:{}','a:0:{}'),(20,10,'Sugarcrm',0,'a:3:{i:0;s:9:\"push_lead\";i:1;s:9:\"get_leads\";i:2;s:10:\"push_leads\";}','a:0:{}','a:0:{}'),(21,10,'Dynamics',0,'a:3:{i:0;s:9:\"push_lead\";i:1;s:9:\"get_leads\";i:2;s:10:\"push_leads\";}','a:0:{}','a:0:{}'),(22,10,'Salesforce',0,'a:3:{i:0;s:9:\"push_lead\";i:1;s:9:\"get_leads\";i:2;s:10:\"push_leads\";}','a:0:{}','a:0:{}'),(23,10,'Vtiger',0,'a:1:{i:0;s:9:\"push_lead\";}','a:0:{}','a:0:{}'),(24,10,'Zoho',0,'a:3:{i:0;s:9:\"push_lead\";i:1;s:9:\"get_leads\";i:2;s:10:\"push_leads\";}','a:0:{}','a:0:{}'),(25,10,'Pipedrive',0,'a:1:{i:0;s:9:\"push_lead\";}','a:0:{}','a:0:{}'),(26,10,'Connectwise',0,'a:2:{i:0;s:9:\"push_lead\";i:1;s:9:\"get_leads\";}','a:0:{}','a:0:{}'),(27,10,'Hubspot',0,'a:2:{i:0;s:9:\"push_lead\";i:1;s:9:\"get_leads\";}','a:0:{}','a:0:{}'),(28,11,'GrapesJsBuilder',0,'a:0:{}','a:0:{}','a:0:{}');

--
-- Table structure for table `plugins`
--

CREATE TABLE `plugins` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_missing` tinyint(1) NOT NULL,
  `bundle` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_bundle` (`bundle`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `plugins`
--

INSERT INTO `plugins` VALUES (1,'Gmail','Enables integrations with Gmail for email tracking',0,'MauticGmailBundle','1.0','Mautic'),(2,'Mautic Focus','Drive visitor\'s focus on your website with Mautic Focus',0,'MauticFocusBundle','1.0','Mautic, Inc'),(3,'Email Marketing','Enables integration with Mautic supported email marketing services.',0,'MauticEmailMarketingBundle','1.0','Mautic'),(4,'Outlook','Enables integrations with Outlook for email tracking',0,'MauticOutlookBundle','1.0','Mautic'),(5,'Clearbit','Enables integration with Clearbit for contact and company lookup',0,'MauticClearbitBundle','1.0','Werner Garcia'),(6,'Citrix','Enables integration with Mautic supported Citrix collaboration products.',0,'MauticCitrixBundle','1.0','Mautic'),(7,'FullContact','Enables integration with FullContact for contact and company lookup',0,'MauticFullContactBundle','1.0','Mautic'),(8,'Cloud Storage','Enables integrations with Mautic supported cloud storage services.',0,'MauticCloudStorageBundle','1.0','Mautic'),(9,'Social Media','Enables integrations with Mautic supported social media services.',0,'MauticSocialBundle','1.0','Mautic'),(10,'CRM','Enables integration with Mautic supported CRMs.',0,'MauticCrmBundle','1.0','Mautic'),(11,'Builder','GrapesJS Builder with MJML support for Mautic',0,'GrapesJsBuilderBundle','1.0.0','Webmecanik'),(12,'Zapier Integration','Zapier lets you connect Mautic with 1100+ other apps\n---\nLearn more about Zapier integration in the <a href=\"https://mautic.org/docs/en/plugins/zapier.html\">docs</a>. Make sure Mautic API and Basic Auth is enabled in the <a href=\"config/edit\" target=\"_blank\">configuration</a>.\n<br>\n<br>\nUse these predefined Zap templates as a starting point:\n<div id=\"zaps\"></div>\n<script src=\"https://zapier.com/apps/embed/widget.js?services=mautic&html_id=zaps\"></script>',0,'MauticZapierBundle','1.0','Mautic');

--
-- Table structure for table `point_lead_action_log`
--

CREATE TABLE `point_lead_action_log` (
  `point_id` int(10) unsigned NOT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `date_fired` datetime NOT NULL,
  PRIMARY KEY (`point_id`,`lead_id`),
  KEY `IDX_6DF94A56C028CEA2` (`point_id`),
  KEY `IDX_6DF94A5655458D` (`lead_id`),
  KEY `IDX_6DF94A56A03F5E9F` (`ip_id`),
  CONSTRAINT `FK_6DF94A5655458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_6DF94A56A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`),
  CONSTRAINT `FK_6DF94A56C028CEA2` FOREIGN KEY (`point_id`) REFERENCES `points` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `point_lead_action_log`
--


--
-- Table structure for table `point_lead_event_log`
--

CREATE TABLE `point_lead_event_log` (
  `event_id` int(10) unsigned NOT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `date_fired` datetime NOT NULL,
  PRIMARY KEY (`event_id`,`lead_id`),
  KEY `IDX_C2A3BDBA71F7E88B` (`event_id`),
  KEY `IDX_C2A3BDBA55458D` (`lead_id`),
  KEY `IDX_C2A3BDBAA03F5E9F` (`ip_id`),
  CONSTRAINT `FK_C2A3BDBA55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_C2A3BDBA71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `point_trigger_events` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_C2A3BDBAA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `point_lead_event_log`
--


--
-- Table structure for table `point_trigger_events`
--

CREATE TABLE `point_trigger_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `trigger_id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_order` int(11) NOT NULL,
  `properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_D5669585FDDDCD6` (`trigger_id`),
  KEY `trigger_type_search` (`type`),
  CONSTRAINT `FK_D5669585FDDDCD6` FOREIGN KEY (`trigger_id`) REFERENCES `point_triggers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `point_trigger_events`
--


--
-- Table structure for table `point_triggers`
--

CREATE TABLE `point_triggers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `points` int(11) NOT NULL,
  `color` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL,
  `trigger_existing_leads` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9CABD32F12469DE2` (`category_id`),
  CONSTRAINT `FK_9CABD32F12469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `point_triggers`
--


--
-- Table structure for table `points`
--

CREATE TABLE `points` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `repeatable` tinyint(1) NOT NULL,
  `delta` int(11) NOT NULL,
  `properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_27BA8E2912469DE2` (`category_id`),
  KEY `point_type_search` (`type`),
  CONSTRAINT `FK_27BA8E2912469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `points`
--


--
-- Table structure for table `push_ids`
--

CREATE TABLE `push_ids` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `push_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `mobile` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_4F2393E855458D` (`lead_id`),
  CONSTRAINT `FK_4F2393E855458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `push_ids`
--


--
-- Table structure for table `push_notification_list_xref`
--

CREATE TABLE `push_notification_list_xref` (
  `notification_id` int(10) unsigned NOT NULL,
  `leadlist_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`notification_id`,`leadlist_id`),
  KEY `IDX_473919EFEF1A9D84` (`notification_id`),
  KEY `IDX_473919EFB9FC8874` (`leadlist_id`),
  CONSTRAINT `FK_473919EFB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `lead_lists` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_473919EFEF1A9D84` FOREIGN KEY (`notification_id`) REFERENCES `push_notifications` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `push_notification_list_xref`
--


--
-- Table structure for table `push_notification_stats`
--

CREATE TABLE `push_notification_stats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `notification_id` int(10) unsigned DEFAULT NULL,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `list_id` int(10) unsigned DEFAULT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `date_sent` datetime NOT NULL,
  `date_read` datetime DEFAULT NULL,
  `is_clicked` tinyint(1) NOT NULL,
  `date_clicked` datetime DEFAULT NULL,
  `tracking_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `retry_count` int(11) DEFAULT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `tokens` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `click_count` int(11) DEFAULT NULL,
  `last_clicked` datetime DEFAULT NULL,
  `click_details` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_DE63695EEF1A9D84` (`notification_id`),
  KEY `IDX_DE63695E55458D` (`lead_id`),
  KEY `IDX_DE63695E3DAE168B` (`list_id`),
  KEY `IDX_DE63695EA03F5E9F` (`ip_id`),
  KEY `stat_notification_search` (`notification_id`,`lead_id`),
  KEY `stat_notification_clicked_search` (`is_clicked`),
  KEY `stat_notification_hash_search` (`tracking_hash`),
  KEY `stat_notification_source_search` (`source`,`source_id`),
  CONSTRAINT `FK_DE63695E3DAE168B` FOREIGN KEY (`list_id`) REFERENCES `lead_lists` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_DE63695E55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_DE63695EA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`),
  CONSTRAINT `FK_DE63695EEF1A9D84` FOREIGN KEY (`notification_id`) REFERENCES `push_notifications` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `push_notification_stats`
--


--
-- Table structure for table `push_notifications`
--

CREATE TABLE `push_notifications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `heading` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `button` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_tags` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `notification_type` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `read_count` int(11) NOT NULL,
  `sent_count` int(11) NOT NULL,
  `mobile` tinyint(1) NOT NULL,
  `mobileSettings` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_5B9B7E4F12469DE2` (`category_id`),
  CONSTRAINT `FK_5B9B7E4F12469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `push_notifications`
--


--
-- Table structure for table `reports`
--

CREATE TABLE `reports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system` tinyint(1) NOT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `columns` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `filters` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `table_order` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `graphs` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `group_by` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `aggregators` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `settings` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:json_array)',
  `is_scheduled` tinyint(1) NOT NULL,
  `schedule_unit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schedule_day` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schedule_month_frequency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `reports`
--

INSERT INTO `reports` VALUES (1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Visits published Pages',NULL,1,'page.hits','a:7:{i:0;s:11:\"ph.date_hit\";i:1;s:6:\"ph.url\";i:2;s:12:\"ph.url_title\";i:3;s:10:\"ph.referer\";i:4;s:12:\"i.ip_address\";i:5;s:7:\"ph.city\";i:6;s:10:\"ph.country\";}','a:2:{i:0;a:3:{s:6:\"column\";s:7:\"ph.code\";s:9:\"condition\";s:2:\"eq\";s:5:\"value\";s:3:\"200\";}i:1;a:3:{s:6:\"column\";s:14:\"p.is_published\";s:9:\"condition\";s:2:\"eq\";s:5:\"value\";s:1:\"1\";}}','a:1:{i:0;a:2:{s:6:\"column\";s:11:\"ph.date_hit\";s:9:\"direction\";s:3:\"ASC\";}}','a:8:{i:0;s:35:\"mautic.page.graph.line.time.on.site\";i:1;s:27:\"mautic.page.graph.line.hits\";i:2;s:38:\"mautic.page.graph.pie.new.vs.returning\";i:3;s:31:\"mautic.page.graph.pie.languages\";i:4;s:34:\"mautic.page.graph.pie.time.on.site\";i:5;s:27:\"mautic.page.table.referrers\";i:6;s:30:\"mautic.page.table.most.visited\";i:7;s:37:\"mautic.page.table.most.visited.unique\";}','a:0:{}','a:0:{}','[]',0,NULL,NULL,NULL,NULL),(2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Downloads of all Assets',NULL,1,'asset.downloads','a:7:{i:0;s:16:\"ad.date_download\";i:1;s:7:\"a.title\";i:2;s:12:\"i.ip_address\";i:3;s:11:\"l.firstname\";i:4;s:10:\"l.lastname\";i:5;s:7:\"l.email\";i:6;s:4:\"a.id\";}','a:1:{i:0;a:3:{s:6:\"column\";s:14:\"a.is_published\";s:9:\"condition\";s:2:\"eq\";s:5:\"value\";s:1:\"1\";}}','a:1:{i:0;a:2:{s:6:\"column\";s:16:\"ad.date_download\";s:9:\"direction\";s:3:\"ASC\";}}','a:4:{i:0;s:33:\"mautic.asset.graph.line.downloads\";i:1;s:31:\"mautic.asset.graph.pie.statuses\";i:2;s:34:\"mautic.asset.table.most.downloaded\";i:3;s:32:\"mautic.asset.table.top.referrers\";}','a:0:{}','a:0:{}','[]',0,NULL,NULL,NULL,NULL),(3,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Submissions of published Forms',NULL,1,'form.submissions','a:0:{}','a:1:{i:1;a:3:{s:6:\"column\";s:14:\"f.is_published\";s:9:\"condition\";s:2:\"eq\";s:5:\"value\";s:1:\"1\";}}','a:0:{}','a:3:{i:0;s:34:\"mautic.form.graph.line.submissions\";i:1;s:32:\"mautic.form.table.most.submitted\";i:2;s:31:\"mautic.form.table.top.referrers\";}','a:0:{}','a:0:{}','[]',0,NULL,NULL,NULL,NULL),(4,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All Emails',NULL,1,'email.stats','a:5:{i:0;s:12:\"es.date_sent\";i:1;s:12:\"es.date_read\";i:2;s:9:\"e.subject\";i:3;s:16:\"es.email_address\";i:4;s:4:\"e.id\";}','a:1:{i:0;a:3:{s:6:\"column\";s:14:\"e.is_published\";s:9:\"condition\";s:2:\"eq\";s:5:\"value\";s:1:\"1\";}}','a:1:{i:0;a:2:{s:6:\"column\";s:12:\"es.date_sent\";s:9:\"direction\";s:3:\"ASC\";}}','a:6:{i:0;s:29:\"mautic.email.graph.line.stats\";i:1;s:42:\"mautic.email.graph.pie.ignored.read.failed\";i:2;s:35:\"mautic.email.table.most.emails.read\";i:3;s:35:\"mautic.email.table.most.emails.sent\";i:4;s:43:\"mautic.email.table.most.emails.read.percent\";i:5;s:37:\"mautic.email.table.most.emails.failed\";}','a:0:{}','a:0:{}','[]',0,NULL,NULL,NULL,NULL),(5,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Leads and Points',NULL,1,'lead.pointlog','a:7:{i:0;s:13:\"lp.date_added\";i:1;s:7:\"lp.type\";i:2;s:13:\"lp.event_name\";i:3;s:11:\"l.firstname\";i:4;s:10:\"l.lastname\";i:5;s:7:\"l.email\";i:6;s:8:\"lp.delta\";}','a:0:{}','a:1:{i:0;a:2:{s:6:\"column\";s:13:\"lp.date_added\";s:9:\"direction\";s:3:\"ASC\";}}','a:6:{i:0;s:29:\"mautic.lead.graph.line.points\";i:1;s:29:\"mautic.lead.table.most.points\";i:2;s:29:\"mautic.lead.table.top.actions\";i:3;s:28:\"mautic.lead.table.top.cities\";i:4;s:31:\"mautic.lead.table.top.countries\";i:5;s:28:\"mautic.lead.table.top.events\";}','a:0:{}','a:0:{}','[]',0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `reports_schedulers`
--

CREATE TABLE `reports_schedulers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `report_id` int(10) unsigned NOT NULL,
  `schedule_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C74CA6B84BD2A4C0` (`report_id`),
  CONSTRAINT `FK_C74CA6B84BD2A4C0` FOREIGN KEY (`report_id`) REFERENCES `reports` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `reports_schedulers`
--


--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL,
  `readable_permissions` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Administrator','Full system access',1,'N;'),(2,1,'2022-06-10 09:39:54',1,'Rüdiger Hahn',NULL,NULL,NULL,NULL,NULL,'Rüdiger Hahn','Read Only',NULL,0,'a:41:{s:16:\"asset:categories\";a:1:{i:0;s:4:\"view\";}s:12:\"asset:assets\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:19:\"campaign:categories\";a:1:{i:0;s:4:\"view\";}s:18:\"campaign:campaigns\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:19:\"category:categories\";a:1:{i:0;s:4:\"view\";}s:18:\"channel:categories\";a:1:{i:0;s:4:\"view\";}s:16:\"channel:messages\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:10:\"lead:leads\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:10:\"lead:lists\";a:1:{i:0;s:9:\"viewother\";}s:11:\"lead:fields\";a:1:{i:0;s:4:\"view\";}s:12:\"lead:imports\";a:1:{i:0;s:4:\"view\";}s:11:\"core:themes\";a:1:{i:0;s:4:\"view\";}s:25:\"dynamiccontent:categories\";a:1:{i:0;s:4:\"view\";}s:30:\"dynamiccontent:dynamiccontents\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:16:\"email:categories\";a:1:{i:0;s:4:\"view\";}s:12:\"email:emails\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:16:\"focus:categories\";a:1:{i:0;s:4:\"view\";}s:11:\"focus:items\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:15:\"form:categories\";a:1:{i:0;s:4:\"view\";}s:10:\"form:forms\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:15:\"page:categories\";a:1:{i:0;s:4:\"view\";}s:10:\"page:pages\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:22:\"page:preference_center\";a:1:{i:0;s:7:\"viewown\";}s:23:\"notification:categories\";a:1:{i:0;s:4:\"view\";}s:26:\"notification:notifications\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:33:\"notification:mobile_notifications\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:16:\"point:categories\";a:1:{i:0;s:4:\"view\";}s:12:\"point:points\";a:1:{i:0;s:4:\"view\";}s:14:\"point:triggers\";a:1:{i:0;s:4:\"view\";}s:14:\"report:reports\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:23:\"mauticSocial:categories\";a:1:{i:0;s:4:\"view\";}s:23:\"mauticSocial:monitoring\";a:1:{i:0;s:4:\"view\";}s:19:\"mauticSocial:tweets\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:16:\"stage:categories\";a:1:{i:0;s:4:\"view\";}s:12:\"stage:stages\";a:1:{i:0;s:4:\"view\";}s:14:\"sms:categories\";a:1:{i:0;s:4:\"view\";}s:9:\"sms:smses\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}s:10:\"user:users\";a:1:{i:0;s:4:\"view\";}s:10:\"user:roles\";a:1:{i:0;s:4:\"view\";}s:18:\"webhook:categories\";a:1:{i:0;s:4:\"view\";}s:16:\"webhook:webhooks\";a:2:{i:0;s:7:\"viewown\";i:1;s:9:\"viewother\";}}');

--
-- Table structure for table `saml_id_entry`
--

CREATE TABLE `saml_id_entry` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `entity_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiryTimestamp` int(11) NOT NULL,
  PRIMARY KEY (`id`,`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `saml_id_entry`
--


--
-- Table structure for table `sms_message_list_xref`
--

CREATE TABLE `sms_message_list_xref` (
  `sms_id` int(10) unsigned NOT NULL,
  `leadlist_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`sms_id`,`leadlist_id`),
  KEY `IDX_B032FC2EBD5C7E60` (`sms_id`),
  KEY `IDX_B032FC2EB9FC8874` (`leadlist_id`),
  CONSTRAINT `FK_B032FC2EB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `lead_lists` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_B032FC2EBD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `sms_messages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `sms_message_list_xref`
--


--
-- Table structure for table `sms_message_stats`
--

CREATE TABLE `sms_message_stats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sms_id` int(10) unsigned DEFAULT NULL,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `list_id` int(10) unsigned DEFAULT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `date_sent` datetime NOT NULL,
  `tracking_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `tokens` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `is_failed` tinyint(1) DEFAULT NULL,
  `details` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:json_array)',
  PRIMARY KEY (`id`),
  KEY `IDX_FE1BAE9BD5C7E60` (`sms_id`),
  KEY `IDX_FE1BAE955458D` (`lead_id`),
  KEY `IDX_FE1BAE93DAE168B` (`list_id`),
  KEY `IDX_FE1BAE9A03F5E9F` (`ip_id`),
  KEY `stat_sms_search` (`sms_id`,`lead_id`),
  KEY `stat_sms_hash_search` (`tracking_hash`),
  KEY `stat_sms_source_search` (`source`,`source_id`),
  KEY `stat_sms_failed_search` (`is_failed`),
  CONSTRAINT `FK_FE1BAE93DAE168B` FOREIGN KEY (`list_id`) REFERENCES `lead_lists` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_FE1BAE955458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_FE1BAE9A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`),
  CONSTRAINT `FK_FE1BAE9BD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `sms_messages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `sms_message_stats`
--


--
-- Table structure for table `sms_messages`
--

CREATE TABLE `sms_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `sms_type` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `sent_count` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_BDF43F9712469DE2` (`category_id`),
  CONSTRAINT `FK_BDF43F9712469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `sms_messages`
--


--
-- Table structure for table `stage_lead_action_log`
--

CREATE TABLE `stage_lead_action_log` (
  `stage_id` int(10) unsigned NOT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `date_fired` datetime NOT NULL,
  PRIMARY KEY (`stage_id`,`lead_id`),
  KEY `IDX_A506AFBE2298D193` (`stage_id`),
  KEY `IDX_A506AFBE55458D` (`lead_id`),
  KEY `IDX_A506AFBEA03F5E9F` (`ip_id`),
  CONSTRAINT `FK_A506AFBE2298D193` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_A506AFBE55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_A506AFBEA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `stage_lead_action_log`
--


--
-- Table structure for table `stages`
--

CREATE TABLE `stages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` int(11) NOT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_2FA26A6412469DE2` (`category_id`),
  CONSTRAINT `FK_2FA26A6412469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `stages`
--


--
-- Table structure for table `sync_object_field_change_report`
--

CREATE TABLE `sync_object_field_change_report` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `integration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `object_id` bigint(20) unsigned NOT NULL,
  `object_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `modified_at` datetime NOT NULL,
  `column_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `column_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `column_value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `object_composite_key` (`object_type`,`object_id`,`column_name`),
  KEY `integration_object_composite_key` (`integration`,`object_type`,`object_id`,`column_name`),
  KEY `integration_object_type_modification_composite_key` (`integration`,`object_type`,`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `sync_object_field_change_report`
--


--
-- Table structure for table `sync_object_mapping`
--

CREATE TABLE `sync_object_mapping` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date_created` datetime NOT NULL,
  `integration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `internal_object_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `internal_object_id` bigint(20) unsigned NOT NULL,
  `integration_object_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `integration_object_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_sync_date` datetime NOT NULL,
  `internal_storage` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:json_array)',
  `is_deleted` tinyint(1) NOT NULL,
  `integration_reference_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `integration_object` (`integration`,`integration_object_name`,`integration_object_id`,`integration_reference_id`),
  KEY `integration_reference` (`integration`,`integration_object_name`,`integration_reference_id`,`integration_object_id`),
  KEY `integration_last_sync_date` (`integration`,`last_sync_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `sync_object_mapping`
--


--
-- Table structure for table `tweet_stats`
--

CREATE TABLE `tweet_stats` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tweet_id` int(10) unsigned DEFAULT NULL,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `twitter_tweet_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `handle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_sent` datetime DEFAULT NULL,
  `is_failed` tinyint(1) DEFAULT NULL,
  `retry_count` int(11) DEFAULT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `favorite_count` int(11) DEFAULT NULL,
  `retweet_count` int(11) DEFAULT NULL,
  `response_details` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:json_array)',
  PRIMARY KEY (`id`),
  KEY `IDX_CB8CBAE51041E39B` (`tweet_id`),
  KEY `IDX_CB8CBAE555458D` (`lead_id`),
  KEY `stat_tweet_search` (`tweet_id`,`lead_id`),
  KEY `stat_tweet_search2` (`lead_id`,`tweet_id`),
  KEY `stat_tweet_failed_search` (`is_failed`),
  KEY `stat_tweet_source_search` (`source`,`source_id`),
  KEY `favorite_count_index` (`favorite_count`),
  KEY `retweet_count_index` (`retweet_count`),
  KEY `tweet_date_sent` (`date_sent`),
  KEY `twitter_tweet_id_index` (`twitter_tweet_id`),
  CONSTRAINT `FK_CB8CBAE51041E39B` FOREIGN KEY (`tweet_id`) REFERENCES `tweets` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_CB8CBAE555458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweet_stats`
--


--
-- Table structure for table `tweets`
--

CREATE TABLE `tweets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `page_id` int(10) unsigned DEFAULT NULL,
  `asset_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `media_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `media_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sent_count` int(11) DEFAULT NULL,
  `favorite_count` int(11) DEFAULT NULL,
  `retweet_count` int(11) DEFAULT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_AA38402512469DE2` (`category_id`),
  KEY `IDX_AA384025C4663E4` (`page_id`),
  KEY `IDX_AA3840255DA1941` (`asset_id`),
  KEY `sent_count_index` (`sent_count`),
  KEY `favorite_count_index` (`favorite_count`),
  KEY `retweet_count_index` (`retweet_count`),
  CONSTRAINT `FK_AA38402512469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_AA3840255DA1941` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_AA384025C4663E4` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweets`
--


--
-- Temporary table structure for view `v_missing_lead_email`
--

/*!50001 DROP VIEW IF EXISTS `v_missing_lead_email`*/;
/*!50001 CREATE TABLE `v_missing_lead_email` (
  `company_id` tinyint NOT NULL,
  `company_customer_number` tinyint NOT NULL,
  `company_email` tinyint NOT NULL,
  `company_name` tinyint NOT NULL,
  `lead_id` tinyint NOT NULL,
  `lead_company` tinyint NOT NULL,
  `lead_email` tinyint NOT NULL,
  `lead_country` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Table structure for table `video_hits`
--

CREATE TABLE `video_hits` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `ip_id` int(10) unsigned NOT NULL,
  `date_hit` datetime NOT NULL,
  `date_left` datetime DEFAULT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` int(11) NOT NULL,
  `referer` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remote_host` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_language` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser_languages` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  `channel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `time_watched` int(11) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `query` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_1D1831F755458D` (`lead_id`),
  KEY `IDX_1D1831F7A03F5E9F` (`ip_id`),
  KEY `video_date_hit` (`date_hit`),
  KEY `video_channel_search` (`channel`,`channel_id`),
  KEY `video_guid_lead_search` (`guid`,`lead_id`),
  CONSTRAINT `FK_1D1831F755458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_1D1831F7A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `video_hits`
--


--
-- Table structure for table `webhook_events`
--

CREATE TABLE `webhook_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `webhook_id` int(10) unsigned NOT NULL,
  `event_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7AD44E375C9BA60B` (`webhook_id`),
  CONSTRAINT `FK_7AD44E375C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `webhook_events`
--


--
-- Table structure for table `webhook_logs`
--

CREATE TABLE `webhook_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `webhook_id` int(10) unsigned NOT NULL,
  `status_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `runtime` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_45A353475C9BA60B` (`webhook_id`),
  CONSTRAINT `FK_45A353475C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `webhook_logs`
--


--
-- Table structure for table `webhook_queue`
--

CREATE TABLE `webhook_queue` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `webhook_id` int(10) unsigned NOT NULL,
  `event_id` int(10) unsigned NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_F52D9A1A5C9BA60B` (`webhook_id`),
  KEY `IDX_F52D9A1A71F7E88B` (`event_id`),
  KEY `webhook_id_date` (`webhook_id`,`date_added`),
  CONSTRAINT `FK_F52D9A1A5C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_F52D9A1A71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `webhook_events` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `webhook_queue`
--


--
-- Table structure for table `widgets`
--

CREATE TABLE `widgets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL,
  `cache_timeout` int(11) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `params` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `widgets`
--

INSERT INTO `widgets` VALUES (1,1,'2020-10-08 13:04:36',1,'Rüdiger Hahn','2020-10-08 13:04:36',NULL,NULL,NULL,NULL,NULL,'Contacts Created','created.leads.in.time',100,330,NULL,0,'a:1:{s:5:\"lists\";s:21:\"identifiedVsAnonymous\";}'),(2,1,'2020-10-08 13:04:37',1,'Rüdiger Hahn','2020-10-08 13:04:37',NULL,NULL,NULL,NULL,NULL,'Page Visits','page.hits.in.time',50,330,NULL,1,'a:1:{s:4:\"flag\";s:6:\"unique\";}'),(3,1,'2020-10-08 13:04:37',1,'Rüdiger Hahn','2020-10-08 13:04:37',NULL,NULL,NULL,NULL,NULL,'Form Submissions','submissions.in.time',50,330,NULL,2,'a:0:{}'),(4,1,'2020-10-08 13:04:38',1,'Rüdiger Hahn','2020-10-08 13:04:38',NULL,NULL,NULL,NULL,NULL,'Recent Activity','recent.activity',50,330,NULL,3,'a:0:{}'),(5,1,'2020-10-08 13:04:39',1,'Rüdiger Hahn','2020-10-08 13:04:39',NULL,NULL,NULL,NULL,NULL,'Upcoming Emails','upcoming.emails',50,330,NULL,4,'a:0:{}'),(6,1,'2020-10-13 06:55:46',2,'Monja Kleine','2020-10-13 06:55:46',NULL,NULL,NULL,NULL,NULL,'Contacts Created','created.leads.in.time',100,330,NULL,0,'a:1:{s:5:\"lists\";s:21:\"identifiedVsAnonymous\";}'),(7,1,'2020-10-13 06:55:46',2,'Monja Kleine','2020-10-13 06:55:46',NULL,NULL,NULL,NULL,NULL,'Page Visits','page.hits.in.time',50,330,NULL,1,'a:1:{s:4:\"flag\";s:6:\"unique\";}'),(8,1,'2020-10-13 06:55:46',2,'Monja Kleine','2020-10-13 06:55:46',NULL,NULL,NULL,NULL,NULL,'Form Submissions','submissions.in.time',50,330,NULL,2,'a:0:{}'),(9,1,'2020-10-13 06:55:47',2,'Monja Kleine','2020-10-13 06:55:47',NULL,NULL,NULL,NULL,NULL,'Recent Activity','recent.activity',50,330,NULL,3,'a:0:{}'),(10,1,'2020-10-13 06:55:47',2,'Monja Kleine','2020-10-13 06:55:47',NULL,NULL,NULL,NULL,NULL,'Upcoming Emails','upcoming.emails',50,330,NULL,4,'a:0:{}'),(11,1,'2022-06-10 14:18:57',3,'Susanne Gockel','2022-06-10 14:18:57',NULL,NULL,NULL,NULL,NULL,'Contacts Created','created.leads.in.time',100,330,NULL,0,'a:1:{s:5:\"lists\";s:21:\"identifiedVsAnonymous\";}'),(12,1,'2022-06-10 14:18:57',3,'Susanne Gockel','2022-06-10 14:18:57',NULL,NULL,NULL,NULL,NULL,'Page Visits','page.hits.in.time',50,330,NULL,1,'a:1:{s:4:\"flag\";s:6:\"unique\";}'),(13,1,'2022-06-10 14:18:57',3,'Susanne Gockel','2022-06-10 14:18:57',NULL,NULL,NULL,NULL,NULL,'Form Submissions','submissions.in.time',50,330,NULL,2,'a:0:{}'),(14,1,'2022-06-10 14:18:57',3,'Susanne Gockel','2022-06-10 14:18:57',NULL,NULL,NULL,NULL,NULL,'Recent Activity','recent.activity',50,330,NULL,3,'a:0:{}'),(15,1,'2022-06-10 14:18:58',3,'Susanne Gockel','2022-06-10 14:18:58',NULL,NULL,NULL,NULL,NULL,'Upcoming Emails','upcoming.emails',50,330,NULL,4,'a:0:{}');

--
-- Final view structure for view `v_missing_lead_email`
--

/*!50001 DROP TABLE IF EXISTS `v_missing_lead_email`*/;
/*!50001 DROP VIEW IF EXISTS `v_missing_lead_email`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `v_missing_lead_email` AS select `c`.`id` AS `company_id`,`c`.`customer_number` AS `company_customer_number`,`c`.`companyemail` AS `company_email`,`c`.`companyname` AS `company_name`,`l`.`id` AS `lead_id`,`l`.`company` AS `lead_company`,`l`.`email` AS `lead_email`,`l`.`country` AS `lead_country` from (((`leads` `l` left join `lead_lists_leads` `lll` on(`lll`.`lead_id` = `l`.`id`)) left join `companies_leads` `cl` on(`cl`.`lead_id` = `l`.`id`)) left join `companies` `c` on(`c`.`id` = `cl`.`company_id`)) where `lll`.`lead_id` is not null and `c`.`companyemail` is not null and `l`.`email` is null */;


