AI: address issue #283

backend/db/migrate/20261112000000_add_foreign_key_on_deerjikists_tag_id.rb

@@ -0,0 +1,5 @@
+class AddForeignKeyOnDeerjikistsTagId < ActiveRecord::Migration[8.0]
+  def change
+    add_foreign_key :deerjikists, :tags, column: :tag_id
+  end
+end

frontend/src/components/PostEmbed.tsx

@@ -196,39 +196,6 @@ const PostEmbed: FC<Props> = (
       return <TwitterEmbed userId={userId} statusId={statusId}/>
     }
 
-  case 'bilibili.com':
-    {
-      const videoId = url.pathname.match (
-	  /^\/video\/(BV[a-zA-Z0-9]{10}|av[1-9]\d*)\/?$/)?.[1]
-      if (!(videoId))
-	break
-
-      if (embedAutoLoadMode === 'off')
-	return externalLink
-      if (shouldLoadEmbed === false)
-	return manualLoadControl
-
-      const playerUrl = new URL ('https://player.bilibili.com/player.html')
-      const parameter = videoId.startsWith ('BV') ? 'bvid' : 'aid'
-      const identifier = parameter === 'bvid' ? videoId : videoId.slice (2)
-      playerUrl.searchParams.set (parameter, identifier)
-      playerUrl.searchParams.set ('autoplay', '1')
-
-      const page = url.searchParams.get ('p')
-      if (page != null && /^[1-9]\d*$/.test (page))
-	playerUrl.searchParams.set ('p', page)
-
-      return (
-	  <iframe
-	      src={playerUrl.toString ()}
-	      title={post.title || post.url}
-	      width={640}
-	      height={360}
-	      className="aspect-video h-auto max-w-full"
-	      allow="autoplay; fullscreen"
-	      allowFullScreen/>)
-    }
-
   case 'youtube.com':
     {
       const videoId = url.searchParams.get ('v')