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