internal/db/migrations/027_add_user_profile_fields.sql at main

A community based topic aggregation platform built on atproto

coves / internal / db / migrations / 027_add_user_profile_fields.sql

at main 11 lines 512 B view raw

wrap content

 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;