mirror of
https://github.com/Tencent/WeKnora.git
synced 2026-06-04 13:30:32 +08:00
7528175a74
Refactored the pinning mechanism for knowledge bases to be user-specific, allowing any user with read access to pin knowledge bases independently. This change includes the introduction of a new `user_kb_pins` table to manage pin states, replacing the previous tenant-wide pinning system. Updated relevant API endpoints and service logic to support this new functionality, ensuring that the UI reflects the user's personal pin status. Additionally, adjusted the knowledge base listing to sort by user-specific pin status, enhancing the user experience by prioritizing pinned items. Refs: #1303
25 lines
878 B
SQL
25 lines
878 B
SQL
DROP TABLE IF EXISTS tenant_invitations;
|
|
DROP TABLE IF EXISTS user_kb_pins;
|
|
DROP TABLE IF EXISTS user_resource_favorites;
|
|
DROP TABLE IF EXISTS tenant_disabled_shared_agents;
|
|
DROP TABLE IF EXISTS agent_shares;
|
|
DROP TABLE IF EXISTS organization_join_requests;
|
|
DROP TABLE IF EXISTS kb_shares;
|
|
DROP TABLE IF EXISTS organization_tenant_members;
|
|
DROP TABLE IF EXISTS organizations;
|
|
DROP TABLE IF EXISTS custom_agents;
|
|
DROP TABLE IF EXISTS mcp_tool_approvals;
|
|
DROP TABLE IF EXISTS mcp_services;
|
|
DROP TABLE IF EXISTS knowledge_tags;
|
|
DROP TABLE IF EXISTS auth_tokens;
|
|
DROP TABLE IF EXISTS audit_logs;
|
|
DROP TABLE IF EXISTS tenant_members;
|
|
DROP TABLE IF EXISTS users;
|
|
DROP TABLE IF EXISTS chunks;
|
|
DROP TABLE IF EXISTS messages;
|
|
DROP TABLE IF EXISTS sessions;
|
|
DROP TABLE IF EXISTS knowledges;
|
|
DROP TABLE IF EXISTS knowledge_bases;
|
|
DROP TABLE IF EXISTS models;
|
|
DROP TABLE IF EXISTS tenants;
|