/*!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 */;
DROP TABLE IF EXISTS `wplc_e_submissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wplc_e_submissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(60) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `hash_id` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `main_meta_id` bigint(20) unsigned NOT NULL COMMENT 'Id of main field. to represent the main meta field',
  `post_id` bigint(20) unsigned NOT NULL,
  `referer` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `referer_title` varchar(300) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `element_id` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `form_name` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `campaign_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `user_ip` varchar(46) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `actions_count` int(11) DEFAULT '0',
  `actions_succeeded_count` int(11) DEFAULT '0',
  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT '0',
  `meta` text COLLATE utf8mb4_unicode_520_ci,
  `created_at_gmt` datetime NOT NULL,
  `updated_at_gmt` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hash_id_unique_index` (`hash_id`),
  KEY `main_meta_id_index` (`main_meta_id`),
  KEY `hash_id_index` (`hash_id`),
  KEY `type_index` (`type`),
  KEY `post_id_index` (`post_id`),
  KEY `element_id_index` (`element_id`),
  KEY `campaign_id_index` (`campaign_id`),
  KEY `user_id_index` (`user_id`),
  KEY `user_ip_index` (`user_ip`),
  KEY `status_index` (`status`),
  KEY `is_read_index` (`is_read`),
  KEY `created_at_gmt_index` (`created_at_gmt`),
  KEY `updated_at_gmt_index` (`updated_at_gmt`),
  KEY `created_at_index` (`created_at`),
  KEY `updated_at_index` (`updated_at`),
  KEY `referer_index` (`referer`(191)),
  KEY `referer_title_index` (`referer_title`(191))
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

INSERT INTO `wplc_e_submissions` VALUES (1,'submission','3355aaf8-864b-4862-af24-8ad42b6d0967',2,47,'https://www.dubdelivery.club/contact/','Contact Us | Düb Delivery Club | Michigan, USA','28c4c43','New Form',0,0,'156.235.89.62','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 YaBrowser/22.7.0 Yowser/2.5 Safari/537.36',1,1,'new',0,'{\"edit_post_id\":\"47\"}','2023-12-08 09:16:41','2023-12-08 09:16:41','2023-12-08 03:16:41','2023-12-08 03:16:41');
INSERT INTO `wplc_e_submissions` VALUES (2,'submission','d9bd26d0-639a-453b-a433-e27d9e3c660b',6,47,'https://www.dubdelivery.club/contact/','Contact Us | Düb Delivery Club | Michigan, USA','28c4c43','New Form',0,0,'5.180.150.38','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36',1,1,'new',0,'{\"edit_post_id\":\"47\"}','2023-12-12 06:16:23','2023-12-12 06:16:24','2023-12-12 00:16:23','2023-12-12 00:16:24');
INSERT INTO `wplc_e_submissions` VALUES (3,'submission','a4b5501e-e5e1-424b-bc1b-25043b3136a5',10,47,'https://www.dubdelivery.club/contact/','Contact Us | Düb Delivery Club | Michigan, USA','28c4c43','New Form',0,0,'173.234.225.157','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Vivaldi/5.3.2679.68',1,1,'new',0,'{\"edit_post_id\":\"47\"}','2023-12-13 04:59:10','2023-12-13 04:59:10','2023-12-12 22:59:10','2023-12-12 22:59:10');
INSERT INTO `wplc_e_submissions` VALUES (4,'submission','fc3ca573-262b-417b-b271-d44580d2af0d',14,47,'https://www.dubdelivery.club/contact/','Contact Us | Düb Delivery Club | Michigan, USA','28c4c43','New Form',0,0,'177.234.143.247','Mozilla/5.0 (X11; Linux i686) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Vivaldi/5.3.2679.68',1,1,'new',0,'{\"edit_post_id\":\"47\"}','2023-12-17 12:25:14','2023-12-17 12:25:15','2023-12-17 06:25:14','2023-12-17 06:25:15');
INSERT INTO `wplc_e_submissions` VALUES (5,'submission','3ce8a047-8dd8-43ad-89a6-70b8b8e97375',18,47,'https://www.dubdelivery.club/contact/','Contact Us | Düb Delivery Club | Michigan, USA','28c4c43','New Form',0,0,'38.170.245.237','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Vivaldi/5.3.2679.68',1,1,'new',0,'{\"edit_post_id\":\"47\"}','2023-12-21 19:10:31','2023-12-21 19:10:32','2023-12-21 13:10:31','2023-12-21 13:10:32');
INSERT INTO `wplc_e_submissions` VALUES (6,'submission','eb517628-2100-413e-be81-209f6ebee49b',22,47,'https://www.dubdelivery.club/contact/','Contact Us | Düb Delivery Club | Michigan, USA','28c4c43','New Form',0,0,'69.147.248.112','Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:114.0) Gecko/20100101 Firefox/114.0',1,1,'new',0,'{\"edit_post_id\":\"47\"}','2023-12-22 08:31:36','2023-12-22 08:31:37','2023-12-22 02:31:36','2023-12-22 02:31:37');
INSERT INTO `wplc_e_submissions` VALUES (7,'submission','db17464e-65c6-480e-aa6f-6beb0fd63f80',26,47,'','Contact Us | Dub Delivery Club | Michigan, USA','28c4c43','New Form',0,0,'185.225.28.4','Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36',1,1,'new',0,'{\"edit_post_id\":\"47\"}','2023-12-22 22:27:51','2023-12-22 22:27:52','2023-12-22 16:27:51','2023-12-22 16:27:52');
INSERT INTO `wplc_e_submissions` VALUES (8,'submission','5112affc-a63c-496d-beb5-973f469ab4be',30,47,'https://www.dubdelivery.club/contact/','Contact Us | Düb Delivery Club | Michigan, USA','28c4c43','New Form',0,0,'38.153.160.239','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36',1,1,'new',0,'{\"edit_post_id\":\"47\"}','2024-01-02 18:06:59','2024-01-02 18:07:00','2024-01-02 12:06:59','2024-01-02 12:07:00');
INSERT INTO `wplc_e_submissions` VALUES (9,'submission','e8508925-666f-4853-b960-992512c5295b',34,47,'https://www.dubdelivery.club/contact/','Contact Us | Düb Delivery Club | Michigan, USA','28c4c43','New Form',0,0,'172.245.103.175','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Vivaldi/5.3.2679.68',1,1,'new',0,'{\"edit_post_id\":\"47\"}','2024-01-05 17:18:47','2024-01-05 17:18:48','2024-01-05 11:18:47','2024-01-05 11:18:48');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

