deploy/migrations/0024_user_birthday_personal_channel.up.sql

Rama main · réplica de lectura del repositorio original.

-- account.updateBirthday / account.updatePersonalChannel: the "birthday" and
-- "personal channel" in a profile. The birthday is stored as month/day/year (all
-- zero = unset; year=0 = only month/day, no year); the personal channel stores the
-- target channel id (0 = unset/cleared), and the profile projection resolves the
-- channel object and its latest post id by that id.
ALTER TABLE public.users
  ADD COLUMN birthday_day integer DEFAULT 0 NOT NULL,
  ADD COLUMN birthday_month integer DEFAULT 0 NOT NULL,
  ADD COLUMN birthday_year integer DEFAULT 0 NOT NULL,
  ADD COLUMN personal_channel_id bigint DEFAULT 0 NOT NULL;