This repository has been archived on 2026-11-17. You can view files and clone it, but cannot push or open issues or pull requests.
gitgram-ai/aitimemachine/api-server/drizzle/0002_add_knowledge_base_tables.sql
caelum0x 49b183818c Unify gitgram + aitimemachine into the monorepo (de-submodule) and merge vendored engines
Convert gitgram/ and aitimemachine/ from embedded git repos (which showed as
opaque submodule gitlinks on GitHub) into fully-tracked first-party content.

AITM now merges its 7 vendored repos as first-party engines:
- memory: beads (Go task DAG) + context7 (docs SDK), unified into saved_contexts
- git: vendored C git (bundled binary) + gitnexus (in-process code intelligence)
- agentic: a2a (@a2a-js/sdk) + pal (AITM-managed Python subprocess)

Includes the full session's product build: Gitgram web/mobile/backend features,
AITM website/CLI/MCP, the unified memory layer, engine build tooling
(scripts/build-engines.sh, Dockerfile, CI), docs (README, ENGINES.md, ARCHITECTURE.md),
and extensive test suites.

Build artifacts, node_modules, external/, and gemini-cli are gitignored.

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
2026-06-23 14:14:09 +03:00

45 lines
1.7 KiB
SQL

-- Migration: Add knowledge_base_files and knowledge_base_artifacts tables
-- These tables support persistent KB storage with optional S3 offloading
CREATE TABLE IF NOT EXISTS "knowledge_base_files" (
"id" uuid PRIMARY KEY DEFAULT gen_random_uuid(),
"repository_id" text NOT NULL REFERENCES "repositories"("id"),
"project_id" text NOT NULL REFERENCES "projects"("id"),
"user_id" text NOT NULL REFERENCES "users"("id"),
"file_path" text NOT NULL,
"content" text,
"content_hash" text NOT NULL,
"size" integer DEFAULT 0,
"language" text,
"source" text DEFAULT 'local',
"storage" text DEFAULT 'db',
"s3" jsonb,
"indexed_at" timestamp DEFAULT now(),
"updated_at" timestamp DEFAULT now()
);
CREATE TABLE IF NOT EXISTS "knowledge_base_artifacts" (
"id" text PRIMARY KEY,
"user_id" text NOT NULL REFERENCES "users"("id"),
"project_id" text REFERENCES "projects"("id"),
"job_id" text,
"type" text NOT NULL,
"format" text NOT NULL,
"storage" text DEFAULT 'db',
"content" jsonb,
"content_hash" text,
"size" integer DEFAULT 0,
"stats" jsonb,
"s3" jsonb,
"created_at" timestamp DEFAULT now()
);
-- Indexes
CREATE INDEX IF NOT EXISTS "idx_kb_files_repo" ON "knowledge_base_files" ("repository_id");
CREATE INDEX IF NOT EXISTS "idx_kb_files_user" ON "knowledge_base_files" ("user_id");
CREATE INDEX IF NOT EXISTS "idx_kb_files_path" ON "knowledge_base_files" ("file_path");
CREATE INDEX IF NOT EXISTS "idx_kb_files_hash" ON "knowledge_base_files" ("content_hash");
CREATE INDEX IF NOT EXISTS "idx_kb_artifacts_user" ON "knowledge_base_artifacts" ("user_id");
CREATE INDEX IF NOT EXISTS "idx_kb_artifacts_type" ON "knowledge_base_artifacts" ("type");
CREATE INDEX IF NOT EXISTS "idx_kb_artifacts_job" ON "knowledge_base_artifacts" ("job_id");