{"table_name":"sr_woo_order_items","full_table_name":"wp_sr_woo_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS `wp_sr_woo_order_items` ( `product_id` bigint(20) unsigned NOT NULL default '0', `order_id` bigint(20) unsigned NOT NULL default '0', `order_date` datetime NOT NULL default '0000-00-00 00:00:00', `order_status` text NOT NULL, `product_name` text NOT NULL, `sku` text NOT NULL, `category` text NOT NULL, `quantity` int(10) unsigned NOT NULL default '0', `sales` decimal(11,2) NOT NULL default '0.00', `discount` decimal(11,2) NOT NULL default '0.00', KEY `product_id` (`product_id`), KEY `order_id` (`order_id`) ) $collate;\"; $wpdb->query($query);","columns":[{"name":"product_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_date","type":"datetime","nullable":false,"primary_key":false},{"name":"order_status","type":"text","nullable":false,"primary_key":false},{"name":"product_name","type":"text","nullable":false,"primary_key":false},{"name":"sku","type":"text","nullable":false,"primary_key":false},{"name":"category","type":"text","nullable":false,"primary_key":false},{"name":"quantity","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"sales","type":"decimal(11,2)","nullable":false,"primary_key":false},{"name":"discount","type":"decimal(11,2)","nullable":false,"primary_key":false}],"plugin":{"slug":"smart-reporter-for-wp-e-commerce","name":"Smart Reporter For WooCommerce and WP eCommerce","active_installs":300,"version":"2.10.0","wp_org_url":"https://wordpress.org/plugins/smart-reporter-for-wp-e-commerce/"}}