0001 Scrape Store

codemode-gatewaysourcesql
Path: codemode-gateway/migrations/0001_scrape_store.sqlRelative: migrations/0001_scrape_store.sqlSubproject: codemode-gatewayCategory: codemode-gateway
Lines: 22Bytes: 905Imports: 0Exports: 0
codemode-gatewaysourcesqlmigrations

Content Preview

  1. -- 0001_scrape_store.sql — B6 D1 persistence layer for codemode-gateway.
  2. -- Creates the single `scrape_pages` table backing the `scrape` namespace
  3. -- (scrape.save / recent / get / find) and the generic `db` namespace.
  4. -- Applied via:
  5. -- bunx wrangler d1 execute codemode-gateway-store --remote \
  6. -- --file=migrations/0001_scrape_store.sql
  7. -- Idempotent: uses IF NOT EXISTS so re-running the deploy script is safe.
  9. CREATE TABLE IF NOT EXISTS scrape_pages (
  10. id TEXT PRIMARY KEY,
  11. url TEXT NOT