ansible-role-kojihub/templates/koji-pgsql.sql.j2

19 lines
1.8 KiB
Plaintext
Raw Permalink Normal View History

2020-12-23 03:52:59 +00:00
with user_id as (insert into users (name, status, usertype) values ('{{ koji_admin_user }}', 0, 0) returning id)
2020-12-23 09:12:56 +00:00
insert into user_krb_principals (user_id, krb_principal) values ((select id from user_id),'{{ koji_admin_principal }}');
2020-12-23 03:52:59 +00:00
insert into user_perms (user_id, perm_id, creator_id) values (1, 1, 1);
2020-12-31 21:44:36 +00:00
with user_id as (insert into users (name, status, usertype) values ('{{ koji_kojira_user }}', 0, 0) returning id)
2020-12-23 18:40:29 +00:00
insert into user_krb_principals (user_id, krb_principal) values ((select id from user_id),'{{ koji_kojira_principal }}');
2020-12-23 09:12:56 +00:00
INSERT INTO user_perms (user_id, perm_id, creator_id) VALUES (2, 10, 1);
2021-01-02 07:06:23 +00:00
with user_id as (insert into users (name, status, usertype) values ('{{ koji_mbs_user }}', 0, 0) returning id)
2020-12-27 20:37:02 +00:00
insert into user_krb_principals (user_id, krb_principal) values ((select id from user_id),'{{ koji_mbs_principal }}');
INSERT INTO user_perms (user_id, perm_id, creator_id) VALUES (3, 1, 1);
2021-01-02 22:53:05 +00:00
with user_id as (insert into users (name, status, usertype) values ('{{ koji_sigul_user }}', 0, 0) returning id)
insert into user_krb_principals (user_id, krb_principal) values ((select id from user_id),'{{ koji_sigul_principal }}');
INSERT INTO user_perms (user_id, perm_id, creator_id) VALUES (4, 1, 1);
2021-02-16 05:39:49 +00:00
with user_id as (insert into users (name, status, usertype) values ('distrobuild', 0, 0) returning id)
insert into user_krb_principals (user_id, krb_principal) values ((select id from user_id),'koji/distrobuild@ROCKYLINUX.ORG');
INSERT INTO user_perms (user_id, perm_id, creator_id) VALUES (5, 1, 1);
with user_id as (insert into users (name, status, usertype) values ('{{ koji_gc_name }}', 0, 0) returning id)
insert into user_krb_principals (user_id, krb_principal) values ((select id from user_id),'{{ koji_gc_principal }}');
INSERT INTO user_perms (user_id, perm_id, creator_id) VALUES (6, 1, 1);