Files
deploy_server/migrations/002_target_extras.sql
egutierrez ff5c17f7ff refactor(store): migration files + embed.FS
- migrations/001_init.sql + 002_target_extras.sql extraidos de schema inline
- store.go: applyMigrations() con embed.FS, splitSQLStatements, isIdempotentError
- aplica regla db_migrations.md (fn_registry/.claude/rules/)

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
2026-05-09 00:44:52 +02:00

7 lines
488 B
SQL

-- Extra deploy_targets columns: strategy, source_dir, branch, compose_files.
-- Aplicacion idempotente: store.go captura "duplicate column" para DBs preexistentes.
ALTER TABLE deploy_targets ADD COLUMN strategy TEXT NOT NULL DEFAULT 'systemd';
ALTER TABLE deploy_targets ADD COLUMN source_dir TEXT NOT NULL DEFAULT '';
ALTER TABLE deploy_targets ADD COLUMN branch TEXT NOT NULL DEFAULT 'main';
ALTER TABLE deploy_targets ADD COLUMN compose_files TEXT NOT NULL DEFAULT '';