Forbes 8d777e83bb feat(db): .kc metadata database migration (#140) ...

Add migration 018_kc_metadata.sql with all tables needed for .kc
server-side metadata indexing:

- item_metadata: indexed manifest + metadata fields from silo/
  directory (tags, lifecycle_state, fields JSONB, manifest info)
- item_dependencies: CAD-extracted assembly dependencies
  (complements existing relationships table)
- item_approvals + approval_signatures: ECO workflow state
- item_macros: registered macros from silo/macros/

Also adds docs/KC_SERVER.md specification document.

Closes #140

2026-02-18 15:04:03 -06:00

..

001_initial.sql

update databasing system with minimum API, schema parsing and FreeCAD

2026-01-24 15:03:17 -06:00

002_sequence_by_name.sql

update databasing system with minimum API, schema parsing and FreeCAD

2026-01-24 15:03:17 -06:00

003_remove_material.sql

update databasing system with minimum API, schema parsing and FreeCAD

2026-01-24 15:03:17 -06:00

004_cad_sync_state.sql

update databasing system with minimum API, schema parsing and FreeCAD

2026-01-24 15:03:17 -06:00

005_property_schema_version.sql

update databasing system with minimum API, schema parsing and FreeCAD

2026-01-24 15:03:17 -06:00

006_project_tags.sql

Add revision control and project tagging migration

2026-01-24 16:27:18 -06:00

007_revision_status.sql

Add revision control and project tagging migration

2026-01-24 16:27:18 -06:00

008_odoo_integration.sql

feat: Infor-style split-panel layout, projects page, fuzzy search, Odoo scaffold

2026-01-31 09:20:27 -06:00

009_auth.sql

feat(auth): add authentication, RBAC, API tokens, and default admin

2026-01-31 11:20:12 -06:00

010_item_extended_fields.sql

fix: push detects locally modified files, renumber migration to 010

2026-01-31 19:13:21 -06:00

011_item_files.sql

feat: production release with React SPA, file attachments, and deploy tooling

2026-02-07 13:35:22 -06:00

012_bom_source.sql

feat(db): add source column to relationships table (#44)

2026-02-08 18:45:41 -06:00

013_move_cost_sourcing_to_props.sql

refactor: move sourcing_link and standard_cost from item columns to revision properties

2026-02-11 09:50:31 -06:00

014_dag_nodes_edges.sql

feat: add database migrations for DAG and worker system

2026-02-14 13:04:41 -06:00

015_jobs_runners.sql

feat: add database migrations for DAG and worker system

2026-02-14 13:04:41 -06:00

016_module_system.sql

feat(modules): settings_overrides and module_state migration

2026-02-14 13:56:26 -06:00

017_file_storage_metadata.sql

feat(db): add storage backend metadata columns

2026-02-17 12:30:20 -06:00

018_kc_metadata.sql

feat(db): .kc metadata database migration (#140)

2026-02-18 15:04:03 -06:00