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

6 lines450 bytesCodeBlame
1-- 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;