{"table_name":"shedform_submission_files","full_table_name":"wp_shedform_submission_files","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE {$table_forms} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, title varchar(200) NOT NULL, status tinyint(1) NOT NULL DEFAULT 1, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) {$charset_collate};\"; // shedform_form_rows $table_rows = wp_'shedform_form_rows'; $sql_rows = \"CREATE TABLE {$table_rows} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, form_id bigint(20) unsigned NOT NULL, row_label varchar(200) DEFAULT NULL, columns varchar(20) NOT NULL DEFAULT 'full', sort_order int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY idx_form_id (form_id) ) {$charset_collate};\"; // shedform_form_fields $table_fields = wp_'shedform_form_fields'; $sql_fields = \"CREATE TABLE {$table_fields} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, form_id bigint(20) unsigned NOT NULL, row_id bigint(20) unsigned DEFAULT NULL, col_index tinyint(1) NOT NULL DEFAULT 0, field_key varchar(100) NOT NULL, field_type varchar(50) NOT NULL, label varchar(200) NOT NULL, placeholder varchar(200) DEFAULT NULL, required tinyint(1) NOT NULL DEFAULT 0, options longtext DEFAULT NULL, validation longtext DEFAULT NULL, extras longtext DEFAULT NULL, sort_order int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY idx_form_id (form_id), KEY idx_row_id (row_id), KEY idx_sort_order (sort_order) ) {$charset_collate};\"; // shedform_form_settings $table_settings = wp_'shedform_form_settings'; $sql_settings = \"CREATE TABLE {$table_settings} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, form_id bigint(20) unsigned NOT NULL, setting_key varchar(100) NOT NULL, setting_value longtext DEFAULT NULL, PRIMARY KEY (id), KEY idx_form_id (form_id), UNIQUE KEY idx_form_setting (form_id, setting_key) ) {$charset_collate};\"; // shedform_submissions $table_submissions = wp_'shedform_submissions'; $sql_submissions = \"CREATE TABLE {$table_submissions} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, form_id bigint(20) unsigned NOT NULL, serial_number varchar(100) DEFAULT NULL, status tinyint(2) NOT NULL DEFAULT 0, ip_address varchar(45) DEFAULT NULL, user_agent varchar(500) DEFAULT NULL, spam_score tinyint(3) unsigned NOT NULL DEFAULT 0, spam_reasons text DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_form_id (form_id), KEY idx_status (status), KEY idx_created_at (created_at) ) {$charset_collate};\"; // shedform_submission_fields $table_sub_fields = wp_'shedform_submission_fields'; $sql_sub_fields = \"CREATE TABLE {$table_sub_fields} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, submission_id bigint(20) unsigned NOT NULL, field_key varchar(100) NOT NULL, field_label varchar(200) NOT NULL, field_value longtext DEFAULT NULL, field_type varchar(50) NOT NULL DEFAULT 'text', PRIMARY KEY (id), KEY idx_submission_id (submission_id) ) {$charset_collate};\"; // shedform_submission_memos $table_sub_memos = wp_'shedform_submission_memos'; $sql_sub_memos = \"CREATE TABLE {$table_sub_memos} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, submission_id bigint(20) unsigned NOT NULL, memo text NOT NULL, created_by bigint(20) unsigned NOT NULL DEFAULT 0, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_submission_id (submission_id) ) {$charset_collate};\"; // shedform_mail_logs $table_mail_logs = wp_'shedform_mail_logs'; $sql_mail_logs = \"CREATE TABLE {$table_mail_logs} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, submission_id bigint(20) unsigned DEFAULT NULL, mail_type varchar(50) NOT NULL, to_email varchar(200) NOT NULL, cc_email text DEFAULT NULL, bcc_email text DEFAULT NULL, subject varchar(500) NOT NULL, body longtext NOT NULL, status varchar(20) NOT NULL DEFAULT 'sent', error_message text DEFAULT NULL, sent_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_submission_id (submission_id), KEY idx_mail_type (mail_type), KEY idx_status (status), KEY idx_sent_at (sent_at) ) {$charset_collate};\"; $sql_sub_files = \"CREATE TABLE wp_shedform_submission_files ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, submission_id bigint(20) unsigned NOT NULL, field_key varchar(100) NOT NULL, original_name varchar(255) NOT NULL, file_path varchar(500) NOT NULL, file_size int(10) unsigned NOT NULL DEFAULT 0, mime_type varchar(100) NOT NULL DEFAULT '', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_submission_id (submission_id) ) {$charset_collate};\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql_forms );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"title","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"form_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"row_label","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"columns","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"form_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"row_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"col_index","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"field_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"field_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"label","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"placeholder","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"required","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"options","type":"longtext","nullable":true,"primary_key":false},{"name":"validation","type":"longtext","nullable":true,"primary_key":false},{"name":"extras","type":"longtext","nullable":true,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"form_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"setting_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"setting_value","type":"longtext","nullable":true,"primary_key":false},{"name":"form_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"serial_number","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(2)","nullable":false,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"user_agent","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"spam_score","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"spam_reasons","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"submission_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"field_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"field_label","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"field_value","type":"longtext","nullable":true,"primary_key":false},{"name":"field_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"submission_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"memo","type":"text","nullable":false,"primary_key":false},{"name":"created_by","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"submission_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"mail_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"to_email","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"cc_email","type":"text","nullable":true,"primary_key":false},{"name":"bcc_email","type":"text","nullable":true,"primary_key":false},{"name":"subject","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"body","type":"longtext","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"error_message","type":"text","nullable":true,"primary_key":false},{"name":"sent_at","type":"datetime","nullable":false,"primary_key":false},{"name":"submission_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"field_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"original_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"file_path","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"file_size","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"mime_type","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"shed-form","name":"Shed Form","active_installs":0,"version":"1.6.23","wp_org_url":"https://wordpress.org/plugins/shed-form/"}}