g1t/services/billing/migrations/0034_given_by_why.sql

7 lines516 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: a statement that keeps usage sold, running g1t, subscriptions and what was given away (comped, free use, trial, pool) apart, and says who was paid; free use carries its own cost; the run button says it is running1-- What was given away, by why: comped workspaces, free use (free periods,
2-- free allowances, overruns g1t covered), the trial and the open-source
3-- pool. given_micros stays their total.
4ALTER TABLE margin_days ADD COLUMN given_comped_micros INTEGER NOT NULL DEFAULT 0;
5ALTER TABLE margin_days ADD COLUMN given_free_micros INTEGER NOT NULL DEFAULT 0;
6ALTER TABLE margin_days ADD COLUMN given_trial_micros INTEGER NOT NULL DEFAULT 0;
7ALTER TABLE margin_days ADD COLUMN given_pool_micros INTEGER NOT NULL DEFAULT 0;