g1t/services/billing/migrations/0033_given_away.sql

6 lines450 bytesCodeBlame

Pick any line to see why it is the way it is: the commit, the pull request and issue it came from, and what the agent was thinking.

Costs: margin is measured on what was sold; comped workspaces, free periods, the trial and the pools are given away, a budget shown beside it1-- What g1t gave away on purpose: the part of each day's cost that went on
2-- usage nobody paid for (g1t's own comped workspaces, a free period, the
3-- trial and the open-source pool). Sudo measures margin on what was sold,
4-- with this shown beside it, so comping does not read as lost money.
5ALTER TABLE margin_days ADD COLUMN given_micros INTEGER NOT NULL DEFAULT 0;
6ALTER TABLE workspace_costs ADD COLUMN given_micros INTEGER NOT NULL DEFAULT 0;