{"table_name":"ahm_download_stats","full_table_name":"wp_ahm_download_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","create_sql":"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","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"pid","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"uid","type":"int(11)","nullable":false,"primary_key":false},{"name":"oid","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"year","type":"int(4)","nullable":false,"primary_key":false},{"name":"month","type":"int(2)","nullable":false,"primary_key":false},{"name":"day","type":"int(2)","nullable":false,"primary_key":false},{"name":"timestamp","type":"int(11)","nullable":false,"primary_key":false},{"name":"ip","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"filename","type":"text","nullable":true,"primary_key":false},{"name":"agent","type":"text","nullable":true,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"pid","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"date","type":"int(11)","nullable":false,"primary_key":false},{"name":"custom_data","type":"text","nullable":false,"primary_key":false},{"name":"request_status","type":"INT( 1 )","nullable":false,"primary_key":false},{"name":"pid","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"user_data","type":"text","nullable":false,"primary_key":false},{"name":"access_token","type":"text","nullable":false,"primary_key":false},{"name":"refresh_token","type":"text","nullable":false,"primary_key":false},{"name":"source","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"timestamp","type":"int(11)","nullable":false,"primary_key":false},{"name":"processed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"path","type":"text","nullable":false,"primary_key":false},{"name":"owner","type":"int(11)","nullable":false,"primary_key":false},{"name":"activities","type":"text","nullable":false,"primary_key":false},{"name":"comments","type":"text","nullable":false,"primary_key":false},{"name":"access","type":"text","nullable":false,"primary_key":false},{"name":"metadata","type":"text","nullable":false,"primary_key":false},{"name":"asset_ID","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"asset_key","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"access","type":"text","nullable":false,"primary_key":false},{"name":"time","type":"int(11)","nullable":false,"primary_key":false},{"name":"deviceID","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"value","type":"text","nullable":false,"primary_key":false},{"name":"lastAccess","type":"int(11)","nullable":false,"primary_key":false},{"name":"expire","type":"int(11)","nullable":false,"primary_key":false},{"name":"user","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"package_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"download_count","type":"int(11)","nullable":false,"primary_key":false},{"name":"code","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(250)","nullable":false,"primary_key":false},{"name":"data","type":"json","nullable":true,"primary_key":false},{"name":"execute_at","type":"int(11)","nullable":false,"primary_key":false},{"name":"repeat_execution","type":"int(11)","nullable":false,"primary_key":false},{"name":"execution_count","type":"int(11)","nullable":false,"primary_key":false},{"name":"interval","type":"int(11)","nullable":false,"primary_key":false},{"name":"created_at","type":"int(11)","nullable":false,"primary_key":false},{"name":"created_by","type":"int(11)","nullable":false,"primary_key":false}],"plugin":{"slug":"download-manager","name":"Download Manager","active_installs":100000,"version":"3.3.54","wp_org_url":"https://wordpress.org/plugins/download-manager/"}}