sojorn/go-backend/scripts/create_admin.sql
Patrick Britton a3fcfe67ab feat: replace Turnstile with ALTCHA for all authentication
- Add ALTCHA service with challenge generation and verification
- Update auth and admin handlers to use ALTCHA tokens
- Replace Turnstile widget with ALTCHA widget in Flutter app
- Update admin frontend to use ALTCHA token
- Add ALTCHA challenge endpoints for both auth and admin
- Maintain development bypass for testing
- Remove Turnstile dependencies from authentication flow
2026-02-16 22:18:29 -06:00

6 lines
447 B
SQL

INSERT INTO users (id, email, encrypted_password, status, mfa_enabled, email_newsletter, email_contact, created_at, updated_at)
VALUES (gen_random_uuid(), 'admin@sojorn.net', '$2a$10$qqXZMxr1cjYTNaN5v3YISes4/sQofUD0dn/.FQj6xJCgoQ4XpPi82', 'active', false, false, false, NOW(), NOW());
INSERT INTO profiles (id, handle, display_name, birth_month, birth_year)
SELECT id, 'admin', 'Admin User', 1, 1990 FROM users WHERE email = 'admin@sojorn.net';