H5微信支付商城初始数据库
<pre><code class="language-SQL">-- 用户表
CREATE TABLE `user` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(64) NOT NULL,
`phone_num` varchar(16) DEFAULT NULL COMMENT '用户名',
`password` varchar(256) DEFAULT NULL COMMENT '用户密码',
`alias` varchar(32) DEFAULT NULL COMMENT '别名',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_user_id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 初始数据
INSERT INTO `user` (`id`, `phone_num`, `password`, `alias`) VALUES ('U00167809301581337D5289CF57149F1881B618AA204FC3D', '15639155028', '1d25ed5aafd100c3c4ea8ec58b60fff2a49b5cd3', '15639155028');
INSERT INTO `user` (`id`, `phone_num`, `password`, `alias`) VALUES ('U167817598774699FE4E5CB82245FA8A8299CD5721F1B9', '15639155029', 'ce58d78e5430d2f733a19d01438503930c3e341e', '15639155029');
-- 商品
CREATE TABLE `product` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(64) NOT NULL,
`name` varchar(128) DEFAULT NULL COMMENT '商品名称',
`img` varchar(256) DEFAULT NULL COMMENT '商品图片地址',
`price` decimal(8,2) DEFAULT NULL COMMENT '商品价格',
`details` varchar(256) DEFAULT NULL COMMENT '商品详情',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '商品状态 1-已上架 2-未上架',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_product_id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 初始数据
INSERT INTO `product` (`id`, `name`, `img`, `price`, `details`, `status`) VALUES ('P1678446509406562B0F5E6D544FB88BA5979F6F6F65D6', '毛绒手袋(深绿色)', 'https://doc.changqian365.com/robot/IMG230310B1859185F6DC490CA25DED93BBDF4C6B.png', 20.00, '50*50cm深绿色毛绒手袋，立体设计，可用于携带日常物品等', 1);
INSERT INTO `product` (`id`, `name`, `img`, `price`, `details`, `status`) VALUES ('P167844650940691AB96FD44C14F1FBB4EF6F835CE14D1', '毛绒手袋(浅绿色)', 'https://doc.changqian365.com/robot/IMG2303101ADF4CD6F2874F42AF1D5C013BEF9BDC.png', 20.00, '50*50cm浅绿色毛绒手袋，立体设计，可用于携带日常物品等', 1);
INSERT INTO `product` (`id`, `name`, `img`, `price`, `details`, `status`) VALUES ('P16784465094065B0188D7E1214FC99263AFBC1103BC8C', '一次性口罩(50支装)', 'https://doc.changqian365.com/robot/IMG230310887D5F0C7F5346109C74E9FB9F8147C4.png', 29.80, '三层防护口罩，印有公司logo，均为单个独立包装，每份50支，图案随机混合', 1);
INSERT INTO `product` (`id`, `name`, `img`, `price`, `details`, `status`) VALUES ('P1678446524591C828BDE84C2D4B0399A43AB9FC68CBD0', '纯棉长袜2双(通用)', 'https://doc.changqian365.com/robot/IMG23031003778A18D7234F8092EC893A59AC3AC7.png', 9.90, '纯棉长袜2双，均码，两种图案各一双', 1);
INSERT INTO `product` (`id`, `name`, `img`, `price`, `details`, `status`) VALUES ('P16784465245918A61E4F3425B46E8AA4A3E60A4D8917E', '创意木质日历(手动)', 'https://doc.changqian365.com/robot/IMG23031089F1017ACDE94F66BACD190B9F703E0A.png', 12.80, '手动万年历，是桌面摆件也是万年历，内含三个月份木条包含一年12个月，含有两个日历木块，日期需自己动手摆好，可随时调整', 1);
-- 订单
CREATE TABLE `orders` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(64) NOT NULL,
`user_id` varchar(64) DEFAULT NULL,
`price` decimal(8,2) DEFAULT NULL COMMENT '订单价格',
`total` int(6) unsigned NOT NULL COMMENT '订单商品总数' ,
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '订单状态 1待支付 2已支付 3已发货 4 已完成',
`pay_time` int(11) unsigned DEFAULT NULL COMMENT '支付时间' ,
`out_time` int(11) unsigned DEFAULT NULL COMMENT '发货时间' ,
`pass_time` int(11) unsigned DEFAULT NULL COMMENT '完成订单时间' ,
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_order_id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 订单和商品关系表
CREATE TABLE `order_and_product` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT,
`product_id` varchar(64) DEFAULT NULL,
`order_id` varchar(64) DEFAULT NULL,
`price` decimal(8,2) DEFAULT NULL COMMENT '下单时商品价格',
`total` int(6) unsigned NOT NULL COMMENT '商品下单数量' ,
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 收件人
CREATE TABLE `consignee` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(64) NOT NULL,
`order_id` varchar(64) DEFAULT NULL,
`user_id` varchar(64) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL COMMENT '收货人姓名',
`phone` varchar(16) DEFAULT NULL COMMENT '收货人电话',
`area` varchar(256) DEFAULT NULL COMMENT '地区',
`address` varchar(256) DEFAULT NULL COMMENT '详细地址',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_consignee_id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 快递
CREATE TABLE `tracking` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(64) NOT NULL,
`order_id` varchar(64) DEFAULT NULL,
`number` varchar(128) DEFAULT NULL COMMENT '运单号',
`server` varchar(128) DEFAULT NULL COMMENT '物流服务商',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_tracking_id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
</code></pre>