{"table_name":"ksgc_templates","full_table_name":"wp_ksgc_templates","description":"Stores ksgc templates data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_ksgc_templates ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, pdf_file_id bigint(20) unsigned NOT NULL DEFAULT 0, expiry_months int(11) NOT NULL DEFAULT 12, trigger_status varchar(50) NOT NULL DEFAULT 'processing', field_mappings longtext NOT NULL DEFAULT '{}', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY pdf_file_id (pdf_file_id) ) $charset;\"; $sql_associations = \"CREATE TABLE IF NOT EXISTS wp_ksgc_associations ( product_id bigint(20) unsigned NOT NULL, template_id bigint(20) unsigned NOT NULL, PRIMARY KEY (product_id), KEY template_id (template_id) ) $charset;\"; $sql_generated = \"CREATE TABLE IF NOT EXISTS wp_ksgc_generated ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, order_id bigint(20) unsigned NOT NULL, order_item_id bigint(20) unsigned NOT NULL, template_id bigint(20) unsigned NOT NULL, voucher_code varchar(32) NOT NULL, pdf_path varchar(1000) NOT NULL, status varchar(20) NOT NULL DEFAULT 'generated', generated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY order_id (order_id), KEY order_item_id (order_item_id), UNIQUE KEY voucher_code (voucher_code) ) $charset;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql_templates );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"pdf_file_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"expiry_months","type":"int(11)","nullable":false,"primary_key":false},{"name":"trigger_status","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"field_mappings","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},{"name":"template_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"template_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"voucher_code","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"pdf_path","type":"varchar(1000)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"generated_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"kafestudio-pdf-gift-cards","name":"PDF Gift Cards for WooCommerce","active_installs":0,"version":"1.1.1","wp_org_url":"https://wordpress.org/plugins/kafestudio-pdf-gift-cards/"}}