Android下的配置管理之道之gerrit之psql数据库表介绍

本文介绍了Gerrit 2.12.x版本中与PostgreSQL数据库相关的表,包括accounts、account_groups等,详细阐述了各表的功能,如账号信息、群组成员、patch评论等,并提供了数据清理的SQL语句。
摘要由CSDN通过智能技术生成

gerrit 2.12.x 版本 数据库表介绍 之 postgresql

下面是2.12.x版本的 数据库表


                     List of relations
 TABLE_SCHEM | TABLE_NAME                  | TABLE_TYPE
 ------------+-----------------------------+-----------
 public      | account_external_ids        | TABLE
 public      | account_group_by_id         | TABLE
 public      | account_group_by_id_aud     | TABLE
 public      | account_group_members       | TABLE
 public      | account_group_members_audit | TABLE
 public      | account_group_names         | TABLE
 public      | account_groups              | TABLE
 public      | account_patch_reviews       | TABLE
 public      | account_project_watches     | TABLE
 public      | account_ssh_keys            | TABLE
 public      | accounts                    | TABLE
 public      | change_messages             | TABLE
 public      | changes                     | TABLE
 public      | patch_comments              | TABLE
 public      | patch_set_approvals         | TABLE
 public      | patch_sets                  | TABLE
 public      | schema_version              | TABLE
 public      | starred_changes             | TABLE
 public      | submodule_subscriptions     | TABLE
 public      | system_config               | TABLE

accounts表

这个表是保存账号相关信息的

SELECT ordinal_position,column_name, data_type, column_default FROM information_schema.columns WHERE table_name ='accounts';

 ordinal_position | column_name                   | data_type                | column_default
 -----------------+-------------------------------+--------------------------+---------------
 1                | registered_on                 | timestamp with time zone | NULL
 2                | full_name                     | character varying        | NULL
 3                | preferred_email               | character varying        | NULL
 5                | maximum_page_size             | smallint                 | 0
 6                | show_site_header              | character                | 'N'::bpchar
 7                | use_flash_clipboard           | character                | 'N'::bpchar
 8                | download_url                  | character varying        | NULL
 9                | download_command              | character varying        | NULL
 10               | copy_self_on_email            | character                | 'N'::bpchar
 11               | date_format                   | character varying        | NULL
 12               | time_format                   | character varying        | NULL
 13               | relative_date_in_change_table | character                | 'N'::bpchar
 14               | diff_view                     | character varying        | NULL
 15               | size_bar_in_change_table      | character                | 'N'::bpchar
 16               | legacycid_in_change_table     | character                | 'N'::bpchar
 17               | review_category_strategy      | character varying        | NULL
 18               | mute_common_path_prefixes     | character                | 'N'::bpchar
 19               | inactive                      | character                | 'N'::bpchar
 20               | account_id                    | integer                  | 0


select account_id, full_name, preferred_email from accounts where account_id=1000000;
 account_id | full_name  |     preferred_email      
------------+------------+--------------------------
    1000000 | xxxxxxx xx | xxxxxx.xx@xxxxxxxxx.com

account_id 是个数字,第一次登录gerrit的时候会自动分配一个,这个基本上是账号的唯一标识了。第一个登录的账号id是1000000,后续的依次累加。
full_name 是 全名,显示的名称,和登录时候填写的账号可以是不一样的,这里也可以是中文的,如果是用的ldap认证的,这里就是ldap里面的全名。
preferred_email 是邮箱地址,如果是用的ldap认证的,这里就是ldap里面的邮箱。

inactive 表示这个账号是否可用,取值 'N''Y', N表示不能使用,不能登录,不能访问ssh下代码等。表示账号被禁用。离职的员工可用把账号禁用了。

account_external_ids 表

SELECT ordinal_position,column_name, data_type, column_default FROM information_schema.columns WHERE table_name ='account_external_ids';

 ordinal_position | column_name   | data_type         | column_default
 -----------------+---------------+-------------------+----------------------
 1                | account_id    | integer           | 0
 2                | email_address | character varying | NULL
 3                | password      | character varying | NULL
 4                | external_id   | character varying | ''::character varying

account_groups 表

这个是群组相关的表。还有个account_group_names表和他对应的,这个表只存放了群组名称。


SELECT ordinal_position,column_name, data_type, column_default FROM information_schema.columns WHERE table_name ='account_groups';          

 ordinal_position | column_name      | data_type         
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值