wp_am_license_keys
StaticStores am license keys data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑license_id | int(11) | NO |
| product_id | int(11) | NO |
| variation_id | int(11) | NO |
| license_key | text | YES |
| image_license_key | text | YES |
| license_status | varchar(100) | YES |
| owner_first_name | varchar(100) | YES |
| owner_last_name | varchar(100) | YES |
| owner_email_address | varchar(255) | YES |
| delivre_x_times | int(11) | YES |
| remaining_delivre_x_times | int(11) | YES |
| max_instance_number | int(11) | YES |
| number_use_remaining | int(11) | YES |
| activation_date | date | YES |
| creation_date | date | YES |
| sold_date | date | YES |
| expiration_date | date | YES |
| valid | int(11) | NO |
| order_id | int(11) | YES |
| device_id | text | YES |
| license_key_hash | varchar(64) | YES |
CREATE TABLE Statement
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
Safe to delete?
If you have uninstalled KEYMARIATOO – digital product license manager & selling tool, 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_am_license_keys`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from KEYMARIATOO – digital product license manager & selling tool