-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 04, 2023 at 01:39 AM -- Server version: 10.5.22-MariaDB-cll-lve -- PHP Version: 8.1.16 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `digitalengage_w632` -- -- -------------------------------------------------------- -- -- Table structure for table `wphs_actionscheduler_actions` -- CREATE TABLE `wphs_actionscheduler_actions` ( `action_id` bigint(20) UNSIGNED NOT NULL, `hook` varchar(191) NOT NULL, `status` varchar(20) NOT NULL, `scheduled_date_gmt` datetime DEFAULT '0000-00-00 00:00:00', `scheduled_date_local` datetime DEFAULT '0000-00-00 00:00:00', `args` varchar(191) DEFAULT NULL, `schedule` longtext DEFAULT NULL, `group_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `attempts` int(11) NOT NULL DEFAULT 0, `last_attempt_gmt` datetime DEFAULT '0000-00-00 00:00:00', `last_attempt_local` datetime DEFAULT '0000-00-00 00:00:00', `claim_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `extended_args` varchar(8000) DEFAULT NULL, `priority` tinyint(3) UNSIGNED NOT NULL DEFAULT 10 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `wphs_actionscheduler_actions` -- INSERT INTO `wphs_actionscheduler_actions` (`action_id`, `hook`, `status`, `scheduled_date_gmt`, `scheduled_date_local`, `args`, `schedule`, `group_id`, `attempts`, `last_attempt_gmt`, `last_attempt_local`, `claim_id`, `extended_args`, `priority`) VALUES (139, 'wc-admin_import_customers', 'complete', '2023-11-02 07:43:07', '2023-11-02 07:43:07', '[1]', 'O:30:\"ActionScheduler_SimpleSchedule\":2:{s:22:\"\0*\0scheduled_timestamp\";i:1698910987;s:41:\"\0ActionScheduler_SimpleSchedule\0timestamp\";i:1698910987;}', 2, 1, '2023-11-02 07:43:37', '2023-11-02 07:43:37', 0, NULL, 10), (140, 'woocommerce_update_marketplace_suggestions', 'complete', '2023-11-02 08:49:46', '2023-11-02 08:49:46', '[]', 'O:30:\"ActionScheduler_SimpleSchedule\":2:{s:22:\"\0*\0scheduled_timestamp\";i:1698914986;s:41:\"\0ActionScheduler_SimpleSchedule\0timestamp\";i:1698914986;}', 0, 1, '2023-11-02 08:50:19', '2023-11-02 08:50:19', 0, NULL, 10), (141, 'woocommerce_admin/stored_state_setup_for_products/async/run_remote_notifications', 'complete', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '[]', 'O:28:\"ActionScheduler_NullSchedule\":0:{}', 0, 1, '2023-11-02 08:54:20', '2023-11-02 08:54:20', 0, NULL, 10), (142, 'woocommerce_admin/stored_state_setup_for_products/async/run_remote_notifications', 'complete', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '[]', 'O:28:\"ActionScheduler_NullSchedule\":0:{}', 0, 1, '2023-11-02 09:07:17', '2023-11-02 09:07:17', 0, NULL, 10), (143, 'woocommerce_admin/stored_state_setup_for_products/async/run_remote_notifications', 'complete', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '[]', 'O:28:\"ActionScheduler_NullSchedule\":0:{}', 0, 1, '2023-11-02 09:08:21', '2023-11-02 09:08:21', 0, NULL, 10), (144, 'woocommerce_admin/stored_state_setup_for_products/async/run_remote_notifications', 'complete', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '[]', 'O:28:\"ActionScheduler_NullSchedule\":0:{}', 0, 1, '2023-11-02 09:09:23', '2023-11-02 09:09:23', 0, NULL, 10), (145, 'wc-admin_import_customers', 'complete', '2023-11-04 05:57:19', '2023-11-04 05:57:19', '[1]', 'O:30:\"ActionScheduler_SimpleSchedule\":2:{s:22:\"\0*\0scheduled_timestamp\";i:1699077439;s:41:\"\0ActionScheduler_SimpleSchedule\0timestamp\";i:1699077439;}', 2, 1, '2023-11-04 05:57:19', '2023-11-04 05:57:19', 0, NULL, 10), (146, 'woocommerce_admin/stored_state_setup_for_products/async/run_remote_notifications', 'complete', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '[]', 'O:28:\"ActionScheduler_NullSchedule\":0:{}', 0, 1, '2023-11-04 06:09:40', '2023-11-04 06:09:40', 0, NULL, 10), (147, 'action_scheduler/migration_hook', 'complete', '2023-11-04 06:21:57', '2023-11-04 06:21:57', '[]', 'O:30:\"ActionScheduler_SimpleSchedule\":2:{s:22:\"\0*\0scheduled_timestamp\";i:1699078917;s:41:\"\0ActionScheduler_SimpleSchedule\0timestamp\";i:1699078917;}', 1, 1, '2023-11-04 06:22:55', '2023-11-04 06:22:55', 0, NULL, 10), (148, 'action_scheduler/migration_hook', 'complete', '2023-11-04 06:31:05', '2023-11-04 06:31:05', '[]', 'O:30:\"ActionScheduler_SimpleSchedule\":2:{s:22:\"\0*\0scheduled_timestamp\";i:1699079465;s:41:\"\0ActionScheduler_SimpleSchedule\0timestamp\";i:1699079465;}', 1, 1, '2023-11-04 06:31:26', '2023-11-04 06:31:26', 0, NULL, 10), (149, 'woocommerce_run_product_attribute_lookup_regeneration_callback', 'complete', '2023-11-04 06:32:28', '2023-11-04 06:32:28', '[]', 'O:30:\"ActionScheduler_SimpleSchedule\":2:{s:22:\"\0*\0scheduled_timestamp\";i:1699079548;s:41:\"\0ActionScheduler_SimpleSchedule\0timestamp\";i:1699079548;}', 3, 1, '2023-11-04 06:32:28', '2023-11-04 06:32:28', 0, NULL, 10), (150, 'woocommerce_run_on_woocommerce_admin_updated', 'complete', '2023-11-04 06:32:27', '2023-11-04 06:32:27', '[]', 'O:30:\"ActionScheduler_SimpleSchedule\":2:{s:22:\"\0*\0scheduled_timestamp\";i:1699079547;s:41:\"\0ActionScheduler_SimpleSchedule\0timestamp\";i:1699079547;}', 4, 1, '2023-11-04 06:32:27', '2023-11-04 06:32:27', 0, NULL, 10), (151, 'woocommerce_cleanup_draft_orders', 'complete', '2023-11-04 06:32:27', '2023-11-04 06:32:27', '[]', 'O:32:\"ActionScheduler_IntervalSchedule\":5:{s:22:\"\0*\0scheduled_timestamp\";i:1699079547;s:18:\"\0*\0first_timestamp\";i:1699079547;s:13:\"\0*\0recurrence\";i:86400;s:49:\"\0ActionScheduler_IntervalSchedule\0start_timestamp\";i:1699079547;s:53:\"\0ActionScheduler_IntervalSchedule\0interval_in_seconds\";i:86400;}', 5, 1, '2023-11-04 06:32:27', '2023-11-04 06:32:27', 0, NULL, 10), (154, 'woocommerce_run_product_attribute_lookup_regeneration_callback', 'complete', '2023-11-04 06:32:56', '2023-11-04 06:32:56', '[]', 'O:30:\"ActionScheduler_SimpleSchedule\":2:{s:22:\"\0*\0scheduled_timestamp\";i:1699079576;s:41:\"\0ActionScheduler_SimpleSchedule\0timestamp\";i:1699079576;}', 3, 1, '2023-11-04 06:33:01', '2023-11-04 06:33:01', 0, NULL, 10), (152, 'woocommerce_cleanup_draft_orders', 'pending', '2023-11-05 06:32:27', '2023-11-05 06:32:27', '[]', 'O:32:\"ActionScheduler_IntervalSchedule\":5:{s:22:\"\0*\0scheduled_timestamp\";i:1699165947;s:18:\"\0*\0first_timestamp\";i:1699079547;s:13:\"\0*\0recurrence\";i:86400;s:49:\"\0ActionScheduler_IntervalSchedule\0start_timestamp\";i:1699165947;s:53:\"\0ActionScheduler_IntervalSchedule\0interval_in_seconds\";i:86400;}', 5, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 10), (153, 'woocommerce_run_product_attribute_lookup_regeneration_callback', 'complete', '2023-11-04 06:32:29', '2023-11-04 06:32:29', '[]', 'O:30:\"ActionScheduler_SimpleSchedule\":2:{s:22:\"\0*\0scheduled_timestamp\";i:1699079549;s:41:\"\0ActionScheduler_SimpleSchedule\0timestamp\";i:1699079549;}', 3, 1, '2023-11-04 06:32:55', '2023-11-04 06:32:55', 0, NULL, 10); -- -------------------------------------------------------- -- -- Table structure for table `wphs_actionscheduler_claims` -- CREATE TABLE `wphs_actionscheduler_claims` ( `claim_id` bigint(20) UNSIGNED NOT NULL, `date_created_gmt` datetime DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wphs_actionscheduler_groups` -- CREATE TABLE `wphs_actionscheduler_groups` ( `group_id` bigint(20) UNSIGNED NOT NULL, `slug` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `wphs_actionscheduler_groups` -- INSERT INTO `wphs_actionscheduler_groups` (`group_id`, `slug`) VALUES (1, 'action-scheduler-migration'), (2, 'wc-admin-data'), (3, 'woocommerce-db-updates'), (4, 'woocommerce-remote-inbox-engine'), (5, ''); -- -------------------------------------------------------- -- -- Table structure for table `wphs_actionscheduler_logs` -- CREATE TABLE `wphs_actionscheduler_logs` ( `log_id` bigint(20) UNSIGNED NOT NULL, `action_id` bigint(20) UNSIGNED NOT NULL, `message` text NOT NULL, `log_date_gmt` datetime DEFAULT '0000-00-00 00:00:00', `log_date_local` datetime DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `wphs_actionscheduler_logs` -- INSERT INTO `wphs_actionscheduler_logs` (`log_id`, `action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (436, 154, 'action complete via Async Request', '2023-11-04 06:33:01', '2023-11-04 06:33:01'), (435, 154, 'action started via Async Request', '2023-11-04 06:33:01', '2023-11-04 06:33:01'), (434, 153, 'action complete via Async Request', '2023-11-04 06:32:55', '2023-11-04 06:32:55'), (433, 154, 'action created', '2023-11-04 06:32:55', '2023-11-04 06:32:55'), (432, 153, 'action started via Async Request', '2023-11-04 06:32:55', '2023-11-04 06:32:55'), (431, 149, 'action complete via WP Cron', '2023-11-04 06:32:28', '2023-11-04 06:32:28'), (429, 149, 'action started via WP Cron', '2023-11-04 06:32:28', '2023-11-04 06:32:28'), (430, 153, 'action created', '2023-11-04 06:32:28', '2023-11-04 06:32:28'), (428, 152, 'action created', '2023-11-04 06:32:28', '2023-11-04 06:32:28'), (427, 151, 'action complete via WP Cron', '2023-11-04 06:32:27', '2023-11-04 06:32:27'), (424, 150, 'action started via WP Cron', '2023-11-04 06:32:27', '2023-11-04 06:32:27'), (425, 150, 'action complete via WP Cron', '2023-11-04 06:32:27', '2023-11-04 06:32:27'), (426, 151, 'action started via WP Cron', '2023-11-04 06:32:27', '2023-11-04 06:32:27'), (423, 151, 'action created', '2023-11-04 06:32:27', '2023-11-04 06:32:27'), (422, 150, 'action created', '2023-11-04 06:32:27', '2023-11-04 06:32:27'), (421, 149, 'action created', '2023-11-04 06:32:27', '2023-11-04 06:32:27'), (419, 148, 'action started via WP Cron', '2023-11-04 06:31:26', '2023-11-04 06:31:26'), (420, 148, 'action complete via WP Cron', '2023-11-04 06:31:26', '2023-11-04 06:31:26'), (418, 148, 'action created', '2023-11-04 06:30:05', '2023-11-04 06:30:05'), (417, 147, 'action complete via WP Cron', '2023-11-04 06:22:55', '2023-11-04 06:22:55'), (391, 139, 'action created', '2023-11-02 07:43:02', '2023-11-02 07:43:02'), (392, 139, 'action started via WP Cron', '2023-11-02 07:43:37', '2023-11-02 07:43:37'), (393, 139, 'action complete via WP Cron', '2023-11-02 07:43:37', '2023-11-02 07:43:37'), (394, 140, 'action created', '2023-11-02 08:49:46', '2023-11-02 08:49:46'), (395, 140, 'action started via WP Cron', '2023-11-02 08:50:19', '2023-11-02 08:50:19'), (396, 140, 'action complete via WP Cron', '2023-11-02 08:50:19', '2023-11-02 08:50:19'), (397, 141, 'action created', '2023-11-02 08:53:54', '2023-11-02 08:53:54'), (398, 141, 'action started via WP Cron', '2023-11-02 08:54:20', '2023-11-02 08:54:20'), (399, 141, 'action complete via WP Cron', '2023-11-02 08:54:20', '2023-11-02 08:54:20'), (400, 142, 'action created', '2023-11-02 09:07:14', '2023-11-02 09:07:14'), (401, 142, 'action started via Async Request', '2023-11-02 09:07:17', '2023-11-02 09:07:17'), (402, 142, 'action complete via Async Request', '2023-11-02 09:07:17', '2023-11-02 09:07:17'), (403, 143, 'action created', '2023-11-02 09:08:11', '2023-11-02 09:08:11'), (404, 143, 'action started via WP Cron', '2023-11-02 09:08:21', '2023-11-02 09:08:21'), (405, 143, 'action complete via WP Cron', '2023-11-02 09:08:21', '2023-11-02 09:08:21'), (406, 144, 'action created', '2023-11-02 09:08:28', '2023-11-02 09:08:28'), (407, 144, 'action started via WP Cron', '2023-11-02 09:09:23', '2023-11-02 09:09:23'), (408, 144, 'action complete via WP Cron', '2023-11-02 09:09:23', '2023-11-02 09:09:23'), (409, 145, 'action created', '2023-11-04 05:57:14', '2023-11-04 05:57:14'), (410, 145, 'action started via WP Cron', '2023-11-04 05:57:19', '2023-11-04 05:57:19'), (411, 145, 'action complete via WP Cron', '2023-11-04 05:57:19', '2023-11-04 05:57:19'), (412, 146, 'action created', '2023-11-04 06:09:32', '2023-11-04 06:09:32'), (413, 146, 'action started via Async Request', '2023-11-04 06:09:40', '2023-11-04 06:09:40'), (414, 146, 'action complete via Async Request', '2023-11-04 06:09:40', '2023-11-04 06:09:40'), (415, 147, 'action created', '2023-11-04 06:20:57', '2023-11-04 06:20:57'), (416, 147, 'action started via WP Cron', '2023-11-04 06:22:55', '2023-11-04 06:22:55'); -- -------------------------------------------------------- -- -- Table structure for table `wphs_commentmeta` -- CREATE TABLE `wphs_commentmeta` ( `meta_id` bigint(20) UNSIGNED NOT NULL, `comment_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wphs_comments` -- CREATE TABLE `wphs_comments` ( `comment_ID` bigint(20) UNSIGNED NOT NULL, `comment_post_ID` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `comment_author` tinytext NOT NULL, `comment_author_email` varchar(100) NOT NULL DEFAULT '', `comment_author_url` varchar(200) NOT NULL DEFAULT '', `comment_author_IP` varchar(100) NOT NULL DEFAULT '', `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_content` text NOT NULL, `comment_karma` int(11) NOT NULL DEFAULT 0, `comment_approved` varchar(20) NOT NULL DEFAULT '1', `comment_agent` varchar(255) NOT NULL DEFAULT '', `comment_type` varchar(20) NOT NULL DEFAULT 'comment', `comment_parent` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `wphs_comments` -- INSERT INTO `wphs_comments` (`comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`, `comment_author_url`, `comment_author_IP`, `comment_date`, `comment_date_gmt`, `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`) VALUES (1, 1, 'A WordPress Commenter', 'wapuu@wordpress.example', 'https://wordpress.org/', '', '2021-10-14 07:41:35', '2021-10-14 07:41:35', 'Hi, this is a comment.\nTo get started with moderating, editing, and deleting comments, please visit the Comments screen in the dashboard.\nCommenter avatars come from Gravatar.', 0, '1', '', 'comment', 0, 0), (2, 824, 'John', 'john@livewp.site', '', '172.68.239.117', '2019-09-18 11:11:59', '2019-09-18 11:11:59', 'Sed virtute suavitate suscipiantur ea, dolor this can eloquentiam ei pro. Suas adversarium interpretaris eu sit, eum viris impedit ne.', 0, '1', '', 'comment', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `wphs_e_events` -- CREATE TABLE `wphs_e_events` ( `id` bigint(20) UNSIGNED NOT NULL, `event_data` text DEFAULT NULL, `created_at` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wphs_e_submissions` -- CREATE TABLE `wphs_e_submissions` ( `id` bigint(20) UNSIGNED NOT NULL, `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 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wphs_e_submissions_actions_log` -- CREATE TABLE `wphs_e_submissions_actions_log` ( `id` bigint(20) UNSIGNED NOT NULL, `submission_id` bigint(20) UNSIGNED NOT NULL, `action_name` varchar(60) NOT NULL, `action_label` varchar(60) DEFAULT NULL, `status` varchar(20) NOT NULL, `log` 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 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wphs_e_submissions_values` -- CREATE TABLE `wphs_e_submissions_values` ( `id` bigint(20) UNSIGNED NOT NULL, `submission_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `key` varchar(60) DEFAULT NULL, `value` longtext DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wphs_gf_draft_submissions` -- CREATE TABLE `wphs_gf_draft_submissions` ( `uuid` char(32) NOT NULL, `email` varchar(255) DEFAULT NULL, `form_id` mediumint(10) UNSIGNED NOT NULL, `date_created` datetime NOT NULL, `ip` varchar(45) NOT NULL, `source_url` longtext NOT NULL, `submission` longtext NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wphs_gf_entry` -- CREATE TABLE `wphs_gf_entry` ( `id` int(10) UNSIGNED NOT NULL, `form_id` mediumint(10) UNSIGNED NOT NULL, `post_id` bigint(10) UNSIGNED DEFAULT NULL, `date_created` datetime NOT NULL, `date_updated` datetime DEFAULT NULL, `is_starred` tinyint(10) NOT NULL DEFAULT 0, `is_read` tinyint(10) NOT NULL DEFAULT 0, `ip` varchar(45) NOT NULL, `source_url` varchar(200) NOT NULL DEFAULT '', `user_agent` varchar(250) NOT NULL DEFAULT '', `currency` varchar(5) DEFAULT NULL, `payment_status` varchar(15) DEFAULT NULL, `payment_date` datetime DEFAULT NULL, `payment_amount` decimal(19,2) DEFAULT NULL, `payment_method` varchar(30) DEFAULT NULL, `transaction_id` varchar(50) DEFAULT NULL, `is_fulfilled` tinyint(10) DEFAULT NULL, `created_by` bigint(10) UNSIGNED DEFAULT NULL, `transaction_type` tinyint(10) DEFAULT NULL, `status` varchar(20) NOT NULL DEFAULT 'active' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `wphs_gf_entry` -- INSERT INTO `wphs_gf_entry` (`id`, `form_id`, `post_id`, `date_created`, `date_updated`, `is_starred`, `is_read`, `ip`, `source_url`, `user_agent`, `currency`, `payment_status`, `payment_date`, `payment_amount`, `payment_method`, `transaction_id`, `is_fulfilled`, `created_by`, `transaction_type`, `status`) VALUES (1, 4, NULL, '2023-04-11 05:45:41', '2023-04-11 05:45:41', 0, 0, '92.38.148.53', 'https://generation.digitalengage.dev/contact-us/newsletters/', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36', 'USD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active'), (2, 2, NULL, '2023-05-26 13:12:48', '2023-05-26 13:12:48', 0, 0, '23.229.90.56', 'https://generation.digitalengage.dev/contact-us/', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; Xbox; Xbox One) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Edge/44.18363.8131', 'USD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active'), (3, 2, NULL, '2023-06-05 14:29:09', '2023-06-05 14:29:09', 0, 0, '38.170.31.4', 'https://generation.digitalengage.dev/contact-us/', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Vivaldi/5.3.2679.68', 'USD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active'), (4, 2, NULL, '2023-07-11 01:59:04', '2023-07-11 01:59:04', 0, 0, '185.222.36.255', 'https://generation.digitalengage.dev/contact-us/', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Vivaldi/5.3.2679.68', 'USD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active'); -- -------------------------------------------------------- -- -- Table structure for table `wphs_gf_entry_meta` -- CREATE TABLE `wphs_gf_entry_meta` ( `id` bigint(10) UNSIGNED NOT NULL, `form_id` mediumint(10) UNSIGNED NOT NULL DEFAULT 0, `entry_id` bigint(10) UNSIGNED NOT NULL, `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext DEFAULT NULL, `item_index` varchar(60) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `wphs_gf_entry_meta` -- INSERT INTO `wphs_gf_entry_meta` (`id`, `form_id`, `entry_id`, `meta_key`, `meta_value`, `item_index`) VALUES (1, 4, 1, '1', 'Shane', ''), (2, 4, 1, '2', 'K', ''), (3, 4, 1, '3', 'pat@aneesho.com', ''), (4, 4, 1, '4', '(810) 244-0753', ''), (5, 4, 1, '13.2', 'Shepard\'s Staff', ''), (6, 4, 1, '8', '10007', ''), (7, 4, 1, '5', 'Just wanted to ask if you would be interested in getting external help with graphic design? We do all design work like banners, advertisements, brochures, logos, flyers, etc. for a fixed monthly fee. \r\n\r\nWe don\'t charge for each task. What kind of work do you need on a regular basis? Let me know and I\'ll share my portfolio with you.', ''), (8, 2, 2, '1', 'Katie', ''), (9, 2, 2, '2', 'Simpson', ''), (10, 2, 2, '3', 'simpsonkatie917@gmail.com', ''), (11, 2, 2, '4', '(704) 685-3608', ''), (12, 2, 2, '5', 'Hi,\r\n\r\nWe\'d like to introduce to you our explainer video service, which we feel can benefit your site generation.digitalengage.dev.\r\n\r\nCheck out some of our existing videos here:\r\n\r\nhttps://www.youtube.com/watch?v=zvGF7uRfH04\r\nhttps://www.youtube.com/watch?v=cZPsp217Iik\r\nhttps://www.youtube.com/watch?v=JHfnqS2zpU8\r\n\r\nAll of our videos are in a similar animated format as the above examples, and we have voice over artists with US/UK/Australian accents.\r\nWe can also produce voice overs in languages other than English.\r\n\r\nThey can show a solution to a problem or simply promote one of your products or services. They are concise, can be uploaded to video sites such as YouTube, and can be embedded into your website or featured on landing pages.\r\n\r\nOur prices are as follows depending on video length:\r\n30 seconds = $195\r\n1 minute = $239\r\n1-2 minutes = $339\r\n2-3 minutes = $439\r\n\r\n*All prices above are in USD and include a full script, voice-over and video.\r\n\r\nIf this is something you would like to discuss further, don\'t hesitate to reply.\r\n\r\nKind Regards,\r\nKatie', ''), (13, 2, 3, '1', 'Elbert', ''), (14, 2, 3, '2', 'Westbury', ''), (15, 2, 3, '3', 'elbert.westbury@gmail.com', ''), (16, 2, 3, '5', 'Hi there,\r\n\r\nWe would like to introduce to you Robin A.I., the world\'s first app that replaces your entire team with an AI assistant. This powerful tool generates human-like content, creates stunning designs, drives unlimited traffic, and more.\r\n\r\nSay goodbye to costly subscriptions and hello to an all-in-one solution. With zero upfront costs and a 30-day money-back guarantee, Robin A.I. empowers you to start your own AI-powered business and achieve unparalleled efficiency.\r\n\r\nDon\'t miss this opportunity to revolutionize your workflow and boost your success.\r\n\r\nDiscover the game-changing capabilities of Robin A.I. today: https://t.ly/WGpr\r\n\r\nElbert', ''), (17, 2, 4, '1', 'Danielle', ''), (18, 2, 4, '2', 'Simpson', ''), (19, 2, 4, '3', 'simpsondanielle800@gmail.com', ''), (20, 2, 4, '4', '(831) 921-1568', ''), (21, 2, 4, '5', 'Hi,\r\n\r\nWe\'d like to introduce to you our explainer video service, which we feel can benefit your site generation.digitalengage.dev.\r\n\r\nCheck out some of our existing videos here:\r\n\r\nhttps://www.youtube.com/watch?v=zvGF7uRfH04\r\nhttps://www.youtube.com/watch?v=cZPsp217Iik\r\nhttps://www.youtube.com/watch?v=JHfnqS2zpU8\r\n\r\nAll of our videos are in a similar animated format as the above examples, and we have voice over artists with US/UK/Australian accents.\r\nWe can also produce voice overs in languages other than English.\r\n\r\nThey can show a solution to a problem or simply promote one of your products or services. They are concise, can be uploaded to video sites such as YouTube, and can be embedded into your website or featured on landing pages.\r\n\r\nOur prices are as follows depending on video length:\r\nUp to 1 minute = $239\r\n1-2 minutes = $339\r\n2-3 minutes = $439\r\n\r\n*All prices above are in USD and include a full script, voice-over and video.\r\n\r\nIf this is something you would like to discuss further, don\'t hesitate to reply.\r\n\r\nKind Regards,\r\nDanielle', ''); -- -------------------------------------------------------- -- -- Table structure for table `wphs_gf_entry_notes` -- CREATE TABLE `wphs_gf_entry_notes` ( `id` int(10) UNSIGNED NOT NULL, `entry_id` int(10) UNSIGNED NOT NULL, `user_name` varchar(250) DEFAULT NULL, `user_id` bigint(10) DEFAULT NULL, `date_created` datetime NOT NULL, `value` longtext DEFAULT NULL, `note_type` varchar(50) DEFAULT NULL, `sub_type` varchar(50) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wphs_gf_form` -- CREATE TABLE `wphs_gf_form` ( `id` mediumint(10) UNSIGNED NOT NULL, `title` varchar(150) NOT NULL, `date_created` datetime NOT NULL, `date_updated` datetime DEFAULT NULL, `is_active` tinyint(10) NOT NULL DEFAULT 1, `is_trash` tinyint(10) NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `wphs_gf_form` -- INSERT INTO `wphs_gf_form` (`id`, `title`, `date_created`, `date_updated`, `is_active`, `is_trash`) VALUES (1, 'Subcription', '2021-10-14 08:53:40', NULL, 1, 0), (2, 'Contact Us', '2021-10-14 08:53:40', NULL, 1, 0), (3, 'Stay Connected', '2021-10-14 14:19:40', NULL, 1, 0), (4, 'General', '2022-08-09 07:07:04', NULL, 1, 0), (5, 'Leadership', '2022-08-09 07:08:59', NULL, 1, 0), (6, 'Prayer Team', '2022-08-09 07:09:43', NULL, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `wphs_gf_form_meta` -- CREATE TABLE `wphs_gf_form_meta` ( `form_id` mediumint(10) UNSIGNED NOT NULL, `display_meta` longtext DEFAULT NULL, `entries_grid_meta` longtext DEFAULT NULL, `confirmations` longtext DEFAULT NULL, `notifications` longtext DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `wphs_gf_form_meta` -- INSERT INTO `wphs_gf_form_meta` (`form_id`, `display_meta`, `entries_grid_meta`, `confirmations`, `notifications`) VALUES (1, '{\"title\":\"Subcription\",\"description\":\"\",\"labelPlacement\":\"top_label\",\"descriptionPlacement\":\"below\",\"button\":{\"type\":\"text\",\"text\":\"Submit\",\"imageUrl\":\"\"},\"fields\":[{\"type\":\"email\",\"id\":3,\"label\":\"Email\",\"adminLabel\":\"Email\",\"isRequired\":false,\"size\":\"large\",\"errorMessage\":\"\",\"visibility\":\"visible\",\"inputs\":null,\"formId\":1,\"description\":\"\",\"allowsPrepopulate\":false,\"inputMask\":false,\"inputMaskValue\":\"\",\"inputMaskIsCustom\":false,\"maxLength\":\"\",\"inputType\":\"\",\"labelPlacement\":\"\",\"descriptionPlacement\":\"\",\"subLabelPlacement\":\"\",\"placeholder\":\"Email\",\"cssClass\":\"\",\"inputName\":\"\",\"noDuplicates\":false,\"defaultValue\":\"\",\"choices\":\"\",\"conditionalLogic\":\"\",\"productField\":\"\",\"emailConfirmEnabled\":\"\",\"multipleFiles\":false,\"maxFiles\":\"\",\"calculationFormula\":\"\",\"calculationRounding\":\"\",\"enableCalculation\":\"\",\"disableQuantity\":false,\"displayAllCategories\":false,\"useRichTextEditor\":false,\"fields\":\"\",\"displayOnly\":\"\",\"pageNumber\":1},{\"type\":\"html\",\"id\":2,\"label\":\"\",\"adminLabel\":\"\",\"isRequired\":false,\"size\":\"medium\",\"errorMessage\":\"\",\"visibility\":\"visible\",\"inputs\":null,\"displayOnly\":true,\"formId\":1,\"description\":\"\",\"allowsPrepopulate\":false,\"inputMask\":false,\"inputMaskValue\":\"\",\"inputMaskIsCustom\":false,\"maxLength\":\"\",\"inputType\":\"\",\"labelPlacement\":\"\",\"descriptionPlacement\":\"\",\"subLabelPlacement\":\"\",\"placeholder\":\"\",\"cssClass\":\"\",\"inputName\":\"\",\"noDuplicates\":false,\"defaultValue\":\"\",\"choices\":\"\",\"conditionalLogic\":\"\",\"content\":\"
\\n