flagon-io/g1t

public

22 lines1,004 bytesCode Blame

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.

Billing keeps Stripe's view itself: the saved card on the account, missed events replayed every 15 minutes, and the endpoint kept23h ago	1	-- What billing keeps of Stripe so reads never wait on it (stripe_sync.rs).
	2
	3	-- The workspace's saved card as Stripe last said, refreshed by card and
	4	-- customer events and a weekly pass. card_synced_at NULL: never read, or
	5	-- forgotten after g1t itself changed the card; the next read asks Stripe.
	6	ALTER TABLE accounts ADD COLUMN card_brand TEXT;
	7	ALTER TABLE accounts ADD COLUMN card_last4 TEXT;
	8	ALTER TABLE accounts ADD COLUMN card_exp_month INTEGER;
	9	ALTER TABLE accounts ADD COLUMN card_exp_year INTEGER;
	10	ALTER TABLE accounts ADD COLUMN card_synced_at TEXT;
	11
	12	-- Card and customer events name the customer, not the workspace.
	13	CREATE INDEX IF NOT EXISTS accounts_by_customer ON accounts (customer_id);
	14
	15	-- How far missed events have been replayed from Stripe's event list, per
	16	-- key mode: every event created before `through` (Unix seconds) has been
	17	-- seen, by its webhook or by the replay.
	18	CREATE TABLE stripe_sync (
	19	mode TEXT PRIMARY KEY,
	20	through INTEGER NOT NULL,
	21	checked_at TEXT NOT NULL
	22	);