-- MySQL dump 10.13  Distrib 5.6.50, for Linux (x86_64)
--
-- Host: localhost    Database: svnadmin
-- ------------------------------------------------------
-- Server version	5.6.50-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;

--
-- Table structure for table `admin_users`
--

DROP TABLE IF EXISTS `admin_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_users` (
  `admin_user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `admin_user_name` varchar(45) NOT NULL COMMENT '用户名',
  `admin_user_password` varchar(45) NOT NULL COMMENT '用户密码',
  `admin_user_phone` char(11) DEFAULT NULL COMMENT '用户手机号',
  `admin_user_email` varchar(45) DEFAULT NULL COMMENT '用户邮箱',
  PRIMARY KEY (`admin_user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理系统用户';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin_users`
--

LOCK TABLES `admin_users` WRITE;
/*!40000 ALTER TABLE `admin_users` DISABLE KEYS */;
INSERT INTO `admin_users` VALUES (1,'admin','admin',NULL,NULL);
/*!40000 ALTER TABLE `admin_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `black_token`
--

DROP TABLE IF EXISTS `black_token`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `black_token` (
  `token_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'tokenid',
  `token` varchar(200) NOT NULL COMMENT 'token内容',
  `start_time` varchar(45) NOT NULL COMMENT 'token的生效时间',
  `end_time` varchar(45) NOT NULL COMMENT 'token的失效时间',
  `insert_time` varchar(45) NOT NULL COMMENT '注销时间',
  PRIMARY KEY (`token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='黑名单token 意思为用户注销后尚未达到过期时间的token将会被加入此黑名单 通过定时的主动扫描来去除过期的token 达到注销即安全的目的';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `black_token`
--

LOCK TABLES `black_token` WRITE;
/*!40000 ALTER TABLE `black_token` DISABLE KEYS */;
/*!40000 ALTER TABLE `black_token` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logs`
--

DROP TABLE IF EXISTS `logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logs` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '日志id',
  `log_type_name` varchar(200) NOT NULL COMMENT '日志类型',
  `log_content` varchar(5000) NOT NULL COMMENT '日志内容',
  `log_add_user_name` varchar(200) NOT NULL COMMENT '操作人',
  `log_add_time` varchar(45) NOT NULL COMMENT '操作时间',
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='日志表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logs`
--

LOCK TABLES `logs` WRITE;
/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `options`
--

DROP TABLE IF EXISTS `options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `options` (
  `option_id` int(11) NOT NULL AUTO_INCREMENT,
  `option_name` varchar(191) NOT NULL,
  `option_value` longtext NOT NULL,
  `option_description` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`option_id`),
  UNIQUE KEY `option_name_UNIQUE` (`option_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全局配置项';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `options`
--

LOCK TABLES `options` WRITE;
/*!40000 ALTER TABLE `options` DISABLE KEYS */;
/*!40000 ALTER TABLE `options` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `svn_groups`
--

DROP TABLE IF EXISTS `svn_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `svn_groups` (
  `svn_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分组id',
  `svn_group_name` varchar(200) NOT NULL COMMENT '分组名称',
  `include_user_count` int(11) NOT NULL,
  `include_group_count` int(11) NOT NULL,
  `svn_group_note` varchar(1000) DEFAULT NULL COMMENT '分组备注信息',
  PRIMARY KEY (`svn_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='SVN分组表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `svn_groups`
--

LOCK TABLES `svn_groups` WRITE;
/*!40000 ALTER TABLE `svn_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `svn_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `svn_reps`
--

DROP TABLE IF EXISTS `svn_reps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `svn_reps` (
  `rep_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '仓库id',
  `rep_name` varchar(1000) NOT NULL COMMENT '仓库名称',
  `rep_size` double DEFAULT NULL COMMENT '仓库体积',
  `rep_note` varchar(1000) DEFAULT NULL COMMENT '仓库备注',
  `rep_rev` int(11) DEFAULT NULL COMMENT '仓库修订版本',
  `rep_uuid` varchar(45) DEFAULT NULL COMMENT '仓库UUID',
  PRIMARY KEY (`rep_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='仓库表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `svn_reps`
--

LOCK TABLES `svn_reps` WRITE;
/*!40000 ALTER TABLE `svn_reps` DISABLE KEYS */;
/*!40000 ALTER TABLE `svn_reps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `svn_user_pri_paths`
--

DROP TABLE IF EXISTS `svn_user_pri_paths`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `svn_user_pri_paths` (
  `svnn_user_pri_path_id` int(11) NOT NULL AUTO_INCREMENT,
  `rep_name` varchar(1000) NOT NULL COMMENT '仓库名称',
  `pri_path` mediumtext NOT NULL COMMENT '仓库路径',
  `rep_pri` varchar(45) DEFAULT NULL COMMENT '该用户所拥有的权限',
  `svn_user_name` varchar(200) NOT NULL COMMENT '该路径的权限的拥有人',
  `unique` varchar(20000) NOT NULL COMMENT '使用仓库名和路径和权限拼接的唯一值',
  PRIMARY KEY (`svnn_user_pri_path_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='SVN用户有权限的仓库路径';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `svn_user_pri_paths`
--

LOCK TABLES `svn_user_pri_paths` WRITE;
/*!40000 ALTER TABLE `svn_user_pri_paths` DISABLE KEYS */;
/*!40000 ALTER TABLE `svn_user_pri_paths` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `svn_users`
--

DROP TABLE IF EXISTS `svn_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `svn_users` (
  `svn_user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `svn_user_name` varchar(200) NOT NULL COMMENT '用户名',
  `svn_user_pass` varchar(200) NOT NULL COMMENT '用户密码',
  `svn_user_status` int(1) NOT NULL COMMENT '用户启用状态\n0 禁用\n1 启用',
  `svn_user_note` varchar(1000) DEFAULT NULL COMMENT '用户备注信息',
  PRIMARY KEY (`svn_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='svn用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `svn_users`
--

LOCK TABLES `svn_users` WRITE;
/*!40000 ALTER TABLE `svn_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `svn_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `verification_code`
--

DROP TABLE IF EXISTS `verification_code`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `verification_code` (
  `code_id` int(11) NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) NOT NULL COMMENT '每次验证码请求的唯一标识',
  `code` varchar(45) NOT NULL COMMENT '验证码',
  `start_time` varchar(45) NOT NULL COMMENT '有效开始时间',
  `end_time` varchar(45) NOT NULL COMMENT '失效时间',
  `insert_time` varchar(45) NOT NULL COMMENT '插入时间',
  PRIMARY KEY (`code_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='验证码';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `verification_code`
--

LOCK TABLES `verification_code` WRITE;
/*!40000 ALTER TABLE `verification_code` DISABLE KEYS */;
/*!40000 ALTER TABLE `verification_code` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'svnadmin'
--

--
-- Dumping routines for database 'svnadmin'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-05-09 14:22:54