-- Migration: Add Telegram support to donors table
-- Run this after creating the initial schema

USE `blood_bank`;

ALTER TABLE `donors` 
ADD COLUMN `telegram_chat_id` VARCHAR(50) DEFAULT NULL AFTER `phone_secondary`,
ADD COLUMN `telegram_username` VARCHAR(100) DEFAULT NULL AFTER `telegram_chat_id`;

-- Add index for telegram chat_id
ALTER TABLE `donors` ADD INDEX `telegram_chat_id` (`telegram_chat_id`);
ALTER TABLE `donors` ADD INDEX `telegram_username` (`telegram_username`);

