首页 > 代码库 > Icehouse版keystone数据库结构

Icehouse版keystone数据库结构

  在安装完keystone并利用keystone-manage命令同步数据库后,mysql(我使用的存储后端)中新加了如下表: 

 

assignment:

type         enum(UserProject,GroupProject,UserDomain,GroupDomain)actor_id     varchar(64)target_id    varchar(64)role_id      varchar(64)inherited    tinyint(1)

 

credential:

id           varchar(64)user_id      varchar(64)project_id   varchar(64)blob         texttype         varchar(255)extra        text

 

domain:

id          varchar(64)name        varchar(64)enabled     tinyint(1)extra       text

 

endpoint

id                    varchar(64)legacy_endpoint_id    varchar(64)interface             varchar(8)region                varchar(255)service_id            varchar(64)url                   textextra                 textenabled               tinyint(1)

 

federation_protocol:

id            varchar(64)idp_id        varchar(64)mapping_id    varchar(64)

 

group:

  不知道为什么这张表始终无法查看,是因为与mysql系统关键字重复了吗?

 

identity_provider:

 

id             varchar(64)
enabled tinyint(1)
description text

 

mapping:

id        varchar(64)rules     text

 

migrate_version

repository_id      varchar(250)repository_path    textversion            int(11)

 

policy:

id       varchar(64)type     varchar(255)blob     textextra    text

 

project

id            varchar(64)name          varchar(64)extra         textdescription   textenabled       tinyint(1)domain_id     varchar(64)

 

region:

id                  varchar(64)description         varchar(255)parent_region_id    varchar(64)extra               text

 

role:

id        varchar(64)name      varchar(255)extra     text

 

service

id        varchar(64)type      varchar(255)extra     mediumtextenabled   tinyint(1)

 

token:

id          varchar(64)expires     datetimeextra       mediumtextvalid       tinyint(1)trust_id    varchar(64)user_id     varchar(64)

 

trust

id                 varchar(64)trustor_user_id    varchar(64)trustee_user_id    varchar(64)project_id         varchar(64)impersonation      tinyint(1)deleted_at         datetimeexpires_at         datetimeextra              textremaining_uses     int(11)

 

trust_role

trust_id        varchar(64)role_id         varchar(64)

 

user:

id                    varchar(64)name                  varchar(255)extra    `            textpassword              varchar(128)enabled               tinyint(1)domian_id             varchar(64)default_project_id    varchar(64)

 

user_group_membership:

user_id              varchar(64)group_id             varchar(64)