video_server/storage/sql/yuanwei_inc_20220223.sql

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`;