Run any Skill in Manus with one click

$pwd:

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.

Run Skill in Manus

$ git log --oneline --stat

stars:203

forks:21

updated:April 10, 2026 at 16:45

SKILL.md

readonly

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

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

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

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

Foreign Keys

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

Best Practices

Separate index creation from table creation
Name all constraints explicitly for easier debugging
Use BIGINT for IDs with GENERATED BY DEFAULT AS IDENTITY
Include NOT NULL constraints where appropriate
Default values for optional columns
One concern per migration when possible
Timestamp precision must always be of TIMESTAMP(9)

Rolling Back

Add downward migrations with V<version>__<name>.sql (no timestamp):

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

Testing Migrations

Flyway runs automatically on application startup with H2 database.

related-skills.json

same repository

archunit-rules.md

from "zapek/Xeres"

ArchUnit architecture rules enforced in Xeres including common module rules (logging, utility classes), app module rules (no field injection, RsService naming), and UI module rules (WindowController naming).

2026-04-10203

crypto.md

from "zapek/Xeres"

Cryptography patterns for Xeres including PGP operations, key generation, and hash functions with best practices.

2026-04-10203

dto-mappers.md

from "zapek/Xeres"

DTO and mapper patterns for Xeres using Java records, canonical constructors with validation, and static mapper utility classes.

2026-04-10203

gradle-build.md

from "zapek/Xeres"

Gradle build configuration for Xeres including build commands, version management, module structure, and key plugins.

2026-04-10203

java-conventions.md

from "zapek/Xeres"

Code style, naming conventions, license headers, and patterns for Xeres Java project. Covers Allman braces, utility classes, package structure, and field injection rules.

2026-04-10203

javafx-patterns.md

from "zapek/Xeres"

JavaFX patterns for Xeres including controller structure with FXML views, WindowController lifecycle, WindowManager usage, and JavaFX-Spring integration.

2026-04-10203

package.json

"author": "zapek"

"repository": "zapek/Xeres"

View GitHub Repository View Creator Repositories

$ install --global

$ download --local

Run Skill in Manus

$ useful --forSOC

Database ArchitectsComputer and Mathematical Occupations15-1243L4

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

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

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

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

Foreign Keys

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

Best Practices

Separate index creation from table creation
Name all constraints explicitly for easier debugging
Use BIGINT for IDs with GENERATED BY DEFAULT AS IDENTITY
Include NOT NULL constraints where appropriate
Default values for optional columns
One concern per migration when possible
Timestamp precision must always be of TIMESTAMP(9)

Rolling Back

Add downward migrations with V<version>__<name>.sql (no timestamp):

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

Testing Migrations

Flyway runs automatically on application startup with H2 database.

flyway-migrations

Flyway Migration Patterns for Xeres

Migration Location

Naming Convention

Table Creation Pattern

Enum Types

Foreign Keys

Best Practices

Rolling Back

Testing Migrations

More from this repository

More from this repository

Flyway Migration Patterns for Xeres

Migration Location

Naming Convention

Table Creation Pattern

Enum Types

Foreign Keys

Best Practices

Rolling Back

Testing Migrations