-- Softaculous SQL Dump
-- http://www.softaculous.com
--




--
-- Database: `quickdentalcom_qdc`
--

-- --------------------------------------------------------

--
-- Table structure for table `qdc_2_e_events`
--

CREATE TABLE `qdc_2_e_events` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `event_data` text DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_at_index` (`created_at`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_2_e_events`
--

INSERT INTO `qdc_2_e_events` VALUES
(1, '{"event":"modal load","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"account\\",\\"user_state\\":\\"anon\\"}","ts":"2024-10-18T02:20:13.505-06:00"}', '2024-10-18 02:20:13'),
(2, '{"event":"modal load","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"account\\",\\"user_state\\":\\"anon\\"}","ts":"2024-10-18T02:20:26.256-06:00"}', '2024-10-18 02:20:26'),
(3, '{"event":"modal load","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\",\\"user_state\\":\\"anon\\"}","ts":"2024-10-18T02:20:38.209-06:00"}', '2024-10-18 02:20:38'),
(4, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"account\\"}","ts":"2024-10-18T02:20:38.160-06:00"}', '2024-10-18 02:20:38'),
(5, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:20:49.372-06:00"}', '2024-10-18 02:20:49'),
(6, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:20:54.810-06:00"}', '2024-10-18 02:20:54'),
(7, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:20:57.640-06:00"}', '2024-10-18 02:20:57'),
(8, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:21:07.251-06:00"}', '2024-10-18 02:21:07'),
(9, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:21:07.992-06:00"}', '2024-10-18 02:21:07'),
(10, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:21:08.190-06:00"}', '2024-10-18 02:21:08'),
(11, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:21:08.412-06:00"}', '2024-10-18 02:21:08'),
(12, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:21:08.776-06:00"}', '2024-10-18 02:21:08'),
(13, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:21:09.232-06:00"}', '2024-10-18 02:21:09'),
(14, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:21:09.510-06:00"}', '2024-10-18 02:21:09'),
(15, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:21:10.230-06:00"}', '2024-10-18 02:21:10'),
(16, '{"event":"modal load","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\",\\"user_state\\":\\"anon\\"}","ts":"2024-10-18T02:21:15.666-06:00"}', '2024-10-18 02:21:15'),
(17, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:21:18.937-06:00"}', '2024-10-18 02:21:18'),
(18, '{"event":"modal load","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"account\\",\\"user_state\\":\\"anon\\"}","ts":"2024-10-18T02:21:50.605-06:00"}', '2024-10-18 02:21:50'),
(19, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"account\\"}","ts":"2024-10-18T02:21:55.820-06:00"}', '2024-10-18 02:21:55'),
(20, '{"event":"modal load","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\",\\"user_state\\":\\"anon\\"}","ts":"2024-10-18T02:21:55.831-06:00"}', '2024-10-18 02:21:55'),
(21, '{"event":"modal load","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"goodToGo\\",\\"user_state\\":\\"anon\\"}","ts":"2024-10-18T02:21:57.662-06:00"}', '2024-10-18 02:21:57'),
(22, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"chooseFeatures\\"}","ts":"2024-10-18T02:21:57.654-06:00"}', '2024-10-18 02:21:57'),
(23, '{"event":"skip","version":"","details":"{\\"placement\\":\\"Onboarding wizard\\",\\"step\\":\\"goodToGo\\"}","ts":"2024-10-18T02:22:08.191-06:00"}', '2024-10-18 02:22:08');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_2_e_submissions`
--

CREATE TABLE `qdc_2_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;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_2_e_submissions_actions_log`
--

CREATE TABLE `qdc_2_e_submissions_actions_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `submission_id_index` (`submission_id`),
  KEY `action_name_index` (`action_name`),
  KEY `status_index` (`status`),
  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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_2_e_submissions_values`
--

CREATE TABLE `qdc_2_e_submissions_values` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `submission_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `key` varchar(60) DEFAULT NULL,
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `submission_id_index` (`submission_id`),
  KEY `key_index` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_actionscheduler_actions`
--

CREATE TABLE `qdc_actionscheduler_actions` (
  `action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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',
  `priority` tinyint(3) unsigned NOT NULL DEFAULT 10,
  `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,
  PRIMARY KEY (`action_id`),
  KEY `hook_status_scheduled_date_gmt` (`hook`(163),`status`,`scheduled_date_gmt`),
  KEY `status_scheduled_date_gmt` (`status`,`scheduled_date_gmt`),
  KEY `scheduled_date_gmt` (`scheduled_date_gmt`),
  KEY `args` (`args`),
  KEY `group_id` (`group_id`),
  KEY `last_attempt_gmt` (`last_attempt_gmt`),
  KEY `claim_id_status_scheduled_date_gmt` (`claim_id`,`status`,`scheduled_date_gmt`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_actionscheduler_actions`
--

INSERT INTO `qdc_actionscheduler_actions` VALUES
(12748, 'action_scheduler/migration_hook', 'complete', '2024-10-12 07:34:03', '2024-10-12 07:34:03', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728718443;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728718443;}', 1, 1, '2024-10-12 07:34:16', '2024-10-12 13:34:16', 0, NULL),
(12749, 'woocommerce_cleanup_draft_orders', 'complete', '2024-10-12 07:33:04', '2024-10-12 07:33:04', 10, '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1728718384;s:18:"\0*\0first_timestamp";i:1728718384;s:13:"\0*\0recurrence";i:86400;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1728718384;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:86400;}', 2, 1, '2024-10-12 07:34:10', '2024-10-12 13:34:10', 0, NULL),
(12750, 'woocommerce_install_assembler_fonts', 'complete', '2024-10-12 07:33:22', '2024-10-12 07:33:22', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728718402;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728718402;}', 2, 1, '2024-10-12 07:34:16', '2024-10-12 13:34:16', 0, NULL),
(12751, 'fetch_patterns', 'complete', '2024-10-12 07:33:22', '2024-10-12 07:33:22', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728718402;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728718402;}', 2, 1, '2024-10-12 07:34:16', '2024-10-12 13:34:16', 0, NULL),
(12752, 'woocommerce_cleanup_draft_orders', 'failed', '2024-10-13 07:34:10', '2024-10-13 07:34:10', 10, '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1728804850;s:18:"\0*\0first_timestamp";i:1728718384;s:13:"\0*\0recurrence";i:86400;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1728804850;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:86400;}', 2, 1, '2024-10-17 20:49:01', '2024-10-18 02:49:01', 0, NULL),
(12753, 'woocommerce_plugins_install_and_activate_async_callback', 'failed', '2024-10-12 07:34:48', '2024-10-12 07:34:48', 10, '[["google-listings-and-ads","mailchimp-for-woocommerce","jetpack"],"670a26986620d"]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728718488;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728718488;}', 2, 1, '2024-10-12 07:35:12', '2024-10-12 13:35:12', 5, NULL),
(12754, 'woocommerce_run_product_attribute_lookup_update_callback', 'complete', '2024-10-12 07:43:02', '2024-10-12 07:43:02', 10, '[12799,1]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728718982;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728718982;}', 3, 1, '2024-10-12 07:43:25', '2024-10-12 13:43:25', 0, NULL),
(12755, 'woocommerce_update_marketplace_suggestions', 'complete', '2024-10-12 07:43:02', '2024-10-12 07:43:02', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728718982;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728718982;}', 2, 1, '2024-10-12 07:43:25', '2024-10-12 13:43:25', 0, NULL),
(12756, 'woocommerce_run_product_attribute_lookup_update_callback', 'complete', '2024-10-12 07:44:34', '2024-10-12 07:44:34', 10, '[12799,3]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728719074;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728719074;}', 3, 1, '2024-10-12 07:44:58', '2024-10-12 13:44:58', 0, NULL),
(12757, 'fetch_patterns', 'complete', '2024-10-12 09:51:49', '2024-10-12 09:51:49', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728726709;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728726709;}', 2, 1, '2024-10-12 09:52:09', '2024-10-12 15:52:09', 0, NULL),
(12758, 'action_scheduler/migration_hook', 'complete', '2024-10-12 09:52:49', '2024-10-12 09:52:49', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728726769;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728726769;}', 1, 1, '2024-10-12 09:53:21', '2024-10-12 15:53:21', 0, NULL),
(12759, 'fetch_patterns', 'complete', '2024-10-12 10:51:50', '2024-10-12 10:51:50', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728730310;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728730310;}', 2, 1, '2024-10-12 10:54:10', '2024-10-12 16:54:10', 0, NULL),
(12760, 'action_scheduler/migration_hook', 'complete', '2024-10-12 11:19:29', '2024-10-12 11:19:29', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728731969;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728731969;}', 1, 1, '2024-10-12 11:20:00', '2024-10-12 17:20:00', 0, NULL),
(12761, 'fetch_patterns', 'complete', '2024-10-12 11:52:29', '2024-10-12 11:52:29', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728733949;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728733949;}', 2, 1, '2024-10-12 11:52:30', '2024-10-12 17:52:30', 0, NULL),
(12762, 'fetch_patterns', 'complete', '2024-10-12 12:52:59', '2024-10-12 12:52:59', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728737579;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728737579;}', 2, 1, '2024-10-12 12:53:32', '2024-10-12 18:53:32', 0, NULL),
(12763, 'action_scheduler/migration_hook', 'complete', '2024-10-12 12:53:59', '2024-10-12 12:53:59', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728737639;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728737639;}', 1, 1, '2024-10-12 12:54:12', '2024-10-12 18:54:12', 0, NULL),
(12764, 'action_scheduler/migration_hook', 'complete', '2024-10-12 12:55:27', '2024-10-12 12:55:27', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728737727;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728737727;}', 1, 1, '2024-10-12 12:55:33', '2024-10-12 18:55:33', 0, NULL),
(12765, 'action_scheduler/migration_hook', 'failed', '2024-10-12 12:56:33', '2024-10-12 12:56:33', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728737793;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728737793;}', 1, 1, '2024-10-12 12:57:32', '2024-10-12 18:57:32', 0, NULL),
(12766, 'action_scheduler/migration_hook', 'complete', '2024-10-12 13:13:40', '2024-10-12 13:13:40', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1728738820;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1728738820;}', 1, 1, '2024-10-17 20:49:01', '2024-10-18 02:49:01', 0, NULL),
(12767, 'woocommerce_cleanup_draft_orders', 'pending', '2024-10-18 20:49:01', '2024-10-18 20:49:01', 10, '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1729284541;s:18:"\0*\0first_timestamp";i:1728718384;s:13:"\0*\0recurrence";i:86400;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1729284541;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:86400;}', 2, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL),
(12768, 'action_scheduler/migration_hook', 'complete', '2024-10-17 21:05:00', '2024-10-17 21:05:00', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729199100;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729199100;}', 1, 1, '2024-10-17 21:05:02', '2024-10-18 03:05:02', 0, NULL),
(12769, 'action_scheduler/migration_hook', 'complete', '2024-10-17 21:12:13', '2024-10-17 21:12:13', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729199533;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729199533;}', 1, 1, '2024-10-17 21:12:59', '2024-10-18 03:12:59', 0, NULL),
(12770, 'action_scheduler/migration_hook', 'complete', '2024-10-17 21:23:54', '2024-10-17 21:23:54', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729200234;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729200234;}', 1, 1, '2024-10-17 21:24:00', '2024-10-18 03:24:00', 0, NULL),
(12771, 'rank_math/analytics/sync_sitemaps', 'complete', '2024-10-17 21:29:01', '2024-10-17 21:29:01', 10, '[]', 'O:28:"ActionScheduler_NullSchedule":0:{}', 4, 1, '2024-10-17 21:29:26', '2024-10-18 03:29:26', 0, NULL),
(12772, 'rank_math/analytics/data_fetch', 'complete', '2024-10-18 13:57:00', '2024-10-18 13:57:00', 10, '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1729259820;s:18:"\0*\0first_timestamp";i:1729259820;s:13:"\0*\0recurrence";i:259200;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1729259820;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:259200;}', 4, 1, '2024-10-18 13:59:38', '2024-10-18 19:59:38', 0, NULL),
(12773, 'rank_math/analytics/flat_posts', 'complete', '2024-10-17 21:30:53', '2024-10-17 21:30:53', 10, '[[12880,12830,12751,12686,13,3]]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729200653;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729200653;}', 4, 1, '2024-10-17 21:31:01', '2024-10-18 03:31:01', 0, NULL),
(12774, 'rank_math/analytics/flat_posts_completed', 'complete', '2024-10-17 21:31:23', '2024-10-17 21:31:23', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729200683;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729200683;}', 4, 1, '2024-10-17 21:32:01', '2024-10-18 03:32:01', 0, NULL),
(12775, 'rank_math/analytics/clear_cache', 'canceled', '2024-10-17 21:31:53', '2024-10-17 21:31:53', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729200713;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729200713;}', 4, 0, '2024-10-17 21:32:01', '2024-10-18 03:32:01', 0, NULL),
(12776, 'rank_math/analytics/workflow', 'complete', '2024-10-17 21:30:23', '2024-10-17 21:30:23', 10, '["console",90,[],{"country":"all","profile":"https:\\/\\/quickdental.com.bd\\/","enable_index_status":true}]', 'O:28:"ActionScheduler_NullSchedule":0:{}', 4, 1, '2024-10-17 21:31:01', '2024-10-18 03:31:01', 0, NULL),
(12777, 'rank_math/analytics/workflow', 'complete', '2024-10-17 21:32:01', '2024-10-17 21:32:01', 10, '["inspections",0,null,null]', 'O:28:"ActionScheduler_NullSchedule":0:{}', 4, 1, '2024-10-17 21:32:01', '2024-10-18 03:32:01', 0, NULL),
(12778, 'rank_math/analytics/get_inspections_data', 'complete', '2024-10-17 21:32:08', '2024-10-17 21:32:08', 10, '["\\/appointment-details\\/"]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729200728;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729200728;}', 4, 1, '2024-10-17 21:33:09', '2024-10-18 03:33:09', 0, NULL),
(12779, 'rank_math/analytics/get_inspections_data', 'complete', '2024-10-17 21:32:15', '2024-10-17 21:32:15', 10, '["\\/privacy-policy\\/"]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729200735;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729200735;}', 4, 1, '2024-10-17 21:33:24', '2024-10-18 03:33:24', 0, NULL),
(12780, 'rank_math/analytics/get_inspections_data', 'complete', '2024-10-17 21:32:22', '2024-10-17 21:32:22', 10, '["\\/loginpress\\/"]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729200742;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729200742;}', 4, 1, '2024-10-17 21:33:38', '2024-10-18 03:33:38', 0, NULL),
(12781, 'rank_math/analytics/get_inspections_data', 'complete', '2024-10-17 21:32:29', '2024-10-17 21:32:29', 10, '["\\/blog\\/bwg_gallery\\/gallery\\/"]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729200749;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729200749;}', 4, 1, '2024-10-17 21:33:53', '2024-10-18 03:33:53', 0, NULL),
(12782, 'rank_math/analytics/get_inspections_data', 'complete', '2024-10-17 21:32:36', '2024-10-17 21:32:36', 10, '["\\/my-account\\/"]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729200756;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729200756;}', 4, 1, '2024-10-17 21:34:07', '2024-10-18 03:34:07', 0, NULL),
(12783, 'rank_math/analytics/get_inspections_data', 'complete', '2024-10-17 21:32:43', '2024-10-17 21:32:43', 10, '["\\/12830-2\\/"]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729200763;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729200763;}', 4, 1, '2024-10-17 21:34:22', '2024-10-18 03:34:22', 0, NULL),
(12784, 'action_scheduler/migration_hook', 'complete', '2024-10-18 09:56:48', '2024-10-18 09:56:48', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729245408;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729245408;}', 1, 1, '2024-10-18 09:56:53', '2024-10-18 15:56:53', 0, NULL),
(12785, 'action_scheduler/migration_hook', 'failed', '2024-10-18 09:57:53', '2024-10-18 09:57:53', 10, '[]', 'O:30:"ActionScheduler_SimpleSchedule":2:{s:22:"\0*\0scheduled_timestamp";i:1729245473;s:41:"\0ActionScheduler_SimpleSchedule\0timestamp";i:1729245473;}', 1, 1, '2024-10-18 09:58:53', '2024-10-18 15:58:53', 0, NULL),
(12786, 'rank_math/analytics/workflow', 'complete', '2024-10-18 13:59:38', '2024-10-18 13:59:38', 10, '["console",90,null,null]', 'O:28:"ActionScheduler_NullSchedule":0:{}', 4, 1, '2024-10-18 13:59:40', '2024-10-18 19:59:40', 0, NULL),
(12787, 'rank_math/analytics/data_fetch', 'pending', '2024-10-21 13:59:38', '2024-10-21 13:59:38', 10, '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1729519178;s:18:"\0*\0first_timestamp";i:1729259820;s:13:"\0*\0recurrence";i:259200;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1729519178;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:259200;}', 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_actionscheduler_claims`
--

CREATE TABLE `qdc_actionscheduler_claims` (
  `claim_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date_created_gmt` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`claim_id`),
  KEY `date_created_gmt` (`date_created_gmt`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_actionscheduler_claims`
--

INSERT INTO `qdc_actionscheduler_claims` VALUES
(5, '2024-10-12 07:35:12');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_actionscheduler_groups`
--

CREATE TABLE `qdc_actionscheduler_groups` (
  `group_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  PRIMARY KEY (`group_id`),
  KEY `slug` (`slug`(191))
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_actionscheduler_groups`
--

INSERT INTO `qdc_actionscheduler_groups` VALUES
(1, 'action-scheduler-migration'),
(2, ''),
(3, 'woocommerce-db-updates'),
(4, 'rank-math');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_actionscheduler_logs`
--

CREATE TABLE `qdc_actionscheduler_logs` (
  `log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`log_id`),
  KEY `action_id` (`action_id`),
  KEY `log_date_gmt` (`log_date_gmt`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_actionscheduler_logs`
--

INSERT INTO `qdc_actionscheduler_logs` VALUES
(1, 12748, 'action created', '2024-10-12 07:33:03', '2024-10-12 07:33:03'),
(2, 12749, 'action created', '2024-10-12 07:33:04', '2024-10-12 07:33:04'),
(3, 12750, 'action created', '2024-10-12 07:33:22', '2024-10-12 07:33:22'),
(4, 12751, 'action created', '2024-10-12 07:33:22', '2024-10-12 07:33:22'),
(5, 12749, 'action started via Async Request', '2024-10-12 07:34:10', '2024-10-12 07:34:10'),
(6, 12749, 'action complete via Async Request', '2024-10-12 07:34:10', '2024-10-12 07:34:10'),
(7, 12752, 'action created', '2024-10-12 07:34:10', '2024-10-12 07:34:10'),
(8, 12750, 'action started via Async Request', '2024-10-12 07:34:10', '2024-10-12 07:34:10'),
(9, 12750, 'action complete via Async Request', '2024-10-12 07:34:16', '2024-10-12 07:34:16'),
(10, 12751, 'action started via Async Request', '2024-10-12 07:34:16', '2024-10-12 07:34:16'),
(11, 12751, 'action complete via Async Request', '2024-10-12 07:34:16', '2024-10-12 07:34:16'),
(12, 12748, 'action started via Async Request', '2024-10-12 07:34:16', '2024-10-12 07:34:16'),
(13, 12748, 'action complete via Async Request', '2024-10-12 07:34:16', '2024-10-12 07:34:16'),
(14, 12753, 'action created', '2024-10-12 07:34:48', '2024-10-12 07:34:48'),
(15, 12753, 'action started via WP Cron', '2024-10-12 07:35:12', '2024-10-12 07:35:12'),
(16, 12753, 'action marked as failed after 300 seconds. Unknown error occurred. Check server, PHP and database error logs to diagnose cause.', '2024-10-12 07:40:26', '2024-10-12 07:40:26'),
(17, 12754, 'action created', '2024-10-12 07:43:01', '2024-10-12 07:43:01'),
(18, 12755, 'action created', '2024-10-12 07:43:02', '2024-10-12 07:43:02'),
(19, 12754, 'action started via Async Request', '2024-10-12 07:43:25', '2024-10-12 07:43:25'),
(20, 12754, 'action complete via Async Request', '2024-10-12 07:43:25', '2024-10-12 07:43:25'),
(21, 12755, 'action started via Async Request', '2024-10-12 07:43:25', '2024-10-12 07:43:25'),
(22, 12755, 'action complete via Async Request', '2024-10-12 07:43:25', '2024-10-12 07:43:25'),
(23, 12756, 'action created', '2024-10-12 07:44:33', '2024-10-12 07:44:33'),
(24, 12756, 'action started via WP Cron', '2024-10-12 07:44:58', '2024-10-12 07:44:58'),
(25, 12756, 'action complete via WP Cron', '2024-10-12 07:44:58', '2024-10-12 07:44:58'),
(26, 12757, 'action created', '2024-10-12 09:51:49', '2024-10-12 09:51:49'),
(27, 12758, 'action created', '2024-10-12 09:51:49', '2024-10-12 09:51:49'),
(28, 12757, 'action started via WP Cron', '2024-10-12 09:52:09', '2024-10-12 09:52:09'),
(29, 12757, 'action complete via WP Cron', '2024-10-12 09:52:09', '2024-10-12 09:52:09'),
(30, 12758, 'action started via WP Cron', '2024-10-12 09:53:21', '2024-10-12 09:53:21'),
(31, 12758, 'action complete via WP Cron', '2024-10-12 09:53:21', '2024-10-12 09:53:21'),
(32, 12759, 'action created', '2024-10-12 10:51:50', '2024-10-12 10:51:50'),
(33, 12759, 'action started via WP Cron', '2024-10-12 10:54:10', '2024-10-12 10:54:10'),
(34, 12759, 'action complete via WP Cron', '2024-10-12 10:54:10', '2024-10-12 10:54:10'),
(35, 12760, 'action created', '2024-10-12 11:18:29', '2024-10-12 11:18:29'),
(36, 12760, 'action started via WP Cron', '2024-10-12 11:20:00', '2024-10-12 11:20:00'),
(37, 12760, 'action complete via WP Cron', '2024-10-12 11:20:00', '2024-10-12 11:20:00'),
(38, 12761, 'action created', '2024-10-12 11:52:29', '2024-10-12 11:52:29'),
(39, 12761, 'action started via WP Cron', '2024-10-12 11:52:30', '2024-10-12 11:52:30'),
(40, 12761, 'action complete via WP Cron', '2024-10-12 11:52:30', '2024-10-12 11:52:30'),
(41, 12762, 'action created', '2024-10-12 12:52:59', '2024-10-12 12:52:59'),
(42, 12763, 'action created', '2024-10-12 12:52:59', '2024-10-12 12:52:59'),
(43, 12762, 'action started via Async Request', '2024-10-12 12:53:32', '2024-10-12 12:53:32'),
(44, 12762, 'action complete via Async Request', '2024-10-12 12:53:32', '2024-10-12 12:53:32'),
(45, 12763, 'action started via WP Cron', '2024-10-12 12:54:12', '2024-10-12 12:54:12'),
(46, 12763, 'action complete via WP Cron', '2024-10-12 12:54:12', '2024-10-12 12:54:12'),
(47, 12764, 'action created', '2024-10-12 12:54:27', '2024-10-12 12:54:27'),
(48, 12764, 'action started via WP Cron', '2024-10-12 12:55:33', '2024-10-12 12:55:33'),
(49, 12764, 'action complete via WP Cron', '2024-10-12 12:55:33', '2024-10-12 12:55:33'),
(50, 12765, 'action created', '2024-10-12 12:55:33', '2024-10-12 12:55:33'),
(51, 12765, 'action started via WP Cron', '2024-10-12 12:57:32', '2024-10-12 12:57:32'),
(52, 12765, 'action failed via WP Cron: Scheduled action for action_scheduler/migration_hook will not be executed as no callbacks are registered.', '2024-10-12 12:57:32', '2024-10-12 12:57:32'),
(53, 12766, 'action created', '2024-10-12 13:12:40', '2024-10-12 13:12:40'),
(54, 12766, 'action started via WP Cron', '2024-10-17 20:49:01', '2024-10-17 20:49:01'),
(55, 12766, 'action complete via WP Cron', '2024-10-17 20:49:01', '2024-10-17 20:49:01'),
(56, 12752, 'action started via WP Cron', '2024-10-17 20:49:01', '2024-10-17 20:49:01'),
(57, 12752, 'action failed via WP Cron: Scheduled action for woocommerce_cleanup_draft_orders will not be executed as no callbacks are registered.', '2024-10-17 20:49:01', '2024-10-17 20:49:01'),
(58, 12767, 'action created', '2024-10-17 20:49:01', '2024-10-17 20:49:01'),
(59, 12768, 'action created', '2024-10-17 21:04:00', '2024-10-17 21:04:00'),
(60, 12768, 'action started via Async Request', '2024-10-17 21:05:02', '2024-10-17 21:05:02'),
(61, 12768, 'action complete via Async Request', '2024-10-17 21:05:02', '2024-10-17 21:05:02'),
(62, 12769, 'action created', '2024-10-17 21:11:13', '2024-10-17 21:11:13'),
(63, 12769, 'action started via WP Cron', '2024-10-17 21:12:59', '2024-10-17 21:12:59'),
(64, 12769, 'action complete via WP Cron', '2024-10-17 21:12:59', '2024-10-17 21:12:59'),
(65, 12770, 'action created', '2024-10-17 21:22:54', '2024-10-17 21:22:54'),
(66, 12770, 'action started via WP Cron', '2024-10-17 21:24:00', '2024-10-17 21:24:00'),
(67, 12770, 'action complete via WP Cron', '2024-10-17 21:24:00', '2024-10-17 21:24:00'),
(68, 12771, 'action created', '2024-10-17 21:29:01', '2024-10-17 21:29:01'),
(69, 12771, 'action started via Async Request', '2024-10-17 21:29:23', '2024-10-17 21:29:23'),
(70, 12771, 'action complete via Async Request', '2024-10-17 21:29:26', '2024-10-17 21:29:26'),
(71, 12772, 'action created', '2024-10-17 21:30:23', '2024-10-17 21:30:23'),
(72, 12773, 'action created', '2024-10-17 21:30:23', '2024-10-17 21:30:23'),
(73, 12774, 'action created', '2024-10-17 21:30:23', '2024-10-17 21:30:23'),
(74, 12775, 'action created', '2024-10-17 21:30:23', '2024-10-17 21:30:23'),
(75, 12776, 'action created', '2024-10-17 21:30:23', '2024-10-17 21:30:23'),
(76, 12776, 'action started via WP Cron', '2024-10-17 21:30:59', '2024-10-17 21:30:59'),
(77, 12776, 'action complete via WP Cron', '2024-10-17 21:31:01', '2024-10-17 21:31:01'),
(78, 12773, 'action started via WP Cron', '2024-10-17 21:31:01', '2024-10-17 21:31:01'),
(79, 12773, 'action complete via WP Cron', '2024-10-17 21:31:01', '2024-10-17 21:31:01'),
(80, 12774, 'action started via WP Cron', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(81, 12775, 'action canceled', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(82, 12777, 'action created', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(83, 12774, 'action complete via WP Cron', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(84, 12775, 'action ignored via WP Cron', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(85, 12777, 'action started via WP Cron', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(86, 12778, 'action created', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(87, 12779, 'action created', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(88, 12780, 'action created', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(89, 12781, 'action created', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(90, 12782, 'action created', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(91, 12783, 'action created', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(92, 12777, 'action complete via WP Cron', '2024-10-17 21:32:01', '2024-10-17 21:32:01'),
(93, 12778, 'action started via WP Cron', '2024-10-17 21:33:01', '2024-10-17 21:33:01'),
(94, 12778, 'action complete via WP Cron', '2024-10-17 21:33:09', '2024-10-17 21:33:09'),
(95, 12779, 'action started via Async Request', '2024-10-17 21:33:16', '2024-10-17 21:33:16'),
(96, 12779, 'action complete via Async Request', '2024-10-17 21:33:24', '2024-10-17 21:33:24'),
(97, 12780, 'action started via Async Request', '2024-10-17 21:33:30', '2024-10-17 21:33:30'),
(98, 12780, 'action complete via Async Request', '2024-10-17 21:33:38', '2024-10-17 21:33:38'),
(99, 12781, 'action started via Async Request', '2024-10-17 21:33:45', '2024-10-17 21:33:45'),
(100, 12781, 'action complete via Async Request', '2024-10-17 21:33:53', '2024-10-17 21:33:53'),
(101, 12782, 'action started via Async Request', '2024-10-17 21:33:59', '2024-10-17 21:33:59'),
(102, 12782, 'action complete via Async Request', '2024-10-17 21:34:07', '2024-10-17 21:34:07'),
(103, 12783, 'action started via Async Request', '2024-10-17 21:34:14', '2024-10-17 21:34:14'),
(104, 12783, 'action complete via Async Request', '2024-10-17 21:34:22', '2024-10-17 21:34:22'),
(105, 12784, 'action created', '2024-10-18 09:55:48', '2024-10-18 09:55:48'),
(106, 12784, 'action started via WP Cron', '2024-10-18 09:56:53', '2024-10-18 09:56:53'),
(107, 12784, 'action complete via WP Cron', '2024-10-18 09:56:53', '2024-10-18 09:56:53'),
(108, 12785, 'action created', '2024-10-18 09:56:53', '2024-10-18 09:56:53'),
(109, 12785, 'action started via WP Cron', '2024-10-18 09:58:53', '2024-10-18 09:58:53'),
(110, 12785, 'action failed via WP Cron: Scheduled action for action_scheduler/migration_hook will not be executed as no callbacks are registered.', '2024-10-18 09:58:53', '2024-10-18 09:58:53'),
(111, 12772, 'action started via WP Cron', '2024-10-18 13:59:38', '2024-10-18 13:59:38'),
(112, 12786, 'action created', '2024-10-18 13:59:38', '2024-10-18 13:59:38'),
(113, 12772, 'action complete via WP Cron', '2024-10-18 13:59:38', '2024-10-18 13:59:38'),
(114, 12787, 'action created', '2024-10-18 13:59:38', '2024-10-18 13:59:38'),
(115, 12786, 'action started via WP Cron', '2024-10-18 13:59:38', '2024-10-18 13:59:38'),
(116, 12786, 'action complete via WP Cron', '2024-10-18 13:59:40', '2024-10-18 13:59:40');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_betterdocs_analytics`
--

CREATE TABLE `qdc_betterdocs_analytics` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) NOT NULL DEFAULT 0,
  `impressions` bigint(20) NOT NULL DEFAULT 0,
  `unique_visit` bigint(20) NOT NULL DEFAULT 0,
  `happy` bigint(20) NOT NULL DEFAULT 0,
  `sad` bigint(20) NOT NULL DEFAULT 0,
  `normal` bigint(20) NOT NULL DEFAULT 0,
  `created_at` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`),
  KEY `post_id` (`post_id`),
  KEY `impressions` (`impressions`),
  KEY `unique_visit` (`unique_visit`),
  KEY `happy` (`happy`),
  KEY `sad` (`sad`),
  KEY `normal` (`normal`),
  KEY `created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_betterdocs_search_keyword`
--

CREATE TABLE `qdc_betterdocs_search_keyword` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `keyword` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_betterdocs_search_log`
--

CREATE TABLE `qdc_betterdocs_search_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `keyword_id` bigint(20) NOT NULL,
  `count` mediumint(9) DEFAULT NULL,
  `not_found_count` mediumint(9) DEFAULT NULL,
  `created_at` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`),
  KEY `keyword_id` (`keyword_id`),
  KEY `created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_blogmeta`
--

CREATE TABLE `qdc_blogmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `blog_id` bigint(20) NOT NULL DEFAULT 0,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `meta_key` (`meta_key`(191)),
  KEY `blog_id` (`blog_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `qdc_blogmeta`
--

INSERT INTO `qdc_blogmeta` VALUES
(1, 1, 'db_version', '57155'),
(2, 1, 'db_last_updated', '0.32574700 1717142084');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_blogs`
--

CREATE TABLE `qdc_blogs` (
  `blog_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `site_id` bigint(20) NOT NULL DEFAULT 0,
  `domain` varchar(200) NOT NULL DEFAULT '',
  `path` varchar(100) NOT NULL DEFAULT '',
  `registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `public` tinyint(2) NOT NULL DEFAULT 1,
  `archived` tinyint(2) NOT NULL DEFAULT 0,
  `mature` tinyint(2) NOT NULL DEFAULT 0,
  `spam` tinyint(2) NOT NULL DEFAULT 0,
  `deleted` tinyint(2) NOT NULL DEFAULT 0,
  `lang_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`blog_id`),
  KEY `domain` (`domain`(50),`path`(5)),
  KEY `lang_id` (`lang_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `qdc_blogs`
--

INSERT INTO `qdc_blogs` VALUES
(1, 1, 'quickdental.com.bd', '/', '2023-05-22 14:20:39', '2024-10-18 13:00:48', 1, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_appointments`
--

CREATE TABLE `qdc_bookly_appointments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `location_id` int(10) unsigned DEFAULT NULL,
  `staff_id` int(10) unsigned NOT NULL,
  `staff_any` tinyint(1) NOT NULL DEFAULT 0,
  `service_id` int(10) unsigned DEFAULT NULL,
  `custom_service_name` varchar(255) DEFAULT NULL,
  `custom_service_price` decimal(10,2) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `extras_duration` int(11) NOT NULL DEFAULT 0,
  `internal_note` text DEFAULT NULL,
  `google_event_id` varchar(255) DEFAULT NULL,
  `google_event_etag` varchar(255) DEFAULT NULL,
  `outlook_event_id` varchar(255) DEFAULT NULL,
  `outlook_event_change_key` varchar(255) DEFAULT NULL,
  `outlook_event_series_id` varchar(255) DEFAULT NULL,
  `online_meeting_provider` enum('zoom','google_meet','jitsi','bbb') DEFAULT NULL,
  `online_meeting_id` varchar(255) DEFAULT NULL,
  `online_meeting_data` text DEFAULT NULL,
  `created_from` enum('bookly','google','outlook') NOT NULL DEFAULT 'bookly',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `staff_id` (`staff_id`),
  KEY `service_id` (`service_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bookly_appointments`
--

INSERT INTO `qdc_bookly_appointments` VALUES
(1, NULL, 1, 0, 1, NULL, NULL, '2023-05-29 14:15:00', '2023-05-29 14:45:00', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'bookly', '2023-05-24 15:46:12', '2023-05-24 15:46:12'),
(2, NULL, 1, 0, 1, NULL, NULL, '2023-05-25 08:30:00', '2023-05-25 09:00:00', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'bookly', '2023-05-24 15:46:59', '2023-05-24 15:46:59');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_categories`
--

CREATE TABLE `qdc_bookly_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `attachment_id` int(10) unsigned DEFAULT NULL,
  `info` text DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT 9999,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_customers`
--

CREATE TABLE `qdc_bookly_customers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `wp_user_id` bigint(20) unsigned DEFAULT NULL,
  `facebook_id` bigint(20) unsigned DEFAULT NULL,
  `group_id` int(10) unsigned DEFAULT NULL,
  `full_name` varchar(255) NOT NULL DEFAULT '',
  `first_name` varchar(255) NOT NULL DEFAULT '',
  `last_name` varchar(255) NOT NULL DEFAULT '',
  `phone` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `birthday` date DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `street_number` varchar(255) DEFAULT NULL,
  `additional_address` varchar(255) DEFAULT NULL,
  `notes` text NOT NULL,
  `info_fields` text DEFAULT NULL,
  `stripe_account` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bookly_customers`
--

INSERT INTO `qdc_bookly_customers` VALUES
(1, NULL, NULL, NULL, 'mohaimin01_056ghy', 'mohaimin01_056ghy', '', '+8801726002069', 'admin@quickdental.com.bd', NULL, '', '', '', '', '', '', '', '', '[]', NULL, '2023-05-24 15:46:12'),
(2, NULL, NULL, NULL, 'mohaimin01_056ghy', 'mohaimin01_056ghy', '', '01726002069', 'munafa.tk@gmail.com', NULL, '', '', '', '', '', '', '', '', '[]', NULL, '2023-05-24 15:46:59');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_customer_appointments`
--

CREATE TABLE `qdc_bookly_customer_appointments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `series_id` int(10) unsigned DEFAULT NULL,
  `package_id` int(10) unsigned DEFAULT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `appointment_id` int(10) unsigned NOT NULL,
  `payment_id` int(10) unsigned DEFAULT NULL,
  `order_id` int(10) unsigned DEFAULT NULL,
  `number_of_persons` int(10) unsigned NOT NULL DEFAULT 1,
  `units` int(10) unsigned NOT NULL DEFAULT 1,
  `notes` text DEFAULT NULL,
  `extras` text DEFAULT NULL,
  `extras_multiply_nop` tinyint(1) NOT NULL DEFAULT 1,
  `custom_fields` text DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'approved',
  `status_changed_at` datetime DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `time_zone` varchar(255) DEFAULT NULL,
  `time_zone_offset` int(11) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `rating_comment` text DEFAULT NULL,
  `locale` varchar(8) DEFAULT NULL,
  `collaborative_service_id` int(10) unsigned DEFAULT NULL,
  `collaborative_token` varchar(255) DEFAULT NULL,
  `compound_service_id` int(10) unsigned DEFAULT NULL,
  `compound_token` varchar(255) DEFAULT NULL,
  `created_from` enum('frontend','backend') NOT NULL DEFAULT 'frontend',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `customer_id` (`customer_id`),
  KEY `appointment_id` (`appointment_id`),
  KEY `series_id` (`series_id`),
  KEY `payment_id` (`payment_id`),
  KEY `order_id` (`order_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bookly_customer_appointments`
--

INSERT INTO `qdc_bookly_customer_appointments` VALUES
(1, NULL, NULL, 1, 1, 1, 1, 1, 1, 'asd', '[]', 1, '[]', 'approved', NULL, 'bebb2386ae5ff7c887eb61c1009aee95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'frontend', '2023-05-24 15:46:12', '2023-05-24 15:46:12'),
(2, NULL, NULL, 2, 2, 2, 2, 1, 1, 'asde', '[]', 1, '[]', 'approved', NULL, '06f86db0392ee322f549289ed3ae1d25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'frontend', '2023-05-24 15:46:59', '2023-05-24 15:46:59');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_holidays`
--

CREATE TABLE `qdc_bookly_holidays` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` int(10) unsigned DEFAULT NULL,
  `parent_id` int(10) unsigned DEFAULT NULL,
  `date` date NOT NULL,
  `repeat_event` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `staff_id` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_log`
--

CREATE TABLE `qdc_bookly_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `action` enum('create','update','delete','error') DEFAULT NULL,
  `target` varchar(255) DEFAULT NULL,
  `target_id` int(10) unsigned DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `ref` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_mailing_campaigns`
--

CREATE TABLE `qdc_bookly_mailing_campaigns` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mailing_list_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `state` enum('pending','in-progress','completed','canceled') NOT NULL DEFAULT 'pending',
  `send_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mailing_list_id` (`mailing_list_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_mailing_lists`
--

CREATE TABLE `qdc_bookly_mailing_lists` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_mailing_list_recipients`
--

CREATE TABLE `qdc_bookly_mailing_list_recipients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mailing_list_id` int(10) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mailing_list_id` (`mailing_list_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_mailing_queue`
--

CREATE TABLE `qdc_bookly_mailing_queue` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `sent` tinyint(1) DEFAULT 0,
  `campaign_id` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_news`
--

CREATE TABLE `qdc_bookly_news` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `news_id` int(10) unsigned NOT NULL,
  `title` text DEFAULT NULL,
  `media_type` enum('image','youtube') NOT NULL DEFAULT 'image',
  `media_url` varchar(255) NOT NULL,
  `text` text DEFAULT NULL,
  `button_url` varchar(255) DEFAULT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT 0,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bookly_news`
--

INSERT INTO `qdc_bookly_news` VALUES
(1, 79, 'New video: How to publish staff availability form', 'youtube', 'https://www.youtube.com/embed/TzZ3fa2MVtg', '<p>Learn how to add the Bookly front-end calendar to your webpage, which enables clients to view staff availability. This type of calendar only displays occupied time slots with the corresponding service title and does not allow bookings.&nbsp;For more details, visit our <a href="https://support.booking-wp-plugin.com/hc/en-us/articles/212973145-Keep-Track-and-Edit-Appointments" target="_blank" rel="noopener" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/212973145-Keep-Track-and-Edit-Appointments">help center</a> and check other <a href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener" data-mce-href="https://www.youtube.com/c/Bookly/videos">video tutorials</a> to learn the basics and get the most out of Bookly.</p>', 'https://youtu.be/TzZ3fa2MVtg', 'Watch on Youtube', 0, '2023-05-08 13:41:35', '2023-05-08 13:41:35'),
(2, 78, 'New version release. See what’s new in Bookly PRO 6.1.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2023/05/Bookly-PRO-6.1-banner-1512.jpg', '<p>As with every update, the latest version of Bookly offers enhanced features, optimizations, and bug fixes to ensure optimal performance. We''ve included new options such as the ability to <strong>sell gift cards</strong> directly through the booking form, an <strong>SMTP mail gateway</strong> for improved email functionality, <strong>waiting list limits</strong> for services, and more.</p>', 'https://www.booking-wp-plugin.com/bookly-pro-v6-1/', 'Read more', 0, '2023-05-03 09:49:19', '2023-05-03 09:49:19'),
(3, 2, ' Mistakes every Bookly beginner should avoid', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2021/09/mistakes-every-bookly-beginner-should-avoid-banner-1512.jpg', '<p><span>Bookly admin panel is very intuitive and user-friendly. Thanks to its clean and simple design, even a WP beginner can</span><span>&nbsp;</span>set up Bookly<span>&nbsp;</span><span>without problems. We know you probably want to get started with online bookings on your website as quickly as possible and with almost no effort, so we’ve gathered the most common mistakes to avoid when you start using Bookly.</span></p>', 'https://www.booking-wp-plugin.com/mistakes-every-bookly-beginner-avoid/', 'Read more', 0, '2023-04-24 06:52:57', '2021-09-20 19:05:05'),
(4, 1, ' How to promote best selling services with Bookly', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2021/09/how-promote-best-selling-services-bookly-banner-1512.jpg', '<p><span>While Bookly is an appointment scheduling plugin that allows you to automate your online reservation system, some of its features can be used as a great way to gain customers’ interest in the services you want to promote. From this article, you’ll find out which Bookly items and built-in features you can use to better sell your services.</span></p>', 'https://www.booking-wp-plugin.com/promote-best-selling-services-bookly/', 'Read more', 0, '2023-04-24 06:46:38', '2021-09-20 19:02:23'),
(5, 44, 'How to get started with Bookly SMS mailing campaigns', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/02/how-to-get-started-with-bookly-sms-campaigns-banner-1512.jpg', '<p><span>Undoubtedly, the easiest and quickest way to reach your clients is by SMS. Bookly’s</span><span>&nbsp;</span><span>SMS service</span><span>&nbsp;</span><span>is already used by thousands of businesses for sending booking details confirmations, appointment reminders, and follow-ups. Now you can also take advantage of the</span><span>&nbsp;</span><span>automated SMS marketing campaigns</span><span>&nbsp;</span><span>that are configured and scheduled right in the Bookly admin area.</span></p>', 'https://www.booking-wp-plugin.com/get-started-bookly-sms-mailing-campaigns/', 'Read more', 0, '2023-04-04 16:34:12', '2022-02-01 08:58:09'),
(6, 40, 'How to add online meeting URL to any Bookly appointment', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/01/add-online-meeting-url-to-your-Bookly-appointment-1512.jpg', '<p><span>Nowadays, more and more companies embrace a remote approach in their operations. With Bookly, you get built-in integrations with the most popular software for online meetings: Zoom, Google Meet, and Jitsi. Whichever app you choose, it will automatically generate unique video meeting links for every appointment created via Bookly.</span></p>', 'https://www.booking-wp-plugin.com/add-online-meeting-url-bookly-appointment/', 'Read more', 0, '2023-04-04 16:32:05', '2022-01-18 08:35:40'),
(7, 46, 'How to limit daily bookings', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/02/how-to-limit-daily-bookings-in-bookly-banner-1512.jpg', '<p><span>Regardless of the staff members’ working schedule configured in Bookly, you may want to limit the number of appointments that your customers can schedule via your online booking page. Here we’ll describe which Bookly features you can use to allow only a certain amount of bookings during the staff working day.</span></p>', 'https://www.booking-wp-plugin.com/limit-daily-bookings/', 'Read more', 0, '2023-04-04 16:25:19', '2022-02-08 09:27:33'),
(8, 77, 'How to create time-flexible services in Bookly', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2023/03/how-to-create-time-flexible-services-in-bookly-banner-1512.jpg', '<p><span>Time-flexible services in Bookly mean appointments that may have changeable lengths, and clients can select a duration that fits them. Bookly offers several add-ons designed to meet specific scenarios where varying duration of the meeting is possible. While all of them may suit similar needs, each add-on differs in setup, customization, and management.</span></p>', 'https://www.booking-wp-plugin.com/create-time-flexible-services-bookly/', 'Read more', 0, '2023-04-04 06:15:16', '2023-04-04 06:15:16'),
(9, 76, 'New version release. See what’s new in Bookly PRO 6.0.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2023/03/Bookly-PRO-6.0-banner-1512.jpg', '<p>We regularly make updates to implement highly requested features and enhance the functionality of our products. This update includes several popular feature requests that will upgrade the Bookly booking system on your website. Discover new features and improvements included in<span>&nbsp;</span><strong>Bookly PRO version 6.0</strong>.</p>', 'https://www.booking-wp-plugin.com/bookly-pro-v6-0/', 'Read more', 0, '2023-03-16 11:09:42', '2023-03-16 11:09:42'),
(10, 75, 'New version release. See what’s new in Bookly PRO 5.9.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2023/02/Bookly-PRO-5.9-banner-1512.jpg', '<p><span>For a better experience and increased flexibility, we continue to develop and enhance Bookly. With this update, we introduce&nbsp;integration with<strong> WhatsApp</strong>, a new&nbsp;<strong>Bookly Staff</strong>&nbsp;booking&nbsp;<strong>form</strong>,&nbsp;customizable content of the service card&nbsp;in the modern booking forms,&nbsp;available payment methods for services, the ability to set&nbsp;default values in the new forms, and more.</span></p>', 'https://www.booking-wp-plugin.com/bookly-pro-v5-9/', 'Read more', 0, '2023-02-20 11:12:32', '2023-02-20 11:12:16'),
(11, 74, 'New video: How to generate invoices in Bookly', 'youtube', 'https://www.youtube.com/embed/gX_84Cvp3AM', '<p><span>With the Bookly Invoices (add-on), you can create detailed invoices for provided services and have them automatically sent when an appointment is booked, approved, or received. Learn how to set up and customize your templates.&nbsp;For more details, visit our <a href="https://support.booking-wp-plugin.com/hc/en-us/articles/360002713233" target="_blank" rel="noopener" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/360002713233">help center</a> and check other <a href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener" data-mce-href="https://www.youtube.com/c/Bookly/videos">video tutorials</a> to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=gX_84Cvp3AM&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-12-28 12:03:22', '2022-12-28 12:03:22'),
(12, 73, 'How to avoid gaps between appointments', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/12/avoid-gaps-between-appointments-banner-1512.jpg', '<p><span>Efficient schedule is very mportant for every business. Unwanted gaps between appointments are not convenient and may affect the whole balance of work.&nbsp;In this article, we’ll provide you with the tips that will help you optimize your Bookly calendar schedule and reduce empty slots as much as possible.</span></p>', 'https://www.booking-wp-plugin.com/avoid-gaps-between-appointments/', 'Read more', 0, '2022-12-06 14:40:35', '2022-12-06 14:40:35'),
(13, 72, 'New version release. See what’s new in Bookly PRO 5.6.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/11/Bookly-PRO-5.6-banner-1512.jpg', '<p><span>Our top priority is improving Bookly and developing new features that will work best for your business.&nbsp;In the current release, we introduce two new products –&nbsp;<strong>Square Payments</strong>&nbsp;and&nbsp;<strong>Voice Notifications</strong>, WooCommerce integration for the Bookly modern booking forms, Bookly Custom Fields (Add-on) &amp; Bookly Files (Add-on) compatibility with the new forms, and more.</span></p>', 'https://www.booking-wp-plugin.com/bookly-pro-v5-6/', 'Read more', 0, '2022-12-01 13:26:21', '2022-12-01 13:26:15'),
(14, 71, 'How to set up new Bookly Services booking form', 'youtube', 'https://www.youtube.com/embed/Qvp35ANbkUQ', '<p><span>One of the main benefits of the Bookly Services form is that you can organise services using categories and display them to your clients in a catalog view. Learn how to create your custom design and modify existing elements.&nbsp;For more details, visit our <a href="https://support.booking-wp-plugin.com/hc/en-us/articles/212178149-Booking-Form-Look-Feel" target="_blank" rel="noopener" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/212178149-Booking-Form-Look-Feel">help center</a> and check other <a href="https://www.youtube.com/c/Bookly/videos" data-mce-href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener">video tutorials</a> to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=Qvp35ANbkUQ&list=PLuLhoBV-rlAagLXlILG_1KgjVSaMUju8i', 'Watch on Youtube', 0, '2022-10-20 06:28:15', '2022-10-20 06:28:15'),
(15, 70, 'New version release. See what’s new in Bookly PRO 5.4.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/10/Bookly-PRO-5.4-banner-756.jpg', '<p>We track requests for new capabilities and keep working on the new functionality so that you can get more with Bookly every day! With this update, we release new features that meet the most popular requirements and help you manage your booking system easier and more effectively.</p>', 'https://www.booking-wp-plugin.com/bookly-pro-v5-4/', 'Read more', 0, '2022-10-10 11:31:59', '2022-10-10 11:31:59'),
(16, 69, 'New video: How to upload files in Bookly', 'youtube', 'https://www.youtube.com/embed/-ONIAAzIbmM', '<p><span>This video tutorial is about the file uploading feature in Bookly.&nbsp;</span><span>With the Bookly Files (Add-on), you can let your clients attach files related to the appointment right in the booking form.&nbsp;Uploaded documents will be stored at the appointment details.&nbsp;For more details, visit our&nbsp;<a href="https://support.booking-wp-plugin.com/hc/en-us/articles/360000373133" target="_blank" rel="noopener" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/360000373133"><span class="s1">help center</span></a>&nbsp;and check other&nbsp;<a href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener" data-mce-href="https://www.youtube.com/c/Bookly/videos"><span class="s1">video tutorials</span></a>&nbsp;to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=-ONIAAzIbmM&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-09-06 14:20:10', '2022-09-06 14:20:10'),
(17, 68, 'New version release. See what’s new in Bookly PRO 5.3.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/08/Bookly-PRO-5.3-banner-756.jpg', '<p><span>With this update, we release major&nbsp;</span>changes in the Appearance section<span>, the ability to&nbsp;</span>create several designs of your booking forms<span>,&nbsp;</span>payments in the new Bookly Search form<span>, and more. Also, as usual, new version includes&nbsp;general enhancements and bug fixes.</span></p>', 'https://www.booking-wp-plugin.com/bookly-pro-v5-3/', 'Read more', 0, '2022-08-25 13:00:11', '2022-08-25 13:00:11'),
(18, 67, 'New video: How to book identical appointments in a row', 'youtube', 'https://www.youtube.com/embed/xPsOXHMrly8', '<p>With the Bookly Multiply Appointments (Add-on), your clients can book back-to-back sessions of the same service.&nbsp;This way, customers can change the default appointment duration by selecting the quantity of similar services they’d like to get in a row.&nbsp;For more details, visit our <a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/210138469-Multiply-Appointments-Add-on" href="https://support.booking-wp-plugin.com/hc/en-us/articles/210138469-Multiply-Appointments-Add-on" target="_blank" rel="noopener">help center</a> and check other <a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener">video tutorials</a> to learn the basics and get the most out of Bookly.</p>', 'https://www.youtube.com/watch?v=xPsOXHMrly8&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-08-05 08:52:41', '2022-08-05 08:52:41'),
(19, 66, 'New version release. See what’s new in Bookly PRO 5.0.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/07/Bookly-PRO-5.0-banner-756.jpg', '<p>We continue to develop new features and make improvements in Bookly for a better experience and more flexibility. Today’s update brings a new appearance of the booking form, the ability to book packages in the Bookly search form, new Diagnostics section in the Bookly menu, and more.</p>', 'https://www.booking-wp-plugin.com/bookly-pro-v5-0/', 'Read more', 0, '2022-07-27 12:05:35', '2022-07-27 12:05:35'),
(20, 65, ' What’s the difference between Compound Services (Add-on) & Collaborative Services (Add-on)', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/07/difference-between-compound-addon-and-collaborative-addon-banner-756.jpg', '<p><span>Add-ons for Bookly have been created to add more advanced functionality to the default configuration of your Bookly PRO. If you have doubts about which extension is best for you, here’s a detailed comparison of the Compound Services (Add-on) and Collaborative Services (Add-on) for Bookly.</span></p>', 'https://www.booking-wp-plugin.com/whats-difference-compound-services-add-collaborative-services-add/', 'Read more', 0, '2022-07-12 10:24:47', '2022-07-12 10:24:47'),
(21, 64, 'New video: How to let clients rate your services', 'youtube', 'https://www.youtube.com/embed/k-iNqs4nBLY', '<p><span>With the Bookly Ratings (Add-on), you can gather customer feedback after each appointment and display staff members’ rating in a booking form. Learn how to quickly set up and use this feature.&nbsp;For more details, visit our <a href="https://support.booking-wp-plugin.com/hc/en-us/articles/360001695713" target="_blank" rel="noopener" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/360001695713">help center</a> and check other <a href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener" data-mce-href="https://www.youtube.com/c/Bookly/videos">video tutorials</a> to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=k-iNqs4nBLY&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-06-28 12:56:54', '2022-06-28 12:56:54'),
(22, 63, 'New video: How to create tasks in Bookly', 'youtube', 'https://www.youtube.com/embed/fT-J4Limf2Q', '<p>This video is about creating unscheduled appointments in Bookly. With the Bookly Tasks (Add-on), you can create and manage an unlimited number of tasks or bookings that have no date and time yet. For more details, visit our&nbsp;<a href="https://support.booking-wp-plugin.com/hc/en-us/articles/360013214654-Skip-time-selection-Tasks-Add-on-" target="_blank" rel="noopener" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/360013214654-Skip-time-selection-Tasks-Add-on-"><span class="s1">help center</span></a>&nbsp;and check other&nbsp;<a href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener" data-mce-href="https://www.youtube.com/c/Bookly/videos"><span class="s1">video tutorials</span></a>&nbsp;to learn the basics and get the most out of Bookly.</p>', 'https://www.youtube.com/watch?v=fT-J4Limf2Q&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-06-17 14:55:12', '2022-06-17 14:55:12'),
(23, 62, 'New version release. See what’s new in Bookly PRO 4.9.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/06/Bookly-PRO-4.9-banner-756.jpg', '<p>This update brings a new product in Bookly Cloud – <strong>Cloud Cron</strong>, integration with BigBlueButton – virtual classroom software, customization of ICS files, read-only access for calendar in Staff Cabinet, new trigger in Zapier, improvements in the Files (Add-on), and more.</p>', 'https://www.booking-wp-plugin.com/bookly-pro-v4-9/', 'Read more', 0, '2022-06-13 11:14:55', '2022-06-13 11:14:55'),
(24, 61, 'New video: How to add online meeting URL to Bookly appointment', 'youtube', 'https://www.youtube.com/embed/KXpgB25Vs60', '<p>With Bookly, you get built-in integrations with the most popular software for online meetings: Zoom, Google Meet, and Jitsi. Whichever app you choose, it will generate unique video meeting links for each appointment created via Bookly.&nbsp;For more details, visit our <a href="https://support.booking-wp-plugin.com/hc/en-us/articles/360013355499" target="_blank" rel="noopener" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/360013355499">help center</a> and check other <a href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener" data-mce-href="https://www.youtube.com/c/Bookly/videos">video tutorials</a> to learn the basics and get the most out of Bookly.</p>', 'https://www.youtube.com/watch?v=KXpgB25Vs60&list=PLuLhoBV-rlAagLXlILG_1KgjVSaMUju8i', 'Watch on Youtube', 0, '2022-06-06 17:10:12', '2022-06-06 17:10:12'),
(25, 60, 'New video: How to set up and use Bookly Compound Services (Add-on)', 'youtube', 'https://www.youtube.com/embed/iIJcQ8fT5BI', '<p>Learn how to combine existing services and spare time to make one complex appointment. Your clients can book such services as regular appointments, while Bookly adds reservations to each staff member’s schedule separately. For more details, visit our <a href="https://support.booking-wp-plugin.com/hc/en-us/articles/360001642033-Compound-Services-Add-on" target="_blank" rel="noopener" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/360001642033-Compound-Services-Add-on">help center</a> and check other <a href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener" data-mce-href="https://www.youtube.com/c/Bookly/videos">video tutorials</a> to learn the basics and get the most out of Bookly.</p>', 'https://www.youtube.com/watch?v=iIJcQ8fT5BI&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-05-24 09:39:45', '2022-05-24 09:39:45'),
(26, 59, 'New video: How to make chain bookings', 'youtube', 'https://www.youtube.com/embed/yGyzwKR9ktg', '<p>With the Chain Appointments (Add-on) for Bookly, your clients will be able to&nbsp;book several services in one booking session. Such appointments will be scheduled sequentially.&nbsp;For more details, visit our <a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/210316865-Chain-Appointments-Add-on" href="https://support.booking-wp-plugin.com/hc/en-us/articles/210316865-Chain-Appointments-Add-on" target="_blank" rel="noopener">help center</a> and check other <a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener">video tutorials</a> to learn the basics and get the most out of Bookly.</p>', 'https://www.youtube.com/watch?v=yGyzwKR9ktg&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-05-16 12:12:22', '2022-05-16 12:12:22'),
(27, 58, 'New version release. See what’s new in Bookly PRO 4.8.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/05/Bookly-PRO-4.8-banner-756.jpg', '<p>Bookly is making ongoing updates to improve your user experience and implement the most popular feature requests. Today’s update introduces the beta version of a new booking form, creation of WooCommerce orders for backend bookings, customization of the QR codes description, and more.</p>', 'https://www.booking-wp-plugin.com/bookly-pro-v4-8/', 'Read more', 0, '2022-05-12 15:35:28', '2022-05-12 15:35:28'),
(28, 57, 'Upcoming System Maintenance', 'image', 'https://images.booking-wp-plugin.com/main/blog/Upcoming-system-maintenance.jpg', '<p class="p1">We would like to inform you that on Sunday-Monday night of <b>2022 May 09 from 00:00 (midnight) to 04:00 CET</b>, the SMS service will be temporarily unavailable to users in some regions or countries (Australia, Europe, Africa, Asia, South America). This time will be used to implement important upgrades and performance optimization.</p><p class="p1">If you have any scheduled text messages during this time, please take this into consideration. We appreciate your patience and understanding!</p>', 'https://support.booking-wp-plugin.com/hc/en-us/articles/212411289-Set-Up-Text-Messages-SMS-', 'Help Center', 0, '2022-05-05 07:47:35', '2022-05-05 07:47:35'),
(29, 56, 'New video: How to create customer groups', 'youtube', 'https://www.youtube.com/embed/pNOayasDJXI', '<p>Bookly Customer Groups (Add-on) enables you to create and manage groups of clients for different purposes. You can set certain limitations, assign special prices, offer promotions to particular customers, and more.&nbsp;For more details, visit our <a href="https://support.booking-wp-plugin.com/hc/en-us/articles/360000201873-Customer-Groups-Add-on" target="_blank" rel="noopener" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/360000201873-Customer-Groups-Add-on">help center</a> and check other <a href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener" data-mce-href="https://www.youtube.com/c/Bookly/videos">video tutorials</a> to learn the basics and get the most out of Bookly.</p>', 'https://www.youtube.com/watch?v=pNOayasDJXI&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-05-05 07:40:52', '2022-05-05 07:40:52'),
(30, 55, 'All you need to know about automatic discounts in Bookly', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/04/756x384.jpg', '<p>Coupon codes, automatic or conditional discounts, and special rates can be used during certain seasons, promotions, or at any time you wish in order to increase customers’ loyalty. Let’s see how a wide range of Bookly features can help you meet various requirements and encourage your clients to book more through your appointment booking form.</p>', 'https://www.booking-wp-plugin.com/automatic-discounts-bookly/', 'Read more', 0, '2022-04-28 10:33:53', '2022-04-28 10:33:53'),
(31, 54, 'New video: How to sync Bookly PRO with Google Calendar', 'youtube', 'https://www.youtube.com/embed/3swwpWJ7_-s', '<p>With Google Calendar and Bookly Pro, you can manage your staff workload and bookings with maximum efficiency. Learn how to set up the connection and enable synchronization of all appointments created in Bookly with the employee''s personal calendar.&nbsp;For more details, visit our <a href="https://support.booking-wp-plugin.com/hc/en-us/articles/203572552-Google-Calendar-Sync" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/203572552-Google-Calendar-Sync">help center</a> and check other <a href="https://www.youtube.com/c/Bookly/videos" data-mce-href="https://www.youtube.com/c/Bookly/videos">video tutorials</a> to learn the basics and get the most out of Bookly.</p>', 'https://www.youtube.com/watch?v=3swwpWJ7_-s&list=PLuLhoBV-rlAagLXlILG_1KgjVSaMUju8i', 'Watch on Youtube', 0, '2022-04-25 16:05:42', '2022-04-25 16:05:42'),
(32, 53, 'New video: How to set flexible prices', 'youtube', 'https://www.youtube.com/embed/WfSbsoi06V8', '<p>Learn how to tweak the price for your services&nbsp;<span>on selected days of the week during&nbsp;cold or hot hours of the day. Dynamic pricing is available with the <strong>Special Hours (Add-on)</strong> for Bookly.&nbsp;For more details, visit our <a href="https://support.booking-wp-plugin.com/hc/en-us/articles/213524185-Dynamic-Pricing-Special-Hours-Add-On-" target="_blank" rel="noopener" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/213524185-Dynamic-Pricing-Special-Hours-Add-On-">help center</a> and check other <a href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener" data-mce-href="https://www.youtube.com/c/Bookly/videos">video tutorials</a> to learn the basics and get the most out of Bookly.</span></p>', 'https://youtu.be/WfSbsoi06V8&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-04-19 08:42:45', '2022-04-19 08:42:45'),
(33, 52, 'New version release. See what’s new in Bookly PRO 4.7.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/04/Bookly-PRO-4.7-banner-756.jpg', '<p><span>Bookly rolls out a new option available for extending your active support period, the ability to create custom fields for backend entries, automatic update of the appointment status once it’s over, visible service price for appointments created via the Bookly admin panel, and more.</span></p>', 'https://www.booking-wp-plugin.com/bookly-pro-v4-7/', 'Read more', 0, '2022-04-07 11:27:12', '2022-04-07 11:27:12'),
(34, 51, 'New video: How to add service locations in Bookly', 'youtube', 'https://www.youtube.com/embed/KRlVIPE9xOA', '<p>With the Bookly Locations (Add-on),&nbsp;you can associate staff members with different locations, so your clients will be able to choose the place for their appointment before they schedule date and time.&nbsp;For more details, visit our <a href="https://support.booking-wp-plugin.com/hc/en-us/articles/210229885" target="_blank" rel="noopener" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/210229885">help center</a> and check other <a href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener" data-mce-href="https://www.youtube.com/c/Bookly/videos">video tutorials</a> to learn the basics and get the most out of Bookly.</p>', 'https://www.youtube.com/watch?v=KRlVIPE9xOA&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-03-31 13:26:43', '2022-03-31 13:26:43'),
(35, 50, 'New video: How to create and manage promo codes in Bookly', 'youtube', 'https://www.youtube.com/embed/luOElg-mnNU', '<p>Bookly Coupons (Add-on) allows you to offer discounts for your services and attract more clients. This video describes how to quickly set up coupons in Bookly.&nbsp;For more details, visit our <a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/115003939373" href="https://support.booking-wp-plugin.com/hc/en-us/articles/115003939373" target="_blank" rel="noopener">help center</a> and check other <a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener">video tutorials</a> to learn the basics and get the most out of Bookly.</p>', 'https://www.youtube.com/watch?v=luOElg-mnNU&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-03-24 12:27:27', '2022-03-24 12:27:27'),
(36, 49, 'New video: How to create time-flexible services', 'youtube', 'https://www.youtube.com/embed/jYKG0eGvWJ0', '<p><span>Custom Duration (Add-on) for Bookly allows you to create services with flexible duration. On the booking page, your clients can choose the length of the appointment from the predefined options, and the price will be adjusted respectively.&nbsp;For more details, visit our <a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/360005082294-Services-with-flexible-duration-Custom-Duration-Add-on-" href="https://support.booking-wp-plugin.com/hc/en-us/articles/360005082294-Services-with-flexible-duration-Custom-Duration-Add-on-" target="_blank" rel="noopener">help center</a>&nbsp;and check other <a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos">video tutorials</a>&nbsp;to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=jYKG0eGvWJ0&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK?utm_source=bookly_admin&utm_medium=news', 'Watch on Youtube', 0, '2022-02-17 09:41:40', '2022-02-17 09:41:40'),
(37, 48, 'New version release. See what’s new in Bookly PRO 4.6.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/02/Bookly-PRO-4.6-banner-756.jpg', '<p><span>Bookly’s new update introduces QR codes, refunds for payments made via Stripe, separate payments for recurring appointments, alert counter for new appointments, default values in custom fields, ability to attach payment to the package, and more.</span></p>', 'https://www.booking-wp-plugin.com/bookly-pro-v4-6/?utm_source=bookly_admin&utm_medium=news', 'Read more', 0, '2022-02-15 16:13:28', '2022-02-15 16:13:28'),
(38, 47, 'New video: How to accept deposit payments', 'youtube', 'https://www.youtube.com/embed/ewK3byklkK0', '<p><span>Bookly Deposit Payments (Add-on)&nbsp;allows you to set up a minimum amount that customers should pay at the time of booking. A deposit&nbsp;is set individually for each staff member and each service.&nbsp;For more details, visit our </span><a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/212234945-Deposit-Payments-Add-on" href="https://support.booking-wp-plugin.com/hc/en-us/articles/212234945-Deposit-Payments-Add-on">help center</a>&nbsp;<span>and check other </span><a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos">video tutorials</a>&nbsp;<span>to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=ewK3byklkK0&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-02-10 10:00:07', '2022-02-10 10:00:07'),
(39, 45, 'New video: How to add special days to staff schedule', 'youtube', 'https://www.youtube.com/embed/gi5eULm5-64', '<p><span>This video tutorial is about working schedule of your employees and changing regular timetable&nbsp;on particular days during the year.&nbsp;For more details, visit our </span><a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/212817929-Extra-Long-Short-Days-Special-Days-Add-on-" href="https://support.booking-wp-plugin.com/hc/en-us/articles/212817929-Extra-Long-Short-Days-Special-Days-Add-on-" target="_blank" rel="noopener">help center</a>&nbsp;<span>and check other </span><a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos">video tutorials</a>&nbsp;<span>to learn the basics and get the most out of Bookly.</span></p>', 'https://youtu.be/gi5eULm5-64&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-02-03 08:46:00', '2022-02-03 08:46:00'),
(40, 43, 'New video: How to create recurring appointments', 'youtube', 'https://www.youtube.com/embed/tfUmuNrYrn8', '<p><span>Learn how to set up and create recurring appointments in Bookly. This feature allows your clients to make multiple bookings that repeat at regular intervals, so they can schedule the whole series at once.&nbsp;For more details, visit our </span><a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/115001442665-Recurring-Appointments-Add-on" href="https://support.booking-wp-plugin.com/hc/en-us/articles/115001442665-Recurring-Appointments-Add-on">help center</a>&nbsp;<span>and check other </span><a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos">video tutorials</a>&nbsp;<span>to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=tfUmuNrYrn8&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-01-27 14:08:11', '2022-01-27 14:08:11'),
(41, 42, 'How to accept payments with WooCommerce', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/01/how-to-accept-payments-with-woocommerce-banner-756.jpg', '<p><span>If some payment gateway is not available in Bookly yet, you can have access to other payment options through WooCommerce – the world’s most popular e-commerce plugin for WordPress.&nbsp;Bookly PRO seamlessly integrates with WooCommerce allowing you to sell services as products.&nbsp;This article describes how to quickly set up the connection between two plugins.</span></p>', 'https://www.booking-wp-plugin.com/accept-payments-woocommerce/', 'Read more', 0, '2022-01-25 10:36:59', '2022-01-25 10:36:59'),
(42, 41, 'New video: How to book several appointments at once', 'youtube', 'https://www.youtube.com/embed/miYLCPCEYIg', '<p><span>Encourage your customers to book more on your website! This video explains how to set up the Bookly Cart (Add-on) and let your clients order a number of bookings in one session.&nbsp;For more details, visit our </span><a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/212969945-Cart-Add-on" href="https://support.booking-wp-plugin.com/hc/en-us/articles/212969945-Cart-Add-on" target="_blank" rel="noopener">help center</a>&nbsp;<span>and check other </span><a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener">video tutorials</a>&nbsp;<span>to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=miYLCPCEYIg&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-01-20 09:42:21', '2022-01-20 09:42:21'),
(43, 39, 'New video: How to add extras to your services', 'youtube', 'https://www.youtube.com/embed/z_B7hyjBxqI', '<p><span>Extras are additional items that your customers can book along with the services. These may be </span><span>special tools, products, or resources for performing a service, or extra time if you set their duration.&nbsp;For more details, visit our <a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/207647799-Extra-Products-Treatments-Service-Extras-Add-on-" href="https://support.booking-wp-plugin.com/hc/en-us/articles/207647799-Extra-Products-Treatments-Service-Extras-Add-on-" target="_blank" rel="noopener">help center</a>&nbsp;and check other <a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener">video tutorials</a>&nbsp;to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=z_B7hyjBxqI&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-01-13 10:13:57', '2022-01-13 10:13:57'),
(44, 38, 'How to set specific booking days and times for a service', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/01/set-specific-booking-days-and-times-for-service-banner-756.jpg', '<p><span>Some services may be available on a seasonal basis, during specific hours within a day, or on certain days only.&nbsp;</span><span>Bookly allows you to adjust the service availability without affecting the regular timetable of your staff.&nbsp;</span><span>From this article, you will learn how to set up a custom schedule for a service to make it bookable only on special days and times.</span></p>', 'https://www.booking-wp-plugin.com/set-specific-booking-days-times-service/', 'Read more', 0, '2022-01-11 08:22:14', '2022-01-11 08:22:07'),
(45, 37, 'New video: How to set up Staff Cabinet (Add-on) for Bookly', 'youtube', 'https://www.youtube.com/embed/awHddbbNOaw', '<p><span>Personal Staff Cabinet for your employees enables them to view and manage the list of bookings, personal details, and schedules on the front end of your website. This video describes how to install and use it.&nbsp;For more details, visit our </span><a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/115003349989" href="https://support.booking-wp-plugin.com/hc/en-us/articles/115003349989" target="_blank" rel="noopener">help center</a>&nbsp;<span>and check other </span><a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener">video tutorials</a>&nbsp;<span>to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=awHddbbNOaw&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2022-01-06 12:10:24', '2022-01-06 12:08:42'),
(46, 36, 'How to create a separate booking page for each staff member', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2022/01/how-to-create-separate-booking-page-for-staff-member-banner-756.jpg', '<p><span>If you want to invite your customers to an appointment with a certain staff member, you may want to create a custom booking page that includes staff details, featured services, information about special offers, etc. This article explains how to set up a personalized online booking form for your employee and provide your customers with a unique booking link.</span></p>', 'https://www.booking-wp-plugin.com/create-separate-booking-page/', 'Read more', 0, '2022-01-04 09:32:50', '2022-01-04 09:32:50'),
(47, 35, 'New video: How to limit the service availability', 'youtube', 'https://www.youtube.com/embed/8EEf0HbZwi0', '<p><span>Learn how to limit the hours during the day when the service can be booked, and which options you have when both Service Schedule (Add-on) and Special Days (Add-on) are installed and activated.&nbsp;For more details, visit our <a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/213850385-Services-Available-at-Limited-Hours-Service-Schedule-Add-on-" href="https://support.booking-wp-plugin.com/hc/en-us/articles/213850385-Services-Available-at-Limited-Hours-Service-Schedule-Add-on-" target="_blank" rel="noopener">help center</a>&nbsp;and check other <a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener">video tutorials</a>&nbsp;to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=8EEf0HbZwi0&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2021-12-30 15:25:12', '2021-12-30 10:32:17'),
(48, 34, 'New version release. See what’s new in Bookly PRO 4.5.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2021/12/Bookly-PRO-4.5-banner-756.jpg', '<p><span>The end of the year brings new features that we’re very excited to share with you! We want you to have a great experience using Bookly items, so the new release, as usual, includes some of the most requested improvements, general enhancements, and bug fixes.</span></p>', 'https://www.booking-wp-plugin.com/bookly-pro-v4-5/', 'Read more', 0, '2021-12-27 08:50:24', '2021-12-27 08:50:24'),
(49, 33, 'New video: How to accept group bookings', 'youtube', 'https://www.youtube.com/embed/Cmb1sxPFIMY', '<p><span>With the Bookly Group Booking (Add-on) you can use a capacity option, so your customers will be able to specify the number of persons they’d like to book for. Learn how to determine&nbsp;individual settings for each&nbsp;service and employee separately.&nbsp;For more details, visit our <a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/360000259594-Group-Booking-Add-on" href="https://support.booking-wp-plugin.com/hc/en-us/articles/360000259594-Group-Booking-Add-on">help center</a>&nbsp;and check other <a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos">video tutorials</a>&nbsp;to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=Cmb1sxPFIMY&list=PLuLhoBV-rlAZpUnQgHJkMBx1rCvQGQ6cK', 'Watch on Youtube', 0, '2021-12-23 10:28:27', '2021-12-23 10:28:27'),
(50, 32, 'How to book appointments longer than 1 day', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2021/12/how-to-book-appointments-longer-than-one-day-banner-756.jpg', '<p><span>Some companies provide services that last throughout the day or even take several days, such as all-day conferences, weekend educational courses, or multi-day guided tours. Depending on the specific type of business, there are several options for setting up and managing such appointments via Bookly.</span></p>', 'https://www.booking-wp-plugin.com/book-appointments-longer-1-day/', 'Read more', 0, '2021-12-21 08:41:51', '2021-12-21 08:41:51'),
(51, 31, 'New video: How to extend client''s profile in Bookly', 'youtube', 'https://www.youtube.com/embed/LvV2JDZV0uc', '<p><span>This video explains how to add custom data to the client’s profile with the Bookly Customer Information (Add-on). All customer-related information will always be available for you with a couple of clicks in the Customers section.&nbsp;For more details, visit our&nbsp;<a href="https://support.booking-wp-plugin.com/hc/en-us/sections/202869125-Manage-Clients" target="_blank" rel="noopener" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/sections/202869125-Manage-Clients">help center</a>&nbsp;and&nbsp;check other&nbsp;<a href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener" data-mce-href="https://www.youtube.com/c/Bookly/videos">video tutorials</a>&nbsp;to learn the basics and get the most out of Bookly.</span></p>', 'https://youtu.be/LvV2JDZV0uc&list=PLuLhoBV-rlAagLXlILG_1KgjVSaMUju8i', 'Watch on Youtube', 0, '2021-12-16 11:23:12', '2021-12-16 11:23:12'),
(52, 30, 'Top 5 automations to use in Bookly', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2021/12/Top-five-automations-to-use-in-Bookly-banner-756.jpg', '<p><span>Bookly is known to be the most feature-rich online booking and scheduling plugin in the market.&nbsp;In this post, we’ll provide an overview of the top 5 Bookly automations that will help you to manage your administrative workload with ease and improve your efficiency.</span></p>', 'https://www.booking-wp-plugin.com/top-5-automations-use-bookly/', 'Read more', 0, '2021-12-14 08:03:44', '2021-12-14 08:03:44'),
(53, 29, 'Discontinued support for Internet Explorer 11', 'image', 'https://images.booking-wp-plugin.com/main/blog/Internet_Explorer_discontinued_support.jpg', '<p><span>The Internet Explorer (IE) 11 desktop application </span><strong>will go out of support&nbsp;</strong><span>starting June 15, 2022. Bootstrap framework used for Bookly interface elements in the admin panel, </span><a href="https://blog.getbootstrap.com/2021/05/05/bootstrap-5/#browser-support" target="_blank" rel="noopener" data-mce-href="https://blog.getbootstrap.com/2021/05/05/bootstrap-5/#browser-support">stopped supporting IE since version 5.0</a>&nbsp;<span>and </span><a href="https://wordpress.org/news/2021/05/dropping-support-for-internet-explorer-11/" data-mce-href="https://wordpress.org/news/2021/05/dropping-support-for-internet-explorer-11/">WordPress no longer supports IE 11 starting from version 5.8</a><span>. If you are currently using IE 11, it is strongly recommended that you switch to a more modern browser.</span></p>', 'https://blogs.windows.com/windowsexperience/2021/05/19/the-future-of-internet-explorer-on-windows-10-is-in-microsoft-edge/', 'Read more', 0, '2021-12-13 07:36:02', '2021-12-13 07:36:02'),
(54, 28, 'New video: How to manage customer base in Bookly', 'youtube', 'https://www.youtube.com/embed/K53xCEIo8NQ', '<p><span>With Bookly you get an unlimited, sortable and searchable customer list. But that’s not all. Learn how&nbsp;</span><span>Bookly allows you to effortlessly manage your customer base. For more details, visit our </span><a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/sections/202869125-Manage-Clients" href="https://support.booking-wp-plugin.com/hc/en-us/sections/202869125-Manage-Clients" target="_blank" rel="noopener">help center</a><span>&nbsp;and&nbsp;check other </span><a href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener" data-mce-href="https://www.youtube.com/c/Bookly/videos">video tutorials</a>&nbsp;<span>to learn the basics and get the most out of Bookly.</span></p>', 'https://www.youtube.com/watch?v=K53xCEIo8NQ&list=PLuLhoBV-rlAbu0MMy7yG8KeysVAEdBOcc', 'Watch on Youtube', 0, '2021-12-09 09:28:31', '2021-12-09 09:28:31'),
(55, 27, 'What’s the difference between Multiply Appointments (Add-on) & Custom Duration (Add-on)', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2021/12/difference-between-multiply-appointments-addon-and-custom-duration-addon-banner-756.jpg', '<p><span>Add-ons for Bookly have been created to add more advanced functionality to the default configuration of your Bookly PRO. If you have doubts about which extension is best for you, here’s a detailed comparison of the Multiply Appointments (Add-on) and Custom Duration (Add-on) for Bookly.</span></p>', 'https://www.booking-wp-plugin.com/whats-difference-multiply-appointments-add-custom-duration-add/', 'Read more', 0, '2021-12-07 09:19:54', '2021-12-07 09:19:54'),
(56, 26, 'New video: How to receive and manage online payments', 'youtube', 'https://www.youtube.com/embed/5WaXF4AeG-A', '<p><span>There are&nbsp;more than </span><strong>10 payment gateways&nbsp;</strong><span>which can be integrated with Bookly PRO to help drive more customers from the booking plugin right to your door. Learn how to quickly enable a desired online payment option in Bookly settings. For more details, visit our&nbsp;</span><a href="https://support.booking-wp-plugin.com/hc/en-us/sections/202811029-Pricing-Payment" data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/sections/202811029-Pricing-Payment" target="_blank" rel="noopener">help center</a><span>.</span></p>', 'https://www.youtube.com/watch?v=5WaXF4AeG-A&list=PLuLhoBV-rlAagLXlILG_1KgjVSaMUju8i', 'Watch on Youtube', 0, '2021-12-02 09:08:52', '2021-12-02 09:08:52'),
(57, 25, ' How to never miss an appointment', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2021/11/how-to-never-miss-an-appointment-with-Bookly-756.jpg', '<p><span>The last thing any business owner or service provider would want is to miss an appointment with a client. No matter how long is your booking list, Bookly will help you to efficiently control your company workload. With these recommendations, you will have no chance to forget or miss a scheduled meeting.</span></p>', 'https://www.booking-wp-plugin.com/never-miss-appointment-bookly/', 'Read more', 0, '2021-11-30 08:06:35', '2021-11-30 08:06:35'),
(58, 24, 'New video: How to set up and use custom fields in Bookly', 'youtube', 'https://www.youtube.com/embed/yRqrXj83eoY', '<p><span>This video explains how</span><span>&nbsp;to add your own custom questions to the booking form with the <strong>Bookly Custom Fields (Add-on)</strong>.&nbsp;For more details, visit our <a data-mce-href="https://support.booking-wp-plugin.com/hc/en-us/articles/115003963514-Custom-Fields-add-on" href="https://support.booking-wp-plugin.com/hc/en-us/articles/115003963514-Custom-Fields-add-on" target="_blank" rel="noopener">help center</a>&nbsp;and check other <a data-mce-href="https://www.youtube.com/c/Bookly/videos" href="https://www.youtube.com/c/Bookly/videos" target="_blank" rel="noopener">video tutorials</a>&nbsp;to learn the basics and get the most out of Bookly.</span></p>', 'https://youtu.be/yRqrXj83eoY', 'Watch on Youtube', 0, '2021-11-26 08:21:57', '2021-11-26 08:21:57'),
(59, 23, 'Introducing Bookly Mailchimp (Add-on)', 'image', 'https://images.booking-wp-plugin.com/main/products/Bookly-Mailchimp-integration.jpg', '<p><span>We are happy to announce our new integration with&nbsp;</span><strong>Mailchimp&nbsp;</strong><span>– one of the most popular and flexible email marketing platforms that you can use for scheduling and </span><strong>automating your email campaigns</strong><span>. Once connected, you''ll be able to&nbsp;automatically export client''s contact information to your mailing list after an appointment is created via Bookly.</span></p>', 'https://codecanyon.net/item/bookly-mailchimp-addon/34925755?ref=ladela', 'Learn more', 0, '2021-11-24 10:29:57', '2021-11-24 10:29:57'),
(60, 22, 'New version release. See what’s new in Bookly PRO 4.4.', 'image', 'https://www.booking-wp-plugin.com/wp-content/uploads/2021/11/Bookly-PRO-release-4.4-756.jpg', '<p><span>Bookly is continually getting better to provide you with the most helpful features for your business. This update brings most-requested features, general improvements, and fixes to ensure that Bookly is working at its best.&nbsp;Check out the list of capabilities included in&nbsp;</span><strong>Bookly PRO version 4.4</strong><span>.</span></p>', 'https://www.booking-wp-plugin.com/bookly-pro-v4-4/', 'Read more', 0, '2021-11-22 12:25:15', '2021-11-22 12:25:15');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_notifications`
--

CREATE TABLE `qdc_bookly_notifications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gateway` enum('email','sms','voice','whatsapp') NOT NULL DEFAULT 'email',
  `type` varchar(255) NOT NULL DEFAULT '',
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `subject` varchar(255) NOT NULL DEFAULT '',
  `message` text DEFAULT NULL,
  `to_staff` tinyint(1) NOT NULL DEFAULT 0,
  `to_customer` tinyint(1) NOT NULL DEFAULT 0,
  `to_admin` tinyint(1) NOT NULL DEFAULT 0,
  `to_custom` tinyint(1) NOT NULL DEFAULT 0,
  `custom_recipients` varchar(255) DEFAULT NULL,
  `attach_ics` tinyint(1) NOT NULL DEFAULT 0,
  `attach_invoice` tinyint(1) NOT NULL DEFAULT 0,
  `settings` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bookly_notifications`
--

INSERT INTO `qdc_bookly_notifications` VALUES
(1, 'email', 'new_booking', 1, 'Notification to customer about approved appointment', 'Your appointment information', 'Dear {client_name}.\n\nThis is a confirmation that you have booked {service_name}.\n\nWe are waiting you at {company_address} on {appointment_date} at {appointment_time}.\n\nThank you for choosing our company.\n\n{company_name}\n{company_phone}\n{company_website}', 0, 1, 0, 0, NULL, 0, 0, '{"status":"approved","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":9,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(2, 'email', 'new_booking', 1, 'Notification to staff member about approved appointment', 'New booking information', 'Hello.\n\nYou have a new booking.\n\nService: {service_name}\nDate: {appointment_date}\nTime: {appointment_time}\nClient name: {client_name}\nClient phone: {client_phone}\nClient email: {client_email}', 1, 0, 0, 0, NULL, 0, 0, '{"status":"approved","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":9,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(3, 'email', 'ca_status_changed', 1, 'Notification to customer about cancelled appointment', 'Booking cancellation', 'Dear {client_name}.\n\nYou have cancelled your booking of {service_name} on {appointment_date} at {appointment_time}.\n\nThank you for choosing our company.\n\n{company_name}\n{company_phone}\n{company_website}', 0, 1, 0, 0, NULL, 0, 0, '{"status":"cancelled","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":9,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(4, 'email', 'ca_status_changed', 1, 'Notification to staff member about cancelled appointment', 'Booking cancellation', 'Hello.\n\nThe following booking has been cancelled.\n\nService: {service_name}\nDate: {appointment_date}\nTime: {appointment_time}\nClient name: {client_name}\nClient phone: {client_phone}\nClient email: {client_email}', 1, 0, 0, 0, NULL, 0, 0, '{"status":"cancelled","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":9,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(5, 'email', 'ca_status_changed', 1, 'Notification to customer about rejected appointment', 'Booking rejection', 'Dear {client_name}.\n\nYour booking of {service_name} on {appointment_date} at {appointment_time} has been rejected.\n\nReason: {cancellation_reason}\n\nThank you for choosing our company.\n\n{company_name}\n{company_phone}\n{company_website}', 0, 1, 0, 0, NULL, 0, 0, '{"status":"rejected","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":9,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(6, 'email', 'ca_status_changed', 1, 'Notification to staff member about rejected appointment', 'Booking rejection', 'Hello.\n\nThe following booking has been rejected.\n\nReason: {cancellation_reason}\n\nService: {service_name}\nDate: {appointment_date}\nTime: {appointment_time}\nClient name: {client_name}\nClient phone: {client_phone}\nClient email: {client_email}', 1, 0, 0, 0, NULL, 0, 0, '{"status":"rejected","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":9,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(7, 'sms', 'new_booking', 1, 'Notification to customer about approved appointment', '', 'Dear {client_name}.\nThis is a confirmation that you have booked {service_name}.\nWe are waiting you at {company_address} on {appointment_date} at {appointment_time}.\nThank you for choosing our company.\n{company_name}\n{company_phone}\n{company_website}', 0, 1, 0, 0, NULL, 0, 0, '{"status":"approved","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":9,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(8, 'sms', 'new_booking', 1, 'Notification to staff member about approved appointment', '', 'Hello.\nYou have a new booking.\nService: {service_name}\nDate: {appointment_date}\nTime: {appointment_time}\nClient name: {client_name}\nClient phone: {client_phone}\nClient email: {client_email}', 1, 0, 0, 0, NULL, 0, 0, '{"status":"approved","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":9,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(9, 'sms', 'ca_status_changed', 1, 'Notification to customer about cancelled appointment', '', 'Dear {client_name}.\nYou have cancelled your booking of {service_name} on {appointment_date} at {appointment_time}.\nThank you for choosing our company.\n{company_name}\n{company_phone}\n{company_website}', 0, 1, 0, 0, NULL, 0, 0, '{"status":"cancelled","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":9,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(10, 'sms', 'ca_status_changed', 1, 'Notification to staff member about cancelled appointment', '', 'Hello.\nThe following booking has been cancelled.\nService: {service_name}\nDate: {appointment_date}\nTime: {appointment_time}\nClient name: {client_name}\nClient phone: {client_phone}\nClient email: {client_email}', 1, 0, 0, 0, NULL, 0, 0, '{"status":"cancelled","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":9,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(11, 'sms', 'ca_status_changed', 1, 'Notification to customer about rejected appointment', '', 'Dear {client_name}.\nYour booking of {service_name} on {appointment_date} at {appointment_time} has been rejected.\nReason: {cancellation_reason}\nThank you for choosing our company.\n{company_name}\n{company_phone}\n{company_website}', 0, 1, 0, 0, NULL, 0, 0, '{"status":"rejected","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":9,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(12, 'sms', 'ca_status_changed', 1, 'Notification to staff member about rejected appointment', '', 'Hello.\nThe following booking has been rejected.\nReason: {cancellation_reason}\nService: {service_name}\nDate: {appointment_date}\nTime: {appointment_time}\nClient name: {client_name}\nClient phone: {client_phone}\nClient email: {client_email}', 1, 0, 0, 0, NULL, 0, 0, '{"status":"rejected","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":9,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(13, 'sms', 'appointment_reminder', 0, 'Evening reminder to customer about next day appointment (requires cron setup)', '', 'Dear {client_name}.\nWe would like to remind you that you have booked {service_name} tomorrow at {appointment_time}. We are waiting for you at {company_address}.\nThank you for choosing our company.\n{company_name}\n{company_phone}\n{company_website}', 0, 1, 0, 0, NULL, 0, 0, '{"status":"any","option":2,"services":{"any":"any","ids":[]},"offset_hours":1,"perform":"before","at_hour":18,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":-24}'),
(14, 'voice', 'appointment_reminder', 0, 'Evening reminder to customer about next day appointment (requires cron setup)', '', 'Dear {client_name}.\nWe would like to remind you that you have booked {service_name} tomorrow at {appointment_time}. We are waiting for you at {company_address}.\nThank you for choosing our company.\n{company_name}\n{company_phone}\n{company_website}', 0, 1, 0, 0, NULL, 0, 0, '{"status":"any","option":2,"services":{"any":"any","ids":[]},"offset_hours":1,"perform":"before","at_hour":18,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":-24}'),
(15, 'sms', 'appointment_reminder', 0, 'Follow-up message in the same day after appointment (requires cron setup)', '', 'Dear {client_name}.\nThank you for choosing {company_name}. We hope you were satisfied with your {service_name}.\nThank you and we look forward to seeing you again soon.\n{company_name}\n{company_phone}\n{company_website}', 0, 1, 0, 0, NULL, 0, 0, '{"status":"any","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":21,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":0}'),
(16, 'sms', 'staff_day_agenda', 0, 'Evening notification with the next day agenda to staff member (requires cron setup)', '', 'Hello.\nYour agenda for tomorrow is:\n{next_day_agenda}', 1, 0, 0, 0, NULL, 0, 0, '{"status":"any","option":2,"services":{"any":"any","ids":[]},"offset_hours":2,"perform":"before","at_hour":18,"before_at_hour":18,"offset_before_hours":-24,"offset_bidirectional_hours":-24}'),
(17, 'email', 'verify_email', 1, 'Notification to customer with verification code', 'Bookly verification code', '{verification_code}', 0, 1, 0, 0, NULL, 0, 0, '[]'),
(18, 'sms', 'verify_phone', 1, 'Notification to customer with verification code', '', '{verification_code}', 0, 1, 0, 0, NULL, 0, 0, '[]');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_notifications_queue`
--

CREATE TABLE `qdc_bookly_notifications_queue` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `token` varchar(255) NOT NULL,
  `data` text DEFAULT NULL,
  `sent` tinyint(1) DEFAULT 0,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_orders`
--

CREATE TABLE `qdc_bookly_orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `token` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bookly_orders`
--

INSERT INTO `qdc_bookly_orders` VALUES
(1, '081025f730f8851646bf85daabe637ff'),
(2, '8c08e23fe82812d0f3843450452a515d');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_payments`
--

CREATE TABLE `qdc_bookly_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target` enum('appointments','packages','gift_cards') NOT NULL DEFAULT 'appointments',
  `coupon_id` int(10) unsigned DEFAULT NULL,
  `gift_card_id` int(10) unsigned DEFAULT NULL,
  `type` enum('local','free','paypal','authorize_net','stripe','2checkout','payu_biz','payu_latam','payson','mollie','woocommerce','cloud_stripe','cloud_square','cloud_gift') NOT NULL DEFAULT 'local',
  `total` decimal(10,2) NOT NULL DEFAULT 0.00,
  `tax` decimal(10,2) NOT NULL DEFAULT 0.00,
  `paid` decimal(10,2) NOT NULL DEFAULT 0.00,
  `paid_type` enum('in_full','deposit') NOT NULL DEFAULT 'in_full',
  `gateway_price_correction` decimal(10,2) DEFAULT 0.00,
  `status` enum('pending','completed','rejected','refunded') NOT NULL DEFAULT 'completed',
  `token` varchar(255) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `ref_id` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bookly_payments`
--

INSERT INTO `qdc_bookly_payments` VALUES
(1, 'appointments', NULL, NULL, 'free', '0.00', '0.00', '0.00', 'in_full', NULL, 'completed', 'a8f2222a574c090f7eac78bc766f8634', '{"items":[{"ca_id":1,"appointment_date":"2023-05-29 14:15:00","app_start_info":null,"service_name":"Appointment","service_price":0,"service_tax":0,"wait_listed":false,"deposit_format":null,"number_of_persons":1,"units":1,"duration":"1800","staff_name":"Quick Dental Care","extras":[]}],"coupon":null,"gift_card":null,"subtotal":{"price":0,"deposit":0},"customer":"mohaimin01_056ghy","tax_in_price":"excluded","tax_paid":null,"extras_multiply_nop":1,"gateway_ref_id":null,"tips":null}', NULL, '2023-05-24 15:46:12', '2023-05-24 15:46:12'),
(2, 'appointments', NULL, NULL, 'free', '0.00', '0.00', '0.00', 'in_full', NULL, 'completed', '03966e7265d0870b19539e95980c23b1', '{"items":[{"ca_id":2,"appointment_date":"2023-05-25 08:30:00","app_start_info":null,"service_name":"Appointment","service_price":0,"service_tax":0,"wait_listed":false,"deposit_format":null,"number_of_persons":1,"units":1,"duration":"1800","staff_name":"Quick Dental Care","extras":[]}],"coupon":null,"gift_card":null,"subtotal":{"price":0,"deposit":0},"customer":"mohaimin01_056ghy","tax_in_price":"excluded","tax_paid":null,"extras_multiply_nop":1,"gateway_ref_id":null,"tips":null}', NULL, '2023-05-24 15:46:59', '2023-05-24 15:46:59');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_schedule_item_breaks`
--

CREATE TABLE `qdc_bookly_schedule_item_breaks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `staff_schedule_item_id` int(10) unsigned NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `staff_schedule_item_id` (`staff_schedule_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_sent_notifications`
--

CREATE TABLE `qdc_bookly_sent_notifications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ref_id` int(10) unsigned NOT NULL,
  `notification_id` int(10) unsigned NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ref_id_idx` (`ref_id`),
  KEY `notification_id` (`notification_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_series`
--

CREATE TABLE `qdc_bookly_series` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `repeat` varchar(255) DEFAULT NULL,
  `token` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_services`
--

CREATE TABLE `qdc_bookly_services` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `type` enum('simple','collaborative','compound','package') NOT NULL DEFAULT 'simple',
  `title` varchar(255) DEFAULT '',
  `attachment_id` int(10) unsigned DEFAULT NULL,
  `duration` int(11) NOT NULL DEFAULT 900,
  `slot_length` varchar(32) NOT NULL DEFAULT 'default',
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `color` varchar(32) NOT NULL DEFAULT '#FFFFFF',
  `deposit` varchar(16) NOT NULL DEFAULT '100%',
  `capacity_min` int(11) NOT NULL DEFAULT 1,
  `capacity_max` int(11) NOT NULL DEFAULT 1,
  `waiting_list_capacity` int(10) unsigned DEFAULT NULL,
  `one_booking_per_slot` tinyint(1) NOT NULL DEFAULT 0,
  `padding_left` int(11) NOT NULL DEFAULT 0,
  `padding_right` int(11) NOT NULL DEFAULT 0,
  `info` text DEFAULT NULL,
  `start_time_info` varchar(32) DEFAULT '',
  `end_time_info` varchar(32) DEFAULT '',
  `same_staff_for_subservices` tinyint(1) NOT NULL DEFAULT 0,
  `units_min` int(10) unsigned NOT NULL DEFAULT 1,
  `units_max` int(10) unsigned NOT NULL DEFAULT 1,
  `package_life_time` int(11) DEFAULT NULL,
  `package_size` int(11) DEFAULT NULL,
  `package_unassigned` tinyint(1) NOT NULL DEFAULT 0,
  `appointments_limit` int(11) DEFAULT NULL,
  `limit_period` enum('off','day','week','month','year','upcoming','calendar_day','calendar_week','calendar_month','calendar_year') NOT NULL DEFAULT 'off',
  `staff_preference` enum('order','least_occupied','most_occupied','least_occupied_for_period','most_occupied_for_period','least_expensive','most_expensive') NOT NULL DEFAULT 'most_expensive',
  `staff_preference_settings` text DEFAULT NULL,
  `recurrence_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `recurrence_frequencies` set('daily','weekly','biweekly','monthly') NOT NULL DEFAULT 'daily,weekly,biweekly,monthly',
  `time_requirements` enum('required','optional','off') NOT NULL DEFAULT 'required',
  `collaborative_equal_duration` tinyint(1) NOT NULL DEFAULT 0,
  `online_meetings` enum('off','zoom','google_meet','jitsi','bbb') NOT NULL DEFAULT 'off',
  `final_step_url` varchar(512) NOT NULL DEFAULT '',
  `wc_product_id` int(10) unsigned NOT NULL DEFAULT 0,
  `wc_cart_info_name` varchar(255) DEFAULT NULL,
  `wc_cart_info` text DEFAULT NULL,
  `min_time_prior_booking` int(11) DEFAULT NULL,
  `min_time_prior_cancel` int(11) DEFAULT NULL,
  `gateways` varchar(255) DEFAULT NULL,
  `visibility` enum('public','private','group') NOT NULL DEFAULT 'public',
  `position` int(11) NOT NULL DEFAULT 9999,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bookly_services`
--

INSERT INTO `qdc_bookly_services` VALUES
(1, NULL, 'simple', 'Appointment', NULL, 1800, 'default', '0.00', '#083AFE', '100%', 1, 1, NULL, 0, 0, 0, NULL, NULL, NULL, 0, 1, 1, NULL, NULL, 0, NULL, 'off', 'most_expensive', '{}', 1, 'daily,weekly,biweekly,monthly', 'required', 0, 'off', '', 0, NULL, NULL, NULL, NULL, NULL, 'public', 1);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_sessions`
--

CREATE TABLE `qdc_bookly_sessions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `token` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `value` text DEFAULT NULL,
  `expire` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `token` (`token`),
  KEY `expire` (`expire`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_shop`
--

CREATE TABLE `qdc_bookly_shop` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `plugin_id` int(10) unsigned NOT NULL,
  `type` enum('plugin','bundle') NOT NULL DEFAULT 'plugin',
  `highlighted` tinyint(1) NOT NULL DEFAULT 0,
  `priority` int(10) unsigned DEFAULT 0,
  `demo_url` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `url` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `sales` int(10) unsigned NOT NULL,
  `rating` decimal(10,2) NOT NULL,
  `reviews` int(10) unsigned NOT NULL,
  `published` datetime NOT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bookly_shop`
--

INSERT INTO `qdc_bookly_shop` VALUES
(1, 7226091, 'plugin', 1, 100, NULL, 'Bookly Pro', 'bookly-addon-pro', 'Bring appointment scheduling process to the next level with Bookly Pro (Add-on). Pro version turns Bookly plugin into the professional appointment management system. Unlock Advanced Customer management, Service provider management, Services management, Email and SMS notifications, Booking management capabilities. Connect payment gateways and modify Pro version with other add-ons available only with Bookly Pro and more.', 'https://codecanyon.net/item/bookly-booking-plugin-responsive-appointment-booking-and-scheduling/7226091', 'https://s3.envato.com/files/437889706/bookly-pro-icon80x80.png', 'https://s3.envato.com/files/441000485/CodeCanyon-main-banner-48K.jpg', '89.00', 48865, '4.54', 1123, '2014-04-12 17:14:52', 1, '2023-05-24 15:42:24'),
(2, 13903524, 'plugin', 0, 0, NULL, 'Bookly Multisite (Add-on)', 'bookly-addon-multisite', 'Bookly Multisite (Add-on) enables you to use a single instance of the Bookly plugin across your entire Multisite network. This means that each site within your network will have its own unique list of services, staff members, appointments, and settings. It’s an efficient and convenient way to manage your bookings across multiple sites from a single point of access.', 'https://codecanyon.net/item/bookly-multisite-addon/13903524', 'https://s3.envato.com/files/437364499/icon80x80.png', 'https://s3.envato.com/files/437364501/Multisite-590x300.jpg', '49.00', 686, '5.00', 9, '2015-12-04 16:38:03', 1, '2023-05-24 15:42:24'),
(3, 15552320, 'plugin', 0, 0, NULL, 'Bookly Service Extras (Add-on)', 'bookly-addon-service-extras', 'Bookly Service Extras (Add-on) allows you to offer extra items, services, products, equipment, or options that customers can book along with the regular appointment created via Bookly. These additional items can affect the overall price and duration of the appointment as selected by the client.', 'https://codecanyon.net/item/bookly-service-extras-addon/15552320', 'https://s3.envato.com/files/437367975/icon80x80%20(1).png', 'https://s3.envato.com/files/437367976/Service-Extras-590x300.jpg', '49.00', 3501, '4.42', 33, '2016-04-01 15:29:11', 1, '2023-05-24 15:42:24'),
(4, 17328208, 'plugin', 0, 0, NULL, 'Bookly Locations (Add-on)', 'bookly-addon-locations', 'Does your company operate in more than one place? Bookly Locations (Add-on) makes it possible to associate staff members and services with different locations, so your clients can pick where they prefer to receive services before they schedule a date and time for their visit.\r\n', 'https://codecanyon.net/item/bookly-locations-addon/17328208', 'https://s3.envato.com/files/437370601/icon80x80%20(2).png', 'https://s3.envato.com/files/437370602/Locations-590x300.jpg', '39.00', 3068, '4.44', 34, '2016-08-03 17:49:31', 1, '2023-05-24 15:42:24'),
(5, 17367838, 'plugin', 0, 0, NULL, 'Bookly Chain Appointments (Add-on)', 'bookly-addon-chain-appointments', 'Let your clients book several consecutive appointments in one visit. With the Bookly Chain Appointments (Add-on), your clients can choose multiple services from different staff members at the first step of the booking process. Bookly will find available time slots when all services can be delivered sequentially during a single visit.', 'https://codecanyon.net/item/bookly-chain-appointments-addon/17367838', 'https://s3.envato.com/files/437373852/icon80x80%20(3).png', 'https://s3.envato.com/files/437373854/Chain-Appointments-590x300.jpg', '29.00', 1371, '4.80', 5, '2016-08-09 17:40:29', 1, '2023-05-24 15:42:24'),
(6, 17457141, 'plugin', 0, 0, NULL, 'Bookly Multiply Appointments (Add-on)', 'bookly-addon-multiply-appointments', 'Let your clients determine the length of their visit by booking back to back sessions of the same service. Bookly Multiply Appointments (Add-on) makes it possible for your clients to select a number of appointments they would like to get in a row with the same service provider. Bookly will automatically calculate the price of such reservation and offer time slots that can accommodate the stated number of identical appointments.', 'https://codecanyon.net/item/bookly-multiply-appointments-addon/17457141', 'https://s3.envato.com/files/437382095/icon80x80%20(4).png', 'https://s3.envato.com/files/437382096/Multiply-Appointments-590x300.jpg', '29.00', 924, '0.00', 2, '2016-08-16 16:02:12', 1, '2023-05-24 15:42:24'),
(7, 17956131, 'plugin', 0, 0, NULL, 'Bookly Deposit Payments (Add-on)', 'bookly-addon-deposit-payments', 'Do you want to minimize the number of missed appointments and reduce cancellations? With the Bookly Deposit Payments (Add-on), you can require clients to pay a deposit at the time of booking to secure their appointment. By collecting a portion of the service cost in advance, you can minimize the risk of no-shows and ensure that the client is committed to their appointment. The remaining amount can then be paid offline when the client arrives for their appointment.', 'https://codecanyon.net/item/bookly-deposit-payments-addon/17956131', 'https://s3.envato.com/files/437382478/icon80x80%20(5).png', 'https://s3.envato.com/files/437382479/Deposit-Payments-2-590x300.jpg', '39.00', 1818, '3.78', 9, '2016-09-22 18:11:00', 1, '2023-05-24 15:42:24'),
(8, 18611122, 'plugin', 0, 0, NULL, 'Bookly Special Days (Add-on)', 'bookly-addon-special-days', 'Bookly Special Days (Add-on) enables you to change the default working hours of your staff on specific days of the year. This means you can create customized work schedules that differ from the regular ones, such as shorter or longer workdays, including breaks. These special days’ working hours will be taken into account when Bookly checks the service provider’s availability, providing your clients with accurate booking times.', 'https://codecanyon.net/item/bookly-special-days-addon/18611122', 'https://s3.envato.com/files/437382756/icon80x80%20(6).png', 'https://s3.envato.com/files/437382758/Special-Days-590x300.jpg', '39.00', 2824, '4.50', 18, '2016-11-07 01:25:43', 1, '2023-05-24 15:42:24'),
(9, 18704535, 'plugin', 0, 0, NULL, 'Bookly Special Hours (Add-on)', 'bookly-addon-special-hours', 'Do you want to offer flexible pricing options for your services? With the Bookly Special Hours (Add-on), you can easily set up dynamic pricing based on the time of day or day of the week. You can offer discounted rates for morning appointments or increase prices for evening or weekend bookings. This allows you to tailor your pricing to the needs of your business and customers.', 'https://codecanyon.net/item/bookly-special-hours-addon/18704535', 'https://s3.envato.com/files/437383025/icon80x80%20(7).png', 'https://s3.envato.com/files/437383027/Special-Hours-590x300.jpg', '29.00', 687, '4.20', 5, '2016-11-09 01:22:54', 1, '2023-05-24 15:42:24'),
(10, 18874038, 'plugin', 0, 0, NULL, 'Bookly Service Schedule (Add-on)', 'bookly-addon-service-schedule', 'Do you offer unique types of services that are only available during specific times or days? With the Bookly Service Schedule (Add-on), you can easily limit the availability of your services to specific hours or days. This allows staff members to follow their regular schedules but booking times for a specific service only appear in the Bookly form when they overlap with the staff’s working hours.', 'https://codecanyon.net/item/bookly-service-schedule-addon/18874038', 'https://s3.envato.com/files/437383322/icon80x80%20(8).png', 'https://s3.envato.com/files/437383325/590x300.jpg', '29.00', 2979, '4.33', 15, '2016-11-22 05:03:19', 1, '2023-05-24 15:42:24'),
(11, 19497634, 'plugin', 0, 0, NULL, 'Bookly Recurring Appointments (Add-on)', 'bookly-addon-recurring-appointments', 'Do you want to streamline your clients’ booking experience and encourage them to schedule regular visits? With the Bookly Recurring Appointments (Add-on), you can easily allow clients to schedule appointments weeks or months in advance. This feature allows you to automate the process of creating a series of appointments at a custom repeat interval, making it simple for clients to schedule regular appointments with just a few clicks in the Bookly booking form.', 'https://codecanyon.net/item/bookly-recurring-appointments-addon/19497634', 'https://s3.envato.com/files/437383633/icon80x80%20(9).png', 'https://s3.envato.com/files/437383634/Recurring-appointments-590x300.jpg', '39.00', 1888, '3.77', 13, '2017-02-23 17:42:00', 1, '2023-05-24 15:42:24'),
(12, 19617518, 'plugin', 0, 0, NULL, 'Bookly PayPal Payments Standard (Add-on)', 'bookly-addon-paypal-payments-standard', 'If you’re looking for a hassle-free way to process online payments during the booking process, Bookly PayPal Payments Standard (Add-on) is the perfect solution for you. By integrating this add-on with your Bookly PRO booking form, you can offer your customers a secure and popular payment gateway to pay via credit card or PayPal account. With all payments processed through PayPal, you can rest assured that the transaction is safe and reliable.', 'https://codecanyon.net/item/bookly-paypal-payments-standard-addon/19617518', 'https://s3.envato.com/files/437397531/icon80x80%20(10).png', 'https://s3.envato.com/files/437397532/PayPal-Payments-Standard-590x300.jpg', '29.00', 1699, '5.00', 7, '2017-03-22 04:29:25', 1, '2023-05-24 15:42:24'),
(13, 20005540, 'plugin', 0, 0, NULL, 'Bookly Staff Cabinet (Add-on)', 'bookly-addon-staff-cabinet', 'With the Bookly Staff Cabinet (Add-on), you can set up and provide each employee with their own personal account to manage their calendars, details, schedules, and other settings directly on the front end of your site. This eliminates the need for staff members to access the WordPress admin panel. By allowing employees to log in to their own Staff Cabinet, you can streamline the appointment management process and improve efficiency.', 'https://codecanyon.net/item/bookly-staff-cabinet-addon/20005540', 'https://s3.envato.com/files/437398500/icon80x80%20(11).png', 'https://s3.envato.com/files/437398501/Staff-Cabinet-590x300.jpg', '39.00', 2254, '4.15', 20, '2017-05-26 16:11:36', 1, '2023-05-24 15:42:24'),
(14, 20685954, 'plugin', 0, 0, NULL, 'Bookly PayU Latam (Add-on)', 'bookly-addon-payu-latam', 'Looking for a seamless and convenient way to accept online payments during booking on your website? Bookly PayU Latam (Add-on) enables integration of PayU Latam payment solution, which is a widely used payment platform in Latin America, into your Bookly PRO booking form. Your customers can easily pay online for your services using the PayU Checkout for secure transaction processing.', 'https://codecanyon.net/item/bookly-payu-latam-addon/20685954', 'https://s3.envato.com/files/437399038/icon80x80%20(12).png', 'https://s3.envato.com/files/437399039/PayU-Latam-590x300.jpg', '29.00', 103, '0.00', 2, '2017-10-04 22:22:08', 1, '2023-05-24 15:42:24'),
(15, 20917406, 'plugin', 0, 0, NULL, 'Bookly Waiting List (Add-on)', 'bookly-addon-waiting-list', 'Do you want to provide clients with the option to join a waiting list for fully-booked time slots? The Bookly Waiting List (Add-on) allows you to enable this feature in your Bookly booking system. If a cancellation occurs, you can quickly fill the open time slot by notifying the clients on the waiting list. Bookly will automatically notify the service provider about the available time slot, along with a list of customers in line. ', 'https://codecanyon.net/item/bookly-waiting-list-addon/20917406', 'https://s3.envato.com/files/437399297/icon80x80%20(13).png', 'https://s3.envato.com/files/437399298/Waiting-List-590x300.jpg', '29.00', 484, '3.67', 3, '2017-11-09 17:58:26', 1, '2023-05-24 15:42:24'),
(16, 20952783, 'plugin', 0, 0, NULL, 'Bookly Packages (Add-on)', 'bookly-addon-packages', 'Do your clients book the same service regularly? Why not offer them a package? With the Bookly Packages (Add-on), you can create deals for a particular service, allowing clients to book their favorite treatment in one package. Offering package deals can help to increase customer loyalty and encourage more sales. You can also set discounts on packages and set a validity period to ensure that customers use their package deals.', 'https://codecanyon.net/item/bookly-packages-addon/20952783', 'https://s3.envato.com/files/437399668/icon80x80%20(14).png', 'https://s3.envato.com/files/437399676/Packages-590x300.jpg', '29.00', 730, '3.00', 6, '2017-11-14 18:45:26', 1, '2023-05-24 15:42:24'),
(17, 21113698, 'plugin', 0, 0, NULL, 'Bookly 2Checkout (Add-on)', 'bookly-addon-2checkout', 'Looking for a safe and convenient way to accept online payments via your Bookly booking form? Bookly 2Checkout (Add-on) allows you to integrate the 2сheckout payment solution – a leading global payment solution that enables companies to accept credit card payments from buyers around the world – into your Bookly PRO booking form. With this payment gateway, you can offer your clients a hassle-free payment experience that’s both secure and reliable.', 'https://codecanyon.net/item/bookly-2checkout-addon/21113698', 'https://s3.envato.com/files/437400829/icon80x80%20(16).png', 'https://s3.envato.com/files/437400830/2checkout-590x300.jpg', '29.00', 39, '0.00', 0, '2017-12-12 10:30:34', 1, '2023-05-24 15:42:24'),
(18, 21113750, 'plugin', 0, 0, NULL, 'Bookly Authorize.Net (Add-on)', 'bookly-addon-authorize-net', 'Simplify the payment process for your customers by integrating a reliable and easy payment method into your website. With the Bookly Authorize.Net (Add-on), you can seamlessly integrate the Authorize.net payment solution into your Bookly PRO booking form. Your clients can pay for their appointments instantly with credit card via one of the most popular payment gateways.', 'https://codecanyon.net/item/bookly-authorizenet-addon/21113750', 'https://s3.envato.com/files/437400619/icon80x80%20(15).png', 'https://s3.envato.com/files/437400621/Authorize.net-590x300.jpg', '29.00', 224, '0.00', 0, '2017-12-12 10:30:24', 1, '2023-05-24 15:42:24'),
(19, 21113860, 'plugin', 0, 0, NULL, 'Bookly Coupons (Add-on)', 'bookly-addon-coupons', 'Would you like to improve customer loyalty, increase your sales, or attract new clients? With the Bookly Coupons (Add-on), you can create and manage promotional codes that customers can apply during checkout in the Bookly booking form. Once a coupon is used, the service price will automatically be reduced, and you’ll receive a record of the discount in the Bookly payment reports.', 'https://codecanyon.net/item/bookly-coupons-addon/21113860', 'https://s3.envato.com/files/437401292/icon80x80%20(17).png', 'https://s3.envato.com/files/437401293/Coupons-590x300.jpg', '39.00', 2176, '4.20', 5, '2017-12-12 10:39:37', 1, '2023-05-24 15:42:24'),
(20, 21113970, 'plugin', 0, 0, NULL, 'Bookly Custom Fields (Add-on)', 'bookly-addon-custom-fields', 'With the Bookly Custom Fields (Add-on), you can add extra fields of different types to the Details step of the Bookly booking form. This feature allows you to gather more specific information from your clients before they complete their booking. The custom fields will be added to the appointment details in the Bookly Calendar, and can be updated if necessary.', 'https://codecanyon.net/item/bookly-custom-fields-addon/21113970', 'https://s3.envato.com/files/437401484/icon80x80%20(18).png', 'https://s3.envato.com/files/437401485/Custom-Fields-590x300.jpg', '49.00', 5603, '4.77', 22, '2017-12-12 10:40:39', 1, '2023-05-24 15:42:24'),
(21, 21114042, 'plugin', 0, 0, NULL, 'Bookly Mollie (Add-on)', 'bookly-addon-mollie', 'Need a secure and easy method of accepting online payments through your Bookly booking form? The Bookly Mollie (Add-on) offers seamless integration with Mollie, one of the leading payment platforms in Europe. Mollie enables companies to accept credit card payments from buyers, providing a convenient and trustworthy payment experience. By integrating Mollie with Bookly PRO, you can offer your customers a reliable method of paying for their bookings directly on your website.', 'https://codecanyon.net/item/bookly-mollie-addon/21114042', 'https://s3.envato.com/files/437401872/icon80x80%20(19).png', 'https://s3.envato.com/files/437401873/Mollie-590x300.jpg', '34.00', 851, '3.67', 3, '2017-12-12 10:43:25', 1, '2023-05-24 15:42:24'),
(22, 21114096, 'plugin', 0, 0, NULL, 'Bookly Payson (Add-on)', 'bookly-addon-payson', 'Bookly Payson (Add-on) allows you to seamlessly integrate the Payson payment solution into your Bookly PRO booking form, providing customers with a convenient and secure payment experience. Payson Checkout is designed to increase the number of completed transactions and supports payment via online bank account or credit card. By integrating Payson with Bookly PRO, you can offer clients a reliable method of paying for their bookings directly on your website.', 'https://codecanyon.net/item/bookly-payson-addon/21114096', 'https://s3.envato.com/files/437888697/icon80x80%20(7).png', 'https://s3.envato.com/files/437888698/Payson-590x300.jpg', '29.00', 15, '0.00', 1, '2017-12-12 10:44:08', 1, '2023-05-24 15:42:24'),
(23, 21114146, 'plugin', 0, 0, NULL, 'Bookly Stripe (Add-on)', 'bookly-addon-stripe', 'Bookly Stripe (Add-on) enables your customers to easily and securely pay for their appointments without being redirected away from the Bookly booking form. By integrating the Stripe payment solution into your Bookly PRO booking form, you can streamline the payment process for your customers, making it quick and convenient to complete transactions.', 'https://codecanyon.net/item/bookly-stripe-addon/21114146', 'https://s3.envato.com/files/437890136/stripe80x80.png', 'https://s3.envato.com/files/437890138/Stripe-590x300.jpg', '39.00', 3612, '4.43', 14, '2017-12-12 10:46:42', 1, '2023-05-24 15:42:24'),
(24, 21344225, 'plugin', 0, 0, NULL, 'Bookly Group Booking (Add-on)', 'bookly-addon-group-booking', 'Bookly Group Booking (Add-on) allows clients to book appointments for multiple people at the same time. The add-on enables you to set the minimum and maximum capacity of the service and accept group bookings for the same appointment slot. In the Bookly booking form, clients can specify the number of people they are booking for, and Bookly ensures that the service provider can accommodate the group.', 'https://codecanyon.net/item/bookly-group-booking-addon/21344225', 'https://s3.envato.com/files/437900981/icon80x80.png', 'https://s3.envato.com/files/437900982/Group-Booking-590x300.jpg', '39.00', 4243, '4.27', 11, '2018-02-01 01:33:45', 1, '2023-05-24 15:42:24'),
(25, 21344290, 'plugin', 0, 0, NULL, 'Bookly Customer Groups (Add-on)', 'bookly-addon-customer-groups', 'The Bookly Customer Groups (Add-on) allows you to easily create and manage customer groups in Bookly, giving you the ability to set specific rules for each group. By categorizing your clients, you can control how their bookings are processed, set customized pricing for their appointments, and determine which services are visible to them in the Bookly booking form.', 'https://codecanyon.net/item/bookly-customer-groups-addon/21344290', 'https://s3.envato.com/files/437901186/icon80x80%20(1).png', 'https://s3.envato.com/files/437901187/Customer-Groups-590x300.jpg', '29.00', 486, '0.00', 1, '2018-02-01 02:03:48', 1, '2023-05-24 15:42:24'),
(26, 21344354, 'plugin', 0, 0, NULL, 'Bookly Files (Add-on)', 'bookly-addon-files', 'File uploading feature simplifies the process of collecting information required for appointments. Bookly Files (Add-on) makes it possible for the clients to attach files related to their visit directly in the Bookly online booking form. All uploaded files will be available for review and update in the booking details. Important: Bookly Files (Add-on) requires Bookly Custom Fields (Add-on) installed and activated.', 'https://codecanyon.net/item/bookly-files-addon/21344354', 'https://s3.envato.com/files/437901282/icon80x80%20(2).png', 'https://s3.envato.com/files/437901283/Files-590x300.jpg', '29.00', 774, '3.25', 8, '2018-02-01 02:07:58', 1, '2023-05-24 15:42:24'),
(27, 21574371, 'plugin', 0, 0, NULL, 'Bookly Compound Services (Add-on)', 'bookly-addon-compound-services', 'With the Bookly Compound Services (Add-on), you can combine existing services with spare time to create a separate complex service that clients can book a complete appointment with multiple services as any regular appointment. Each service included in the compound appointment will be performed by a relevant staff member who will only be reserved for their part of the service.', 'https://codecanyon.net/item/bookly-compound-services-addon/21574371', 'https://s3.envato.com/files/437881226/icon80x80%20(2).png', 'https://s3.envato.com/files/437881235/Compound-Services-590x300.jpg', '29.00', 294, '0.00', 2, '2018-03-13 06:08:47', 1, '2023-05-24 15:42:24'),
(28, 21574466, 'plugin', 0, 0, NULL, 'Bookly Customer Information (Add-on)', 'bookly-addon-customer-information', 'Need specific fields or records on a client profile in Bookly? Bookly Customer Information (Add-on) allows you to create multiple custom fields of different types that will appear on the Details step of the booking form. Once a booking is complete, the custom information entered by the client will be added to their profile in Bookly for future reference.', 'https://codecanyon.net/item/bookly-customer-information-addon/21574466', 'https://s3.envato.com/files/437901407/icon80x80%20(3).png', 'https://s3.envato.com/files/437901408/Customer-Information-590x300.jpg', '29.00', 1436, '4.86', 7, '2018-03-13 06:10:12', 1, '2023-05-24 15:42:24'),
(29, 21574566, 'plugin', 0, 0, NULL, 'Bookly Ratings (Add-on)', 'bookly-addon-ratings', 'Gathering feedback from customers is crucial for businesses to understand areas where they can improve their services. With the Bookly Ratings (Add-on), you can request feedback from clients after each appointment. By encouraging customers to rate the service they received, you can continuously strive to maintain high professional standards and meet their expectations.', 'https://codecanyon.net/item/bookly-ratings-addon/21574566', 'https://s3.envato.com/files/437889900/icon80x80%20(9).png', 'https://s3.envato.com/files/437889901/Ratings-590x300.jpg', '29.00', 373, '0.00', 2, '2018-03-13 06:19:21', 1, '2023-05-24 15:42:24'),
(30, 21841764, 'plugin', 0, 0, NULL, 'Bookly Cart (Add-on)', 'bookly-addon-cart', 'Do you want to boost your online sales even more? With With the Bookly Cart (Add-on), you can prompt your clients to book more appointments on your website. This feature enables clients to add multiple services to their cart and book them all in a single session. This way, clients can schedule additional future appointments with your business in one go. Also, the Cart step in Bookly can be customized to display summary information in a format that suits your needs.', 'https://codecanyon.net/item/bookly-cart-addon/21841764', 'https://s3.envato.com/files/437901471/icon80x80%20(4).png', 'https://s3.envato.com/files/437901472/Cart-590x300.jpg', '29.00', 1710, '5.00', 8, '2018-04-29 02:25:40', 1, '2023-05-24 15:42:24'),
(31, 21841828, 'plugin', 0, 0, NULL, 'Bookly Taxes (Add-on)', 'bookly-addon-taxes', 'Bookly Taxes (Add-on) makes it easy for you to include taxes in your service price. You can define multiple tax rates and apply them to selected services in Bookly. Once you’ve set up the tax rates, Bookly will automatically calculate and add the appropriate tax amount to the service price, resulting in a final price that includes taxes.', 'https://codecanyon.net/item/bookly-taxes-addon/21841828', 'https://s3.envato.com/files/437901541/icon80x80%20(5).png', 'https://s3.envato.com/files/437901542/Taxes-590x300.jpg', '39.00', 646, '3.00', 3, '2018-04-29 02:29:54', 1, '2023-05-24 15:42:24'),
(32, 21841856, 'plugin', 0, 0, NULL, 'Bookly Invoices (Add-on)', 'bookly-addon-invoices', 'Bookly Invoices (Add-on) allows you to automatically generate invoices for your clients upon ordered appointments in Bookly. You can choose to send payment requests when appointments are booked, approved, or received, and set a specific payment period. This feature allows you to quickly and easily collect payment from your clients and improve your cash flow.', 'https://codecanyon.net/item/bookly-invoices-addon/21841856', 'https://s3.envato.com/files/437887599/icon80x80%20(4).png', 'https://s3.envato.com/files/437887600/Invoices-590x300.jpg', '39.00', 1109, '4.33', 3, '2018-04-29 02:30:22', 1, '2023-05-24 15:42:24'),
(33, 21841871, 'plugin', 0, 0, NULL, 'Bookly Google Maps Address (Add-on)', 'bookly-addon-google-maps-address', 'The Bookly Google Maps Address (Add-on) streamlines the process of filling out address details in the booking form by using the Google Maps autocomplete service. Clients can quickly choose an address from the suggestions that appear as they type, minimizing errors and saving time. Address details entered in the Bookly booking form will be automatically saved in the Customers section for future reference.', 'https://codecanyon.net/item/bookly-google-maps-address-addon/21841871', 'https://s3.envato.com/files/437901578/icon80x80%20(6).png', 'https://s3.envato.com/files/437901579/Google-Maps-Address-590x300.jpg', '29.00', 489, '4.67', 3, '2018-04-29 02:45:11', 1, '2023-05-24 15:42:24'),
(34, 22060579, 'plugin', 0, 0, NULL, 'Bookly Advanced Google Calendar (Add-on)', 'bookly-addon-advanced-google-calendar', 'With the Advanced Google Calendar (Add-on), you can enjoy a complete bidirectional synchronization between Bookly Calendar and Google Calendar. This ensures that all appointments can be viewed and managed seamlessly in both calendars. Bookings made through Bookly are automatically synced to your Google Calendar, and any new events, updates, or cancellations made in your Google Calendar are instantly reflected in Bookly.', 'https://codecanyon.net/item/bookly-advanced-google-calendar-addon/22060579', 'https://s3.envato.com/files/437880953/icon80x80.png', 'https://s3.envato.com/files/437880955/Advanced-Google-Calendar-590x300.jpg', '49.00', 3095, '4.36', 14, '2018-06-06 04:37:53', 1, '2023-05-24 15:42:24'),
(35, 22060627, 'plugin', 0, 0, NULL, 'Bookly Customer Cabinet (Add-on)', 'bookly-addon-customer-cabinet', 'Looking for a way to provide your clients with online access to their bookings? Bookly Customer Cabinet (Add-on) allows you to set up a secure, personal customer account on your website where clients can view and manage their appointments and profile information. This includes the ability to reschedule and cancel appointments, view payments, and update personal information.', 'https://codecanyon.net/item/bookly-customer-cabinet-addon/22060627', 'https://s3.envato.com/files/437881780/icon80x80%20(3).png', 'https://s3.envato.com/files/437881782/Customer-Cabinet-590x300.jpg', '29.00', 1967, '4.17', 12, '2018-06-06 04:39:24', 1, '2023-05-24 15:42:24'),
(36, 22060703, 'plugin', 0, 0, NULL, 'Bookly Custom Duration (Add-on)', 'bookly-addon-custom-duration', 'Bookly Custom Duration (Add-on) allows your clients to have more control over their bookings by choosing how long they would like their appointments to last. This feature is especially useful for services that may require more time than the default duration, such as meetings or conferences. When clients book services with flexible duration, they can select the length of their appointment at the beginning of the booking process in the Bookly form, and the price will be calculated accordingly.', 'https://codecanyon.net/item/bookly-custom-duration-addon/22060703', 'https://s3.envato.com/files/437901822/icon80x80%20(7).png', 'https://s3.envato.com/files/437901823/Custom-Duration-590x300.jpg', '29.00', 1457, '4.33', 6, '2018-06-06 04:42:30', 1, '2023-05-24 15:42:24'),
(37, 22060797, 'plugin', 0, 0, NULL, 'Bookly PayUbiz (Add-on)', 'bookly-addon-payu-biz', 'If you want to accept and manage online payments from your clients in India, PayUbiz is a popular payment gateway that can help. With the Bookly PayUbiz (Add-on), you can easily integrate PayUbiz method into your Bookly PRO booking form and offer your customers a convenient way to pay instantly for their appointments.', 'https://codecanyon.net/item/bookly-payubiz-addon/22060797', 'https://s3.envato.com/files/437888863/icon80x80%20(8).png', 'https://s3.envato.com/files/437888864/PayUbiz-590x300.jpg', '29.00', 21, '0.00', 1, '2018-06-06 04:52:32', 1, '2023-05-24 15:42:24'),
(38, 22999600, 'plugin', 0, 0, NULL, 'Bookly Tasks (Add-on) ', 'bookly-addon-tasks', 'Bookly Tasks (Add-on) offers a solution for businesses that provide services without requiring clients to select a specific day and time. With this feature, clients and administrators can create and manage a list of tasks or unscheduled appointments within the Bookly admin area. For instance, employees can set a task to arrange a meeting with a specific client, and once it’s done, they can schedule the date and time, which will automatically convert the task into an appointment.', 'https://codecanyon.net/item/bookly-tasks-addon/22999600', 'https://s3.envato.com/files/437890581/icon80x80%20(10).png', 'https://s3.envato.com/files/437890582/Tasks-590x300.jpg', '29.00', 466, '0.00', 1, '2018-12-12 00:17:51', 1, '2023-05-24 15:42:24'),
(39, 22999632, 'plugin', 0, 0, NULL, 'Bookly Collaborative Services (Add-on)', 'bookly-addon-collaborative-services', 'Do you offer services that involve two or more staff members working together or shared resources? With the Bookly Collaborative Services (Add-on), you can create and sell complex services that involve multiple employees and resources, while your clients easily book a single service they need. Whether your employees work together to provide a service or need to use shared resources in an appointment, Bookly will make sure everything is properly scheduled.', 'https://codecanyon.net/item/bookly-collaborative-services-addon/22999632', 'https://s3.envato.com/files/437881105/icon80x80%20(1).png', 'https://s3.envato.com/files/437881106/Collaborative-Services-590x300.jpg', '39.00', 746, '4.50', 4, '2018-12-12 00:22:29', 1, '2023-05-24 15:42:24'),
(40, 23324001, 'plugin', 0, 0, NULL, 'Bookly Custom Statuses (Add-on)', 'bookly-addon-custom-statuses', 'If you need to manage your online bookings more efficiently and want to assign custom labels to your Bookly appointments, you can use Bookly Custom Statuses (Add-on). When editing an appointment, you can select a custom status from the list you created, allowing you to add more specific information to the appointment. You can also set up email notifications that correspond to each custom appointment status.', 'https://codecanyon.net/item/bookly-custom-statuses-addon/23324001', 'https://s3.envato.com/files/437902454/icon80x80%20(8).png', 'https://s3.envato.com/files/437902455/Custom-Statuses-590x300.jpg', '29.00', 530, '5.00', 3, '2019-02-18 20:10:01', 1, '2023-05-24 15:42:24'),
(41, 23350952, 'plugin', 0, 0, NULL, 'Bookly Outlook Calendar (Add-on)', 'bookly-addon-outlook-calendar', 'Bookly Outlook Calendar (Add-on) enables a complete bidirectional synchronization between Bookly Calendar and Outlook Calendar, ensuring seamless management of appointments across both platforms. With this add-on, appointments made through Bookly will be automatically added to the linked Outlook Calendar, while updates, cancellations, and new events from Outlook Calendar will be immediately reflected in Bookly.', 'https://codecanyon.net/item/bookly-outlook-calendar-addon/23350952', 'https://s3.envato.com/files/437888057/icon80x80%20(5).png', 'https://s3.envato.com/files/437888058/Outlook-Calendar-590x300.jpg', '49.00', 966, '3.00', 4, '2019-02-21 23:33:34', 1, '2023-05-24 15:42:24'),
(42, 24219988, 'plugin', 0, 0, NULL, 'Bookly PayPal Checkout (Add-on)', 'bookly-addon-paypal-checkout', 'Bookly PayPal Checkout (Add-on) provides you with the ability to accept secure online payments at the time of booking through one of the most popular payment gateways. With this add-on, you can seamlessly integrate the PayPal payment option into your Bookly PRO booking form. By offering this convenient payment option to your customers, they can easily purchase your services with just a few clicks.', 'https://codecanyon.net/item/bookly-paypal-checkout-addon/24219988', 'https://s3.envato.com/files/437888402/icon80x80%20(6).png', 'https://s3.envato.com/files/437888403/PayPal-Checkout-590x300.jpg', '29.00', 609, '0.00', 0, '2019-07-30 18:31:46', 1, '2023-05-24 15:42:24'),
(43, 29936495, 'plugin', 0, 0, NULL, 'Bookly Discounts (Add-on)', 'bookly-addon-discounts', 'Providing discounts is a proven method to attract customers and boost sales. Bookly Discounts (Add-on) enables you to create automatic conditional discounts based on various factors like the number of customers or services booked. Once the booking details meet the conditions you set, the discounted price will be automatically applied, and customers will see the reduced price instantly. ', 'https://codecanyon.net/item/bookly-discounts-addon/29936495', 'https://s3.envato.com/files/437902644/icon80x80%20(9).png', 'https://s3.envato.com/files/437902653/Discounts-590x300.jpg', '29.00', 288, '0.00', 0, '2021-01-05 01:18:25', 1, '2023-05-24 15:42:24'),
(44, 34925755, 'plugin', 0, 0, NULL, 'Bookly Mailchimp (Add-on)', 'bookly-addon-mailchimp', 'Bookly Mailchimp (Add-on) offers a seamless integration between your Bookly booking system and your Mailchimp account, one of the most popular email marketing platforms available. With this integration, you can easily automate your email campaigns and build strong relationships with your customers. New customers in Bookly will be automatically added as new subscribers to your Mailchimp mailing list, allowing you to easily deliver targeted messages that drive sales and engagement.', 'https://codecanyon.net/item/bookly-mailchimp-addon/34925755', 'https://s3.envato.com/files/437902744/icon80x80%20(10).png', 'https://s3.envato.com/files/437902745/Mailchimp-590x300.jpg', '29.00', 101, '0.00', 0, '2021-11-24 03:10:56', 1, '2023-05-24 15:42:24');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_staff`
--

CREATE TABLE `qdc_bookly_staff` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `wp_user_id` bigint(20) unsigned DEFAULT NULL,
  `attachment_id` int(10) unsigned DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `time_zone` varchar(255) DEFAULT NULL,
  `info` text DEFAULT NULL,
  `working_time_limit` int(10) unsigned DEFAULT NULL,
  `visibility` enum('public','private','archive') NOT NULL DEFAULT 'public',
  `position` int(11) NOT NULL DEFAULT 9999,
  `google_data` text DEFAULT NULL,
  `outlook_data` text DEFAULT NULL,
  `zoom_authentication` enum('default','jwt','oauth') NOT NULL DEFAULT 'default',
  `zoom_jwt_api_key` varchar(255) DEFAULT NULL,
  `zoom_jwt_api_secret` varchar(255) DEFAULT NULL,
  `zoom_oauth_token` text DEFAULT NULL,
  `icalendar` tinyint(1) NOT NULL DEFAULT 0,
  `icalendar_token` varchar(255) DEFAULT NULL,
  `icalendar_days_before` int(11) NOT NULL DEFAULT 365,
  `icalendar_days_after` int(11) NOT NULL DEFAULT 365,
  `color` varchar(255) NOT NULL DEFAULT '#dddddd',
  `gateways` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bookly_staff`
--

INSERT INTO `qdc_bookly_staff` VALUES
(1, NULL, NULL, NULL, 'Quick Dental Care', 'info@quickdental.com.bd', '+8801307978439', NULL, NULL, NULL, 'public', 1, NULL, NULL, 'default', NULL, NULL, NULL, 0, 'ea091be0982334fb14fdfac3508107d0', 365, 365, '#43D580', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_staff_schedule_items`
--

CREATE TABLE `qdc_bookly_staff_schedule_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` int(10) unsigned NOT NULL,
  `location_id` int(10) unsigned DEFAULT NULL,
  `day_index` int(10) unsigned NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_ids_idx` (`staff_id`,`day_index`,`location_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bookly_staff_schedule_items`
--

INSERT INTO `qdc_bookly_staff_schedule_items` VALUES
(1, 1, NULL, 1, NULL, NULL),
(2, 1, NULL, 2, '08:00:00', '18:00:00'),
(3, 1, NULL, 3, '08:00:00', '18:00:00'),
(4, 1, NULL, 4, '08:00:00', '18:00:00'),
(5, 1, NULL, 5, '08:00:00', '18:00:00'),
(6, 1, NULL, 6, '08:00:00', '18:00:00'),
(7, 1, NULL, 7, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_staff_services`
--

CREATE TABLE `qdc_bookly_staff_services` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` int(10) unsigned NOT NULL,
  `service_id` int(10) unsigned NOT NULL,
  `location_id` int(10) unsigned DEFAULT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `deposit` varchar(100) NOT NULL DEFAULT '100%',
  `capacity_min` int(11) NOT NULL DEFAULT 1,
  `capacity_max` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_ids_idx` (`staff_id`,`service_id`,`location_id`),
  KEY `service_id` (`service_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bookly_staff_services`
--

INSERT INTO `qdc_bookly_staff_services` VALUES
(1, 1, 1, NULL, '0.00', '100%', 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_stats`
--

CREATE TABLE `qdc_bookly_stats` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bookly_sub_services`
--

CREATE TABLE `qdc_bookly_sub_services` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('service','spare_time') NOT NULL DEFAULT 'service',
  `service_id` int(10) unsigned NOT NULL,
  `sub_service_id` int(10) unsigned DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT 9999,
  PRIMARY KEY (`id`),
  KEY `service_id` (`service_id`),
  KEY `sub_service_id` (`sub_service_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bwg_album`
--

CREATE TABLE `qdc_bwg_album` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` mediumtext NOT NULL,
  `preview_image` mediumtext NOT NULL,
  `random_preview_image` mediumtext NOT NULL,
  `order` bigint(20) NOT NULL,
  `author` bigint(20) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `modified_date` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bwg_album_gallery`
--

CREATE TABLE `qdc_bwg_album_gallery` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `album_id` bigint(20) NOT NULL,
  `is_album` tinyint(1) NOT NULL,
  `alb_gal_id` bigint(20) NOT NULL,
  `order` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bwg_file_paths`
--

CREATE TABLE `qdc_bwg_file_paths` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `is_dir` tinyint(1) DEFAULT 0,
  `path` mediumtext DEFAULT NULL,
  `type` varchar(5) DEFAULT NULL,
  `name` varchar(250) DEFAULT NULL,
  `filename` varchar(250) DEFAULT NULL,
  `alt` varchar(250) DEFAULT NULL,
  `thumb` varchar(250) DEFAULT NULL,
  `size` varchar(10) DEFAULT NULL,
  `resolution` varchar(15) DEFAULT NULL,
  `resolution_thumb` varchar(15) DEFAULT NULL,
  `credit` varchar(250) DEFAULT NULL,
  `aperture` int(10) DEFAULT NULL,
  `camera` varchar(250) DEFAULT NULL,
  `caption` varchar(250) DEFAULT NULL,
  `iso` int(10) DEFAULT NULL,
  `orientation` int(10) DEFAULT NULL,
  `copyright` varchar(250) DEFAULT NULL,
  `tags` mediumtext DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `author` bigint(20) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bwg_file_paths`
--

INSERT INTO `qdc_bwg_file_paths` VALUES
(46, 1, '/', NULL, 'imported_from_media_libray', 'imported_from_media_libray', 'imported_from_media_libray', '/filemanager/images/dir.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-10-12 21:30:52', 1),
(47, 0, '', 'jpg', 'restoration1.jpg', 'restoration1', 'restoration1', 'thumb/restoration1.jpg', '62 KB', '', '', '', 0, '', '', 0, 0, '', '', '2024-10-12 21:30:52', 1),
(48, 0, '/imported_from_media_libray/', 'jpg', 'restoration1.jpg', 'restoration1', 'restoration1', 'thumb/restoration1.jpg', '62 KB', '510 x 510 px', '500.00x500.00', '', 0, '', '', 0, 0, '', '', '2024-10-12 21:30:52', 1),
(49, 0, '', 'jpg', 'restoration3.jpg', 'restoration3', 'restoration3', 'thumb/restoration3.jpg', '45 KB', '', '', '', 0, '', '', 0, 0, '', '', '2024-10-12 21:31:03', 1),
(50, 0, '/imported_from_media_libray/', 'jpg', 'restoration3.jpg', 'restoration3', 'restoration3', 'thumb/restoration3.jpg', '45 KB', '510 x 510 px', '500.00x500.00', '', 0, '', '', 0, 0, '', '', '2024-10-12 21:31:03', 1),
(51, 0, '', 'jpg', 'restoration2.jpg', 'restoration2', 'restoration2', 'thumb/restoration2.jpg', '47 KB', '', '', '', 0, '', '', 0, 0, '', '', '2024-10-12 21:31:34', 1),
(52, 0, '/imported_from_media_libray/', 'jpg', 'restoration2.jpg', 'restoration2', 'restoration2', 'thumb/restoration2.jpg', '47 KB', '510 x 510 px', '500.00x500.00', '', 0, '', '', 0, 0, '', '', '2024-10-12 21:31:34', 1);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bwg_gallery`
--

CREATE TABLE `qdc_bwg_gallery` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` mediumtext NOT NULL,
  `page_link` mediumtext NOT NULL,
  `preview_image` mediumtext NOT NULL,
  `random_preview_image` mediumtext NOT NULL,
  `order` bigint(20) NOT NULL,
  `author` bigint(20) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `gallery_type` varchar(32) NOT NULL,
  `gallery_source` varchar(256) NOT NULL,
  `autogallery_image_number` int(4) NOT NULL,
  `update_flag` varchar(32) NOT NULL,
  `modified_date` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bwg_gallery`
--

INSERT INTO `qdc_bwg_gallery` VALUES
(1, 'Gallery', 'gallery', '', '', '', '/imported_from_media_libray/thumb/restoration2.jpg', 0, 1, 1, '', '', 12, '', 1717154375);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bwg_image`
--

CREATE TABLE `qdc_bwg_image` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `gallery_id` bigint(20) NOT NULL,
  `slug` longtext NOT NULL,
  `filename` varchar(255) NOT NULL,
  `image_url` mediumtext NOT NULL,
  `thumb_url` mediumtext NOT NULL,
  `description` mediumtext NOT NULL,
  `alt` mediumtext NOT NULL,
  `date` varchar(128) NOT NULL,
  `size` varchar(128) NOT NULL,
  `filetype` varchar(128) NOT NULL,
  `resolution` varchar(128) NOT NULL,
  `resolution_thumb` varchar(128) NOT NULL,
  `author` bigint(20) NOT NULL,
  `order` bigint(20) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `comment_count` bigint(20) NOT NULL,
  `avg_rating` float NOT NULL,
  `rate_count` bigint(20) NOT NULL,
  `hit_count` bigint(20) NOT NULL,
  `redirect_url` varchar(255) NOT NULL,
  `pricelist_id` bigint(20) NOT NULL,
  `modified_date` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bwg_image`
--

INSERT INTO `qdc_bwg_image` VALUES
(1, 1, 'restoration1', 'restoration1', '/imported_from_media_libray/restoration1.jpg', '/imported_from_media_libray/thumb/restoration1.jpg', '', 'restoration1', '2024-10-12 21:30:52', '62 KB', 'jpg', '510 x 510 px', '500.00x500.00', 1, 3, 1, 0, 0, 0, 0, '', 0, 1728768708),
(2, 1, 'restoration3', 'restoration3', '/imported_from_media_libray/restoration3.jpg', '/imported_from_media_libray/thumb/restoration3.jpg', '', 'restoration3', '2024-10-12 21:31:03', '45 KB', 'jpg', '510 x 510 px', '500.00x500.00', 1, 2, 1, 0, 0, 0, 0, '', 0, 1728768708),
(3, 1, 'restoration2', 'restoration2', '/imported_from_media_libray/restoration2.jpg', '/imported_from_media_libray/thumb/restoration2.jpg', '', 'restoration2', '2024-10-12 21:31:33', '47 KB', 'jpg', '510 x 510 px', '500.00x500.00', 1, 1, 1, 0, 0, 0, 0, '', 0, 1728768708);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bwg_image_comment`
--

CREATE TABLE `qdc_bwg_image_comment` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `image_id` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `date` varchar(64) NOT NULL,
  `comment` mediumtext NOT NULL,
  `url` mediumtext NOT NULL,
  `mail` mediumtext NOT NULL,
  `published` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bwg_image_rate`
--

CREATE TABLE `qdc_bwg_image_rate` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `image_id` bigint(20) NOT NULL,
  `rate` float NOT NULL,
  `ip` varchar(64) NOT NULL,
  `date` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bwg_image_tag`
--

CREATE TABLE `qdc_bwg_image_tag` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tag_id` bigint(20) NOT NULL,
  `image_id` bigint(20) NOT NULL,
  `gallery_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bwg_shortcode`
--

CREATE TABLE `qdc_bwg_shortcode` (
  `id` bigint(20) NOT NULL,
  `tagtext` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bwg_shortcode`
--

INSERT INTO `qdc_bwg_shortcode` VALUES
(1, ' use_option_defaults="1" type="gallery" theme_id="1" gallery_id="1" tag="0" gallery_type="thumbnails" thumb_width="250" thumb_height="140" image_column_number="5" image_enable_page="1" images_per_page="30" load_more_image_count="30" sort_by="order" order_by="asc" show_search_box="0" placeholder="Search" search_box_width="330" show_sort_images="0" show_tag_box="0" showthumbs_name="0" show_gallery_description="0" image_title="" show_thumb_description="0" play_icon="1" gallery_download="0" ecommerce_icon="" thumb_click_action="open_lightbox" thumb_link_target="1" popup_fullscreen="1" popup_width="800" popup_height="500" popup_effect="" popup_effect_duration="0.1" popup_autoplay="0" popup_interval="2.5" popup_enable_filmstrip="1" popup_filmstrip_height="" popup_enable_ctrl_btn="1" popup_enable_fullscreen="1" popup_enable_comment="1" popup_enable_email="1" popup_enable_captcha="0" gdpr_compliance="0" comment_moderation="0" popup_enable_info="1" popup_info_always_show="0" popup_info_full_width="1" autohide_lightbox_navigation="0" popup_hit_counter="0" popup_enable_rate="0" popup_enable_zoom="0" popup_enable_fullsize_image="0" popup_enable_download="0" show_image_counts="0" enable_loop="1" enable_addthis="0" addthis_profile_id="" popup_enable_facebook="1" popup_enable_twitter="1" popup_enable_pinterest="0" popup_enable_tumblr="0" popup_enable_ecommerce="1" watermark_type="none" watermark_link="https://10web.io/"');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_bwg_theme`
--

CREATE TABLE `qdc_bwg_theme` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `options` longtext NOT NULL,
  `default_theme` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_bwg_theme`
--

INSERT INTO `qdc_bwg_theme` VALUES
(1, 'Light', '{"album_compact_back_font_color":"323A45","album_compact_back_font_size":15,"album_compact_back_font_style":"Ubuntu","album_compact_back_font_weight":"bold","album_compact_back_padding":"0","album_compact_gal_title_align":"center","album_compact_gal_title_font_color":"323A45","album_compact_gal_title_font_size":18,"album_compact_gal_title_font_style":"Ubuntu","album_compact_gal_title_font_weight":"bold","album_compact_gal_title_margin":"0 2px 2px 2px","album_compact_gal_title_shadow":"0px 0px 0px #888888","album_compact_thumb_align":"center","album_compact_thumb_bg_color":"000000","album_compact_thumb_bg_transparent":0,"album_compact_thumb_border_color":"CCCCCC","album_compact_thumb_border_radius":"0","album_compact_thumb_border_style":"none","album_compact_thumb_border_width":0,"album_compact_thumb_box_shadow":"0px 0px 0px #888888","album_compact_thumb_hover_effect":"zoom","album_compact_thumb_hover_effect_value":"1.08","album_compact_thumb_margin":4,"album_compact_thumb_padding":0,"album_compact_thumb_title_pos":"bottom","album_compact_thumb_transition":1,"album_compact_thumb_transparent":100,"album_compact_thumb_bg_transparency":30,"album_compact_thumbs_bg_color":"FFFFFF","album_compact_title_font_color":"323A45","album_compact_title_font_color_hover":"FFFFFF","album_compact_title_font_size":16,"album_compact_title_font_style":"Ubuntu","album_compact_title_font_weight":"bold","album_compact_title_margin":"2px","album_compact_title_shadow":"0px 0px 0px #888888","album_extended_back_font_color":"000000","album_extended_back_font_size":20,"album_extended_back_font_style":"Ubuntu","album_extended_back_font_weight":"bold","album_extended_back_padding":"0","album_extended_desc_font_color":"5C5C5C","album_extended_desc_font_size":16,"album_extended_desc_font_style":"Ubuntu","album_extended_desc_font_weight":"normal","album_extended_desc_more_color":"007AFF","album_extended_desc_more_size":12,"album_extended_desc_padding":"0px 0px 0px 0px","album_extended_desc_span_border_color":"CCCCCC","album_extended_desc_span_border_style":"none","album_extended_desc_span_border_width":0,"album_extended_div_bg_color":"FAFAFA","album_extended_div_bg_transparent":0,"album_extended_div_border_radius":"14px","album_extended_div_margin":"20px 20px 0px 0px","album_extended_div_padding":0,"album_extended_div_separator_color":"E0E0E0","album_extended_div_separator_style":"solid","album_extended_div_separator_width":0,"album_extended_gal_title_align":"right","album_extended_gal_title_font_color":"CCCCCC","album_extended_gal_title_font_size":16,"album_extended_gal_title_font_style":"Ubuntu","album_extended_gal_title_font_weight":"bold","album_extended_gal_title_margin":"2px","album_extended_gal_title_shadow":"0px 0px 0px #888888","album_extended_text_div_bg_color":"FAFAFA","album_extended_text_div_border_color":"E8E8E8","album_extended_text_div_border_radius":"0","album_extended_text_div_border_style":"none","album_extended_text_div_border_width":0,"album_extended_text_div_padding":"16px","album_extended_thumb_align":"left","album_extended_thumb_bg_color":"FFFFFF","album_extended_thumb_bg_transparent":0,"album_extended_thumb_border_color":"FAFAFA","album_extended_thumb_border_radius":"10px","album_extended_thumb_border_style":"none","album_extended_thumb_border_width":0,"album_extended_thumb_box_shadow":"","album_extended_thumb_div_bg_color":"FAFAFA","album_extended_thumb_div_border_color":"E8E8E8","album_extended_thumb_div_border_radius":"","album_extended_thumb_div_border_style":"none","album_extended_thumb_div_border_width":0,"album_extended_thumb_div_padding":"14px","album_extended_thumb_hover_effect":"none","album_extended_thumb_hover_effect_value":"1.03","album_extended_thumb_margin":0,"album_extended_thumb_padding":0,"album_extended_thumb_transition":0,"album_extended_thumb_transparent":100,"album_extended_thumbs_bg_color":"FFFFFF","album_extended_title_desc_alignment":"top","album_extended_title_font_color":"000000","album_extended_title_font_size":22,"album_extended_title_font_style":"Ubuntu","album_extended_title_font_weight":"bold","album_extended_title_margin_bottom":0,"album_extended_title_padding":"0px 0px 0px 0px","album_extended_title_span_border_color":"CCCCCC","album_extended_title_span_border_style":"none","album_extended_title_span_border_width":0,"album_masonry_back_font_color":"323A45","album_masonry_back_font_size":15,"album_masonry_back_font_style":"Ubuntu","album_masonry_back_font_weight":"bold","album_masonry_back_padding":"0","album_masonry_container_margin":1,"album_masonry_gal_title_align":"center","album_masonry_gal_title_font_color":"323A45","album_masonry_gal_title_font_size":18,"album_masonry_gal_title_font_style":"Ubuntu","album_masonry_gal_title_font_weight":"bold","album_masonry_gal_title_margin":"0 2px 2px 2px","album_masonry_gal_title_shadow":"0px 0px 0px #888888","album_masonry_thumb_align":"center","album_masonry_thumb_bg_color":"000000","album_masonry_thumb_bg_transparent":0,"album_masonry_thumb_border_color":"CCCCCC","album_masonry_thumb_border_radius":"0","album_masonry_thumb_border_style":"none","album_masonry_thumb_border_width":0,"album_masonry_thumb_box_shadow":"","album_masonry_thumb_hover_effect":"zoom","album_masonry_thumb_hover_effect_value":"1.08","album_masonry_thumb_margin":0,"album_masonry_thumb_padding":4,"album_masonry_thumb_title_font_color_hover":"FFFFFF","album_masonry_thumb_title_pos":"bottom","album_masonry_thumb_transition":1,"album_masonry_thumb_transparent":100,"album_masonry_thumbs_bg_color":"FFFFFF","album_masonry_title_font_color":"323A45","album_masonry_title_font_size":16,"album_masonry_title_font_style":"Ubuntu","album_masonry_title_font_weight":"bold","album_masonry_title_margin":"","album_masonry_title_shadow":"0px 0px 0px #888888","blog_style_align":"center","blog_style_bg_color":"FFFFFF","blog_style_border_color":"F5F5F5","blog_style_border_radius":"0","blog_style_border_style":"solid","blog_style_border_width":1,"blog_style_box_shadow":"","blog_style_gal_title_align":"center","blog_style_gal_title_font_color":"323A45","blog_style_gal_title_font_size":16,"blog_style_gal_title_font_style":"Ubuntu","blog_style_gal_title_font_weight":"bold","blog_style_gal_title_margin":"2px","blog_style_gal_title_shadow":"0px 0px 0px #888888","blog_style_img_font_color":"000000","blog_style_img_font_family":"Ubuntu","blog_style_img_font_size":16,"blog_style_margin":"2px","blog_style_padding":"0","blog_style_share_buttons_align":"right","blog_style_share_buttons_bg_color":"FFFFFF","blog_style_share_buttons_bg_transparent":0,"blog_style_share_buttons_border_color":"000000","blog_style_share_buttons_border_radius":"0","blog_style_share_buttons_border_style":"none","blog_style_share_buttons_border_width":0,"blog_style_share_buttons_color":"B3AFAF","blog_style_share_buttons_font_size":20,"blog_style_share_buttons_margin":"5px auto 10px auto","blog_style_transparent":80,"carousel_caption_background_color":"000000","carousel_caption_bottom":0,"carousel_caption_p_color":"FFFFFF","carousel_caption_p_font_size":14,"carousel_caption_p_font_weight":"bold","carousel_caption_p_mergin":0,"carousel_caption_p_pedding":5,"carousel_close_btn_transparent":50,"carousel_close_rl_btn_hover_color":"191919","carousel_cont_bg_color":"000000","carousel_cont_btn_transparent":0,"carousel_feature_border_color":"5D204F","carousel_feature_border_style":"none","carousel_feature_border_width":2,"carousel_font_family":"arial","carousel_mergin_bottom":"0.5","carousel_play_pause_btn_size":25,"carousel_rl_btn_bg_color":"FFFFFF","carousel_rl_btn_border_color":"FFFFFF","carousel_rl_btn_border_radius":"20px","carousel_rl_btn_border_style":"none","carousel_rl_btn_border_width":0,"carousel_rl_btn_color":"303030","carousel_rl_btn_height":35,"carousel_rl_btn_size":15,"carousel_rl_btn_style":"bwg-icon-angle","carousel_rl_btn_width":35,"carousel_title_border_radius":"5px","carousel_title_opacity":100,"carousel_gal_title_align":"center","carousel_gal_title_font_color":"323A45","carousel_gal_title_font_size":16,"carousel_gal_title_font_style":"Ubuntu","carousel_gal_title_font_weight":"bold","carousel_gal_title_margin":"2px","carousel_gal_title_shadow":"0px 0px 0px #888888","compact_container_margin":"1","container_margin":"1","image_browser_align":"center","image_browser_bg_color":"EBEBEB","image_browser_border_color":"F5F5F5","image_browser_border_radius":"0","image_browser_border_style":"none","image_browser_border_width":1,"image_browser_box_shadow":"","image_browser_full_bg_color":"F5F5F5","image_browser_full_border_color":"F7F7F7","image_browser_full_border_radius":"0","image_browser_full_border_style":"none","image_browser_full_border_width":2,"image_browser_full_padding":"4px","image_browser_full_transparent":90,"image_browser_gal_title_align":"center","image_browser_gal_title_font_color":"323A45","image_browser_gal_title_font_size":16,"image_browser_gal_title_font_style":"Ubuntu","image_browser_gal_title_font_weight":"bold","image_browser_gal_title_margin":"2px","image_browser_gal_title_shadow":"0px 0px 0px #888888","image_browser_image_description_align":"center","image_browser_image_description_bg_color":"EBEBEB","image_browser_image_description_border_color":"FFFFFF","image_browser_image_description_border_radius":"0","image_browser_image_description_border_style":"none","image_browser_image_description_border_width":1,"image_browser_image_description_margin":"0px 5px 0px 5px","image_browser_image_description_padding":"8px 8px 8px 8px","image_browser_image_title_align":"top","image_browser_img_font_color":"000000","image_browser_img_font_family":"Ubuntu","image_browser_img_font_size":15,"image_browser_margin":"2px auto","image_browser_padding":"4px","image_browser_transparent":80,"lightbox_bg_color":"FFFFFF","lightbox_bg_transparent":100,"lightbox_close_btn_bg_color":"FFFFFF","lightbox_close_btn_border_color":"FFFFFF","lightbox_close_btn_border_radius":"16px","lightbox_close_btn_border_style":"none","lightbox_close_btn_border_width":2,"lightbox_close_btn_box_shadow":"","lightbox_close_btn_color":"808080","lightbox_close_btn_full_color":"000000","lightbox_close_btn_height":30,"lightbox_close_btn_right":"-15","lightbox_close_btn_size":20,"lightbox_close_btn_top":"-20","lightbox_close_btn_transparent":60,"lightbox_close_btn_width":30,"lightbox_close_rl_btn_hover_color":"808080","lightbox_comment_author_font_size":14,"lightbox_comment_bg_color":"FFFFFF","lightbox_comment_body_font_size":12,"lightbox_comment_button_bg_color":"2F2F2F","lightbox_comment_button_border_color":"666666","lightbox_comment_button_border_radius":"7px","lightbox_comment_button_border_style":"none","lightbox_comment_button_border_width":1,"lightbox_comment_button_padding":"10px 10px","lightbox_comment_date_font_size":10,"lightbox_comment_font_color":"7A7A7A","lightbox_comment_font_size":12,"lightbox_comment_font_style":"Ubuntu","lightbox_comment_input_bg_color":"F7F8F9","lightbox_comment_input_border_color":"EBEBEB","lightbox_comment_input_border_radius":"7px","lightbox_comment_input_border_style":"none","lightbox_comment_input_border_width":2,"lightbox_comment_input_padding":"5px","lightbox_comment_pos":"left","lightbox_comment_separator_color":"383838","lightbox_comment_separator_style":"none","lightbox_comment_separator_width":20,"lightbox_comment_share_button_color":"808080","lightbox_comment_width":350,"lightbox_ctrl_btn_align":"center","lightbox_ctrl_btn_color":"808080","lightbox_ctrl_btn_height":20,"lightbox_ctrl_btn_margin_left":7,"lightbox_ctrl_btn_margin_top":10,"lightbox_ctrl_btn_pos":"bottom","lightbox_ctrl_btn_transparent":100,"lightbox_ctrl_cont_bg_color":"FFFFFF","lightbox_ctrl_cont_border_radius":4,"lightbox_ctrl_cont_transparent":85,"lightbox_description_color":"B0B0B0","lightbox_description_font_size":"13","lightbox_description_font_style":"Ubuntu","lightbox_description_font_weight":"bold","lightbox_filmstrip_pos":"bottom","lightbox_filmstrip_rl_bg_color":"EBEBEB","lightbox_filmstrip_rl_btn_color":"808080","lightbox_filmstrip_rl_btn_size":20,"lightbox_filmstrip_thumb_active_border_color":"FFFFFF","lightbox_filmstrip_thumb_active_border_width":0,"lightbox_filmstrip_thumb_border_color":"000000","lightbox_filmstrip_thumb_border_radius":"0","lightbox_filmstrip_thumb_border_style":"none","lightbox_filmstrip_thumb_border_width":1,"lightbox_filmstrip_thumb_deactive_transparent":80,"lightbox_filmstrip_thumb_margin":"0 1px","lightbox_hit_align":"left","lightbox_hit_bg_color":"000000","lightbox_hit_bg_transparent":"70","lightbox_hit_border_color":"000000","lightbox_hit_border_radius":"5px","lightbox_hit_border_style":"none","lightbox_hit_border_width":"1","lightbox_hit_color":"FFFFFF","lightbox_hit_font_size":14,"lightbox_hit_font_style":"Ubuntu","lightbox_hit_font_weight":"normal","lightbox_hit_margin":"0 5px","lightbox_hit_padding":"5px","lightbox_hit_pos":"bottom","lightbox_info_align":"left","lightbox_info_bg_color":"FFFFFF","lightbox_info_bg_transparent":"70","lightbox_info_border_color":"000000","lightbox_info_border_radius":"0px","lightbox_info_border_style":"none","lightbox_info_border_width":"1","lightbox_info_margin":"10px 10px -5px 10px","lightbox_info_padding":"10px 7px 44px 10px","lightbox_info_pos":"bottom","lightbox_overlay_bg_color":"EEEEEE","lightbox_overlay_bg_transparent":60,"lightbox_rate_align":"left","lightbox_rate_color":"F9D062","lightbox_rate_hover_color":"F7B50E","lightbox_rate_icon":"star","lightbox_rate_padding":"15px","lightbox_rate_pos":"top","lightbox_rate_size":"20","lightbox_rate_stars_count":"5","lightbox_rl_btn_bg_color":"FFFFFF","lightbox_rl_btn_border_color":"FFFFFF","lightbox_rl_btn_border_radius":"20px","lightbox_rl_btn_border_style":"none","lightbox_rl_btn_border_width":0,"lightbox_rl_btn_box_shadow":"","lightbox_rl_btn_color":"ADADAD","lightbox_rl_btn_height":35,"lightbox_rl_btn_size":25,"lightbox_rl_btn_style":"bwg-icon-angle","lightbox_rl_btn_transparent":"60","lightbox_rl_btn_width":35,"lightbox_title_color":"808080","lightbox_title_font_size":"16","lightbox_title_font_style":"Ubuntu","lightbox_title_font_weight":"bold","lightbox_toggle_btn_height":20,"lightbox_toggle_btn_width":100,"masonry_container_margin":"1","masonry_description_color":"323A45","masonry_description_font_size":16,"masonry_description_font_style":"Ubuntu","masonry_thumb_align":"center","masonry_thumb_bg_color":"000000","masonry_thumb_bg_transparent":"0","masonry_thumb_border_color":"CCCCCC","masonry_thumb_border_radius":"0","masonry_thumb_border_style":"none","masonry_thumb_border_width":"0","masonry_thumb_gal_title_align":"center","masonry_thumb_gal_title_font_color":"323A45","masonry_thumb_gal_title_font_size":16,"masonry_thumb_gal_title_font_style":"Ubuntu","masonry_thumb_gal_title_font_weight":"bold","masonry_thumb_gal_title_margin":"2px","masonry_thumb_gal_title_shadow":"","masonry_thumb_hover_effect":"zoom","masonry_thumb_hover_effect_value":"1.08","masonry_thumb_padding":"4","masonry_thumb_title_font_color":"323A45","masonry_thumb_title_font_color_hover":"FFFFFF","masonry_thumb_title_font_size":16,"masonry_thumb_title_font_style":"Ubuntu","masonry_thumb_title_font_weight":"bold","masonry_thumb_title_margin":"2px","masonry_thumb_transition":"1","masonry_thumb_transparent":"100","masonry_thumb_bg_transparency":"30","masonry_thumbs_bg_color":"FFFFFF","mosaic_container_margin":"1","mosaic_thumb_align":"center","mosaic_thumb_bg_color":"000000","mosaic_thumb_bg_transparent":"0","mosaic_thumb_border_color":"CCCCCC","mosaic_thumb_border_radius":"0","mosaic_thumb_border_style":"none","mosaic_thumb_border_width":"0","mosaic_thumb_gal_title_align":"center","mosaic_thumb_gal_title_font_color":"323A45","mosaic_thumb_gal_title_font_size":16,"mosaic_thumb_gal_title_font_style":"Ubuntu","mosaic_thumb_gal_title_font_weight":"bold","mosaic_thumb_gal_title_margin":"2px","mosaic_thumb_gal_title_shadow":"","mosaic_thumb_hover_effect":"zoom","mosaic_thumb_hover_effect_value":"1.08","mosaic_thumb_padding":"2","mosaic_thumb_title_font_color":"323A45","mosaic_thumb_title_font_color_hover":"FFFFFF","mosaic_thumb_title_font_size":16,"mosaic_thumb_title_font_style":"Ubuntu","mosaic_thumb_title_font_weight":"bold","mosaic_thumb_title_margin":"2px","mosaic_thumb_title_shadow":"","mosaic_thumb_transition":"1","mosaic_thumb_transparent":"100","mosaic_thumb_bg_transparency":"30","mosaic_thumbs_bg_color":"FFFFFF","page_nav_align":"center","page_nav_border_color":"E3E3E3","page_nav_border_radius":"0","page_nav_border_style":"solid","page_nav_border_width":1,"page_nav_box_shadow":"0","page_nav_button_bg_color":"FFFFFF","page_nav_button_bg_transparent":100,"page_nav_button_text":0,"page_nav_button_transition":1,"page_nav_font_color":"666666","page_nav_font_size":12,"page_nav_font_style":"Ubuntu","page_nav_font_weight":"bold","page_nav_margin":"0","page_nav_number":0,"page_nav_padding":"3px 6px","page_nav_position":"bottom","slideshow_close_btn_transparent":100,"slideshow_close_rl_btn_hover_color":"BABABA","slideshow_cont_bg_color":"F2F2F2","slideshow_description_background_color":"000000","slideshow_description_border_radius":"0","slideshow_description_color":"FFFFFF","slideshow_description_font":"Ubuntu","slideshow_description_font_size":14,"slideshow_description_opacity":70,"slideshow_description_padding":"5px 10px 5px 10px","slideshow_dots_active_background_color":"FFFFFF","slideshow_dots_active_border_color":"000000","slideshow_dots_active_border_width":1,"slideshow_dots_background_color":"F2D22E","slideshow_dots_border_radius":"5px","slideshow_dots_height":12,"slideshow_dots_margin":3,"slideshow_dots_width":12,"slideshow_filmstrip_pos":"bottom","slideshow_filmstrip_rl_bg_color":"F2F2F2","slideshow_filmstrip_rl_btn_color":"BABABA","slideshow_filmstrip_rl_btn_size":20,"slideshow_filmstrip_thumb_active_border_color":"FFFFFF","slideshow_filmstrip_thumb_active_border_width":0,"slideshow_filmstrip_thumb_border_color":"000000","slideshow_filmstrip_thumb_border_radius":"0","slideshow_filmstrip_thumb_border_style":"none","slideshow_filmstrip_thumb_border_width":0,"slideshow_filmstrip_thumb_deactive_transparent":100,"slideshow_filmstrip_thumb_margin":"0px 2px 0 0 ","slideshow_play_pause_btn_size":35,"slideshow_rl_btn_bg_color":"FFFFFF","slideshow_rl_btn_border_color":"FFFFFF","slideshow_rl_btn_border_radius":"20px","slideshow_rl_btn_border_style":"none","slideshow_rl_btn_border_width":0,"slideshow_rl_btn_box_shadow":"","slideshow_rl_btn_color":"D6D6D6","slideshow_rl_btn_height":37,"slideshow_rl_btn_size":12,"slideshow_rl_btn_style":"bwg-icon-angle","slideshow_rl_btn_width":37,"slideshow_title_background_color":"000000","slideshow_title_border_radius":"5px","slideshow_title_color":"FFFFFF","slideshow_title_font":"Ubuntu","slideshow_title_font_size":16,"slideshow_title_opacity":70,"slideshow_title_padding":"0 0 0 0","thumb_align":"center","thumb_bg_color":"000000","thumb_bg_transparent":0,"thumb_border_color":"CCCCCC","thumb_border_radius":"0","thumb_border_style":"none","thumb_border_width":0,"thumb_box_shadow":"","thumb_gal_title_align":"center","thumb_gal_title_font_color":"323A45","thumb_gal_title_font_size":18,"thumb_gal_title_font_style":"Ubuntu","thumb_gal_title_font_weight":"bold","thumb_gal_title_margin":"2px","thumb_gal_title_shadow":"","thumb_hover_effect":"zoom","thumb_hover_effect_value":"1.08","thumb_margin":"4","thumb_padding":"0","thumb_title_font_color":"323A45","thumb_title_font_color_hover":"FFFFFF","thumb_title_font_size":16,"thumb_title_font_style":"Ubuntu","thumb_title_font_weight":"bold","thumb_title_margin":"2px","thumb_description_font_color":"323A45","thumb_description_font_style":"Ubuntu","thumb_description_font_size":12,"thumb_title_pos":"bottom","thumb_title_shadow":"","thumb_transition":1,"thumb_transparent":100,"thumb_bg_transparency":30,"thumbs_bg_color":"FFFFFF","tags_view":1,"tags_but_font_color":"323A45","tags_but_font_size":14,"tags_but_font_style":"Ubuntu","tags_but_font_weight":"normal","tags_but_margin":"0px 5px 10px 5px","tags_but_padding":"6px 6px 6px 6px","tags_but_border_width":0,"tags_but_border_style":"none","tags_but_border_color":"E9EBEE","tags_but_border_radius":"4px","tags_but_bg_color":"E9EBEE","tags_but_active_bg_color":"2160B5","tags_but_active_color":"FFFFFF","tags_but_see_all_size":14,"tags_but_see_all_color":"323A45","tags_but_see_all_back_color":"F8F8F8","tags_but_see_all_border_w":1,"tags_but_see_all_border_s":"solid","tags_but_see_all_border_c":"E5E5E5","tags_but_see_all_border_r":"20px"}', 1),
(2, 'Dark', '{"album_compact_back_font_color":"323A45","album_compact_back_font_size":15,"album_compact_back_font_style":"Ubuntu","album_compact_back_font_weight":"normal","album_compact_back_padding":"0","album_compact_gal_title_align":"center","album_compact_gal_title_font_color":"323A45","album_compact_gal_title_font_size":18,"album_compact_gal_title_font_style":"Ubuntu","album_compact_gal_title_font_weight":"bold","album_compact_gal_title_margin":"0 2px 2px 2px","album_compact_gal_title_shadow":"0px 0px 0px #888888","album_compact_thumb_align":"center","album_compact_thumb_bg_color":"000000","album_compact_thumb_bg_transparent":100,"album_compact_thumb_border_color":"000000","album_compact_thumb_border_radius":"0","album_compact_thumb_border_style":"none","album_compact_thumb_border_width":1,"album_compact_thumb_box_shadow":"","album_compact_thumb_hover_effect":"rotate","album_compact_thumb_hover_effect_value":"2deg","album_compact_thumb_margin":4,"album_compact_thumb_padding":4,"album_compact_thumb_title_pos":"bottom","album_compact_thumb_transition":1,"album_compact_thumb_transparent":100,"album_compact_thumb_bg_transparency":30,"album_compact_thumbs_bg_color":"FFFFFF","album_compact_title_font_color":"CCCCCC","album_compact_title_font_color_hover":"FFFFFF","album_compact_title_font_size":16,"album_compact_title_font_style":"Ubuntu","album_compact_title_font_weight":"bold","album_compact_title_margin":"5px","album_compact_title_shadow":"","album_extended_back_font_color":"323A45","album_extended_back_font_size":15,"album_extended_back_font_style":"Ubuntu","album_extended_back_font_weight":"bold","album_extended_back_padding":"0","album_extended_desc_font_color":"000000","album_extended_desc_font_size":14,"album_extended_desc_font_style":"Ubuntu","album_extended_desc_font_weight":"normal","album_extended_desc_more_color":"FFC933","album_extended_desc_more_size":12,"album_extended_desc_padding":"2px","album_extended_desc_span_border_color":"CCCCCC","album_extended_desc_span_border_style":"none","album_extended_desc_span_border_width":1,"album_extended_div_bg_color":"FFFFFF","album_extended_div_bg_transparent":0,"album_extended_div_border_radius":"","album_extended_div_margin":"0 0 5px 0","album_extended_div_padding":10,"album_extended_div_separator_color":"CCCCCC","album_extended_div_separator_style":"none","album_extended_div_separator_width":1,"album_extended_gal_title_align":"center","album_extended_gal_title_font_color":"323A45","album_extended_gal_title_font_size":18,"album_extended_gal_title_font_style":"Ubuntu","album_extended_gal_title_font_weight":"bold","album_extended_gal_title_margin":"0 2px 2px 2px","album_extended_gal_title_shadow":"0px 0px 0px #888888","album_extended_text_div_bg_color":"FFFFFF","album_extended_text_div_border_color":"CCCCCC","album_extended_text_div_border_radius":"0","album_extended_text_div_border_style":"none","album_extended_text_div_border_width":1,"album_extended_text_div_padding":"5px","album_extended_thumb_align":"left","album_extended_thumb_bg_color":"E8E8E8","album_extended_thumb_bg_transparent":100,"album_extended_thumb_border_color":"E8E8E8","album_extended_thumb_border_radius":"0","album_extended_thumb_border_style":"none","album_extended_thumb_border_width":4,"album_extended_thumb_box_shadow":"","album_extended_thumb_div_bg_color":"FFFFFF","album_extended_thumb_div_border_color":"CCCCCC","album_extended_thumb_div_border_radius":"","album_extended_thumb_div_border_style":"none","album_extended_thumb_div_border_width":0,"album_extended_thumb_div_padding":"0","album_extended_thumb_hover_effect":"rotate","album_extended_thumb_hover_effect_value":"2deg","album_extended_thumb_margin":2,"album_extended_thumb_padding":4,"album_extended_thumb_transition":0,"album_extended_thumb_transparent":100,"album_extended_thumbs_bg_color":"FFFFFF","album_extended_title_desc_alignment":"top","album_extended_title_font_color":"000000","album_extended_title_font_size":16,"album_extended_title_font_style":"Ubuntu","album_extended_title_font_weight":"bold","album_extended_title_margin_bottom":2,"album_extended_title_padding":"2px","album_extended_title_span_border_color":"CCCCCC","album_extended_title_span_border_style":"none","album_extended_title_span_border_width":1,"album_masonry_back_font_color":"323A45","album_masonry_back_font_size":15,"album_masonry_back_font_style":"Ubuntu","album_masonry_back_font_weight":"normal","album_masonry_back_padding":"0","album_masonry_container_margin":1,"album_masonry_gal_title_align":"center","album_masonry_gal_title_font_color":"323A45","album_masonry_gal_title_font_size":18,"album_masonry_gal_title_font_style":"Ubuntu","album_masonry_gal_title_font_weight":"bold","album_masonry_gal_title_margin":"0 2px 2px 2px","album_masonry_gal_title_shadow":"0px 0px 0px #888888","album_masonry_thumb_align":"center","album_masonry_thumb_bg_color":"000000","album_masonry_thumb_bg_transparent":100,"album_masonry_thumb_border_color":"000000","album_masonry_thumb_border_radius":"0","album_masonry_thumb_border_style":"none","album_masonry_thumb_border_width":1,"album_masonry_thumb_box_shadow":"","album_masonry_thumb_hover_effect":"zoom","album_masonry_thumb_hover_effect_value":"2deg","album_masonry_thumb_margin":4,"album_masonry_thumb_padding":4,"album_masonry_thumb_title_font_color_hover":"FFFFFF","album_masonry_thumb_title_pos":"bottom","album_masonry_thumb_transition":1,"album_masonry_thumb_transparent":100,"album_masonry_thumbs_bg_color":"FFFFFF","album_masonry_title_font_color":"323A45","album_masonry_title_font_size":16,"album_masonry_title_font_style":"Ubuntu","album_masonry_title_font_weight":"bold","album_masonry_title_margin":"5px","album_masonry_title_shadow":"","blog_style_align":"center","blog_style_bg_color":"E8E8E8","blog_style_border_color":"CCCCCC","blog_style_border_radius":"0","blog_style_border_style":"none","blog_style_border_width":1,"blog_style_box_shadow":"","blog_style_gal_title_align":"center","blog_style_gal_title_font_color":"323A45","blog_style_gal_title_font_size":16,"blog_style_gal_title_font_style":"Ubuntu","blog_style_gal_title_font_weight":"bold","blog_style_gal_title_margin":"2px","blog_style_gal_title_shadow":"0px 0px 0px #888888","blog_style_img_font_color":"000000","blog_style_img_font_family":"Ubuntu","blog_style_img_font_size":16,"blog_style_margin":"2px","blog_style_padding":"4px","blog_style_share_buttons_align":"right","blog_style_share_buttons_bg_color":"FFFFFF","blog_style_share_buttons_bg_transparent":0,"blog_style_share_buttons_border_color":"000000","blog_style_share_buttons_border_radius":"0","blog_style_share_buttons_border_style":"none","blog_style_share_buttons_border_width":0,"blog_style_share_buttons_color":"A1A1A1","blog_style_share_buttons_font_size":20,"blog_style_share_buttons_margin":"5px auto 10px auto","blog_style_transparent":70,"carousel_caption_background_color":"000000","carousel_caption_bottom":0,"carousel_caption_p_color":"FFFFFF","carousel_caption_p_font_size":14,"carousel_caption_p_font_weight":"bold","carousel_caption_p_mergin":0,"carousel_caption_p_pedding":5,"carousel_close_btn_transparent":100,"carousel_close_rl_btn_hover_color":"CCCCCC","carousel_cont_bg_color":"000000","carousel_cont_btn_transparent":0,"carousel_feature_border_color":"5D204F","carousel_feature_border_style":"solid","carousel_feature_border_width":2,"carousel_font_family":"Ubuntu","carousel_mergin_bottom":"0.5","carousel_play_pause_btn_size":20,"carousel_rl_btn_bg_color":"000000","carousel_rl_btn_border_color":"FFFFFF","carousel_rl_btn_border_radius":"20px","carousel_rl_btn_border_style":"none","carousel_rl_btn_border_width":0,"carousel_rl_btn_color":"FFFFFF","carousel_rl_btn_height":40,"carousel_rl_btn_size":20,"carousel_rl_btn_style":"bwg-icon-chevron","carousel_rl_btn_width":40,"carousel_title_border_radius":"5px","carousel_title_opacity":100,"carousel_gal_title_align":"center","carousel_gal_title_font_color":"323A45","carousel_gal_title_font_size":16,"carousel_gal_title_font_style":"Ubuntu","carousel_gal_title_font_weight":"bold","carousel_gal_title_margin":"2px","carousel_gal_title_shadow":"0px 0px 0px #888888","compact_container_margin":"1","container_margin":"1","image_browser_align":"center","image_browser_bg_color":"E8E8E8","image_browser_border_color":"E8E8E8","image_browser_border_radius":"2px","image_browser_border_style":"none","image_browser_border_width":1,"image_browser_box_shadow":"","image_browser_full_bg_color":"FFFFFF","image_browser_full_border_color":"EDEDED","image_browser_full_border_radius":"0","image_browser_full_border_style":"solid","image_browser_full_border_width":1,"image_browser_full_padding":"4px","image_browser_full_transparent":90,"image_browser_gal_title_align":"center","image_browser_gal_title_font_color":"323A45","image_browser_gal_title_font_size":16,"image_browser_gal_title_font_style":"Ubuntu","image_browser_gal_title_font_weight":"bold","image_browser_gal_title_margin":"2px","image_browser_gal_title_shadow":"0px 0px 0px #888888","image_browser_image_description_align":"center","image_browser_image_description_bg_color":"E8E8E8","image_browser_image_description_border_color":"FFFFFF","image_browser_image_description_border_radius":"0","image_browser_image_description_border_style":"none","image_browser_image_description_border_width":1,"image_browser_image_description_margin":"24px 0px 0px 0px","image_browser_image_description_padding":"8px 8px 8px 8px","image_browser_image_title_align":"top","image_browser_img_font_color":"000000","image_browser_img_font_family":"Ubuntu","image_browser_img_font_size":14,"image_browser_margin":"2px auto","image_browser_padding":"4px","image_browser_transparent":80,"lightbox_bg_color":"000000","lightbox_bg_transparent":100,"lightbox_close_btn_bg_color":"000000","lightbox_close_btn_border_color":"FFFFFF","lightbox_close_btn_border_radius":"16px","lightbox_close_btn_border_style":"none","lightbox_close_btn_border_width":0,"lightbox_close_btn_box_shadow":"","lightbox_close_btn_color":"FFFFFF","lightbox_close_btn_full_color":"FFFFFF","lightbox_close_btn_height":20,"lightbox_close_btn_right":"-10","lightbox_close_btn_size":10,"lightbox_close_btn_top":"-10","lightbox_close_btn_transparent":95,"lightbox_close_btn_width":20,"lightbox_close_rl_btn_hover_color":"FFFFFF","lightbox_comment_author_font_size":14,"lightbox_comment_bg_color":"000000","lightbox_comment_body_font_size":12,"lightbox_comment_button_bg_color":"333333","lightbox_comment_button_border_color":"666666","lightbox_comment_button_border_radius":"3px","lightbox_comment_button_border_style":"none","lightbox_comment_button_border_width":1,"lightbox_comment_button_padding":"3px 10px","lightbox_comment_date_font_size":10,"lightbox_comment_font_color":"CCCCCC","lightbox_comment_font_size":12,"lightbox_comment_font_style":"Ubuntu","lightbox_comment_input_bg_color":"333333","lightbox_comment_input_border_color":"666666","lightbox_comment_input_border_radius":"0","lightbox_comment_input_border_style":"none","lightbox_comment_input_border_width":1,"lightbox_comment_input_padding":"3px","lightbox_comment_pos":"left","lightbox_comment_separator_color":"2B2B2B","lightbox_comment_separator_style":"solid","lightbox_comment_separator_width":1,"lightbox_comment_share_button_color":"FFFFFF","lightbox_comment_width":400,"lightbox_ctrl_btn_align":"center","lightbox_ctrl_btn_color":"FFFFFF","lightbox_ctrl_btn_height":20,"lightbox_ctrl_btn_margin_left":7,"lightbox_ctrl_btn_margin_top":10,"lightbox_ctrl_btn_pos":"bottom","lightbox_ctrl_btn_transparent":80,"lightbox_ctrl_cont_bg_color":"000000","lightbox_ctrl_cont_border_radius":4,"lightbox_ctrl_cont_transparent":80,"lightbox_description_color":"FFFFFF","lightbox_description_font_size":14,"lightbox_description_font_style":"Ubuntu","lightbox_description_font_weight":"normal","lightbox_filmstrip_pos":"top","lightbox_filmstrip_rl_bg_color":"2B2B2B","lightbox_filmstrip_rl_btn_color":"FFFFFF","lightbox_filmstrip_rl_btn_size":20,"lightbox_filmstrip_thumb_active_border_color":"FFFFFF","lightbox_filmstrip_thumb_active_border_width":0,"lightbox_filmstrip_thumb_border_color":"000000","lightbox_filmstrip_thumb_border_radius":"0","lightbox_filmstrip_thumb_border_style":"none","lightbox_filmstrip_thumb_border_width":1,"lightbox_filmstrip_thumb_deactive_transparent":80,"lightbox_filmstrip_thumb_margin":"0 1px","lightbox_hit_align":"left","lightbox_hit_bg_color":"000000","lightbox_hit_bg_transparent":70,"lightbox_hit_border_color":"000000","lightbox_hit_border_radius":"5px","lightbox_hit_border_style":"none","lightbox_hit_border_width":1,"lightbox_hit_color":"FFFFFF","lightbox_hit_font_size":14,"lightbox_hit_font_style":"Ubuntu","lightbox_hit_font_weight":"normal","lightbox_hit_margin":"0 5px","lightbox_hit_padding":"5px","lightbox_hit_pos":"bottom","lightbox_info_align":"right","lightbox_info_bg_color":"000000","lightbox_info_bg_transparent":70,"lightbox_info_border_color":"000000","lightbox_info_border_radius":"5px","lightbox_info_border_style":"none","lightbox_info_border_width":1,"lightbox_info_margin":"15px","lightbox_info_padding":"5px","lightbox_info_pos":"top","lightbox_overlay_bg_color":"000000","lightbox_overlay_bg_transparent":70,"lightbox_rate_align":"right","lightbox_rate_color":"F9D062","lightbox_rate_hover_color":"F7B50E","lightbox_rate_icon":"star","lightbox_rate_padding":"15px","lightbox_rate_pos":"bottom","lightbox_rate_size":20,"lightbox_rate_stars_count":5,"lightbox_rl_btn_bg_color":"000000","lightbox_rl_btn_border_color":"FFFFFF","lightbox_rl_btn_border_radius":"20px","lightbox_rl_btn_border_style":"none","lightbox_rl_btn_border_width":2,"lightbox_rl_btn_box_shadow":"","lightbox_rl_btn_color":"FFFFFF","lightbox_rl_btn_height":40,"lightbox_rl_btn_size":20,"lightbox_rl_btn_style":"bwg-icon-chevron","lightbox_rl_btn_transparent":80,"lightbox_rl_btn_width":40,"lightbox_title_color":"FFFFFF","lightbox_title_font_size":18,"lightbox_title_font_style":"Ubuntu","lightbox_title_font_weight":"bold","lightbox_toggle_btn_height":14,"lightbox_toggle_btn_width":100,"masonry_container_margin":"1","masonry_description_color":"323A45","masonry_description_font_size":16,"masonry_description_font_style":"Ubuntu","masonry_thumb_align":"center","masonry_thumb_bg_color":"000000","masonry_thumb_bg_transparent":0,"masonry_thumb_border_color":"CCCCCC","masonry_thumb_border_radius":"2px","masonry_thumb_border_style":"none","masonry_thumb_border_width":1,"masonry_thumb_gal_title_align":"center","masonry_thumb_gal_title_font_color":"323A45","masonry_thumb_gal_title_font_size":16,"masonry_thumb_gal_title_font_style":"Ubuntu","masonry_thumb_gal_title_font_weight":"bold","masonry_thumb_gal_title_margin":"2px","masonry_thumb_gal_title_shadow":"","masonry_thumb_hover_effect":"zoom","masonry_thumb_hover_effect_value":"1.08","masonry_thumb_padding":4,"masonry_thumb_title_font_color":"323A45","masonry_thumb_title_font_color_hover":"FFFFFF","masonry_thumb_title_font_size":16,"masonry_thumb_title_font_style":"Ubuntu","masonry_thumb_title_font_weight":"bold","masonry_thumb_title_margin":"2px","masonry_thumb_transition":1,"masonry_thumb_transparent":80,"masonry_thumb_bg_transparency":30,"masonry_thumbs_bg_color":"FFFFFF","mosaic_container_margin":"1","mosaic_thumb_align":"center","mosaic_thumb_bg_color":"000000","mosaic_thumb_bg_transparent":0,"mosaic_thumb_border_color":"CCCCCC","mosaic_thumb_border_radius":"2px","mosaic_thumb_border_style":"none","mosaic_thumb_border_width":1,"mosaic_thumb_gal_title_align":"center","mosaic_thumb_gal_title_font_color":"323A45","mosaic_thumb_gal_title_font_size":16,"mosaic_thumb_gal_title_font_style":"Ubuntu","mosaic_thumb_gal_title_font_weight":"bold","mosaic_thumb_gal_title_margin":"2px","mosaic_thumb_gal_title_shadow":"","mosaic_thumb_hover_effect":"rotate","mosaic_thumb_hover_effect_value":"2deg","mosaic_thumb_padding":4,"mosaic_thumb_title_font_color":"323A45","mosaic_thumb_title_font_color_hover":"FFFFFF","mosaic_thumb_title_font_size":16,"mosaic_thumb_title_font_style":"Ubuntu","mosaic_thumb_title_font_weight":"bold","mosaic_thumb_title_margin":"2px","mosaic_thumb_title_shadow":"0px 0px 0px #888888","mosaic_thumb_transition":1,"mosaic_thumb_transparent":80,"mosaic_thumb_bg_transparency":30,"mosaic_thumbs_bg_color":"FFFFFF","page_nav_align":"center","page_nav_border_color":"E3E3E3","page_nav_border_radius":"0","page_nav_border_style":"none","page_nav_border_width":1,"page_nav_box_shadow":"0","page_nav_button_bg_color":"FCFCFC","page_nav_button_bg_transparent":100,"page_nav_button_text":0,"page_nav_button_transition":1,"page_nav_font_color":"666666","page_nav_font_size":12,"page_nav_font_style":"Ubuntu","page_nav_font_weight":"bold","page_nav_margin":"0","page_nav_number":0,"page_nav_padding":"3px 6px","page_nav_position":"bottom","slideshow_close_btn_transparent":100,"slideshow_close_rl_btn_hover_color":"DBDBDB","slideshow_cont_bg_color":"000000","slideshow_description_background_color":"000000","slideshow_description_border_radius":"0","slideshow_description_color":"FFFFFF","slideshow_description_font":"Ubuntu","slideshow_description_font_size":14,"slideshow_description_opacity":70,"slideshow_description_padding":"5px 10px 5px 10px","slideshow_dots_active_background_color":"292929","slideshow_dots_active_border_color":"FFC933","slideshow_dots_active_border_width":2,"slideshow_dots_background_color":"292929","slideshow_dots_border_radius":"10px","slideshow_dots_height":10,"slideshow_dots_margin":1,"slideshow_dots_width":10,"slideshow_filmstrip_pos":"bottom","slideshow_filmstrip_rl_bg_color":"303030","slideshow_filmstrip_rl_btn_color":"FFFFFF","slideshow_filmstrip_rl_btn_size":20,"slideshow_filmstrip_thumb_active_border_color":"FFFFFF","slideshow_filmstrip_thumb_active_border_width":0,"slideshow_filmstrip_thumb_border_color":"000000","slideshow_filmstrip_thumb_border_radius":"0","slideshow_filmstrip_thumb_border_style":"none","slideshow_filmstrip_thumb_border_width":1,"slideshow_filmstrip_thumb_deactive_transparent":80,"slideshow_filmstrip_thumb_margin":"0 1px","slideshow_play_pause_btn_size":60,"slideshow_rl_btn_bg_color":"000000","slideshow_rl_btn_border_color":"FFFFFF","slideshow_rl_btn_border_radius":"20px","slideshow_rl_btn_border_style":"none","slideshow_rl_btn_border_width":0,"slideshow_rl_btn_box_shadow":"","slideshow_rl_btn_color":"FFFFFF","slideshow_rl_btn_height":40,"slideshow_rl_btn_size":20,"slideshow_rl_btn_style":"bwg-icon-arrow","slideshow_rl_btn_width":40,"slideshow_title_background_color":"000000","slideshow_title_border_radius":"5px","slideshow_title_color":"FFFFFF","slideshow_title_font":"Ubuntu","slideshow_title_font_size":16,"slideshow_title_opacity":70,"slideshow_title_padding":"5px 10px 5px 10px","thumb_align":"center","thumb_bg_color":"000000","thumb_bg_transparent":0,"thumb_border_color":"FFFFFF","thumb_border_radius":"0","thumb_border_style":"none","thumb_border_width":5,"thumb_box_shadow":"","thumb_gal_title_align":"center","thumb_gal_title_font_color":"323A45","thumb_gal_title_font_size":18,"thumb_gal_title_font_style":"Ubuntu","thumb_gal_title_font_weight":"bold","thumb_gal_title_margin":"2px","thumb_gal_title_shadow":"","thumb_hover_effect":"zoom","thumb_hover_effect_value":"1.08","thumb_margin":"4","thumb_padding":"0","thumb_title_font_color":"323A45","thumb_title_font_color_hover":"FFFFFF","thumb_title_font_size":16,"thumb_title_font_style":"Ubuntu","thumb_title_font_weight":"bold","thumb_title_margin":"5px","thumb_description_font_color":"323A45","thumb_description_font_style":"Ubuntu","thumb_description_font_size":12,"thumb_title_pos":"bottom","thumb_title_shadow":"","thumb_transition":1,"thumb_transparent":100,"thumb_bg_transparency":30,"thumbs_bg_color":"FFFFFF","tags_view":1,"tags_but_font_color":"323A45","tags_but_font_size":14,"tags_but_font_style":"Ubuntu","tags_but_font_weight":"normal","tags_but_margin":"0px 5px 10px 5px","tags_but_padding":"6px 6px 6px 6px","tags_but_border_width":0,"tags_but_border_style":"none","tags_but_border_color":"E9EBEE","tags_but_border_radius":"4px","tags_but_bg_color":"E9EBEE","tags_but_active_bg_color":"2160B5","tags_but_active_color":"FFFFFF","tags_but_see_all_size":14,"tags_but_see_all_color":"323A45","tags_but_see_all_back_color":"F8F8F8","tags_but_see_all_border_w":1,"tags_but_see_all_border_s":"solid","tags_but_see_all_border_c":"E5E5E5","tags_but_see_all_border_r":"20px"}', 0);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_commentmeta`
--

CREATE TABLE `qdc_commentmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_comments`
--

CREATE TABLE `qdc_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`comment_ID`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`),
  KEY `comment_parent` (`comment_parent`),
  KEY `comment_author_email` (`comment_author_email`(10)),
  KEY `woo_idx_comment_type` (`comment_type`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_cpappbk_forms`
--

CREATE TABLE `qdc_cpappbk_forms` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `form_name` varchar(250) NOT NULL DEFAULT '',
  `form_structure` mediumtext DEFAULT NULL,
  `calendar_language` varchar(250) NOT NULL DEFAULT '',
  `date_format` varchar(250) NOT NULL DEFAULT '',
  `product_name` varchar(250) NOT NULL DEFAULT '',
  `pay_later_label` varchar(250) NOT NULL DEFAULT '',
  `defaultstatus` varchar(250) NOT NULL DEFAULT '',
  `defaultpaidstatus` varchar(250) NOT NULL DEFAULT '',
  `fp_from_email` varchar(250) NOT NULL DEFAULT '',
  `fp_from_name` text DEFAULT NULL,
  `fp_destination_emails` text DEFAULT NULL,
  `fp_subject` text DEFAULT NULL,
  `fp_inc_additional_info` varchar(10) NOT NULL DEFAULT '',
  `fp_return_page` varchar(250) NOT NULL DEFAULT '',
  `fp_message` text DEFAULT NULL,
  `fp_emailformat` varchar(10) NOT NULL DEFAULT '',
  `fp_emailtomethod` varchar(10) NOT NULL DEFAULT '',
  `fp_destination_emails_field` varchar(200) NOT NULL DEFAULT '',
  `cu_enable_copy_to_user` varchar(10) NOT NULL DEFAULT '',
  `cu_user_email_field` varchar(250) NOT NULL DEFAULT '',
  `cu_subject` varchar(250) NOT NULL DEFAULT '',
  `cu_message` text DEFAULT NULL,
  `cu_emailformat` varchar(10) NOT NULL DEFAULT '',
  `fp_emailfrommethod` varchar(10) NOT NULL DEFAULT '',
  `vs_text_maxapp` text DEFAULT NULL,
  `vs_text_is_required` text DEFAULT NULL,
  `vs_text_is_email` text DEFAULT NULL,
  `vs_text_datemmddyyyy` text DEFAULT NULL,
  `vs_text_dateddmmyyyy` text DEFAULT NULL,
  `vs_text_number` text DEFAULT NULL,
  `vs_text_digits` text DEFAULT NULL,
  `vs_text_max` text DEFAULT NULL,
  `vs_text_min` text DEFAULT NULL,
  `vs_text_pageof` text DEFAULT NULL,
  `vs_text_submitbtn` text DEFAULT NULL,
  `vs_text_previousbtn` text DEFAULT NULL,
  `vs_text_nextbtn` text DEFAULT NULL,
  `vs_text_quantity` text DEFAULT NULL,
  `vs_text_cancel` text DEFAULT NULL,
  `vs_text_cost` text DEFAULT NULL,
  `vs_text_nmore` text DEFAULT NULL,
  `cp_user_access` text DEFAULT NULL,
  `cp_user_access_settings` varchar(10) NOT NULL DEFAULT '',
  `display_emails_endtime` varchar(10) NOT NULL DEFAULT '',
  `rep_enable` varchar(10) NOT NULL DEFAULT '',
  `rep_days` varchar(10) NOT NULL DEFAULT '',
  `rep_hour` varchar(10) NOT NULL DEFAULT '',
  `rep_emails` text DEFAULT NULL,
  `rep_subject` text DEFAULT NULL,
  `rep_emailformat` varchar(10) NOT NULL DEFAULT '',
  `rep_message` text DEFAULT NULL,
  `cv_enable_captcha` varchar(20) NOT NULL DEFAULT '',
  `cv_width` varchar(20) NOT NULL DEFAULT '',
  `cv_height` varchar(20) NOT NULL DEFAULT '',
  `cv_chars` varchar(20) NOT NULL DEFAULT '',
  `cv_font` varchar(20) NOT NULL DEFAULT '',
  `cv_min_font_size` varchar(20) NOT NULL DEFAULT '',
  `cv_max_font_size` varchar(20) NOT NULL DEFAULT '',
  `cv_noise` varchar(20) NOT NULL DEFAULT '',
  `cv_noise_length` varchar(20) NOT NULL DEFAULT '',
  `cv_background` varchar(20) NOT NULL DEFAULT '',
  `cv_border` varchar(20) NOT NULL DEFAULT '',
  `cv_text_enter_valid_captcha` varchar(200) NOT NULL DEFAULT '',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_cpappbk_forms`
--

INSERT INTO `qdc_cpappbk_forms` VALUES
(2, 'Quick Dental Care', '[[{"form_identifier":"","name":"fieldname1","shortlabel":"","index":0,"ftype":"fapp","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Appointment","services":[{"name":"Service 1","price":1,"duration":60}],"openhours":[{"name":"Default","openhours":[{"type":"all","d":"","h1":8,"m1":0,"h2":17,"m2":0}]}],"allOH":[{"name":"Default","openhours":[{"type":"all","d":"","h1":8,"m1":0,"h2":17,"m2":0}]}],"dateFormat":"mm/dd/yy","showDropdown":false,"dropdownRange":"-10:+10","working_dates":[true,true,true,true,true,true,true],"numberOfMonths":1,"firstDay":0,"minDate":"0","maxDate":"","defaultDate":"","invalidDates":"","required":true,"fBuild":{}},{"form_identifier":"","name":"email","shortlabel":"","index":1,"ftype":"femail","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Email","predefined":"","predefinedClick":false,"required":true,"size":"medium","equalTo":"","fBuild":{}}],[{"title":"","description":"","formlayout":"top_aligned","formtemplate":"","evalequations":1,"autocomplete":1}]]', '', '', '', '', '', '', 'admin@quickdental.com.bd', NULL, 'admin@quickdental.com.bd', 'Notification to administrator: Booking request received...', 'true', 'https://quickdental.com.bd', 'The following booking request has been received:\n\n<%INFO%>\n\n', 'text', '', '', 'true', 'email', 'Confirmation: Your booking has been received...', 'Your appointment is received. We look forward to seeing you then.\n\nThis is a copy of the data sent:\n\n<%INFO%>\n\nBest Regards.', 'text', '', 'Please select a max of  {0} appointments per customer.', 'This field is required.', 'Please enter a valid email address.', 'Please enter a valid date with this format(mm/dd/yyyy)', 'Please enter a valid date with this format(dd/mm/yyyy)', 'Please enter a valid number.', 'Please enter only digits.', 'Please enter a value less than or equal to {0}.', 'Please enter a value greater than or equal to {0}.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', NULL, 'true', '180', '60', '5', 'font1', '25', '35', '200', '4', 'ffffff', '000000', 'Please enter a valid captcha code.');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_cpappbk_messages`
--

CREATE TABLE `qdc_cpappbk_messages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `formid` int(11) NOT NULL,
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ipaddr` varchar(250) NOT NULL DEFAULT '',
  `notifyto` varchar(250) NOT NULL DEFAULT '',
  `data` mediumtext DEFAULT NULL,
  `posted_data` mediumtext DEFAULT NULL,
  `whoadded` varchar(250) NOT NULL DEFAULT '',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_ctmdcd_appointment`
--

CREATE TABLE `qdc_ctmdcd_appointment` (
  `appointment_id` int(11) NOT NULL AUTO_INCREMENT,
  `appointment_timestamp` int(11) NOT NULL,
  `schedule` varchar(255) DEFAULT NULL,
  `patient_id` int(11) NOT NULL,
  `chamber_id` int(11) NOT NULL,
  `is_visited` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`appointment_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `qdc_ctmdcd_appointment`
--

INSERT INTO `qdc_ctmdcd_appointment` VALUES
(1, 1684972800, '4:00 PM - 6:00 PM', 1, 1, 0),
(2, 1684886400, '4:00 PM - 6:00 PM', 1, 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_ctmdcd_chamber`
--

CREATE TABLE `qdc_ctmdcd_chamber` (
  `chamber_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `schedule` text NOT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`chamber_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `qdc_ctmdcd_chamber`
--

INSERT INTO `qdc_ctmdcd_chamber` VALUES
(1, 'Quick Dental Care', 'Nurani-1, Subidbazar', '[{"day":"Sunday","key":0,"status":"open","morning_open":"11:00 AM","morning_close":"1:00 PM","morning":"11:00 AM - 1:00 PM","afternoon_open":"4:00 PM","afternoon_close":"6:00 PM","afternoon":"4:00 PM - 6:00 PM","evening_open":"6:30 PM","evening_close":"9:00 PM","evening":"6:30 PM - 9:00 PM"},{"day":"Monday","key":1,"status":"open","morning_open":"11:00 AM","morning_close":"1:00 PM","morning":"11:00 AM - 1:00 PM","afternoon_open":"4:00 PM","afternoon_close":"6:00 PM","afternoon":"4:00 PM - 6:00 PM","evening_open":"6:30 PM","evening_close":"9:00 PM","evening":"6:30 PM - 9:00 PM"},{"day":"Tuesday","key":2,"status":"open","morning_open":"11:00 AM","morning_close":"1:00 PM","morning":"11:00 AM - 1:00 PM","afternoon_open":"6:00 PM","afternoon_close":"6:00 PM","afternoon":"6:00 PM - 6:00 PM","evening_open":"6:30 PM","evening_close":"9:00 PM","evening":"6:30 PM - 9:00 PM"},{"day":"Wednesday","key":3,"status":"open","morning_open":"11:00 AM","morning_close":"1:00 PM","morning":"11:00 AM - 1:00 PM","afternoon_open":"4:00 PM","afternoon_close":"6:00 PM","afternoon":"4:00 PM - 6:00 PM","evening_open":"6:30 PM","evening_close":"9:00 PM","evening":"6:30 PM - 9:00 PM"},{"day":"Thursday","key":4,"status":"open","morning_open":"11:00 AM","morning_close":"1:00 PM","morning":"11:00 AM - 1:00 PM","afternoon_open":"4:00 PM","afternoon_close":"6:00 PM","afternoon":"4:00 PM - 6:00 PM","evening_open":"6:30 PM","evening_close":"9:00 PM","evening":"6:30 PM - 9:00 PM"},{"day":"Friday","key":5,"status":"closed","morning_open":"","morning_close":"","morning":"","afternoon_open":"","afternoon_close":"","afternoon":"","evening_open":"","evening_close":"","evening":""},{"day":"Saturday","key":6,"status":"open","morning_open":"11:00 AM","morning_close":"1:00 PM","morning":"11:00 AM - 1:00 PM","afternoon_open":"4:00 PM","afternoon_close":"6:00 PM","afternoon":"4:00 PM - 6:00 PM","evening_open":"6:30 PM","evening_close":"9:00 PM","evening":"6:30 PM - 9:00 PM"}]', 1);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_ctmdcd_country`
--

CREATE TABLE `qdc_ctmdcd_country` (
  `ID` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `code` varchar(2) NOT NULL,
  `dial_code` varchar(5) NOT NULL,
  `currency_name` varchar(20) NOT NULL,
  `currency_symbol` varchar(20) NOT NULL,
  `currency_code` varchar(10) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `qdc_ctmdcd_country`
--

INSERT INTO `qdc_ctmdcd_country` VALUES
(1, 'Afghanistan', 'AF', '+93', 'Afghan afghani', '؋', 'AFN'),
(2, 'Aland Islands', 'AX', '+358', '', '', ''),
(3, 'Albania', 'AL', '+355', 'Albanian lek', 'L', 'ALL'),
(4, 'Algeria', 'DZ', '+213', 'Algerian dinar', 'د.ج', 'DZD'),
(5, 'AmericanSamoa', 'AS', '+1684', '', '', ''),
(6, 'Andorra', 'AD', '+376', 'Euro', '€', 'EUR'),
(7, 'Angola', 'AO', '+244', 'Angolan kwanza', 'Kz', 'AOA'),
(8, 'Anguilla', 'AI', '+1264', 'East Caribbean dolla', '$', 'XCD'),
(9, 'Antarctica', 'AQ', '+672', '', '', ''),
(10, 'Antigua and Barbuda', 'AG', '+1268', 'East Caribbean dolla', '$', 'XCD'),
(11, 'Argentina', 'AR', '+54', 'Argentine peso', '$', 'ARS'),
(12, 'Armenia', 'AM', '+374', 'Armenian dram', '', 'AMD'),
(13, 'Aruba', 'AW', '+297', 'Aruban florin', 'ƒ', 'AWG'),
(14, 'Australia', 'AU', '+61', 'Australian dollar', '$', 'AUD'),
(15, 'Austria', 'AT', '+43', 'Euro', '€', 'EUR'),
(16, 'Azerbaijan', 'AZ', '+994', 'Azerbaijani manat', '', 'AZN'),
(17, 'Bahamas', 'BS', '+1242', '', '', ''),
(18, 'Bahrain', 'BH', '+973', 'Bahraini dinar', '.د.ب', 'BHD'),
(19, 'Bangladesh', 'BD', '+880', 'Bangladeshi taka', '৳', 'BDT'),
(20, 'Barbados', 'BB', '+1246', 'Barbadian dollar', '$', 'BBD'),
(21, 'Belarus', 'BY', '+375', 'Belarusian ruble', 'Br', 'BYR'),
(22, 'Belgium', 'BE', '+32', 'Euro', '€', 'EUR'),
(23, 'Belize', 'BZ', '+501', 'Belize dollar', '$', 'BZD'),
(24, 'Benin', 'BJ', '+229', 'West African CFA fra', 'Fr', 'XOF'),
(25, 'Bermuda', 'BM', '+1441', 'Bermudian dollar', '$', 'BMD'),
(26, 'Bhutan', 'BT', '+975', 'Bhutanese ngultrum', 'Nu.', 'BTN'),
(27, 'Bolivia, Plurination', 'BO', '+591', '', '', ''),
(28, 'Bosnia and Herzegovi', 'BA', '+387', '', '', ''),
(29, 'Botswana', 'BW', '+267', 'Botswana pula', 'P', 'BWP'),
(30, 'Brazil', 'BR', '+55', 'Brazilian real', 'R$', 'BRL'),
(31, 'British Indian Ocean', 'IO', '+246', '', '', ''),
(32, 'Brunei Darussalam', 'BN', '+673', '', '', ''),
(33, 'Bulgaria', 'BG', '+359', 'Bulgarian lev', 'лв', 'BGN'),
(34, 'Burkina Faso', 'BF', '+226', 'West African CFA fra', 'Fr', 'XOF'),
(35, 'Burundi', 'BI', '+257', 'Burundian franc', 'Fr', 'BIF'),
(36, 'Cambodia', 'KH', '+855', 'Cambodian riel', '៛', 'KHR'),
(37, 'Cameroon', 'CM', '+237', 'Central African CFA ', 'Fr', 'XAF'),
(38, 'Canada', 'CA', '+1', 'Canadian dollar', '$', 'CAD'),
(39, 'Cape Verde', 'CV', '+238', 'Cape Verdean escudo', 'Esc or $', 'CVE'),
(40, 'Cayman Islands', 'KY', '+ 345', 'Cayman Islands dolla', '$', 'KYD'),
(41, 'Central African Repu', 'CF', '+236', '', '', ''),
(42, 'Chad', 'TD', '+235', 'Central African CFA ', 'Fr', 'XAF'),
(43, 'Chile', 'CL', '+56', 'Chilean peso', '$', 'CLP'),
(44, 'China', 'CN', '+86', 'Chinese yuan', '¥ or 元', 'CNY'),
(45, 'Christmas Island', 'CX', '+61', '', '', ''),
(46, 'Cocos (Keeling) Isla', 'CC', '+61', '', '', ''),
(47, 'Colombia', 'CO', '+57', 'Colombian peso', '$', 'COP'),
(48, 'Comoros', 'KM', '+269', 'Comorian franc', 'Fr', 'KMF'),
(49, 'Congo', 'CG', '+242', '', '', ''),
(50, 'Congo, The Democrati', 'CD', '+243', '', '', ''),
(51, 'Cook Islands', 'CK', '+682', 'New Zealand dollar', '$', 'NZD'),
(52, 'Costa Rica', 'CR', '+506', 'Costa Rican colón', '₡', 'CRC'),
(53, 'Cote d''Ivoire', 'CI', '+225', 'West African CFA fra', 'Fr', 'XOF'),
(54, 'Croatia', 'HR', '+385', 'Croatian kuna', 'kn', 'HRK'),
(55, 'Cuba', 'CU', '+53', 'Cuban convertible pe', '$', 'CUC'),
(56, 'Cyprus', 'CY', '+357', 'Euro', '€', 'EUR'),
(57, 'Czech Republic', 'CZ', '+420', 'Czech koruna', 'Kč', 'CZK'),
(58, 'Denmark', 'DK', '+45', 'Danish krone', 'kr', 'DKK'),
(59, 'Djibouti', 'DJ', '+253', 'Djiboutian franc', 'Fr', 'DJF'),
(60, 'Dominica', 'DM', '+1767', 'East Caribbean dolla', '$', 'XCD'),
(61, 'Dominican Republic', 'DO', '+1849', 'Dominican peso', '$', 'DOP'),
(62, 'Ecuador', 'EC', '+593', 'United States dollar', '$', 'USD'),
(63, 'Egypt', 'EG', '+20', 'Egyptian pound', '£ or ج.م', 'EGP'),
(64, 'El Salvador', 'SV', '+503', 'United States dollar', '$', 'USD'),
(65, 'Equatorial Guinea', 'GQ', '+240', 'Central African CFA ', 'Fr', 'XAF'),
(66, 'Eritrea', 'ER', '+291', 'Eritrean nakfa', 'Nfk', 'ERN'),
(67, 'Estonia', 'EE', '+372', 'Euro', '€', 'EUR'),
(68, 'Ethiopia', 'ET', '+251', 'Ethiopian birr', 'Br', 'ETB'),
(69, 'Falkland Islands (Ma', 'FK', '+500', '', '', ''),
(70, 'Faroe Islands', 'FO', '+298', 'Danish krone', 'kr', 'DKK'),
(71, 'Fiji', 'FJ', '+679', 'Fijian dollar', '$', 'FJD'),
(72, 'Finland', 'FI', '+358', 'Euro', '€', 'EUR'),
(73, 'France', 'FR', '+33', 'Euro', '€', 'EUR'),
(74, 'French Guiana', 'GF', '+594', '', '', ''),
(75, 'French Polynesia', 'PF', '+689', 'CFP franc', 'Fr', 'XPF'),
(76, 'Gabon', 'GA', '+241', 'Central African CFA ', 'Fr', 'XAF'),
(77, 'Gambia', 'GM', '+220', '', '', ''),
(78, 'Georgia', 'GE', '+995', 'Georgian lari', 'ლ', 'GEL'),
(79, 'Germany', 'DE', '+49', 'Euro', '€', 'EUR'),
(80, 'Ghana', 'GH', '+233', 'Ghana cedi', '₵', 'GHS'),
(81, 'Gibraltar', 'GI', '+350', 'Gibraltar pound', '£', 'GIP'),
(82, 'Greece', 'GR', '+30', 'Euro', '€', 'EUR'),
(83, 'Greenland', 'GL', '+299', '', '', ''),
(84, 'Grenada', 'GD', '+1473', 'East Caribbean dolla', '$', 'XCD'),
(85, 'Guadeloupe', 'GP', '+590', '', '', ''),
(86, 'Guam', 'GU', '+1671', '', '', ''),
(87, 'Guatemala', 'GT', '+502', 'Guatemalan quetzal', 'Q', 'GTQ'),
(88, 'Guernsey', 'GG', '+44', 'British pound', '£', 'GBP'),
(89, 'Guinea', 'GN', '+224', 'Guinean franc', 'Fr', 'GNF'),
(90, 'Guinea-Bissau', 'GW', '+245', 'West African CFA fra', 'Fr', 'XOF'),
(91, 'Guyana', 'GY', '+595', 'Guyanese dollar', '$', 'GYD'),
(92, 'Haiti', 'HT', '+509', 'Haitian gourde', 'G', 'HTG'),
(93, 'Holy See (Vatican Ci', 'VA', '+379', '', '', ''),
(94, 'Honduras', 'HN', '+504', 'Honduran lempira', 'L', 'HNL'),
(95, 'Hong Kong', 'HK', '+852', 'Hong Kong dollar', '$', 'HKD'),
(96, 'Hungary', 'HU', '+36', 'Hungarian forint', 'Ft', 'HUF'),
(97, 'Iceland', 'IS', '+354', 'Icelandic króna', 'kr', 'ISK'),
(98, 'India', 'IN', '+91', 'Indian rupee', '₹', 'INR'),
(99, 'Indonesia', 'ID', '+62', 'Indonesian rupiah', 'Rp', 'IDR'),
(100, 'Iran, Islamic Republ', 'IR', '+98', '', '', ''),
(101, 'Iraq', 'IQ', '+964', 'Iraqi dinar', 'ع.د', 'IQD'),
(102, 'Ireland', 'IE', '+353', 'Euro', '€', 'EUR'),
(103, 'Isle of Man', 'IM', '+44', 'British pound', '£', 'GBP'),
(104, 'Israel', 'IL', '+972', 'Israeli new shekel', '₪', 'ILS'),
(105, 'Italy', 'IT', '+39', 'Euro', '€', 'EUR'),
(106, 'Jamaica', 'JM', '+1876', 'Jamaican dollar', '$', 'JMD'),
(107, 'Japan', 'JP', '+81', 'Japanese yen', '¥', 'JPY'),
(108, 'Jersey', 'JE', '+44', 'British pound', '£', 'GBP'),
(109, 'Jordan', 'JO', '+962', 'Jordanian dinar', 'د.ا', 'JOD'),
(110, 'Kazakhstan', 'KZ', '+7 7', 'Kazakhstani tenge', '', 'KZT'),
(111, 'Kenya', 'KE', '+254', 'Kenyan shilling', 'Sh', 'KES'),
(112, 'Kiribati', 'KI', '+686', 'Australian dollar', '$', 'AUD'),
(113, 'Korea, Democratic Pe', 'KP', '+850', '', '', ''),
(114, 'Korea, Republic of S', 'KR', '+82', '', '', ''),
(115, 'Kuwait', 'KW', '+965', 'Kuwaiti dinar', 'د.ك', 'KWD'),
(116, 'Kyrgyzstan', 'KG', '+996', 'Kyrgyzstani som', 'лв', 'KGS'),
(117, 'Laos', 'LA', '+856', 'Lao kip', '₭', 'LAK'),
(118, 'Latvia', 'LV', '+371', 'Euro', '€', 'EUR'),
(119, 'Lebanon', 'LB', '+961', 'Lebanese pound', 'ل.ل', 'LBP'),
(120, 'Lesotho', 'LS', '+266', 'Lesotho loti', 'L', 'LSL'),
(121, 'Liberia', 'LR', '+231', 'Liberian dollar', '$', 'LRD'),
(122, 'Libyan Arab Jamahiri', 'LY', '+218', '', '', ''),
(123, 'Liechtenstein', 'LI', '+423', 'Swiss franc', 'Fr', 'CHF'),
(124, 'Lithuania', 'LT', '+370', 'Euro', '€', 'EUR'),
(125, 'Luxembourg', 'LU', '+352', 'Euro', '€', 'EUR'),
(126, 'Macao', 'MO', '+853', '', '', ''),
(127, 'Macedonia', 'MK', '+389', '', '', ''),
(128, 'Madagascar', 'MG', '+261', 'Malagasy ariary', 'Ar', 'MGA'),
(129, 'Malawi', 'MW', '+265', 'Malawian kwacha', 'MK', 'MWK'),
(130, 'Malaysia', 'MY', '+60', 'Malaysian ringgit', 'RM', 'MYR'),
(131, 'Maldives', 'MV', '+960', 'Maldivian rufiyaa', '.ރ', 'MVR'),
(132, 'Mali', 'ML', '+223', 'West African CFA fra', 'Fr', 'XOF'),
(133, 'Malta', 'MT', '+356', 'Euro', '€', 'EUR'),
(134, 'Marshall Islands', 'MH', '+692', 'United States dollar', '$', 'USD'),
(135, 'Martinique', 'MQ', '+596', '', '', ''),
(136, 'Mauritania', 'MR', '+222', 'Mauritanian ouguiya', 'UM', 'MRO'),
(137, 'Mauritius', 'MU', '+230', 'Mauritian rupee', '₨', 'MUR'),
(138, 'Mayotte', 'YT', '+262', '', '', ''),
(139, 'Mexico', 'MX', '+52', 'Mexican peso', '$', 'MXN'),
(140, 'Micronesia, Federate', 'FM', '+691', '', '', ''),
(141, 'Moldova', 'MD', '+373', 'Moldovan leu', 'L', 'MDL'),
(142, 'Monaco', 'MC', '+377', 'Euro', '€', 'EUR'),
(143, 'Mongolia', 'MN', '+976', 'Mongolian tögrög', '₮', 'MNT'),
(144, 'Montenegro', 'ME', '+382', 'Euro', '€', 'EUR'),
(145, 'Montserrat', 'MS', '+1664', 'East Caribbean dolla', '$', 'XCD'),
(146, 'Morocco', 'MA', '+212', 'Moroccan dirham', 'د.م.', 'MAD'),
(147, 'Mozambique', 'MZ', '+258', 'Mozambican metical', 'MT', 'MZN'),
(148, 'Myanmar', 'MM', '+95', 'Burmese kyat', 'Ks', 'MMK'),
(149, 'Namibia', 'NA', '+264', 'Namibian dollar', '$', 'NAD'),
(150, 'Nauru', 'NR', '+674', 'Australian dollar', '$', 'AUD'),
(151, 'Nepal', 'NP', '+977', 'Nepalese rupee', '₨', 'NPR'),
(152, 'Netherlands', 'NL', '+31', 'Euro', '€', 'EUR'),
(153, 'Netherlands Antilles', 'AN', '+599', '', '', ''),
(154, 'New Caledonia', 'NC', '+687', 'CFP franc', 'Fr', 'XPF'),
(155, 'New Zealand', 'NZ', '+64', 'New Zealand dollar', '$', 'NZD'),
(156, 'Nicaragua', 'NI', '+505', 'Nicaraguan córdoba', 'C$', 'NIO'),
(157, 'Niger', 'NE', '+227', 'West African CFA fra', 'Fr', 'XOF'),
(158, 'Nigeria', 'NG', '+234', 'Nigerian naira', '₦', 'NGN'),
(159, 'Niue', 'NU', '+683', 'New Zealand dollar', '$', 'NZD'),
(160, 'Norfolk Island', 'NF', '+672', '', '', ''),
(161, 'Northern Mariana Isl', 'MP', '+1670', '', '', ''),
(162, 'Norway', 'NO', '+47', 'Norwegian krone', 'kr', 'NOK'),
(163, 'Oman', 'OM', '+968', 'Omani rial', 'ر.ع.', 'OMR'),
(164, 'Pakistan', 'PK', '+92', 'Pakistani rupee', '₨', 'PKR'),
(165, 'Palau', 'PW', '+680', 'Palauan dollar', '$', ''),
(166, 'Palestinian Territor', 'PS', '+970', '', '', ''),
(167, 'Panama', 'PA', '+507', 'Panamanian balboa', 'B/.', 'PAB'),
(168, 'Papua New Guinea', 'PG', '+675', 'Papua New Guinean ki', 'K', 'PGK'),
(169, 'Paraguay', 'PY', '+595', 'Paraguayan guaraní', '₲', 'PYG'),
(170, 'Peru', 'PE', '+51', 'Peruvian nuevo sol', 'S/.', 'PEN'),
(171, 'Philippines', 'PH', '+63', 'Philippine peso', '₱', 'PHP'),
(172, 'Pitcairn', 'PN', '+872', '', '', ''),
(173, 'Poland', 'PL', '+48', 'Polish z?oty', 'zł', 'PLN'),
(174, 'Portugal', 'PT', '+351', 'Euro', '€', 'EUR'),
(175, 'Puerto Rico', 'PR', '+1939', '', '', ''),
(176, 'Qatar', 'QA', '+974', 'Qatari riyal', 'ر.ق', 'QAR'),
(177, 'Romania', 'RO', '+40', 'Romanian leu', 'lei', 'RON'),
(178, 'Russia', 'RU', '+7', 'Russian ruble', '', 'RUB'),
(179, 'Rwanda', 'RW', '+250', 'Rwandan franc', 'Fr', 'RWF'),
(180, 'Reunion', 'RE', '+262', '', '', ''),
(181, 'Saint Barthelemy', 'BL', '+590', '', '', ''),
(182, 'Saint Helena, Ascens', 'SH', '+290', '', '', ''),
(183, 'Saint Kitts and Nevi', 'KN', '+1869', '', '', ''),
(184, 'Saint Lucia', 'LC', '+1758', 'East Caribbean dolla', '$', 'XCD'),
(185, 'Saint Martin', 'MF', '+590', '', '', ''),
(186, 'Saint Pierre and Miq', 'PM', '+508', '', '', ''),
(187, 'Saint Vincent and th', 'VC', '+1784', '', '', ''),
(188, 'Samoa', 'WS', '+685', 'Samoan t?l?', 'T', 'WST'),
(189, 'San Marino', 'SM', '+378', 'Euro', '€', 'EUR'),
(190, 'Sao Tome and Princip', 'ST', '+239', '', '', ''),
(191, 'Saudi Arabia', 'SA', '+966', 'Saudi riyal', 'ر.س', 'SAR'),
(192, 'Senegal', 'SN', '+221', 'West African CFA fra', 'Fr', 'XOF'),
(193, 'Serbia', 'RS', '+381', 'Serbian dinar', 'дин. or din.', 'RSD'),
(194, 'Seychelles', 'SC', '+248', 'Seychellois rupee', '₨', 'SCR'),
(195, 'Sierra Leone', 'SL', '+232', 'Sierra Leonean leone', 'Le', 'SLL'),
(196, 'Singapore', 'SG', '+65', 'Brunei dollar', '$', 'BND'),
(197, 'Slovakia', 'SK', '+421', 'Euro', '€', 'EUR'),
(198, 'Slovenia', 'SI', '+386', 'Euro', '€', 'EUR'),
(199, 'Solomon Islands', 'SB', '+677', 'Solomon Islands doll', '$', 'SBD'),
(200, 'Somalia', 'SO', '+252', 'Somali shilling', 'Sh', 'SOS'),
(201, 'South Africa', 'ZA', '+27', 'South African rand', 'R', 'ZAR'),
(202, 'South Georgia and th', 'GS', '+500', '', '', ''),
(203, 'Spain', 'ES', '+34', 'Euro', '€', 'EUR'),
(204, 'Sri Lanka', 'LK', '+94', 'Sri Lankan rupee', 'Rs or රු', 'LKR'),
(205, 'Sudan', 'SD', '+249', 'Sudanese pound', 'ج.س.', 'SDG'),
(206, 'Suriname', 'SR', '+597', 'Surinamese dollar', '$', 'SRD'),
(207, 'Svalbard and Jan May', 'SJ', '+47', '', '', ''),
(208, 'Swaziland', 'SZ', '+268', 'Swazi lilangeni', 'L', 'SZL'),
(209, 'Sweden', 'SE', '+46', 'Swedish krona', 'kr', 'SEK'),
(210, 'Switzerland', 'CH', '+41', 'Swiss franc', 'Fr', 'CHF'),
(211, 'Syrian Arab Republic', 'SY', '+963', '', '', ''),
(212, 'Taiwan', 'TW', '+886', 'New Taiwan dollar', '$', 'TWD'),
(213, 'Tajikistan', 'TJ', '+992', 'Tajikistani somoni', 'ЅМ', 'TJS'),
(214, 'Tanzania, United Rep', 'TZ', '+255', '', '', ''),
(215, 'Thailand', 'TH', '+66', 'Thai baht', '฿', 'THB'),
(216, 'Timor-Leste', 'TL', '+670', '', '', ''),
(217, 'Togo', 'TG', '+228', 'West African CFA fra', 'Fr', 'XOF'),
(218, 'Tokelau', 'TK', '+690', '', '', ''),
(219, 'Tonga', 'TO', '+676', 'Tongan pa?anga', 'T$', 'TOP'),
(220, 'Trinidad and Tobago', 'TT', '+1868', 'Trinidad and Tobago ', '$', 'TTD'),
(221, 'Tunisia', 'TN', '+216', 'Tunisian dinar', 'د.ت', 'TND'),
(222, 'Turkey', 'TR', '+90', 'Turkish lira', '', 'TRY'),
(223, 'Turkmenistan', 'TM', '+993', 'Turkmenistan manat', 'm', 'TMT'),
(224, 'Turks and Caicos Isl', 'TC', '+1649', '', '', ''),
(225, 'Tuvalu', 'TV', '+688', 'Australian dollar', '$', 'AUD'),
(226, 'Uganda', 'UG', '+256', 'Ugandan shilling', 'Sh', 'UGX'),
(227, 'Ukraine', 'UA', '+380', 'Ukrainian hryvnia', '₴', 'UAH'),
(228, 'United Arab Emirates', 'AE', '+971', 'United Arab Emirates', 'د.إ', 'AED'),
(229, 'United Kingdom', 'GB', '+44', 'British pound', '£', 'GBP'),
(230, 'United States', 'US', '+1', 'United States dollar', '$', 'USD'),
(231, 'Uruguay', 'UY', '+598', 'Uruguayan peso', '$', 'UYU'),
(232, 'Uzbekistan', 'UZ', '+998', 'Uzbekistani som', '', 'UZS'),
(233, 'Vanuatu', 'VU', '+678', 'Vanuatu vatu', 'Vt', 'VUV'),
(234, 'Venezuela, Bolivaria', 'VE', '+58', '', '', ''),
(235, 'Vietnam', 'VN', '+84', 'Vietnamese ??ng', '₫', 'VND'),
(236, 'Virgin Islands, Brit', 'VG', '+1284', '', '', ''),
(237, 'Virgin Islands, U.S.', 'VI', '+1340', '', '', ''),
(238, 'Wallis and Futuna', 'WF', '+681', 'CFP franc', 'Fr', 'XPF'),
(239, 'Yemen', 'YE', '+967', 'Yemeni rial', '﷼', 'YER'),
(240, 'Zambia', 'ZM', '+260', 'Zambian kwacha', 'ZK', 'ZMW'),
(241, 'Zimbabwe', 'ZW', '+263', 'Botswana pula', 'P', 'BWP');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_ctmdcd_patient`
--

CREATE TABLE `qdc_ctmdcd_patient` (
  `patient_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(50) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `address` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `age` varchar(255) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `medical_info` longtext DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  PRIMARY KEY (`patient_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `qdc_ctmdcd_patient`
--

INSERT INTO `qdc_ctmdcd_patient` VALUES
(1, 'Mohaimin Chowdhury', 'munafa.tk@gmail.com', '01726002069', '', '', '32', 'Male', '[{"blood_group":"A+","height":"","weight":"63","blood_pressure":"80\\/120","pulse":"80","respiration":"","allergy":"","diet":""}]', 1684886400);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_ctmdcd_prescription`
--

CREATE TABLE `qdc_ctmdcd_prescription` (
  `prescription_id` int(11) NOT NULL AUTO_INCREMENT,
  `appointment_id` int(11) NOT NULL,
  `symptom` text NOT NULL,
  `diagnosis` text NOT NULL,
  `medicine` longtext NOT NULL COMMENT 'json',
  `test` longtext NOT NULL COMMENT 'json',
  `patient_id` int(11) NOT NULL,
  `chamber_id` int(11) NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY (`prescription_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `qdc_ctmdcd_prescription`
--

INSERT INTO `qdc_ctmdcd_prescription` VALUES
(1, 0, 'xvd', 'vbdfb', '[{"medicine_name":"vbbd","medicine_note":"101"},{"medicine_name":"vdbf","medicine_note":"001"}]', '[{"test_name":"vv","test_note":"cc"}]', 1, 0, 1684886400);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_ctmdcd_settings`
--

CREATE TABLE `qdc_ctmdcd_settings` (
  `settings_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`settings_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `qdc_ctmdcd_settings`
--

INSERT INTO `qdc_ctmdcd_settings` VALUES
(1, 'default_chamber_id', '1'),
(2, 'default_currency', '19'),
(3, 'default_email', 'doctor@chamber.com'),
(4, 'doctor_name', 'Marjana Siddique Moury'),
(5, 'doctor_phone', '+8801307978439'),
(6, 'doctor_qualification', '');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_dms_mappings`
--

CREATE TABLE `qdc_dms_mappings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `host` varchar(256) NOT NULL,
  `path` varchar(512) DEFAULT NULL,
  `attachment_id` bigint(20) DEFAULT NULL,
  `custom_html` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_dms_mapping_values`
--

CREATE TABLE `qdc_dms_mapping_values` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mapping_id` bigint(20) NOT NULL,
  `object_id` bigint(20) DEFAULT NULL,
  `object_type` varchar(256) NOT NULL,
  `primary` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mapping_id` (`mapping_id`),
  KEY `object_id` (`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_ea_error_logs`
--

CREATE TABLE `qdc_ea_error_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `error_type` varchar(50) DEFAULT NULL,
  `errors` text DEFAULT NULL,
  `errors_data` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_eb_form_settings`
--

CREATE TABLE `qdc_eb_form_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `block_id` varchar(24) NOT NULL,
  `title` text NOT NULL,
  `fields` text NOT NULL,
  `form_options` text NOT NULL,
  `settings` text NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `block_id` (`block_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_epf_fields`
--

CREATE TABLE `qdc_epf_fields` (
  `name` text NOT NULL,
  `start` float NOT NULL,
  `end` float NOT NULL,
  `step` float NOT NULL,
  `field_order` int(11) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `format` varchar(30) NOT NULL,
  `metadata` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_e_events`
--

CREATE TABLE `qdc_e_events` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `event_data` text DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_at_index` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_e_notes`
--

CREATE TABLE `qdc_e_notes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `route_url` text DEFAULT NULL COMMENT 'Clean url where the note was created.',
  `route_title` varchar(255) DEFAULT NULL,
  `route_post_id` bigint(20) unsigned DEFAULT NULL COMMENT 'The post id of the route that the note was created on.',
  `post_id` bigint(20) unsigned DEFAULT NULL,
  `element_id` varchar(60) DEFAULT NULL COMMENT 'The Elementor element ID the note is attached to.',
  `parent_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `author_id` bigint(20) unsigned DEFAULT NULL,
  `author_display_name` varchar(250) DEFAULT NULL COMMENT 'Save the author name when the author was deleted.',
  `status` varchar(20) NOT NULL DEFAULT 'publish',
  `position` text DEFAULT NULL COMMENT 'A JSON string that represents the position of the note inside the element in percentages. e.g. {x:10, y:15}',
  `content` longtext DEFAULT NULL,
  `is_resolved` tinyint(1) NOT NULL DEFAULT 0,
  `is_public` tinyint(1) NOT NULL DEFAULT 1,
  `last_activity_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `route_url_index` (`route_url`(191)),
  KEY `post_id_index` (`post_id`),
  KEY `element_id_index` (`element_id`),
  KEY `parent_id_index` (`parent_id`),
  KEY `author_id_index` (`author_id`),
  KEY `status_index` (`status`),
  KEY `is_resolved_index` (`is_resolved`),
  KEY `is_public_index` (`is_public`),
  KEY `created_at_index` (`created_at`),
  KEY `updated_at_index` (`updated_at`),
  KEY `last_activity_at_index` (`last_activity_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_e_notes_users_relations`
--

CREATE TABLE `qdc_e_notes_users_relations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(60) NOT NULL COMMENT 'The relation type between user and note (e.g mention, watch, read).',
  `note_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type_index` (`type`),
  KEY `note_id_index` (`note_id`),
  KEY `user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_e_submissions`
--

CREATE TABLE `qdc_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;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_e_submissions_actions_log`
--

CREATE TABLE `qdc_e_submissions_actions_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `submission_id_index` (`submission_id`),
  KEY `action_name_index` (`action_name`),
  KEY `status_index` (`status`),
  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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_e_submissions_values`
--

CREATE TABLE `qdc_e_submissions_values` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `submission_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `key` varchar(60) DEFAULT NULL,
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `submission_id_index` (`submission_id`),
  KEY `key_index` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_appointments`
--

CREATE TABLE `qdc_kc_appointments` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appointment_start_date` date DEFAULT NULL,
  `appointment_start_time` time DEFAULT NULL,
  `appointment_end_date` date DEFAULT NULL,
  `appointment_end_time` time DEFAULT NULL,
  `visit_type` varchar(191) DEFAULT NULL,
  `clinic_id` bigint(20) unsigned NOT NULL,
  `doctor_id` bigint(20) unsigned NOT NULL,
  `patient_id` bigint(20) unsigned NOT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) unsigned DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `appointment_report` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_kc_appointments`
--

INSERT INTO `qdc_kc_appointments` VALUES
(1, '2023-05-25', '17:30:00', '2023-05-25', '18:00:00', NULL, 1, 4, 8, '', 3, '2023-05-24 22:50:57', NULL),
(2, '2023-05-25', '18:30:00', '2023-05-25', '19:00:00', NULL, 1, 4, 6, '', 4, '2023-05-24 22:52:06', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_appointment_reminder_mapping`
--

CREATE TABLE `qdc_kc_appointment_reminder_mapping` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appointment_id` bigint(20) DEFAULT 0,
  `msg_send_date` date DEFAULT NULL,
  `email_status` int(1) DEFAULT 0,
  `sms_status` int(1) DEFAULT 0,
  `whatsapp_status` int(1) DEFAULT 0,
  `extra` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_appointment_service_mapping`
--

CREATE TABLE `qdc_kc_appointment_service_mapping` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appointment_id` bigint(20) DEFAULT 0,
  `service_id` int(10) DEFAULT 0,
  `status` int(1) DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_kc_appointment_service_mapping`
--

INSERT INTO `qdc_kc_appointment_service_mapping` VALUES
(1, 1, 2, 1, '2023-05-24 22:50:57'),
(2, 2, 2, 1, '2023-05-24 22:52:06');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_bills`
--

CREATE TABLE `qdc_kc_bills` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `encounter_id` bigint(20) unsigned NOT NULL,
  `appointment_id` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `total_amount` int(11) NOT NULL,
  `discount` int(11) NOT NULL,
  `actual_amount` int(11) NOT NULL,
  `status` bigint(1) NOT NULL,
  `payment_status` varchar(10) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `clinic_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_kc_bills`
--

INSERT INTO `qdc_kc_bills` VALUES
(2, 4, 2, '', 3100, 20, 3080, 0, 'unpaid', '2023-05-25 13:22:52', 1);

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_bill_items`
--

CREATE TABLE `qdc_kc_bill_items` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `bill_id` bigint(20) unsigned NOT NULL,
  `item_id` bigint(20) unsigned NOT NULL,
  `qty` int(6) NOT NULL,
  `price` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_kc_bill_items`
--

INSERT INTO `qdc_kc_bill_items` VALUES
(2, 2, 2, 1, 100, '2023-05-25 13:22:52'),
(3, 2, 2, 3, 1000, '2023-05-25 13:26:04');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_clinics`
--

CREATE TABLE `qdc_kc_clinics` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `telephone_no` varchar(191) DEFAULT NULL,
  `specialties` longtext DEFAULT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `status` tinyint(1) unsigned DEFAULT 0,
  `clinic_admin_id` bigint(20) NOT NULL DEFAULT 0,
  `clinic_logo` bigint(20) NOT NULL DEFAULT 0,
  `profile_image` bigint(20) DEFAULT NULL,
  `extra` longtext DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_kc_clinics`
--

INSERT INTO `qdc_kc_clinics` VALUES
(1, 'Quick Dental Care', 'munafa.tk@gmail.com', '01726002069', '[{"id":8,"label":"Dentist"}]', 'Nurani-1, Subidbazar', 'Sylhet', NULL, 'Bangladesh', '3100', 1, 7, 0, NULL, '{"currency_prefix":"","currency_postfix":"\\/-"}', '2023-05-24 22:20:16');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_clinic_schedule`
--

CREATE TABLE `qdc_kc_clinic_schedule` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `module_type` varchar(191) DEFAULT NULL,
  `module_id` bigint(20) unsigned NOT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) unsigned DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_clinic_sessions`
--

CREATE TABLE `qdc_kc_clinic_sessions` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `clinic_id` bigint(20) unsigned NOT NULL,
  `doctor_id` bigint(20) unsigned NOT NULL,
  `day` varchar(191) DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `time_slot` int(5) DEFAULT 5,
  `parent_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_kc_clinic_sessions`
--

INSERT INTO `qdc_kc_clinic_sessions` VALUES
(1, 1, 4, 'mon', '00:00:00', '23:55:00', 30, NULL, '2023-05-24 22:19:53'),
(2, 1, 4, 'tue', '00:00:00', '23:55:00', 30, 1, '2023-05-24 22:19:53'),
(3, 1, 4, 'wed', '00:00:00', '23:55:00', 30, 1, '2023-05-24 22:19:53'),
(4, 1, 4, 'thu', '00:00:00', '23:55:00', 30, 1, '2023-05-24 22:19:53'),
(5, 1, 4, 'fri', '00:00:00', '23:55:00', 30, 1, '2023-05-24 22:19:53'),
(6, 1, 4, 'sat', '00:00:00', '23:55:00', 30, 1, '2023-05-24 22:19:53'),
(7, 1, 4, 'sun', '00:00:00', '23:55:00', 30, 1, '2023-05-24 22:19:53');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_custom_fields`
--

CREATE TABLE `qdc_kc_custom_fields` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `module_type` varchar(191) DEFAULT NULL,
  `module_id` bigint(20) DEFAULT NULL,
  `fields` longtext DEFAULT NULL,
  `status` tinyint(1) unsigned DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_custom_fields_data`
--

CREATE TABLE `qdc_kc_custom_fields_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `module_type` varchar(191) DEFAULT NULL,
  `module_id` bigint(20) unsigned NOT NULL,
  `fields_data` longtext DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `field_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_doctor_clinic_mappings`
--

CREATE TABLE `qdc_kc_doctor_clinic_mappings` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `doctor_id` bigint(20) unsigned NOT NULL,
  `clinic_id` bigint(20) unsigned NOT NULL,
  `owner` tinyint(1) unsigned DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_kc_doctor_clinic_mappings`
--

INSERT INTO `qdc_kc_doctor_clinic_mappings` VALUES
(1, 4, 1, 0, '2023-05-24 22:19:53');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_medical_history`
--

CREATE TABLE `qdc_kc_medical_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `encounter_id` bigint(20) unsigned NOT NULL,
  `patient_id` bigint(20) unsigned NOT NULL,
  `type` varchar(191) NOT NULL,
  `title` varchar(191) NOT NULL,
  `added_by` bigint(20) unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_kc_medical_history`
--

INSERT INTO `qdc_kc_medical_history` VALUES
(1, 4, 6, 'note', 'non', 1, '2023-05-25 13:23:24'),
(2, 4, 6, 'problem', 'sssssd', 1, '2023-05-25 13:24:52'),
(3, 4, 6, 'observation', 'ssdc', 1, '2023-05-25 13:24:56'),
(4, 4, 6, 'note', 'wsdefc', 1, '2023-05-25 13:25:00');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_medical_problems`
--

CREATE TABLE `qdc_kc_medical_problems` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `encounter_id` bigint(20) unsigned NOT NULL,
  `patient_id` bigint(20) unsigned NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `description` text DEFAULT NULL,
  `problem_type` varchar(191) NOT NULL,
  `outcome` varchar(191) NOT NULL,
  `added_by` bigint(20) unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_patient_clinic_mappings`
--

CREATE TABLE `qdc_kc_patient_clinic_mappings` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `patient_id` bigint(20) unsigned NOT NULL,
  `clinic_id` bigint(20) unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_kc_patient_clinic_mappings`
--

INSERT INTO `qdc_kc_patient_clinic_mappings` VALUES
(1, 6, 1, '0000-00-00 00:00:00'),
(2, 8, 1, '2023-05-24 22:22:37');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_patient_encounters`
--

CREATE TABLE `qdc_kc_patient_encounters` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `encounter_date` date DEFAULT NULL,
  `clinic_id` bigint(20) unsigned NOT NULL,
  `doctor_id` bigint(20) unsigned NOT NULL,
  `patient_id` bigint(20) unsigned NOT NULL,
  `appointment_id` bigint(20) unsigned DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) unsigned DEFAULT 0,
  `added_by` bigint(20) unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_kc_patient_encounters`
--

INSERT INTO `qdc_kc_patient_encounters` VALUES
(4, '2023-05-25', 1, 4, 6, 2, '', 1, 1, '2023-05-25 13:22:52');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_patient_review`
--

CREATE TABLE `qdc_kc_patient_review` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `review` bigint(20) unsigned NOT NULL,
  `review_description` longtext DEFAULT NULL,
  `patient_id` bigint(20) unsigned NOT NULL,
  `doctor_id` bigint(20) unsigned NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_payments_appointment_mappings`
--

CREATE TABLE `qdc_kc_payments_appointment_mappings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_mode` varchar(255) DEFAULT '',
  `payment_id` varchar(255) DEFAULT '',
  `payer_id` varchar(255) DEFAULT '',
  `payer_email` varchar(255) DEFAULT '',
  `appointment_id` bigint(20) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `currency` varchar(255) DEFAULT '',
  `payment_status` varchar(255) DEFAULT '',
  `request_page_url` varchar(255) DEFAULT '',
  `extra` longtext DEFAULT NULL,
  `notification_status` bigint(20) DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_prescription`
--

CREATE TABLE `qdc_kc_prescription` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `encounter_id` bigint(20) unsigned NOT NULL,
  `patient_id` bigint(20) unsigned NOT NULL,
  `name` varchar(199) DEFAULT NULL,
  `frequency` varchar(199) DEFAULT NULL,
  `duration` varchar(199) DEFAULT NULL,
  `instruction` text DEFAULT NULL,
  `added_by` bigint(20) unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_kc_prescription`
--

INSERT INTO `qdc_kc_prescription` VALUES
(1, 1, 1, '1', 'as', '30', 'xxxxxxxxxx', 1, '2023-05-24 22:59:55'),
(2, 4, 6, 'qwerty', '101', '2', 'ball', 1, '2023-05-25 13:24:16'),
(3, 4, 6, '1', '101', '5', NULL, 1, '2023-05-25 13:24:33');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_receptionist_clinic_mappings`
--

CREATE TABLE `qdc_kc_receptionist_clinic_mappings` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `receptionist_id` bigint(20) unsigned NOT NULL,
  `clinic_id` bigint(20) unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `qdc_kc_receptionist_clinic_mappings`
--

INSERT INTO `qdc_kc_receptionist_clinic_mappings` VALUES
(1, 5, 1, '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `qdc_kc_services`
--

CREATE TABLE `qdc_kc_services` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `price` int(11) NOT NULL,
  `status` bigint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
