TRUNCATE leave_violation_rules;

INSERT INTO `leave_violation_rules` (`leave_violation_rules_id`, `leave_id`, `duration_days`, `rule_description`, `violation_msg`, `status`, `cerated_at`, `updated_at`) VALUES (1, 1, 0, 'To be applied before, same day or future', 'Sick Leave Rule Violation ', NULL, '2019-09-04 16:05:41', '0000-00-00 00:00:00');
INSERT INTO `leave_violation_rules` (`leave_violation_rules_id`, `leave_id`, `duration_days`, `rule_description`, `violation_msg`, `status`, `cerated_at`, `updated_at`) VALUES (3, 5, 0, 'To be applied before or same day', 'Work Leave Rule Violation', NULL, '2019-09-04 16:07:05', '0000-00-00 00:00:00');
INSERT INTO `leave_violation_rules` (`leave_violation_rules_id`, `leave_id`, `duration_days`, `rule_description`, `violation_msg`, `status`, `cerated_at`, `updated_at`) VALUES (4, 2, 0, 'To be applied before or same day', 'Emergency Leave Rule Violation', NULL, '2019-09-04 16:07:37', '0000-00-00 00:00:00');
INSERT INTO `leave_violation_rules` (`leave_violation_rules_id`, `leave_id`, `duration_days`, `rule_description`, `violation_msg`, `status`, `cerated_at`, `updated_at`) VALUES (2, 9, -7, 'To be applied before', 'Annual Leave Rule Violation', NULL, '2019-09-04 16:06:35', '0000-00-00 00:00:00');
INSERT INTO `leave_violation_rules` (`leave_violation_rules_id`, `leave_id`, `duration_days`, `rule_description`, `violation_msg`, `status`, `cerated_at`, `updated_at`) VALUES (5, 7, -7, 'To be applied before', 'CPL Rule Violation', NULL, '2019-09-04 16:06:35', '0000-00-00 00:00:00');
