wp_dlm_reports_log
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑ID | bigint(20) | NO |
| user_id | bigint(20) | NO |
| user_ip | varchar(200) | NO |
| uuid | varchar(200) | NO |
| user_agent | varchar(200) | NO |
| download_id | bigint(20) | NO |
| version_id | bigint(20) | NO |
| version | varchar(200) | NO |
| download_date | datetime | YES |
| download_status | varchar(200) | YES |
| download_status_message | varchar(200) | YES |
| download_location | varchar(200) | YES |
| download_category | longtext | YES |
| meta_data | longtext | YES |
| download_ids | longtext | YES |
| revenue | longtext | YES |
| refunds | longtext | YES |
| download_id | bigint(20) | NO |
| download_count | bigint(20) | NO |
| download_versions | varchar(200) | NO |
| hash | longtext | YES |
| creation_date | datetime | YES |
| expiration_date | datetime | YES |
| cookie_id | bigint(20) | YES |
| meta_key | longtext | YES |
| meta_data | longtext | YES |
| user_id | bigint(20) | YES |
| public_key | longtext | YES |
| token | longtext | YES |
| secret_key | longtext | YES |
| create_date | datetime | YES |
CREATE TABLE Statement
CREATE TABLE `' . wp_"download_log` ( ID bigint(20) NOT NULL auto_increment, user_id bigint(20) NOT NULL, user_ip varchar(200) NOT NULL, uuid varchar(200) NOT NULL, user_agent varchar(200) NOT NULL, download_id bigint(20) NOT NULL, version_id bigint(20) NOT NULL, version varchar(200) NOT NULL, download_date datetime DEFAULT NULL, download_status varchar(200) DEFAULT NULL, download_status_message varchar(200) DEFAULT NULL, download_location varchar(200) DEFAULT NULL, download_category longtext DEFAULT NULL, meta_data longtext DEFAULT NULL, PRIMARY KEY (ID), KEY attribute_name (download_id) ) $collate; "; $dlm_reports = "CREATE TABLE `wp_dlm_reports_log` ( date DATE NOT NULL, download_ids longtext NULL, revenue longtext NULL, refunds longtext NULL, PRIMARY KEY (date), KEY attribute_name (date) ) $collate;"; $dlm_downloads = "CREATE TABLE `wp_dlm_downloads` ( ID bigint(20) NOT NULL auto_increment, download_id bigint(20) NOT NULL, download_count bigint(20) NOT NULL, download_versions varchar(200) NOT NULL, PRIMARY KEY (ID), KEY attribute_name (download_id) ) $collate;"; /** * Cookies table */ $dlm_cookie = "CREATE TABLE `wp_dlm_cookies` ( ID bigint(20) NOT NULL auto_increment, hash longtext NULL, creation_date datetime DEFAULT NULL, expiration_date datetime DEFAULT NULL, PRIMARY KEY (ID), KEY attribute_name (ID) ) $collate;"; /** * Cookie meta table */ $dlm_cookie_meta = "CREATE TABLE `wp_dlm_cookiemeta` ( ID bigint(20) NOT NULL auto_increment, cookie_id bigint(20) NULL, meta_key longtext NULL, meta_data longtext NULL, PRIMARY KEY (ID), KEY attribute_name (ID) ) $collate;"; /** * Cookie meta table */ $api_table = "CREATE TABLE `wp_dlm_api_keys` ( ID bigint(20) NOT NULL auto_increment, user_id bigint(20) NULL, public_key longtext NULL, token longtext NULL, secret_key longtext NULL, create_date datetime DEFAULT NULL, PRIMARY KEY (ID), KEY attribute_name (ID) ) $collate;"; dbDelta( $dlm_log );
Safe to delete?
If you have uninstalled Download Monitor, 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_dlm_reports_log`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Download Monitor