{"table_name":"woo_sr_orders","full_table_name":"wp_woo_sr_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_woo_sr_orders ( `order_id` bigint(20) unsigned NOT NULL, `created_date` date NOT NULL DEFAULT '0000-00-00', `created_time` time NOT NULL DEFAULT '00:00:00', `status` ENUM('wc-pending' ,'wc-processing' ,'wc-on-hold' ,'wc-completed' ,'wc-cancelled' ,'wc-refunded' ,'wc-failed'), `type` ENUM('shop_order','shop_order_refund') NOT NULL DEFAULT 'shop_order', `parent_id` bigint(20) NOT NULL DEFAULT '0', `total` decimal(10,2) NOT NULL DEFAULT '0.00', `currency` varchar(5) NOT NULL, `discount` decimal(10,2) NOT NULL DEFAULT '0.00', `cart_discount` decimal(10,2) NOT NULL DEFAULT '0.00', `shipping` decimal(10,2) NOT NULL DEFAULT '0.00', `shipping_tax` decimal(10,2) NOT NULL DEFAULT '0.00', `shipping_method` varchar(50) NOT NULL, `tax` decimal(10,2) NOT NULL DEFAULT '0.00', `qty` smallint(5) unsigned NOT NULL DEFAULT '0', `payment_method` varchar(20) NOT NULL, `user_id` bigint(20) NOT NULL DEFAULT '0', `billing_email` varchar(255) NOT NULL, `customer_name` varchar(255) NOT NULL, `billing_country` varchar(20) 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_id`), KEY `parent_id` (`parent_id`), KEY `currency` (`currency`), KEY `date_and_status` (`created_date`,`status`) ) $collate;\"; $wpdb->query($query);","columns":[{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"created_date","type":"date","nullable":false,"primary_key":false},{"name":"created_time","type":"time","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('wc-pending' ,'wc-processing' ,'wc-on-hold' ,'wc-completed' ,'wc-cancelled' ,'wc-refunded' ,'wc-failed')","nullable":true,"primary_key":false},{"name":"type","type":"ENUM('shop_order','shop_order_refund')","nullable":false,"primary_key":false},{"name":"parent_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"total","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(5)","nullable":false,"primary_key":false},{"name":"discount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"cart_discount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"shipping","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"shipping_tax","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"shipping_method","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"tax","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"qty","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"payment_method","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"billing_email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"customer_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_country","type":"varchar(20)","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/"}}