-- Add disabled column to portal_user table
ALTER TABLE portal_user
ADD COLUMN disabled BOOLEAN NOT NULL DEFAULT FALSE;

-- Add disabled column to store table
ALTER TABLE store
ADD COLUMN disabled BOOLEAN NOT NULL DEFAULT FALSE;

-- Create index for faster queries on active users
CREATE INDEX idx_portal_user_disabled ON portal_user(disabled);

-- Create index for faster queries on active stores
CREATE INDEX idx_store_disabled ON store(disabled);

