-- Add soft delete columns to bills table
ALTER TABLE bills ADD COLUMN deleted_by UUID;
ALTER TABLE bills ADD COLUMN deleted_at TIMESTAMP;

-- Create index for deleted_at to optimize soft delete queries
CREATE INDEX idx_bills_deleted_at ON bills(deleted_at);

-- DROP DATABASE IF EXISTS bekind_backend;