{"table_name":"bitforms_reports","full_table_name":"wp_bitforms_reports","description":"Stores bitforms reports data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS `wp_bitforms_reports` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category` varchar(50) NOT NULL, `type` varchar(20) NOT NULL, `context` varchar(20) NOT NULL, `details` longtext DEFAULT NULL, `isDefault` tinyint(1) DEFAULT 0,/* 0 not default, 1 default */ `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `user_device` varchar(50) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_bitforms_form` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `form_name` varchar(255) DEFAULT NULL, `form_content` longtext DEFAULT NULL, `builder_helper_state` longtext DEFAULT NULL, `atomic_class_map` longtext DEFAULT NULL, `generated_script_page_ids` longtext DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `views` int(11) unsigned DEFAULT 0, `entries` int(11) unsigned DEFAULT 0, `user_device` varchar(50) DEFAULT NULL, `status` tinyint(1) DEFAULT 1,/* 0 not published, 1 published, 2 trashed */ `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_bitforms_workflows` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `workflow_name` varchar(255) NOT NULL, `workflow_type` varchar(50) NOT NULL, `workflow_run` varchar(50) NOT NULL, `workflow_behaviour` varchar(25) NOT NULL, `workflow_condition` longtext DEFAULT NULL, `workflow_info` longtext DEFAULT NULL, `workflow_order` int(11) unsigned DEFAULT NULL, `workflow_status` tinyint(1) DEFAULT 1,/* 0 disable, 1 enable, 2 enable in field settings */ `form_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `user_location` text DEFAULT NULL, `user_device` varchar(50) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `form_id` (`form_id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_bitforms_success_messages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `message_title` varchar(255) DEFAULT NULL, `message_content` longtext DEFAULT NULL, `message_config` longtext DEFAULT NULL, `form_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_bitforms_email_template` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` text DEFAULT NULL, `sub` text DEFAULT NULL, `body` longtext DEFAULT NULL, `form_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_bitforms_integration` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category` varchar(50) NOT NULL, `integration_name` varchar(255) DEFAULT NULL, `integration_type` varchar(50) NOT NULL, `integration_details` longtext DEFAULT NULL, `form_id` bigint(20) unsigned DEFAULT NULL, /* form_id = 0 means all/app */ `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `status` tinyint(1) DEFAULT 1,/* 0 disabled, 1 published, 2 trashed */ `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_bitforms_form_entries` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `form_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` varchar(255) DEFAULT NULL, `user_location` text DEFAULT NULL, `user_device` varchar(50) DEFAULT NULL, `referer` TEXT DEFAULT NULL, `status` tinyint(1) DEFAULT 0,/* 0 not viewed, 1 viewed, 2 trashed */ `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `form_id` (`form_id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_bitforms_form_entrymeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `bitforms_form_entry_id` bigint(20) unsigned DEFAULT NULL, `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`), KEY `meta_key` (`meta_key`({$max_index_length})), KEY `entry_id` (`bitforms_form_entry_id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_bitforms_form_entry_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `log_type` varchar(50) DEFAULT NULL, `ip` int(11) DEFAULT NULL, `action_type` varchar(50) DEFAULT NULL, `form_entry_id` bigint(20) DEFAULT NULL, `form_id` bigint(20) DEFAULT NULL, `content` longtext, `created_at` DATETIME NOT NULL, PRIMARY KEY (`id`), KEY `form_id` (`form_id`), KEY `form_entry_id` (`form_entry_id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_bitforms_form_log_details` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `log_id` bigint(20) NOT NULL, `integration_id` bigint(20) DEFAULT NULL, `api_type` varchar(255) DEFAULT NULL, `response_type` varchar(50) DEFAULT NULL, `response_obj` LONGTEXT DEFAULT NULL, `created_at` DATETIME NOT NULL, PRIMARY KEY (`id`), KEY `log_id` (`log_id`), KEY `integration_id` (`integration_id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_bitforms_form_entry_relatedinfo` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `info_type` VARCHAR(50) NOT NULL, `info_details` LONGTEXT NULL, `form_id` BIGINT(20) UNSIGNED NOT NULL, `entry_id` BIGINT(20) UNSIGNED NOT NULL, `user_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, `user_ip` INT(11) UNSIGNED NULL DEFAULT NULL, `status` INT(1) UNSIGNED NOT NULL DEFAULT '1', `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `form_id` (`form_id`), KEY `entry_id` (`entry_id`) ) $collate;\" ]; try { include_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ($table_schema as $table) { dbDelta($table);","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"category","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"context","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"details","type":"longtext","nullable":true,"primary_key":false},{"name":"isDefault","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"1","type":"default","nullable":true,"primary_key":false},{"name":"user_ip","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"user_device","type":"varchar(50)","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":"form_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"form_content","type":"longtext","nullable":true,"primary_key":false},{"name":"builder_helper_state","type":"longtext","nullable":true,"primary_key":false},{"name":"atomic_class_map","type":"longtext","nullable":true,"primary_key":false},{"name":"generated_script_page_ids","type":"longtext","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_ip","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"views","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"entries","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"user_device","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"1","type":"published","nullable":true,"primary_key":false},{"name":"2","type":"trashed","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"workflow_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"workflow_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"workflow_run","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"workflow_behaviour","type":"varchar(25)","nullable":false,"primary_key":false},{"name":"workflow_condition","type":"longtext","nullable":true,"primary_key":false},{"name":"workflow_info","type":"longtext","nullable":true,"primary_key":false},{"name":"workflow_order","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"workflow_status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"1","type":"enable","nullable":true,"primary_key":false},{"name":"2","type":"enable","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_ip","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"user_location","type":"text","nullable":true,"primary_key":false},{"name":"user_device","type":"varchar(50)","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":"message_title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"message_content","type":"longtext","nullable":true,"primary_key":false},{"name":"message_config","type":"longtext","nullable":true,"primary_key":false},{"name":"form_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_ip","type":"int(11) unsigned","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":"title","type":"text","nullable":true,"primary_key":false},{"name":"sub","type":"text","nullable":true,"primary_key":false},{"name":"body","type":"longtext","nullable":true,"primary_key":false},{"name":"form_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_ip","type":"int(11) unsigned","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":"category","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"integration_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"integration_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"integration_details","type":"longtext","nullable":true,"primary_key":false},{"name":"form_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_ip","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"1","type":"published","nullable":true,"primary_key":false},{"name":"2","type":"trashed","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"form_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_ip","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"user_location","type":"text","nullable":true,"primary_key":false},{"name":"user_device","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"referer","type":"TEXT","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"1","type":"viewed","nullable":true,"primary_key":false},{"name":"2","type":"trashed","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"bitforms_form_entry_id","type":"bigint(20) unsigned","nullable":true,"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":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"log_type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ip","type":"int(11)","nullable":true,"primary_key":false},{"name":"action_type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"form_entry_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"form_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"content","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"log_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"integration_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"api_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"response_type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"response_obj","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"info_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"info_details","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"form_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"entry_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"user_ip","type":"INT(11) UNSIGNED","nullable":true,"primary_key":false},{"name":"status","type":"INT(1) UNSIGNED","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}],"plugin":{"slug":"bit-form","name":"Bit Form – Contact Form, Payment Forms, Multi Step Forms, Calculator & Custom Form Builder","active_installs":10000,"version":"3.1.1","wp_org_url":"https://wordpress.org/plugins/bit-form/"}}