Files
admin/env/db/06_users_email_unique.sql
Oleksandr Bezdieniezhnykh c7b297de83
ci/woodpecker/push/01-test Pipeline failed
ci/woodpecker/push/02-build-push unknown status
refactor: remove deploy.cmd and update Dockerfile for health checks
- Deleted the deploy.cmd script as it was no longer needed.
- Updated Dockerfile to include curl for health checks and added a non-root user for improved security.
- Modified health check command to use curl for better reliability.
- Adjusted docker-compose.test.yml to reflect changes in health check configuration.
- Cleaned up appsettings.json and removed unused configuration properties.
- Removed Resource entity and related requests from the codebase as part of the architectural shift.
- Updated documentation to reflect the removal of hardware binding and related endpoints.

Co-authored-by: Cursor <cursoragent@cursor.com>
2026-05-13 08:47:21 +03:00

7 lines
415 B
SQL

-- Enforce uniqueness on users.email. Closes the duplicate-row race in
-- UserService.RegisterUser / RegisterDevice (security audit finding F-3, 2026-05-13).
-- Application code (Azaion.Services/UserService.cs) catches the resulting
-- Npgsql.PostgresException(SqlState=23505) and surfaces it as
-- BusinessException(EmailExists, code 5).
create unique index if not exists users_email_uidx on public.users (email);