spring-boot-starter-mybatis/src/test/resources/schema.sql

-- H2 数据库表结构初始化脚本

CREATE TABLE IF NOT EXISTS test_user (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    user_name VARCHAR(100),
    email VARCHAR(100),
    age INT,
    status VARCHAR(50),
    create_time TIMESTAMP,
    update_time TIMESTAMP,
    creator VARCHAR(100),
    updater VARCHAR(100),
    deleted BOOLEAN DEFAULT FALSE
);

CREATE TABLE IF NOT EXISTS test_order (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    user_id BIGINT,
    order_no VARCHAR(100),
    amount DECIMAL(10, 2),
    status VARCHAR(50),
    create_time TIMESTAMP,
    update_time TIMESTAMP,
    creator VARCHAR(100),
    updater VARCHAR(100),
    deleted BOOLEAN DEFAULT FALSE
);