aboutsummaryrefslogtreecommitdiff
path: root/migrations
AgeCommit message (Collapse)Author
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