budgit/internal/db/migrations/00014_add_currency_to_accounts.sql
2026-05-04 04:24:08 +00:00

9 lines
238 B
SQL

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