/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 50650
Source Host : localhost:3306
Source Schema : tongxun
Target Server Type : MySQL
Target Server Version : 50650
File Encoding : 65001
Date: 19/04/2021 09:24:14
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for friends
-- ----------------------------
DROP TABLE IF EXISTS `friends`;
CREATE TABLE `friends` (
`friend_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`my_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`friends` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`friend_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0聊天1未聊天',
PRIMARY KEY (`friend_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of friends
-- ----------------------------
INSERT INTO `friends` VALUES ('2103311338215130726422', '21033113382151307264', '21040603198859345920', '0');
INSERT INTO `friends` VALUES ('2104072055338773708818', '21033113382151307264', '21033113382151307264', '1');
INSERT INTO `friends` VALUES ('21040720553387737088182', '21033113382151307264', '21040601474467725312', '0');
INSERT INTO `friends` VALUES ('210407205533877370888', '21040720553385639936', '21040720553385639936', '1');
INSERT INTO `friends` VALUES ('2104072055338773708882', '21040601474467725312', '21033113382151307264', '0');
INSERT INTO `friends` VALUES ('210411126261414330368', '21033113382151307264', '21040717741239025664', '1');
INSERT INTO `friends` VALUES ('210411137053811507200', '21040717741239025664', '21033113382151307264', '0');
INSERT INTO `friends` VALUES ('210411166078470684672', '21040603198859345920', '21033113382151307264', '0');
INSERT INTO `friends` VALUES ('210412831302244761608', '21041283130222379008', '21041283130222379008', '1');
-- ----------------------------
-- Table structure for keep
-- ----------------------------
DROP TABLE IF EXISTS `keep`;
CREATE TABLE `keep` (
`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`fromid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送者id',
`toid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收者id',
`createtime` datetime(0) NULL DEFAULT NULL,
`msg` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`msgtype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息类型1文本2语言3图片',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of keep
-- ----------------------------
INSERT INTO `keep` VALUES ('11nm6eieiqcg000', '21033113382151307264', '21040601474467725312', '2021-04-12 13:34:45', 'http://192.168.128.101:8080/img/1618205685361_274.jpg', '1', '3');
INSERT INTO `keep` VALUES ('120n1q8tln0g000', '21040601474467725312', '21033113382151307264', '2021-04-12 12:18:39', 'http://192.168.128.101:8080/img/1618201119076_662.png', '0', '3');
INSERT INTO `keep` VALUES ('2h8kv4syku00000', '21033113382151307264', '21040603198859345920', '2021-04-11 22:50:45', '你好', '1', '1');
INSERT INTO `keep` VALUES ('2njzoxapkdi0000', '21040601474467725312', '21033113382151307264', '2021-04-12 13:35:02', 'http://192.168.128.101:8080/img/1618205702018_9.jpg', '0', '3');
INSERT INTO `keep` VALUES ('2ttgpqfwtas0000', '21040603198859345920', '21033113382151307264', '2021-04-12 00:06:41', '5959', '0', '1');
INSERT INTO `keep` VALUES ('336gnl8i50o0000', '21040603198859345920', '21033113382151307264', '2021-04-12 00:09:43', 'de shabi', '1', '1');
INSERT INTO `keep` VALUES ('36aud0565nc0000', '21040603198859345920', '21033113382151307264', '2021-04-11 22:50:45', '你好', '0', '1');
INSERT INTO `keep` VALUES ('3i34nh493mw0000', '21040603198859345920', '21033113382151307264', '2021-04-12 13:33:19', '你好', '0', '1');
INSERT INTO `keep` VALUES ('3vimdpmp0540000', '21033113382151307264', '21040603198859345920', '2021-04-12 00:06:28', '5959', '1', '1');
INSERT INTO `keep` VALUES ('44vl93mkftk0000', '21040603198859345920', '21033113382151307264', '2021-04-12 13:17:50', '测试', '0', '1');
INSERT INTO `keep` VALUES ('4fqgvxr5pgq0000', '21040603198859345920', '21033113382151307264', '2021-04-12 13:28:46', '测试', '1', '1');
INSERT INTO `keep` VALUES ('5w8l2enprbc0000', '21040601474467725312', '21033113382151307264', '2021-04-12 13:34:45', 'http://192.168.128.101:8080/img/1618205685361_274.jpg', '0', '3');
INSERT INTO `keep` VALUES ('6ijc1sie44g0000', '21033113382151307264', '21040603198859345920', '2021-04-19 09:23:12', '收到', '1', '1');
INSERT INTO `keep` VALUES ('6voshn0b09w0000', '21033113382151307264', '21040717741239025664', '2021-04-12 13:42:02', '你好', '0', '1');
INSERT INTO `keep` VALUES ('7b9anj00abo0000', '21033113382151307264', '21040603198859345920', '2021-04-12 00:06:49', '5959', '1', '1');
INSERT INTO `keep` VALUES ('7dfh7m2ohsw0000', '21040603198859345920', '21033113382151307264', '2021-04-12 13:30:12', 'nihao', '0', '1');
INSERT INTO `keep` VALUES ('7fwrcodajio0000', '21040603198859345920', '21033113382151307264', '2021-04-12 13:15:17', 'ces', '0', '1');
INSERT INTO `keep` VALUES ('7jmamtddojk0000', '21033113382151307264', '21040603198859345920', '2021-04-12 13:33:19', '你好', '1', '1');
INSERT INTO `keep` VALUES ('7ma0dohk2lw0000', '21040603198859345920', '21033113382151307264', '2021-04-12 00:09:40', 'louxia', '1', '1');
INSERT INTO `keep` VALUES ('7n250ra91g00000', '21033113382151307264', '21040603198859345920', '2021-04-12 13:30:18', '你好', '0', '1');
INSERT INTO `keep` VALUES ('7tkj1stu7ro0000', '21040603198859345920', '21033113382151307264', '2021-04-12 00:06:49', '5959', '0', '1');
INSERT INTO `keep` VALUES ('7wgn3uwvhkc0000', '21040603198859345920', '21033113382151307264', '2021-04-19 09:23:12', '收到', '0', '1');
INSERT INTO `keep` VALUES ('86j5mmwznto0000', '21040603198859345920', '21033113382151307264', '2021-04-12 00:06:47', '5959', '0', '1');
INSERT INTO `keep` VALUES ('8ykanr3mhu80000', '21040603198859345920', '21033113382151307264', '2021-04-12 00:06:39', '5959', '0', '1');
INSERT INTO `keep` VALUES ('9406x0xro4k0000', NULL, '21033113382151307264', '2021-04-12 13:19:44', '的东西', '1', '1');
INSERT INTO `keep` VALUES ('a1rv9v258a00000', '21033113382151307264', '21040603198859345920', '2021-04-12 13:30:12', 'nihao', '1', '1');
INSERT INTO `keep` VALUES ('a40cu57j7b40000', '21033113382151307264', '21040603198859345920', '2021-04-12 00:09:36', 'nima ', '0', '1');
INSERT INTO `keep` VALUES ('a7hbdtbo3ks0000', '21040601474467725312', '21033113382151307264', '2021-04-12 12:20:24', 'http://192.168.128.101:8080/img/1618201224721_57.jpg', '0', '3');
INSERT INTO `keep` VALUES ('ak3bs9egefs000', '21040603198859345920', '21033113382151307264', '2021-04-12 00:09:33', '卧槽', '0', '1');
INSERT INTO `keep` VALUES ('amzne18878g0000', '21033113382151307264', '21040603198859345920', '2021-04-12 00:06:41', '5959', '1', '1');
INSERT INTO `keep` VALUES ('aqw3l21dz000000', '21040603198859345920', '21033113382151307264', '2021-04-12 13:30:06', '测试', '1', '1');
INSERT INTO `keep` VALUES ('b0f6betadfs0000', '21040603198859345920', '21033113382151307264', '2021-04-12 00:09:36', 'nima ', '1', '1');
INSERT INTO `keep` VALUES ('b1v3frmevso0000', '21033113382151307264', '21040603198859345920', '2021-04-12 13:15:17', 'ces', '1', '1');
INSERT INTO `keep` VALUES ('b4d8w8ufg28000', '21033113382151307264', '210406031988593
通讯app前后端.rar
1星 需积分: 0 65 浏览量
2021-04-21
18:48:31
上传
评论 2
收藏 290.16MB RAR 举报
weixin_45310749
- 粉丝: 0
- 资源: 1
最新资源
- Cesium 高程为0的地形数据
- 国产化神通数据库-数据库开发手册
- Oracle数据库备份与恢复教程.zip
- 苹果闹铃音乐苹果闹铃音乐
- Unity导入Excel文件自动创建class文件和ScriptObject文件,并转化成ScriptObject的插件pro版
- UE4仅k位移产生完美行走动作-UE4项目
- 基于 Python 的校园导航系统
- tensorflow-2.6.3-cp37-cp37m-manylinux2010-x86-64.whl
- tensorflow-2.6.2-cp39-cp39-win-amd64.whl
- tensorflow-2.6.2-cp39-cp39-manylinux2010-x86-64.whl
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
评论1