budgit/internal/db/migrations/00004_add_balance_to_accounts.sql
2026-04-11 17:57:41 +00:00

9 lines
237 B
SQL

-- +goose Up
-- +goose StatementBegin
ALTER TABLE accounts ADD COLUMN balance TEXT NOT NULL DEFAULT '0.00';
-- +goose StatementEnd
-- +goose Down
-- +goose StatementBegin
ALTER TABLE accounts DROP COLUMN balance;
-- +goose StatementEnd