创建数据库，字段
表1:product_info
CREATE TABLE `product_info` (
`product_id` varchar(32) NOT NULL COMMENT '商品ID',
`product_name` varchar(64) NOT NULL COMMENT '商品名称',
`product_price` decimal(8,2) NOT NULL COMMENT '单价',
`product_stock` int(255) NOT NULL COMMENT '库存',
`product_description` varchar(64) NOT NULL COMMENT '描述',
`product_icon` varchar(512) NOT NULL COMMENT '小图',
`caretory_type` int(255) NOT NULL COMMENT '类目编号',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间/修改时间',
PRIMARY KEY (`product_id`)
) ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8
COMMENT='商品表';
product_category
CREATE TABLE `product_category` (
`category_id` int NOT NULL AUTO_INCREMENT COMMENT '类目id',
`category_name` varchar(64) NOT NULL COMMENT '类目名字',
`category_type` int NOT NULL COMMENT '类目编号',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间/修改时间',
PRIMARY KEY (`category_id`),
Unique KEY `uqe_category_type`(`category_type`)
) ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8
COMMENT='类目表';
order_master
CREATE TABLE `order_master` (
`order_id` varchar(32) NOT NULL,
`buyer_name` varchar(32) NOT NULL COMMENT '买家名字',
`buyer_phone` varchar(32) NOT NULL COMMENT '买家电话',
`buyer_address` varchar(128) NOT NULL COMMENT '买家地址',
`buyer_openid` varchar(64) NOT NULL COMMENT '买家微信openid',
`order_amount` decimal(8,2) NOT NULL COMMENT '订单总金额',
`order_status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '订单状态,默认0新下单',
`pay_status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '支付状态，默认0未支付',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间/更新时间',
PRIMARY KEY (`order_id`),
KEY `idx_buyer_openid`(`buyer_openid`)
) ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8
COMMENT='订单表';
order_detail
/* 请确认以下SQL符合您的变更需求，务必确认无误后再提交执行 */
CREATE TABLE `order_detail` (
`detail_id` varchar(32) NOT NULL,
`order_id` varchar(32) NOT NULL COMMENT '订单id',
`product_id` varchar(32) NOT NULL COMMENT '商品id',
`product_name` varchar(64) NOT NULL COMMENT '商品名称',
`product_price` decimal(8,2) NOT NULL COMMENT '商品数量',
`product_quantity` int(255) NOT NULL COMMENT '商品数量',
`product_icon` varchar(512) NOT NULL COMMENT '商品小图',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间/修改时间',
PRIMARY KEY (`detail_id`),
KEY `idx_order_id`(`order_id`)
) ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8
COMMENT='订单详情表';
环境搭建,springboot，配置密码，环境，mybatis，yml
日志框架logback
区分info和error日志，每天产生一个日志文件