lemmy/server/migrations/2020-09-14-135047_activity_id_column/up.sql

-- For activity table, remove the user_id column and add activity_id

ALTER TABLE activity ADD COLUMN activity_id Text;
ALTER TABLE activity DROP COLUMN user_id;