mirror of
https://github.com/memohai/Memoh.git
synced 2026-04-25 07:00:48 +09:00
Acbox
17 lines
668 B
SQL
17 lines
668 B
SQL
-- Replace is_multimodal boolean with input modality array.
|
|
ALTER TABLE models ADD COLUMN IF NOT EXISTS input_modalities TEXT[] NOT NULL DEFAULT ARRAY['text']::TEXT[];
|
|
|
|
-- Migrate existing data (only when upgrading from old schema that had is_multimodal).
|
|
DO $$
|
|
BEGIN
|
|
IF EXISTS (
|
|
SELECT 1 FROM information_schema.columns
|
|
WHERE table_name = 'models' AND column_name = 'is_multimodal'
|
|
) THEN
|
|
UPDATE models SET input_modalities = ARRAY['text','image']::TEXT[] WHERE is_multimodal = true;
|
|
UPDATE models SET input_modalities = ARRAY['text']::TEXT[] WHERE is_multimodal = false;
|
|
END IF;
|
|
END $$;
|
|
|
|
ALTER TABLE models DROP COLUMN IF EXISTS is_multimodal;
|