Datenbankstruktur

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_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