GraceSolutions
09a09d4a68
Phase 1 foundations: - Go backend with Chi router framework - SQLite database with WAL mode and foreign keys - Database migrations for users, roles, credentials, AD connections, schedules, rules, and audit - CLI commands: init, run, install, uninstall, start, stop, migrate, backup, restore, doctor - Configuration loading from environment variables - Centralized logging with file rotation (lumberjack) - Crypto package for Argon2id password hashing and AES-GCM encryption - Auth service with session management - Audit service for event logging - Scheduler with 6-field cron support - REST API routes scaffolded for all major resources - CORS support with localhost defaults for development - Docker support with Dockerfile and docker-compose.yml - Multi-platform build script (PowerShell) - Project structure per design specification Version format: yyyy.MM.dd.HHmm All PKs are UUIDv4, all timestamps UTC
11 lines
318 B
SQL
11 lines
318 B
SQL
-- Rollback initial schema
|
|
DROP TABLE IF EXISTS schedules;
|
|
DROP TABLE IF EXISTS ad_connections;
|
|
DROP TABLE IF EXISTS credentials;
|
|
DROP TABLE IF EXISTS oidc_providers;
|
|
DROP TABLE IF EXISTS api_keys;
|
|
DROP TABLE IF EXISTS sessions;
|
|
DROP TABLE IF EXISTS user_roles;
|
|
DROP TABLE IF EXISTS roles;
|
|
DROP TABLE IF EXISTS users;
|