{"table_name":"aieo_order_stats","full_table_name":"wp_aieo_order_stats","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_aieo_order_stats` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `orderid` decimal(12,0) DEFAULT NULL, `customeremail` varchar(255) DEFAULT NULL, `customerid` decimal(12,0) DEFAULT NULL, `birthyear` decimal(12,0) DEFAULT NULL, `birthday` varchar(50) DEFAULT NULL, `firstname` varchar(60) DEFAULT NULL, `lastname` varchar(90) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `postcode` varchar(50) DEFAULT NULL, `numberofitemsperorder` decimal(12,0) DEFAULT NULL, `numberoforders` decimal(12,0) DEFAULT NULL, `orderspend` decimal(12,2) DEFAULT NULL, `shippingcharged` decimal(12,2) DEFAULT NULL, `shippingtype` varchar(255) DEFAULT NULL, `freeshipping` varchar(5) DEFAULT NULL, `totalshipping` decimal(12,2) DEFAULT NULL, `netspendonproducts` decimal(12,2) DEFAULT NULL, `orderdate` date NOT NULL DEFAULT '0000-00-00', `orderdatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `orderday` decimal(2,0) DEFAULT NULL, `orderdaymonth` decimal(2,0) DEFAULT NULL, `buyerspayrol` varchar(20) DEFAULT NULL, `buyersday` varchar(20) DEFAULT NULL, `buyerstime` varchar(20) DEFAULT NULL, `buyersdevice` varchar(100) DEFAULT NULL, `link_to_order_details` varchar(200) DEFAULT NULL, `paymenttype` varchar(80) DEFAULT NULL, `pickuplocation` varchar(150) DEFAULT NULL, `phoneorder` varchar(5) DEFAULT NULL, `orderstatus` varchar(50) DEFAULT NULL, `ordersource` varchar(255) DEFAULT NULL, `orderutmsource` varchar(255) DEFAULT NULL, `orderutmmedium` varchar(255) DEFAULT NULL, `orderutmcampaign` varchar(255) DEFAULT NULL, `orderutmterm` varchar(255) DEFAULT NULL, `orderutmcontent` varchar(255) DEFAULT NULL, `statsclientid` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_id_idx` (`orderid`,`customeremail`), KEY `idx_customeremail` (`customeremail`) ) ENGINE","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"orderid","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"customeremail","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"customerid","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"birthyear","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"birthday","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"firstname","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"lastname","type":"varchar(90)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"postcode","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"numberofitemsperorder","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"numberoforders","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"orderspend","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"shippingcharged","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"shippingtype","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"freeshipping","type":"varchar(5)","nullable":true,"primary_key":false},{"name":"totalshipping","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"netspendonproducts","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"orderdate","type":"date","nullable":false,"primary_key":false},{"name":"orderdatetime","type":"datetime","nullable":false,"primary_key":false},{"name":"orderday","type":"decimal(2,0)","nullable":true,"primary_key":false},{"name":"orderdaymonth","type":"decimal(2,0)","nullable":true,"primary_key":false},{"name":"buyerspayrol","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"buyersday","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"buyerstime","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"buyersdevice","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"link_to_order_details","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"paymenttype","type":"varchar(80)","nullable":true,"primary_key":false},{"name":"pickuplocation","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"phoneorder","type":"varchar(5)","nullable":true,"primary_key":false},{"name":"orderstatus","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ordersource","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"orderutmsource","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"orderutmmedium","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"orderutmcampaign","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"orderutmterm","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"orderutmcontent","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"statsclientid","type":"int(10) unsigned","nullable":true,"primary_key":false}],"plugin":{"slug":"ai-eshop-optimizer","name":"AI eShop Optimizer","active_installs":10,"version":"8.3","wp_org_url":"https://wordpress.org/plugins/ai-eshop-optimizer/"}}