mirror of
https://github.com/coleam00/Archon.git
synced 2025-12-23 18:29:18 -05:00
3ff3f7f2dc
* Preparing migration folder for the migration alert implementation * Migrations and version APIs initial * Touching up update instructions in README and UI * Unit tests for migrations and version APIs * Splitting up the Ollama migration scripts * Removing temporary PRPs --------- Co-authored-by: Rasmus Widing <rasmus.widing@gmail.com>
35 lines
1.4 KiB
PL/PgSQL
35 lines
1.4 KiB
PL/PgSQL
-- ======================================================================
|
|
-- Migration 003: Ollama Implementation - Add Columns
|
|
-- Adds multi-dimensional embedding support columns
|
|
-- ======================================================================
|
|
|
|
-- Increase memory for this session
|
|
SET maintenance_work_mem = '256MB';
|
|
|
|
BEGIN;
|
|
|
|
-- Add multi-dimensional embedding columns to archon_crawled_pages
|
|
ALTER TABLE archon_crawled_pages
|
|
ADD COLUMN IF NOT EXISTS embedding_384 VECTOR(384),
|
|
ADD COLUMN IF NOT EXISTS embedding_768 VECTOR(768),
|
|
ADD COLUMN IF NOT EXISTS embedding_1024 VECTOR(1024),
|
|
ADD COLUMN IF NOT EXISTS embedding_1536 VECTOR(1536),
|
|
ADD COLUMN IF NOT EXISTS embedding_3072 VECTOR(3072),
|
|
ADD COLUMN IF NOT EXISTS llm_chat_model TEXT,
|
|
ADD COLUMN IF NOT EXISTS embedding_model TEXT,
|
|
ADD COLUMN IF NOT EXISTS embedding_dimension INTEGER;
|
|
|
|
-- Add multi-dimensional embedding columns to archon_code_examples
|
|
ALTER TABLE archon_code_examples
|
|
ADD COLUMN IF NOT EXISTS embedding_384 VECTOR(384),
|
|
ADD COLUMN IF NOT EXISTS embedding_768 VECTOR(768),
|
|
ADD COLUMN IF NOT EXISTS embedding_1024 VECTOR(1024),
|
|
ADD COLUMN IF NOT EXISTS embedding_1536 VECTOR(1536),
|
|
ADD COLUMN IF NOT EXISTS embedding_3072 VECTOR(3072),
|
|
ADD COLUMN IF NOT EXISTS llm_chat_model TEXT,
|
|
ADD COLUMN IF NOT EXISTS embedding_model TEXT,
|
|
ADD COLUMN IF NOT EXISTS embedding_dimension INTEGER;
|
|
|
|
COMMIT;
|
|
|
|
SELECT 'Ollama columns added successfully' AS status; |