pr_01m47d15m3e54sn21z27rpy5n9/services/billing/migrations/0019_closed_workspaces.sql

9 lines397 bytesCodeBlame
1-- Workspaces whose billing was closed because the workspace was deleted
2-- (src/closing.rs): who closed it, when, and the balance it had then. The
3-- ledger, invoices and statements stay under the slug for accounting.
4CREATE TABLE IF NOT EXISTS closed_workspaces (
5 workspace TEXT PRIMARY KEY,
6 closed_by TEXT NOT NULL,
7 closed_at TEXT NOT NULL,
8 balance_micros INTEGER NOT NULL DEFAULT 0
9);