storefront_script_snapshots

534 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE storefront_script_snapshots (
    snapshot_at  TEXT NOT NULL,
    store        TEXT NOT NULL,           -- 'centralvapors' | 'wholesale'
    page_url     TEXT NOT NULL,           -- the URL we GET'd
    script_id    TEXT NOT NULL,           -- src URL for src scripts; sha256 for inline
    kind         TEXT NOT NULL,           -- 'src' | 'inline'
    src          TEXT,                    -- src URL or NULL
    integrity    TEXT,                    -- integrity attr if present
    inline_hash  TEXT,                    -- sha256 of inline body, or NULL
    inline_preview TEXT,                  -- first ~300 chars of inline body for forensics
    position     INTEGER NOT NULL,        -- 0-based order in HTML
    PRIMARY KEY (snapshot_at, store, script_id, position)
);
CREATE INDEX idx_storefront_script_snapshots_lookup
    ON storefront_script_snapshots(store, snapshot_at DESC);