007_permissions.sql RawHistoryFolder

1-- +goose Up
2-- Permission storage for media access (mic, camera, etc.)
3-- Per W3C spec: display capture permissions cannot be persisted
4
5CREATE TABLE IF NOT EXISTS permissions (
6    origin TEXT NOT NULL,
7    permission_type TEXT NOT NULL,
8    decision TEXT NOT NULL CHECK(decision IN ('granted', 'denied')),
9    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
10    PRIMARY KEY (origin, permission_type)
11);
12
13CREATE INDEX IF NOT EXISTS idx_permissions_updated_at ON permissions(updated_at);
14
15-- +goose Down
16DROP TABLE IF EXISTS permissions;