packages/server/migrations/001_add_document_fields.sql 1.1 K raw
1
-- Migration: Add full Document and Publication fields to resolved_documents
2
-- Run with: wrangler d1 execute atfeeds-db --file=migrations/001_add_document_fields.sql --remote
3
4
-- Document fields
5
ALTER TABLE resolved_documents ADD COLUMN description TEXT;
6
ALTER TABLE resolved_documents ADD COLUMN cover_image_cid TEXT;
7
ALTER TABLE resolved_documents ADD COLUMN cover_image_url TEXT;
8
ALTER TABLE resolved_documents ADD COLUMN bsky_post_ref TEXT;
9
ALTER TABLE resolved_documents ADD COLUMN tags TEXT;
10
ALTER TABLE resolved_documents ADD COLUMN updated_at TEXT;
11
12
-- Publication fields
13
ALTER TABLE resolved_documents ADD COLUMN pub_url TEXT;
14
ALTER TABLE resolved_documents ADD COLUMN pub_name TEXT;
15
ALTER TABLE resolved_documents ADD COLUMN pub_description TEXT;
16
ALTER TABLE resolved_documents ADD COLUMN pub_icon_cid TEXT;
17
ALTER TABLE resolved_documents ADD COLUMN pub_icon_url TEXT;
18
19
-- Metadata
20
ALTER TABLE resolved_documents ADD COLUMN pds_endpoint TEXT;
21
22
-- Index for publication queries
23
CREATE INDEX IF NOT EXISTS idx_resolved_documents_pub_url ON resolved_documents(pub_url);