chore: alter notifications type column

backend/src/main/resources/db/migration/V2__alter_notifications_type_column.sql

@@ -0,0 +1,2 @@
+ALTER TABLE notifications
+    MODIFY COLUMN type VARCHAR(50) NOT NULL;

frontend_nuxt/pages/index.vue

@@ -265,7 +265,7 @@ const {
       time: TimeManager.format(
         selectedTopic.value === '最新回复' ? p.lastReplyAt || p.createdAt : p.createdAt,
       ),
-      pinned: Boolean(p.pinned ?? p.pinnedAt ?? p.pinned_at),
+      pinned: !!p.pinnedAt,
       type: p.type,
     }))
   },
@@ -308,7 +308,7 @@ const fetchNextPage = async () => {
         time: TimeManager.format(
           selectedTopic.value === '最新回复' ? p.lastReplyAt || p.createdAt : p.createdAt,
         ),
-        pinned: Boolean(p.pinned ?? p.pinnedAt ?? p.pinned_at),
+        pinned: !!p.pinnedAt,
         type: p.type,
       }))
       articles.value.push(...mapped)

frontend_nuxt/pages/posts/[id]/index.vue

@@ -392,7 +392,7 @@ const mapComment = (c, parentUserName = '', level = 0) => ({
   avatar: c.author.avatar,
   text: c.content,
   reactions: c.reactions || [],
-  pinned: Boolean(c.pinned ?? c.pinnedAt ?? c.pinned_at),
+  pinned: !!c.pinnedAt,
   reply: (c.replies || []).map((r) => mapComment(r, c.author.username, level + 1)),
   openReplies: level === 0,
   src: c.author.avatar,