{"slug":"wprobo-documerge-lite","name":"WPRobo DocuMerge Lite","description":"Free document automation for WordPress. Upload DOCX templates, collect data via forms, and deliver personalised PDF or DOCX documents automatically.","author":"WPRobo Limited","active_installs":0,"version":"1.0.2","wp_org_url":"https://wordpress.org/plugins/wprobo-documerge-lite/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"wprdm_forms","full_table_name":"wp_wprdm_forms","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(200)","nullable":false,"primary_key":false},{"name":"template_id","type":"bigint(20)   UNSIGNED","nullable":false,"primary_key":false},{"name":"mode","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"integration","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"fields","type":"longtext","nullable":false,"primary_key":false},{"name":"settings","type":"longtext","nullable":false,"primary_key":false},{"name":"output_format","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"delivery_methods","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"submit_label","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"success_message","type":"text","nullable":false,"primary_key":false},{"name":"redirect_url","type":"varchar(500)","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_wprdm_forms ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, title varchar(200) NOT NULL DEFAULT '', template_id bigint(20) UNSIGNED NOT NULL DEFAULT 0, mode varchar(20) NOT NULL DEFAULT 'standalone', integration varchar(50) NOT NULL DEFAULT '', fields longtext NOT NULL, settings longtext NOT NULL, output_format varchar(10) NOT NULL DEFAULT 'pdf', delivery_methods varchar(200) NOT NULL DEFAULT 'download', submit_label varchar(200) NOT NULL DEFAULT 'Submit', success_message text NOT NULL, redirect_url varchar(500) NOT NULL DEFAULT '', created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', updated_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY template_id (template_id) ) {$charset_collate};\"; dbDelta( $sql );"},{"table_name":"wprdm_submissions","full_table_name":"wp_wprdm_submissions","description":"Stores form submissions and user-entered data.","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":"template_id","type":"bigint(20)   UNSIGNED","nullable":false,"primary_key":false},{"name":"submitter_email","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"form_data","type":"longtext","nullable":false,"primary_key":false},{"name":"doc_path_docx","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"doc_path_pdf","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"error_log","type":"text","nullable":false,"primary_key":false},{"name":"retry_count","type":"tinyint(3)","nullable":false,"primary_key":false},{"name":"delivery_status","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"admin_notes","type":"text","nullable":false,"primary_key":false},{"name":"ip_address","type":"varchar(45)","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_wprdm_submissions ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, form_id bigint(20) UNSIGNED NOT NULL DEFAULT 0, template_id bigint(20) UNSIGNED NOT NULL DEFAULT 0, submitter_email varchar(200) NOT NULL DEFAULT '', form_data longtext NOT NULL, doc_path_docx varchar(500) NOT NULL DEFAULT '', doc_path_pdf varchar(500) NOT NULL DEFAULT '', status varchar(30) NOT NULL DEFAULT 'processing', error_log text NOT NULL, retry_count tinyint(3) NOT NULL DEFAULT 0, delivery_status varchar(30) NOT NULL DEFAULT 'pending', admin_notes text NOT NULL, ip_address varchar(45) NOT NULL DEFAULT '', created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', updated_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY form_id (form_id), KEY status (status), KEY created_at (created_at) ) {$charset_collate};\"; dbDelta( $sql );"},{"table_name":"wprdm_templates","full_table_name":"wp_wprdm_templates","description":"Stores wprdm templates data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)   UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":false,"primary_key":false},{"name":"file_path","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"file_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"output_format","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"merge_tags","type":"longtext","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_wprdm_templates ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, name varchar(200) NOT NULL DEFAULT '', description text NOT NULL, file_path varchar(500) NOT NULL DEFAULT '', file_name varchar(255) NOT NULL DEFAULT '', output_format varchar(10) NOT NULL DEFAULT 'pdf', merge_tags longtext NOT NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', updated_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id) ) {$charset_collate};\"; dbDelta( $sql );"}],"table_count":3}