CREATE TABLE `goods` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品名称', `class_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '商品分类uid', `sort` int unsigned NOT NULL DEFAULT '1000' COMMENT '排序', `steer_level` int unsigned NOT NULL DEFAULT '1' COMMENT '推荐等级(1-9)', `cover` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '封面', `status` int NOT NULL DEFAULT '1' COMMENT '状态1,未上架;2,已上架;3,待审核;4,已删除', `coins` int unsigned NOT NULL DEFAULT '0' COMMENT '现价金币', `original_cions` int unsigned NOT NULL DEFAULT '0' COMMENT '原价金币', `member_coins` int unsigned NOT NULL DEFAULT '0' COMMENT '会员金币', `stock` int unsigned NOT NULL DEFAULT '0' COMMENT '库存', `shops_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '店铺uid(即用户uid)', `likes` int NOT NULL DEFAULT '0' COMMENT '点赞数', `browse` int unsigned NOT NULL DEFAULT '0' COMMENT '浏览数', `number_orders` int unsigned NOT NULL DEFAULT '0' COMMENT '下单数', `actual_number_orders` int NOT NULL DEFAULT '0' COMMENT '真实订单数', `appraise` int unsigned NOT NULL DEFAULT '0' COMMENT '评价数', `introduce` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品介绍', `photo_address` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品图片地址json', `video_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品视频地址', `up_date` datetime DEFAULT NULL COMMENT '上架时间', `delete_at` datetime DEFAULT NULL COMMENT '删除时间(下架时间)', `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='原味商品表'; CREATE TABLE `goods_assess` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `goods_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '商品uid', `buy_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '买家uid', `goods_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品名', `order_sn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单编号', `evaluation_map` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '评价图json', `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '评价内容', `comment_fraction` int unsigned NOT NULL DEFAULT '0' COMMENT '评价分数', `reward_coins` int unsigned NOT NULL DEFAULT '0' COMMENT '奖励金币', `created_at` datetime DEFAULT NULL COMMENT '评价时间', `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='商品评价表'; CREATE TABLE `shops` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '店铺uid(即用户uid)', `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '店铺名字', `credit_value` int NOT NULL DEFAULT '0' COMMENT '信誉值', `sort` int unsigned NOT NULL DEFAULT '0' COMMENT '排序', `steer_level` int NOT NULL DEFAULT '1' COMMENT '推荐等级(1-9)', `is_certified` int unsigned NOT NULL DEFAULT '1' COMMENT '是否认证:1,未认证；2,已认证', `province` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '省', `city` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '市', `region` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '区', `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '封面', `goods_count` int unsigned NOT NULL DEFAULT '0' COMMENT '商品个数', `goods_up_count` int NOT NULL DEFAULT '0' COMMENT '商品上架个数', `margin` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '保证金', `frozen_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '冻结金额', `amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额', `video_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '店铺视频地址', `share_ratio` int DEFAULT '0' COMMENT '分成比例', `introduce` text COLLATE utf8mb4_unicode_ci COMMENT '文字介绍', `tg` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'tg联系方式', `qq` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'qq联系方式', `updated_at` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL COMMENT '入住时间', PRIMARY KEY (`id`), UNIQUE KEY `uid` (`uid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='店铺表'; CREATE TABLE `original_order` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `order_sn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单号', `buy_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '买家uid', `sell_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '卖家uid', `goods_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '商品uid', `goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品名字', `goods_cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品封面', `goods_amount` int unsigned NOT NULL DEFAULT '0' COMMENT '商品数量', `original_amount` int unsigned NOT NULL DEFAULT '0' COMMENT '原价金额', `sell_amount` int unsigned NOT NULL DEFAULT '0' COMMENT '销售金额', `actual_amount` int unsigned NOT NULL DEFAULT '0' COMMENT '实际金额', `clinch_amount` int unsigned NOT NULL DEFAULT '0' COMMENT '成交金额', `order_status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '订单状态:1待付款,2待发货,3待收货,4已完成,5,退款', `pay_status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '支付状态:1,待支付2,已取消3,成功', `redund_status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '退款状态:1,未申请2,处理中3,驳回4,成功退款', `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '收货地址(json)', `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '留言', `courier_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '快递单号', `courier_firm` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '快递公司', `logistics_info` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '物流信息', `denial_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '拒绝原因', `apply_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `pay_time` datetime DEFAULT NULL COMMENT '支付时间', `receipt_time` datetime DEFAULT NULL COMMENT '收货时间', `refund_apply_time` datetime DEFAULT NULL COMMENT '退款申请时间', `refund_end_time` datetime DEFAULT NULL COMMENT '退款结束时间', `assess_time` datetime DEFAULT NULL COMMENT '评价时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `order_sn` (`order_sn`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='原味订单'; CREATE TABLE `original_like_log` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户uid', `goods_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '商品uid', `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='原味点赞日志'; CREATE TABLE `user_shipping_address` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '收件人名字', `phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '手机号', `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '收货详细地址', `is_default` int unsigned NOT NULL DEFAULT '2' COMMENT '是否默认地址:1,是;2,否', `province` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '省', `city` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '市', `region` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '区', `updated_at` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户收货地址'; CREATE TABLE `original_category` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类名字', `status` int unsigned NOT NULL DEFAULT '2' COMMENT '状态:1,开启2,关闭', `type` int NOT NULL DEFAULT '0' COMMENT '分类类型:1,类型分类,2标签分类', `sort` int unsigned NOT NULL DEFAULT '0' COMMENT '排序', `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='原味分类'; ALTER TABLE `coins_log` MODIFY COLUMN `coin_type` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '类型 1 购买金币 2金币购买会员 3后台处理 4购买原味' AFTER `amount_log`;