-- Add is_pending column to tablo_invites table
ALTER TABLE tablo_invites 
ADD COLUMN IF NOT EXISTS is_pending BOOLEAN DEFAULT FALSE NOT NULL;

-- Add comment to document the column
COMMENT ON COLUMN tablo_invites.is_pending IS 
    'When TRUE, the invite is pending acceptance. When FALSE, the invite has been accepted or rejected.';

-- Create index for performance when querying pending invites
CREATE INDEX IF NOT EXISTS idx_tablo_invites_is_pending ON tablo_invites(is_pending);