{"slug":"email-subscribers","name":"Email Subscribers & Newsletters – Email Marketing, Post Notifications & Newsletter Plugin for WordPress","description":"Add subscription forms on the website and send newsletters & automatically send post notification about new blog posts once it gets published.","author":"Icegram","active_installs":60000,"version":"5.9.23","wp_org_url":"https://wordpress.org/plugins/email-subscribers/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"actionscheduler_logs","full_table_name":"wp_actionscheduler_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"es_advanced_form","full_table_name":"wp_es_advanced_form","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"es_deliverreport","full_table_name":"wp_es_deliverreport","description":"Stores es deliverreport data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"es_emaillist","full_table_name":"wp_es_emaillist","description":"Stores es emaillist data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"es_lists","full_table_name":"wp_es_lists","description":"Stores es lists data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"es_notification","full_table_name":"wp_es_notification","description":"Stores es notification data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"es_sentdetails","full_table_name":"wp_es_sentdetails","description":"Stores es sentdetails data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"es_subscriber_ips","full_table_name":"wp_es_subscriber_ips","description":"Stores es subscriber ips data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ip","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_es_subscriber_ips ( ip varchar(45) NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (created_at, ip), KEY ip (ip) ) $charset_collate\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $es_subscriber_ips_table );"},{"table_name":"es_templates","full_table_name":"wp_es_templates","description":"Stores es templates data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_actions","full_table_name":"wp_ig_actions","description":"Stores ig actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_blocked_emails","full_table_name":"wp_ig_blocked_emails","description":"Stores ig blocked emails data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_campaigns","full_table_name":"wp_ig_campaigns","description":"Stores ig campaigns data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(10)","nullable":false,"primary_key":true},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"parent_id","type":"int(10) unsigned","nullable":true,"primary_key":false},{"name":"parent_type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"subject","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"body","type":"longtext","nullable":true,"primary_key":false},{"name":"from_name","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"from_email","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"reply_to_name","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"reply_to_email","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"categories","type":"text","nullable":true,"primary_key":false},{"name":"list_ids","type":"text","nullable":false,"primary_key":false},{"name":"base_template_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"status","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"meta","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"deleted_at","type":"datetime","nullable":true,"primary_key":false},{"name":"wp_user_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"first_name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"last_name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"source","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ip_address","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"country_code","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"bounce_status","type":"enum('0','1','2')","nullable":false,"primary_key":false},{"name":"timezone","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"form_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"reference_site","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"unsubscribed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"hash","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"engagement_score","type":"float","nullable":true,"primary_key":false},{"name":"average_opened_at","type":"TIME","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"is_verified","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"is_disposable","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"is_rolebased","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"is_webmail","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"is_deliverable","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"is_sendsafely","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"meta","type":"longtext","nullable":true,"primary_key":false},{"name":"created_on","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"email","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ip","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"created_on","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"body","type":"longtext","nullable":true,"primary_key":false},{"name":"settings","type":"longtext","nullable":true,"primary_key":false},{"name":"styles","type":"longtext","nullable":true,"primary_key":false},{"name":"preview_image","type":"mediumtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"deleted_at","type":"datetime","nullable":true,"primary_key":false},{"name":"af_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"hash","type":"varchar(12)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"deleted_at","type":"datetime","nullable":true,"primary_key":false},{"name":"list_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"contact_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"optin_type","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"subscribed_at","type":"datetime","nullable":true,"primary_key":false},{"name":"subscribed_ip","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"unsubscribed_at","type":"datetime","nullable":true,"primary_key":false},{"name":"unsubscribed_ip","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"hash","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"campaign_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"subject","type":"text","nullable":true,"primary_key":false},{"name":"body","type":"longtext","nullable":true,"primary_key":false},{"name":"count","type":"int(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"start_at","type":"datetime","nullable":true,"primary_key":false},{"name":"finish_at","type":"datetime","nullable":true,"primary_key":false},{"name":"meta","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"mailing_queue_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"mailing_queue_hash","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"campaign_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"contact_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"contact_hash","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"links","type":"longtext","nullable":true,"primary_key":false},{"name":"opened","type":"int(1)","nullable":true,"primary_key":false},{"name":"send_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"sent_at","type":"datetime","nullable":true,"primary_key":false},{"name":"opened_at","type":"datetime","nullable":true,"primary_key":false},{"name":"contact_id","type":"bigint(10) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"contact_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"campaign_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"requeued","type":"tinyint(1) unsigned","nullable":false,"primary_key":false},{"name":"added","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"timestamp","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"sent_at","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"priority","type":"tinyint(1) unsigned","nullable":false,"primary_key":false},{"name":"count","type":"tinyint(1) unsigned","nullable":false,"primary_key":false},{"name":"error","type":"tinyint(1) unsigned","nullable":false,"primary_key":false},{"name":"ignore_status","type":"tinyint(1) unsigned","nullable":false,"primary_key":false},{"name":"options","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"tags","type":"longtext","nullable":false,"primary_key":false},{"name":"contact_id","type":"bigint(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"message_id","type":"bigint(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"campaign_id","type":"bigint(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"count","type":"int(11) UNSIGNED","nullable":false,"primary_key":false},{"name":"link_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"list_id","type":"int(11) UNSIGNED","nullable":false,"primary_key":false},{"name":"ip","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"country","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"device","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"browser","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"email_client","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"os","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"created_at","type":"int(11) UNSIGNED","nullable":false,"primary_key":false},{"name":"updated_at","type":"int(11) UNSIGNED","nullable":false,"primary_key":false},{"name":"message_id","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"campaign_id","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"link","type":"varchar(2083)","nullable":false,"primary_key":false},{"name":"hash","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"i","type":"tinyint(1) unsigned","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trigger_name","type":"varchar(250)","nullable":false,"primary_key":false},{"name":"trigger_options","type":"longtext","nullable":false,"primary_key":false},{"name":"rules","type":"longtext","nullable":false,"primary_key":false},{"name":"actions","type":"longtext","nullable":false,"primary_key":false},{"name":"status","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"type","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"priority","type":"int(11)","nullable":true,"primary_key":false},{"name":"meta","type":"longtext","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"workflow_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"failed","type":"int(1)","nullable":false,"primary_key":false},{"name":"failure_code","type":"int(3)","nullable":false,"primary_key":false},{"name":"meta","type":"longtext","nullable":false,"primary_key":false},{"name":"scheduled_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"guest_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"last_modified","type":"datetime","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false},{"name":"items","type":"longtext","nullable":false,"primary_key":false},{"name":"coupons","type":"longtext","nullable":false,"primary_key":false},{"name":"fees","type":"longtext","nullable":false,"primary_key":false},{"name":"shipping_tax_total","type":"double","nullable":false,"primary_key":false},{"name":"shipping_total","type":"double","nullable":false,"primary_key":false},{"name":"total","type":"double","nullable":false,"primary_key":false},{"name":"token","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(8)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"tracking_key","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false},{"name":"last_active","type":"datetime","nullable":true,"primary_key":false},{"name":"meta","type":"longtext","nullable":false,"primary_key":false},{"name":"language","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"most_recent_order","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"version","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"data","type":"longtext","nullable":false,"primary_key":false},{"name":"identifier","type":"char(13)","nullable":false,"primary_key":false},{"name":"contact_id","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"list_id","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"campaign_id","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"mailing_queue_id","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"feedback_slug","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"feedback_text","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"meta","type":"longtext","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"label","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"meta","type":"longtext","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_ig_campaigns` ( `id` int(10) NOT NULL AUTO_INCREMENT, `slug` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `type` varchar(50) DEFAULT NULL, `parent_id` int(10) unsigned DEFAULT NULL, `parent_type` varchar(50) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `body` longtext DEFAULT NULL, `from_name` varchar(250) DEFAULT NULL, `from_email` varchar(150) DEFAULT NULL, `reply_to_name` varchar(250) DEFAULT NULL, `reply_to_email` varchar(150) DEFAULT NULL, `categories` text, `list_ids` text NOT NULL, `base_template_id` int(10) NOT NULL, `status` tinyint(4) NOT NULL, `meta` longtext DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (id), KEY `type` (type), KEY `status` (status), KEY `base_template_id` (base_template_id) ) $collate; CREATE TABLE `wp_ig_contacts` ( `id` int(10) NOT NULL AUTO_INCREMENT, `wp_user_id` int(10) NOT NULL DEFAULT '0', `first_name` varchar(50) DEFAULT NULL, `last_name` varchar(50) DEFAULT NULL, `email` varchar(50) NOT NULL, `source` varchar(50) DEFAULT NULL, `ip_address` varchar(50) DEFAULT NULL, `country_code` varchar(50) DEFAULT NULL, `bounce_status` enum('0','1','2') NOT NULL DEFAULT '0', `timezone` varchar(255) NULL DEFAULT NULL, `form_id` int(10) NOT NULL DEFAULT '0', `status` varchar(10) DEFAULT NULL, `reference_site` varchar(255) NULL DEFAULT NULL, `unsubscribed` tinyint(1) NOT NULL DEFAULT '0', `hash` varchar(50) DEFAULT NULL, `engagement_score` float DEFAULT NULL, `average_opened_at` TIME DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `is_verified` tinyint(1) DEFAULT '0', `is_disposable` tinyint(1) DEFAULT '0', `is_rolebased` tinyint(1) DEFAULT '0', `is_webmail` tinyint(1) DEFAULT '0', `is_deliverable` tinyint(1) DEFAULT '0', `is_sendsafely` tinyint(1) DEFAULT '0', `meta` longtext CHARACTER SET utf8, PRIMARY KEY (id), KEY `wp_user_id` (wp_user_id), KEY `email` (email), KEY `status` (status), KEY `form_id` (form_id) ) $collate; CREATE TABLE `wp_ig_contacts_ips` ( ip varchar(45) NOT NULL, created_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (created_on, ip), KEY ip (ip) ) $collate; CREATE TABLE `wp_ig_blocked_emails` ( id int(10) NOT NULL AUTO_INCREMENT, email varchar(50) DEFAULT NULL, ip varchar(45) DEFAULT NULL, created_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $collate; CREATE TABLE `wp_ig_forms` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `body` longtext, `settings` longtext, `styles` longtext, `preview_image` mediumtext DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, `af_id` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (id) ) $collate; CREATE TABLE `wp_ig_lists` ( `id` int(10) NOT NULL AUTO_INCREMENT, `slug` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `description` varchar(255) DEFAULT NULL, `hash` varchar(12) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (id) ) $collate; CREATE TABLE `wp_ig_lists_contacts` ( `id` int(10) NOT NULL AUTO_INCREMENT, `list_id` int(10) NOT NULL, `contact_id` int(10) NOT NULL, `status` varchar(50) NOT NULL, `optin_type` tinyint(4) NOT NULL, `subscribed_at` datetime DEFAULT NULL, `subscribed_ip` varchar(45) DEFAULT NULL, `unsubscribed_at` datetime DEFAULT NULL, `unsubscribed_ip` varchar(45) DEFAULT NULL, PRIMARY KEY (id), KEY `contact_id` (contact_id) ) $collate; CREATE TABLE `wp_ig_mailing_queue` ( `id` int(10) NOT NULL AUTO_INCREMENT, `hash` varchar(50) NOT NULL, `campaign_id` int(10) NOT NULL DEFAULT '0', `subject` text DEFAULT '', `body` longtext, `count` int(10) UNSIGNED NOT NULL DEFAULT '0', `status` varchar(10) NOT NULL, `start_at` datetime DEFAULT NULL, `finish_at` datetime DEFAULT NULL, `meta` longtext DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (id), KEY `campaign_id` (campaign_id) ) $collate; CREATE TABLE `wp_ig_sending_queue` ( `id` int(10) NOT NULL AUTO_INCREMENT, `mailing_queue_id` int(10) NOT NULL DEFAULT '0', `mailing_queue_hash` varchar(50) DEFAULT NULL, `campaign_id` int(10) NOT NULL DEFAULT '0', `contact_id` int(10) NOT NULL DEFAULT '0', `contact_hash` varchar(255) DEFAULT NULL, `email` varchar(50) DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `links` longtext, `opened` int(1) DEFAULT NULL, `send_at` DATETIME NULL DEFAULT NULL, `sent_at` datetime DEFAULT NULL, `opened_at` datetime DEFAULT NULL, PRIMARY KEY (id) ) $collate; \"; return $tables; } /** * Create Contact Meta table * * @param string $collate * * @return string * * @since 4.2.0 */ public static function get_ig_es_420_schema( $collate = '' ) { global $wpdb; $tables = \"CREATE TABLE `wp_ig_contact_meta` ( `id` int(10) NOT NULL AUTO_INCREMENT, `contact_id` bigint(10) unsigned NOT NULL, `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext, PRIMARY KEY (id), KEY `contact_id` (contact_id), KEY `meta_ley` (meta_key) ) $collate; \"; return $tables; } /** * Add new table * * @param string $collate * * @return string * * @since 4.2.1 */ public static function get_ig_es_421_schema( $collate = '' ) { global $wpdb; $tables = \"CREATE TABLE `wp_ig_contactmeta` ( `meta_id` bigint(20) NOT NULL AUTO_INCREMENT, `contact_id` bigint(20) unsigned NOT NULL, `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext DEFAULT NULL, PRIMARY KEY (meta_id), KEY `contact_id` (contact_id), KEY `meta_ley` (meta_key) ) $collate; CREATE TABLE wp_ig_queue ( `contact_id` bigint(20) unsigned NOT NULL DEFAULT 0, `campaign_id` bigint(20) unsigned NOT NULL DEFAULT 0, `requeued` tinyint(1) unsigned NOT NULL DEFAULT 0, `added` int(11) unsigned NOT NULL DEFAULT 0, `timestamp` int(11) unsigned NOT NULL DEFAULT 0, `sent_at` int(11) unsigned NOT NULL DEFAULT 0, `priority` tinyint(1) unsigned NOT NULL DEFAULT 0, `count` tinyint(1) unsigned NOT NULL DEFAULT 0, `error` tinyint(1) unsigned NOT NULL DEFAULT 0, `ignore_status` tinyint(1) unsigned NOT NULL DEFAULT 0, `options` varchar(191) NOT NULL DEFAULT '', `tags` longtext NOT NULL, UNIQUE KEY `id` (`contact_id`,`campaign_id`,`requeued`,`options`), KEY `contact_id` (`contact_id`), KEY `campaign_id` (`campaign_id`), KEY `requeued` (`requeued`), KEY `timestamp` (`timestamp`), KEY `priority` (`priority`), KEY `count` (`count`), KEY `error` (`error`), KEY `ignore_status` (`ignore_status`) ) $collate; CREATE TABLE `wp_ig_actions` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `contact_id` bigint(20) UNSIGNED DEFAULT NULL, `message_id` bigint(20) UNSIGNED DEFAULT NULL, `campaign_id` bigint(20) UNSIGNED DEFAULT NULL, `type` tinyint(1) NOT NULL DEFAULT 0, `count` int(11) UNSIGNED NOT NULL DEFAULT 0, `link_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `list_id` int(11) UNSIGNED NOT NULL DEFAULT 0, `ip` varchar(50) DEFAULT NULL, `country` varchar(50) DEFAULT NULL, `device` varchar(50) DEFAULT NULL, `browser` varchar(50) DEFAULT NULL, `email_client` varchar(50) DEFAULT NULL, `os` varchar(50) DEFAULT NULL, `created_at` int(11) UNSIGNED NOT NULL DEFAULT 0, `updated_at` int(11) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY `id` (`contact_id`,`message_id`, `campaign_id`,`type`,`link_id`, `list_id`), KEY `contact_id` (`contact_id`), KEY `message_id` (`message_id`), KEY `campaign_id` (`campaign_id`), KEY `type` (`type`), KEY `idx_updated_type_contact` (`updated_at`, `type`, `contact_id`) ) $collate; \"; return $tables; } /** * Create Links Table * * @param string $collate * * @return string * * @sinc 4.2.4 */ public static function get_ig_es_424_schema( $collate = '' ) { global $wpdb; $tables = \"CREATE TABLE `wp_ig_links` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `message_id` int(10) unsigned NOT NULL, `campaign_id` int(10) unsigned NOT NULL, `link` varchar(2083) NOT NULL, `hash` varchar(20) NOT NULL, `i` tinyint(1) unsigned NOT NULL, `created_at` datetime DEFAULT NULL, PRIMARY KEY (id), KEY `campaign_id` (campaign_id), KEY `message_id` (message_id), KEY `link` (link(100)) ) $collate; \"; return $tables; } /** * Create Links Table * * @param string $collate * * @return string * * @sinc 4.4.1 */ public static function get_ig_es_441_schema( $collate = '' ) { global $wpdb; $tables = \"CREATE TABLE `wp_ig_workflows` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `trigger_name` varchar(250) NOT NULL, `trigger_options` longtext NOT NULL, `rules` longtext NOT NULL, `actions` longtext NOT NULL, `status` tinyint(4) NOT NULL, `type` tinyint(4) NOT NULL, `priority` int(11) DEFAULT 0, `meta` longtext NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (id) ) $collate; CREATE TABLE wp_ig_workflows_queue ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `workflow_id` bigint(20) DEFAULT NULL, `failed` int(1) NOT NULL DEFAULT 0, `failure_code` int(3) NOT NULL DEFAULT 0, `meta` longtext NOT NULL, `scheduled_at` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, PRIMARY KEY (id) ) $collate; \"; return $tables; } /** * Create WooCommerce cart and guest tables * * @param string $collate * * @return string * * @sinc 4.6.5 */ public static function get_ig_es_465_schema( $collate = '' ) { global $wpdb; $tables = \"CREATE TABLE `wp_ig_wc_cart` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `status` varchar(100) NOT NULL default '', `user_id` bigint(20) NOT NULL default 0, `guest_id` bigint(20) NOT NULL default 0, `last_modified` datetime NULL, `created` datetime NULL, `items` longtext NOT NULL default '', `coupons` longtext NOT NULL default '', `fees` longtext NOT NULL default '', `shipping_tax_total` double DEFAULT 0 NOT NULL, `shipping_total` double DEFAULT 0 NOT NULL, `total` double DEFAULT 0 NOT NULL, `token` varchar(32) NOT NULL default '', `currency` varchar(8) NOT NULL default '', PRIMARY KEY (id), KEY `status` (`status`), KEY `user_id` (`user_id`), KEY `guest_id` (`guest_id`), KEY `last_modified` (`last_modified`), KEY `created` (`created`) ) $collate; CREATE TABLE `wp_ig_wc_guests` ( id bigint(20) NOT NULL AUTO_INCREMENT, email varchar(255) NOT NULL default '', tracking_key varchar(32) NOT NULL default '', created datetime NULL, last_active datetime NULL, meta longtext NOT NULL, language varchar(10) NOT NULL default '', most_recent_order bigint(20) NOT NULL DEFAULT 0, version bigint(20) NOT NULL default 0, PRIMARY KEY (id), KEY tracking_key (tracking_key), KEY email (email(191)), KEY most_recent_order (most_recent_order), KEY version (version) ) $collate; \"; return $tables; } /** * Create table for storing subscribers import CSV data temporarily * * @param string $collate * * @return string * * @since 4.6.6 */ public static function get_ig_es_466_schema( $collate = '' ) { global $wpdb; $tables = \"CREATE TABLE wp_ig_temp_import ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `data` longtext NOT NULL, `identifier` char(13) NOT NULL, PRIMARY KEY (ID) ) $collate;\"; return $tables; } /** * Create table unsubscribe feedback * * @param string $collate * * @return string * * @since 4.6.8 */ public static function get_ig_es_468_schema( $collate = '' ) { global $wpdb; $tables = \"CREATE TABLE wp_ig_unsubscribe_feedback ( `id` int(10) NOT NULL AUTO_INCREMENT, `contact_id` int(10) unsigned NOT NULL, `list_id` int(10) unsigned NOT NULL, `campaign_id` int(10) unsigned NOT NULL, `mailing_queue_id` int(10) unsigned NOT NULL, `feedback_slug` varchar(50) NOT NULL, `feedback_text` varchar(500) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `meta` longtext DEFAULT NULL, PRIMARY KEY (id) ) $collate;\"; return $tables; } /** * Create table for storing custom fields * * @param string $collate * * @return string * * @since 4.8.4 */ public static function get_ig_es_484_schema( $collate = '' ) { global $wpdb; $tables = \"CREATE TABLE wp_ig_custom_fields ( `id` int(10) NOT NULL AUTO_INCREMENT, `slug` varchar(100) NOT NULL, `label` varchar(100) NOT NULL, `type` varchar(50) NOT NULL, `meta` longtext DEFAULT NULL, PRIMARY KEY (id) ) $collate;\"; return $tables; } /** * Collect multiple version schema * * @param string $collate * * @return string * * @since 4.2.0 */ private static function get_schema( $collate = '' ) { $tables = self::get_ig_es_400_schema( $collate );"},{"table_name":"ig_contact_meta","full_table_name":"wp_ig_contact_meta","description":"Stores additional metadata (key-value pairs) for ig contact records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_contactmeta","full_table_name":"wp_ig_contactmeta","description":"Stores ig contactmeta data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_contacts","full_table_name":"wp_ig_contacts","description":"Stores ig contacts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_contacts_ips","full_table_name":"wp_ig_contacts_ips","description":"Stores ig contacts ips data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_custom_fields","full_table_name":"wp_ig_custom_fields","description":"Stores ig custom fields data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_forms","full_table_name":"wp_ig_forms","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_links","full_table_name":"wp_ig_links","description":"Stores ig links data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_lists","full_table_name":"wp_ig_lists","description":"Stores ig lists data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_lists_contacts","full_table_name":"wp_ig_lists_contacts","description":"Stores ig lists contacts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_mailing_queue","full_table_name":"wp_ig_mailing_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_queue","full_table_name":"wp_ig_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_sending_queue","full_table_name":"wp_ig_sending_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_temp_import","full_table_name":"wp_ig_temp_import","description":"Stores ig temp import data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ig_unsubscribe_feedback","full_table_name":"wp_ig_unsubscribe_feedback","description":"Stores ig unsubscribe feedback data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ig_wc_cart","full_table_name":"wp_ig_wc_cart","description":"Stores ig wc cart data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ig_wc_guests","full_table_name":"wp_ig_wc_guests","description":"Stores ig wc guests data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ig_workflows","full_table_name":"wp_ig_workflows","description":"Stores ig workflows data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ig_workflows_queue","full_table_name":"wp_ig_workflows_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":31}