1package sites23import (4 "context"5 "database/sql"6)78const manifestSchema = `CREATE TABLE IF NOT EXISTS site_manifests (9 label TEXT PRIMARY KEY, event_id TEXT NOT NULL, kind INTEGER NOT NULL,10 pubkey TEXT NOT NULL, d TEXT NOT NULL DEFAULT '', updated_at INTEGER NOT NULL11);12CREATE TRIGGER IF NOT EXISTS site_manifest_event_deleted13AFTER DELETE ON events14WHEN old.kind IN (5128,15128,35128)15BEGIN16 DELETE FROM site_manifests WHERE event_id=old.id;17END;`1819func ensureManifestSchema(ctx context.Context, db *sql.DB) error {20 _, err := db.ExecContext(ctx, manifestSchema)21 return err22}