about summary refs log tree commit diff
path: root/migrations
AgeCommit message (Collapse)Author
2025-07-31Add sysadmin-level privileges for user management.Frederick Muriuki Muriithi
2025-07-29Assign `system-administrator` role on all non-system resources.Frederick Muriuki Muriithi
2025-07-29Assign now system-wide resource-access privileges to sysadmins.Frederick Muriuki Muriithi
2025-07-29Add system-wide resource-access privileges for system administratorsFrederick Muriuki Muriithi
System administrators need to access, and modify the resources in the system, and to do that, we need to grant them specific privileges to check against. These privileges act on the wrapper resource objects, not necessarily the data attached to the resource object.
2025-07-22Migrations: Give sysadmins the 'system:user:edit' privilege.Frederick Muriuki Muriithi
2025-07-22Migrations: New privilege (system:user:edit)Frederick Muriuki Muriithi
Add a new privilege to give users the general ability to edit user information at the 'system level', i.e. edit user information for any user.
2025-07-03Add role management privileges to the group-leader role.Frederick Muriuki Muriithi
2025-06-09Add migrations for admin UI and batch edit privileges/roleszsloan
2025-06-09Link 'group:data:link-to-group' privilege to the group-leader role.Frederick Muriuki Muriithi
2025-06-09Add a new privilege: 'group:data:link-to-group'Frederick Muriuki Muriithi
2024-09-25feat: add base implementation for hooks systemJohn Nduli
2024-08-19Migrations: Add forgot_password_tokens tableFrederick Muriuki Muriithi
Create the `forgot_password_tokens` table to be used to enable users change their passwords if they forget.
2024-06-07migration: Drop `group_roles` db table.Frederick Muriuki Muriithi
2024-06-06migration: Create `resource_roles` db tableFrederick Muriuki Muriithi
2024-06-06migration: Move role-manipulation privileges from group to resourcesFrederick Muriuki Muriithi
Attach the role-manipulation privileges to the resource rather than the group, because the roles actually act on the resource itself - thus each role needs to track which resource it acts on.
2024-06-03Update db schema to allow user verification.Frederick Muriuki Muriithi
2024-05-09Refresh tokens: Create db schema.Frederick Muriuki Muriithi
2023-10-12migrations: Create role for dealing with inbredset groups.Frederick Muriuki Muriithi
2023-10-02migrations: New migration - InbredSet ResourcesFrederick Muriuki Muriithi
Provide a new migration to create tables to handle the InbredSet resources. The migration also sets up the resource category and the related privileges.
2023-09-29Make migrations directory a package.Frederick Muriuki Muriithi
2023-09-26Add `public-view` role. Assign it to users.Frederick Muriuki Muriithi
Add a new `public-view` role to be assigned to all users on all resources that are defined as publicly viewable. Update code to make assign `public-view` role to a newly registered user for all publicly viewable roles. Update the code to assign/revoke the `public-view` role to/from users whenever the resource is toggled to and from being publicly viewable. Ensure that `public-view` is not revoked from system-administrators. Ensure that `public-view` is not revoked from the group administrators of the group that owns the resource.
2023-09-26Fix foreign-key refs. Merge tables.Frederick Muriuki Muriithi
* Link the `role_id` field to the `roles` table rather than the `group_roles` table. * Merge the data in the `group_user_roles_on_resources` table in the `user_roles` table to have a single point-of-truth for all user roles on resources.
2023-09-26Add a 'system' resourceFrederick Muriuki Muriithi
Add a 'system' resource to allow users to have roles they can use to act on the system itself.
2023-09-26migrations: Create `group_resources` table.Frederick Muriuki Muriithi
2023-09-26Drop `group_id` from resources tableFrederick Muriuki Muriithi
Drop the `group_id` from the `resources` table and update all dependent tables to fix FOREIGN KEY constraints to ensure integrity of the data.
2023-09-26Add `system` and `group` resource categories.Frederick Muriuki Muriithi
2023-09-26Resources refactor: Add `resource_ownership` tableFrederick Muriuki Muriithi
New table to link resources to groups, where relevant.
2023-08-04Copy over files from GN3 repository.Frederick Muriuki Muriithi