♻️ refactor: update to add user_id for db schema

[arvinxx]

💻 变更类型 | Change Type

• ✨ feat
• 🐛 fix
• ♻️ refactor
• 💄 style
• 👷 build
• ⚡️ perf
• 📝 docs
• 🔨 chore

🔀 变更说明 | Description of Change

针对所有关联表均添加 userId 字段

📝 补充信息 | Additional Information

• [RFC] 077 - 兼容 Postgres/Pglite 的数据导入导出 #5147

[vercel]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
lobe-chat-database	✅ Ready (Inspect)	Visit Preview		Mar 18, 2025 9:07am
lobe-chat-desktop	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Mar 18, 2025 9:07am
lobe-chat-preview	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Mar 18, 2025 9:07am

[lobehubbot]

👍 @arvinxx

Thank you for raising your pull request and contributing to our Community
Please make sure you have followed our contributing guidelines. We will review it as soon as possible.
If you encounter any problems, please feel free to connect with us.
非常感谢您提出拉取请求并为我们的社区做出贡献，请确保您已经遵循了我们的贡献指南，我们会尽快审查它。
如果您遇到任何问题，请随时与我们联系。

[gru-agent]

TestGru Assignment

Summary

Link	CommitId	Status	Reason
Detail	8f4872e	🚫 Skipped	No files need to be tested {"docs/developer/database-schema.dbml":"target file(docs/developer/database-schema.dbml) not in work scope \n include: src/utils,src/server,src/database,src/services,src/store,packages//src/ \n exclude: node_modules,/*.test.ts,/.test.tsx,**/.spec.ts,/*.spec.tsx,/.d.ts,**/.test.js,/*.spec.js,src/database/server","src/database/client/migrations.json":"target file(src/database/client/migrations.json) not in work scope \n include: src/utils,src/server,src/database,src/services,src/store,packages//src/** \n exclude: node_modules,/*.test.ts,/.test.tsx,**/.spec.ts,/*.spec.tsx,/.d.ts,**/.test.js,/*.spec.js,src/database/server","src/database/migrations/0017_add_user_id_to_tables.sql":"target file(src/database/migrations/0017_add_user_id_to_tables.sql) not in work scope \n include: src/utils,src/server,src/database,src/services,src/store,packages//src/** \n exclude: node_modules,/*.test.ts,/.test.tsx,**/.spec.ts,**/.spec.tsx,…

Tip

You can @gru-agent and leave your feedback. TestGru will make adjustments based on your input

[codecov]

Codecov Report

Attention: Patch coverage is 97.94521% with 3 lines in your changes missing coverage. Please review.

Project coverage is 91.38%. Comparing base (de8df94) to head (1e1921f).

Files with missing lines	Patch %	Lines
src/database/repositories/dataImporter/index.ts	33.33%	2 Missing ⚠️
src/database/server/models/message.ts	96.55%	1 Missing ⚠️

Additional details and impacted files

@@            Coverage Diff             @@
##             main    #7022      +/-   ##
==========================================
+ Coverage   91.34%   91.38%   +0.03%     
==========================================
  Files         733      736       +3     
  Lines       69493    69676     +183     
  Branches     3410     3233     -177     
==========================================
+ Hits        63478    63671     +193     
+ Misses       6015     6005      -10     

Flag	Coverage Δ
app	91.38% <97.94%> (+0.03%)	⬆️
server	97.54% <97.56%> (+0.04%)	⬆️

Flags with carried forward coverage won't be shown. Click here to find out more.

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:

• ❄ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
• 📦 JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.