| | |
| | | -- ---------------------------- |
| | | -- 初始化-用户信息表数据 |
| | | -- ---------------------------- |
| | | insert into sys_user values(1, 103, 'admin', '', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '管理员'); |
| | | insert into sys_user values(2, 105, 'ry', '', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '测试员'); |
| | | insert into sys_user values(1, 103, 'admin', '', '00', 'se@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '管理员'); |
| | | insert into sys_user values(2, 105, 'ry', '', '00', 'se@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '测试员'); |
| | | |
| | | |
| | | -- ---------------------------- |
| | |
| | | DROP DATABASE IF EXISTS `se-seata`; |
| | | -- DROP DATABASE IF EXISTS `se-seata`; |
| | | |
| | | CREATE DATABASE `se-seata` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; |
| | | CREATE DATABASE IF NOT EXISTS `se-seata` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; |
| | | |
| | | SET NAMES utf8mb4; |
| | | SET FOREIGN_KEY_CHECKS = 0; |