apskel-pos-backend/migrations/000036_add_deleted_at_to_units.up.sql

-- Add deleted_at column to units table for soft delete functionality
ALTER TABLE units ADD COLUMN deleted_at TIMESTAMP WITH TIME ZONE;
CREATE INDEX idx_units_deleted_at ON units(deleted_at);