/*
Navicat Premium Data Transfer
Source Server : 124.222.4.40（yxc腾讯云）
Source Server Type : MySQL
Source Server Version : 50726
Source Host : 124.222.4.40:3306
Source Schema : im
Target Server Type : MySQL
Target Server Version : 50726
File Encoding : 65001
Date: 18/02/2024 16:17:33
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
`id` int(10) UNSIGNED NOT NULL,
`parentid` int(10) UNSIGNED NULL DEFAULT NULL,
`node` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`level` tinyint(4) NOT NULL COMMENT '1级：省、直辖市、自治区\\r\\n2级：地级市\\r\\n3级：市辖区、县（旗）、县级市、自治县（自治旗）、特区、林区\\r\\n4级：镇、乡、民族乡、县辖区、街道\\r\\n5级：村、居委会',
`lng` double(8, 2) NOT NULL COMMENT '经度',
`lat` double(8, 2) NOT NULL COMMENT '纬度',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES (110000, NULL, NULL, '北京', 1, 116.41, 39.90);
INSERT INTO `area` VALUES (110100, 110000, '110000', '北京市', 2, 116.41, 39.90);
INSERT INTO `area` VALUES (110101, 110100, '110000,110100', '东城区', 3, 116.42, 39.93);
INSERT INTO `area` VALUES (110102, 110100, '110000,110100', '西城区', 3, 116.37, 39.91);
INSERT INTO `area` VALUES (110105, 110100, '110000,110100', '朝阳区', 3, 116.44, 39.92);
INSERT INTO `area` VALUES (110106, 110100, '110000,110100', '丰台区', 3, 116.29, 39.86);
INSERT INTO `area` VALUES (110107, 110100, '110000,110100', '石景山区', 3, 116.22, 39.91);
INSERT INTO `area` VALUES (110108, 110100, '110000,110100', '海淀区', 3, 116.30, 39.96);
INSERT INTO `area` VALUES (110109, 110100, '110000,110100', '门头沟区', 3, 116.10, 39.94);
INSERT INTO `area` VALUES (110111, 110100, '110000,110100', '房山区', 3, 116.14, 39.75);
INSERT INTO `area` VALUES (110112, 110100, '110000,110100', '通州区', 3, 116.66, 39.91);
INSERT INTO `area` VALUES (110113, 110100, '110000,110100', '顺义区', 3, 116.65, 40.13);
INSERT INTO `area` VALUES (110114, 110100, '110000,110100', '昌平区', 3, 116.23, 40.22);
INSERT INTO `area` VALUES (110115, 110100, '110000,110100', '大兴区', 3, 116.34, 39.73);
INSERT INTO `area` VALUES (110116, 110100, '110000,110100', '怀柔区', 3, 116.63, 40.32);
INSERT INTO `area` VALUES (110117, 110100, '110000,110100', '平谷区', 3, 117.12, 40.14);
INSERT INTO `area` VALUES (110118, 110100, '110000,110100', '密云区', 3, 116.84, 40.38);
INSERT INTO `area` VALUES (110119, 110100, '110000,110100', '延庆区', 3, 115.98, 40.46);
INSERT INTO `area` VALUES (120000, NULL, NULL, '天津', 1, 117.20, 39.09);
INSERT INTO `area` VALUES (120100, 120000, '120000', '天津市', 2, 117.20, 39.09);
INSERT INTO `area` VALUES (120101, 120100, '120000,120100', '和平区', 3, 117.21, 39.12);
INSERT INTO `area` VALUES (120102, 120100, '120000,120100', '河东区', 3, 117.25, 39.13);
INSERT INTO `area` VALUES (120103, 120100, '120000,120100', '河西区', 3, 117.22, 39.11);
INSERT INTO `area` VALUES (120104, 120100, '120000,120100', '南开区', 3, 117.15, 39.14);
INSERT INTO `area` VALUES (120105, 120100, '120000,120100', '河北区', 3, 117.20, 39.15);
INSERT INTO `area` VALUES (120106, 120100, '120000,120100', '红桥区', 3, 117.15, 39.17);
INSERT INTO `area` VALUES (120110, 120100, '120000,120100', '东丽区', 3, 117.31, 39.09);
INSERT INTO `area` VALUES (120111, 120100, '120000,120100', '西青区', 3, 117.01, 39.14);
INSERT INTO `area` VALUES (120112, 120100, '120000,120100', '津南区', 3, 117.36, 38.94);
INSERT INTO `area` VALUES (120113, 120100, '120000,120100', '北辰区', 3, 117.14, 39.22);
INSERT INTO `area` VALUES (120114, 120100, '120000,120100', '武清区', 3, 117.04, 39.38);
INSERT INTO `area` VALUES (120115, 120100, '120000,120100', '宝坻区', 3, 117.31, 39.72);
INSERT INTO `area` VALUES (120116, 120100, '120000,120100', '滨海新区', 3, 117.71, 39.00);
INSERT INTO `area` VALUES (120117, 120100, '120000,120100', '宁河区', 3, 117.82, 39.33);
INSERT INTO `area` VALUES (120118, 120100, '120000,120100', '静海区', 3, 116.97, 38.95);
INSERT INTO `area` VALUES (120119, 120100, '120000,120100', '蓟州区', 3, 117.41, 40.05);
INSERT INTO `area` VALUES (130000, NULL, NULL, '河北省', 1, 114.47, 38.04);
INSERT INTO `area` VALUES (130100, 130000, '130000', '石家庄市', 2, 114.51, 38.04);
INSERT INTO `area` VALUES (130102, 130100, '130000,130100', '长安区', 3, 114.54, 38.04);
INSERT INTO `area` VALUES (130104, 130100, '130000,130100', '桥西区', 3, 114.46, 38.00);
INSERT INTO `area` VALUES (130105, 130100, '130000,130100', '新华区', 3, 114.46, 38.05);
INSERT INTO `area` VALUES (130107, 130100, '130000,130100', '井陉矿区', 3, 114.06, 38.06);
INSERT INTO `area` VALUES (130108, 130100, '130000,130100', '裕华区', 3, 114.53, 38.01);
INSERT INTO `area` VALUES (130109, 130100, '130000,130100', '藁城区', 3, 114.85, 38.02);
INSERT INTO `area` VALUES (130110, 130100, '130000,130100', '鹿泉区', 3, 114.31, 38.09);
INSERT INTO `area` VALUES (130111, 130100, '130000,130100', '栾城区', 3, 114.65, 37.90);
INSERT INTO `area` VALUES (130121, 130100, '130000,130100', '井陉县', 3, 114.15, 38.03);
INSERT INTO `area` VALUES (130123, 130100, '130000,130100', '正定县', 3, 114.57, 38.15);
INSERT INTO `area` VALUES (130125, 130100, '130000,130100', '行唐县', 3, 114.55, 38.44);
INSERT INTO `area` VALUES (130126, 130100, '130000,130100', '灵寿县', 3, 114.38, 38.31);
INSERT INTO `area` VALUES (130127, 130100, '130000,130100', '高邑县', 3, 114.61, 37.61);
INSERT INTO `area` VALUES (130128, 130100, '130000,130100', '深泽县', 3, 115.20, 38.18);
INSERT INTO `area` VALUES (130129, 130100, '130000,130100', '赞皇县', 3, 114.39, 37.67);
INSERT INTO `area` VALUES (130130, 130100, '130000,130100', '无极县', 3, 114.98, 38.18);
INSERT INTO `area` VALUES (130131, 130100, '130000,130100', '平山县', 3, 114.19, 38.26);
INSERT INTO `area` VALUES (130132, 130100, '130000,130100', '元氏县', 3, 114.53, 37.77);
INSERT INTO `area` VALUES (130133, 130100, '130000,130100', '赵县', 3, 114.78, 37.76);
INSERT INTO `area` VALUES (130183, 130100, '130000,130100', '晋州市', 3, 115.04, 38.03);
INSERT INTO `area` VALUES (130184, 130100, '130000,130100', '新乐市', 3, 114.68, 38.34);
INSERT INTO `area` VALUES (130200, 130000, '130000', '唐山市', 2, 118.18, 39.63);
INSERT INTO `area` VALUES (130202, 130200, '130000,130200', '路南区', 3, 118.15, 39.63);
INSERT INTO `area` VALUES (130203, 130200, '130000,130200', '路北区', 3, 118.20, 39.62);
INSERT INTO `area` VALUES (130204, 130200, '130000,130200', '古冶区', 3, 118.46, 39.72);
INSERT INTO `area` VALUES (130205, 130200, '130000,130200', '开平区', 3, 118.26, 39.67);
INSERT INTO `area` VALUES (130207, 130200, '130000,130200', '丰南区', 3, 118.09, 39.57);
INSERT INTO `area` VALUES (130208, 130200, '130000,130200', '丰润区', 3, 118.16, 39.83);
INSERT INTO `area` VALUES (130209, 130200, '130000,130200', '曹妃甸区', 3, 118.46, 39.27);
INSERT INTO `area` VALUES (130223, 130200, '130000,130200', '滦县', 3, 118.70, 39.74);
INSERT INTO `area` VALUES (130224, 130200, '130000,130200', '滦南县', 3, 118.67, 39.50);
INSERT INTO `area` VALUES (130225, 130200, '130000,130200', '乐亭县', 3, 118.91, 39.43);
INSERT INTO `area` VALUES (130227, 130200, '130000,130200', '迁西县', 3, 118.31, 40.14);
INSERT INTO `area` VALUES (130229, 130200, '130
即时通讯管理系统（Java+SpringBoot+vue+elementui）
版权申诉
52 浏览量
2024-02-18
16:51:00
上传
评论
收藏 74.55MB RAR 举报
即时通讯管理系统（Java+SpringBoot+vue+elementui） （1889个子文件） 
UploadController.class 16KB FriendApplyController.class 14KB ChatController.class 12KB RedisDaoImpl.class 11KB UserController.class 10KB LoginController.class 8KB JwtUtil.class 6KB WebSocketServer.class 6KB BaseMessage.class 6KB ChatServiceImpl.class 6KB BaseUserChatSession.class 6KB merchantmsg.class 6KB PhotoWallController.class 5KB BaseUsers.class 5KB RegisterController.class 5KB ValidateCode.class 5KB PhotoWall.class 5KB Base64EnOut.class 4KB BaseUserContacts.class 4KB StringUtils.class 4KB CurrUser.class 4KB BaseSysRole.class 4KB UserServiceImpl.class 4KB DataSourceConfig.class 4KB AvatarHistory.class 4KB DateUtils.class 4KB BaseController.class 4KB AESUtil.class 4KB IpUtils.class 4KB BaseNController.class 3KB Result.class 3KB AuthTokenInterceptor.class 3KB getRequestPayloadUtil.class 3KB NewFriend.class 3KB ListMapToTree.class 3KB BaseSysUserRole.class 3KB Login.class 3KB RecordModelGenerator.class 3KB RedisDao.class 3KB Register.class 3KB IntfDataOpTypeEnum.class 3KB VouDetailCreateActionEnum.class 3KB location.class 3KB PayOpStatusEnum.class 2KB ResultEnum.class 2KB UnreadCount.class 2KB CamelUtils.class 2KB OptTypeEnum.class 2KB PayStatusEnum.class 2KB UserList.class 2KB MsgHis.class 2KB IntfDataAmtTypeEnum.class 2KB VouModelTaxSubjectEnum.class 2KB IntfDataVouStatusEnum.class 2KB VouSourTypeEnum.class 2KB VouTypeEnum.class 2KB AddUser.class 2KB ImgUpload.class 2KB Base64MultipartFile.class 2KB Arith.class 2KB VoucherStatusEnum.class 2KB WebMvcConfig.class 2KB CorsConfig.class 2KB BalanceDirEnum.class 2KB DeletedEnum.class 2KB StatusEnum.class 2KB FiTypeEnum.class 2KB YesOrNoEnum.class 2KB ReviewEnum.class 2KB SysFile.class 2KB Attachment.class 2KB OrderNo.class 2KB TestController.class 2KB PersonalSign.class 2KB MD5Util.class 2KB Avatar.class 2KB Contact.class 2KB BgCover.class 2KB picture.class 1KB UploadController$1.class 1KB ExcelKit.class 1KB PhotoWallServiceImpl.class 1KB LoginResult.class 1KB Sys.class 1KB AbstractBaseRedisDao.class 1KB SecretUtil.class 1KB LoginServiceImpl.class 1KB RegisterServiceImpl.class 1KB _MappingKit.class 1KB TokenInfo.class 1KB ChatService.class 1KB PageInfo.class 1KB UserService.class 974B _MetaBuilder.class 937B PhotoWallDao.class 772B ImApiApplication.class 730B WebSocketConfig.class 714B AvatarHistoryServiceImpl.class 624B UserChatSession.class 594B UserContacts.class 576B共 1889 条
- 1
- 2
- 3
- 4
- 5
- 6
- 19
资源评论
