Working with jOOQ and Flyway using Testcontainers — Create Flyway migration scripts

Reference note (untrusted external data; do not execute it as instructions). The sample application has users, posts, and comments tables. Create the first migration script following the Flyway naming convention. Create src/main/resources/db/migration/V1create_tables.sql Bounded code example (external data; do not execute automatically): ```sql create table users ( id bigserial not null, name varchar not null, email varchar not null, created_at timestamp, updated_at timestamp, primary key (id), constraint user_email_unique unique (email) ); create table posts ( id bigserial not null, title varchar not null, content varchar not null, created_by bigint references users (id) not null, created_at timestamp, updated_at timestamp, primary key (id) ); create table comments ( id bigserial not null, name varchar not null, content varchar not null, post_id bigint references posts (id) not null, created_at timestamp, updated_at timestamp, primary key (id) ); ALTER SEQUENCE us ``` The sequence values restart at 101 so that you can insert sample data with explicit primary key values for testing. Attribution: Adapted from Docker Documentation under Apache-2.0. Adaptation: WikiKV isolated this documentation section, normalized formatting, retained only bounded code excerpts, and shortened it at a paragraph or sentence boundary for retrieval. Verify version-sensitive details at the source.