{"slug":"e-shot-form-builder","name":"e-shot","description":"Installing the e-shot™ plugin for WordPress enables you to add e-shot™ sign-up forms to your WordPress site, hassle free. Your website visitors will h …","author":"forfront","active_installs":10,"version":"1.0.2","wp_org_url":"https://wordpress.org/plugins/e-shot-form-builder/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"eshotformbuilder_control","full_table_name":"wp_eshotformbuilder_control","description":"Stores eshotformbuilder control data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_eshotformbuilder_control` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `token` varchar(36) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"eshotformbuilder_fields","full_table_name":"wp_eshotformbuilder_fields","description":"Stores eshotformbuilder fields data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_eshotformbuilder_fields` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `e_shot_form_id` mediumint NOT NULL,\\n  `display_name` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `field_name` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `data_type` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `field_length` mediumint DEFAULT NULL,\\n  `data_type_id` mediumint DEFAULT NULL,\\n  `use_field` tinyint(1) NOT NULL DEFAULT '1',\\n  `mandatory` tinyint(1) NOT NULL DEFAULT '1',\\n  `group_field` tinyint(1) NOT NULL DEFAULT '0',\\n  `group_field_id` mediumint DEFAULT NULL,\\n  `group_field_display` tinyint(1) NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"eshotformbuilder_forms","full_table_name":"wp_eshotformbuilder_forms","description":"Stores form definitions and related configuration.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_eshotformbuilder_forms` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `subscribe_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `form_id` mediumint NOT NULL,\\n  `sub_account_id` mediumint NOT NULL,\\n  `form_type` mediumint NOT NULL,\\n  `show_group` mediumint NOT NULL,\\n  `include_consent` tinyint(1) NOT NULL DEFAULT '0',\\n  `consent_text` text COLLATE utf8mb4_unicode_520_ci,\\n  `display_preferences` tinyint(1) NOT NULL DEFAULT '1',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"eshotformbuilder_preference_centre","full_table_name":"wp_eshotformbuilder_preference_centre","description":"Stores eshotformbuilder preference centre data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_eshotformbuilder_preference_centre` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `channel_preference_id` mediumint NOT NULL,\\n  `e_shot_form_id` mediumint NOT NULL,\\n  `channel_id` mediumint NOT NULL,\\n  `channel_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `preference_id` mediumint NOT NULL,\\n  `preference_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `is_shown` tinyint(1) DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"eshotformbuilder_subaccounts","full_table_name":"wp_eshotformbuilder_subaccounts","description":"Stores eshotformbuilder subaccounts data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_eshotformbuilder_subaccounts` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `subaccount_id` mediumint NOT NULL,\\n  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `onboarding` tinyint(1) DEFAULT NULL,\\n  `is_live` tinyint(1) DEFAULT NULL,\\n  `has_channels` tinyint(1) DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":5}