-- Add shop owner info columns to pending_shoprenter_installs
-- These columns store the config_email and config_owner from ShopRenter settings API
-- to enable auto-registration during the OAuth flow

ALTER TABLE pending_shoprenter_installs
ADD COLUMN IF NOT EXISTS shop_email text,
ADD COLUMN IF NOT EXISTS shop_owner_name text;

-- Add comment for documentation
COMMENT ON COLUMN pending_shoprenter_installs.shop_email IS 'Shop admin email from ShopRenter config_email setting';
COMMENT ON COLUMN pending_shoprenter_installs.shop_owner_name IS 'Shop owner name from ShopRenter config_owner setting';
