{"slug":"gerador-de-certificados-devapps","name":"Gerador de Certificados – DevApps","description":"Plugin que permite emitir certificados para suas palestras ou cursos livres de forma prática","author":"DevApps® Consultoria e Desenvolvimento","active_installs":80,"version":"1.3.6","wp_org_url":"https://wordpress.org/plugins/gerador-de-certificados-devapps/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"devapps_certificate_models","full_table_name":"wp_devapps_certificate_models","description":"Stores devapps certificate models data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"code","type":"CHAR(36)","nullable":false,"primary_key":false},{"name":"path","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"url","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_devapps_certificate_models` ( `id` INT NOT NULL AUTO_INCREMENT, `code` CHAR(36) NOT NULL DEFAULT (uuid()), `path` VARCHAR(255) NOT NULL, `url` VARCHAR(255) NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `code_UNIQUE` (`code` ASC) VISIBLE) ENGINE"},{"table_name":"devapps_certificates","full_table_name":"wp_devapps_certificates","description":"Stores devapps certificates data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"Id","type":"INT","nullable":false,"primary_key":true},{"name":"code","type":"CHAR(36)","nullable":false,"primary_key":false},{"name":"person","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"document","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"certificate","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_devapps_certificates` ( `Id` INT NOT NULL AUTO_INCREMENT, `code` CHAR(36) NOT NULL DEFAULT (uuid()), `person` VARCHAR(255) NOT NULL, `document` VARCHAR(45) NOT NULL, `email` VARCHAR(255) NOT NULL, `certificate` VARCHAR(255) NOT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`Id`), UNIQUE INDEX `code_UNIQUE` (`code` ASC) VISIBLE) ENGINE"}],"table_count":2}