{"slug":"kafestudio-pdf-gift-cards","name":"PDF Gift Cards for WooCommerce","description":"Automatically generate personalized PDF gift cards for WooCommerce orders with a Drag & Drop template editor. No design skills needed.","author":"kafestudio","active_installs":0,"version":"1.1.1","wp_org_url":"https://wordpress.org/plugins/kafestudio-pdf-gift-cards/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ksgc_associations","full_table_name":"wp_ksgc_associations","description":"Stores ksgc associations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ksgc_generated","full_table_name":"wp_ksgc_generated","description":"Stores ksgc generated data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ksgc_templates","full_table_name":"wp_ksgc_templates","description":"Stores ksgc 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(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}],"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 );"}],"table_count":3}