-- M4: Permission Graduation - Add currentLevel column
-- Migration: Add permission level tracking to conversation state
-- Add currentLevel column (1=read, 2=write, 3=execute)
ALTER TABLE conversations
ADD COLUMN current_level INTEGER NOT NULL DEFAULT 1;
-- Add constraint to ensure valid permission levels
ALTER TABLE conversations
ADD CONSTRAINT valid_permission_level CHECK (current_level >= 1 AND current_level <= 3);
-- Add index for permission level queries
CREATE INDEX idx_conversations_current_level ON conversations(current_level);
-- Add comment explaining the column
COMMENT ON COLUMN conversations.current_level IS 'M4: Current permission level (1=read, 2=write, 3=execute). Accumulated through permission upgrades.';
