home / declaration250 / app_csp_origins

Menu

app_csp_origins

✎ View and edit SQL

This data as json

id ▼ app_id directive origin created_at updated_at

0 records

CREATE TABLE app_csp_origins (
    id INTEGER PRIMARY KEY,
    app_id TEXT NOT NULL REFERENCES apps(id),
    directive TEXT NOT NULL DEFAULT 'connect-src',
    origin TEXT NOT NULL,
    created_at TEXT NOT NULL,
    updated_at TEXT NOT NULL,
    CHECK (directive IN ('connect-src')),
    UNIQUE (app_id, directive, origin)
);
CREATE INDEX idx_app_csp_origins_app
    ON app_csp_origins(app_id, directive);
Powered by Datasette · Queries took 1.2ms