{"slug":"delveant-form-suite","name":"Delveant Form Suite","description":"Complete form management suite with drag-and-drop builder and secure Delveant CRM integration.","author":"Kovaion","active_installs":0,"version":"1.0.6","wp_org_url":"https://wordpress.org/plugins/delveant-form-suite/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"delveant_form_submissions","full_table_name":"wp_delveant_form_submissions","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"form_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"fields","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"meta","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"crm_status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"crm_response","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":true,"primary_key":false},{"name":"user_agent","type":"TEXT","nullable":true,"primary_key":false},{"name":"page_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"referrer","type":"TEXT","nullable":true,"primary_key":false},{"name":"submitted_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_delveant_form_submissions ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, form_id BIGINT(20) UNSIGNED NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'new', fields LONGTEXT NOT NULL, meta LONGTEXT NOT NULL, crm_status VARCHAR(20) NOT NULL DEFAULT 'pending', crm_response LONGTEXT NULL, ip_address VARCHAR(45) NULL, user_agent TEXT NULL, page_url TEXT NULL, referrer TEXT NULL, submitted_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY form_id (form_id), KEY status (status), KEY crm_status (crm_status), KEY submitted_at (submitted_at) ) $charset_collate;\" );"},{"table_name":"delveant_form_suite","full_table_name":"wp_delveant_form_suite","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"form_fields","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"form_settings","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"crm_settings","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"mail_settings","type":"LONGTEXT","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":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_delveant_form_suite ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(255) NOT NULL DEFAULT '', slug VARCHAR(200) NOT NULL DEFAULT '', status VARCHAR(20) NOT NULL DEFAULT 'publish', form_fields LONGTEXT NOT NULL, form_settings LONGTEXT NOT NULL, crm_settings LONGTEXT NOT NULL, mail_settings LONGTEXT NOT NULL, created_by BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status), KEY slug (slug) ) $charset_collate;\" );"},{"table_name":"delveant_rate_limits","full_table_name":"wp_delveant_rate_limits","description":"Stores delveant rate limits data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"identifier","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"hits","type":"INT(11)","nullable":false,"primary_key":false},{"name":"window_start","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_delveant_rate_limits ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, identifier VARCHAR(200) NOT NULL, hits INT(11) NOT NULL DEFAULT 1, window_start DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY identifier (identifier), KEY window_start (window_start) ) $charset_collate;\" );"},{"table_name":"delveant_used_nonces","full_table_name":"wp_delveant_used_nonces","description":"Stores delveant used nonces data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"nonce_hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"form_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"used_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_delveant_used_nonces ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, nonce_hash VARCHAR(64) NOT NULL, form_id BIGINT(20) UNSIGNED NOT NULL, used_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY nonce_hash (nonce_hash), KEY used_at (used_at) ) $charset_collate;\" );"}],"table_count":4}