Datenbankstruktur

Inhaltstabelle

elm_licenses
elm_license_activations
elm_license_trial_requests (Pro)
elm_license_notifications
elm_generators
elm_distributors (Pro)
elm_distributor_codes (Pro)
elm_releases (Pro)
elm_rest_api_keys (Pro)
elm_products_installed_on (Pro)

Folgend findest du eine Übersicht aller Datenbanktabellen von Enwikuna License Manager & Enwikuna License Manager Pro. Diese Datenbanktabellen werden bei der Installation der jeweiligen Plugins in deiner WordPress Datenbank angelegt.

elm_licenses

Name	Type	Null	Standard \| Extra
id 🔑	`BIGINT(20)`	`NO`	`NONE \| AUTO_INCREMENT`
type	`VARCHAR(255)`	`NO`	`normal`
order_id	`BIGINT(20)`	`YES`	`NULL`
product_id	`BIGINT(20)`	`YES`	`NULL`
customer_id	`BIGINT(20)`	`YES`	`NULL`
generator_id	`BIGINT(20)`	`YES`	`NULL`
license_key	`LONGTEXT`	`NO`	`NONE`
hash	`LONGTEXT`	`NO`	`NONE`
expires_at	`DATETIME`	`YES`	`NULL`
source	`VARCHAR(255)`	`NO`	`NONE`
hosts	`LONGTEXT`	`YES`	`NULL`
status	`VARCHAR(255)`	`NO`	`NONE`
internal_note	`LONGTEXT`	`YES`	`NULL`
times_activated	`INT(10)`	`YES`	`NULL`
allowed_activations	`INT(10)`	`YES`	`NULL`
created_at	`DATETIME`	`NO`	`CURRENT_TIMESTAMP`
created_by	`BIGINT(20)`	`YES`	`NULL`
updated_at	`DATETIME`	`YES`	`NULL`
updated_by	`BIGINT(20)`	`YES`	`NULL`

elm_license_activations

Name	Type	Null	Standard \| Extra
id 🔑	`BIGINT(20)`	`NO`	`NONE \| AUTO_INCREMENT`
license_id	`BIGINT(20)`	`NO`	`NONE`
type	`VARCHAR(255)`	`NO`	`online`
label	`VARCHAR(255)`	`YES`	`NULL`
source	`VARCHAR(255)`	`NO`	`NONE`
host	`VARCHAR(255)`	`YES`	`NULL`
created_at	`DATETIME`	`NO`	`CURRENT_TIMESTAMP`
created_by	`BIGINT(20)`	`YES`	`NULL`
updated_at	`DATETIME`	`YES`	`NULL`
updated_by	`BIGINT(20)`	`YES`	`NULL`

elm_license_trial_requests (Pro)

Name	Type	Null	Standard \| Extra
id 🔑	`BIGINT(20)`	`NO`	`NONE \| AUTO_INCREMENT`
product_id	`BIGINT(20)`	`NO`	`NONE`
customer_id	`BIGINT(20)`	`NO`	`NONE`
host	`VARCHAR(255)`	`YES`	`NULL`
created_at	`DATETIME`	`NO`	`CURRENT_TIMESTAMP`
created_by	`BIGINT(20)`	`YES`	`NULL`

elm_license_notifications

Name	Type	Null	Standard \| Extra
id 🔑	`BIGINT(20)`	`NO`	`NONE \| AUTO_INCREMENT`
license_id	`BIGINT(20)`	`NO`	`NONE`
type	`VARCHAR(255)`	`NO`	`NONE`
message	`LONGTEXT`	`YES`	`NULL`
url	`VARCHAR(255)`	`YES`	`NULL`
reason	`VARCHAR(255)`	`NO`	`NONE`
source	`VARCHAR(255)`	`NO`	`NONE`
seen	`TINYINT(1)`	`NO`	`0`

elm_generators

Name	Type	Null	Standard \| Extra
id 🔑	`BIGINT(20)`	`NO`	`NONE \| AUTO_INCREMENT`
name	`VARCHAR(255)`	`NO`	`NONE`
charset	`VARCHAR(255)`	`NO`	`NONE`
chunks	`INT(10)`	`NO`	`NONE`
chunk_length	`INT(10)`	`NO`	`NONE`
allowed_activations	`INT(10)`	`YES`	`NULL`
block_separator	`VARCHAR(255)`	`YES`	`NULL`
prefix	`VARCHAR(255)`	`YES`	`NULL`
suffix	`VARCHAR(255)`	`YES`	`NULL`
source	`VARCHAR(255)`	`NO`	`NONE`
valid_for	`INT(32)`	`YES`	`NULL`
created_at	`DATETIME`	`NO`	`CURRENT_TIMESTAMP`
created_by	`BIGINT(20)`	`YES`	`NULL`
updated_at	`DATETIME`	`YES`	`NULL`
updated_by	`BIGINT(20)`	`YES`	`NULL`

