ALTER TABLE "users"
  ADD COLUMN "city" text,
  ADD COLUMN "city_code" text,
  ADD COLUMN "birth_month" integer,
  ADD COLUMN "birth_day" integer,
  ADD COLUMN "onboarding_completed_at" timestamp with time zone;

ALTER TABLE "users"
  ADD CONSTRAINT "users_birth_month_range_check"
    CHECK (birth_month IS NULL OR (birth_month BETWEEN 1 AND 12));

ALTER TABLE "users"
  ADD CONSTRAINT "users_birth_day_range_check"
    CHECK (birth_day IS NULL OR (birth_day BETWEEN 1 AND 31));

UPDATE "users"
  SET "onboarding_completed_at" = NOW()
  WHERE "onboarding_completed_at" IS NULL;
