inventory/backend/database/add_date_of_purchase.sql

-- Add date_of_purchase column to items table
ALTER TABLE items 
ADD COLUMN date_of_purchase DATE NULL 
AFTER price;

-- Set default date for existing items (current date)
UPDATE items 
SET date_of_purchase = CURDATE() 
WHERE date_of_purchase IS NULL;