22 lines
669 B
Markdown
22 lines
669 B
Markdown
# Database Migration Instructions
|
|
|
|
## Add auth_provider column to users table
|
|
|
|
Run this command in your backend directory:
|
|
|
|
```bash
|
|
# Windows (PowerShell)
|
|
$env:PGPASSWORD="recipes_password"; psql -h localhost -U recipes_user -d recipes_db -f add_auth_provider_column.sql
|
|
|
|
# Or using psql directly
|
|
psql -h localhost -U recipes_user -d recipes_db -f add_auth_provider_column.sql
|
|
```
|
|
|
|
This will:
|
|
1. Add the `auth_provider` column to the users table (default: 'local')
|
|
2. Update all existing users to have 'local' as their auth_provider
|
|
3. Create an index for faster lookups
|
|
4. Display the updated table structure
|
|
|
|
After running the migration, restart your backend server.
|