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

eaglet/social_service_system

代码 Issues 3 Pull Requests 0 Wiki 0 统计
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
克隆/下载
ex_post.sql 22.04 KB
一键复制 编辑 原始数据 按行查看 历史
eaglet 提交于 2023-11-21 16:55 . 修复删除帖子bug，实现回复、转发消息通知功能
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121
/*

 Navicat Premium Data Transfer



 Source Server         : 我的本地数据库

 Source Server Type    : MySQL

 Source Server Version : 80030

 Source Host           : localhost:3306

 Source Schema         : socialdb



 Target Server Type    : MySQL

 Target Server Version : 80030

 File Encoding         : 65001



 Date: 17/11/2023 16:39:50

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



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

-- 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(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_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 = 236 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, 1, 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, 2, 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, 3, 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, 2, 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, 0, 12, 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, 0, 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, 0, 2, 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, 0, 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, 0, 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连等赋值是指在一行代码中同时给多个变量赋值，这些变量的值可以是多个值或者一个可迭代对象。', 0, 0, 0, 3, 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, 0, 0, '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, 0, 4, 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, 0, 4, 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, 1, 1, 4, '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, 0, 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');



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