{"table_name":"dreamcore_monitor_useragents","full_table_name":"wp_dreamcore_monitor_useragents","description":"Stores dreamcore monitor useragents data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_dreamcore_monitor_useragents ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, user_agent VARCHAR(500) NOT NULL, ip_address VARCHAR(45) NOT NULL, page_url VARCHAR(500) NOT NULL, referer VARCHAR(500) NULL, category VARCHAR(50) NOT NULL, browser VARCHAR(100) NULL, os VARCHAR(100) NULL, device_type VARCHAR(50) NULL, visited_at DATETIME DEFAULT CURRENT_TIMESTAMP, INDEX idx_category (category), INDEX idx_visited_at (visited_at), INDEX idx_ip_address (ip_address), INDEX idx_browser (browser), INDEX idx_device_type (device_type) ) {$charset_collate}\"; // Safe loading of upgrade.php with proper path handling $upgrade_file = wp_normalize_path( ABSPATH . 'wp-admin/includes/upgrade.php' );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":true},{"name":"user_agent","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"page_url","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"referer","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"category","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"browser","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"os","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"device_type","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"visited_at","type":"DATETIME","nullable":true,"primary_key":false}],"plugin":{"slug":"sitesignal","name":"SiteSignal","active_installs":10,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/sitesignal/"}}