-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `hris`
--

-- --------------------------------------------------------

--
-- Table structure for table `leave_types`
--

/*CREATE TABLE `leave_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` char(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `acronym` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;*/

--
-- Dumping data for table `leave_types`
--

INSERT INTO `leave_types` (`id`, `name`, `acronym`, `no_days`, `gender`, `is_attachment_required`, `is_staggered`, `is_include_weekend`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Vacation', 'VL', NULL, 'all', 0, 1, 0, 1, '2019-10-28 01:07:31', '2021-07-14 07:41:08'),
(2, 'Force', 'FL', '5', 'all', 0, 1, 0, 1, '2019-10-28 01:07:40', '2021-06-30 07:36:57'),
(3, 'Sick', 'SL', NULL, 'all', 0, 1, 0, 1, '2019-10-28 01:07:50', '2021-06-30 07:40:23'),
(4, 'Special Privilege', 'SPL', '3', 'all', 0, 1, 0, 1, '2019-10-28 01:08:00', '2021-06-30 07:42:09'),
(5, 'Maternity', 'MAL', '105', 'F', 1, 0, 1, 1, '2019-10-28 01:08:10', '2021-07-12 04:11:44'),
(6, 'Paternity', 'PAL', '7', 'M', 1, 1, 0, 1, '2019-10-28 01:08:16', '2021-06-30 07:44:10'),
(8, 'Monetization', 'MOL', NULL, 'all', 1, 0, 0, 1, '2019-10-28 01:08:37', '2021-07-08 02:07:24'),
(9, 'Parental (Solo Parent)', 'SOL', '7', 'all', 1, 1, 0, 1, '2019-10-28 01:08:55', '2021-06-30 07:44:58'),
(10, 'CTO', 'CTO', NULL, 'all', 0, 1, 0, 1, '2019-10-28 01:09:14', '2021-07-08 06:44:42'),
(11, 'CDO', 'CDO', NULL, 'all', 0, 1, 0, 1, '2019-10-28 01:09:20', '2021-06-30 07:36:39'),
(13, 'Maternity - 7 days Transferable to father/alternate caregiver', 'MTF', '7', 'all', 1, 0, 1, 1, '2019-10-28 01:12:14', '2021-06-30 07:34:48'),
(14, 'Maternity - 15 days for single mother', 'MSM', '15', 'F', 0, 0, 1, 1, '2019-10-28 01:12:14', '2021-07-01 07:48:48'),
(15, 'Special Emergency (Calamity)', 'SEL', '5', 'all', 0, 1, 0, 1, '2021-06-09 04:29:06', '2021-06-30 07:41:13'),
(16, 'Adoption', 'ADL', '60', 'all', 1, 0, 1, 1, '2021-06-09 04:30:32', '2021-07-13 03:08:35'),
(17, 'VAWC', 'VAL', '10', 'F', 1, 1, 0, 1, '2021-06-09 04:30:46', '2021-07-08 06:42:07'),
(18, 'Study', 'STL', NULL, 'all', 1, 0, 1, 1, '2021-06-09 04:31:12', '2021-06-30 07:42:18'),
(19, 'Special Leave Benefits for women', 'SLBW', '60', 'F', 1, 0, 1, 1, '2021-06-09 04:31:50', '2021-06-30 07:41:56'),
(20, 'Rehabilitation', 'REL', NULL, 'all', 1, 0, 1, 1, '2021-06-09 04:32:51', '2021-06-30 07:39:45'),
(21, 'Sabbatical', 'SAL', NULL, 'all', 0, 0, 1, 1, '2021-06-09 04:33:50', '2021-06-30 07:39:55');

-- INSERT INTO `leave_types` (`id`, `name`, `acronym`, `created_at`, `updated_at`) VALUES
-- (1, 'Vacation', 'VL', '2019-10-28 01:07:31', '2019-10-28 01:07:31'),
-- (2, 'Force', 'FL', '2019-10-28 01:07:40', '2019-10-28 01:07:40'),
-- (3, 'Sick', 'SL', '2019-10-28 01:07:50', '2019-10-28 01:07:50'),
-- (4, 'Special', 'SPL', '2019-10-28 01:08:00', '2019-10-28 01:08:00'),
-- (5, 'Maternity', 'MAL', '2019-10-28 01:08:10', '2019-10-28 01:08:10'),
-- (6, 'Paternity', 'PAL', '2019-10-28 01:08:16', '2019-10-28 01:08:16'),
-- (7, 'Service credits', 'SEL', '2019-10-28 01:08:28', '2019-10-28 01:08:28'),
-- (8, 'Monetization', 'MOL', '2019-10-28 01:08:37', '2019-10-28 01:08:37'),
-- (9, 'Parental (Solo Parent)', 'SOL', '2019-10-28 01:08:55', '2019-10-28 01:08:55'),
-- (10, 'CTO', 'CTO', '2019-10-28 01:09:14', '2019-10-28 01:09:14'),
-- (11, 'CDO', 'CDO', '2019-10-28 01:09:20', '2019-10-28 01:09:20'),
-- (12, 'Emergency', 'EML', '2019-10-28 01:12:14', '2019-10-28 01:12:14'),
-- (13, 'Maternity - 7 days Transferable to father', 'MTF', '2019-10-28 01:12:14', '2019-10-28 01:12:14'),
-- (14, 'Maternity - 15 days for single mother', 'MSM', '2019-10-28 01:12:14', '2019-10-28 01:12:14');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `leave_types`
--
ALTER TABLE `leave_types`
    ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `leave_types`
--
ALTER TABLE `leave_types`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
COMMIT;

