登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 6 Fork 1

王朔/猫咪直播

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
egg-catlive.sql 22.19 KB
一键复制 编辑 原始数据 按行查看 历史
王朔 提交于 2024-08-30 22:00 . 123
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309
/*

Navicat MySQL Data Transfer



Source Server         : ceshi

Source Server Version : 50505

Source Host           : localhost:3306

Source Database       : egg-catlive



Target Server Type    : MYSQL

Target Server Version : 50505

File Encoding         : 65001



Date: 2024-08-30 21:59:04

*/



SET FOREIGN_KEY_CHECKS=0;



-- ----------------------------

-- Table structure for comment

-- ----------------------------

DROP TABLE IF EXISTS `comment`;

CREATE TABLE `comment` (

  `id` int(20) NOT NULL AUTO_INCREMENT,

  `content` text COLLATE utf8mb4_unicode_520_nopad_ci NOT NULL COMMENT '评论内容',

  `live_id` int(11) NOT NULL DEFAULT 0 COMMENT '直播间id',

  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',

  `created_time` datetime DEFAULT NULL,

  `updated_time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `live_id` (`live_id`),

  KEY `user_id` (`user_id`),

  CONSTRAINT `comment_ibfk_1` FOREIGN KEY (`live_id`) REFERENCES `live` (`id`) ON DELETE CASCADE,

  CONSTRAINT `comment_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_nopad_ci;



-- ----------------------------

-- Records of comment

-- ----------------------------

INSERT INTO `comment` VALUES ('2', '不错', '8', '7', '2024-08-30 19:44:19', '2024-08-30 19:44:19');

INSERT INTO `comment` VALUES ('3', '123', '8', '7', '2024-08-30 19:55:27', '2024-08-30 19:55:27');

INSERT INTO `comment` VALUES ('4', '456', '8', '7', '2024-08-30 19:55:37', '2024-08-30 19:55:37');

INSERT INTO `comment` VALUES ('5', '123', '8', '7', '2024-08-30 19:57:04', '2024-08-30 19:57:04');

INSERT INTO `comment` VALUES ('6', '456', '8', '7', '2024-08-30 19:57:12', '2024-08-30 19:57:12');

INSERT INTO `comment` VALUES ('7', '555', '8', '7', '2024-08-30 19:58:37', '2024-08-30 19:58:37');

INSERT INTO `comment` VALUES ('8', '6667', '8', '7', '2024-08-30 19:58:42', '2024-08-30 19:58:42');

INSERT INTO `comment` VALUES ('9', 'yyy', '8', '7', '2024-08-30 19:58:50', '2024-08-30 19:58:50');

INSERT INTO `comment` VALUES ('10', '123', '8', '7', '2024-08-30 20:02:23', '2024-08-30 20:02:23');

INSERT INTO `comment` VALUES ('11', '456', '8', '7', '2024-08-30 20:02:27', '2024-08-30 20:02:27');

INSERT INTO `comment` VALUES ('12', '7777', '8', '7', '2024-08-30 20:02:35', '2024-08-30 20:02:35');

INSERT INTO `comment` VALUES ('13', '888', '8', '7', '2024-08-30 20:02:41', '2024-08-30 20:02:41');

INSERT INTO `comment` VALUES ('14', '999', '8', '7', '2024-08-30 20:02:46', '2024-08-30 20:02:46');

INSERT INTO `comment` VALUES ('15', '123', '8', '7', '2024-08-30 20:04:42', '2024-08-30 20:04:42');

INSERT INTO `comment` VALUES ('16', '999', '8', '7', '2024-08-30 20:05:06', '2024-08-30 20:05:06');

INSERT INTO `comment` VALUES ('17', '888', '8', '7', '2024-08-30 20:05:10', '2024-08-30 20:05:10');

INSERT INTO `comment` VALUES ('18', '777', '8', '7', '2024-08-30 20:05:15', '2024-08-30 20:05:15');

INSERT INTO `comment` VALUES ('19', '665', '8', '7', '2024-08-30 20:05:19', '2024-08-30 20:05:19');

INSERT INTO `comment` VALUES ('20', '123', '8', '7', '2024-08-30 21:47:47', '2024-08-30 21:47:47');



-- ----------------------------

-- Table structure for gift

-- ----------------------------

DROP TABLE IF EXISTS `gift`;

CREATE TABLE `gift` (

  `id` int(20) NOT NULL AUTO_INCREMENT,

  `name` varchar(30) COLLATE utf8mb4_unicode_520_nopad_ci NOT NULL DEFAULT '' COMMENT '礼物名称',

  `image` varchar(255) COLLATE utf8mb4_unicode_520_nopad_ci DEFAULT '' COMMENT '礼物图标',

  `coin` int(11) NOT NULL DEFAULT 0 COMMENT '金币',

  `created_time` datetime DEFAULT NULL,

  `updated_time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_nopad_ci;



-- ----------------------------

-- Records of gift

-- ----------------------------

INSERT INTO `gift` VALUES ('3', '鸡蛋', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/bjgslqyt1280000.png', '1', '2024-08-23 20:30:51', '2024-08-23 20:30:51');

INSERT INTO `gift` VALUES ('4', '666', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/7jp2conp3qg0000.png', '1', '2024-08-23 20:31:09', '2024-08-23 20:31:09');

INSERT INTO `gift` VALUES ('5', '冰激凌', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/fgc1okuvneo0000.png', '1', '2024-08-23 20:31:31', '2024-08-23 20:31:31');

INSERT INTO `gift` VALUES ('6', '龙虾', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/4drwd1n4oys0000.png', '1', '2024-08-23 20:31:44', '2024-08-23 20:36:00');

INSERT INTO `gift` VALUES ('7', '精灵球', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/afqvtk2gzg80000.png', '1', '2024-08-23 20:32:06', '2024-08-23 20:35:51');

INSERT INTO `gift` VALUES ('8', '胶囊', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/3ol1p5oz0m00000.png', '1', '2024-08-23 20:32:16', '2024-08-23 20:32:16');

INSERT INTO `gift` VALUES ('9', '爱心', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/cin61n2sghs0000.png', '1', '2024-08-23 20:32:36', '2024-08-23 20:32:36');

INSERT INTO `gift` VALUES ('10', '花瓣', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/5pvgzdldy900000.png', '1', '2024-08-23 20:32:47', '2024-08-23 20:32:47');



-- ----------------------------

-- Table structure for live

-- ----------------------------

DROP TABLE IF EXISTS `live`;

CREATE TABLE `live` (

  `id` int(20) NOT NULL AUTO_INCREMENT,

  `title` varchar(100) COLLATE utf8mb4_unicode_520_nopad_ci NOT NULL DEFAULT '' COMMENT '直播间标题',

  `cover` varchar(255) COLLATE utf8mb4_unicode_520_nopad_ci DEFAULT '' COMMENT '直播间封面',

  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',

  `look_count` int(11) NOT NULL DEFAULT 0 COMMENT '总观看人数',

  `coin` int(11) NOT NULL DEFAULT 0 COMMENT '总金币',

  `key` varchar(255) COLLATE utf8mb4_unicode_520_nopad_ci NOT NULL DEFAULT '' COMMENT '唯一标识',

  `status` int(1) NOT NULL DEFAULT 0 COMMENT '直播间状态 0未开播 1直播中 2暂停直播 3直播结束',

  `created_time` datetime DEFAULT NULL,

  `updated_time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `user_id` (`user_id`),

  CONSTRAINT `live_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_nopad_ci;



-- ----------------------------

-- Records of live

-- ----------------------------

INSERT INTO `live` VALUES ('7', '测试', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/g929pmeba940000.png', '7', '0', '0', 'eLHdzUrESaSfmYURv1HZ', '0', '2024-08-27 15:38:47', '2024-08-27 15:38:47');

INSERT INTO `live` VALUES ('8', '测试', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/g929pmeba940000.png', '7', '0', '0', 'yDXEnR0nvQAFNjlUoIeW', '1', '2024-08-27 15:43:31', '2024-08-27 15:43:31');

INSERT INTO `live` VALUES ('9', '测试', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/g929pmeba940000.png', '7', '0', '0', 'T4xSKNH8weNF8B7figPt', '0', '2024-08-28 11:14:49', '2024-08-28 11:14:49');

INSERT INTO `live` VALUES ('10', '测试', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/g929pmeba940000.png', '7', '0', '0', 'dHiYzBuFlMCC5GasdsJz', '3', '2024-08-28 11:15:06', '2024-08-28 11:30:26');

INSERT INTO `live` VALUES ('11', '测试', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/g929pmeba940000.png', '6', '0', '0', 'hjziRqYIO7UXayXTi3gy', '0', '2024-08-28 11:26:09', '2024-08-28 11:26:09');

INSERT INTO `live` VALUES ('12', '123', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/c5l4s7og5uo0000.jpg', '7', '0', '0', '63Q5dIHTB3layvSVncXM', '0', '2024-08-30 21:27:48', '2024-08-30 21:27:48');

INSERT INTO `live` VALUES ('13', '火锅局', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/bposnhhrqa80000.jpg', '7', '0', '0', 'UgxwsOW7rPXXVWZksujx', '0', '2024-08-30 21:32:35', '2024-08-30 21:32:35');

INSERT INTO `live` VALUES ('14', '火锅局', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/2x4evqm1mhc0000.jpg', '7', '0', '0', '8NcP9IcZqvDJLejBJdcg', '0', '2024-08-30 21:36:39', '2024-08-30 21:36:39');

INSERT INTO `live` VALUES ('15', '火锅局', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/clsd6e6d84o0000.jpg', '7', '0', '0', 'zr8j3k8lR7olmYgwx3Ma', '0', '2024-08-30 21:38:49', '2024-08-30 21:38:49');

INSERT INTO `live` VALUES ('16', '鸡翅', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/7y2v00k5poc0000.png', '7', '0', '0', 'L2VlNbY4FzTkFjl8jeqE', '0', '2024-08-30 21:44:40', '2024-08-30 21:44:40');



-- ----------------------------

-- Table structure for live_gift

-- ----------------------------

DROP TABLE IF EXISTS `live_gift`;

CREATE TABLE `live_gift` (

  `id` int(20) NOT NULL AUTO_INCREMENT,

  `live_id` int(11) NOT NULL DEFAULT 0 COMMENT '直播间id',

  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',

  `gift_id` int(11) NOT NULL DEFAULT 0 COMMENT '礼物id',

  `created_time` datetime DEFAULT NULL,

  `updated_time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `live_id` (`live_id`),

  KEY `user_id` (`user_id`),

  KEY `gift_id` (`gift_id`),

  CONSTRAINT `live_gift_ibfk_1` FOREIGN KEY (`live_id`) REFERENCES `live` (`id`) ON DELETE CASCADE,

  CONSTRAINT `live_gift_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,

  CONSTRAINT `live_gift_ibfk_3` FOREIGN KEY (`gift_id`) REFERENCES `gift` (`id`) ON DELETE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_nopad_ci;



-- ----------------------------

-- Records of live_gift

-- ----------------------------

INSERT INTO `live_gift` VALUES ('3', '8', '7', '4', '2024-08-30 20:20:51', '2024-08-30 20:20:51');

INSERT INTO `live_gift` VALUES ('4', '8', '7', '4', '2024-08-30 20:21:03', '2024-08-30 20:21:03');

INSERT INTO `live_gift` VALUES ('5', '8', '7', '4', '2024-08-30 20:21:04', '2024-08-30 20:21:04');

INSERT INTO `live_gift` VALUES ('6', '8', '7', '4', '2024-08-30 20:21:05', '2024-08-30 20:21:05');

INSERT INTO `live_gift` VALUES ('7', '8', '7', '4', '2024-08-30 20:21:05', '2024-08-30 20:21:05');

INSERT INTO `live_gift` VALUES ('8', '8', '7', '4', '2024-08-30 20:21:05', '2024-08-30 20:21:05');

INSERT INTO `live_gift` VALUES ('9', '8', '7', '3', '2024-08-30 20:21:36', '2024-08-30 20:21:36');

INSERT INTO `live_gift` VALUES ('10', '8', '7', '5', '2024-08-30 20:21:41', '2024-08-30 20:21:41');

INSERT INTO `live_gift` VALUES ('11', '8', '7', '6', '2024-08-30 20:21:44', '2024-08-30 20:21:44');

INSERT INTO `live_gift` VALUES ('14', '8', '7', '3', '2024-08-30 20:25:13', '2024-08-30 20:25:13');

INSERT INTO `live_gift` VALUES ('15', '8', '7', '3', '2024-08-30 20:25:56', '2024-08-30 20:25:56');

INSERT INTO `live_gift` VALUES ('16', '8', '7', '4', '2024-08-30 20:26:01', '2024-08-30 20:26:01');

INSERT INTO `live_gift` VALUES ('17', '8', '7', '3', '2024-08-30 20:27:14', '2024-08-30 20:27:14');

INSERT INTO `live_gift` VALUES ('18', '8', '7', '3', '2024-08-30 20:27:17', '2024-08-30 20:27:17');

INSERT INTO `live_gift` VALUES ('19', '8', '7', '3', '2024-08-30 20:27:18', '2024-08-30 20:27:18');

INSERT INTO `live_gift` VALUES ('20', '8', '7', '3', '2024-08-30 20:27:46', '2024-08-30 20:27:46');

INSERT INTO `live_gift` VALUES ('21', '8', '7', '3', '2024-08-30 20:28:41', '2024-08-30 20:28:41');

INSERT INTO `live_gift` VALUES ('22', '8', '7', '3', '2024-08-30 20:29:25', '2024-08-30 20:29:25');

INSERT INTO `live_gift` VALUES ('23', '8', '7', '4', '2024-08-30 20:30:11', '2024-08-30 20:30:11');

INSERT INTO `live_gift` VALUES ('24', '8', '7', '3', '2024-08-30 20:31:05', '2024-08-30 20:31:05');

INSERT INTO `live_gift` VALUES ('25', '8', '7', '4', '2024-08-30 20:31:08', '2024-08-30 20:31:08');

INSERT INTO `live_gift` VALUES ('26', '8', '7', '4', '2024-08-30 20:32:57', '2024-08-30 20:32:57');

INSERT INTO `live_gift` VALUES ('27', '8', '7', '4', '2024-08-30 20:32:59', '2024-08-30 20:32:59');

INSERT INTO `live_gift` VALUES ('28', '8', '7', '3', '2024-08-30 20:33:32', '2024-08-30 20:33:32');

INSERT INTO `live_gift` VALUES ('29', '8', '7', '3', '2024-08-30 20:34:31', '2024-08-30 20:34:31');

INSERT INTO `live_gift` VALUES ('30', '8', '7', '3', '2024-08-30 20:34:32', '2024-08-30 20:34:32');

INSERT INTO `live_gift` VALUES ('31', '8', '7', '3', '2024-08-30 20:35:00', '2024-08-30 20:35:00');

INSERT INTO `live_gift` VALUES ('32', '8', '7', '4', '2024-08-30 20:35:09', '2024-08-30 20:35:09');

INSERT INTO `live_gift` VALUES ('33', '8', '7', '7', '2024-08-30 20:35:12', '2024-08-30 20:35:12');

INSERT INTO `live_gift` VALUES ('34', '8', '7', '3', '2024-08-30 21:47:13', '2024-08-30 21:47:13');

INSERT INTO `live_gift` VALUES ('35', '8', '7', '4', '2024-08-30 21:47:43', '2024-08-30 21:47:43');



-- ----------------------------

-- Table structure for live_user

-- ----------------------------

DROP TABLE IF EXISTS `live_user`;

CREATE TABLE `live_user` (

  `id` int(20) NOT NULL AUTO_INCREMENT,

  `live_id` int(11) NOT NULL DEFAULT 0 COMMENT '直播间id',

  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',

  `created_time` datetime DEFAULT NULL,

  `updated_time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `live_id` (`live_id`),

  KEY `user_id` (`user_id`),

  CONSTRAINT `live_user_ibfk_1` FOREIGN KEY (`live_id`) REFERENCES `live` (`id`) ON DELETE CASCADE,

  CONSTRAINT `live_user_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_nopad_ci;



-- ----------------------------

-- Records of live_user

-- ----------------------------

INSERT INTO `live_user` VALUES ('3', '7', '7', '2024-08-30 16:38:56', '2024-08-30 16:38:56');

INSERT INTO `live_user` VALUES ('4', '8', '7', '2024-08-30 16:39:05', '2024-08-30 16:39:05');

INSERT INTO `live_user` VALUES ('5', '9', '7', '2024-08-30 16:40:22', '2024-08-30 16:40:22');

INSERT INTO `live_user` VALUES ('6', '11', '7', '2024-08-30 16:40:32', '2024-08-30 16:40:32');



-- ----------------------------

-- Table structure for manager

-- ----------------------------

DROP TABLE IF EXISTS `manager`;

CREATE TABLE `manager` (

  `id` int(20) NOT NULL AUTO_INCREMENT,

  `username` varchar(30) COLLATE utf8mb4_unicode_520_nopad_ci NOT NULL DEFAULT '' COMMENT '用户名',

  `password` varchar(255) COLLATE utf8mb4_unicode_520_nopad_ci NOT NULL DEFAULT '' COMMENT '密码',

  `name` varchar(255) COLLATE utf8mb4_unicode_520_nopad_ci DEFAULT NULL,

  `notename` varchar(255) COLLATE utf8mb4_unicode_520_nopad_ci DEFAULT NULL,

  `note` varchar(255) COLLATE utf8mb4_unicode_520_nopad_ci NOT NULL DEFAULT '' COMMENT '简历',

  `avatar` varchar(255) COLLATE utf8mb4_unicode_520_nopad_ci NOT NULL DEFAULT '',

  `created_time` datetime DEFAULT NULL,

  `updated_time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `username` (`username`)

) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_nopad_ci;



-- ----------------------------

-- Records of manager

-- ----------------------------

INSERT INTO `manager` VALUES ('12', 'huangjiaju', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '黄家驹1', '妄想.docx', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/bb4fmkn1z2w0000.docx', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/4zphakbh3ww0000.png', '2024-08-22 16:19:04', '2024-08-27 15:21:23');

INSERT INTO `manager` VALUES ('13', 'admin', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 'admin', '妄想.docx', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/e5dwbqv86ts0000.docx', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/7ajxtu0kr6k0000.jpg', '2024-08-22 16:19:50', '2024-08-22 16:23:12');

INSERT INTO `manager` VALUES ('14', 'azu', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '打不死的阿祖', '妄想.docx', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/5rjcu0yplrc0000.docx', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/693bqpvpdu00000.jpg', '2024-08-22 16:21:41', '2024-08-22 16:21:41');

INSERT INTO `manager` VALUES ('15', 'ceshi', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 'ceshi', '我是愤怒.docx', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/f40ba5c0p000000.docx', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/85o388uj3j80000.png', '2024-08-27 15:19:31', '2024-08-27 15:20:29');



-- ----------------------------

-- Table structure for order

-- ----------------------------

DROP TABLE IF EXISTS `order`;

CREATE TABLE `order` (

  `id` int(20) NOT NULL AUTO_INCREMENT,

  `no` varchar(100) COLLATE utf8mb4_unicode_520_nopad_ci NOT NULL DEFAULT '' COMMENT '订单号',

  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',

  `price` int(11) NOT NULL DEFAULT 0 COMMENT '价格',

  `status` enum('pending','success','fail') COLLATE utf8mb4_unicode_520_nopad_ci NOT NULL DEFAULT 'pending' COMMENT '支付状态',

  `created_time` datetime DEFAULT NULL,

  `updated_time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `no` (`no`),

  KEY `user_id` (`user_id`),

  CONSTRAINT `order_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_nopad_ci;



-- ----------------------------

-- Records of order

-- ----------------------------

INSERT INTO `order` VALUES ('19', 'lN3YAVVHvKXRvOpnpUv2', '7', '10', 'pending', '2024-08-29 11:47:36', '2024-08-29 11:47:36');

INSERT INTO `order` VALUES ('20', 'CTglMv82KfXL2qKsOYd5', '7', '10', 'pending', '2024-08-29 11:49:16', '2024-08-29 11:49:16');

INSERT INTO `order` VALUES ('21', 'L2KDdXSBIPd8fyiC7NQw', '7', '10', 'pending', '2024-08-29 12:01:03', '2024-08-29 12:01:03');

INSERT INTO `order` VALUES ('22', 'JptqtX5Q6bYId8kvgiD5', '7', '10', 'pending', '2024-08-29 12:02:50', '2024-08-29 12:02:50');

INSERT INTO `order` VALUES ('23', 'Y8JpQ5Ew68LUCYYUQeAp', '7', '10', 'pending', '2024-08-29 12:09:30', '2024-08-29 12:09:30');

INSERT INTO `order` VALUES ('24', 'QQC8VJrlHtV8e8Y2aiUg', '7', '10', 'pending', '2024-08-29 12:09:51', '2024-08-29 12:09:51');

INSERT INTO `order` VALUES ('25', 'K86VYIUxSqFIxDPDgWzh', '7', '10', 'pending', '2024-08-29 15:13:59', '2024-08-29 15:13:59');

INSERT INTO `order` VALUES ('26', 'tBbAjIRC4F9NPW2WRREz', '7', '10', 'pending', '2024-08-29 15:14:23', '2024-08-29 15:14:23');

INSERT INTO `order` VALUES ('27', 'SLKgXkZ7a0lfmrEzF31K', '7', '10', 'pending', '2024-08-29 15:14:35', '2024-08-29 15:14:35');

INSERT INTO `order` VALUES ('28', 'PHZyM8gfC8qok8ilPGyb', '7', '10', 'pending', '2024-08-29 15:14:38', '2024-08-29 15:14:38');

INSERT INTO `order` VALUES ('29', 'xjG7XyM9C86uBQUA7sqW', '7', '10', 'pending', '2024-08-29 15:14:49', '2024-08-29 15:14:49');

INSERT INTO `order` VALUES ('30', '3TR9omjzQtafkmwAFWIn', '7', '20', 'pending', '2024-08-29 15:22:23', '2024-08-29 15:22:23');

INSERT INTO `order` VALUES ('31', 'zrAKV86uAdRQLNpiiiBO', '7', '20', 'pending', '2024-08-29 15:23:31', '2024-08-29 15:23:31');

INSERT INTO `order` VALUES ('32', 'JhXyU61GpNDyxDKFVS38', '7', '20', 'pending', '2024-08-29 15:23:54', '2024-08-29 15:23:54');

INSERT INTO `order` VALUES ('33', 'bLXP1HvAPA8ZjXhMgnfn', '7', '30', 'pending', '2024-08-29 15:25:26', '2024-08-29 15:25:26');



-- ----------------------------

-- Table structure for sequelizemeta

-- ----------------------------

DROP TABLE IF EXISTS `sequelizemeta`;

CREATE TABLE `sequelizemeta` (

  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`name`),

  UNIQUE KEY `name` (`name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



-- ----------------------------

-- Records of sequelizemeta

-- ----------------------------

INSERT INTO `sequelizemeta` VALUES ('20240820083540-manager.js');

INSERT INTO `sequelizemeta` VALUES ('20240820083759-manager.js');

INSERT INTO `sequelizemeta` VALUES ('20240823020129-user.js');

INSERT INTO `sequelizemeta` VALUES ('20240823090841-gift.js');

INSERT INTO `sequelizemeta` VALUES ('20240824094958-order.js');

INSERT INTO `sequelizemeta` VALUES ('20240824120706-live.js');

INSERT INTO `sequelizemeta` VALUES ('20240825022236-live_user.js');

INSERT INTO `sequelizemeta` VALUES ('20240825071039-live_gift.js');

INSERT INTO `sequelizemeta` VALUES ('20240825073252-comment.js');



-- ----------------------------

-- Table structure for user

-- ----------------------------

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (

  `id` int(20) NOT NULL AUTO_INCREMENT,

  `name` varchar(255) COLLATE utf8mb4_unicode_520_nopad_ci DEFAULT NULL,

  `username` varchar(30) COLLATE utf8mb4_unicode_520_nopad_ci NOT NULL DEFAULT '' COMMENT '用户名',

  `password` varchar(255) COLLATE utf8mb4_unicode_520_nopad_ci NOT NULL DEFAULT '' COMMENT '密码',

  `avatar` varchar(255) COLLATE utf8mb4_unicode_520_nopad_ci DEFAULT '' COMMENT '头像',

  `coin` int(11) NOT NULL DEFAULT 0 COMMENT '金币',

  `created_time` datetime DEFAULT NULL,

  `updated_time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `username` (`username`)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_nopad_ci;



-- ----------------------------

-- Records of user

-- ----------------------------

INSERT INTO `user` VALUES ('3', '黄家驹', 'huangjiaju', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/g929pmeba940000.png', '-3', '2024-08-23 15:07:22', '2024-08-30 20:33:32');

INSERT INTO `user` VALUES ('4', '黄家强', 'huangjiaqiang', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/g7agyu9ac5c0000.jpeg', '0', '2024-08-24 22:29:46', '2024-08-24 22:29:46');

INSERT INTO `user` VALUES ('5', '黄贯中', 'huangguanzhong', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/49mmno1i32o0000.jpg', '0', '2024-08-24 22:30:04', '2024-08-24 22:30:04');

INSERT INTO `user` VALUES ('6', '叶世荣', 'yeshirong', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/22e11uwz96dc000.jpeg', '0', '2024-08-24 22:30:26', '2024-08-24 22:30:26');

INSERT INTO `user` VALUES ('7', '超级管理员', 'admin', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 'http://wangshuo-web1.oss-cn-beijing.aliyuncs.com/egg-oss-demo/5vbmwmbfe6c0000.jpeg', '103', '2024-08-26 15:55:12', '2024-08-30 21:47:43');
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/absolute822/cat-live-streaming.git
git@gitee.com:absolute822/cat-live-streaming.git
absolute822
cat-live-streaming
猫咪直播
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部