CREATE TABLE IF NOT EXISTS oidc_group_mapping (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    oidc_group_claim VARCHAR(255) NOT NULL UNIQUE,
    is_admin BOOLEAN NOT NULL DEFAULT FALSE,
    permissions TEXT,
    library_ids TEXT,
    description VARCHAR(500),
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
