12 lines
448 B
SQL
12 lines
448 B
SQL
-- Add mocked auth role for dev/mock OAuth users (roles table)
|
|
-- Use with: psql postgres://alinmeuser:password@localhost:5430/alinmedb -f database/scripts/seed_mock_role.sql
|
|
INSERT INTO "public"."roles" ("id", "name", "description", "created_at", "updated_at")
|
|
VALUES (
|
|
'a0000000-0000-0000-0000-000000000001',
|
|
'user',
|
|
'Default role for authenticated users (including mock OAuth dev users)',
|
|
now(),
|
|
now()
|
|
)
|
|
ON CONFLICT (name) DO NOTHING;
|