{"table_name":"woo_sr_order_items","full_table_name":"wp_woo_sr_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_woo_sr_order_items ( `order_item_id` bigint(20) NOT NULL, `order_date` date NOT NULL DEFAULT '0000-00-00', `order_time` time NOT NULL DEFAULT '00:00:00', `order_is_sale` tinyint(1) NOT NULL DEFAULT '1', `product_id` bigint(20) NOT NULL DEFAULT '0', `variation_id` bigint(20) NOT NULL DEFAULT '0', `order_id` bigint(20) NOT NULL, `type` enum('S','D','R') NOT NULL, `qty` smallint(6) NOT NULL, `total` decimal(10,2) NOT NULL, `trash` BIT(1) NOT NULL DEFAULT 0, `meta_values` longtext NOT NULL, `update_flag` BIT(1) NOT NULL default 0, PRIMARY KEY (`order_item_id`), KEY `composite` (`order_date`,`order_is_sale`,`type`,`product_id`) ) $collate;\"; $wpdb->query($query);","columns":[{"name":"order_item_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"order_date","type":"date","nullable":false,"primary_key":false},{"name":"order_time","type":"time","nullable":false,"primary_key":false},{"name":"order_is_sale","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"variation_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"type","type":"enum('S','D','R')","nullable":false,"primary_key":false},{"name":"qty","type":"smallint(6)","nullable":false,"primary_key":false},{"name":"total","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"trash","type":"BIT(1)","nullable":false,"primary_key":false},{"name":"meta_values","type":"longtext","nullable":false,"primary_key":false},{"name":"update_flag","type":"BIT(1)","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/"}}