wp_fc_campaign_emails.sql

wp_fc_campaign_emails.sql

--
-- Table structure for table `wp_fc_campaign_emails`
--

CREATE TABLE `wp_fc_campaign_emails` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `campaign_id` bigint(20) UNSIGNED DEFAULT NULL,
  `email_type` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT 'campaign',
  `subscriber_id` bigint(20) UNSIGNED DEFAULT NULL,
  `email_subject_id` bigint(20) UNSIGNED DEFAULT NULL,
  `email_address` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `email_subject` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `email_body` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `email_headers` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `is_open` tinyint(1) NOT NULL DEFAULT 0,
  `is_parsed` tinyint(1) NOT NULL DEFAULT 0,
  `click_counter` int(11) DEFAULT NULL,
  `status` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'draft',
  `note` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `scheduled_at` timestamp NULL DEFAULT NULL,
  `email_hash` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `wp_fc_campaign_emails`
--
ALTER TABLE `wp_fc_campaign_emails`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wp_fc_cam__cid_idx` (`campaign_id`),
  ADD KEY `wp_fc_cam__sid_idx` (`subscriber_id`),
  ADD KEY `wp_fc_cam__et_idx` (`email_type`),
  ADD KEY `wp_fc_cam__estidx` (`status`),
  ADD KEY `wp_fc_cam__emtidx` (`email_hash`),
  ADD KEY `scheduled_at` (`scheduled_at`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `wp_fc_campaign_emails`
--
ALTER TABLE `wp_fc_campaign_emails`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;