-- ============================================
-- BAYAZID FARM MANAGEMENT SYSTEM
-- Add attachment support (photo/document) to health records
-- Run this once after schema_phase2.sql
-- ============================================

USE technica_bayezid;

ALTER TABLE health_records ADD COLUMN attachment VARCHAR(255) NULL AFTER remarks;