elm_distributors (Pro)

Name	Type	Null	Standard \| Extra
id 🔑	`BIGINT(20)`	`NO`	`NONE \| AUTO_INCREMENT`
user_id	`BIGINT(20)`	`NO`	`NONE`
label	`VARCHAR(255)`	`YES`	`NULL`
generator_id	`BIGINT(20)`	`NO`	`NONE`
source	`VARCHAR(255)`	`NO`	`NONE`
status	`VARCHAR(255)`	`NO`	`NONE`
internal_note	`LONGTEXT`	`YES`	`NULL`
created_at	`DATETIME`	`NO`	`CURRENT_TIMESTAMP`
created_by	`BIGINT(20)`	`YES`	`NULL`
updated_at	`DATETIME`	`YES`	`NULL`
updated_by	`BIGINT(20)`	`YES`	`NULL`

elm_distributor_codes (Pro)

Name	Type	Null	Standard \| Extra
id 🔑	`BIGINT(20)`	`NO`	`NONE \| AUTO_INCREMENT`
redeemed	`TINYINT(1)`	`NO`	`0`
code	`VARCHAR(255)`	`NO`	`NONE`
hash	`LONGTEXT`	`NO`	`NONE`
distributor_id	`BIGINT(20)`	`NO`	`NONE`
product_id	`BIGINT(20)`	`NO`	`NONE`
license_id	`BIGINT(20)`	`YES`	`NULL`
source	`VARCHAR(255)`	`NO`	`NONE`
created_at	`DATETIME`	`NO`	`CURRENT_TIMESTAMP`
created_by	`BIGINT(20)`	`YES`	`NULL`
updated_at	`DATETIME`	`YES`	`NULL`
updated_by	`BIGINT(20)`	`YES`	`NULL`

elm_releases (Pro)

Name	Type	Null	Standard \| Extra
id 🔑	`BIGINT(20)`	`NO`	`NONE \| AUTO_INCREMENT`
version	`VARCHAR(255)`	`NO`	`NONE`
release_date	`DATETIME`	`NO`	`NONE`
product_id	`BIGINT(20)`	`YES`	`NULL`
tested	`VARCHAR(255)`	`YES`	`NULL`
requires	`VARCHAR(255)`	`YES`	`NULL`
requires_php	`VARCHAR(255)`	`YES`	`NULL`
changelog	`LONGTEXT`	`YES`	`NULL`
upgrade_notice	`LONGTEXT`	`YES`	`NULL`
source	`VARCHAR(255)`	`NO`	`NONE`
created_at	`DATETIME`	`NO`	`CURRENT_TIMESTAMP`
created_by	`BIGINT(20)`	`YES`	`NULL`
updated_at	`DATETIME`	`YES`	`NULL`
updated_by	`BIGINT(20)`	`YES`	`NULL`

elm_rest_api_keys (Pro)

Name	Type	Null	Standard \| Extra
id 🔑	`BIGINT(20)`	`NO`	`NONE \| AUTO_INCREMENT`
user_id	`BIGINT(20)`	`NO`	`NONE`
description	`VARCHAR(255)`	`NO`	`NONE`
permission	`VARCHAR(10)`	`NO`	`NONE`
consumer_key	`CHAR(64)`	`NO`	`NONE`
consumer_secret	`CHAR(43)`	`NO`	`NONE`
routes	`LONGTEXT`	`YES`	`NULL`
jwt	`TINYINT(1)`	`NO`	`0`
nonces	`LONGTEXT`	`YES`	`NULL`
truncated_key	`CHAR(7)`	`NO`	`NONE`
last_access	`DATETIME`	`YES`	`NULL`

elm_products_installed_on (Pro)

Name	Type	Null	Standard \| Extra
id 🔑	`BIGINT(20)`	`NO`	`NONE \| AUTO_INCREMENT`
product_name	`VARCHAR(255)`	`YES`	`NULL`
license_id	`BIGINT(20)`	`YES`	`NULL`
host	`VARCHAR(255)`	`YES`	`NULL`
installed_version	`VARCHAR(255)`	`YES`	`NULL`
last_ping	`DATETIME`	`YES`	`NULL`

Updated on 10.06.2024