{"table_name":"dlm_reports_log","full_table_name":"wp_dlm_reports_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"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 );","columns":[{"name":"ID","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"user_ip","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"uuid","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"user_agent","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"download_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"version_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"version","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"download_date","type":"datetime","nullable":true,"primary_key":false},{"name":"download_status","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"download_status_message","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"download_location","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"download_category","type":"longtext","nullable":true,"primary_key":false},{"name":"meta_data","type":"longtext","nullable":true,"primary_key":false},{"name":"download_ids","type":"longtext","nullable":true,"primary_key":false},{"name":"revenue","type":"longtext","nullable":true,"primary_key":false},{"name":"refunds","type":"longtext","nullable":true,"primary_key":false},{"name":"download_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"download_count","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"download_versions","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"hash","type":"longtext","nullable":true,"primary_key":false},{"name":"creation_date","type":"datetime","nullable":true,"primary_key":false},{"name":"expiration_date","type":"datetime","nullable":true,"primary_key":false},{"name":"cookie_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"meta_key","type":"longtext","nullable":true,"primary_key":false},{"name":"meta_data","type":"longtext","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"public_key","type":"longtext","nullable":true,"primary_key":false},{"name":"token","type":"longtext","nullable":true,"primary_key":false},{"name":"secret_key","type":"longtext","nullable":true,"primary_key":false},{"name":"create_date","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"download-monitor","name":"Download Monitor","active_installs":90000,"version":"5.1.13","wp_org_url":"https://wordpress.org/plugins/download-monitor/"}}