repos / pico

pico services - prose.sh, pastes.sh, imgs.sh, feeds.sh, pgs.sh
git clone https://github.com/picosh/pico.git

pico / sql / migrations
Eric Bower · 11 Mar 24

20240311_add_public_key_name.sql

1ALTER TABLE public_keys ADD COLUMN name varchar(256) NOT NULL DEFAULT '';
2-- cannot add this because all names are empty
3-- ALTER TABLE public_keys ADD CONSTRAINT unique_public_keys_user_name UNIQUE (user_id, name);