-- 014_viewer_role.sql
-- Adds 'viewer' role to users.role ENUM.
-- Viewers are read-only mini-accounts issued by a tenant owner so their
-- customers can watch the company's customer flow without edit rights.

ALTER TABLE users
    MODIFY COLUMN role
        ENUM('developer','maintainer','owner','subscriber','operator','viewer')
        NOT NULL DEFAULT 'subscriber';
