-- ========================================
-- ADD FCM COLUMNS TO web_private TABLE
-- ========================================

USE `whatscrm`;

-- Add missing FCM columns to web_private (using TEXT to avoid row size limit)
ALTER TABLE `web_private`
ADD COLUMN `fcm_apiKey` text DEFAULT NULL AFTER `teleHash`,
ADD COLUMN `fcm_authDomain` text DEFAULT NULL,
ADD COLUMN `fcm_projectId` text DEFAULT NULL,
ADD COLUMN `fcm_storageBucket` text DEFAULT NULL,
ADD COLUMN `fcm_messagingSenderId` text DEFAULT NULL,
ADD COLUMN `fcm_appId` text DEFAULT NULL,
ADD COLUMN `fcm_measurementId` text DEFAULT NULL,
ADD COLUMN `fcm_vapidKey` text DEFAULT NULL,
ADD COLUMN `fcm_clientEmail` text DEFAULT NULL,
ADD COLUMN `fcm_privateKey` text DEFAULT NULL;