A community based topic aggregation platform built on atproto
1-- +goose Up
2ALTER TABLE users ADD COLUMN display_name TEXT CHECK (display_name IS NULL OR length(display_name) <= 64);
3ALTER TABLE users ADD COLUMN bio TEXT CHECK (bio IS NULL OR length(bio) <= 256);
4ALTER TABLE users ADD COLUMN avatar_cid TEXT;
5ALTER TABLE users ADD COLUMN banner_cid TEXT;
6
7-- +goose Down
8ALTER TABLE users DROP COLUMN IF EXISTS banner_cid;
9ALTER TABLE users DROP COLUMN IF EXISTS avatar_cid;
10ALTER TABLE users DROP COLUMN IF EXISTS bio;
11ALTER TABLE users DROP COLUMN IF EXISTS display_name;