mirror of
https://github.com/tiennm99/goclaw.git
synced 2026-10-13 00:14:33 +00:00
viettranx
2644a08b2b
- Add migration 000048: vault_documents.path_basename + vault_links.metadata (PG) - Update SQLite schema.sql: add path_basename, metadata columns + v15→v16 markers - Add schema.go backfill: loop-patch v15→v16 + basename extraction for existing docs - Update vault_documents store: SELECT/INSERT with path_basename (PG + SQLite) - Update vault_links store: SELECT/INSERT with metadata (PG + SQLite) - Add vault_source_cleanup: helper to purge orphaned sources + links by source ID - Add basename_helper.go + test: extract filename from path for DB sync - Update version.go: RequiredSchemaVersion → 48, SQLite SchemaVersion → 16 - Update vault_store.go: DeleteLinksBySource + BatchFindByDelegationIDs interface
20 lines
717 B
SQL
20 lines
717 B
SQL
-- Reverse Phase 03 schema changes.
|
|
|
|
DROP INDEX IF EXISTS idx_vault_docs_delegation;
|
|
|
|
ALTER TABLE vault_links DROP CONSTRAINT IF EXISTS vault_links_to_doc_id_fkey;
|
|
ALTER TABLE vault_links
|
|
ADD CONSTRAINT vault_links_to_doc_id_fkey
|
|
FOREIGN KEY (to_doc_id) REFERENCES vault_documents(id);
|
|
|
|
ALTER TABLE vault_links DROP CONSTRAINT IF EXISTS vault_links_from_doc_id_fkey;
|
|
ALTER TABLE vault_links
|
|
ADD CONSTRAINT vault_links_from_doc_id_fkey
|
|
FOREIGN KEY (from_doc_id) REFERENCES vault_documents(id);
|
|
|
|
DROP INDEX IF EXISTS idx_vault_links_source;
|
|
ALTER TABLE vault_links DROP COLUMN IF EXISTS metadata;
|
|
|
|
DROP INDEX IF EXISTS idx_tta_tenant_basename;
|
|
ALTER TABLE team_task_attachments DROP COLUMN IF EXISTS base_name;
|