Embed Notice

@dev@post.naskya.net それで、"Note: Ignore errors of column "xxx" of relation "xxx" already exists." とのことでしたが、Docker だと無視するとエラーが出て止まるので、それに該当するものも含めて、エラーメッセージやローカルホストのテスト環境に新しく建てた Firefish サーバーから出力した SQL ファイルと見比べながら、私は次のような変更も追加しました
ALTER TABLE "meta" ADD COLUMN "useStarForReactionFallback" boolean DEFAULT false NOT NULL; ALTER TABLE "user" DROP COLUMN "movedToUri"; ALTER TABLE "user" DROP COLUMN "alsoKnownAs"; ALTER TABLE "user_profile" DROP COLUMN "preventAiLearning"; CREATE TABLE "antenna_note" (id character varying(32) NOT NULL, "noteId" character varying(32) NOT NULL, "antennaId" character varying(32) NOT NULL, read boolean DEFAULT false NOT NULL); ALTER TABLE "meta" ADD COLUMN "pinnedPages" character varying(512)[] DEFAULT '{/featured,/channels,/explore,/pages,/about-misskey}'::character varying[] NOT NULL; ALTER TABLE "meta" ALTER COLUMN "logoImageUrl" TYPE character varying(512); ALTER TABLE "meta" ADD COLUMN "pinnedClipId" character varying(32); ALTER TABLE "meta" ADD COLUMN "errorImageUrl" character varying(512) DEFAULT '/static-assets/badges/error.png'::character varying; ALTER TABLE "meta" ADD COLUMN "enableTwitterIntegration" boolean DEFAULT false NOT NULL; ALTER TABLE "meta" ADD COLUMN "twitterConsumerKey" character varying(128); ALTER TABLE "meta" ADD COLUMN "twitterConsumerSecret" character varying(128); ALTER TABLE "meta" ADD COLUMN "enableGithubIntegration" boolean DEFAULT false NOT NULL; ALTER TABLE "meta" ADD COLUMN "githubClientId" character varying(128); ALTER TABLE "meta" ADD COLUMN "githubClientSecret" character varying(128); ALTER TABLE "meta" ADD COLUMN "enableDiscordIntegration" boolean DEFAULT false NOT NULL; ALTER TABLE "meta" ADD COLUMN "discordClientId" character varying(128); ALTER TABLE "meta" ADD COLUMN "discordClientSecret" character varying(128); ALTER TABLE "meta" ADD COLUMN "ToSUrl" character varying(512); ALTER TABLE "user_profile" ADD COLUMN integrations jsonb DEFAULT '{}'::jsonb NOT NULL; CREATE TABLE "notification" ( id character varying(32) NOT NULL, "createdAt" timestamp with time zone NOT NULL, "notifieeId" character varying(32) NOT NULL, "notifierId" character varying(32), "isRead" boolean DEFAULT false NOT NULL, "noteId" character varying(32), reaction character varying(128), choice integer, "followRequestId" character varying(32), type public.notification_type_enum NOT NULL, "userGroupInvitationId" character varying(32), "customBody" character varying(2048), "customHeader" character varying(256), "customIcon" character varying(1024), "appAccessTokenId" character varying(32)); ALTER TABLE "antenna" ADD COLUMN "userGroupJoiningId" character varying(32); ALTER TABLE "user_profile" DROP COLUMN achievements; ALTER TABLE "user_profile" DROP COLUMN "loggedInDates";
さらに、今回の連合サーバーの情報が見られない情報に直面して、次の変更も加えて、「その変更は」成功しました
ALTER TABLE "migrations" DROP COLUMN "achievement1674118260469"; ALTER TABLE "migrations" DROP COLUMN "loggedInDates1674255666603";