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

NameTypeNullStandard | Extra
id 🔑BIGINT(20)NONONE | AUTO_INCREMENT
typeVARCHAR(255)NOnormal
order_idBIGINT(20)YESNULL
product_idBIGINT(20)YESNULL
customer_idBIGINT(20)YESNULL
generator_idBIGINT(20)YESNULL
license_keyLONGTEXTNONONE
hashLONGTEXTNONONE
expires_atDATETIMEYESNULL
sourceVARCHAR(255)NONONE
hostsLONGTEXTYESNULL
statusVARCHAR(255)NONONE
internal_noteLONGTEXTYESNULL
times_activatedINT(10)YESNULL
allowed_activationsINT(10)YESNULL
created_atDATETIMENOCURRENT_TIMESTAMP
created_byBIGINT(20)YESNULL
updated_atDATETIMEYESNULL
updated_byBIGINT(20)YESNULL

elm_license_activations

NameTypeNullStandard | Extra
id 🔑BIGINT(20)NONONE | AUTO_INCREMENT
license_idBIGINT(20)NONONE
typeVARCHAR(255)NOonline
labelVARCHAR(255)YESNULL
sourceVARCHAR(255)NONONE
hostVARCHAR(255)YESNULL
created_atDATETIMENOCURRENT_TIMESTAMP
created_byBIGINT(20)YESNULL
updated_atDATETIMEYESNULL
updated_byBIGINT(20)YESNULL

elm_license_trial_requests (Pro)

NameTypeNullStandard | Extra
id 🔑BIGINT(20)NONONE | AUTO_INCREMENT
product_idBIGINT(20)NONONE
customer_idBIGINT(20)NONONE
hostVARCHAR(255)YESNULL
created_atDATETIMENOCURRENT_TIMESTAMP
created_byBIGINT(20)YESNULL

elm_license_notifications

NameTypeNullStandard | Extra
id 🔑BIGINT(20)NONONE | AUTO_INCREMENT
license_idBIGINT(20)NONONE
typeVARCHAR(255)NONONE
messageLONGTEXTYESNULL
urlVARCHAR(255)YESNULL
reasonVARCHAR(255)NONONE
sourceVARCHAR(255)NONONE
seenTINYINT(1)NO0

elm_generators

NameTypeNullStandard | Extra
id 🔑BIGINT(20)NONONE | AUTO_INCREMENT
nameVARCHAR(255)NONONE
charsetVARCHAR(255)NONONE
chunksINT(10)NONONE
chunk_lengthINT(10)NONONE
allowed_activationsINT(10)YESNULL
block_separatorVARCHAR(255)YESNULL
prefixVARCHAR(255)YESNULL
suffixVARCHAR(255)YESNULL
sourceVARCHAR(255)NONONE
valid_forINT(32)YESNULL
created_atDATETIMENOCURRENT_TIMESTAMP
created_byBIGINT(20)YESNULL
updated_atDATETIMEYESNULL
updated_byBIGINT(20)YESNULL

elm_distributors (Pro)

NameTypeNullStandard | Extra
id 🔑BIGINT(20)NONONE | AUTO_INCREMENT
user_idBIGINT(20)NONONE
labelVARCHAR(255)YESNULL
generator_idBIGINT(20)NONONE
sourceVARCHAR(255)NONONE
statusVARCHAR(255)NONONE
internal_noteLONGTEXTYESNULL
created_atDATETIMENOCURRENT_TIMESTAMP
created_byBIGINT(20)YESNULL
updated_atDATETIMEYESNULL
updated_byBIGINT(20)YESNULL

elm_distributor_codes (Pro)

NameTypeNullStandard | Extra
id 🔑BIGINT(20)NONONE | AUTO_INCREMENT
redeemedTINYINT(1)NO0
codeVARCHAR(255)NONONE
hashLONGTEXTNONONE
distributor_idBIGINT(20)NONONE
product_idBIGINT(20)NONONE
license_idBIGINT(20)YESNULL
sourceVARCHAR(255)NONONE
created_atDATETIMENOCURRENT_TIMESTAMP
created_byBIGINT(20)YESNULL
updated_atDATETIMEYESNULL
updated_byBIGINT(20)YESNULL

elm_releases (Pro)

NameTypeNullStandard | Extra
id 🔑BIGINT(20)NONONE | AUTO_INCREMENT
versionVARCHAR(255)NONONE
release_dateDATETIMENONONE
product_idBIGINT(20)YESNULL
testedVARCHAR(255)YESNULL
requiresVARCHAR(255)YESNULL
requires_phpVARCHAR(255)YESNULL
changelogLONGTEXTYESNULL
upgrade_noticeLONGTEXTYESNULL
sourceVARCHAR(255)NONONE
created_atDATETIMENOCURRENT_TIMESTAMP
created_byBIGINT(20)YESNULL
updated_atDATETIMEYESNULL
updated_byBIGINT(20)YESNULL

elm_rest_api_keys (Pro)

NameTypeNullStandard | Extra
id 🔑BIGINT(20)NONONE | AUTO_INCREMENT
user_idBIGINT(20)NONONE
descriptionVARCHAR(255)NONONE
permissionVARCHAR(10)NONONE
consumer_keyCHAR(64)NONONE
consumer_secretCHAR(43)NONONE
routesLONGTEXTYESNULL
jwtTINYINT(1)NO0
noncesLONGTEXTYESNULL
truncated_keyCHAR(7)NONONE
last_accessDATETIMEYESNULL

elm_products_installed_on (Pro)

NameTypeNullStandard | Extra
id 🔑BIGINT(20)NONONE | AUTO_INCREMENT
product_nameVARCHAR(255)YESNULL
license_idBIGINT(20)YESNULL
hostVARCHAR(255)YESNULL
installed_versionVARCHAR(255)YESNULL
last_pingDATETIMEYESNULL