同步操作将从 michlee/mysql数据库同步 强制同步,此操作会覆盖自 Fork 仓库以来所做的任何修改,且无法恢复!!!
确定后同步将在后台操作,完成时将刷新页面,请耐心等待。
-- ---------------------------------------------------------- 主机: localhost-- 服务器版本: 10.3.7-MariaDB - mariadb.org binary distribution-- 服务器操作系统: Win64-- HeidiSQL 版本: 11.2.0.6232-- --------------------------------------------------------/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET NAMES utf8 */;/*!50503 SET NAMES utf8mb4 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;-- 导出 tabsync 的数据库结构CREATE DATABASE IF NOT EXISTS `tabsync` /*!40100 DEFAULT CHARACTER SET utf8 */;USE `tabsync`;-- 导出 表 tabsync.menu 结构CREATE TABLE IF NOT EXISTS `menu` (`id` varchar(64) NOT NULL COMMENT '主键',`name` varchar(64) DEFAULT NULL COMMENT '菜单名称',`menu_type` varchar(10) DEFAULT NULL COMMENT '菜单类型 0菜单 1按键 2功能',`level` int(11) NOT NULL DEFAULT 1 COMMENT '菜单层级',`parent_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '父级菜单ID',`remark` varchar(400) DEFAULT NULL COMMENT '菜单备注',`pm_mark` varchar(255) DEFAULT NULL COMMENT '权限标识符',`icon` varchar(40) DEFAULT NULL COMMENT '图标',`visible` varchar(32) NOT NULL DEFAULT '1' COMMENT '菜单是否可见 0不可见 1可见',`blank` int(11) DEFAULT NULL COMMENT '是否在新窗口打开 0 默认否, 1 是在新窗口打开',`url` varchar(50) DEFAULT NULL COMMENT '菜单链接',`order_num` int(11) DEFAULT NULL COMMENT '排序号升序排列,小的在前面',`create_time` datetime DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='操作菜单';-- 正在导出表 tabsync.menu 的数据:~42 rows (大约)/*!40000 ALTER TABLE `menu` DISABLE KEYS */;INSERT INTO `menu` (`id`, `name`, `menu_type`, `level`, `parent_id`, `remark`, `pm_mark`, `icon`, `visible`, `blank`, `url`, `order_num`, `create_time`) VALUES('1616982304771874960', '查询', '2', 3, '6666666666', '', 'system:menu:view', '', '0', 0, '', 1, NULL),('1616982313362858836', '角色管理', '0', 2, '5555555555', '', 'system:role:view', '', '1', 0, '', 103, NULL),('1616982317338928444', '查询', '2', 3, '7777777777', '', 'system:user:view', '', '1', 0, '', 1, NULL),('1617856384575699027', 'MYSQL同步', '0', 1, '0', '', 'system:tab:manage', '', '1', 1, '', 201, NULL),('1617856415985357199', '数据库配置', '0', 2, '1617856384575699027', '', 'system:tabConfig:view', '', '1', 1, '', 202, NULL),('1617856433349437985', '结构同步', '0', 2, '1617856384575699027', '', 'system:tabSync:view', '', '1', 1, '', 203, NULL),('1617856499660779557', '备用菜单', '0', 1, '0', '', 'system:bak', '', '1', 1, '', 301, NULL),('1617956051506105403', '新增', '1', 3, '6666666666', '', 'system:menu:add', '', '1', 0, '', 1, NULL),('1617956082746811777', '修改', '1', 3, '6666666666', '', 'system:menu:update', '', '1', 0, '', 3, NULL),('1617956109545824002', '删除', '1', 3, '6666666666', '', 'system:menu:delete', '', '1', 0, '', 4, NULL),('1617956178077686040', '查询', '2', 3, '1616982313362858836', '', 'system:role:view', '', '0', 0, '', 1, NULL),('1617956200872579094', '新增', '1', 3, '1616982313362858836', '', 'system:role:add', '', '1', 0, '', 2, NULL),('1617956200872579095', '新增', '1', 3, '7777777777', '', 'system:user:add', '', '1', 0, '', 2, NULL),('1617956224707929135', '修改', '1', 3, '1616982313362858836', '', 'system:role:update', '', '1', 0, '', 3, NULL),('1617956224707929136', '修改', '1', 3, '7777777777', '', 'system:user:update', '', '1', 0, '', 3, NULL),('1617956243677917460', '删除', '1', 3, '1616982313362858836', '', 'system:role:delete', '', '1', 0, '', 4, NULL),('1617956243677917461', '删除', '1', 3, '7777777777', '', 'system:user:delete', '', '1', 0, '', 4, NULL),('1618975853338179983', '查询', '2', 3, '1617856415985357199', '', 'system:tabConfig:view', '', '1', 1, '', 1, NULL),('1618979603829332128', '新增', '1', 3, '1617856415985357199', '', 'system:tabConfig:add', '', '1', 1, '', 1, NULL),('1618979628781643187', '修改', '1', 3, '1617856415985357199', '', 'system:tabConfig:update', '', '1', 1, '', 1, NULL),('1618979652046189100', '删除', '1', 3, '1617856415985357199', '', 'system:tabConfig:delete', '', '1', 1, '', 1, NULL),('1618979713508256167', '编辑数据库', '1', 3, '1617856415985357199', '', 'system:dbInfo:view', '', '1', 1, '', 1, NULL),('1618979831589167996', '新增数据库', '1', 3, '1617856415985357199', '', 'system:dbInfo:add', '', '1', 1, '', 1, NULL),('1618979852594649956', '修改数据库', '1', 3, '1617856415985357199', '', 'system:dbInfo:update', '', '1', 1, '', 1, NULL),('1618979872598382522', '删除数据库', '1', 3, '1617856415985357199', '', 'system:dbInfo:delete', '', '1', 1, '', 1, NULL),('1618979960038404792', '单表同步', '1', 3, '1617856433349437985', '', 'system:tabSync:one', '', '1', 1, '', 2, NULL),('1618979977506984139', '全表同步', '1', 3, '1617856433349437985', '', 'system:tabSync:all', '', '1', 1, '', 4, NULL),('1618985520146779500', '查看', '2', 3, '1617856433349437985', '', 'system:tabSync:view', '', '1', 1, '', 1, NULL),('1618989495106901801', '编辑角色菜单', '1', 3, '1616982313362858836', '', 'system:role:menu', '', '1', 0, '', 5, NULL),('1619063793942612867', '多表同步', '1', 3, '1617856433349437985', '', 'system:tabSync:some', '', '1', 1, '', 3, NULL),('1619178964737185311', '数据同步', '0', 2, '1617856384575699027', '', 'system:dataSync:view', '', '1', 1, '', 206, NULL),('1619182886110321594', '查看', '2', 3, '1619178964737185311', '', 'system:dataSync:view', '', '1', 1, '', 1, NULL),('1619182926179135906', '执行同步', '1', 3, '1619178964737185311', '', 'system:dataSync:doSync', '', '1', 1, '', 2, NULL),('1619354041408678799', '视图同步', '0', 2, '1617856384575699027', '', 'system:viewSync:view', '', '1', 1, '', 204, '2021-04-25 20:34:01'),('1619354062690734455', '函数同步', '0', 2, '1617856384575699027', '', 'system:funSync:view', '', '1', 1, '', 205, '2021-04-25 20:34:22'),('1619354090590204860', '查看', '2', 3, '1619354062690734455', '', 'system:funSync:view', '', '1', 1, '', 1, '2021-04-25 20:34:50'),('1619354120467443547', '查看', '2', 3, '1619354041408678799', '', 'system:viewSync:view', '', '1', 1, '', 1, '2021-04-25 20:35:20'),('1619354169061895429', '执行同步', '1', 3, '1619354041408678799', '', 'system:viewSync:doSync', '', '1', 1, '', 2, '2021-04-25 20:36:09'),('1619354201179670754', '执行同步', '1', 3, '1619354062690734455', '', 'system:funSync:doSync', '', '1', 1, '', 2, '2021-04-25 20:36:41'),('5555555555', '系统管理', '0', 1, '0', '系统管理', 'system:manage', '', '1', 0, '', 101, '2021-03-24 17:02:55'),('6666666666', '菜单管理', '0', 2, '5555555555', '菜单管理', 'system:menu:view', '', '1', 0, '', 102, '2021-03-24 17:02:55'),('7777777777', '用户管理', '0', 2, '5555555555', '用户管理', 'system:user:view', '', '1', 0, '', 104, '2021-03-25 09:36:00');/*!40000 ALTER TABLE `menu` ENABLE KEYS */;-- 导出 表 tabsync.role 结构CREATE TABLE IF NOT EXISTS `role` (`id` varchar(64) NOT NULL COMMENT '主键',`name` varchar(50) DEFAULT NULL COMMENT '角色名称(中文名称)',`remark` varchar(400) DEFAULT NULL COMMENT '角色备注',`sys_role` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0可删除 1系统内置角色不可删除',`create_time` datetime DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色';-- 正在导出表 tabsync.role 的数据:~3 rows (大约)/*!40000 ALTER TABLE `role` DISABLE KEYS */;INSERT INTO `role` (`id`, `name`, `remark`, `sys_role`, `create_time`) VALUES('1618996191103137028', '管理员', '普通管理员', 0, '2021-03-22 17:10:50'),('7777777777', '超管', '超级管理员', 1, '2021-03-21 17:02:07'),('8888888888', '普通用户', '普通用户', 0, '2021-03-25 09:36:45');/*!40000 ALTER TABLE `role` ENABLE KEYS */;-- 导出 表 tabsync.role_menu 结构CREATE TABLE IF NOT EXISTS `role_menu` (`menu_id` varchar(64) NOT NULL COMMENT '菜单主键',`role_id` varchar(64) NOT NULL COMMENT '角色主键',PRIMARY KEY (`menu_id`,`role_id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色菜单关系表';-- 正在导出表 tabsync.role_menu 的数据:~79 rows (大约)/*!40000 ALTER TABLE `role_menu` DISABLE KEYS */;INSERT INTO `role_menu` (`menu_id`, `role_id`) VALUES('1616982304771874960', '7777777777'),('1616982313362858836', '1618996191103137028'),('1616982313362858836', '7777777777'),('1616982313362858836', '8888888888'),('1616982317338928444', '1618996191103137028'),('1616982317338928444', '7777777777'),('1617856384575699027', '1618996191103137028'),('1617856384575699027', '7777777777'),('1617856384575699027', '8888888888'),('1617856415985357199', '1618996191103137028'),('1617856415985357199', '7777777777'),('1617856415985357199', '8888888888'),('1617856433349437985', '1618996191103137028'),('1617856433349437985', '7777777777'),('1617856433349437985', '8888888888'),('1617956051506105403', '7777777777'),('1617956082746811777', '7777777777'),('1617956109545824002', '7777777777'),('1617956178077686040', '1618996191103137028'),('1617956178077686040', '7777777777'),('1617956178077686040', '8888888888'),('1617956200872579094', '7777777777'),('1617956200872579095', '1618996191103137028'),('1617956200872579095', '7777777777'),('1617956224707929135', '7777777777'),('1617956224707929136', '1618996191103137028'),('1617956224707929136', '7777777777'),('1617956243677917460', '7777777777'),('1617956243677917461', '1618996191103137028'),('1617956243677917461', '7777777777'),('1618975853338179983', '1618996191103137028'),('1618975853338179983', '7777777777'),('1618975853338179983', '8888888888'),('1618979603829332128', '1618996191103137028'),('1618979603829332128', '7777777777'),('1618979628781643187', '1618996191103137028'),('1618979628781643187', '7777777777'),('1618979652046189100', '1618996191103137028'),('1618979652046189100', '7777777777'),('1618979713508256167', '1618996191103137028'),('1618979713508256167', '7777777777'),('1618979713508256167', '8888888888'),('1618979831589167996', '1618996191103137028'),('1618979831589167996', '7777777777'),('1618979852594649956', '1618996191103137028'),('1618979852594649956', '7777777777'),('1618979872598382522', '1618996191103137028'),('1618979872598382522', '7777777777'),('1618979960038404792', '1618996191103137028'),('1618979960038404792', '7777777777'),('1618979960038404792', '8888888888'),('1618979977506984139', '1618996191103137028'),('1618979977506984139', '7777777777'),('1618985520146779500', '1618996191103137028'),('1618985520146779500', '7777777777'),('1618985520146779500', '8888888888'),('1618989495106901801', '7777777777'),('1619063793942612867', '1618996191103137028'),('1619063793942612867', '7777777777'),('1619178964737185311', '1618996191103137028'),('1619178964737185311', '7777777777'),('1619178964737185311', '8888888888'),('1619182886110321594', '1618996191103137028'),('1619182886110321594', '7777777777'),('1619182886110321594', '8888888888'),('1619182926179135906', '1618996191103137028'),('1619182926179135906', '7777777777'),('1619354041408678799', '7777777777'),('1619354062690734455', '7777777777'),('1619354090590204860', '7777777777'),('1619354120467443547', '7777777777'),('1619354169061895429', '7777777777'),('1619354201179670754', '7777777777'),('5555555555', '1618996191103137028'),('5555555555', '7777777777'),('5555555555', '8888888888'),('6666666666', '7777777777'),('7777777777', '1618996191103137028'),('7777777777', '7777777777');/*!40000 ALTER TABLE `role_menu` ENABLE KEYS */;-- 导出 表 tabsync.table_config 结构CREATE TABLE IF NOT EXISTS `table_config` (`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '主键',`user_id` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '用户ID',`name` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '配置名称',`remark` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',`create_time` datetime DEFAULT NULL COMMENT '创建时间',`is_enable` varchar(4) COLLATE utf8_bin DEFAULT NULL COMMENT '是否启用 0不启用 1启用',`con_type` varchar(4) COLLATE utf8_bin DEFAULT '1' COMMENT '配置类型 1结构同步 2数据同步',PRIMARY KEY (`id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='表同步配置';-- 正在导出表 tabsync.table_config 的数据:~6 rows (大约)/*!40000 ALTER TABLE `table_config` DISABLE KEYS */;INSERT INTO `table_config` (`id`, `user_id`, `name`, `remark`, `create_time`, `is_enable`, `con_type`) VALUES('1618981364656183366', NULL, '测试', '1', '2021-04-21 13:02:44', '1', '2');/*!40000 ALTER TABLE `table_config` ENABLE KEYS */;-- 导出 表 tabsync.table_db_info 结构CREATE TABLE IF NOT EXISTS `table_db_info` (`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '主键',`config_id` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '同步配置ID',`db_type` varchar(4) COLLATE utf8_bin DEFAULT NULL COMMENT '数据库类型 1源数据库 2目标数据库',`db_sort` tinyint(4) DEFAULT NULL COMMENT '数据库序号',`db_host` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '主机IP端口',`db_username` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '主机用户名',`db_password` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '主机密码',`db_salt` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '生成秘钥的公钥',`data_base` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '数据库名',`mysql_type` varchar(4) COLLATE utf8_bin DEFAULT NULL COMMENT '数据库类型 5-Mysql5 8-Mysql8',`char_set` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '字符集 utf8',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='数据库信息';-- 正在导出表 tabsync.table_db_info 的数据:~16 rows (大约)/*!40000 ALTER TABLE `table_db_info` DISABLE KEYS */;INSERT INTO `table_db_info` (`id`, `config_id`, `db_type`, `db_sort`, `db_host`, `db_username`, `db_password`, `db_salt`, `data_base`, `mysql_type`, `char_set`) VALUES('1618982327882459900', '1618981364656183366', '1', NULL, '127.0.0.1:3306', 'root', 'oij+iYhdMec716qZKT5m5w==', '2f2ef07d-6817-4d90-9a0a-212b7dd4a9aa', 'tabsync', '5', 'utf8'),('1619058420504278826', '1618981364656183366', '2', NULL, '127.0.0.1:3306', 'root', '7EBkczruJ5nvsnd0rTfZhw==', '5f3ffc02-3fd9-4327-b76e-3e64ae970e7a', 'test', '5', 'utf8');/*!40000 ALTER TABLE `table_db_info` ENABLE KEYS */;-- 导出 表 tabsync.user 结构CREATE TABLE IF NOT EXISTS `user` (`id` varchar(64) NOT NULL COMMENT '主键',`user_name` varchar(64) DEFAULT NULL COMMENT '姓名',`login_name` varchar(64) NOT NULL COMMENT '登录账号',`password` varchar(64) DEFAULT NULL COMMENT '密码',`salt` varchar(64) DEFAULT NULL COMMENT '盐值',`locked` tinyint(4) DEFAULT NULL COMMENT '是否锁定 0未锁 1已锁定',`is_admin` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否超级管理员 0否 1是',PRIMARY KEY (`id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';-- 正在导出表 tabsync.user 的数据:~3 rows (大约)/*!40000 ALTER TABLE `user` DISABLE KEYS */;INSERT INTO `user` (`id`, `user_name`, `login_name`, `password`, `salt`, `locked`, `is_admin`) VALUES('1616635985833613598', '测试', 'test', '77fd5155afc47355c02f7a16568e8f40', 'd97d2d70-8fb8-4aa5-8b4c-32a4c93e239f', 1, 0),('1616635985833613599', '普通用户', 'test1', '7c0afdda971641b3d79f0e2344e4e732', '506dff06-b989-401f-b275-a64b4b2839f9', 0, 0),('8888888888', '超级管理员', 'admin', 'd1594fc70c2f99d38db534084ad338f8', '9af96af8-a2d8-4e4c-bcf1-92dbe0dc70a2', 0, 1);/*!40000 ALTER TABLE `user` ENABLE KEYS */;-- 导出 表 tabsync.user_role 结构CREATE TABLE IF NOT EXISTS `user_role` (`user_id` varchar(64) NOT NULL COMMENT '用户主键',`role_id` varchar(64) NOT NULL COMMENT '角色主键',PRIMARY KEY (`user_id`,`role_id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色关系表';-- 正在导出表 tabsync.user_role 的数据:~3 rows (大约)/*!40000 ALTER TABLE `user_role` DISABLE KEYS */;INSERT INTO `user_role` (`user_id`, `role_id`) VALUES('1616635985833613598', '8888888888'),('1616635985833613599', '1618996191103137028'),('8888888888', '7777777777');/*!40000 ALTER TABLE `user_role` ENABLE KEYS */;/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。