{"slug":"esell","name":"Esell","description":"This is a global supply chain plug-in","author":"wwyc","active_installs":0,"version":"5.4.4","wp_org_url":"https://wordpress.org/plugins/esell/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"dealbao_category_bind","full_table_name":"wp_dealbao_category_bind","description":"Stores dealbao category bind data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(10) UNSIGNED","nullable":false,"primary_key":true},{"name":"cate_id","type":"int(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"collect_cate_id","type":"int(10) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dealbao_category_bind`( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类绑定表id', `cate_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'woocommerce产品分类id', `collect_cate_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'dealbao收藏分类id', PRIMARY KEY (`id`) USING BTREE )DEFAULT CHARSET"},{"table_name":"dealbao_goods","full_table_name":"wp_dealbao_goods","description":"Stores dealbao goods data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"goods_id","type":"int(10) UNSIGNED","nullable":false,"primary_key":true},{"name":"spu","type":"varchar(24)","nullable":true,"primary_key":false},{"name":"goods_name","type":"text","nullable":false,"primary_key":false},{"name":"goods_ad_words","type":"text","nullable":true,"primary_key":false},{"name":"category_id","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"spec_name","type":"text","nullable":true,"primary_key":false},{"name":"spec_value","type":"text","nullable":true,"primary_key":false},{"name":"goods_image","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"goods_body","type":"mediumtext","nullable":false,"primary_key":false},{"name":"mobile_body","type":"mediumtext","nullable":true,"primary_key":false},{"name":"sku_data","type":"mediumtext","nullable":true,"primary_key":false},{"name":"gallery_ids","type":"mediumtext","nullable":true,"primary_key":false},{"name":"goods_price","type":"decimal(10, 2)","nullable":false,"primary_key":false},{"name":"goods_marketprice","type":"decimal(12, 2)","nullable":false,"primary_key":false},{"name":"goods_storage","type":"int(10) UNSIGNED","nullable":true,"primary_key":false},{"name":"weight","type":"int(10) UNSIGNED","nullable":true,"primary_key":false},{"name":"goods_storage_alarm","type":"int(10) UNSIGNED","nullable":true,"primary_key":false},{"name":"goods_upload_type","type":"int(2) UNSIGNED","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dealbao_goods`( `goods_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商品公共表id', `spu` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '10位不重复SPU', `goods_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名称', `goods_ad_words` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品广告词', `category_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品分类', `spec_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '规格名称', `spec_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '规格值', `goods_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品主图', `goods_body` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品内容', `mobile_body` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '手机端商品描述', `sku_data` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品规格详情', `gallery_ids` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品多图片', `goods_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品价格', `goods_marketprice` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '市场价', `goods_storage` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '商品库存', `weight` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '商品重量', `goods_storage_alarm` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '库存报警值', `goods_upload_type` int(2) UNSIGNED NULL DEFAULT 0 COMMENT '商品上传状态 0是待上传，1是上传成功', PRIMARY KEY (`goods_id`) USING BTREE, INDEX `category_id`(`category_id`) USING BTREE, INDEX `spu`(`spu`) USING BTREE, INDEX `goods_stoage`(`goods_storage`) USING BTREE )DEFAULT CHARSET"}],"table_count":2}