## 1.商品主表 ``` CREATE TABLE `ims_goods`(`goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,`cat_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '分类id',`goods_sn` varchar(60) NOT NULL DEFAULT '' COMMENT '商品货号', `goods_name` varchar(120) NOT NULL DEFAULT '' COMMENT '商品名',`click_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览量', `brand_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '品牌id', `suppliers_id` varchar(100) NOT NULL DEFAULT '' COMMENT '供应商id', `market_price` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '市场价格', `shop_price` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '本店售价', `promote_price` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '促销价格', `promote_start_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '促销开始日期', `promote_end_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '促销结束日期', `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '商品关键字', `goods_brief` varchar(255) NOT NULL DEFAULT '' COMMENT '商品简介', `goods_desc` text NOT NULL COMMENT '商品详情', `goods_img` varchar(255) NOT NULL DEFAULT '' COMMENT '商品图' , `is_putaway` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否上架', `putaway_time` timestamp NOT NULL COMMENT '上架时间', `create_time` timestamp NOT NULL COMMENT '添加时间', `sort_order` smallint(4) unsigned NOT NULL DEFAULT '100' COMMENT '排序', `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否被删除', `is_best` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '精品', `is_new` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '新品', `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '热销', `is_promote` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '促销', `goods_for` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '商品归属于哪个活动', `give_integral` int(11) NOT NULL DEFAULT '-1' COMMENT '赠送积分', `rank_integral` int(11) NOT NULL DEFAULT '-1' COMMENT '赠送等级经验', `rest_count` mediumint(5) NOT NULL DEFAULT '0' COMMENT '库存', `sell_count` mediumint(5) NOT NULL DEFAULT '0' COMMENT '销量', PRIMARY KEY(`goods_id`), KEY`goods_sn`(`goods_sn`), KEY`cat_id`(`cat_id`), KEY`brand_id`(`brand_id`), KEY`promote_end_date`(`promote_end_date`), KEY`promote_start_date`(`promote_start_date`) )ENGINE=MyISAM DEFAULT CHARSET=utf8 ```