crates/hub/migrations/0002_push_details.sql at 076c7a7c86b1 · andymccall/oxygenhub

# 076c7a7c86b1 oxygenhub / crates / hub / migrations / 0002_push_details.sql

324 B · SQL · last changed Push log records states, heads and change counts from the push report 1 month ago source blame history raw

-- What a push moved: the states and heads (hub spec §6.12).
ALTER TABLE pushes ADD COLUMN old_state TEXT NOT NULL DEFAULT '';
ALTER TABLE pushes ADD COLUMN new_state TEXT NOT NULL DEFAULT '';
ALTER TABLE pushes ADD COLUMN heads INTEGER NOT NULL DEFAULT 0;
ALTER TABLE pushes ADD COLUMN changes INTEGER NOT NULL DEFAULT 0;

`/`	Search
`g` `c`	Code
`g` `h`	History
`g` `b`	Bookmarks
`g` `t`	Trust
`y`	Permalink to this state (files and trees)
`?`	This sheet

1	-- What a push moved: the states and heads (hub spec §6.12).
2	ALTER TABLE pushes ADD COLUMN old_state TEXT NOT NULL DEFAULT '';
3	ALTER TABLE pushes ADD COLUMN new_state TEXT NOT NULL DEFAULT '';
4	ALTER TABLE pushes ADD COLUMN heads INTEGER NOT NULL DEFAULT 0;
5	ALTER TABLE pushes ADD COLUMN changes INTEGER NOT NULL DEFAULT 0;

Keyboard