Bug 958: Fix the Postgres database table issues and its relevant code changes device_group and role_device_group
Review Request #372 — Created July 25, 2024 and submitted — Latest diff uploaded
| Information | |
|---|---|
| apoorva.sn | |
| AMP | |
| amp_3_7_1 | |
| 958 | |
| Reviewers | |
| pmurugaiyan, prajesh, shuinvy | |
Problem
Fix the Postgres database table issues and its relevant code changes
1.device_group and role_device_group
2. file_type and file_listSolution
Added id column to device_group and make it the primary key for the table
Added new column device_group_id to role_device_group table and make it the foreign key referring to id from device group.
Since the existing entries in the role_device_group will not have any value for device_group_id column added script to populate the value for that column during the upgrade process
Also made similar changes in file_type and file_list as above
Tested the changes and shared screenshots of the tables before and after upgrade