{"slug":"smart-reporter-for-wp-e-commerce","name":"Smart Reporter For WooCommerce and WP eCommerce","description":"A phenomenal plugin that solves all your business related issues, from business analysis to reporting on your WooCommerce and WordPress eCommerce site …","author":"storeapps","active_installs":300,"version":"2.10.0","wp_org_url":"https://wordpress.org/plugins/smart-reporter-for-wp-e-commerce/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"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","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}],"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);"},{"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","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}],"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);"},{"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","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}],"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);"},{"table_name":"woo_sr_orders_meta_all","full_table_name":"wp_woo_sr_orders_meta_all","description":"Stores additional metadata (key-value pairs) for woo sr orders meta all records.","detection_method":"static","confidence":"medium","columns":[],"create_sql":"CREATE TABLE IF NOT EXISTS wp_woo_sr_orders_meta_all ( `post_id` bigint(20) NOT NULL, `meta_key` varchar(255) COLLATE"}],"table_count":4}