{"table_name":"jblm_licenses","full_table_name":"wp_jblm_licenses","description":"Stores jblm licenses data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_jblm_licenses ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, license_key varchar(255) NOT NULL, license_key_encrypted text NOT NULL, order_id bigint(20) unsigned DEFAULT NULL, product_id bigint(20) unsigned DEFAULT NULL, user_id bigint(20) unsigned DEFAULT NULL, customer_email varchar(255) NOT NULL DEFAULT '', status varchar(20) NOT NULL DEFAULT 'inactive', max_domains int(5) NOT NULL DEFAULT 1, expires_at datetime DEFAULT NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', meta longtext DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY license_key (license_key), KEY order_id (order_id), KEY user_id (user_id), KEY status (status) ) $charset;\"; // ── Table 2: activations ───────────────────────────────── $sql_activations = \"CREATE TABLE wp_jblm_activations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, license_id bigint(20) unsigned NOT NULL, domain varchar(255) NOT NULL DEFAULT '', domain_hash varchar(64) NOT NULL DEFAULT '', ip_address varchar(45) DEFAULT NULL, activated_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', last_validated datetime DEFAULT NULL, is_active tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (id), UNIQUE KEY license_domain (license_id,domain_hash), KEY license_id (license_id) ) $charset;\"; // ── Table 3: logs ──────────────────────────────────────── $sql_logs = \"CREATE TABLE wp_jblm_logs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, license_id bigint(20) unsigned DEFAULT NULL, action varchar(100) NOT NULL DEFAULT '', domain varchar(255) DEFAULT NULL, ip_address varchar(45) DEFAULT NULL, status varchar(50) DEFAULT NULL, message text DEFAULT NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY license_id (license_id), KEY created_at (created_at) ) $charset;\"; dbDelta( $sql_licenses );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"license_key","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"license_key_encrypted","type":"text","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"product_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"customer_email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"max_domains","type":"int(5)","nullable":false,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"meta","type":"longtext","nullable":true,"primary_key":false},{"name":"license_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"domain","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"domain_hash","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"activated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"last_validated","type":"datetime","nullable":true,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"license_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"action","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"domain","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"message","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"jb-license-manager","name":"JB License Manager for WooCommerce","active_installs":0,"version":"2.0.1","wp_org_url":"https://wordpress.org/plugins/jb-license-manager/"}}