wp_jblm_licenses
StaticStores jblm licenses data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| license_key | varchar(255) | NO |
| license_key_encrypted | text | NO |
| order_id | bigint(20) unsigned | YES |
| product_id | bigint(20) unsigned | YES |
| user_id | bigint(20) unsigned | YES |
| customer_email | varchar(255) | NO |
| status | varchar(20) | NO |
| max_domains | int(5) | NO |
| expires_at | datetime | YES |
| created_at | datetime | NO |
| meta | longtext | YES |
| license_id | bigint(20) unsigned | NO |
| domain | varchar(255) | NO |
| domain_hash | varchar(64) | NO |
| ip_address | varchar(45) | YES |
| activated_at | datetime | NO |
| last_validated | datetime | YES |
| is_active | tinyint(1) | NO |
| license_id | bigint(20) unsigned | YES |
| action | varchar(100) | NO |
| domain | varchar(255) | YES |
| ip_address | varchar(45) | YES |
| status | varchar(50) | YES |
| message | text | YES |
| created_at | datetime | NO |
CREATE TABLE Statement
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 );
Safe to delete?
If you have uninstalled JB License Manager for WooCommerce, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_jblm_licenses`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from JB License Manager for WooCommerce