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
388 B
SQL
11 lines
388 B
SQL
-- Rollback rules schema
|
|
DROP INDEX IF EXISTS idx_rule_run_actions_rule_run_id;
|
|
DROP INDEX IF EXISTS idx_rule_runs_started_utc;
|
|
DROP INDEX IF EXISTS idx_rule_runs_rule_id;
|
|
DROP TABLE IF EXISTS rule_run_actions;
|
|
DROP TABLE IF EXISTS rule_runs;
|
|
DROP TABLE IF EXISTS rule_actions;
|
|
DROP TABLE IF EXISTS rule_conditions;
|
|
DROP TABLE IF EXISTS rule_condition_groups;
|
|
DROP TABLE IF EXISTS rules;
|