1ALTER TABLE forward_sessions ADD COLUMN client_id TEXT
 2    CHECK (
 3        client_id IS NULL
 4        OR (length(client_id) BETWEEN 1 AND 32 AND client_id NOT GLOB '*[^a-z0-9_]*')
 5    );
 6ALTER TABLE forward_sessions ADD COLUMN address TEXT
 7    CHECK (
 8        address IS NULL
 9        OR (length(address) BETWEEN 2 AND 45 AND address NOT GLOB '*[^0-9a-f.:]*')
10    );
11ALTER TABLE forward_sessions ADD COLUMN user_agent TEXT
12    CHECK (
13        user_agent IS NULL
14        OR (
15            length(CAST(user_agent AS BLOB)) BETWEEN 1 AND 256
16            AND user_agent NOT GLOB '*[' || char(1) || '-' || char(31) || char(127) || ']*'
17        )
18    );
19ALTER TABLE forward_sessions ADD COLUMN last_seen_at INTEGER;