-- ============================================
-- BAYAZID FARM MANAGEMENT SYSTEM
-- Sales module v4: link each employee to their factory
-- so picking an employee auto-fills the factory field.
-- Run this AFTER schema_sales_v3.sql
-- ============================================

USE technica_bayezid;

ALTER TABLE employees ADD COLUMN factory_id INT NULL AFTER contact;
ALTER TABLE employees ADD CONSTRAINT fk_employees_factory FOREIGN KEY (factory_id) REFERENCES factories(id) ON DELETE SET NULL;