RFC 503: Create sub_repo_permissions table
Created by: ryanslade
With the following schema:
create table sub_repo_permissions
(
repo_id integer not null
constraint sub_repo_permissions_repo_id_fk
references repo
on delete cascade,
user_id integer not null
constraint sub_repo_permissions_users_id_fk
references users
on delete cascade,
version int default 1 not null,
path_includes text[],
path_excludes text[],
updated_at timestamp with time zone default now() not null
);
comment on table sub_repo_permissions is 'Responsible for storing permissions at a finer granularity than repo';
create unique index sub_repo_permissions_repo_id_user_id_uindex
on sub_repo_permissions (repo_id, user_id)