-- Ensure workplace invoice type exists
INSERT INTO invoice_types (name)
SELECT 'workplace'
WHERE NOT EXISTS (
    SELECT 1 FROM invoice_types WHERE name='workplace'
);

-- Ensure Notice of Certain Workplaces invoice template exists
INSERT INTO invoice_templates (name, file_path, tenant_id)
SELECT 'Notice of Certain Workplaces', 'templates/invoices/workplace_notice.php', NULL
WHERE NOT EXISTS (
    SELECT 1 FROM invoice_templates WHERE file_path='templates/invoices/workplace_notice.php'
);
