/* CUSTOM VARS START */
/* REAL_TABLE_NAME: `wpk9bt_e_submissions`; */
/* PRE_TABLE_NAME: `1741599259_wpk9bt_e_submissions`; */
/* CUSTOM VARS END */

CREATE TABLE IF NOT EXISTS `1741599259_wpk9bt_e_submissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(60) DEFAULT NULL, `hash_id` varchar(60) 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) NOT NULL, `referer_title` varchar(300) DEFAULT NULL, `element_id` varchar(20) NOT NULL, `form_name` varchar(60) NOT NULL, `campaign_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` varchar(46) NOT NULL, `user_agent` text NOT NULL, `actions_count` int(11) DEFAULT 0, `actions_succeeded_count` int(11) DEFAULT 0, `status` varchar(20) NOT NULL, `is_read` tinyint(1) NOT NULL DEFAULT 0, `meta` text DEFAULT NULL, `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
