/*
 Navicat MySQL Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80028
 Source Host           : localhost:3306
 Source Schema         : ku_server

 Target Server Type    : MySQL
 Target Server Version : 80028
 File Encoding         : 65001

 Date: 21/09/2024 15:24:08
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for hotfix_code
-- ----------------------------
DROP TABLE IF EXISTS `hotfix_code`;
CREATE TABLE `hotfix_code`  (
  `id` bigint NOT NULL COMMENT 'id',
  `is_delete` int NOT NULL DEFAULT 0 COMMENT '是否删除',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注信息',
  `code` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '热更代码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hotfix_code
-- ----------------------------
INSERT INTO `hotfix_code` VALUES (1, 1, NULL, NULL, NULL, NULL, '# 替换掉原来的recv_ws_test函数，给函数增加一个print打印\r\nfrom server_module.handler_module import handler_common\r\nexec (\'\'\'\r\nasync def recv_ws_test(self, user_id, data):\r\n	value = data[\"value\"]\r\n	await sender_common.send_ws_test(user_id, value)\r\nHandleCommon.recv_ws_test = recv_ws_test\r\n\'\'\', dict(handler_common.__dict__))');
INSERT INTO `hotfix_code` VALUES (2, 0, NULL, NULL, NULL, NULL, 'import misc\r\n\r\nasync def bbb():\r\n	from mgr.user_mgr import UserMgr\r\n	from server_module import misc_logic\r\n	for user_id in UserMgr.get().user_dict:\r\n		await misc_logic.send_tip(user_id, \"666666\", True)\r\nmisc.run_async(bbb)');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` bigint NOT NULL COMMENT 'id',
  `is_delete` int NOT NULL DEFAULT 0 COMMENT '是否删除',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注信息',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `user_nack_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `pwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1835681255413391360, 1, '2024-09-16 22:04:51', '2024-09-16 22:04:51', '2024-09-16 22:05:45', NULL, '123', '珍野苦沙弥', '250cf8b51c773f3f8dc8b4be867a9a02');
INSERT INTO `user` VALUES (1835681589489704960, 0, '2024-09-16 22:06:10', '2024-09-20 20:53:04', NULL, NULL, '456', '88888888', '250cf8b51c773f3f8dc8b4be867a9a02');

SET FOREIGN_KEY_CHECKS = 1;