Migrations

# Create new migration
cargo sqlx migrate add <name>

# Example
cargo sqlx migrate add create_users_table

migrations/
└── 20240115120000_create_users_table.sql

-- Up migration (apply)
CREATE TABLE users (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    email VARCHAR(255) NOT NULL UNIQUE,
    name VARCHAR(100) NOT NULL,
    created_at TIMESTAMPTZ DEFAULT NOW()
);

-- Down migration (revert)
-- (in separate file: 20240115120000_create_users_table.down.sql)
DROP TABLE users;

cargo sqlx migrate run

cargo sqlx migrate info

20240115120000_create_users_table  Applied
20240115130000_create_wallets_table  Applied
20240115140000_create_transactions_table  Pending

cargo sqlx migrate revert

-- migrations/20240115150000_add_wallet_icon.sql
BEGIN;

ALTER TABLE wallets
ADD COLUMN icon VARCHAR(50);

COMMIT;

-- migrations/20240115150000_add_wallet_icon.down.sql
BEGIN;

ALTER TABLE wallets
DROP COLUMN icon;

COMMIT;