汽车故障诊断-

-- 数据库大全：汽车故障诊断-
-- 来源：YesApi.cn
CREATE TABLE `yesapi_ecs_goods` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `cat_id` smallint(5) NULL DEFAULT '0' COMMENT '',
    `goods_sn` varchar(60) NULL COMMENT '',
    `goods_name` varchar(120) NULL COMMENT '',
    `goods_name_style` varchar(60) NULL DEFAULT '+' COMMENT '',
    `click_count` int(10) NULL DEFAULT '0' COMMENT '',
    `brand_id` smallint(5) NULL DEFAULT '0' COMMENT '',
    `provider_name` varchar(100) NULL COMMENT '',
    `goods_number` smallint(5) NULL DEFAULT '0' COMMENT '',
    `goods_weight` decimal(10,3) unsigned NULL DEFAULT '0.000' COMMENT '',
    `market_price` decimal(10,2) unsigned NULL DEFAULT '0.00' COMMENT '',
    `shop_price` decimal(10,2) unsigned NULL DEFAULT '0.00' COMMENT '',
    `promote_price` decimal(10,2) unsigned NULL DEFAULT '0.00' COMMENT '',
    `promote_start_date` int(11) NULL DEFAULT '0' COMMENT '',
    `promote_end_date` int(11) NULL DEFAULT '0' COMMENT '',
    `warn_number` tinyint(3) NULL DEFAULT '1' COMMENT '',
    `keywords` varchar(255) NULL COMMENT '',
    `goods_brief` varchar(255) NULL COMMENT '',
    `goods_desc` text NULL COMMENT '',
    `goods_thumb` varchar(255) NULL COMMENT '',
    `goods_img` varchar(255) NULL COMMENT '',
    `original_img` varchar(255) NULL COMMENT '',
    `is_real` tinyint(3) NULL DEFAULT '1' COMMENT '',
    `extension_code` varchar(30) NULL COMMENT '',
    `is_on_sale` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `is_alone_sale` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `is_shipping` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `integral` int(10) NULL DEFAULT '0' COMMENT '',
    `sort_order` smallint(4) NULL DEFAULT '100' COMMENT '',
    `is_delete` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `is_best` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `is_new` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `is_hot` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `is_promote` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `bonus_type_id` tinyint(3) NULL DEFAULT '0' COMMENT '',
    `last_update` int(10) NULL DEFAULT '0' COMMENT '',
    `goods_type` smallint(5) NULL DEFAULT '0' COMMENT '',
    `seller_note` varchar(255) NULL COMMENT '',
    `give_integral` int(11) NULL DEFAULT '-1' COMMENT '',
    `rank_integral` int(11) NULL DEFAULT '-1' COMMENT '',
    `suppliers_id` smallint(5) NULL COMMENT '',
    `is_check` tinyint(1) NULL COMMENT '',
    KEY `cat_id` (`cat_id`),
    KEY `goods_sn` (`goods_sn`),
    KEY `brand_id` (`brand_id`),
    KEY `goods_number` (`goods_number`),
    KEY `goods_weight` (`goods_weight`),
    KEY `promote_start_date` (`promote_start_date`),
    KEY `promote_end_date` (`promote_end_date`),
    KEY `sort_order` (`sort_order`),
    KEY `last_update` (`last_update`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '汽车故障诊断-';

复制后，到数据库执行，即可创建此数据库表。