一款node版本的mysql数据库管理工具

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50641 Source Host : localhost:3306 Source Schema : gododb Target Server Type : MySQL Target Server Version : 50641 File Encoding : 65001 Date: 03/08/2023 10:15:11 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for rt_admin -- ---------------------------- DROP TABLE IF EXISTS `rt_admin`; CREATE TABLE `rt_admin` ( `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名', `password` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码', `admin_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '唯一标志', `salt` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码钥匙', `add_time` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间', `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '真实姓名', `mobile` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '手机号', `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态1正常0禁用', `login_time` int(10) DEFAULT '0' COMMENT '登录时间', `login_num` int(10) DEFAULT '0' COMMENT '登录次数', `update_time` int(10) DEFAULT '0' COMMENT '更新时间', `rules` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '-1', PRIMARY KEY (`admin_id`) USING BTREE, UNIQUE KEY `username` (`username`) USING BTREE, UNIQUE KEY `mobile` (`mobile`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理员表'; -- ---------------------------- -- Records of rt_admin -- ---------------------------- BEGIN; INSERT INTO `rt_admin` VALUES ('admin', '6d585e2c9760497cac7b1d7de2af5a4c', 1, '5KhNBSWmzf8zTRmj', 0, NULL, NULL, 0, 1691028880, 395, 0, '-1'); INSERT INTO `rt_admin` VALUES ('test', '0fc4cb8f312dad842411e616bb5eca33', 7, 'H6pecfi8GS7DRHji', 1690966737, 'test2', '13873150575', 0, 0, 0, 1690967270, '-1'); COMMIT; -- ---------------------------- -- Table structure for rt_admin_auth -- ---------------------------- DROP TABLE IF EXISTS `rt_admin_auth`; CREATE TABLE `rt_admin_auth` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `rules` text CHARACTER SET utf8, `status` tinyint(2) unsigned DEFAULT '0' COMMENT '是否可用0可用1不可用', `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理权限表'; -- ---------------------------- -- Records of rt_admin_auth -- ---------------------------- BEGIN; INSERT INTO `rt_admin_auth` VALUES (1, '总管理员', '-1', 0, NULL); INSERT INTO `rt_admin_auth` VALUES (2, 'test', '2,35,88,89', 0, 'test'); COMMIT; -- ---------------------------- -- Table structure for rt_adminlog -- ---------------------------- DROP TABLE IF EXISTS `rt_adminlog`; CREATE TABLE `rt_adminlog` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `admin_id` int(10) unsigned NOT NULL COMMENT '管理员账号', `log` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '日志名称', `data` text CHARACTER SET utf8 COMMENT '返回记录', `ip` varchar(64) CHARACTER SET utf8 DEFAULT '' COMMENT 'IP地址', `agent` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '客户端信息', `url` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '地址', `method` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '方法', `addtime` int(10) unsigned DEFAULT '0' COMMENT '添加时间', `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '日志类型', `leavetime` int(10) unsigned DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理操作日志'; -- ---------------------------- -- Records of rt_adminlog -- ---------------------------- BEGIN; INSERT INTO `rt_adminlog` VALUES (1, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"31\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690857164, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (2, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"23\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690857173, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (3, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"31\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690857425, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (4, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"39\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690861691, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (5, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"35\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690866922, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (6, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"31\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690871201, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (7, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"29\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690873314, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (8, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"41\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690874184, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (9, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"26\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690875634, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (10, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"45\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690882175, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (11, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"28\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690939770, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (12, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"33\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690939929, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (13, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"21\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690940018, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (14, 1, 'admin用户登录', '{\"username\":\"admin\",\"captcha\":\"32\"}', '::ffff:127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/115.0', '/login/loginIn', 'POST', 1690960382, 'admin_login', 0); INSERT INTO `rt_adminlog` VALUES (15, 1, 'admin用户登录', '{\"username\":\"admin\",