首页 开源 资讯 活动 开源许可证
软件工程云服务
软件代码质量检测云服务 持续集成与部署云服务 社区个性化内容推荐服务 贡献审阅人推荐服务 群体化学习服务 重睛鸟代码扫描工具
Watch 1 Star 4 Fork 3

eaglet/social_service_system

代码 Issues 3 Pull Requests 0 Wiki 0 统计
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
克隆/下载
socialdb.sql 104.64 KB
一键复制 编辑 原始数据 按行查看 历史
eaglet 提交于 2024-04-01 13:05 . 更新介绍
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923
/*

 Navicat Premium Data Transfer



 Source Server         : 我的华为云服务器

 Source Server Type    : MySQL

 Source Server Version : 80033

 Source Host           : 120.46.83.148:3306

 Source Schema         : socialdb



 Target Server Type    : MySQL

 Target Server Version : 80033

 File Encoding         : 65001



 Date: 01/12/2023 16:12:09

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



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

-- Table structure for ex_code

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

DROP TABLE IF EXISTS `ex_code`;

CREATE TABLE `ex_code`  (

  `code_id` int NOT NULL AUTO_INCREMENT,

  `user_email` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `code_string` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '',

  `code_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,

  PRIMARY KEY (`code_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 64 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_code

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

INSERT INTO `ex_code` VALUES (7, '317834473@qq.com', '1vpEtX', '2023-10-12 09:06:28');

INSERT INTO `ex_code` VALUES (8, '317834473@qq.com', 'WxN9RG', '2023-10-12 09:10:35');

INSERT INTO `ex_code` VALUES (9, '317834473@qq.com', 'Uxn5pP', '2023-10-12 09:11:41');

INSERT INTO `ex_code` VALUES (10, '317834473@qq.com', 'Zwy7GF', '2023-10-12 09:20:32');

INSERT INTO `ex_code` VALUES (11, '317834473@qq.com', 'USp2Ds', '2023-10-12 09:21:57');

INSERT INTO `ex_code` VALUES (12, '7488719@qq.com', 'Mkp9Pg', '2023-10-31 15:36:08');

INSERT INTO `ex_code` VALUES (13, '', 'zfdN8M', '2023-11-07 10:37:48');

INSERT INTO `ex_code` VALUES (14, '1762612420@qq.com', 'wiF457', '2023-11-07 15:23:06');

INSERT INTO `ex_code` VALUES (15, '2351881368@qq.com', 'FUZj7A', '2023-11-07 15:26:11');

INSERT INTO `ex_code` VALUES (16, '1172842362@qq.com', '7l8FHP', '2023-11-07 16:15:11');

INSERT INTO `ex_code` VALUES (17, '1172842362@qq.com', 'LaS039', '2023-11-07 16:19:08');

INSERT INTO `ex_code` VALUES (18, '2529035579@qq.com', 'et8DhZ', '2023-11-07 16:28:11');

INSERT INTO `ex_code` VALUES (19, '2942216927@qq.com', 'Bfk0KV', '2023-11-07 16:43:59');

INSERT INTO `ex_code` VALUES (20, 'fangxingchao@163.com', 'GfR168', '2023-11-07 20:08:47');

INSERT INTO `ex_code` VALUES (21, 'fangxingchao@163.com', 'kKV3tg', '2023-11-07 20:09:13');

INSERT INTO `ex_code` VALUES (22, '1290008082@qq.com', 'Mwy9i1', '2023-11-07 20:15:23');

INSERT INTO `ex_code` VALUES (23, 'rlam1225@gmail.com', '8Mxurn', '2023-11-07 20:37:10');

INSERT INTO `ex_code` VALUES (24, '1600650397@qq.com', 'pZ2SUH', '2023-11-10 08:21:23');

INSERT INTO `ex_code` VALUES (25, '486490078@qq.com', 'XpB3KJ', '2023-11-10 17:44:13');

INSERT INTO `ex_code` VALUES (26, 'swyuxiangyi@outlook.com', '2L0riG', '2023-11-10 22:22:21');

INSERT INTO `ex_code` VALUES (27, '2771585220@qq.com', 'cBz1At', '2023-11-15 16:27:24');

INSERT INTO `ex_code` VALUES (28, 'fangxingchaotcu@163.com', '0WlHoH', '2023-11-15 21:05:33');

INSERT INTO `ex_code` VALUES (29, 'fangxingchaotcu@163.com', '0qZm1o', '2023-11-15 21:06:29');

INSERT INTO `ex_code` VALUES (30, '', 'jwY0Jp', '2023-11-15 21:13:36');

INSERT INTO `ex_code` VALUES (31, '', 'LyX8wy', '2023-11-15 21:14:07');

INSERT INTO `ex_code` VALUES (32, '1505457259@qq.com', 'SqT5v4', '2023-11-15 21:14:52');

INSERT INTO `ex_code` VALUES (33, '1505457259@qq.com', 'RJWr7Q', '2023-11-15 21:16:31');

INSERT INTO `ex_code` VALUES (34, '1505457259@qq.com', 'FYa0Kc', '2023-11-15 21:16:36');

INSERT INTO `ex_code` VALUES (35, '1505457259@qq.com', 'xZG2Aa', '2023-11-15 21:16:38');

INSERT INTO `ex_code` VALUES (36, '1505457259@qq.com', 'xbU5QG', '2023-11-15 21:16:40');

INSERT INTO `ex_code` VALUES (37, '1505457259@qq.com', 'RDXg8h', '2023-11-15 21:16:42');

INSERT INTO `ex_code` VALUES (38, '1505457259@qq.com', 'C8wiK9', '2023-11-15 21:16:44');

INSERT INTO `ex_code` VALUES (39, '1505457259@qq.com', 'LZSt6q', '2023-11-15 21:16:46');

INSERT INTO `ex_code` VALUES (40, '1505457259@qq.com', 'Jd9GR2', '2023-11-15 21:16:47');

INSERT INTO `ex_code` VALUES (41, '1505457259@qq.com', '6NrQZc', '2023-11-15 21:16:49');

INSERT INTO `ex_code` VALUES (42, '1505457259@qq.com', 'T26tYn', '2023-11-15 21:16:50');

INSERT INTO `ex_code` VALUES (43, '1505457259@qq.com', 'Fqn55D', '2023-11-15 21:16:52');

INSERT INTO `ex_code` VALUES (44, '1505457259@qq.com', 'u7Sbkw', '2023-11-15 21:16:53');

INSERT INTO `ex_code` VALUES (45, '1505457259@qq.com', 'M3scbe', '2023-11-15 21:16:55');

INSERT INTO `ex_code` VALUES (46, '1505457259@qq.com', 'gVM2jR', '2023-11-15 21:16:56');

INSERT INTO `ex_code` VALUES (47, '1505457259@qq.com', 'Ro2j9Z', '2023-11-15 21:16:57');

INSERT INTO `ex_code` VALUES (48, '1505457259@qq.com', 'SqA5ub', '2023-11-15 21:16:58');

INSERT INTO `ex_code` VALUES (49, 'fangxingchaotcu@163.com', 'qPJ2z4', '2023-11-15 21:17:14');

INSERT INTO `ex_code` VALUES (50, '1505457259@qq.com', 'kEB6zB', '2023-11-15 21:17:56');

INSERT INTO `ex_code` VALUES (51, 'fangxc@asiainfo.com', 'rolO7A', '2023-11-15 21:18:45');

INSERT INTO `ex_code` VALUES (52, '1505457259@qq.com', 'oYu0NK', '2023-11-15 21:19:19');

INSERT INTO `ex_code` VALUES (53, '1505457259@qq.com', 'SWy8Ey', '2023-11-15 21:19:30');

INSERT INTO `ex_code` VALUES (54, 'fangxingchaotcu@163.com', 'X4WnGS', '2023-11-15 21:20:07');

INSERT INTO `ex_code` VALUES (55, 'fangxingchaotcu@163.com', 'ykB45E', '2023-11-15 21:26:03');

INSERT INTO `ex_code` VALUES (56, '11111@qq.com', 'eNA23T', '2023-11-15 21:26:22');

INSERT INTO `ex_code` VALUES (57, 'fangxingchaotcu@163.com', '06bAvf', '2023-11-18 10:22:53');

INSERT INTO `ex_code` VALUES (58, 'fangxingchaotcu@163.com', '8AUn8V', '2023-11-18 23:27:36');

INSERT INTO `ex_code` VALUES (59, '', 'Ra8Jkg', '2023-11-18 23:46:48');

INSERT INTO `ex_code` VALUES (60, '859511661@qq.com', 'B5Yrd0', '2023-11-23 14:41:11');

INSERT INTO `ex_code` VALUES (61, '1578164799@qq.com', 'mIr0zK', '2023-11-24 11:00:46');

INSERT INTO `ex_code` VALUES (62, '1578164799@qq.com', 'Foa0uV', '2023-11-24 11:03:14');

INSERT INTO `ex_code` VALUES (63, '3506704365@qq.com', 'Qii3mN', '2023-11-27 14:22:38');

INSERT INTO `ex_code` VALUES (64, 'whxsw@qq.com', 'fnzE2x', '2023-11-30 10:07:38');



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

-- Table structure for ex_fanslist

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

DROP TABLE IF EXISTS `ex_fanslist`;

CREATE TABLE `ex_fanslist`  (

  `fans_id` bigint NOT NULL AUTO_INCREMENT,

  `fans_fo_id` bigint NULL DEFAULT NULL,

  `fo_id` bigint NULL DEFAULT NULL,

  `fo_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,

  PRIMARY KEY (`fans_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 97 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_fanslist

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

INSERT INTO `ex_fanslist` VALUES (22, 4, 1, '2023-11-14 10:31:41');

INSERT INTO `ex_fanslist` VALUES (25, 2, 1, '2023-11-14 10:31:41');

INSERT INTO `ex_fanslist` VALUES (26, 1, 2, '2023-11-14 10:31:41');

INSERT INTO `ex_fanslist` VALUES (28, 5, 1, '2023-11-14 14:21:56');

INSERT INTO `ex_fanslist` VALUES (30, 1, 6, '2023-11-14 15:14:22');

INSERT INTO `ex_fanslist` VALUES (32, 2, 6, '2023-11-14 17:10:42');

INSERT INTO `ex_fanslist` VALUES (33, 1, 3, '2023-11-15 16:40:53');

INSERT INTO `ex_fanslist` VALUES (75, 1, 15, '2023-11-18 23:10:33');

INSERT INTO `ex_fanslist` VALUES (84, 3, 1, '2023-11-22 12:35:54');

INSERT INTO `ex_fanslist` VALUES (85, 15, 1, '2023-11-22 12:36:29');

INSERT INTO `ex_fanslist` VALUES (86, 6, 1, '2023-11-22 12:36:37');

INSERT INTO `ex_fanslist` VALUES (90, 6, 2, '2023-11-23 09:32:26');

INSERT INTO `ex_fanslist` VALUES (93, 3, 2, '2023-11-30 10:20:36');

INSERT INTO `ex_fanslist` VALUES (95, 11, 1, '2023-11-30 16:39:46');

INSERT INTO `ex_fanslist` VALUES (96, 8, 1, '2023-12-01 10:56:26');



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

-- Table structure for ex_hotlist

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

DROP TABLE IF EXISTS `ex_hotlist`;

CREATE TABLE `ex_hotlist`  (

  `hotpost_id` bigint NOT NULL AUTO_INCREMENT,

  `hotpost_title` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `hot_fw_counts` bigint NULL DEFAULT 0,

  `hot_time` datetime NULL DEFAULT NULL,

  PRIMARY KEY (`hotpost_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_hotlist

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



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

-- Table structure for ex_i18n

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

DROP TABLE IF EXISTS `ex_i18n`;

CREATE TABLE `ex_i18n`  (

  `in_id` int NOT NULL AUTO_INCREMENT,

  `in_language` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `in_language_file` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `in_language_text` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`in_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_i18n

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

INSERT INTO `ex_i18n` VALUES (1, 'zh-CN', 'zh', '简体中文');

INSERT INTO `ex_i18n` VALUES (2, 'zh-SG', 'zh', '马新简体');

INSERT INTO `ex_i18n` VALUES (3, 'zh-TW', 'zh', '繁体中文');

INSERT INTO `ex_i18n` VALUES (4, 'zh-HK', 'zh', '繁体中文');

INSERT INTO `ex_i18n` VALUES (5, 'en-US', 'en', '英文');

INSERT INTO `ex_i18n` VALUES (6, 'en-AU', 'en', '英文（澳大利亚）');

INSERT INTO `ex_i18n` VALUES (7, 'en-GB', 'en', '英文（英国）');

INSERT INTO `ex_i18n` VALUES (8, 'en-CA', 'en', '英文（加拿大）');

INSERT INTO `ex_i18n` VALUES (9, 'en-NZ', 'en', '英文（新西兰）');

INSERT INTO `ex_i18n` VALUES (10, 'en-IE', 'en', '英文（爱尔兰）');

INSERT INTO `ex_i18n` VALUES (11, 'en-ZA', 'en', '英文（南非）');

INSERT INTO `ex_i18n` VALUES (12, 'en-JM', 'en', '英文（牙买加）');

INSERT INTO `ex_i18n` VALUES (13, 'en-BZ', 'en', '英文（伯利兹）');

INSERT INTO `ex_i18n` VALUES (14, 'en-TT', 'en', '英文（特立尼达和多巴哥）');

INSERT INTO `ex_i18n` VALUES (15, 'en', 'en', '英文');

INSERT INTO `ex_i18n` VALUES (16, 'it-CH', 'it', '意大利语（瑞士）');

INSERT INTO `ex_i18n` VALUES (17, 'it', 'it', '意大利语');

INSERT INTO `ex_i18n` VALUES (18, 'fr', 'fra', '法语');

INSERT INTO `ex_i18n` VALUES (19, 'fr-BE', 'fra', '法语（比利时）');

INSERT INTO `ex_i18n` VALUES (20, 'fr-CA', 'fra', '法语（加拿大）');

INSERT INTO `ex_i18n` VALUES (21, 'fr-CH', 'fra', '法语（瑞士）');

INSERT INTO `ex_i18n` VALUES (22, 'fr-LU', 'fra', '法语（卢森堡）');

INSERT INTO `ex_i18n` VALUES (23, 'de', 'de', '德语');

INSERT INTO `ex_i18n` VALUES (24, 'de-CH', 'de', '德语（瑞士）');

INSERT INTO `ex_i18n` VALUES (25, 'de-AT', 'de', '德语（奥地利）');

INSERT INTO `ex_i18n` VALUES (26, 'de-LU', 'de', '德语（卢森堡）');

INSERT INTO `ex_i18n` VALUES (27, 'de-LI', 'de', '德语（列支敦士登）');

INSERT INTO `ex_i18n` VALUES (28, 'ru', 'ru', '俄语');

INSERT INTO `ex_i18n` VALUES (29, 'es', 'spa', '西班牙语');



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

-- Table structure for ex_loginrecord

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

DROP TABLE IF EXISTS `ex_loginrecord`;

CREATE TABLE `ex_loginrecord`  (

  `lr_id` bigint NOT NULL AUTO_INCREMENT,

  `user_id` bigint NOT NULL,

  `login_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,

  `logout_time` datetime NULL DEFAULT NULL,

  `online_time` bigint NULL DEFAULT 0,

  `login_ip` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '',

  `login_lan_ip` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `login_location` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '',

  `login_city` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '',

  `login_country` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `login_regionName` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `login_lat` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `login_lon` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`lr_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 136 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_loginrecord

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

INSERT INTO `ex_loginrecord` VALUES (1, 1, '2023-10-13 09:21:18', NULL, 0, '202.22.11.1', NULL, '', '', NULL, NULL, NULL, NULL);

INSERT INTO `ex_loginrecord` VALUES (2, 1, '2023-10-13 09:46:33', NULL, 0, '222.122.11.22', NULL, '', NULL, NULL, NULL, NULL, NULL);

INSERT INTO `ex_loginrecord` VALUES (3, 1, '2023-10-13 09:58:33', NULL, 0, '10.2.185.100', NULL, '', NULL, NULL, NULL, NULL, NULL);

INSERT INTO `ex_loginrecord` VALUES (4, 1, '2023-10-13 10:45:49', NULL, 0, '10.2.185.100', NULL, '', NULL, NULL, NULL, NULL, NULL);

INSERT INTO `ex_loginrecord` VALUES (5, 1, '2023-10-13 10:51:22', NULL, 0, '10.2.185.100', NULL, '', NULL, NULL, NULL, NULL, NULL);

INSERT INTO `ex_loginrecord` VALUES (6, 1, '2023-10-16 13:48:26', NULL, 0, '111.31.210.13', '10.2.185.100', '', '', '', NULL, NULL, NULL);

INSERT INTO `ex_loginrecord` VALUES (7, 1, '2023-10-16 13:50:08', NULL, 0, '111.31.210.13', '10.2.185.100', '', '', '', NULL, NULL, NULL);

INSERT INTO `ex_loginrecord` VALUES (8, 1, '2023-10-16 14:03:22', NULL, 0, '', '10.2.185.100', '', '', '', NULL, NULL, NULL);

INSERT INTO `ex_loginrecord` VALUES (9, 1, '2023-10-16 14:05:16', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', NULL, NULL, NULL);

INSERT INTO `ex_loginrecord` VALUES (10, 1, '2023-10-16 14:12:00', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', NULL, NULL, NULL);

INSERT INTO `ex_loginrecord` VALUES (11, 1, '2023-10-16 14:16:06', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (12, 1, '2023-10-16 16:17:43', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (13, 1, '2023-10-17 08:52:41', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (14, 1, '2023-10-17 11:24:07', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (15, 1, '2023-10-17 15:20:24', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (16, 1, '2023-10-18 11:02:45', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (17, 1, '2023-10-24 14:05:08', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (18, 1, '2023-10-25 14:43:05', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (19, 1, '2023-10-25 15:00:58', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (20, 1, '2023-10-25 15:02:14', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (21, 1, '2023-10-25 15:06:47', NULL, 0, '', '10.2.185.100', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (22, 1, '2023-10-25 15:29:18', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (23, 1, '2023-10-25 15:39:13', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (24, 1, '2023-10-25 16:16:38', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (25, 1, '2023-10-30 08:36:00', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (26, 1, '2023-10-30 15:41:27', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (27, 2, '2023-10-31 15:36:58', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (28, 1, '2023-10-31 17:00:04', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (29, 1, '2023-11-02 08:18:50', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (30, 1, '2023-11-02 08:51:20', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (31, 1, '2023-11-02 13:08:09', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (32, 1, '2023-11-03 08:54:02', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (33, 1, '2023-11-03 14:19:07', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (34, 1, '2023-11-06 12:43:32', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (35, 2, '2023-11-06 13:04:27', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (36, 1, '2023-11-06 16:13:24', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (37, 1, '2023-11-07 10:45:52', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (38, 1, '2023-11-07 11:02:00', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (39, 1, '2023-11-07 12:45:05', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (40, 1, '2023-11-07 13:11:19', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (41, 1, '2023-11-07 14:42:56', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (42, 3, '2023-11-07 15:24:00', NULL, 0, '113.54.203.216', '', '北京市 北京 CERNET', '北京', '中国', '北京市', '39.9042', '116.407');

INSERT INTO `ex_loginrecord` VALUES (43, 4, '2023-11-07 15:26:50', NULL, 0, '60.28.43.170', '10.1.68.235', '天津市 天津 CNC Group CHINA169 Tianjin Province Network', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (44, 1, '2023-11-07 15:28:31', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (45, 5, '2023-11-07 16:19:38', NULL, 0, '111.31.210.12', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (46, 6, '2023-11-07 16:28:36', NULL, 0, '163.123.192.52', '', '亞利桑那州 凤凰城 Tempest Hosting, LLC', '凤凰城', '美国', '亞利桑那州', '33.4168', '-112.0268');

INSERT INTO `ex_loginrecord` VALUES (47, 1, '2023-11-07 17:02:46', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (48, 6, '2023-11-07 17:02:52', NULL, 0, '42.80.76.228', '240e:428:543e:891e:c789:ef88:90b4:eec6', '天津市 天津 ASN for TIANJIN Provincial Net of CT', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (49, 1, '2023-11-07 17:03:33', NULL, 0, '39.144.81.102', '2409:8903:1824:1112:1794:9864:ddf8:af1c', '天津市 大王庄 China Mobile', '大王庄', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_loginrecord` VALUES (50, 3, '2023-11-07 17:13:52', NULL, 0, '117.173.139.146', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (51, 1, '2023-11-07 17:18:31', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (52, 1, '2023-11-07 18:28:06', NULL, 0, '111.32.114.127', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (53, 1, '2023-11-07 19:15:19', NULL, 0, '111.32.114.127', '2409:8a02:1844:8fd1:ac:985:918f:17e0', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (54, 1, '2023-11-07 19:52:02', NULL, 0, '111.32.114.127', '2409:8a02:1844:8fd1:7d14:d2ac:8acb:8cb8', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (55, 8, '2023-11-07 20:15:59', NULL, 0, '42.80.119.166', '240e:428:4820:7804:64b2:3dff:fedc:54c8', '天津市 天津 ASN for TIANJIN Provincial Net of CT', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (56, 9, '2023-11-07 20:37:41', NULL, 0, '70.18.199.24', '', '纽约州 紐約 Verizon Business', '紐約', '美国', '纽约州', '40.7263', '-73.9818');

INSERT INTO `ex_loginrecord` VALUES (57, 5, '2023-11-07 20:38:36', NULL, 0, '221.197.235.56', '2408:8411:5421:f2fb:f4c0:c483:dcc3:542a', '天津市 天津 CNC Group CHINA169 Tianjin Province Network', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (58, 2, '2023-11-08 07:36:14', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (59, 2, '2023-11-08 08:37:12', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (60, 5, '2023-11-08 09:12:30', NULL, 0, '111.31.210.25', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (61, 1, '2023-11-09 08:43:34', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (62, 8, '2023-11-10 00:03:54', NULL, 0, '42.80.95.61', '240e:428:5436:b5d0:3897:d0ff:fe28:2a94', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (63, 10, '2023-11-10 08:22:28', NULL, 0, '221.238.47.87', '', '天津市 天津 ASN for TIANJIN Provincial Net of CT', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (64, 10, '2023-11-10 08:23:12', NULL, 0, '221.238.47.87', '', '天津市 天津 ASN for TIANJIN Provincial Net of CT', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (66, 1, '2023-11-10 15:52:21', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (67, 11, '2023-11-10 16:29:11', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (68, 11, '2023-11-10 16:38:20', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (69, 1, '2023-11-10 16:41:59', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (70, 5, '2023-11-10 17:10:11', NULL, 0, '116.130.191.194', '2408:8411:5448:b40d:80ae:9a12:f89b:82da', '天津市 天津 China Unicom CHINA169 Network', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (71, 12, '2023-11-10 17:47:02', NULL, 0, '180.212.44.169', '', '天津市 天津 ASN for TIANJIN Provincial Net of CT', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (72, 13, '2023-11-10 22:22:52', NULL, 0, '3.99.32.80', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (73, 1, '2023-11-11 11:55:25', NULL, 0, '111.32.114.225', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (74, 1, '2023-11-11 11:58:34', NULL, 0, '111.32.114.225', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (75, 2, '2023-11-11 12:34:57', NULL, 0, '111.32.114.225', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (77, 2, '2023-11-11 12:57:28', NULL, 0, '111.32.114.225', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (78, 6, '2023-11-14 15:14:17', NULL, 0, '42.80.117.194', '', '天津市 天津 ASN for TIANJIN Provincial Net of CT', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (79, 6, '2023-11-14 16:57:19', NULL, 0, '18.176.55.180', '172.19.0.1', 'Tokyo 东京 Amazon Technologies Inc.', '东京', '日本', 'Tokyo', '35.6895', '139.692');

INSERT INTO `ex_loginrecord` VALUES (80, 1, '2023-11-15 09:42:04', NULL, 0, '39.144.82.55', '2409:8903:1b45:7aa:1797:a052:b809:7b3a', '天津市 天津 China Mobile', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (81, 14, '2023-11-15 16:28:01', NULL, 0, '221.238.47.90', '10.2.188.192', '天津市 天津 ASN for TIANJIN Provincial Net of CT', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (82, 6, '2023-11-15 16:28:18', NULL, 0, '42.80.76.166', '240e:428:543e:88ff:e488:feb8:2f8b:334b', '天津市 天津 ASN for TIANJIN Provincial Net of CT', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (83, 5, '2023-11-15 16:40:32', NULL, 0, '221.197.235.56', '2408:8411:5430:b8ee:4def:fea6:6194:70a9', '天津市 天津 CNC Group CHINA169 Tianjin Province Network', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (84, 3, '2023-11-15 16:40:41', NULL, 0, '117.173.139.232', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (85, 5, '2023-11-15 16:43:29', NULL, 0, '60.28.43.169', '', '天津市 天津 CNC Group CHINA169 Tianjin Province Network', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (86, 14, '2023-11-15 16:54:30', NULL, 0, '221.238.47.90', '10.2.188.192', '天津市 天津 ASN for TIANJIN Provincial Net of CT', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (87, 1, '2023-11-15 19:17:29', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (88, 15, '2023-11-15 21:07:00', NULL, 0, '39.144.81.18', '', '天津市 河东 China Mobile', '河东', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_loginrecord` VALUES (89, 15, '2023-11-15 21:20:39', NULL, 0, '39.144.81.18', '', '天津市 河东 China Mobile', '河东', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_loginrecord` VALUES (90, 15, '2023-11-15 21:21:15', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (91, 8, '2023-11-16 10:53:10', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (92, 15, '2023-11-16 13:29:04', NULL, 0, '111.33.241.42', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (93, 15, '2023-11-16 13:30:23', NULL, 0, '116.130.190.234', '2408:8411:5460:66fb:389d:3bb3:500b:c571', '天津市 天津 China Unicom CHINA169 Network', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (94, 15, '2023-11-16 13:41:50', NULL, 0, '', '2408:8411:5460:66fb:389d:3bb3:500b:c571', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (95, 1, '2023-11-17 17:16:28', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (96, 15, '2023-11-17 23:38:30', NULL, 0, '116.130.195.219', '2408:8411:2448:e357:cd5f:2372:c77e:6b7b', '天津市 天津 China Unicom CHINA169 Network', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (97, 15, '2023-11-18 10:33:05', NULL, 0, '39.144.82.57', '', '天津市 天津 China Mobile', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (98, 15, '2023-11-18 10:34:54', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (99, 15, '2023-11-18 10:42:43', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (100, 15, '2023-11-18 11:12:03', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (101, 1, '2023-11-19 18:24:25', NULL, 0, '111.33.200.70', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (102, 1, '2023-11-20 09:43:11', NULL, 0, '', '10.2.185.100', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (103, 1, '2023-11-20 09:49:28', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (104, 1, '2023-11-20 09:58:10', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (105, 15, '2023-11-20 18:01:47', NULL, 0, '111.33.241.244', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (106, 1, '2023-11-21 00:39:59', NULL, 0, '103.20.198.102', '', 'Tokyo Chiyoda 1nextnet Hosting', 'Chiyoda', '日本', 'Tokyo', '35.694', '139.754');

INSERT INTO `ex_loginrecord` VALUES (107, 1, '2023-11-21 07:18:28', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (108, 1, '2023-11-21 17:30:36', NULL, 0, '39.144.82.42', '2409:8903:5704:729:1799:9807:3fae:bc46', '天津市 天津 China Mobile', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (109, 2, '2023-11-22 08:35:54', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (110, 1, '2023-11-22 08:38:32', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (111, 3, '2023-11-22 14:30:26', NULL, 0, '39.144.137.52', '', '四川省 成都 China Mobile', '成都', '中国', '四川省', '30.6498', '104.0555');

INSERT INTO `ex_loginrecord` VALUES (112, 1, '2023-11-22 21:31:48', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (113, 2, '2023-11-23 08:11:16', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (114, 1, '2023-11-23 13:27:38', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (115, 1, '2023-11-23 13:36:14', NULL, 0, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (116, 16, '2023-11-23 14:44:55', NULL, 0, '27.223.78.116', '', '山东省 青岛市 China Unicom Shandong Province Network', '青岛市', '中国', '山东省', '36.061', '120.3814');

INSERT INTO `ex_loginrecord` VALUES (117, 17, '2023-11-24 11:03:38', NULL, 0, '42.80.110.55', '', '天津市 天津 ASN for TIANJIN Provincial Net of CT', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (118, 1, '2023-11-24 15:52:18', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (119, 1, '2023-11-24 16:28:16', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (120, 1, '2023-11-24 16:31:45', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (121, 1, '2023-11-27 10:08:45', NULL, 0, '39.144.82.5', '2409:8903:1b24:d85:179b:4a5a:de82:844', '天津市 天津 China Mobile', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (122, 18, '2023-11-27 14:23:06', NULL, 0, '60.28.43.166', '', '天津市 天津 CNC Group CHINA169 Tianjin Province Network', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (123, 18, '2023-11-27 15:23:06', NULL, 0, '60.28.43.166', '', '天津市 天津 CNC Group CHINA169 Tianjin Province Network', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (124, 11, '2023-11-27 16:46:29', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (125, 4, '2023-11-27 17:23:46', NULL, 0, '111.31.210.9', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (126, 1, '2023-11-29 08:13:14', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (127, 2, '2023-11-29 16:49:34', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (128, 3, '2023-11-29 17:00:24', NULL, 0, '117.173.139.238', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (129, 11, '2023-11-29 18:30:54', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (130, 2, '2023-11-30 08:41:02', NULL, 0, '111.31.210.13', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (131, 19, '2023-11-30 10:08:19', NULL, 0, '116.130.192.246', '2408:8411:5448:ac69:1482:ec70:6286:38e8', '天津市 天津 China Unicom CHINA169 Network', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (132, 11, '2023-11-30 11:21:12', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (133, 1, '2023-11-30 11:22:31', NULL, 0, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_loginrecord` VALUES (134, 8, '2023-12-01 09:26:06', NULL, 0, '60.29.166.122', '', '天津市 天津 CNC Group CHINA169 Tianjin Province Network', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_loginrecord` VALUES (135, 8, '2023-12-01 09:27:39', NULL, 0, '', '', '', '', '', '', '', '');

INSERT INTO `ex_loginrecord` VALUES (136, 11, '2023-12-01 15:05:06', NULL, 0, '112.45.96.209', '', '', '', '', '', '', '');



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

-- Table structure for ex_notify

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

DROP TABLE IF EXISTS `ex_notify`;

CREATE TABLE `ex_notify`  (

  `notify_id` bigint NOT NULL AUTO_INCREMENT,

  `post_id` bigint NULL DEFAULT 0,

  `post_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,

  `is_reply` int NULL DEFAULT 0,

  `is_quote` int NULL DEFAULT 0,

  `is_liked` int NULL DEFAULT 0,

  `is_foyou` int NULL DEFAULT 0,

  `opr_user_id` bigint NULL DEFAULT 0,

  `current_user_id` bigint NULL DEFAULT 0,

  `is_readed` int NULL DEFAULT 0,

  `notify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,

  PRIMARY KEY (`notify_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_notify

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

INSERT INTO `ex_notify` VALUES (1, 0, NULL, 0, 0, 0, 1, 1, 3, 1, '2023-11-22 12:35:54');

INSERT INTO `ex_notify` VALUES (2, 0, NULL, 0, 0, 0, 1, 1, 15, 0, '2023-11-22 12:36:29');

INSERT INTO `ex_notify` VALUES (3, 0, NULL, 0, 0, 0, 1, 1, 6, 0, '2023-11-22 12:36:37');

INSERT INTO `ex_notify` VALUES (4, 187, NULL, 0, 0, 1, 0, 1, 3, 1, '2023-11-22 12:38:35');

INSERT INTO `ex_notify` VALUES (5, 186, NULL, 0, 0, 1, 0, 1, 4, 1, '2023-11-22 12:38:40');

INSERT INTO `ex_notify` VALUES (6, 255, NULL, 0, 0, 1, 0, 3, 1, 1, '2023-11-22 14:34:14');

INSERT INTO `ex_notify` VALUES (7, 254, NULL, 0, 0, 1, 0, 3, 1, 1, '2023-11-22 14:34:17');

INSERT INTO `ex_notify` VALUES (8, 250, '[2023_20]', 1, 0, 0, 0, 3, 1, 1, '2023-11-22 14:35:02');

INSERT INTO `ex_notify` VALUES (9, 250, '芜湖', 0, 1, 0, 0, 3, 1, 1, '2023-11-22 14:39:23');

INSERT INTO `ex_notify` VALUES (10, 256, NULL, 0, 0, 1, 0, 1, 3, 1, '2023-11-22 17:20:54');

INSERT INTO `ex_notify` VALUES (11, 259, NULL, 0, 0, 1, 0, 1, 3, 1, '2023-11-22 17:20:58');

INSERT INTO `ex_notify` VALUES (12, 256, '1.问题\r\n2.概念/方法\r\n3.实现\r\n4.效果\r\n5.思考改进\r\n6.实现\r\n7.效果\r\n8.总结\r\n[2023_14]', 1, 0, 0, 0, 1, 3, 1, '2023-11-22 21:35:04');

INSERT INTO `ex_notify` VALUES (13, 261, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-22 21:36:06');

INSERT INTO `ex_notify` VALUES (14, 0, NULL, 0, 0, 0, 1, 2, 6, 0, '2023-11-23 08:24:19');

INSERT INTO `ex_notify` VALUES (15, 263, NULL, 0, 0, 1, 0, 2, NULL, 0, '2023-11-23 13:17:02');

INSERT INTO `ex_notify` VALUES (16, 263, NULL, 0, 0, 1, 0, 2, NULL, 0, '2023-11-23 13:17:21');

INSERT INTO `ex_notify` VALUES (17, 263, NULL, 0, 0, 1, 0, 2, NULL, 0, '2023-11-23 13:22:33');

INSERT INTO `ex_notify` VALUES (18, 262, '测试内容', 1, 0, 0, 0, 2, 1, 1, '2023-11-23 13:22:50');

INSERT INTO `ex_notify` VALUES (19, 263, NULL, 0, 0, 1, 0, 2, NULL, 0, '2023-11-23 13:32:07');

INSERT INTO `ex_notify` VALUES (20, 263, NULL, 0, 0, 1, 0, 2, NULL, 0, '2023-11-23 13:35:04');

INSERT INTO `ex_notify` VALUES (21, 262, '发布测试111点赞', 1, 0, 0, 0, 2, 1, 1, '2023-11-23 13:35:44');

INSERT INTO `ex_notify` VALUES (22, 266, NULL, 0, 0, 1, 0, 2, NULL, 0, '2023-11-23 13:35:48');

INSERT INTO `ex_notify` VALUES (23, 267, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 13:36:39');

INSERT INTO `ex_notify` VALUES (24, 267, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 13:36:55');

INSERT INTO `ex_notify` VALUES (25, 267, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 13:37:10');

INSERT INTO `ex_notify` VALUES (26, 266, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 13:39:45');

INSERT INTO `ex_notify` VALUES (27, 267, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 13:39:56');

INSERT INTO `ex_notify` VALUES (28, 267, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 13:40:38');

INSERT INTO `ex_notify` VALUES (29, 266, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 13:44:14');

INSERT INTO `ex_notify` VALUES (30, 263, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 13:53:08');

INSERT INTO `ex_notify` VALUES (31, 262, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 13:53:49');

INSERT INTO `ex_notify` VALUES (32, 266, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 14:00:23');

INSERT INTO `ex_notify` VALUES (33, 270, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 14:09:20');

INSERT INTO `ex_notify` VALUES (34, 269, NULL, 0, 0, 1, 0, 2, 3, 1, '2023-11-23 14:14:42');

INSERT INTO `ex_notify` VALUES (35, 266, NULL, 0, 0, 1, 0, 2, NULL, 0, '2023-11-23 14:16:34');

INSERT INTO `ex_notify` VALUES (36, 270, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 15:10:32');

INSERT INTO `ex_notify` VALUES (37, 269, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-11-23 15:10:51');

INSERT INTO `ex_notify` VALUES (38, 271, NULL, 0, 0, 1, 0, 1, 2, 1, '2023-11-23 15:10:56');

INSERT INTO `ex_notify` VALUES (39, 256, NULL, 0, 0, 1, 0, 1, 3, 1, '2023-11-23 15:11:09');

INSERT INTO `ex_notify` VALUES (40, 276, NULL, 0, 0, 1, 0, 1, 3, 1, '2023-11-27 13:17:03');

INSERT INTO `ex_notify` VALUES (41, 279, NULL, 0, 0, 1, 0, 1, 4, 1, '2023-11-27 17:25:18');

INSERT INTO `ex_notify` VALUES (42, 279, '[2023_43]', 0, 1, 0, 0, 1, 4, 0, '2023-11-27 17:26:15');

INSERT INTO `ex_notify` VALUES (43, 0, NULL, 0, 0, 0, 1, 11, 1, 1, '2023-11-29 18:31:09');

INSERT INTO `ex_notify` VALUES (44, 279, NULL, 0, 0, 1, 0, 11, 4, 0, '2023-11-29 18:32:23');

INSERT INTO `ex_notify` VALUES (45, 277, NULL, 0, 0, 1, 0, 11, 1, 1, '2023-11-29 18:32:31');

INSERT INTO `ex_notify` VALUES (46, 0, NULL, 0, 0, 0, 1, 11, 4, 0, '2023-11-29 18:37:28');

INSERT INTO `ex_notify` VALUES (47, 0, NULL, 0, 0, 0, 1, 2, 3, 0, '2023-11-30 10:20:36');

INSERT INTO `ex_notify` VALUES (48, 0, NULL, 0, 0, 0, 1, 2, 4, 0, '2023-11-30 10:20:48');

INSERT INTO `ex_notify` VALUES (49, 0, NULL, 0, 0, 0, 1, 1, 11, 1, '2023-11-30 16:39:46');

INSERT INTO `ex_notify` VALUES (50, 277, NULL, 0, 0, 1, 0, 8, 1, 1, '2023-12-01 09:26:49');

INSERT INTO `ex_notify` VALUES (51, 0, NULL, 0, 0, 0, 1, 1, 8, 0, '2023-12-01 10:56:26');

INSERT INTO `ex_notify` VALUES (52, 277, NULL, 0, 0, 1, 0, 1, NULL, 0, '2023-12-01 10:56:53');

INSERT INTO `ex_notify` VALUES (53, 279, NULL, 0, 0, 1, 0, 11, 4, 0, '2023-12-01 15:05:22');

INSERT INTO `ex_notify` VALUES (54, 279, NULL, 0, 0, 1, 0, 2, 4, 0, '2023-12-01 15:13:52');

INSERT INTO `ex_notify` VALUES (55, 279, NULL, 0, 0, 1, 0, 2, 4, 0, '2023-12-01 15:43:34');

INSERT INTO `ex_notify` VALUES (56, 279, NULL, 0, 0, 1, 0, 2, 4, 0, '2023-12-01 15:43:35');

INSERT INTO `ex_notify` VALUES (57, 277, NULL, 0, 0, 1, 0, 2, 1, 1, '2023-12-01 15:45:09');



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

-- Table structure for ex_post

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

DROP TABLE IF EXISTS `ex_post`;

CREATE TABLE `ex_post`  (

  `post_id` bigint NOT NULL AUTO_INCREMENT,

  `pl_parent_id` bigint NULL DEFAULT 0,

  `zf_parent_id` bigint NULL DEFAULT 0,

  `zf_quick` int NULL DEFAULT 0,

  `reply_user_id` bigint NULL DEFAULT 0,

  `reply_user_account` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `user_id` bigint NULL DEFAULT NULL,

  `post_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,

  `zf_counts` bigint NULL DEFAULT 0,

  `pl_counts` bigint NULL DEFAULT 0,

  `xh_counts` bigint NULL DEFAULT 0,

  `fw_counts` bigint NULL DEFAULT 0,

  `sp_url` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `tp_url` varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

  `post_replylimit` int NULL DEFAULT 1,

  `post_delete` int NULL DEFAULT 0,

  `post_lock` int NULL DEFAULT 0,

  `post_lockmsg` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `post_show` int NULL DEFAULT 0,

  `post_edit` int NULL DEFAULT 0,

  `post_time` datetime NULL DEFAULT NULL,

  `post_edittime` datetime NULL DEFAULT NULL,

  `post_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `post_lan_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `post_location` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `post_city` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `post_country` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `post_regionName` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `post_lat` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `post_lon` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`post_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 281 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_post

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

INSERT INTO `ex_post` VALUES (161, 0, 0, 0, 0, NULL, 1, '#新话题# [2023_4]主页测试第一帖', 0, 0, 0, 0, NULL, 'http://localhost:8080/img/2023-11-03/4b917b29-0eef-46dd-887d-5f6d00289848.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-03 14:37:04', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (162, 0, 0, 0, 0, NULL, 1, '#新话题# 弹出发布测试带视频', 1, 1, 1, 0, 'http://localhost:8080/video/2023-11-03/560913de-51fa-4666-8b57-6e6423a9b69c.mp4', NULL, 1, 0, 0, NULL, 0, 0, '2023-11-03 14:37:26', NULL, '111.31.210.13', '', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (163, 0, 162, 1, 0, NULL, 1, '快转', 0, 0, 0, 0, '', '', 1, 0, 0, NULL, 0, 0, '2023-11-03 14:37:33', NULL, '111.31.210.13', '', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (164, 162, 0, 0, 1, 'e4glet', 1, '好看', 0, 0, 0, 0, '', '', 1, 0, 0, NULL, 0, 0, '2023-11-03 14:37:47', NULL, '111.31.210.13', '', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (165, 0, 0, 0, 0, NULL, 1, '在个人主页发布弹出第一帖[2023_19]', 0, 0, 0, 0, '', '', 1, 0, 0, NULL, 0, 0, '2023-11-03 14:38:08', NULL, '111.31.210.13', '', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (166, 0, 0, 0, 0, NULL, 2, '发帖测试[2023_19]', 0, 0, 0, 0, '', '', 1, 0, 0, NULL, 0, 0, '2023-11-06 13:29:45', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (167, 0, 0, 0, 0, NULL, 2, '测试新发布接口[2023_17]', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-06 13:35:19', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (168, 0, 0, 0, 0, NULL, 2, '测试新发布接口，带图片上传', 0, 0, 0, 1, NULL, 'http://localhost:8080/img/2023-11-06/b34548e4-175d-41b5-b3c9-f3cc3ade64d1.png', 1, 0, 0, NULL, 0, 0, '2023-11-06 13:35:40', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (169, 0, 0, 0, 0, NULL, 2, '测试新发布接口，带视频上传', 0, 0, 0, 0, 'http://localhost:8080/video/2023-11-06/8826d9dc-3296-4b37-945e-e4d9e6dde20b.mp4', NULL, 1, 0, 0, NULL, 0, 0, '2023-11-06 13:36:09', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (170, 0, 0, 0, 0, NULL, 2, '测试弹出窗口发帖[2023_30]', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-06 13:38:47', NULL, '111.31.210.13', '', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (171, 0, 0, 0, 0, NULL, 2, '测试弹出窗口发帖，带图片', 0, 0, 0, 0, NULL, 'http://localhost:8080/img/2023-11-06/1cb96787-9c02-4e63-8342-d926d1e7b60b.png', 1, 0, 0, NULL, 0, 0, '2023-11-06 13:40:01', NULL, '111.31.210.13', '', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (172, 0, 0, 0, 0, NULL, 2, '弹出窗口发布帖子带视频', 1, 0, 0, 0, 'http://localhost:8080/video/2023-11-06/2d348c6a-5190-4ea9-b54f-1cfa4dca7b9f.mp4', NULL, 1, 0, 0, NULL, 0, 0, '2023-11-06 13:40:27', NULL, '111.31.210.13', '10.2.185.100', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (173, 0, 172, 0, 0, NULL, 2, '转发测试', 0, 2, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-06 13:54:04', NULL, '111.31.210.13', '', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (175, 173, 0, 0, 2, '7488719', 2, '评论回复测试[2023_28]', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-06 13:57:29', NULL, '111.31.210.13', '', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (176, 173, 0, 0, 2, '7488719', 2, '回复测试带图片', 0, 1, 0, 0, NULL, 'http://localhost:8080/img/2023-11-06/90b7c08a-a715-425e-b609-96a4cd30ebb0.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-06 13:58:18', NULL, '111.31.210.13', '', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (177, 176, 0, 0, 2, '7488719', 2, '测试', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-06 15:00:00', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (178, 0, 0, 0, 0, NULL, 2, '#新话题# [2023_17]', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-06 15:02:00', NULL, '111.31.210.13', '', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (179, 0, 0, 0, 0, NULL, 2, 'Cesar', 0, 1, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-06 15:05:03', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (180, 0, 0, 0, 0, NULL, 2, '测试', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-06 15:05:50', NULL, '111.31.210.13', '', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (181, 0, 0, 0, 0, NULL, 2, '穿深色', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-06 15:06:29', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (182, 179, 0, 0, 2, '7488719', 2, 'escape', 0, 1, 0, 3, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-06 15:08:12', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (184, 0, 0, 0, 0, NULL, 1, 'Hallo alle, meine Seife ist die beste.', 0, 0, 0, 2, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 09:12:57', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (185, 0, 0, 0, 0, NULL, 1, 'Всем привет, мыло в моем доме лучше использовать. ', 0, 0, 0, 4, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 09:13:26', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (186, 0, 0, 0, 0, NULL, 4, '嘿嘿嘿，欢迎光临[2023_14]', 2, 0, 3, 3, NULL, 'http://120.46.83.148:8090/img/2023-11-07/ada15502-6510-438b-9a80-cb03445af262.png', 1, 0, 0, NULL, 0, 0, '2023-11-07 15:29:19', NULL, '60.28.43.170', '10.1.68.235', '天津市 天津 CNC Group CHINA169 Tianjin Province Network', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (187, 0, 0, 0, 0, NULL, 3, '#新话题# 新人报道[2023_20]', 0, 0, 2, 2, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 15:32:43', NULL, '113.54.203.216', '', '北京市 北京 CERNET', '北京', '中国', '北京市', '39.9042', '116.407');

INSERT INTO `ex_post` VALUES (188, 0, 0, 0, 0, NULL, 1, '#新话题# [2023_16]', 0, 2, 3, 4, 'http://120.46.83.148:8090/video/2023-11-07/2361eeff-cc96-44e1-aca9-c63f4c4cd106.mp4', NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 15:36:26', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (189, 0, 0, 0, 0, NULL, 5, '波音747', 0, 0, 1, 6, NULL, 'http://120.46.83.148:8090/img/2023-11-07/795ecdb3-3fa9-4e10-8465-12793b56ddc3.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-07 16:24:37', NULL, '111.31.210.12', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (190, 0, 0, 0, 0, NULL, 6, 'lemons', 0, 1, 3, 4, NULL, 'http://120.46.83.148:8090/img/2023-11-07/29545172-91e1-4381-a0b2-c49b0903c2a1.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-07 16:29:09', NULL, '163.123.192.52', '', '亞利桑那州 凤凰城 Tempest Hosting, LLC', '凤凰城', '美国', '亞利桑那州', '33.4168', '-112.0268');

INSERT INTO `ex_post` VALUES (192, 188, 0, 0, 1, 'e4glet', 5, '666', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 16:31:34', NULL, '111.31.210.12', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (193, 188, 0, 0, 1, 'e4glet', 5, '666', 0, 1, 0, 3, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 16:31:43', NULL, '111.31.210.12', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (194, 0, 0, 0, 0, NULL, 1, 'JUST IN  House Republicans are ramping up their investigation of President Biden and his family, with plans to subpoena ', 0, 0, 0, 1, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 17:01:15', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (195, 0, 0, 0, 0, NULL, 1, 'Seifenpersonen müssen zur Einäscherung in den Ofen geworfen werden. ', 0, 0, 0, 4, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 17:07:31', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (196, 193, 0, 0, 5, 'RAIN', 1, 'six[2023_25]', 0, 0, 0, 1, '', '', 1, 0, 0, NULL, 0, 0, '2023-11-07 17:36:26', NULL, '39.144.81.102', '2409:8903:1824:1112:1794:9864:ddf8:af1c', '天津市 大王庄 China Mobile', '大王庄', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_post` VALUES (197, 0, 0, 0, 0, NULL, 1, '#周杰伦演唱会# [2023_21]', 0, 0, 0, 1, 'http://120.46.83.148:8090/video/2023-11-07/02b2e82d-ec42-452e-b2ba-c67af6fc8902.mp4', NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 17:38:36', NULL, '39.144.81.102', '2409:8903:1824:1112:1794:9864:ddf8:af1c', '天津市 大王庄 China Mobile', '大王庄', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_post` VALUES (198, 0, 0, 0, 0, NULL, 1, '[2023_16] 冒泡', 0, 0, 0, 1, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 17:40:28', NULL, '39.144.81.102', '2409:8903:1824:1112:1794:9864:ddf8:af1c', '天津市 大王庄 China Mobile', '大王庄', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_post` VALUES (199, 190, 0, 0, 6, 'meng25290', 1, '图不错', 0, 0, 0, 2, '', '', 1, 0, 0, NULL, 0, 0, '2023-11-07 17:41:13', NULL, '39.144.81.102', '2409:8903:1824:1112:1794:9864:ddf8:af1c', '天津市 大王庄 China Mobile', '大王庄', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_post` VALUES (200, 0, 0, 0, 0, NULL, 1, '这宠物不错', 0, 0, 0, 0, NULL, 'http://120.46.83.148:8090/img/2023-11-07/bcd9ab1e-c10d-431d-8a42-505a35a40a77.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-07 17:46:38', NULL, '39.144.81.102', '2409:8903:c45:3ba7:1795:4e05:869b:4214', '天津市 大王庄 China Mobile', '大王庄', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_post` VALUES (201, 0, 0, 0, 0, NULL, 1, '奶茶是暖手的最佳宝贝[2023_4]', 0, 0, 1, 0, NULL, 'http://120.46.83.148:8090/img/2023-11-07/730fc6db-faad-4d61-893a-573662bffb95.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-07 19:41:07', NULL, '39.144.81.102', '2409:8a02:1844:8fd1:ac:985:918f:17e0', '天津市 大王庄 China Mobile', '大王庄', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_post` VALUES (202, 0, 0, 0, 0, NULL, 1, '#浪漫动画# [2023_4]', 0, 1, 0, 6, 'http://120.46.83.148:8090/video/2023-11-07/6ffec2d0-e7cd-48ad-8e22-e56d75e4a872.mp4', NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 20:06:51', NULL, '39.144.81.102', '2409:8a02:1844:8fd1:ac:985:918f:17e0', '天津市 大王庄 China Mobile', '大王庄', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_post` VALUES (203, 0, 186, 1, 0, NULL, 1, '快转', 0, 0, 0, 0, '', '', 1, 0, 0, NULL, 0, 0, '2023-11-07 20:15:34', NULL, '39.144.81.102', '', '', '', '', '', '', '');

INSERT INTO `ex_post` VALUES (207, 0, 0, 0, 0, NULL, 5, 'firework', 0, 0, 1, 0, 'http://120.46.83.148:8090/video/2023-11-07/f6fc9383-8697-4fe2-ab7e-ab86226b8160.mp4', NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 20:45:47', NULL, '221.197.235.56', '2408:8411:5421:f2fb:f4c0:c483:dcc3:542a', '天津市 天津 CNC Group CHINA169 Tianjin Province Network', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (208, 0, 0, 0, 0, NULL, 5, '大家好，我是來自天津市大學軟體學院，練習時長兩年半的軟體發展練習生，喜歡CSDN、GitHub與Gitee。', 1, 0, 0, 1, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-07 20:55:34', NULL, '221.197.235.56', '192.168.31.17', '天津市 天津 CNC Group CHINA169 Tianjin Province Network', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (209, 0, 0, 0, 0, NULL, 1, '美好的一天从早上开始[2023_4]', 0, 0, 4, 5, NULL, 'http://120.46.83.148:8090/img/2023-11-07/0bed6a9d-b9c5-4c07-ba3f-a9842521f87e.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-08 07:30:10', NULL, '39.144.81.102', '2409:8903:1b04:829:1795:7a66:737d:1260', '天津市 大王庄 China Mobile', '大王庄', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_post` VALUES (213, 0, 0, 0, 0, NULL, 5, 'GIF', 0, 0, 5, 2, NULL, 'http://120.46.83.148:8090/img/2023-11-08/2e4cc481-6b29-4bbf-bc0f-bbb8a5b6b1b7.gif', 1, 0, 0, NULL, 0, 0, '2023-11-08 09:13:41', NULL, '111.31.210.25', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (216, 0, 0, 0, 0, NULL, 1, 'PPDM和SD是在2022年8月才落地的技术，你让一个人在一年内攒出五年经验，这是不懂技术，还是不带脑子？', 0, 0, 0, 0, NULL, 'http://120.46.83.148:8090/img/2023-11-08/5f097e9d-b66e-48c1-9ce8-c94c99cb09f8.png', 1, 0, 0, NULL, 0, 0, '2023-11-08 10:30:31', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (217, 0, 0, 0, 0, NULL, 2, '我们都是#中国人#，我们热爱#中国#。', 0, 0, 0, 19, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-08 10:41:19', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (219, 0, 0, 0, 0, NULL, 10, '大家好，古德猫宁[2023_21]', 0, 3, 1, 13, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-10 08:27:35', NULL, '221.238.47.87', '', '天津市 天津 ASN for TIANJIN Provincial Net of CT', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (222, 219, 0, 0, 10, 'x1600650397', 1, '[2023_18]', 0, 0, 0, 1, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-10 15:47:20', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (223, 219, 0, 0, 10, 'x1600650397', 1, '[2023_19]', 0, 0, 0, 1, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-10 15:49:22', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (224, 0, 0, 0, 0, NULL, 1, '1952年，教员提出废除贵族学校、取消等级，今天读来依然有现实意义。', 0, 0, 1, 0, NULL, 'http://120.46.83.148:8090/img/2023-11-10/68326b55-cb10-4cd6-9082-c602a647bf0c.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-10 16:25:38', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (225, 0, 0, 0, 0, NULL, 11, 'Cumhurbaşkanı Erdoğan: Ateşkesi sağlamak öncelikli hedefimizdir', 0, 0, 1, 3, NULL, 'http://120.46.83.148:8090/img/2023-11-10/e2f6daeb-e8a5-4f62-8e17-670ee05eb56e.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-10 16:37:08', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (226, 0, 0, 0, 0, NULL, 1, '与时代共奋飞，热烈庆祝人民空军成立74周年。 ​​​', 0, 0, 1, 0, NULL, 'http://120.46.83.148:8090/img/2023-11-10/5d148839-63a5-4fec-88a9-4aa967f6bc62.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-11 00:05:13', NULL, '39.144.81.102', '2409:8903:5445:7ed:1796:27ee:7e5f:84c', '天津市 河东 China Mobile', '河东', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_post` VALUES (227, 0, 0, 0, 0, NULL, 1, '#巴以冲突# 昨晚，以色列向加沙希法医院外的记者帐篷旁投下了一枚似乎是“地狱火RX9”的导弹，导弹没有爆炸。但造成一名男子失去了一条腿，另一名男子受伤。来源于X（原推特）', 0, 0, 1, 11, 'http://120.46.83.148:8090/video/2023-11-11/d919956f-46a7-429e-886f-2d3a956bcd5a.mp4', NULL, 1, 0, 0, NULL, 0, 0, '2023-11-11 09:18:05', NULL, '39.144.81.102', '2409:8a02:184c:44c1:f888:25f:51d5:f042', '天津市 河东 China Mobile', '河东', '中国', '天津市', '39.127', '117.216');

INSERT INTO `ex_post` VALUES (230, 0, 0, 0, 0, NULL, 2, '#Python连等赋值# \r\nPython连等赋值是指在一行代码中同时给多个变量赋值，这些变量的值可以是多个值或者一个可迭代对象。', 1, 0, 1, 8, NULL, 'http://120.46.83.148:8090/img/2023-11-11/06637500-ec89-4cad-81ff-b49a29212e2c.png', 1, 0, 0, NULL, 0, 0, '2023-11-11 12:37:09', NULL, '111.32.114.225', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (231, 0, 0, 0, 0, NULL, 1, 'Mandarin is a beautiful language.', 0, 0, 9, 2, 'http://120.46.83.148:8090/video/2023-11-11/3c6eaeb3-c226-4db8-b2a4-16625dd037ad.mp4', NULL, 1, 0, 0, NULL, 0, 0, '2023-11-11 12:46:46', NULL, '111.32.114.225', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (232, 0, 0, 0, 0, NULL, 1, '#中国风景#[2023_21]', 0, 0, 6, 7, NULL, 'http://120.46.83.148:8090/img/2023-11-11/635cc95f-0b5d-4660-b483-f56987a5de0c.jpeg', 1, 0, 0, NULL, 0, 0, '2023-11-11 12:54:57', NULL, '111.32.114.225', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (233, 0, 0, 0, 0, NULL, 2, '#认知作战# #资本疯狂试探#\r\n认知作战：重塑敌国的历史意识、教育体系，动摇其社会的基础思想和目标，破坏其社会传统、生活方式和基本价值观。', 0, 0, 2, 7, NULL, 'http://120.46.83.148:8090/img/2023-11-11/574a5c87-e369-4c6a-adfc-cea24650c1db.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-11 13:20:17', NULL, '111.32.114.225', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (235, 0, 0, 0, 0, NULL, 6, 'TEST[2023_83]', 0, 2, 3, 14, 'http://120.46.83.148:8090/video/2023-11-13/3eaa56ea-cd49-4455-b327-24abe42bc049.mkv', 'http://120.46.83.148:8090/img/2023-11-13/6d86b2f9-306b-472b-b844-98df4ecc861d.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-13 08:42:56', NULL, '163.123.192.52', '', '亞利桑那州 凤凰城 Tempest Hosting, LLC', '凤凰城', '美国', '亞利桑那州', '33.4168', '-112.0268');

INSERT INTO `ex_post` VALUES (236, 235, 0, 0, 6, 'meng25290', 1, 'content is ok.', 0, 0, 1, 1, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-13 11:46:41', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (237, 235, 0, 0, 6, 'meng25290', 15, '                                                                1                                                                                                                                                                                                                                           ', 0, 0, 1, 1, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-18 11:11:10', NULL, '39.144.82.57', '', '天津市 天津 China Mobile', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (238, 0, 230, 1, 0, NULL, 15, '快转', 1, 1, 1, 5, '', '', 1, 1, 0, NULL, 0, 0, '2023-11-18 23:05:17', NULL, '39.144.82.57', '', '天津市 天津 China Mobile', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (239, 0, 238, 1, 0, NULL, 15, '快转', 1, 0, 1, 2, '', '', 1, 1, 0, NULL, 0, 0, '2023-11-18 23:06:27', NULL, '39.144.82.57', '', '天津市 天津 China Mobile', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (240, 0, 239, 1, 0, NULL, 15, '快转', 0, 0, 1, 0, '', '', 1, 1, 0, NULL, 0, 0, '2023-11-18 23:06:44', NULL, '39.144.82.57', '', '天津市 天津 China Mobile', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (241, 238, 0, 0, 15, 'fangxc', 15, '1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n1\r\n', 0, 0, 0, 2, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-18 23:13:53', NULL, '39.144.82.57', '', '天津市 天津 China Mobile', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (242, 0, 0, 0, 0, NULL, 15, '[2023_21][2023_5][2023_6][2023_21][2023_5][2023_6][2023_21][2023_5][2023_6][2023_21][2023_5][2023_6][2023_21][2023_5][2023_6][2023_21][2023_5][2023_6][2023_21][2023_5][2023_6][2023_21][2023_5][2023_6][2023_21][2023_5][2023_6][2023_21][2023_5][2023_6][2023_21][2023_5][2023_6][2023_21][2023_5][2023_6]', 0, 0, 0, 1, NULL, NULL, 1, 1, 0, NULL, 0, 0, '2023-11-18 23:39:28', NULL, '39.144.82.57', '', '天津市 天津 China Mobile', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (243, 0, 0, 0, 0, NULL, 1, '#天津美食##天津煎饼果子#', 1, 0, 2, 5, NULL, 'http://120.46.83.148:8090/img/2023-11-20/27729710-a553-4bd6-a83a-8998fae96760.png', 1, 0, 0, NULL, 0, 0, '2023-11-20 09:52:12', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (244, 0, 0, 0, 0, NULL, 1, '#布达拉宫#[2023_18]', 0, 1, 1, 9, NULL, 'http://120.46.83.148:8090/img/2023-11-20/3d6bb6ea-93af-46af-a855-58ca0d8bc4c2.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-20 09:53:37', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (245, 0, 243, 0, 0, NULL, 1, '#天津煎饼果子# 自家小区楼下的煎饼果子是最好吃的', 1, 0, 0, 7, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-20 09:55:22', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (246, 244, 0, 0, 1, 'e4glet', 1, '测试评论并删除', 0, 0, 0, 0, NULL, NULL, 1, 1, 0, NULL, 0, 0, '2023-11-20 12:28:49', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (247, 244, 0, 0, 1, 'e4glet', 1, '测试图片', 0, 0, 0, 0, NULL, 'http://120.46.83.148:8090/img/2023-11-20/53cb1ed5-0846-47c6-aa63-d93bbeeac992.jpg', 1, 1, 0, NULL, 0, 0, '2023-11-20 12:33:51', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (248, 0, 0, 0, 0, NULL, 1, '#新话题# [2023_20]', 0, 0, 0, 0, NULL, NULL, 1, 1, 0, NULL, 0, 0, '2023-11-21 17:05:13', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (249, 0, 0, 0, 0, NULL, 1, '[2023_19]', 0, 0, 0, 0, NULL, NULL, 1, 1, 0, NULL, 0, 0, '2023-11-21 17:05:20', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (250, 0, 0, 0, 0, NULL, 1, '#新疆美景##布达拉宫#', 1, 2, 0, 20, NULL, 'http://120.46.83.148:8090/img/2023-11-21/b33f6cc0-07e1-4e52-aaf2-93e36299d299.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-21 17:08:08', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (251, 250, 0, 0, 1, 'e4glet', 1, '[2023_19]好看', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-21 17:08:34', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (252, 0, 0, 0, 0, NULL, 1, '#阿根廷新总统#\r\n阿根廷新总统：“我不会跟中国做生意” “会将货币换成美元”。\r\n\r\nPS:好，要说到做到，2024年要把出口到中国的肉类、豆类、葡萄酒、皮革、纺织品等统统出口到美国去。', 0, 0, 0, 3, 'http://120.46.83.148:8090/video/2023-11-22/2cf6b035-24ac-43b5-8121-80cdf8f2fc30.mp4', NULL, 1, 0, 0, NULL, 0, 0, '2023-11-22 08:29:03', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (253, 0, 0, 0, 0, NULL, 2, '#阿根廷新总统#Meet mentally ill, Zionist,new president of Argentine Javier Milei.A Set back for Argentine, a set back for BRICS', 0, 0, 0, 6, NULL, 'http://120.46.83.148:8090/img/2023-11-22/9eea0835-774a-4c1d-bcbd-0dd8de5fc80c.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-22 08:36:03', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (254, 0, 0, 0, 0, NULL, 1, '#阿根廷新总统##社会实验场#阿根廷新总统不仅要关闭阿根廷央行，废除本国货币，主张医疗、教育、监狱、养老私有化，甚至器官交易合法化，取消监管，同时放开移民。\r\n\r\n在南美洲资源丰富的阿根廷，为何会选出这样的总统，一个演员将乌克兰毁了。阿根廷的命运将何去何从。单单医疗私有化、取消监管、器官交易+放开移民，这是一条完整的器官贩卖产业链。\r\n\r\n我们将共同见证这个大型#社会实验场#最终的结果。[2023_29]', 0, 0, 1, 18, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-22 08:45:34', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (255, 0, 0, 0, 0, NULL, 1, '#加拿大间谍内讧#\r\n曾被中国逮捕的两名加拿大间谍，在回国后居然闹内讧了！而且这一闹，不仅把大量两人涉及的案情曝光了出来，更把加拿大政府的脸都给抽肿了！\r\n不知大家是否还记得，几年前，在华为公司的高管孟晚舟遭加拿大政府非法扣押的那段时间，我国的执法部门曾逮捕了两名涉嫌在中国从事间谍活动的加拿大人，一个叫康明凯，一个叫迈克尔。\r\n\r\n没错，就是下面这两个货！[2023_30]', 0, 0, 1, 13, NULL, 'http://120.46.83.148:8090/img/2023-11-22/c0f0047c-949b-439d-a94c-912d730398db.png', 1, 0, 0, NULL, 0, 0, '2023-11-22 09:00:59', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (256, 0, 0, 0, 0, NULL, 3, '我来👀', 0, 1, 1, 6, NULL, 'http://120.46.83.148:8090/img/2023-11-22/5ca71d2a-694b-4dbd-b763-893bb52b5e7d.jpeg', 1, 0, 0, NULL, 0, 0, '2023-11-22 14:33:11', NULL, '39.144.137.52', '', '四川省 成都 China Mobile', '成都', '中国', '四川省', '30.6498', '104.0555');

INSERT INTO `ex_post` VALUES (257, 250, 0, 0, 1, 'e4glet', 3, '[2023_20]', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-22 14:35:02', NULL, '39.144.137.52', '', '四川省 成都 China Mobile', '成都', '中国', '四川省', '30.6498', '104.0555');

INSERT INTO `ex_post` VALUES (258, 0, 245, 1, 0, NULL, 3, '快转', 0, 0, 0, 2, '', '', 1, 0, 0, NULL, 0, 0, '2023-11-22 14:39:02', NULL, '39.144.137.52', '', '四川省 成都 China Mobile', '成都', '中国', '四川省', '30.6498', '104.0555');

INSERT INTO `ex_post` VALUES (259, 0, 250, 0, 0, NULL, 3, '芜湖', 0, 0, 1, 4, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-22 14:39:23', NULL, '39.144.137.52', '', '四川省 成都 China Mobile', '成都', '中国', '四川省', '30.6498', '104.0555');

INSERT INTO `ex_post` VALUES (260, 0, 0, 0, 0, NULL, 1, '#认证功能已开通#目前引用部分还有一个显示bug，明天再弄吧[2023_78]', 0, 0, 0, 6, NULL, NULL, 1, 1, 0, NULL, 0, 0, '2023-11-22 17:24:09', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (261, 256, 0, 0, 3, 'Yujie', 1, '1.问题\r\n2.概念/方法\r\n3.实现\r\n4.效果\r\n5.思考改进\r\n6.实现\r\n7.效果\r\n8.总结\r\n[2023_14]', 0, 0, 0, 3, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-22 21:35:04', NULL, '111.33.200.70', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (262, 0, 260, 0, 0, NULL, 1, '功能已经完善，bug已修复。下一步开发系统设置功能，用户可以设置国际化语言，并增加消息列表删除功能。最后实现推荐算法，以实现个性化推荐贴文。[2023_52]', 0, 2, 0, 68, NULL, NULL, 1, 1, 0, NULL, 0, 0, '2023-11-23 12:20:16', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (263, 262, 0, 0, 1, 'e4glet', 1, '补充:后续再完善移动端适配，增加可选操作内容。', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-23 12:39:45', NULL, '39.144.82.42', '2409:8903:1845:4c4:1799:c165:a87d:c21c', '天津市 天津 China Mobile', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (266, 262, 0, 0, 1, 'e4glet', 2, '发布测试111点赞', 0, 0, 0, 1, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-23 13:35:44', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (267, 262, 0, 0, 1, 'e4glet', 1, '自己发帖', 0, 0, 1, 0, NULL, NULL, 1, 1, 0, NULL, 0, 0, '2023-11-23 13:36:36', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (268, 0, 0, 0, 0, NULL, 1, '[2023_16]', 0, 0, 0, 0, NULL, NULL, 1, 1, 0, NULL, 0, 0, '2023-11-23 14:01:42', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (269, 0, 0, 0, 0, NULL, 3, '[2023_15]', 0, 1, 0, 7, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-23 14:05:42', NULL, '39.144.137.52', '', '四川省 成都 China Mobile', '成都', '中国', '四川省', '30.6498', '104.0555');

INSERT INTO `ex_post` VALUES (270, 269, 0, 0, 3, 'Yujie', 3, 'nice', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-23 14:05:57', NULL, '39.144.137.52', '', '四川省 成都 China Mobile', '成都', '中国', '四川省', '30.6498', '104.0555');

INSERT INTO `ex_post` VALUES (271, 0, 0, 0, 0, NULL, 2, '[2023_15]', 0, 0, 0, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-23 15:08:37', NULL, '111.31.210.13', '10.2.185.100', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (272, 0, 0, 0, 0, NULL, 1, '【以色列代表对联合国机构出言不逊　中国常驻联合国代表张军当场打断】#以色列在联合国出言不逊被警告# 当地时间22日，根据阿联酋和马耳他要求，在中方主持下，联合国安理会再就加沙地带局势举行公开会。在联合国妇女署等机构对加沙地带情况做完通报后，以色列常驻联合国代表埃尔丹当场不满，并放言“联合国妇女署太可耻了”！如此出言不逊，被本月联合国安理会轮值主席、中国常驻联合国代表张军当场打断。（CCTV国际时讯）', 0, 0, 0, 2, 'http://120.46.83.148:8090/video/2023-11-23/9de8b999-140d-4059-b019-5abb17f7d97c.mp4', NULL, 1, 0, 0, NULL, 0, 0, '2023-11-23 23:45:23', NULL, '111.33.200.70', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (273, 0, 0, 0, 0, NULL, 1, '【#礼兵视角看2架歼20伴飞护航#】今天，运-20专机接迎，歼-20伴飞护航，25名在韩志愿军烈士回家。离家尚是少年身，归来已是报国躯。#英雄回家#，一起致敬英烈！', 0, 0, 0, 15, 'http://120.46.83.148:8090/video/2023-11-23/81d64582-f82f-42ee-b246-646716243ac7.mp4', NULL, 1, 0, 0, NULL, 0, 0, '2023-11-23 23:47:37', NULL, '111.33.200.70', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (274, 0, 0, 0, 0, NULL, 1, '#接英雄回家#70多年前，你跨过鸭绿江保家卫国。烽烟散尽，山河锦绣，亲人盼你回家，祖国带你回家。这盛世里的中国，一直有你的故事。今天，我们接你回家！#第十批在韩志愿军烈士遗骸回国##25名在韩志愿军烈士回家# ​', 0, 0, 0, 20, NULL, 'http://120.46.83.148:8090/img/2023-11-23/1aadaaf9-3a5c-4309-9d3d-0c8c1465733a.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-23 23:53:35', NULL, '111.33.200.70', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.1488', '117.1762');

INSERT INTO `ex_post` VALUES (275, 0, 0, 0, 0, NULL, 1, '#毛岸英烈士逝世73周年##还毛岸英烈士清白#！民族大义前，硝烟战火中，毛岸英毅然奔赴朝鲜战场，壮烈牺牲。然而，毛岸英烈士为国捐躯的壮举，却被一些人泼上了各种脏水，其中尤以“毛岸英牺牲是因其做蛋炒饭生火引来敌机”的谣言最为恶毒。英烈不容玷污，历史不容亵渎！今天，戳破谣言、澄清史实、敬悼英魂，还烈士清白！#毛岸英烈士牺牲的历史真相#', 1, 1, 1, 15, NULL, 'http://120.46.83.148:8090/img/2023-11-27/e3445221-0790-41a7-898e-2dad813973b6.jpg|http://120.46.83.148:8090/img/2023-11-27/ea6da74d-94c8-4a96-b29a-52859578cd48.jpg|http://120.46.83.148:8090/img/2023-11-27/bc506dc4-a70c-4e7d-b1c6-b289a8eb205f.jpg|http://120.46.83.148:8090/img/2023-11-27/660b8c71-7f19-445b-b0b8-d8eaf918bb5d.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-27 10:46:09', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (276, 0, 0, 0, 0, NULL, 3, '芜湖[2023_82]', 0, 0, 1, 0, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-27 11:22:02', NULL, '39.144.137.52', '', '四川省 成都 China Mobile', '成都', '中国', '四川省', '30.6498', '104.0555');

INSERT INTO `ex_post` VALUES (277, 0, 275, 0, 0, NULL, 1, '#毛岸英烈士逝世73周年##还毛岸英烈士清白#英雄不容诋毁！[2023_30]', 0, 0, 4, 12, NULL, NULL, 1, 0, 0, NULL, 0, 0, '2023-11-27 13:17:42', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (278, 275, 0, 0, 1, 'e4glet', 1, '#毛岸英烈士逝世73周年##还毛岸英烈士清白#人民英雄不容诋毁！', 0, 0, 0, 13, NULL, 'http://120.46.83.148:8090/img/2023-11-27/560b02fb-8923-4494-99bc-6338b524f5fe.jpg|http://120.46.83.148:8090/img/2023-11-27/978411c4-78f8-4db3-a527-645e1c6db167.jpg|http://120.46.83.148:8090/img/2023-11-27/5ff490f4-fb0c-4ffb-b0f6-807e27a9c7f7.jpg|http://120.46.83.148:8090/img/2023-11-27/2232b150-e854-4a7b-9dc3-bc725fb9f5d1.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-27 13:20:23', NULL, '111.31.210.13', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (279, 0, 0, 0, 0, NULL, 4, '霹雳工作组', 0, 0, 2, 8, NULL, 'http://120.46.83.148:8090/img/2023-11-27/6ba3d7a9-4a71-48ef-a162-8e54f2a1353c.jpg', 1, 0, 0, NULL, 0, 0, '2023-11-27 17:24:59', NULL, '111.31.210.9', '', '天津市 天津 China Mobile communications corporation', '天津', '中国', '天津市', '39.3434', '117.362');

INSERT INTO `ex_post` VALUES (280, 0, 279, 0, 0, NULL, 1, '[2023_43]', 0, 0, 0, 0, NULL, NULL, 1, 1, 0, NULL, 0, 0, '2023-11-27 17:26:15', NULL, '39.144.82.5', '10.1.75.140', '天津市 天津 China Mobile', '天津', '中国', '天津市', '39.1488', '117.1762');



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

-- Table structure for ex_post_zf_xh_rel

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

DROP TABLE IF EXISTS `ex_post_zf_xh_rel`;

CREATE TABLE `ex_post_zf_xh_rel`  (

  `post_rel_id` bigint NOT NULL AUTO_INCREMENT,

  `post_id` bigint NULL DEFAULT NULL,

  `opr_user_id` bigint NULL DEFAULT NULL,

  `xh_selected` int NULL DEFAULT 0,

  `zf_selected` int NULL DEFAULT 0,

  PRIMARY KEY (`post_rel_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 271 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_post_zf_xh_rel

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

INSERT INTO `ex_post_zf_xh_rel` VALUES (68, 162, 1, 1, 1);

INSERT INTO `ex_post_zf_xh_rel` VALUES (69, 173, 2, 0, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (71, 186, 1, 1, 1);

INSERT INTO `ex_post_zf_xh_rel` VALUES (72, 188, 5, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (73, 186, 5, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (78, 190, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (81, 207, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (82, 190, 2, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (83, 187, 2, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (84, 186, 2, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (85, 189, 2, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (86, 209, 2, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (87, 209, 8, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (88, 201, 8, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (89, 211, 2, 0, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (90, 188, 2, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (91, 213, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (92, 209, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (93, 188, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (94, 213, 10, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (97, 240, 1, 1, 1);

INSERT INTO `ex_post_zf_xh_rel` VALUES (98, 243, 6, 1, 1);

INSERT INTO `ex_post_zf_xh_rel` VALUES (114, 247, 1, 0, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (148, 270, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (157, 268, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (158, 267, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (159, 266, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (164, 273, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (165, 274, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (166, 269, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (176, 279, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (184, 225, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (187, 227, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (188, 226, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (189, 224, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (190, 219, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (192, 213, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (195, 235, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (196, 235, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (198, 233, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (210, 190, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (212, 236, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (213, 237, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (214, 232, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (215, 231, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (216, 230, 15, 1, 1);

INSERT INTO `ex_post_zf_xh_rel` VALUES (217, 238, 15, 1, 1);

INSERT INTO `ex_post_zf_xh_rel` VALUES (218, 239, 15, 1, 1);

INSERT INTO `ex_post_zf_xh_rel` VALUES (222, 240, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (223, 209, 15, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (229, 244, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (230, 235, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (231, 243, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (232, 187, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (233, 255, 3, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (234, 254, 3, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (235, 256, 3, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (236, 245, 3, 0, 1);

INSERT INTO `ex_post_zf_xh_rel` VALUES (238, 259, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (263, 256, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (264, 276, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (266, 277, 11, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (268, 275, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (269, 277, 8, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (270, 277, 1, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (273, 279, 2, 1, 0);

INSERT INTO `ex_post_zf_xh_rel` VALUES (274, 277, 2, 1, 0);



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

-- Table structure for ex_record_editpost

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

DROP TABLE IF EXISTS `ex_record_editpost`;

CREATE TABLE `ex_record_editpost`  (

  `record_id` bigint NOT NULL AUTO_INCREMENT,

  `user_id` bigint NULL DEFAULT NULL,

  `post_id` bigint NULL DEFAULT NULL,

  `post_content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL,

  `post_edittime` datetime NULL DEFAULT NULL,

  PRIMARY KEY (`record_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_record_editpost

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



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

-- Table structure for ex_roles

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

DROP TABLE IF EXISTS `ex_roles`;

CREATE TABLE `ex_roles`  (

  `role_id` int NOT NULL AUTO_INCREMENT,

  `role_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`role_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_roles

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

INSERT INTO `ex_roles` VALUES (1, '普通用户');

INSERT INTO `ex_roles` VALUES (2, '管理员');



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

-- Table structure for ex_user

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

DROP TABLE IF EXISTS `ex_user`;

CREATE TABLE `ex_user`  (

  `user_id` int NOT NULL AUTO_INCREMENT,

  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,

  `user_pass` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `user_nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,

  `user_headimg` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `user_bgimg` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `user_phone` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `user_email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `user_truename` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '',

  `user_card` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '',

  `user_info` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',

  `auth_id` int NULL DEFAULT 0,

  `auth_input_limit` int NULL DEFAULT 300,

  `user_lang` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'zh',

  `role_id` int NULL DEFAULT 1,

  `user_isAlive` int NULL DEFAULT 0,

  `user_lock` int NULL DEFAULT 0,

  `user_isBlock` int NULL DEFAULT 0,

  `user_fo` bigint NULL DEFAULT 0,

  `user_fans` bigint NULL DEFAULT 0,

  `user_regtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,

  `user_isDelete` int NULL DEFAULT 0,

  `user_code` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '',

  `user_codetime` datetime NULL DEFAULT NULL,

  PRIMARY KEY (`user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_user

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

INSERT INTO `ex_user` VALUES (1, 'e4glet', 'c6c000f7c372f420239775892142427dc4e85397bf7fdf47b95f2cd0a37a8e56a343e3f44c635949933a7d7b380030f1eb7c9f1be95f47269ee6bc1f87101b4f', 'eaglet', 'http://120.46.83.148:8090/person/header/2023-11-10/5c1e2bdb-6fc9-42c8-a3a0-9766cff5107f.png', 'http://120.46.83.148:8090/person/bg/2023-11-07/521e9489-634d-449d-80f8-0dfc0f448dd7.png', NULL, '317834473@qq.com', '', '', '好看的马路不长草，聪明的脑袋不长毛。', 2, 5000, 'zh', 1, 0, 0, 0, 8, 4, '2023-09-10 11:31:05', 0, 'GYYb3B', '2023-11-11 11:33:37');

INSERT INTO `ex_user` VALUES (2, '7488719', 'c6c000f7c372f420239775892142427dc4e85397bf7fdf47b95f2cd0a37a8e56a343e3f44c635949933a7d7b380030f1eb7c9f1be95f47269ee6bc1f87101b4f', '爱编程', 'http://120.46.83.148:8090/person/header/2023-11-11/d47700e1-f822-412b-8126-3c3a50ced463.png', 'http://120.46.83.148:8090/person/bg/2023-11-07/7cea0517-91dd-49d8-adfe-656912fb96f0.jpg', NULL, '7488719@qq.com', '', '', '最新喜欢学习', 1, 1000, 'zh', 1, 0, 0, 0, 3, 2, '2023-10-26 11:31:05', 0, '', NULL);

INSERT INTO `ex_user` VALUES (3, 'Yujie', '344116dcab7b50e7c0794938b0a8fa272085502f88f8281f806a91a152b74a19de8fe2c2d66fb2eae1527e9d3e6546f79bf3fdc744e43dfcfc27c4f359e01769', 'Yujie', 'http://120.46.83.148:8090/person/header/2023-11-07/ee96ee80-e2b8-4fc4-8621-b95a1e8161ad.jpeg', 'http://120.46.83.148:8090/person/bg/2023-11-07/c0eb5893-2185-4868-b2d4-78961b91b443.jpeg', NULL, '1762612420@qq.com', '', '', '吼吼吼', 1, 1000, 'zh', 1, 0, 0, 0, 1, 2, '2023-11-07 15:23:37', 0, '', NULL);

INSERT INTO `ex_user` VALUES (4, 'mxh', '2ed1ecee5c8f2bbbc5f5a50a438362cd4b253e3cea569e07a2e1d81fe04e5e6a4a4d92a7cbc75ccb9bd5f2675b83aef93ef342df9363604d5336dc1251fb1243', 'mxh', 'http://120.46.83.148:8090/person/header/2023-11-07/676da357-a966-42ea-93b0-ba0092e0ec82.jpg', 'http://120.46.83.148:8090/person/bg/2023-11-07/4e7a9f1c-adc2-4cb6-bf8a-00044872b136.jpg', NULL, '2351881368@qq.com', '', '', '做一个温柔的人', 1, 1000, 'zh', 1, 0, 0, 0, 0, 1, '2023-11-07 15:26:38', 0, '', NULL);

INSERT INTO `ex_user` VALUES (5, 'RAIN', '47ec976068a696f8234a1fa1e99defa31320278b8adf74847aa3324647f8ca6e96f3b57a8678519a931295bba5b5c8673819f1f0e8888ed3e616e32426847116', 'RAIN', 'http://120.46.83.148:8090/person/header/2023-11-07/9128e04a-2b12-40bd-be7a-a329146d7e97.png', 'http://120.46.83.148:8090/person/bg/2023-11-07/0630030e-64d6-4dad-8177-04ade43ec140.jpeg', NULL, '1172842362@qq.com', '', '', '又见一年桂花香，拾得秋风月渐凉。', 0, 300, 'zh', 1, 0, 0, 0, 0, 1, '2023-11-07 16:19:27', 0, '', NULL);

INSERT INTO `ex_user` VALUES (6, 'meng25290', 'b1aff692621060f23bef4127f704ac7de3b3dc317ced17dfbe50dcaea1067ef99aa0096f72626599f9dcc8f69fe6496ec43d1f5b45949c4799216b5d7fd6b691', 'meng25290', 'http://120.46.83.148:8090/person/header/2023-11-07/91132f5d-5c3a-4913-851b-c0077f4d0f02.png', 'http://120.46.83.148:8090/person/bg/2023-11-14/1285b2db-b6e0-4edd-9101-7385a224d510.jpg', NULL, '2529035579@qq.com', '', '', 'HELLO WORLD', 0, 300, 'zh', 1, 0, 0, 0, 3, 3, '2023-11-07 16:28:30', 0, '', NULL);

INSERT INTO `ex_user` VALUES (7, 'qwer', '352cc80a82a148367d947e687fb640f7579bea1162def6f35c357d039e62d052a709ee703d1213f5f1195597826e841d91e4c28821b86dd3fd0a176ec5664a32', 'qwer', NULL, NULL, NULL, '2942216927@qq.com', '', '', '', 0, 300, 'zh', 1, 0, 0, 0, 0, 0, '2023-11-07 16:44:21', 0, 'pznI1V', '2023-11-07 16:45:05');

INSERT INTO `ex_user` VALUES (8, 'sunflower', '61fa3054130194d9b59ec51373f857e4e090d480e9532545c6e2dc66413b9a51704c4ecba7032a5befd68fd97913924f8b5621c53b1190edb1c9bf1b414a0824', 'sunflower', NULL, NULL, NULL, '1290008082@qq.com', '', '', '', 0, 300, 'zh', 1, 0, 0, 0, 0, 1, '2023-11-07 20:15:42', 0, 'QMo7zM', '2023-12-01 09:24:13');

INSERT INTO `ex_user` VALUES (9, 'AAA168', 'abf145b8ddc2ba960a26258a52036bb9d782fa81e69b8f9d3acf1e3c9c270c87d3f14f3c695e66d728dee34006c40fa180b0a64ae2d0e3cb87e1cc8560b6a201', 'AAA168', NULL, NULL, NULL, 'rlam1225@gmail.com', '', '', '', 0, 300, 'zh', 1, 0, 0, 0, 0, 0, '2023-11-07 20:37:28', 0, '', NULL);

INSERT INTO `ex_user` VALUES (10, 'x1600650397', '7d863d54311c19212edc33b02c751a68007c012264f54d96be058ca5b50dea7a7bbf8bc819f385c6969033a0483646155b0fdb49761a0762473dd3a4d9aed990', 'xsp', NULL, 'http://120.46.83.148:8090/person/bg/2023-11-10/3f8ae7a6-1ccc-455a-ab7e-4e8752ed4f97.jpg', NULL, '1600650397@qq.com', '', '', '该用户比较懒，什么都没写。', 0, 300, 'zh', 1, 0, 0, 0, 0, 0, '2023-11-10 08:22:21', 0, '', NULL);

INSERT INTO `ex_user` VALUES (11, 'CGTN', 'c6c000f7c372f420239775892142427dc4e85397bf7fdf47b95f2cd0a37a8e56a343e3f44c635949933a7d7b380030f1eb7c9f1be95f47269ee6bc1f87101b4f', 'CGTN', 'http://120.46.83.148:8090/person/header/2023-11-10/087df297-8ff3-4522-ac7d-0c7d4263e199.jpg', 'http://120.46.83.148:8090/person/bg/2023-11-10/0c383719-6052-4856-922c-069af67c4689.jpg', NULL, NULL, '', '', 'CGTN is an international media organization. ', 2, 5000, 'zh', 1, 0, 0, 0, 0, 1, '2023-11-10 16:28:01', 0, '', NULL);

INSERT INTO `ex_user` VALUES (12, 'PEMGG', '1049ec363f0d525e9869d7bab920fd949f11c683b0cb0641cb951e97a283b0c5ee34b3048d686a47b22d92f2e893208e63035c83ea7920fd9bb9139560d3b4d5', 'PEMGG', NULL, NULL, NULL, '486490078@qq.com', '', '', '', 0, 300, 'zh', 1, 0, 0, 0, 0, 0, '2023-11-10 17:44:35', 0, 'WO6eRt', '2023-11-10 17:45:44');

INSERT INTO `ex_user` VALUES (13, 'swyxy4484', '6009a56e68bf1f3701d801e462e9e4e223b4e1a80004e53c9aa200d9fc60ae80276504dd04a0464bc2d368a77ba17161038a17264d33668877f16af55c3c44f0', '无人机咻咻咻', 'http://120.46.83.148:8090/person/header/2023-11-10/06156cd7-9ad0-4bda-93e0-cfa158fe088a.jpg', NULL, NULL, 'swyuxiangyi@outlook.com', '', '', '该用户比较懒，什么都没写。', 0, 300, 'zh', 1, 0, 0, 0, 0, 0, '2023-11-10 22:22:45', 0, '', NULL);

INSERT INTO `ex_user` VALUES (14, 'qaz', '4d63cae615483b742f8bf0b772390552bf7ee63b3d6ee225c395a465bef5c13bfc5ac1bb2a52077a659ff4664dbb6f1fb97a0601998eed1b1639842903cb6c47', 'qaz', NULL, NULL, NULL, '2771585220@qq.com', '', '', '', 0, 300, 'zh', 1, 0, 0, 0, 0, 0, '2023-11-15 16:27:47', 0, '', NULL);

INSERT INTO `ex_user` VALUES (15, 'fangxc', 'b073c7359af15f87f0c774a20f45c80244c35161202456bf3218596fea24edcee3b58001804b6f5e10f8773c7908cde2a2d25d8a24940bf339d20beb640d55fa', 'fangxc', NULL, NULL, NULL, 'fangxingchaotcu@163.com', '', '', '', 0, 300, 'zh', 1, 0, 0, 0, 1, 1, '2023-11-15 21:06:48', 0, '', NULL);

INSERT INTO `ex_user` VALUES (16, 'candy', '6d83f6762f399b279c3aab077011bd7c3831967b130d37e5d1404814ef4d6ec95edb2405cc042dd8fb755c3a726c9a2b12f77817a9ccc08895d1f3f7b394c357', 'candy', NULL, NULL, NULL, '859511661@qq.com', '', '', '', 0, 300, 'zh', 1, 0, 0, 0, 0, 0, '2023-11-23 14:44:42', 0, '', NULL);

INSERT INTO `ex_user` VALUES (17, 'chen', '11fd9d55629ca531612dc2d716a1a78a79bddda9bcfa5ec04befa03f51da72088398130c589b60e14ea6f5327877cb1e76b2d7f90ec7febe88f092601e701fca', 'chen', NULL, NULL, NULL, '1578164799@qq.com', '', '', '', 0, 300, 'zh', 1, 0, 0, 0, 0, 0, '2023-11-24 11:03:30', 0, '', NULL);

INSERT INTO `ex_user` VALUES (18, 'hxya', '5984855f85ca596b49a5a6df00788e2c77f31e58d38b8bb56dc42459944a0ba768e5aa05af5071e5e37af9d161c6299997aa8186119357008ca82eb7ff43e6ec', '芜湖', 'http://120.46.83.148:8090/person/header/2023-11-27/a9fccab1-230f-40ff-989f-ddafc9b49189.jpg', 'http://120.46.83.148:8090/person/bg/2023-11-27/00c83cd0-806e-4010-a119-862186a9ebd7.jpeg', NULL, '3506704365@qq.com', '', '', '该用户比较懒，什么都没写。', 0, 300, 'zh', 1, 0, 0, 0, 0, 0, '2023-11-27 14:23:00', 0, '', NULL);

INSERT INTO `ex_user` VALUES (19, 'AIT007', '7b2e68ba048377a0d3b4fdfa73bea571caf892ba4996a642c0c53d28a99ad983251bdcf81368e7bf0aa2141b0a8f5bffb96c322eef123767b4091beffd82980e', 'AIT007', NULL, NULL, NULL, 'whxsw@qq.com', '', '', '', 0, 300, 'zh', 1, 0, 0, 0, 0, 0, '2023-11-30 10:08:03', 0, '', NULL);



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

-- Table structure for ex_user_vip

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

DROP TABLE IF EXISTS `ex_user_vip`;

CREATE TABLE `ex_user_vip`  (

  `rel_id` bigint NOT NULL AUTO_INCREMENT,

  `user_id` bigint NULL DEFAULT NULL,

  `vip_id` int NULL DEFAULT NULL,

  PRIMARY KEY (`rel_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_user_vip

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



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

-- Table structure for ex_vip

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

DROP TABLE IF EXISTS `ex_vip`;

CREATE TABLE `ex_vip`  (

  `vip_id` int NOT NULL AUTO_INCREMENT,

  `vip_name` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  `vip_express` bigint NULL DEFAULT NULL,

  `vip_icon` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`vip_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of ex_vip

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



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

-- Procedure structure for ex_updatePLCountsByPostId

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

DROP PROCEDURE IF EXISTS `ex_updatePLCountsByPostId`;

delimiter ;;

CREATE PROCEDURE `ex_updatePLCountsByPostId`(post_id int)

BEGIN

	#定义评论数量

	DECLARE pl_count int;

	#定义sql错误捕获变量

	DECLARE error INTEGER DEFAULT 0;

  #捕获到sql错误，就设置error为1

	DECLARE CONTINUE HANDLER FOR SQLEXCEPTION set error=1;

	#开启事务

	START TRANSACTION;

	

	#功能操作

	#查询当前帖子的回复帖子数

	SELECT count(*) INTO pl_count FROM ex_post where post_delete=0 and zf_parent_id=0 and pl_parent_id=post_id;

	#更新当前帖子的评论数量

	UPDATE ex_post set pl_counts=pl_count where post_id=post_id;

	

	

	-- 判断是否有错误

	if error =1 THEN	

	ROLLBACK; -- 如果有错误，回滚事务	

	ELSE	

	COMMIT;  -- 如果没有错误，提交事务

	END IF;

	

	SELECT error;

END

;;

delimiter ;



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

-- Procedure structure for ex_updateUserFoAndFansInfo

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

DROP PROCEDURE IF EXISTS `ex_updateUserFoAndFansInfo`;

delimiter ;;

CREATE PROCEDURE `ex_updateUserFoAndFansInfo`(post_user_id int,current_user_id int)

BEGIN

	#更新关注者和被关注用户的关注人数与被关注人数

	#定义数据变量，关注者的关注人数 ，被关注者的人数

	DECLARE current_user_fo_counts int;

	DECLARE current_user_fans_counts int;

	DECLARE post_user_fo_counts int;

	DECLARE post_user_fans_counts int;

	#定义sql错误捕获变量

	DECLARE error INTEGER DEFAULT 0;

  #捕获到sql错误，就设置error为1

	DECLARE CONTINUE HANDLER FOR SQLEXCEPTION set error=1;

	#开启事务

	START TRANSACTION;

	# 查询当前用户关注关系表中关注了多少人，并将数量赋值给变量

	SELECT count(*) INTO current_user_fo_counts FROM ex_fanslist WHERE fo_id = current_user_id;

	# 查询当前用户的粉丝数量并赋值给变量

	SELECT count(*) INTO current_user_fans_counts FROM ex_fanslist where fans_fo_id = current_user_id;

	# 将当前用户关注数量更新

	UPDATE ex_user set user_fo = current_user_fo_counts,user_fans = current_user_fans_counts where user_id = current_user_id;



  # 查询被关注者关系表中关注人数 并赋值给变量

	SELECT count(*) INTO post_user_fo_counts FROM ex_fanslist WHERE fo_id = post_user_id;

	# 查询被关注者关系表中粉丝人数 并赋值给变量

	SELECT count(*) INTO post_user_fans_counts FROM ex_fanslist WHERE fans_fo_id = post_user_id;

	# 将被关注用户的关注数量更新

	UPDATE ex_user set user_fo = post_user_fo_counts,user_fans = post_user_fans_counts where user_id = post_user_id;

	

	-- 判断是否有错误

	if error =1 THEN	

	ROLLBACK; -- 如果有错误，回滚事务	

	ELSE	

	COMMIT;  -- 如果没有错误，提交事务

	END IF;

	

	SELECT error;

END

;;

delimiter ;



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

-- Procedure structure for ex_updateXHCountsByPostId

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

DROP PROCEDURE IF EXISTS `ex_updateXHCountsByPostId`;

delimiter ;;

CREATE PROCEDURE `ex_updateXHCountsByPostId`(post_id int)

BEGIN

	#定义转发数量

	DECLARE xh_count int;

	#定义sql错误捕获变量

	DECLARE error INTEGER DEFAULT 0;

  #捕获到sql错误，就设置error为1

	DECLARE CONTINUE HANDLER FOR SQLEXCEPTION set error=1;

	#开启事务

	START TRANSACTION;

	

	#功能操作

	#查询当前帖子的转发帖子数

	SELECT count(*) INTO xh_count FROM ex_post_zf_xh_rel where xh_selected=1 and post_id = post_id;

	#更新当前帖子的转发数量

	UPDATE ex_post set xh_counts = xh_count where post_id = post_id;

	

	

	-- 判断是否有错误

	if error =1 THEN	

	ROLLBACK; -- 如果有错误，回滚事务	

	ELSE	

	COMMIT;  -- 如果没有错误，提交事务

	END IF;

	

	SELECT error;



END

;;

delimiter ;



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

-- Procedure structure for ex_updateZFCountsByPostId

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

DROP PROCEDURE IF EXISTS `ex_updateZFCountsByPostId`;

delimiter ;;

CREATE PROCEDURE `ex_updateZFCountsByPostId`(post_id int)

BEGIN

	#定义转发数量

	DECLARE zf_count int;

	#定义sql错误捕获变量

	DECLARE error INTEGER DEFAULT 0;

  #捕获到sql错误，就设置error为1

	DECLARE CONTINUE HANDLER FOR SQLEXCEPTION set error=1;

	#开启事务

	START TRANSACTION;

	

	#功能操作

	#查询当前帖子的转发帖子数

	SELECT count(*) INTO zf_count FROM ex_post where post_delete=0 and pl_parent_id=0 and zf_parent_id=post_id;

	#更新当前帖子的转发数量

	UPDATE ex_post set zf_counts=zf_count where post_id=post_id;

	

	

	-- 判断是否有错误

	if error =1 THEN	

	ROLLBACK; -- 如果有错误，回滚事务	

	ELSE	

	COMMIT;  -- 如果没有错误，提交事务

	END IF;

	

	SELECT error;



END

;;

delimiter ;



SET FOREIGN_KEY_CHECKS = 1;
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化