16 lines
397 B
SQL
16 lines
397 B
SQL
|
-- +goose Up
|
||
|
|
-- +goose StatementBegin
|
||
|
|
CREATE TABLE public.ssh_keys (
|
||
|
|
key_id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
||
|
|
angler_id UUID NOT NULL REFERENCES public.anglers(angler_id),
|
||
|
|
key_type TEXT NOT NULL,
|
||
|
|
key_data BYTEA NOT NULL UNIQUE,
|
||
|
|
key_fingerprint TEXT
|
||
|
|
);
|
||
|
|
-- +goose StatementEnd
|
||
|
|
|
||
|
|
-- +goose Down
|
||
|
|
-- +goose StatementBegin
|
||
|
|
DROP TABLE public.ssh_keys;
|
||
|
|
-- +goose StatementEnd
|