max / makenotwork

399 B · 12 lines History Blame Raw

1	CREATE TABLE ssh_keys (
2	id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
3	user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
4	public_key TEXT NOT NULL,
5	fingerprint VARCHAR(128) NOT NULL,
6	label VARCHAR(128) NOT NULL DEFAULT '',
7	created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
8	UNIQUE (user_id, fingerprint)
9	);
10
11	CREATE INDEX idx_ssh_keys_user_id ON ssh_keys(user_id);
12