{"slug":"am-license-manager","name":"KEYMARIATOO – digital product license manager & selling tool","description":"Sell digital product license keys, serials, and activation codes in WooCommerce with automated stock allocation and real-time dashboard.","author":"avtandilimakhatadze","active_installs":0,"version":"5.0.1","wp_org_url":"https://wordpress.org/plugins/am-license-manager/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"am_generator_rules","full_table_name":"wp_am_generator_rules","description":"Stores am generator rules data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"rule_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"variation_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"prefix","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"chunks_number","type":"int(11)","nullable":false,"primary_key":false},{"name":"chunks_length","type":"int(11)","nullable":false,"primary_key":false},{"name":"suffix","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"max_instance_number","type":"int(11)","nullable":true,"primary_key":false},{"name":"valid","type":"int(11)","nullable":true,"primary_key":false},{"name":"active","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_am_generator_rules ( rule_id int(11) NOT NULL AUTO_INCREMENT, product_id int(11) NOT NULL DEFAULT 0, variation_id int(11) NOT NULL DEFAULT 0, prefix varchar(100) DEFAULT NULL, chunks_number int(11) NOT NULL DEFAULT 4, chunks_length int(11) NOT NULL DEFAULT 4, suffix varchar(100) DEFAULT NULL, max_instance_number int(11) DEFAULT 1, valid int(11) DEFAULT 365, active tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (rule_id), UNIQUE KEY product_id (product_id, variation_id) ) ENGINE"},{"table_name":"am_license_key_meta","full_table_name":"wp_am_license_key_meta","description":"Stores additional metadata (key-value pairs) for am license key records.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"license_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"meta_value","type":"text","nullable":true,"primary_key":false},{"name":"admin_only","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_am_license_key_meta ( id int(11) NOT NULL AUTO_INCREMENT, license_id int(11) NOT NULL, meta_key varchar(150) NOT NULL, meta_value text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, admin_only tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY meta_key (license_id, meta_key) ) ENGINE"},{"table_name":"am_license_keys","full_table_name":"wp_am_license_keys","description":"Stores am license keys data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"license_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"variation_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"license_key","type":"text","nullable":true,"primary_key":false},{"name":"image_license_key","type":"text","nullable":true,"primary_key":false},{"name":"license_status","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"owner_first_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"owner_last_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"owner_email_address","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"delivre_x_times","type":"int(11)","nullable":true,"primary_key":false},{"name":"remaining_delivre_x_times","type":"int(11)","nullable":true,"primary_key":false},{"name":"max_instance_number","type":"int(11)","nullable":true,"primary_key":false},{"name":"number_use_remaining","type":"int(11)","nullable":true,"primary_key":false},{"name":"activation_date","type":"date","nullable":true,"primary_key":false},{"name":"creation_date","type":"date","nullable":true,"primary_key":false},{"name":"sold_date","type":"date","nullable":true,"primary_key":false},{"name":"expiration_date","type":"date","nullable":true,"primary_key":false},{"name":"valid","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"device_id","type":"text","nullable":true,"primary_key":false},{"name":"license_key_hash","type":"varchar(64)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_am_license_keys ( license_id int(11) NOT NULL AUTO_INCREMENT, product_id int(11) NOT NULL DEFAULT 0, variation_id int(11) NOT NULL DEFAULT 0, license_key text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, image_license_key text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, license_status varchar(100) DEFAULT 'available', owner_first_name varchar(100) DEFAULT NULL, owner_last_name varchar(100) DEFAULT NULL, owner_email_address varchar(255) DEFAULT NULL, delivre_x_times int(11) DEFAULT 1, remaining_delivre_x_times int(11) DEFAULT 1, max_instance_number int(11) DEFAULT 1, number_use_remaining int(11) DEFAULT 1, activation_date date DEFAULT NULL, creation_date date DEFAULT NULL, sold_date date DEFAULT NULL, expiration_date date DEFAULT NULL, valid int(11) NOT NULL DEFAULT 1, order_id int(11) DEFAULT 0, device_id text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, license_key_hash varchar(64) DEFAULT NULL, PRIMARY KEY (license_id), KEY idx_lkh (license_key_hash) ) ENGINE"},{"table_name":"am_licensed_products","full_table_name":"wp_am_licensed_products","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[{"name":"config_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"variation_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"active","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_am_licensed_products ( config_id int(11) NOT NULL AUTO_INCREMENT, product_id int(11) NOT NULL DEFAULT 0, variation_id int(11) NOT NULL DEFAULT 0, active tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (config_id), UNIQUE KEY product_id (product_id, variation_id) ) ENGINE"}],"table_count":4}