|
|
-- Create Database
|
|
|
-- ----------------------------------------------------------
|
|
|
CREATE DATABASE IF NOT EXISTS moss DEFAULT CHARACTER SET = utf8mb4;
|
|
|
|
|
|
Use moss;
|
|
|
|
|
|
SET NAMES utf8;
|
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for `t_app`
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `t_app`;
|
|
|
CREATE TABLE `t_app`
|
|
|
(
|
|
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '应用Id',
|
|
|
`app_id` varchar(200) NOT NULL,
|
|
|
`name` varchar(200) NOT NULL DEFAULT '' COMMENT '应用名称',
|
|
|
`owner_name` varchar(200) NOT NULL DEFAULT '' COMMENT '负责人姓名',
|
|
|
`owner_id` varchar(200) DEFAULT '0' COMMENT '负责人Id',
|
|
|
`project_name` varchar(200) NOT NULL DEFAULT '' COMMENT '所属项目名称',
|
|
|
`project_key` varchar(200) NOT NULL DEFAULT '0' COMMENT '所属项目Id',
|
|
|
`description` varchar(1000) DEFAULT '' COMMENT '应用描述',
|
|
|
`gmt_create` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
|
|
|
`gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
|
|
|
`status` tinyint(4) DEFAULT '0' COMMENT '应用的状态 0-创建 1-开发中 2-运行中 3-已下线',
|
|
|
`take_over` tinyint(4) DEFAULT '0',
|
|
|
`ops_owner_name` varchar(200) DEFAULT NULL,
|
|
|
`ops_owner_id` varchar(200) DEFAULT NULL,
|
|
|
`repo_url` varchar(1000) DEFAULT NULL,
|
|
|
`bu_name` varchar(255) DEFAULT NULL,
|
|
|
`spring_application_name` varchar(255) DEFAULT NULL,
|
|
|
`spring_boot_version` int(2) DEFAULT '0',
|
|
|
`spring_cloud_version` int(2) DEFAULT '0',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE = InnoDB
|
|
|
AUTO_INCREMENT = 287
|
|
|
DEFAULT CHARSET = utf8 COMMENT ='应用表';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of `t_app`
|
|
|
-- ----------------------------
|
|
|
BEGIN;
|
|
|
INSERT INTO `t_app`
|
|
|
VALUES ('1', 'halo-moss', 'halo-moss', '许进', 'xujin', 'halo', 'Halo', '', '2019-02-27 02:23:42', '2019-04-21 10:15:04',
|
|
|
'0', '2', '1', '韩令三', 'lingshan.han', 'https://github.com/SoftwareKing/Moss.git', 'XX', 'halo-moss', '2', '2'),
|
|
|
('2', 'moss-sample-1.5.x', 'moss-sample-1.5.x', '杜为极', 'weiji.du', 'BKCASHIER', 'MOSS', '',
|
|
|
'2019-02-27 02:23:42', '2019-04-21 10:15:27', '0', '2', '1', '叶张', 'dingf.ye001',
|
|
|
'https://github.com/SoftwareKing/Moss.git', '金融XX', 'moss-sample-1.5.x', '1', '1'),
|
|
|
('3', 'moss-sample-2.1.x', 'moss-sample-2.1.x', '许进', 'guojian.li', 'MOSS', 'MOSS', '', '2019-02-27 02:23:42',
|
|
|
'2019-04-21 10:15:22', '0', '2', '1', '齐思宇', 'daiying.qi', 'https://github.com/SoftwareKing/Moss.git', '房XX',
|
|
|
'moss-sample-2.1.x', '2', '2');
|
|
|
COMMIT;
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for `t_app_name`
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `t_app_name`;
|
|
|
CREATE TABLE `t_app_name`
|
|
|
(
|
|
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
|
`name` varchar(200) NOT NULL DEFAULT '' COMMENT '应用名称',
|
|
|
`gmt_create` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
|
|
|
`gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE = InnoDB
|
|
|
AUTO_INCREMENT = 4
|
|
|
DEFAULT CHARSET = utf8 COMMENT ='应用name表';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for `t_dict_data`
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `t_dict_data`;
|
|
|
CREATE TABLE `t_dict_data`
|
|
|
(
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '数据字典详细主键',
|
|
|
`dict_code` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '数据字典分类标识',
|
|
|
`item_name` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '数据字典详细名称',
|
|
|
`item_value` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '数据字典详细值',
|
|
|
`item_desc` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '数据字典详细描述',
|
|
|
`item_sort` int(16) DEFAULT NULL COMMENT '排序',
|
|
|
`gmt_create` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
|
|
|
`gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
|
|
|
`status` tinyint(4) DEFAULT '0' COMMENT 'COMMENT ''数据字典项启用状态,1:启用,0:未启用'',',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE = InnoDB
|
|
|
AUTO_INCREMENT = 22
|
|
|
DEFAULT CHARSET = utf8
|
|
|
COLLATE = utf8_bin COMMENT ='数据字典详细表';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of `t_dict_data`
|
|
|
-- ----------------------------
|
|
|
BEGIN;
|
|
|
INSERT INTO `t_dict_data`
|
|
|
VALUES ('1', 'springBootVersion', '1.5.13.RELEASE', '1', '1.5.13.RELEASE', '0', '1970-01-02 00:00:00',
|
|
|
'2019-03-15 17:44:15', '0', '1'),
|
|
|
('2', 'springBootVersion', '2.0.7.RELEASE', '2', '2.0.7.RELEASE', '0', '1970-01-02 00:00:00',
|
|
|
'2019-03-15 17:44:19', '0', '1'),
|
|
|
('3', 'springCloudVersion', 'Edgware.SR3', '1', 'Spring Cloud Edgware.SR3', '0', '1970-01-02 00:00:00',
|
|
|
'2019-03-15 17:44:27', '0', '1'),
|
|
|
('4', 'springCloudVersion', 'Finchley.SR2', '2', 'Spring Cloud Finchley.SR2', '0', '1970-01-02 00:00:00',
|
|
|
'2019-03-15 17:44:31', '0', '1'),
|
|
|
('5', 'frameworkVerison', '1.1.8.RELEASE', '1', '1.1.8.RELEASE', '0', '1970-01-02 00:00:00',
|
|
|
'2019-04-10 19:58:48', '1', '1'),
|
|
|
('6', 'frameworkVerison', '2.0.0.RELEASE', '2', '2.0.0.RELEASE', '0', '1970-01-02 00:00:00',
|
|
|
'2019-04-10 19:58:48', '1', '1'),
|
|
|
('11', 'appFlickerRule', '当实例数小于2', '1', '当实例数小于2时闪烁', '0', '1970-01-02 00:00:00', '2019-03-19 13:44:36', '0',
|
|
|
'1'),
|
|
|
('12', 'scoringRules', '当实例数大于1', '1', '当实例数大于1给1颗星', '0', '1970-01-02 00:00:00', '2019-03-19 13:42:48', '0',
|
|
|
'1');
|
|
|
COMMIT;
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for `t_dict_type`
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `t_dict_type`;
|
|
|
CREATE TABLE `t_dict_type`
|
|
|
(
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '数据字典分类主键',
|
|
|
`dict_name` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '数据字典分类名称',
|
|
|
`dict_code` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '数据字典分类唯一标识',
|
|
|
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '数据字典分类启用状态,0:启用,1:未启用',
|
|
|
`gmt_create` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
|
|
|
`gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE = InnoDB
|
|
|
AUTO_INCREMENT = 11
|
|
|
DEFAULT CHARSET = utf8
|
|
|
COLLATE = utf8_bin COMMENT ='数据字典分类表';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of `t_dict_type`
|
|
|
-- ----------------------------
|
|
|
BEGIN;
|
|
|
INSERT INTO `t_dict_type`
|
|
|
VALUES ('1', 'Spring Boot的版本', 'springBootVersion', '0', '2019-03-12 02:36:02', '2019-03-14 14:17:10', '0'),
|
|
|
('2', 'Spring Cloud的版本', 'springCloudVersion', '0', '2019-03-12 02:36:42', '2019-03-14 14:17:27', '0'),
|
|
|
('3', 'Summer Framework的版本', 'frameworkVerison', '0', '2019-03-12 02:37:21', '2019-03-14 14:17:41', '1'),
|
|
|
('6', 'App根据实例数闪烁规则', 'appFlickerRule', '0', '2019-03-15 01:55:56', '2019-03-15 01:55:56', '0'),
|
|
|
('7', '评分规则', 'scoringRules', '0', '2019-03-15 01:56:22', '2019-03-15 01:56:22', '0');
|
|
|
COMMIT;
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for `t_menu`
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `t_menu`;
|
|
|
CREATE TABLE `t_menu`
|
|
|
(
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`parent_id` bigint(20) DEFAULT NULL,
|
|
|
`name` varchar(255) DEFAULT NULL,
|
|
|
`parent_ids` varchar(255) DEFAULT NULL,
|
|
|
`url` varchar(255) DEFAULT NULL,
|
|
|
`roles` varchar(255) DEFAULT NULL,
|
|
|
`sort` int(11) NOT NULL DEFAULT '1',
|
|
|
`icon` varchar(255) DEFAULT NULL,
|
|
|
`gmt_create` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
|
|
|
`gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
|
|
|
`key` varchar(255) NOT NULL,
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE = InnoDB
|
|
|
AUTO_INCREMENT = 32
|
|
|
DEFAULT CHARSET = utf8;
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of `t_menu`
|
|
|
-- ----------------------------
|
|
|
BEGIN;
|
|
|
INSERT INTO `t_menu`
|
|
|
VALUES ('1', '0', '总览', '0', '/dashboard', 'USER,ADMIN', '6', 'dashboard', '1970-01-02 00:00:00', '2019-03-01 18:36:14',
|
|
|
'0', 'dashboard'),
|
|
|
('2', '0', '服务治理', '0', '/#/application', 'USER,ADMIN', '5', 'appstore', '1970-01-02 00:00:00',
|
|
|
'2019-03-01 17:34:03', '0', 'serviceMgmt'),
|
|
|
('5', '0', '平台管理', '0', '/#', 'USER,ADMIN', '1', 'hdd', '1970-01-02 00:00:00', '2019-04-04 04:12:52', '0',
|
|
|
'projectMgmt'),
|
|
|
('6', '4', '推送记录', '0', '/switchCenter', 'USER,ADMIN', '1', 'code', '1970-01-02 00:00:00', '2019-01-03 16:21:07',
|
|
|
'0', 'switchPushLog'),
|
|
|
('10', '4', '开关管理', '0', '/switchCenter', 'USER,ADMIN', '1', 'key', '1970-01-02 00:00:00', '2019-01-03 11:01:32',
|
|
|
'0', 'switchManage'),
|
|
|
('11', '4', '机器管理', '0', null, 'USER,ADMIN', '1', 'database', '1970-01-02 00:00:00', '2018-12-10 14:04:18', '0',
|
|
|
'machine'),
|
|
|
('12', '0', '系统管理', '0', '', 'ADMIN', '1', 'setting', '1970-01-02 00:00:00', '2018-12-10 14:15:55', '0', 'sys'),
|
|
|
('13', '12', '菜单管理', '0', '/OSManage', 'USER,ADMIN', '1', 'profile', '1970-01-02 00:00:00',
|
|
|
'2018-12-10 14:04:24', '0', 'menuManage'),
|
|
|
('16', '5', '应用管理', '0', '/application', 'ADMIN', '1', 'euro', '1970-01-02 00:00:00', '2019-04-19 21:47:35', '0',
|
|
|
'appAccept'),
|
|
|
('24', '2', '服务管理', '0', '/application', 'USER,ADMIN', '5', 'deployment-unit', '2019-02-22 03:21:10',
|
|
|
'2019-04-19 21:49:06', '0', 'serviceManage'),
|
|
|
('25', '2', '事件中心', '0', '/application', 'USER,ADMIN', '0', 'setting', '2019-02-25 03:22:10',
|
|
|
'2019-02-25 03:22:24', '0', 'eventLog'),
|
|
|
('26', '2', '实例管理', '0', '/application', 'USER,ADMIN', '3', 'ant-design', '1970-01-02 00:00:00',
|
|
|
'2019-04-19 21:50:22', '0', 'list'),
|
|
|
('27', '5', '项目列表', '0', '/application', 'ADMIN', '2', 'project', '2019-03-07 02:33:31', '2019-04-19 21:48:32',
|
|
|
'0', 'Project'),
|
|
|
('28', '12', '用户列表', '0', '/userMgmt', 'USER,ADMIN', '0', 'user', '2019-03-07 02:35:53', '2019-04-04 06:53:52',
|
|
|
'0', 'userMgmt'),
|
|
|
('30', '12', '数据字典', '0', '/remoteConfig', 'ADMIN', '0', 'appstore', '2019-03-13 03:10:28',
|
|
|
'2019-03-13 03:10:28', '0', 'remoteConfig'),
|
|
|
('31', '5', '注册中心', '0', '/registerCenterMgmt', 'ADMIN', '0', 'gateway', '2019-04-04 04:13:20',
|
|
|
'2019-04-19 21:48:02', '0', 'registerCenterMgmt');
|
|
|
COMMIT;
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for `t_project`
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `t_project`;
|
|
|
CREATE TABLE `t_project`
|
|
|
(
|
|
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '项目Id',
|
|
|
`name` varchar(200) NOT NULL DEFAULT '' COMMENT '项目名称',
|
|
|
`cname` varchar(200) NOT NULL DEFAULT '' COMMENT '项目中文名称',
|
|
|
`key` varchar(200) NOT NULL DEFAULT '0' COMMENT '项目key',
|
|
|
`owner_name` varchar(200) NOT NULL DEFAULT '' COMMENT '负责人姓名',
|
|
|
`owner_id` varchar(200) DEFAULT '0' COMMENT '负责人Id',
|
|
|
`description` varchar(1000) DEFAULT '' COMMENT '项目描述',
|
|
|
`gmt_create` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
|
|
|
`gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE = InnoDB
|
|
|
AUTO_INCREMENT = 216
|
|
|
DEFAULT CHARSET = utf8 COMMENT ='项目表';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of `t_project`
|
|
|
-- ----------------------------
|
|
|
BEGIN;
|
|
|
INSERT INTO `t_project`
|
|
|
VALUES ('1', '服务治理', '服务治理', 'MOSS', '许进', 'xujin', '服务治理', '2019-02-28 21:01:18', '2019-04-05 14:42:36', '0'),
|
|
|
('2', '中台项目', '中台项目', 'HALO', '许进', 'xujin', '', '2019-02-28 21:02:25', '2019-04-05 14:43:09', '0'),
|
|
|
('3', 'PMO', 'PMO', 'PMO', '黎茂', 'mao.li001', '', '2019-02-28 21:02:25', '2019-03-07 16:45:13', '1'),
|
|
|
('4', 'XXXUED', 'XXXUED', 'UED', '王佳琳', 'jialin.wang', '', '2019-02-28 21:02:26', '2019-03-07 16:45:17', '1');
|
|
|
COMMIT;
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for `t_register_center`
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `t_register_center`;
|
|
|
CREATE TABLE `t_register_center`
|
|
|
(
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
|
`code` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '注册中心标识',
|
|
|
`url` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '注册中心url',
|
|
|
`desc` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '描述',
|
|
|
`status` tinyint(1) NOT NULL COMMENT '1 运行,0 停用',
|
|
|
`gmt_create` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
|
|
|
`gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
|
|
|
`name` varchar(50) COLLATE utf8_bin DEFAULT NULL,
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE = InnoDB
|
|
|
AUTO_INCREMENT = 5
|
|
|
DEFAULT CHARSET = utf8
|
|
|
COLLATE = utf8_bin COMMENT ='注册中心表';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of `t_register_center`
|
|
|
-- ----------------------------
|
|
|
BEGIN;
|
|
|
INSERT INTO `t_register_center`
|
|
|
VALUES ('1', 'sq', 'http://eureka.springcloud.cn/eureka/', '社区注册', '1', '2019-04-04 04:28:11', '2019-04-05 18:54:45',
|
|
|
'0', '社区注册'),
|
|
|
('4', 'zj', 'http://localhost:8071/eureka', '自己本地', '0', '2019-04-20 22:37:04', '2019-04-21 11:37:25', '0',
|
|
|
'自己本地');
|
|
|
COMMIT;
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for `t_user`
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `t_user`;
|
|
|
CREATE TABLE `t_user`
|
|
|
(
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
|
`username` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '英文名唯一',
|
|
|
`name` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '中文名',
|
|
|
`password` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '密码',
|
|
|
`status` tinyint(1) NOT NULL COMMENT '是否启用',
|
|
|
`gmt_create` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
|
|
|
`gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
|
|
|
`email` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE = InnoDB
|
|
|
AUTO_INCREMENT = 7
|
|
|
DEFAULT CHARSET = utf8
|
|
|
COLLATE = utf8_bin COMMENT ='用户表';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of `t_user`
|
|
|
-- ----------------------------
|
|
|
BEGIN;
|
|
|
INSERT INTO `t_user`
|
|
|
VALUES ('1', 'xujin', 'xujin', 'UUKHSDDI5KPA43A8VL06V0TU2', '0', '2019-03-06 20:23:50', '2019-03-08 19:15:35', '0',
|
|
|
'Software_King@qq.com'),
|
|
|
('6', 'admin', 'admin', 'UUKHSDDI5KPA43A8VL06V0TU2', '0', '2019-04-12 04:37:00', '2019-04-21 11:38:48', '0',
|
|
|
'admin@qq.com');
|
|
|
COMMIT;
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for `t_user_app`
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `t_user_app`;
|
|
|
CREATE TABLE `t_user_app`
|
|
|
(
|
|
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
|
`mail_nick_name` varchar(200) NOT NULL DEFAULT '' COMMENT '邮箱前缀名称',
|
|
|
`app_id` varchar(200) NOT NULL DEFAULT '' COMMENT '应用名称',
|
|
|
`gmt_create` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
|
|
|
`gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE = InnoDB
|
|
|
AUTO_INCREMENT = 48
|
|
|
DEFAULT CHARSET = utf8 COMMENT ='应用name表';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of `t_user_app`
|
|
|
-- ----------------------------
|
|
|
BEGIN;
|
|
|
INSERT INTO `t_user_app`
|
|
|
VALUES ('38', 'xujin', 'halo-moss', '2019-03-10 05:46:39', '2019-04-05 01:31:23', '1'),
|
|
|
('39', 'xujin', 'loop_test', '2019-03-10 07:44:23', '2019-03-10 07:44:27', '1'),
|
|
|
('40', 'admin', 'halo-moss', '2019-03-11 22:45:05', '2019-03-11 22:45:07', '1'),
|
|
|
('41', 'test', 'halo-moss', '2019-03-12 00:03:39', '2019-03-12 00:03:51', '1'),
|
|
|
('42', 'test', 'loop_test', '2019-03-12 00:52:27', '2019-03-12 01:04:15', '1'),
|
|
|
('43', 'admin', 'loop_test', '2019-03-12 04:37:18', '2019-03-12 04:37:21', '1'),
|
|
|
('44', 'admin', 'loop_test', '2019-03-12 04:37:23', '2019-03-12 04:37:24', '1'),
|
|
|
('45', 'admin', 'loop_test', '2019-03-14 09:13:35', '2019-03-14 09:13:41', '1'),
|
|
|
('46', 'test', 'halo-moss', '2019-03-18 04:17:17', '2019-03-18 04:17:19', '1'),
|
|
|
('47', 'xujin', 'halo-moss', '2019-04-10 06:47:12', '2019-04-10 06:47:12', '0');
|
|
|
COMMIT;
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for `t_user_roles`
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `t_user_roles`;
|
|
|
CREATE TABLE `t_user_roles`
|
|
|
(
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
|
`username` varchar(50) COLLATE utf8_bin NOT NULL,
|
|
|
`role` varchar(50) COLLATE utf8_bin NOT NULL,
|
|
|
`gmt_create` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
|
|
|
`gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
|
|
|
PRIMARY KEY (`id`),
|
|
|
UNIQUE KEY `ix_auth_username` (`username`, `role`) USING BTREE
|
|
|
) ENGINE = InnoDB
|
|
|
AUTO_INCREMENT = 16
|
|
|
DEFAULT CHARSET = utf8
|
|
|
COLLATE = utf8_bin;
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of `t_user_roles`
|
|
|
-- ----------------------------
|
|
|
BEGIN;
|
|
|
INSERT INTO `t_user_roles`
|
|
|
VALUES ('11', 'admin', 'ADMIN', '2019-03-06 20:24:51', '2019-03-07 16:27:54', '0'),
|
|
|
('12', 'xujin', 'ADMIN', '2019-03-08 05:15:41', '2019-03-08 19:16:52', '0'),
|
|
|
('13', 'test', 'USER', '1970-01-02 00:00:00', '2019-03-12 12:52:40', '0');
|
|
|
COMMIT;
|
|
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1; |