skills/lobehub__lobehub
1
0
Fork 0
mirror of https://github.com/lobehub/lobehub.git synced 2026-09-20 04:56:13 +08:00
Code Issues Packages Projects Releases Wiki Activity
Files
feat/quick-note
lobehub__lobehub/packages/database/migrations
T
History
Neko Ayaka 13ac4b04b2 🐛 fix: allow deletion of pinned Quick Note context documents
2026-09-20 00:24:48 +09:00
..
meta
🐛 fix: allow deletion of pinned Quick Note context documents
2026-09-20 00:24:48 +09:00
0000_init.sql
…
0001_add_client_id.sql
…
0002_amusing_puma.sql
…
0003_naive_echo.sql
…
0004_add_next_auth.sql
…
0005_pgvector.sql
…
0006_add_knowledge_base.sql
…
0007_fix_embedding_table.sql
…
0008_add_rag_evals.sql
…
0009_remove_unused_user_tables.sql
…
0010_add_accessed_at_and_clean_tables.sql
…
0011_add_topic_history_summary.sql
…
0012_add_thread.sql
…
0013_add_ai_infra.sql
…
0014_add_message_reasoning.sql
…
0015_add_message_search_metadata.sql
…
0016_add_message_index.sql
…
0017_add_user_id_to_tables.sql
…
0018_add_client_id_for_entities.sql
…
0019_add_hotkey_user_settings.sql
…
0020_add_oidc.sql
…
0021_add_agent_opening_settings.sql
…
0022_add_documents.sql
…
0023_remove_param_and_doubao.sql
…
0024_add_rbac_tables.sql
…
0025_add_provider_config.sql
…
0026_add_autovacuum_tuning.sql
…
0027_ai_image.sql
…
0028_oauth_handoffs.sql
…
0029_add_apikey_manage.sql
…
0030_add_group_chat.sql
…
0031_add_agent_index.sql
…
0032_improve_agents_field.sql
…
0033_add_table_index.sql
…
0034_fix_chat_group.sql
…
0035_add_virtual.sql
…
0036_add_group_messages.sql
…
0037_add_user_memory.sql
…
0038_add_image_user_settings.sql
…
0039_add_editor_data.sql
👷 build: Add editorData column on document table (#9899)
2025-10-27 17:12:55 +08:00
0040_improve_user_memory_field.sql
👷 build(database): improve user memory schema (#9822)
2025-10-28 15:50:15 +08:00
0041_improve_index.sql
⚡️ perf: improve db query performance (#9946)
2025-10-31 12:39:59 +08:00
0042_improve_agent_index.sql
⚡️ perf: improve db query performance (#10036)
2025-11-04 14:29:11 +08:00
0043_add_ai_model_settings.sql
♻️ refactor: add settings (jsonb) column to ai_models table (#10042)
2025-11-04 21:02:40 +08:00
0044_high_toxin.sql
🔨 chore: add market_identifier into agents table schema (#10164)
2025-11-11 22:37:47 +08:00
0045_add_tool_intervention.sql
👷 build: add intervention tool column (#10163)
2025-11-12 10:25:03 +08:00
0046_add_parent_id.sql
👷 build: Update schema for incoming folder (#10217)
2025-11-18 16:42:13 +08:00
0047_add_slug_document.sql
🐛 fix: fix db migration snapshot not align with db schema (#10399)
2025-11-24 21:15:25 +08:00
0048_add_editor_data.sql
🔨 chore: add editor_data in agents db (#10448)
2025-11-27 13:09:05 +08:00
0049_better_auth.sql
✨ feat: support better-auth (#10215)
2025-11-27 20:10:40 +08:00
0050_thread_and_user_id.sql
♻️ refactor: refactor thread table and nextauth userId (#10475)
2025-11-28 13:50:43 +08:00
0051_add_market_into_user_settings.sql
🔨 chore: add market into userSettings & save the oidc token into db (#10481)
2025-11-28 23:19:42 +08:00
0052_topic_and_messages.sql
🔨 chore: update topic and message db (#10511)
2025-11-30 19:37:57 +08:00
0053_better_auth_admin.sql
✨ feat: integrate better-auth admin plugin (#10512)
2025-12-01 17:16:06 +08:00
0054_better_auth_two_factor.sql
🐛 fix: user email unique migration error (#10548)
2025-12-02 12:37:42 +08:00
0055_rename_phone_number_to_phone.sql
🐛 fix: drop user.phoneNumber and reuse user.phone (#10531)
2025-12-01 19:00:29 +08:00
0056_update_agent_slug_index.sql
♻️ refactor: refactor agent slug schema (#10561)
2025-12-02 23:23:42 +08:00
0057_add_topic_user_memory_extract_status.sql
feat(database): topic metadata for user memory extractor (#10569)
2025-12-03 19:14:29 +08:00
0058_add_source_into_user_plugins.sql
🔨 chore: add source type into user_install_plugins (#10603)
2025-12-04 18:14:21 +08:00
0059_add_normalized_email_indexes.sql
✨ feat: betterauth username signin (#10607)
2025-12-05 01:35:20 +08:00
0060_add_user_last_active_at.sql
🔨 chore: track user last active time (#10733)
2025-12-11 17:14:25 +08:00
0061_add_document_and_memory_index.sql
⚡️ perf(database): optimize document queries with indexes and field exclusion (#10740)
2025-12-12 20:09:08 +08:00
0062_add_more_index.sql
⚡️ perf: add more sql to improve performance (#10777)
2025-12-15 01:06:34 +08:00
0063_add_columns_for_several_tables.sql
♻️ refactor: refactor database schema (#10860)
2025-12-20 20:20:07 +08:00
0064_add_agents_session_group_id.sql
👷 build: add session group in agents table (#10868)
2025-12-21 21:38:20 +08:00
0065_add_document_fields.sql
✨ feat: support notebook tool (#10902)
2025-12-24 12:55:09 +08:00
0065_add_passkey.sql
✨ feat: mobile native better auth support (#10871)
2025-12-23 15:19:42 +08:00
0066_add_document_fields.sql
👷 build: improve document db schema (#10892)
2025-12-23 18:54:48 +08:00
0067_add_agent_cron_tables.sql
✨ feat: generate agent_cron_jobs in agents (#11349)
2026-01-09 14:22:35 +08:00
0068_update_group_data.sql
♻️ refactor(agentGroup): simplify LobeChatGroupChatConfig schema (#11431)
2026-01-12 15:46:11 +08:00
0069_add_topic_shares_table.sql
✨ feat(share): add topic sharing functionality (#11448)
2026-01-13 22:10:48 +08:00
0070_add_user_memory_activities.sql
✨ feat(database): added user memory activity (#11680)
2026-01-22 10:24:50 +08:00
0071_add_async_task_extend.sql
✨ feat(database): extended async task with metadata and parent id, added index (#11712)
2026-01-23 21:49:56 +08:00
0072_add_market_identifier_chat_group.sql
🔨 chore: add the market identifier in chat group (#11779)
2026-01-24 21:07:56 +08:00
0073_add_message_group_metadata.sql
✨ feat: support history context auto compress (#11790)
2026-01-25 13:59:44 +08:00
0074_add_fk_indexes_for_cascade_delete.sql
🔨 chore: add account deletion feature with 72h cooling-off period (#11818)
2026-01-25 20:21:52 +08:00
0075_add_user_memory_persona.sql
✨ feat(database): added user memory persona schema (#11833)
2026-01-26 01:50:56 +08:00
0076_add_message_group_index.sql
👷 build: fix db index (#12090)
2026-02-04 13:16:56 +08:00
0077_add_agent_skills.sql
👷 build: add agent skills database schema (#12197)
2026-02-08 19:53:27 +08:00
0078_added_id_nanoid_for_replacing_id.sql
👷 build(database): migrate id using seq and identity to text with nanoid (#12223)
2026-02-09 22:27:46 +08:00
0079_update_id_nanoid_from_casted_id.sql
👷 build(database): migrate id using seq and identity to text with nanoid (#12223)
2026-02-09 22:27:46 +08:00
0080_add_constraint_unique_not_null_to_id_nanoid.sql
👷 build(database): migrate id using seq and identity to text with nanoid (#12223)
2026-02-09 22:27:46 +08:00
0081_switch_forgien_key_to_id_nanoid.sql
👷 build(database): migrate id using seq and identity to text with nanoid (#12223)
2026-02-09 22:27:46 +08:00
0082_set_id_nanoid_as_primary.sql
👷 build(database): migrate id using seq and identity to text with nanoid (#12223)
2026-02-09 22:27:46 +08:00
0083_remove_id_seq_identity_column.sql
👷 build(database): migrate id using seq and identity to text with nanoid (#12223)
2026-02-09 22:27:46 +08:00
0084_rename_id_nanoid_to_id.sql
👷 build(database): migrate id using seq and identity to text with nanoid (#12223)
2026-02-09 22:27:46 +08:00
0085_remove_id_unique_constraint.sql
👷 build(database): migrate id using seq and identity to text with nanoid (#12223)
2026-02-09 22:27:46 +08:00
0086_video_generation_schema.sql
🗃️ db: add video generation schema changes
2026-02-13 12:09:18 +08:00
0087_add_eval_benchmark.sql
👷 build: add benchmark db schema (#12402)
2026-02-21 00:44:06 +08:00
0088_fix_benchmark_add_bot_provider.sql
🐛 fix: fix benchmarks table schema not correctly (#12532)
2026-02-28 21:05:32 +08:00
0089_add_api_key_hash.sql
👷 build: add api key hash column migration (#12862)
2026-03-09 23:04:45 +08:00
0090_enable_pg_search.sql
👷 build: add migration to enable pg_search extension (#12874)
2026-03-10 14:34:42 +08:00
0091_topics_add_description.sql
👷 build: add description column to topics table (#12939)
2026-03-12 19:39:47 +08:00
0092_add_agent_documents.sql
👷 build: add agent_documents table (#12944)
2026-03-16 11:48:30 +08:00
0093_add_bm25_indexes_with_icu.sql
🗃️ db: add BM25 indexes with ICU tokenizer for 14 tables
2026-03-16 19:41:19 +08:00
0094_agent_bot_providers_add_settings.sql
👷 build: add settings column to agent_bot_providers (#13081)
2026-03-18 12:28:58 +08:00
0095_add_agent_task_system.sql
👷 build: add agent task system database schema (#13280)
2026-03-26 13:56:01 +08:00
0096_add_notification_tables.sql
🗃️ db: add notification tables (#13295)
2026-03-26 17:04:47 +08:00
0097_add_agent_onboarding.sql
✨ feat(onboarding): agent web onboarding, feature toggle, and lifecycle sync (#13139)
2026-03-30 20:28:54 +08:00
0098_add_document_history.sql
💾 chore(database): sync document history schema indexes
2026-04-16 16:48:15 +08:00
0099_topic_status_tasks_automation_mode.sql
👷 build(database): add topic status and tasks automation mode (#13994)
2026-04-20 17:34:13 +08:00
0100_add_metadata_and_trigger_to_briefs.sql
👷 build(database): add metadata and trigger to briefs table (#14354)
2026-05-01 15:47:02 +08:00
0101_add_messenger_tables.sql
👷 build(database): add messenger tables for IM bot integration (#14496)
2026-05-08 01:10:34 +07:00
0102_add_agent_operations_table.sql
✨ feat(database): add agent_operations table (#14416)
2026-05-13 00:51:03 +08:00
0103_add_llm_tracing_and_eval_experiments.sql
🔨 feat(db): add llm_generation_tracing and agent eval experiment tables (#15126)
2026-05-23 00:05:15 +08:00
0104_add_devices_connectors_push_tokens.sql
🔨 feat(db): batch topic usage stats, push tokens, tasks editor_data & document shares migrations (#15280)
2026-05-28 19:36:45 +08:00
0105_add_usage_agent_share_workspace.sql
✨ feat(db): add workspace and agent share table (#15439)
2026-06-04 00:24:09 +08:00
0106_add_workspace_id_columns.sql
🗃️ db(database): add workspace_id columns to existing tables (#15446)
2026-06-04 13:18:16 +08:00
0107_add_workspace_id_fk.sql
🗃️ build(database): add workspace_id FK constraints (#15465)
2026-06-04 16:23:14 +08:00
0108_add_workspace_id_indexes.sql
🗃️ build(database): add workspace_id indexes (#15468)
2026-06-04 19:03:00 +08:00
0109_migrate_unique_constraints.sql
🗃️ build(database): migrate unique constraints to workspace scope (#15472)
2026-06-04 21:08:36 +08:00
0110_add_verify_tables_and_ai_infra_id.sql
♻️ chore: replace LOBE-XXX markers with inline migration context (#15567)
2026-06-09 10:54:22 +08:00
0111_workspace_device_and_ai_infra_surrogate_pk.sql
chore: remove internal LOBE-XXX issue references from code comments (#18327)
2026-08-15 12:15:19 +08:00
0112_add_verify_evidence_and_reports.sql
🗃️ feat(verify): add verify_evidence + verify_reports tables, probe verifier type (#16114)
2026-06-20 19:49:24 +08:00
0113_add_verify_runs.sql
🗃️ refactor(verify): decouple verify chain from agent_operations via verify_runs (#16129)
2026-06-20 22:42:00 +08:00
0114_add_verify_run_scenario_context.sql
✨ feat(verify): make the verify page the final report (scenario scope + conclusion + score) (#16140)
2026-06-21 13:52:15 +08:00
0115_add_workspace_private_visibility.sql
✨ feat(database): add workspace visibility columns and indexes for pr… (#16598)
2026-07-02 11:29:04 +08:00
0116_add_task_connector_message_and_verify_updates.sql
🗃️ feat(db): add task_topics.trigger and user_connectors.agent_id (combined schema) (#16718)
2026-07-08 17:15:46 +08:00
0117_workspace_user_settings_and_device_share.sql
✨ feat(database): add workspace_user_settings table and device visibility/share columns (#17031)
2026-07-11 18:51:08 +08:00
0118_workspace_user_settings_surrogate_pk.sql
🗃️ refactor(db): replace workspace_user_settings composite PK with surrogate id (#17042)
2026-07-11 21:35:32 +08:00
0119_add_acceptances.sql
🗃️ feat(db): add acceptance aggregates (#16899)
2026-07-15 19:23:58 +08:00
0120_oidc_clients_governance.sql
👷 build(database): add OIDC client governance schema (#17228)
2026-07-16 00:06:08 +08:00
0121_add_work_registry_tables.sql
💚 build: make work registry migration idempotent (#17279)
2026-07-17 02:22:41 +08:00
0122_verify_visibility_and_check_user_decision.sql
✨ feat(acceptance): per-check user review with feedback loop (#17271)
2026-07-17 12:02:56 +08:00
0123_resource_permissions_and_messenger_credentials.sql
🗃️ feat(database): add resource_permissions table and messenger credential columns (#17300)
2026-07-17 23:17:34 +08:00
0124_agent_quota_accounts.sql
✨ feat(agent-quota): account + quota-window tables (schema + migration) (#17378)
2026-07-21 10:15:28 +08:00
0125_add_stats_activity_created_at_indexes.sql
⚡️ perf(db): index activity sources by creation time (#17414)
2026-07-21 23:25:19 +08:00
0126_agent_quota_workspace_identity.sql
✨ feat(agent-quota): account-scoped quota data layer + capacity calibration (#17314)
2026-07-22 10:00:49 +08:00
0127_add_topic_comments.sql
🗃️ feat(db): add workspace topic comment schema (#17526)
2026-07-24 14:18:41 +08:00
0128_notifications_add_workspace_id.sql
✨ feat(database): add workspace_id column to notifications (#17565)
2026-07-25 00:13:54 +08:00
0129_workspace_members_unique_active_owner.sql
🗃️ feat(db): unique active workspace owner partial index (#17590)
2026-07-26 09:39:58 +08:00
0130_notifications_add_context.sql
✨ feat: support notification context in inbox (#17624)
2026-07-27 00:20:19 +08:00
0131_agents_add_name_column.sql
✨ feat(database): add name column to agents table (#17821)
2026-08-02 14:56:05 +08:00
0132_add_agent_labels.sql
🗃️ feat(db): add agent labels schema and migration (uuid ids) (#17847)
2026-08-02 17:46:56 -07:00
0133_common_veda.sql
✨ feat(db): add agent history job tables for async transfer backfill (#17984)
2026-08-06 17:49:23 -07:00
0134_add_projects.sql
✨ feat(database): add project schema (#17996)
2026-08-07 11:46:01 +08:00
0135_api_keys_add_scopes.sql
✨ feat(db): add capability scopes column to api_keys (#18016)
2026-08-07 09:49:26 -07:00
0136_projects_add_identifier.sql
🗃️ db: add project identifier column (#18034)
2026-08-08 07:38:30 +08:00
0137_agent_history_jobs_payload.sql
🗃️ chore(db): add payload column to agent history job tables (#18043)
2026-08-07 19:08:47 -07:00
0138_agent_history_job_groups.sql
🗃️ chore(db): add agent history job groups junction table (#18081)
2026-08-08 21:20:51 -07:00
0139_projects_add_coordinator_agent.sql
✨ feat: add dedicated project coordinator agent (#18054)
2026-08-09 22:23:01 -07:00
0140_productive_madripoor.sql
✨ feat(acceptance): propose review verdicts and record the reviewer's answer (#18199)
2026-08-13 07:32:53 +08:00
0141_goals.sql
✨ feat(database): add goals table as independent goal entity (#18335)
2026-08-15 18:38:00 +08:00
0142_expertise_domain_tables.sql
✨ feat(expertise): add self-evolving data schema (#18334)
2026-08-15 19:47:34 +08:00
0143_resource_transfer_requests.sql
✨ feat(database): add resource transfer requests schema and migration (#18348)
2026-08-16 11:39:52 +08:00
0144_notifications_add_metadata_column.sql
🗃️ chore(db): add notifications metadata column (#18434)
2026-08-17 21:08:11 +08:00
0145_agents_add_identity_columns.sql
✨ feat(agent): give agents a character sheet, a society and an extension bag (#18464)
2026-08-20 09:07:47 +08:00
0146_acceptance_project_association.sql
✨ feat: group acceptance deliveries by project (#18448)
2026-08-20 13:00:15 +08:00
0147_resource_permissions_per_member_subject.sql
✨ feat(database): subject-aware resource permissions with per-member grants (#18536)
2026-08-21 09:21:17 +08:00
0148_goal_graph.sql
✨ feat(goal): add durable goal graph schema (#18585)
2026-08-22 14:41:49 +08:00
0149_goals_recovery_and_document_evidence.sql
✨ feat(goal): add autonomous work recovery and final acceptance (#18635)
2026-08-24 12:48:41 +08:00
0150_agent_interventions_and_live_activity.sql
✨ feat(database): persist generic agent interventions (#18417)
2026-08-26 21:28:35 -07:00
0151_document_comments.sql
✨ feat(db): add workspace document comment schema (#18726)
2026-08-27 17:04:15 +08:00
0152_trash_goal_traces_eval_dataset.sql
🗃️ chore(db): merge recycle-bin, goal-trace and eval-dataset schema into one migration (#18852)
2026-08-30 11:34:07 +08:00
0153_fts_search_sync_outbox.sql
✨ feat: add Elasticsearch full-text search provider (#18807)
2026-08-31 02:17:23 +08:00
0154_goal_node_task_kind.sql
✨ feat(goal): record and replay a goal's whole trajectory (#18801)
2026-08-31 12:41:39 +08:00
0155_document_likes.sql
✨ feat(database): add document_likes table (#18947)
2026-09-01 17:21:36 +08:00
0156_project_working_directories.sql
✨ feat: add project working directory schema (#18746)
2026-09-02 12:01:32 +08:00
0157_add_metrics_tables.sql
🗃️ feat(db): add generic metrics time-series tables (#19063)
2026-09-03 10:25:09 +08:00
0158_file_upload_reservations.sql
🐛 fix(file): reserve storage before upload (#19119)
2026-09-06 13:41:18 +08:00
0159_task_activities.sql
🗃️ feat(db): add task_activities event log for assignment changes (#19217)
2026-09-07 23:35:44 +08:00
0160_acceptance_check_assets.sql
✨ feat: add reusable check assets and grouped acceptance flows (#19268)
2026-09-08 20:08:15 +08:00
0161_acceptance_comments.sql
🗃️ feat(acceptance): a table for collaboration on an acceptance (#19392)
2026-09-10 20:44:44 +08:00
0162_configurable_quick_note_analyzer.sql
🐛 fix: allow deletion of pinned Quick Note context documents
2026-09-20 00:24:48 +09:00