广州网站建设_开发安卓app_青岛做网站_东营网站建设
CREATE TABLE sh_goods (id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT COMMENT '商品id',category_id INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '分类id',spu_id INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'SPU id',sn VARCHAR(20) NOT NULL DEFAULT '' COMMENT '编号',name VARCHAR(120) NOT NULL DEFAULT '' COMMENT '名称',keyword VARCHAR(255) NOT NULL DEFAULT '' COMMENT '关键词',picture VARCHAR(255) NOT NULL DEFAULT '' COMMENT '图片',tips VARCHAR(255) NOT NULL DEFAULT '' COMMENT '提示',description VARCHAR(255) NOT NULL DEFAULT '' COMMENT '描述',content TEXT NOT NULL COMMENT '详情',price DECIMAL(10, 2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '价格',stock INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '库存',score DECIMAL(3, 2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '评分',is_on_sale TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否上架',is_del TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除',is_free_shipping TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否包邮',sell_count INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '销量计数',comment_count INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '评论计数',on_sale_time INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '上架时间',create_time INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',update_time INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间'">