wp_dealbao_goods
StaticStores dealbao goods data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑goods_id | int(10) UNSIGNED | NO |
| spu | varchar(24) | YES |
| goods_name | text | NO |
| goods_ad_words | text | YES |
| category_id | varchar(200) | NO |
| spec_name | text | YES |
| spec_value | text | YES |
| goods_image | varchar(255) | NO |
| goods_body | mediumtext | NO |
| mobile_body | mediumtext | YES |
| sku_data | mediumtext | YES |
| gallery_ids | mediumtext | YES |
| goods_price | decimal(10, 2) | NO |
| goods_marketprice | decimal(12, 2) | NO |
| goods_storage | int(10) UNSIGNED | YES |
| weight | int(10) UNSIGNED | YES |
| goods_storage_alarm | int(10) UNSIGNED | YES |
| goods_upload_type | int(2) UNSIGNED | YES |
CREATE TABLE Statement
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
Safe to delete?
If you have uninstalled Esell, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_dealbao_goods`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Esell