You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
89 lines
3.6 KiB
89 lines
3.6 KiB
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : 127.0.0.1
|
|
Source Server Type : MySQL
|
|
Source Server Version : 50723
|
|
Source Host : 127.0.0.1:3306
|
|
Source Schema : etcd-manage
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 50723
|
|
File Encoding : 65001
|
|
|
|
Date: 11/08/2019 21:10:37
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for etcd_servers
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `etcd_servers`;
|
|
CREATE TABLE `etcd_servers` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`version` varchar(3) NOT NULL DEFAULT 'v3' COMMENT 'etcd版本',
|
|
`name` varchar(30) NOT NULL DEFAULT '' COMMENT 'etcd服务名字',
|
|
`address` varchar(600) NOT NULL COMMENT 'etcd地址列表',
|
|
`prefix` varchar(100) NOT NULL DEFAULT '' COMMENT 'key前缀，建议不为空，防止大量key',
|
|
`tls_enable` varchar(5) NOT NULL DEFAULT 'true' COMMENT '是否启用tls连接',
|
|
`cert_file` text NOT NULL COMMENT '证书',
|
|
`key_file` text NOT NULL COMMENT '证书',
|
|
`ca_file` text NOT NULL COMMENT '证书',
|
|
`username` varchar(60) NOT NULL DEFAULT '' COMMENT '用户名',
|
|
`password` varchar(60) NOT NULL DEFAULT '' COMMENT '密码',
|
|
`desc` varchar(300) NOT NULL COMMENT '描述信息',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='etched server列表';
|
|
|
|
-- ----------------------------
|
|
-- Records of etcd_servers
|
|
-- ----------------------------
|
|
BEGIN;
|
|
INSERT INTO `etcd_servers` VALUES (1, 'v3', 'local', '127.0.0.1:2379', '', 'false', '', '', '', '', '', '本机测试');
|
|
INSERT INTO `etcd_servers` VALUES (3, 'v3', '测试', '127.0.0.1:2379', '', 'false', '', '', '', '', '', '备注一下');
|
|
INSERT INTO `etcd_servers` VALUES (4, 'v2', 'v2测试', '127.0.0.1:2379', '', 'false', '', '', '', '', '', 'v2备注');
|
|
COMMIT;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for role_etcd_servers
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `role_etcd_servers`;
|
|
CREATE TABLE `role_etcd_servers` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`etcd_server_id` int(11) NOT NULL DEFAULT '0' COMMENT 'etcd服务id',
|
|
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0读 1写 2读写',
|
|
`created_at` datetime NOT NULL COMMENT '添加时间',
|
|
`updated_at` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色权限表';
|
|
|
|
-- ----------------------------
|
|
-- Table structure for roles
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `roles`;
|
|
CREATE TABLE `roles` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(60) NOT NULL DEFAULT '' COMMENT '角色名',
|
|
`created_at` datetime NOT NULL COMMENT '添加时间',
|
|
`updated_at` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色表';
|
|
|
|
-- ----------------------------
|
|
-- Table structure for users
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `users`;
|
|
CREATE TABLE `users` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`username` varchar(60) NOT NULL DEFAULT '' COMMENT '用户名',
|
|
`password` char(32) NOT NULL DEFAULT '' COMMENT '密码',
|
|
`email` varchar(300) NOT NULL DEFAULT '' COMMENT '邮箱',
|
|
`role_id` int(11) NOT NULL DEFAULT '0' COMMENT '角色id',
|
|
`created_at` datetime NOT NULL COMMENT '添加时间',
|
|
`updated_at` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|