-- Migration: Add connection test status to GA4 settings table
-- Date: 2025-01-XX
-- Description: Adds connection_test_passed column to track if GA4 connection test has been completed

-- ===== Add connection test status to GA4 Settings =====
ALTER TABLE ga4_settings 
ADD COLUMN connection_test_passed BOOLEAN DEFAULT FALSE COMMENT '接続テストが完了しているかどうか',
ADD COLUMN connection_test_date TIMESTAMP NULL DEFAULT NULL COMMENT '接続テスト完了日時';

-- Add index for connection test status
ALTER TABLE ga4_settings
ADD INDEX idx_connection_test (connection_test_passed);

