3ea5e6416f
Add declarative infrastructure for self-hosted DevOps stack on black: Reconciliation service (devops-stack.sh): - Detects Docker installation and daemon status - Auto-generates secrets on first deployment - Syncs config from repo to remote - Manages container lifecycle - Staged deployment (Forgejo first, Woodpecker after OAuth) Docker configuration: - Forgejo with nginx proxy, postgres, runner - Woodpecker CI with Forgejo OAuth integration - Shared network for internal communication Integration: - Added to black host inventory - rectify-deploy detects forgejo/woodpecker changes - Convenience wrapper script (deploy-devops-stack.sh) Also removes deprecated service-registry (replaced by status-dashboard). 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
63 lines
2.4 KiB
SQL
63 lines
2.4 KiB
SQL
-- Feature Flags Database Initialization
|
|
|
|
CREATE SCHEMA IF NOT EXISTS flags;
|
|
|
|
-- Feature flags table
|
|
CREATE TABLE IF NOT EXISTS flags.feature_flags (
|
|
id VARCHAR(100) PRIMARY KEY,
|
|
name VARCHAR(255) NOT NULL,
|
|
description TEXT,
|
|
type VARCHAR(50) NOT NULL DEFAULT 'boolean',
|
|
default_value JSONB NOT NULL DEFAULT 'false',
|
|
enabled BOOLEAN DEFAULT TRUE,
|
|
environments TEXT[] DEFAULT ARRAY['development', 'staging', 'production'],
|
|
tags TEXT[] DEFAULT '{}',
|
|
created_by UUID,
|
|
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
|
|
updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
|
|
);
|
|
|
|
-- Flag overrides (per-user, per-group, percentage)
|
|
CREATE TABLE IF NOT EXISTS flags.feature_flag_overrides (
|
|
id SERIAL PRIMARY KEY,
|
|
flag_id VARCHAR(100) NOT NULL REFERENCES flags.feature_flags(id) ON DELETE CASCADE,
|
|
override_type VARCHAR(50) NOT NULL,
|
|
target_id VARCHAR(255),
|
|
target_value JSONB NOT NULL,
|
|
percentage INTEGER,
|
|
priority INTEGER DEFAULT 0,
|
|
expires_at TIMESTAMP WITH TIME ZONE,
|
|
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
|
|
CONSTRAINT valid_override CHECK (
|
|
(override_type = 'user' AND target_id IS NOT NULL) OR
|
|
(override_type = 'group' AND target_id IS NOT NULL) OR
|
|
(override_type = 'percentage' AND percentage IS NOT NULL)
|
|
)
|
|
);
|
|
|
|
-- Audit log
|
|
CREATE TABLE IF NOT EXISTS flags.feature_flag_audit (
|
|
id SERIAL PRIMARY KEY,
|
|
flag_id VARCHAR(100) NOT NULL,
|
|
action VARCHAR(50) NOT NULL,
|
|
old_value JSONB,
|
|
new_value JSONB,
|
|
changed_by UUID,
|
|
changed_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
|
|
reason TEXT
|
|
);
|
|
|
|
-- Indexes
|
|
CREATE INDEX IF NOT EXISTS idx_flags_enabled ON flags.feature_flags(enabled);
|
|
CREATE INDEX IF NOT EXISTS idx_flags_tags ON flags.feature_flags USING GIN(tags);
|
|
CREATE INDEX IF NOT EXISTS idx_overrides_flag ON flags.feature_flag_overrides(flag_id);
|
|
CREATE INDEX IF NOT EXISTS idx_overrides_target ON flags.feature_flag_overrides(override_type, target_id);
|
|
CREATE INDEX IF NOT EXISTS idx_audit_flag ON flags.feature_flag_audit(flag_id);
|
|
CREATE INDEX IF NOT EXISTS idx_audit_time ON flags.feature_flag_audit(changed_at DESC);
|
|
|
|
-- Permissions
|
|
GRANT ALL PRIVILEGES ON SCHEMA flags TO lilith;
|
|
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA flags TO lilith;
|
|
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA flags TO lilith;
|
|
|
|
DO $$ BEGIN RAISE NOTICE 'Feature flags database initialized'; END $$;
|