stevedylan.dev / docs.surf
A fullstack app for indexing standard.site documents
fork atom
docs.surf / packages / server / migrations / 001_add_document_fields.sql
at main 23 lines 1.1 kB view 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 5ALTER TABLE resolved_documents ADD COLUMN description TEXT; 6ALTER TABLE resolved_documents ADD COLUMN cover_image_cid TEXT; 7ALTER TABLE resolved_documents ADD COLUMN cover_image_url TEXT; 8ALTER TABLE resolved_documents ADD COLUMN bsky_post_ref TEXT; 9ALTER TABLE resolved_documents ADD COLUMN tags TEXT; 10ALTER TABLE resolved_documents ADD COLUMN updated_at TEXT; 11 12-- Publication fields 13ALTER TABLE resolved_documents ADD COLUMN pub_url TEXT; 14ALTER TABLE resolved_documents ADD COLUMN pub_name TEXT; 15ALTER TABLE resolved_documents ADD COLUMN pub_description TEXT; 16ALTER TABLE resolved_documents ADD COLUMN pub_icon_cid TEXT; 17ALTER TABLE resolved_documents ADD COLUMN pub_icon_url TEXT; 18 19-- Metadata 20ALTER TABLE resolved_documents ADD COLUMN pds_endpoint TEXT; 21 22-- Index for publication queries 23CREATE INDEX IF NOT EXISTS idx_resolved_documents_pub_url ON resolved_documents(pub_url);