Files

8 lines
189 B
SQL
Raw Permalink Normal View History

ALTER TABLE knowledge_items
ADD COLUMN markdown_content TEXT;
UPDATE knowledge_items
SET markdown_content = content_text
WHERE markdown_content IS NULL
AND content_text IS NOT NULL;