dodil/erp-brick-payroll

DODIL ERP brick: payroll

src/brick_payroll/migrations/00003_statutory_rows/down.sql

-- 00003_statutory_rows down: removes the rows this migration seeded.
DELETE FROM prl_element WHERE company_code = '*' AND element_code IN ('SICK_DEDUCTION', 'SSP', 'MATERNITY_DEDUCTION', 'SMP');
DELETE FROM prl_statutory_rate WHERE set_by = 'seed' AND rate_key IN ('ssp_weekly_rate', 'ssp_waiting_days', 'ssp_lel_test', 'ssp_earnings_cap_pct', 'ssp_requires_piw', 'ssp_max_weeks', 'ssp_self_certification_days', 'ni_lower_earnings_limit', 'smp_weekly_flat_rate', 'smp_higher_pct', 'smp_higher_weeks', 'smp_total_weeks', 'smp_recovery_pct', 'smp_small_employer_recovery_pct');