Update dev_scripts.sql - Githubissues

Police-Data-Accessibility-Project / prod-to-dev-migration

Regularly migrates production database and schema to development database

1 stars 0 forks source link

Update dev_scripts.sql #4

Closed maxachis closed 1 month ago

maxachis commented 4 months ago

Fixes

https://github.com/Police-Data-Accessibility-Project/data-sources-app/issues/316

Description

Add user_roles enum
Convert all 'null' roles in users table to 'user'
Have 'user' be default value for 'role' column

Testing

Will need to be validated with related update to web app

Performance

Performance impact marginal

Docs

Not applicable.