| -- MySQL dump 10.13 Distrib 5.7.32, for Linux (x86_64) |
| -- |
| -- Host: localhost Database: ApolloPortalDB |
| -- ------------------------------------------------------ |
| -- Server version 5.7.32 |
| |
| /*!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 */; |
| |
| -- |
| -- Current Database: `ApolloPortalDB` |
| -- |
| |
| CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ApolloPortalDB` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; |
| |
| USE `ApolloPortalDB`; |
| |
| -- |
| -- Table structure for table `App` |
| -- |
| |
| DROP TABLE IF EXISTS `App`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `App` ( |
| `Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', |
| `AppId` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'AppID', |
| `Name` varchar(500) NOT NULL DEFAULT 'default' COMMENT '应用名', |
| `OrgId` varchar(32) NOT NULL DEFAULT 'default' COMMENT '部门Id', |
| `OrgName` varchar(64) NOT NULL DEFAULT 'default' COMMENT '部门名字', |
| `OwnerName` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'ownerName', |
| `OwnerEmail` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'ownerEmail', |
| `IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal', |
| `DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀', |
| `DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| `DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀', |
| `DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间', |
| PRIMARY KEY (`Id`), |
| KEY `AppId` (`AppId`(191)), |
| KEY `DataChange_LastTime` (`DataChange_LastTime`), |
| KEY `IX_Name` (`Name`(191)) |
| ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='应用表'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `App` |
| -- |
| |
| LOCK TABLES `App` WRITE; |
| /*!40000 ALTER TABLE `App` DISABLE KEYS */; |
| INSERT INTO `App` VALUES (1,'SampleApp','Sample App','TEST1','样例部门1','apollo','apollo@acme.com',_binary '\0','default','2021-01-06 11:52:43','','2021-01-06 11:52:43'); |
| /*!40000 ALTER TABLE `App` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `AppNamespace` |
| -- |
| |
| DROP TABLE IF EXISTS `AppNamespace`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `AppNamespace` ( |
| `Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键', |
| `Name` varchar(32) NOT NULL DEFAULT '' COMMENT 'namespace名字，注意，需要全局唯一', |
| `AppId` varchar(32) NOT NULL DEFAULT '' COMMENT 'app id', |
| `Format` varchar(32) NOT NULL DEFAULT 'properties' COMMENT 'namespace的format类型', |
| `IsPublic` bit(1) NOT NULL DEFAULT b'0' COMMENT 'namespace是否为公共', |
| `Comment` varchar(64) NOT NULL DEFAULT '' COMMENT '注释', |
| `IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal', |
| `DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT '' COMMENT '创建人邮箱前缀', |
| `DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| `DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀', |
| `DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间', |
| PRIMARY KEY (`Id`), |
| KEY `IX_AppId` (`AppId`), |
| KEY `Name_AppId` (`Name`,`AppId`), |
| KEY `DataChange_LastTime` (`DataChange_LastTime`) |
| ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='应用namespace定义'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `AppNamespace` |
| -- |
| |
| LOCK TABLES `AppNamespace` WRITE; |
| /*!40000 ALTER TABLE `AppNamespace` DISABLE KEYS */; |
| INSERT INTO `AppNamespace` VALUES (1,'application','SampleApp','properties',_binary '\0','default app namespace',_binary '\0','','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(2,'dubbo','SampleApp','properties',_binary '\0','',_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'); |
| /*!40000 ALTER TABLE `AppNamespace` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `Authorities` |
| -- |
| |
| DROP TABLE IF EXISTS `Authorities`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `Authorities` ( |
| `Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id', |
| `Username` varchar(64) NOT NULL, |
| `Authority` varchar(50) NOT NULL, |
| PRIMARY KEY (`Id`) |
| ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `Authorities` |
| -- |
| |
| LOCK TABLES `Authorities` WRITE; |
| /*!40000 ALTER TABLE `Authorities` DISABLE KEYS */; |
| INSERT INTO `Authorities` VALUES (1,'apollo','ROLE_user'); |
| /*!40000 ALTER TABLE `Authorities` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `Consumer` |
| -- |
| |
| DROP TABLE IF EXISTS `Consumer`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `Consumer` ( |
| `Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id', |
| `AppId` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'AppID', |
| `Name` varchar(500) NOT NULL DEFAULT 'default' COMMENT '应用名', |
| `OrgId` varchar(32) NOT NULL DEFAULT 'default' COMMENT '部门Id', |
| `OrgName` varchar(64) NOT NULL DEFAULT 'default' COMMENT '部门名字', |
| `OwnerName` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'ownerName', |
| `OwnerEmail` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'ownerEmail', |
| `IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal', |
| `DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀', |
| `DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| `DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀', |
| `DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间', |
| PRIMARY KEY (`Id`), |
| KEY `AppId` (`AppId`(191)), |
| KEY `DataChange_LastTime` (`DataChange_LastTime`) |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='开放API消费者'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `Consumer` |
| -- |
| |
| LOCK TABLES `Consumer` WRITE; |
| /*!40000 ALTER TABLE `Consumer` DISABLE KEYS */; |
| /*!40000 ALTER TABLE `Consumer` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `ConsumerAudit` |
| -- |
| |
| DROP TABLE IF EXISTS `ConsumerAudit`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `ConsumerAudit` ( |
| `Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id', |
| `ConsumerId` int(11) unsigned DEFAULT NULL COMMENT 'Consumer Id', |
| `Uri` varchar(1024) NOT NULL DEFAULT '' COMMENT '访问的Uri', |
| `Method` varchar(16) NOT NULL DEFAULT '' COMMENT '访问的Method', |
| `DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| `DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间', |
| PRIMARY KEY (`Id`), |
| KEY `IX_DataChange_LastTime` (`DataChange_LastTime`), |
| KEY `IX_ConsumerId` (`ConsumerId`) |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='consumer审计表'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `ConsumerAudit` |
| -- |
| |
| LOCK TABLES `ConsumerAudit` WRITE; |
| /*!40000 ALTER TABLE `ConsumerAudit` DISABLE KEYS */; |
| /*!40000 ALTER TABLE `ConsumerAudit` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `ConsumerRole` |
| -- |
| |
| DROP TABLE IF EXISTS `ConsumerRole`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `ConsumerRole` ( |
| `Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id', |
| `ConsumerId` int(11) unsigned DEFAULT NULL COMMENT 'Consumer Id', |
| `RoleId` int(10) unsigned DEFAULT NULL COMMENT 'Role Id', |
| `IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal', |
| `DataChange_CreatedBy` varchar(32) DEFAULT '' COMMENT '创建人邮箱前缀', |
| `DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| `DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀', |
| `DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间', |
| PRIMARY KEY (`Id`), |
| KEY `IX_DataChange_LastTime` (`DataChange_LastTime`), |
| KEY `IX_RoleId` (`RoleId`), |
| KEY `IX_ConsumerId_RoleId` (`ConsumerId`,`RoleId`) |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='consumer和role的绑定表'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `ConsumerRole` |
| -- |
| |
| LOCK TABLES `ConsumerRole` WRITE; |
| /*!40000 ALTER TABLE `ConsumerRole` DISABLE KEYS */; |
| /*!40000 ALTER TABLE `ConsumerRole` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `ConsumerToken` |
| -- |
| |
| DROP TABLE IF EXISTS `ConsumerToken`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `ConsumerToken` ( |
| `Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id', |
| `ConsumerId` int(11) unsigned DEFAULT NULL COMMENT 'ConsumerId', |
| `Token` varchar(128) NOT NULL DEFAULT '' COMMENT 'token', |
| `Expires` datetime NOT NULL DEFAULT '2099-01-01 00:00:00' COMMENT 'token失效时间', |
| `IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal', |
| `DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀', |
| `DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| `DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀', |
| `DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间', |
| PRIMARY KEY (`Id`), |
| UNIQUE KEY `IX_Token` (`Token`), |
| KEY `DataChange_LastTime` (`DataChange_LastTime`) |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='consumer token表'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `ConsumerToken` |
| -- |
| |
| LOCK TABLES `ConsumerToken` WRITE; |
| /*!40000 ALTER TABLE `ConsumerToken` DISABLE KEYS */; |
| /*!40000 ALTER TABLE `ConsumerToken` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `Favorite` |
| -- |
| |
| DROP TABLE IF EXISTS `Favorite`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `Favorite` ( |
| `Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', |
| `UserId` varchar(32) NOT NULL DEFAULT 'default' COMMENT '收藏的用户', |
| `AppId` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'AppID', |
| `Position` int(32) NOT NULL DEFAULT '10000' COMMENT '收藏顺序', |
| `IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal', |
| `DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀', |
| `DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| `DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀', |
| `DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间', |
| PRIMARY KEY (`Id`), |
| KEY `AppId` (`AppId`(191)), |
| KEY `IX_UserId` (`UserId`), |
| KEY `DataChange_LastTime` (`DataChange_LastTime`) |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='应用收藏表'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `Favorite` |
| -- |
| |
| LOCK TABLES `Favorite` WRITE; |
| /*!40000 ALTER TABLE `Favorite` DISABLE KEYS */; |
| /*!40000 ALTER TABLE `Favorite` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `Permission` |
| -- |
| |
| DROP TABLE IF EXISTS `Permission`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `Permission` ( |
| `Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id', |
| `PermissionType` varchar(32) NOT NULL DEFAULT '' COMMENT '权限类型', |
| `TargetId` varchar(256) NOT NULL DEFAULT '' COMMENT '权限对象类型', |
| `IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal', |
| `DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT '' COMMENT '创建人邮箱前缀', |
| `DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| `DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀', |
| `DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间', |
| PRIMARY KEY (`Id`), |
| KEY `IX_TargetId_PermissionType` (`TargetId`(191),`PermissionType`), |
| KEY `IX_DataChange_LastTime` (`DataChange_LastTime`) |
| ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COMMENT='permission表'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `Permission` |
| -- |
| |
| LOCK TABLES `Permission` WRITE; |
| /*!40000 ALTER TABLE `Permission` DISABLE KEYS */; |
| INSERT INTO `Permission` VALUES (1,'CreateCluster','SampleApp',_binary '\0','','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(2,'CreateNamespace','SampleApp',_binary '\0','','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(3,'AssignRole','SampleApp',_binary '\0','','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(4,'ModifyNamespace','SampleApp+application',_binary '\0','','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(5,'ReleaseNamespace','SampleApp+application',_binary '\0','','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(6,'CreateApplication','SystemRole',_binary '\0','apollo','2021-01-05 21:54:27','apollo','2021-01-05 21:54:27'),(7,'ModifyNamespace','SampleApp+application+DEV',_binary '\0','apollo','2021-01-05 22:00:26','apollo','2021-01-05 22:00:26'),(8,'ReleaseNamespace','SampleApp+application+DEV',_binary '\0','apollo','2021-01-05 22:00:26','apollo','2021-01-05 22:00:26'),(9,'ModifyNamespace','SampleApp+dubbo',_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'),(10,'ReleaseNamespace','SampleApp+dubbo',_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'),(11,'ModifyNamespace','SampleApp+dubbo+DEV',_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'),(12,'ReleaseNamespace','SampleApp+dubbo+DEV',_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'); |
| /*!40000 ALTER TABLE `Permission` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `Role` |
| -- |
| |
| DROP TABLE IF EXISTS `Role`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `Role` ( |
| `Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id', |
| `RoleName` varchar(256) NOT NULL DEFAULT '' COMMENT 'Role name', |
| `IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal', |
| `DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀', |
| `DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| `DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀', |
| `DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间', |
| PRIMARY KEY (`Id`), |
| KEY `IX_RoleName` (`RoleName`(191)), |
| KEY `IX_DataChange_LastTime` (`DataChange_LastTime`) |
| ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='角色表'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `Role` |
| -- |
| |
| LOCK TABLES `Role` WRITE; |
| /*!40000 ALTER TABLE `Role` DISABLE KEYS */; |
| INSERT INTO `Role` VALUES (1,'Master+SampleApp',_binary '\0','default','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(2,'ModifyNamespace+SampleApp+application',_binary '\0','default','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(3,'ReleaseNamespace+SampleApp+application',_binary '\0','default','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(4,'CreateApplication+SystemRole',_binary '\0','apollo','2021-01-05 21:54:27','apollo','2021-01-05 21:54:27'),(5,'ModifyNamespace+SampleApp+application+DEV',_binary '\0','apollo','2021-01-05 22:00:26','apollo','2021-01-05 22:00:26'),(6,'ReleaseNamespace+SampleApp+application+DEV',_binary '\0','apollo','2021-01-05 22:00:26','apollo','2021-01-05 22:00:26'),(7,'ModifyNamespace+SampleApp+dubbo',_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'),(8,'ReleaseNamespace+SampleApp+dubbo',_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'),(9,'ModifyNamespace+SampleApp+dubbo+DEV',_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'),(10,'ReleaseNamespace+SampleApp+dubbo+DEV',_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'); |
| /*!40000 ALTER TABLE `Role` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `RolePermission` |
| -- |
| |
| DROP TABLE IF EXISTS `RolePermission`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `RolePermission` ( |
| `Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id', |
| `RoleId` int(10) unsigned DEFAULT NULL COMMENT 'Role Id', |
| `PermissionId` int(10) unsigned DEFAULT NULL COMMENT 'Permission Id', |
| `IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal', |
| `DataChange_CreatedBy` varchar(32) DEFAULT '' COMMENT '创建人邮箱前缀', |
| `DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| `DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀', |
| `DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间', |
| PRIMARY KEY (`Id`), |
| KEY `IX_DataChange_LastTime` (`DataChange_LastTime`), |
| KEY `IX_RoleId` (`RoleId`), |
| KEY `IX_PermissionId` (`PermissionId`) |
| ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COMMENT='角色和权限的绑定表'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `RolePermission` |
| -- |
| |
| LOCK TABLES `RolePermission` WRITE; |
| /*!40000 ALTER TABLE `RolePermission` DISABLE KEYS */; |
| INSERT INTO `RolePermission` VALUES (1,1,1,_binary '\0','','2021-01-06 11:52:44','','2021-01-06 11:52:44'),(2,1,2,_binary '\0','','2021-01-06 11:52:44','','2021-01-06 11:52:44'),(3,1,3,_binary '\0','','2021-01-06 11:52:44','','2021-01-06 11:52:44'),(4,2,4,_binary '\0','','2021-01-06 11:52:44','','2021-01-06 11:52:44'),(5,3,5,_binary '\0','','2021-01-06 11:52:44','','2021-01-06 11:52:44'),(6,4,6,_binary '\0','apollo','2021-01-05 21:54:27','apollo','2021-01-05 21:54:27'),(7,5,7,_binary '\0','apollo','2021-01-05 22:00:26','apollo','2021-01-05 22:00:26'),(8,6,8,_binary '\0','apollo','2021-01-05 22:00:26','apollo','2021-01-05 22:00:26'),(9,7,9,_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'),(10,8,10,_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'),(11,9,11,_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'),(12,10,12,_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'); |
| /*!40000 ALTER TABLE `RolePermission` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `ServerConfig` |
| -- |
| |
| DROP TABLE IF EXISTS `ServerConfig`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `ServerConfig` ( |
| `Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id', |
| `Key` varchar(64) NOT NULL DEFAULT 'default' COMMENT '配置项Key', |
| `Value` varchar(2048) NOT NULL DEFAULT 'default' COMMENT '配置项值', |
| `Comment` varchar(1024) DEFAULT '' COMMENT '注释', |
| `IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal', |
| `DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀', |
| `DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| `DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀', |
| `DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间', |
| PRIMARY KEY (`Id`), |
| KEY `IX_Key` (`Key`), |
| KEY `DataChange_LastTime` (`DataChange_LastTime`) |
| ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='配置服务自身配置'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `ServerConfig` |
| -- |
| |
| LOCK TABLES `ServerConfig` WRITE; |
| /*!40000 ALTER TABLE `ServerConfig` DISABLE KEYS */; |
| INSERT INTO `ServerConfig` VALUES (1,'apollo.portal.envs','dev','可支持的环境列表',_binary '\0','default','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(2,'organizations','[{\"orgId\":\"TEST1\",\"orgName\":\"样例部门1\"},{\"orgId\":\"TEST2\",\"orgName\":\"样例部门2\"}]','部门列表',_binary '\0','default','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(3,'superAdmin','apollo','Portal超级管理员',_binary '\0','default','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(4,'api.readTimeout','10000','http接口read timeout',_binary '\0','default','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(5,'consumer.token.salt','someSalt','consumer token salt',_binary '\0','default','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(6,'admin.createPrivateNamespace.switch','true','是否允许项目管理员创建私有namespace',_binary '\0','default','2021-01-06 11:52:43','','2021-01-06 11:52:43'),(7,'configView.memberOnly.envs','dev','只对项目成员显示配置信息的环境列表，多个env以英文逗号分隔',_binary '\0','default','2021-01-06 11:52:43','','2021-01-06 11:52:43'); |
| /*!40000 ALTER TABLE `ServerConfig` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `UserRole` |
| -- |
| |
| DROP TABLE IF EXISTS `UserRole`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `UserRole` ( |
| `Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id', |
| `UserId` varchar(128) DEFAULT '' COMMENT '用户身份标识', |
| `RoleId` int(10) unsigned DEFAULT NULL COMMENT 'Role Id', |
| `IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal', |
| `DataChange_CreatedBy` varchar(32) DEFAULT '' COMMENT '创建人邮箱前缀', |
| `DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| `DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀', |
| `DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间', |
| PRIMARY KEY (`Id`), |
| KEY `IX_DataChange_LastTime` (`DataChange_LastTime`), |
| KEY `IX_RoleId` (`RoleId`), |
| KEY `IX_UserId_RoleId` (`UserId`,`RoleId`) |
| ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='用户和role的绑定表'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `UserRole` |
| -- |
| |
| LOCK TABLES `UserRole` WRITE; |
| /*!40000 ALTER TABLE `UserRole` DISABLE KEYS */; |
| INSERT INTO `UserRole` VALUES (1,'apollo',1,_binary '\0','','2021-01-06 11:52:44','','2021-01-06 11:52:44'),(2,'apollo',2,_binary '\0','','2021-01-06 11:52:44','','2021-01-06 11:52:44'),(3,'apollo',3,_binary '\0','','2021-01-06 11:52:44','','2021-01-06 11:52:44'),(4,'apollo',7,_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'),(5,'apollo',8,_binary '\0','apollo','2021-01-05 22:07:20','apollo','2021-01-05 22:07:20'); |
| /*!40000 ALTER TABLE `UserRole` ENABLE KEYS */; |
| UNLOCK TABLES; |
| |
| -- |
| -- Table structure for table `Users` |
| -- |
| |
| DROP TABLE IF EXISTS `Users`; |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `Users` ( |
| `Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id', |
| `Username` varchar(64) NOT NULL DEFAULT 'default' COMMENT '用户名', |
| `Password` varchar(64) NOT NULL DEFAULT 'default' COMMENT '密码', |
| `Email` varchar(64) NOT NULL DEFAULT 'default' COMMENT '邮箱地址', |
| `Enabled` tinyint(4) DEFAULT NULL COMMENT '是否有效', |
| PRIMARY KEY (`Id`) |
| ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户表'; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
| |
| -- |
| -- Dumping data for table `Users` |
| -- |
| |
| LOCK TABLES `Users` WRITE; |
| /*!40000 ALTER TABLE `Users` DISABLE KEYS */; |
| INSERT INTO `Users` VALUES (1,'apollo','$2a$10$7r20uS.BQ9uBpf3Baj3uQOZvMVvB1RN3PYoKE94gtz2.WAOuiiwXS','apollo@acme.com',1); |
| /*!40000 ALTER TABLE `Users` ENABLE KEYS */; |
| UNLOCK TABLES; |
| /*!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 2021-01-06 20:18:08 |
