wp_ahm_download_stats
StaticStores analytics or statistics data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | NO |
| pid | bigint(20) | NO |
| uid | int(11) | NO |
| oid | varchar(100) | NO |
| year | int(4) | NO |
| month | int(2) | NO |
| day | int(2) | NO |
| timestamp | int(11) | NO |
| ip | varchar(255) | NO |
| filename | text | YES |
| agent | text | YES |
| varchar(255) | NO | |
| pid | bigint(20) | NO |
| date | int(11) | NO |
| custom_data | text | NO |
| request_status | INT( 1 ) | NO |
| pid | bigint(20) | NO |
| varchar(200) | NO | |
| name | varchar(200) | NO |
| user_data | text | NO |
| access_token | text | NO |
| refresh_token | text | NO |
| source | varchar(200) | NO |
| timestamp | int(11) | NO |
| processed | tinyint(1) | NO |
| path | text | NO |
| owner | int(11) | NO |
| activities | text | NO |
| comments | text | NO |
| access | text | NO |
| metadata | text | NO |
| asset_ID | bigint(20) | NO |
| asset_key | varchar(255) | NO |
| access | text | NO |
| time | int(11) | NO |
| deviceID | varchar(255) | NO |
| name | varchar(255) | NO |
| value | text | NO |
| lastAccess | int(11) | NO |
| expire | int(11) | NO |
| user | varchar(255) | NO |
| package_id | int(11) | NO |
| download_count | int(11) | NO |
| code | varchar(255) | NO |
| type | varchar(250) | NO |
| data | json | YES |
| execute_at | int(11) | NO |
| repeat_execution | int(11) | NO |
| execution_count | int(11) | NO |
| interval | int(11) | NO |
| created_at | int(11) | NO |
| created_by | int(11) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_ahm_download_stats` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `pid` bigint(20) NOT NULL, `uid` int(11) NOT NULL, `oid` varchar(100) NOT NULL, `year` int(4) NOT NULL, `month` int(2) NOT NULL, `day` int(2) NOT NULL, `timestamp` int(11) NOT NULL, `ip` varchar(255) NOT NULL, `filename` text, `agent` text, PRIMARY KEY (`id`) )"; $sqls[] = "CREATE TABLE IF NOT EXISTS `wp_ahm_emails` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `email` varchar(255) NOT NULL, `pid` bigint(20) NOT NULL, `date` int(11) NOT NULL, `custom_data` text NOT NULL, `request_status` INT( 1 ) NOT NULL, PRIMARY KEY (`id`) )"; $sqls[] = "CREATE TABLE IF NOT EXISTS `wp_ahm_social_conns` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `pid` bigint(20) NOT NULL, `email` varchar(200) NOT NULL, `name` varchar(200) NOT NULL, `user_data` text NOT NULL, `access_token` text NOT NULL, `refresh_token` text NOT NULL, `source` varchar(200) NOT NULL, `timestamp` int(11) NOT NULL, `processed` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) )"; $sqls[] = "CREATE TABLE IF NOT EXISTS `wp_ahm_assets` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `path` text NOT NULL, `owner` int(11) NOT NULL, `activities` text NOT NULL, `comments` text NOT NULL, `access` text NOT NULL, `metadata` text NOT NULL, PRIMARY KEY (`ID`) )"; $sqls[] = "CREATE TABLE IF NOT EXISTS `wp_ahm_asset_links` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `asset_ID` bigint(20) NOT NULL, `asset_key` varchar(255) NOT NULL, `access` text NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`ID`) )"; $sqls[] = "DROP TABLE IF EXISTS `wp_ahm_sessions`"; $sqls[] = "CREATE TABLE IF NOT EXISTS `wp_ahm_sessions` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `deviceID` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `value` text NOT NULL, `lastAccess` int(11) NOT NULL, `expire` int(11) NOT NULL, PRIMARY KEY (`ID`) )"; $sqls[] = "CREATE TABLE IF NOT EXISTS `wp_ahm_user_download_counts` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `user` varchar(255) NOT NULL, `package_id` int(11) NOT NULL, `download_count` int(11) NOT NULL, PRIMARY KEY (`ID`) )"; $sqls[] = "CREATE TABLE IF NOT EXISTS `wp_ahm_cron_jobs` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `code` varchar(255) NOT NULL, `type` varchar(250) NOT NULL, `data` json DEFAULT NULL, `execute_at` int(11) NOT NULL, `repeat_execution` int(11) NOT NULL DEFAULT '0', `execution_count` int(11) NOT NULL DEFAULT '0', `interval` int(11) NOT NULL DEFAULT '0', `created_at` int(11) NOT NULL DEFAULT '0', `created_by` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), UNIQUE KEY `code` (`code`) ) ENGINE
Safe to delete?
If you have uninstalled Download Manager, 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_ahm_download_stats`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Download Manager