스킬 파일

Flyway Migrations

Name: Flyway Migrations
Author: zapek

Flyway SQL migration patterns for Xeres including naming conventions, H2 database patterns, enum types, foreign keys, and best practices.

zapek202 스타2026. 4. 10.

직업
카테고리: 데이터베이스 도구

스킬 내용

Flyway Migration Patterns for Xeres

Migration Location

app/src/main/resources/db/migration/

Naming Convention

V<major>_<minor>_<timestamp>__<description>.sql

Examples:

V00_0_1_202001232214__InitDb.sql
V00_0_32_202603092327__AddIndices.sql

Table Creation Pattern

CREATE TABLE profile (
    id          BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    name        VARCHAR(255) NOT NULL,
    pgp_id      BIGINT,
    created     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT profile_pkey PRIMARY KEY (id)
);

CREATE INDEX idx_profile_name ON profile(name);

Enum Types

관련 스킬

Flyway Migrations | Skills Pool

CREATE TYPE trust_level AS ENUM ('UNKNOWN', 'NEVER', 'MARGINAL', 'FULLY', 'ULTIMATE');

ALTER TABLE profile ADD COLUMN trust trust_level NOT NULL DEFAULT 'UNKNOWN';

ALTER TABLE contact
    ADD CONSTRAINT fk_contact_profile
    FOREIGN KEY (profile_id) REFERENCES profile(id)
    ON DELETE CASCADE;

-- V00_0_33__AddLocations.sql
ALTER TABLE location DROP COLUMN IF EXISTS last_seen;

Flyway Migrations

Flyway Migration Patterns for Xeres

Migration Location

Naming Convention

Table Creation Pattern

Enum Types

Flyway Migrations

Flyway Migration Patterns for Xeres

Migration Location

Naming Convention

Table Creation Pattern

Enum Types

Foreign Keys

Best Practices

Rolling Back

Testing Migrations

Database Migrations

Database Migrations

Postgres Patterns

Frontend Query & Mutation

Db Migrations

Drizzle