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	Typ	Null	Standard / Extra
`id` Primärschlüssel	`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	Typ	Null	Standard / Extra
`id` Primärschlüssel	`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	Typ	Null	Standard / Extra
`id` Primärschlüssel	`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	Typ	Null	Standard / Extra
`id` Primärschlüssel	`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	Typ	Null	Standard / Extra
`id` Primärschlüssel	`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	Typ	Null	Standard / Extra
`id` Primärschlüssel	`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	Typ	Null	Standard / Extra
`id` Primärschlüssel	`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	Typ	Null	Standard / Extra
`id` Primärschlüssel	`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	Typ	Null	Standard / Extra
`id` Primärschlüssel	`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	Typ	Null	Standard / Extra
`id` Primärschlüssel	`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`