theme_snapshots

✎ View and edit SQL

This data as json

0 records

CREATE TABLE theme_snapshots (
    snapshot_at      TEXT NOT NULL,
    store            TEXT NOT NULL,        -- store label: 'centralvapors' | 'wholesale'
    theme_uuid       TEXT NOT NULL,
    name             TEXT,
    is_active        INTEGER NOT NULL DEFAULT 0,
    is_private       INTEGER NOT NULL DEFAULT 0,
    PRIMARY KEY (snapshot_at, store, theme_uuid)
);
CREATE INDEX idx_theme_snapshots_lookup
    ON theme_snapshots(store, snapshot_at DESC);