{"slug":"download-monitor","name":"Download Monitor","description":"Powerful Download Manager Plugin for WordPress","author":"WP Chill","active_installs":90000,"version":"5.1.13","wp_org_url":"https://wordpress.org/plugins/download-monitor/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"dlm_api_keys","full_table_name":"wp_dlm_api_keys","description":"Stores dlm api keys data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"dlm_cookiemeta","full_table_name":"wp_dlm_cookiemeta","description":"Stores dlm cookiemeta data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"dlm_cookies","full_table_name":"wp_dlm_cookies","description":"Stores dlm cookies data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"dlm_downloads","full_table_name":"wp_dlm_downloads","description":"Stores dlm downloads data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"dlm_order","full_table_name":"wp_dlm_order","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"status","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":false,"primary_key":false},{"name":"date_modified","type":"DATETIME","nullable":true,"primary_key":false},{"name":"currency","type":"VARCHAR(5)","nullable":false,"primary_key":false},{"name":"hash","type":"VARCHAR(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dlm_order` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `status` VARCHAR(255) NOT NULL, `date_created` DATETIME NOT NULL, `date_modified` DATETIME NULL, `currency` VARCHAR(5) NOT NULL, `hash` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"dlm_order_customer","full_table_name":"wp_dlm_order_customer","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"first_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"last_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"company","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"address_1","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"address_2","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"city","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"state","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"postcode","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"country","type":"VARCHAR(5)","nullable":true,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"phone","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"ip_address","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"order_id","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dlm_order_customer` ( `first_name` VARCHAR(255) NULL, `last_name` VARCHAR(255) NULL, `company` VARCHAR(255) NULL, `address_1` VARCHAR(255) NULL, `address_2` VARCHAR(255) NULL, `city` VARCHAR(255) NULL, `state` VARCHAR(255) NULL, `postcode` VARCHAR(255) NULL, `country` VARCHAR(5) NULL, `email` VARCHAR(255) NULL, `phone` VARCHAR(50) NULL, `ip_address` VARCHAR(50) NULL, `order_id` INT UNSIGNED NOT NULL, PRIMARY KEY (`order_id`), CONSTRAINT `wp_fk_order_customer_order` FOREIGN KEY (`order_id`) REFERENCES `wp_dlm_order` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE"},{"table_name":"dlm_order_item","full_table_name":"wp_dlm_order_item","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"order_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"label","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"qty","type":"INT","nullable":true,"primary_key":false},{"name":"product_id","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"tax_class","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"tax_total","type":"INT","nullable":true,"primary_key":false},{"name":"subtotal","type":"INT","nullable":true,"primary_key":false},{"name":"total","type":"INT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dlm_order_item` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `order_id` INT UNSIGNED NOT NULL, `label` VARCHAR(255) NULL, `qty` INT NULL, `product_id` INT UNSIGNED NULL, `tax_class` VARCHAR(255) NULL, `tax_total` INT NULL, `subtotal` INT NULL, `total` INT NULL, PRIMARY KEY (`id`), CONSTRAINT `wp_fk_order_item_order1` FOREIGN KEY (`order_id`) REFERENCES `wp_dlm_order` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE"},{"table_name":"dlm_order_transaction","full_table_name":"wp_dlm_order_transaction","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"date_created","type":"DATETIME","nullable":true,"primary_key":false},{"name":"date_modified","type":"DATETIME","nullable":true,"primary_key":false},{"name":"amount","type":"INT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"processor","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"processor_nice_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"processor_transaction_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"processor_status","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"order_id","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dlm_order_transaction` ( `id` INT NOT NULL AUTO_INCREMENT, `date_created` DATETIME NULL, `date_modified` DATETIME NULL, `amount` INT NULL, `status` VARCHAR(50) NULL, `processor` VARCHAR(255) NULL, `processor_nice_name` VARCHAR(255) NULL, `processor_transaction_id` VARCHAR(255) NULL, `processor_status` VARCHAR(255) NULL, `order_id` INT UNSIGNED NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `wp_fk_transaction_order1` FOREIGN KEY (`order_id`) REFERENCES `wp_dlm_order` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE"},{"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","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}],"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 );"},{"table_name":"dlm_session","full_table_name":"wp_dlm_session","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[{"name":"key","type":"VARCHAR(150)","nullable":false,"primary_key":false},{"name":"hash","type":"VARCHAR(150)","nullable":false,"primary_key":false},{"name":"expiry","type":"DATETIME","nullable":false,"primary_key":false},{"name":"data","type":"LONGTEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dlm_session` ( `key` VARCHAR(150) NOT NULL, `hash` VARCHAR(150) NOT NULL, `expiry` DATETIME NOT NULL, `data` LONGTEXT NOT NULL, PRIMARY KEY (`key`) ) ENGINE"},{"table_name":"download_log","full_table_name":"wp_download_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"download_monitor_file_meta","full_table_name":"wp_download_monitor_file_meta","description":"Stores additional metadata (key-value pairs) for download monitor file records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"download_monitor_files","full_table_name":"wp_download_monitor_files","description":"Stores download monitor files data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"download_monitor_formats","full_table_name":"wp_download_monitor_formats","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"download_monitor_log","full_table_name":"wp_download_monitor_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"download_monitor_relationships","full_table_name":"wp_download_monitor_relationships","description":"Stores download monitor relationships data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"download_monitor_stats","full_table_name":"wp_download_monitor_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"download_monitor_taxonomies","full_table_name":"wp_download_monitor_taxonomies","description":"Stores download monitor taxonomies data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":18}