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

START TRANSACTION;



--
-- Database: `osapp_hrm_dev`
--

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

--
-- Table structure for table `account`
--

CREATE TABLE `account` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) 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 `account`
--

INSERT INTO `account` (`id`, `name`, `type`, `created_at`, `updated_at`) VALUES
(1, 'Asset', 'Asset', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(2, 'Liability', 'Liability', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(3, 'Capital', 'Owner\'s Equity', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(4, 'Withdrawal', 'Owner\'s Equity', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(5, 'Revenue', 'Owner\'s Equity', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(6, 'Expense', 'Owner\'s Equity', '2023-11-19 08:50:59', '2023-11-19 08:50:59');

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

--
-- Table structure for table `announcement`
--

CREATE TABLE `announcement` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `appSetting`
--

CREATE TABLE `appSetting` (
  `id` bigint UNSIGNED NOT NULL,
  `companyName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tagLine` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `footer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 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 `appSetting`
--

INSERT INTO `appSetting` (`id`, `companyName`, `tagLine`, `address`, `phone`, `email`, `website`, `footer`, `logo`, `created_at`, `updated_at`) VALUES
(1, 'Company Name', 'Tag Line', 'Address', '2345678', 'company@gmail.com', 'Website', 'Footer', NULL, '2023-11-19 08:50:59', '2023-11-19 08:50:59');

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

--
-- Table structure for table `assignedTask`
--

CREATE TABLE `assignedTask` (
  `id` bigint UNSIGNED NOT NULL,
  `taskId` bigint UNSIGNED NOT NULL,
  `userId` bigint UNSIGNED NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `attendance`
--

CREATE TABLE `attendance` (
  `id` bigint UNSIGNED NOT NULL,
  `userId` bigint UNSIGNED NOT NULL,
  `inTime` datetime NOT NULL,
  `outTime` datetime DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `punchBy` int DEFAULT NULL,
  `totalHour` double DEFAULT NULL,
  `inTimeStatus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outTimeStatus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `award`
--

CREATE TABLE `award` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `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 `award`
--

INSERT INTO `award` (`id`, `name`, `description`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Employee of the Month', 'Awarded to the employee of the month', 'https://i.imgur.com/3Lm2Wwv.png', 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(2, 'Employee of the Year', 'Awarded to the employee of the year', 'https://i.imgur.com/3Lm2Wwv.png', 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59');

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

--
-- Table structure for table `awardHistory`
--

CREATE TABLE `awardHistory` (
  `id` bigint UNSIGNED NOT NULL,
  `userId` bigint UNSIGNED NOT NULL,
  `awardId` bigint UNSIGNED NOT NULL,
  `awardedDate` datetime NOT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `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 `department`
--

INSERT INTO `department` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(2, 'HR', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(3, 'IT', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(4, 'Marketing', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(5, 'Sales', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(6, 'Accounting', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(7, 'Production', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(8, 'Logistics', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(9, 'Customer Service', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(10, 'Research and Development', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(11, 'Quality Assurance', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(12, 'Purchasing', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(13, 'Legal', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(14, 'Facilities', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(15, 'Security', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(16, 'Management', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58');

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

--
-- Table structure for table `designation`
--

CREATE TABLE `designation` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `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 `designation`
--

INSERT INTO `designation` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'CEO', 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(2, 'COO', 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(3, 'CFO', 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59');

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

--
-- Table structure for table `designationHistory`
--

CREATE TABLE `designationHistory` (
  `id` bigint UNSIGNED NOT NULL,
  `userId` bigint UNSIGNED NOT NULL,
  `designationId` bigint UNSIGNED NOT NULL,
  `startDate` datetime NOT NULL,
  `endDate` datetime DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `education`
--

CREATE TABLE `education` (
  `id` bigint UNSIGNED NOT NULL,
  `userId` bigint UNSIGNED NOT NULL,
  `degree` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `institution` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fieldOfStudy` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `result` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `studyStartDate` datetime NOT NULL,
  `studyEndDate` datetime DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `email`
--

CREATE TABLE `email` (
  `id` bigint UNSIGNED NOT NULL,
  `senderEmail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `receiverEmail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` longtext COLLATE utf8mb4_unicode_ci,
  `emailStatus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `employmentStatus`
--

CREATE TABLE `employmentStatus` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `colourValue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `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 `employmentStatus`
--

INSERT INTO `employmentStatus` (`id`, `name`, `colourValue`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Intern', '#00FF00', 'Intern', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(2, 'Permanent', '#FF0000', 'Permanent', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(3, 'Staff', '#FFFF00', 'Staff', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(4, 'Terminated', '#00FFFF', 'Terminated', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58');

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

--
-- Table structure for table `leaveApplication`
--

CREATE TABLE `leaveApplication` (
  `id` bigint UNSIGNED NOT NULL,
  `userId` bigint UNSIGNED NOT NULL,
  `leaveType` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `leaveFrom` datetime NOT NULL,
  `leaveTo` datetime NOT NULL,
  `acceptLeaveFrom` datetime DEFAULT NULL,
  `acceptLeaveTo` datetime DEFAULT NULL,
  `acceptLeaveBy` int DEFAULT NULL,
  `leaveDuration` int DEFAULT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reviewComment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `leavePolicy`
--

CREATE TABLE `leavePolicy` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `paidLeaveCount` int NOT NULL,
  `unpaidLeaveCount` int NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `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 `leavePolicy`
--

INSERT INTO `leavePolicy` (`id`, `name`, `paidLeaveCount`, `unpaidLeaveCount`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Policy 8-12', 8, 12, 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(2, 'Policy 12-15', 12, 15, 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(3, 'Policy 15-15', 15, 15, 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(2, '2023_07_10_040532_create_employment_status_table', 1),
(3, '2023_07_10_040552_create_department_table', 1),
(4, '2023_07_10_040609_create_role_table', 1),
(5, '2023_07_10_040624_create_shift_table', 1),
(6, '2023_07_10_040639_create_users_table', 1),
(7, '2023_07_11_071240_create_education_table', 1),
(8, '2023_07_11_111057_update_users_table', 1),
(9, '2023_07_12_065307_create_permission_table', 1),
(10, '2023_07_12_090218_create_role_permission_table', 1),
(11, '2023_07_16_082632_create_designation_table', 1),
(12, '2023_07_16_082811_create_designation_history_table', 1),
(13, '2023_07_16_090929_create_salary_history_table', 1),
(14, '2023_07_17_043455_create_app_setting_table', 1),
(15, '2023_07_17_080852_create_account_table', 1),
(16, '2023_07_17_081817_create_sub_account_table', 1),
(17, '2023_07_17_101745_create_transaction_table', 1),
(18, '2023_08_15_072853_create_announcement_table', 1),
(19, '2023_08_16_041506_create_award_table', 1),
(20, '2023_08_16_065556_create_award_history_table', 1),
(21, '2023_08_29_081018_create_email_config_table', 1),
(22, '2023_08_30_065226_create_email_table', 1),
(23, '2023_09_05_055747_create_project_table', 1),
(24, '2023_09_05_060014_create_public_holiday_table', 1),
(25, '2023_09_05_060058_create_milestone_table', 1),
(26, '2023_09_05_060215_create_task_status_table', 1),
(27, '2023_09_05_060318_create_priority_table', 1),
(28, '2023_09_05_060432_create_task_table', 1),
(29, '2023_09_05_061613_create_project_team_table', 1),
(30, '2023_09_05_062418_create_project_team_member_table', 1),
(31, '2023_09_05_062619_create_assigned_task_table', 1),
(32, '2023_09_05_102951_create_weekly_holiday_table', 1),
(33, '2023_09_06_040656_create_leave_policy_table', 1),
(34, '2023_09_06_053958_add_foreign_key_to_users', 1),
(35, '2023_09_06_073113_create_leave_application_table', 1),
(36, '2023_09_07_035153_create_attendance_table', 1),
(37, '2023_09_07_102931_create_payslip_table', 1);

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

--
-- Table structure for table `milestone`
--

CREATE TABLE `milestone` (
  `id` bigint UNSIGNED NOT NULL,
  `projectId` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `startDate` datetime NOT NULL,
  `endDate` datetime NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payslip`
--

CREATE TABLE `payslip` (
  `id` bigint UNSIGNED NOT NULL,
  `userId` bigint UNSIGNED NOT NULL,
  `salaryMonth` int NOT NULL,
  `salaryYear` int NOT NULL,
  `salary` double(8,2) NOT NULL,
  `paidLeave` int NOT NULL,
  `unpaidLeave` int NOT NULL,
  `monthlyHoliday` int NOT NULL,
  `publicHoliday` int NOT NULL,
  `workDay` int NOT NULL,
  `shiftWiseWorkHour` double(8,2) NOT NULL,
  `monthlyWorkHour` double(8,2) NOT NULL,
  `hourlySalary` double(8,2) NOT NULL,
  `workingHour` double(8,2) NOT NULL,
  `salaryPayable` double(8,2) NOT NULL,
  `bonus` double(8,2) NOT NULL,
  `bonusComment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deduction` double(8,2) NOT NULL,
  `deductionComment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `totalPayable` double(8,2) NOT NULL,
  `paymentStatus` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'UNPAID',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `permission`
--

CREATE TABLE `permission` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) 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 `permission`
--

INSERT INTO `permission` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'create-rolePermission', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(2, 'readAll-rolePermission', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(3, 'readSingle-rolePermission', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(4, 'update-rolePermission', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(5, 'delete-rolePermission', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(6, 'create-transaction', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(7, 'readAll-transaction', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(8, 'readSingle-transaction', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(9, 'update-transaction', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(10, 'delete-transaction', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(11, 'create-permission', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(12, 'readAll-permission', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(13, 'readSingle-permission', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(14, 'update-permission', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(15, 'delete-permission', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(16, 'create-dashboard', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(17, 'readAll-dashboard', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(18, 'readSingle-dashboard', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(19, 'update-dashboard', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(20, 'delete-dashboard', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(21, 'create-user', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(22, 'readAll-user', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(23, 'readSingle-user', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(24, 'update-user', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(25, 'delete-user', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(26, 'create-role', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(27, 'readAll-role', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(28, 'readSingle-role', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(29, 'update-role', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(30, 'delete-role', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(31, 'create-designation', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(32, 'readAll-designation', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(33, 'readSingle-designation', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(34, 'update-designation', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(35, 'delete-designation', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(36, 'create-account', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(37, 'readAll-account', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(38, 'readSingle-account', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(39, 'update-account', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(40, 'delete-account', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(41, 'create-setting', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(42, 'readAll-setting', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(43, 'readSingle-setting', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(44, 'update-setting', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(45, 'delete-setting', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(46, 'create-email', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(47, 'readAll-email', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(48, 'readSingle-email', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(49, 'update-email', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(50, 'delete-email', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(51, 'create-attendance', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(52, 'readAll-attendance', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(53, 'readSingle-attendance', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(54, 'update-attendance', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(55, 'delete-attendance', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(56, 'create-department', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(57, 'readAll-department', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(58, 'readSingle-department', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(59, 'update-department', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(60, 'delete-department', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(61, 'create-education', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(62, 'readAll-education', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(63, 'readSingle-education', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(64, 'update-education', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(65, 'delete-education', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(66, 'create-payroll', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(67, 'readAll-payroll', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(68, 'readSingle-payroll', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(69, 'update-payroll', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(70, 'delete-payroll', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(71, 'create-leaveApplication', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(72, 'readAll-leaveApplication', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(73, 'readSingle-leaveApplication', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(74, 'update-leaveApplication', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(75, 'delete-leaveApplication', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(76, 'create-shift', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(77, 'readAll-shift', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(78, 'readSingle-shift', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(79, 'update-shift', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(80, 'delete-shift', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(81, 'create-employmentStatus', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(82, 'readAll-employmentStatus', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(83, 'readSingle-employmentStatus', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(84, 'update-employmentStatus', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(85, 'delete-employmentStatus', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(86, 'create-announcement', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(87, 'readAll-announcement', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(88, 'readSingle-announcement', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(89, 'update-announcement', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(90, 'delete-announcement', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(91, 'create-salaryHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(92, 'readAll-salaryHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(93, 'readSingle-salaryHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(94, 'update-salaryHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(95, 'delete-salaryHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(96, 'create-designationHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(97, 'readAll-designationHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(98, 'readSingle-designationHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(99, 'update-designationHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(100, 'delete-designationHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(101, 'create-award', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(102, 'readAll-award', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(103, 'readSingle-award', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(104, 'update-award', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(105, 'delete-award', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(106, 'create-awardHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(107, 'readAll-awardHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(108, 'readSingle-awardHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(109, 'update-awardHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(110, 'delete-awardHistory', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(111, 'create-file', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(112, 'readAll-file', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(113, 'readSingle-file', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(114, 'update-file', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(115, 'delete-file', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(116, 'create-leavePolicy', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(117, 'readAll-leavePolicy', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(118, 'readSingle-leavePolicy', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(119, 'update-leavePolicy', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(120, 'delete-leavePolicy', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(121, 'create-weeklyHoliday', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(122, 'readAll-weeklyHoliday', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(123, 'readSingle-weeklyHoliday', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(124, 'update-weeklyHoliday', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(125, 'delete-weeklyHoliday', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(126, 'create-publicHoliday', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(127, 'readAll-publicHoliday', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(128, 'readSingle-publicHoliday', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(129, 'update-publicHoliday', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(130, 'delete-publicHoliday', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(131, 'create-project', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(132, 'readAll-project', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(133, 'readSingle-project', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(134, 'update-project', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(135, 'delete-project', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(136, 'create-milestone', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(137, 'readAll-milestone', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(138, 'readSingle-milestone', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(139, 'update-milestone', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(140, 'delete-milestone', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(141, 'create-task', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(142, 'readAll-task', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(143, 'readSingle-task', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(144, 'update-task', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(145, 'delete-task', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(146, 'create-projectTeam', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(147, 'readAll-projectTeam', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(148, 'readSingle-projectTeam', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(149, 'update-projectTeam', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(150, 'delete-projectTeam', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(151, 'create-taskDependency', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(152, 'readAll-taskDependency', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(153, 'readSingle-taskDependency', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(154, 'update-taskDependency', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(155, 'delete-taskDependency', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(156, 'create-taskStatus', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(157, 'readAll-taskStatus', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(158, 'readSingle-taskStatus', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(159, 'update-taskStatus', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(160, 'delete-taskStatus', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(161, 'create-taskTime', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(162, 'readAll-taskTime', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(163, 'readSingle-taskTime', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(164, 'update-taskTime', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(165, 'delete-taskTime', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(166, 'create-priority', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(167, 'readAll-priority', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(168, 'readSingle-priority', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(169, 'update-priority', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(170, 'delete-priority', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(171, 'create-assignedTask', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(172, 'readAll-assignedTask', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(173, 'readSingle-assignedTask', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(174, 'update-assignedTask', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(175, 'delete-assignedTask', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(176, 'create-emailConfig', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(177, 'readAll-emailConfig', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(178, 'readSingle-emailConfig', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(179, 'update-emailConfig', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(180, 'delete-emailConfig', '2023-11-19 08:50:59', '2023-11-19 08:50:59');

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

--
-- Table structure for table `priority`
--

CREATE TABLE `priority` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `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 `priority`
--

INSERT INTO `priority` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Low', 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(2, 'Medium', 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(3, 'High', 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59');

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

--
-- Table structure for table `project`
--

CREATE TABLE `project` (
  `id` bigint UNSIGNED NOT NULL,
  `projectManagerId` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `startDate` datetime NOT NULL,
  `endDate` datetime NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `projectTeam`
--

CREATE TABLE `projectTeam` (
  `id` bigint UNSIGNED NOT NULL,
  `projectTeamName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `projectId` bigint UNSIGNED NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `projectTeamMember`
--

CREATE TABLE `projectTeamMember` (
  `id` bigint UNSIGNED NOT NULL,
  `projectTeamId` bigint UNSIGNED NOT NULL,
  `userId` bigint UNSIGNED NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `publicHoliday`
--

CREATE TABLE `publicHoliday` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `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 `publicHoliday`
--

INSERT INTO `publicHoliday` (`id`, `name`, `date`, `status`, `created_at`, `updated_at`) VALUES
(1, 'New Year', '2023-11-19 00:00:00', 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(2, 'Independence Day', '2023-11-22 00:00:00', 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(3, 'Christmas', '2023-12-01 00:00:00', 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59');

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

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `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 `role`
--

INSERT INTO `role` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(2, 'employee', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(3, 'customer', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58');

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

--
-- Table structure for table `rolePermission`
--

CREATE TABLE `rolePermission` (
  `id` bigint UNSIGNED NOT NULL,
  `roleId` bigint UNSIGNED NOT NULL,
  `permissionId` bigint UNSIGNED 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 `rolePermission`
--

INSERT INTO `rolePermission` (`id`, `roleId`, `permissionId`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(2, 1, 2, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(3, 1, 3, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(4, 1, 4, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(5, 1, 5, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(6, 1, 6, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(7, 1, 7, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(8, 1, 8, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(9, 1, 9, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(10, 1, 10, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(11, 1, 11, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(12, 1, 12, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(13, 1, 13, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(14, 1, 14, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(15, 1, 15, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(16, 1, 16, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(17, 1, 17, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(18, 1, 18, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(19, 1, 19, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(20, 1, 20, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(21, 1, 21, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(22, 1, 22, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(23, 1, 23, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(24, 1, 24, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(25, 1, 25, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(26, 1, 26, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(27, 1, 27, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(28, 1, 28, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(29, 1, 29, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(30, 1, 30, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(31, 1, 31, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(32, 1, 32, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(33, 1, 33, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(34, 1, 34, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(35, 1, 35, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(36, 1, 36, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(37, 1, 37, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(38, 1, 38, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(39, 1, 39, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(40, 1, 40, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(41, 1, 41, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(42, 1, 42, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(43, 1, 43, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(44, 1, 44, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(45, 1, 45, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(46, 1, 46, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(47, 1, 47, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(48, 1, 48, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(49, 1, 49, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(50, 1, 50, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(51, 1, 51, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(52, 1, 52, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(53, 1, 53, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(54, 1, 54, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(55, 1, 55, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(56, 1, 56, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(57, 1, 57, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(58, 1, 58, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(59, 1, 59, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(60, 1, 60, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(61, 1, 61, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(62, 1, 62, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(63, 1, 63, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(64, 1, 64, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(65, 1, 65, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(66, 1, 66, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(67, 1, 67, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(68, 1, 68, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(69, 1, 69, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(70, 1, 70, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(71, 1, 71, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(72, 1, 72, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(73, 1, 73, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(74, 1, 74, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(75, 1, 75, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(76, 1, 76, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(77, 1, 77, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(78, 1, 78, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(79, 1, 79, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(80, 1, 80, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(81, 1, 81, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(82, 1, 82, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(83, 1, 83, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(84, 1, 84, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(85, 1, 85, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(86, 1, 86, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(87, 1, 87, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(88, 1, 88, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(89, 1, 89, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(90, 1, 90, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(91, 1, 91, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(92, 1, 92, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(93, 1, 93, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(94, 1, 94, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(95, 1, 95, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(96, 1, 96, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(97, 1, 97, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(98, 1, 98, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(99, 1, 99, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(100, 1, 100, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(101, 1, 101, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(102, 1, 102, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(103, 1, 103, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(104, 1, 104, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(105, 1, 105, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(106, 1, 106, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(107, 1, 107, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(108, 1, 108, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(109, 1, 109, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(110, 1, 110, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(111, 1, 111, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(112, 1, 112, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(113, 1, 113, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(114, 1, 114, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(115, 1, 115, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(116, 1, 116, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(117, 1, 117, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(118, 1, 118, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(119, 1, 119, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(120, 1, 120, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(121, 1, 121, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(122, 1, 122, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(123, 1, 123, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(124, 1, 124, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(125, 1, 125, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(126, 1, 126, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(127, 1, 127, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(128, 1, 128, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(129, 1, 129, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(130, 1, 130, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(131, 1, 131, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(132, 1, 132, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(133, 1, 133, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(134, 1, 134, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(135, 1, 135, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(136, 1, 136, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(137, 1, 137, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(138, 1, 138, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(139, 1, 139, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(140, 1, 140, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(141, 1, 141, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(142, 1, 142, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(143, 1, 143, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(144, 1, 144, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(145, 1, 145, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(146, 1, 146, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(147, 1, 147, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(148, 1, 148, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(149, 1, 149, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(150, 1, 150, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(151, 1, 151, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(152, 1, 152, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(153, 1, 153, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(154, 1, 154, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(155, 1, 155, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(156, 1, 156, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(157, 1, 157, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(158, 1, 158, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(159, 1, 159, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(160, 1, 160, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(161, 1, 161, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(162, 1, 162, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(163, 1, 163, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(164, 1, 164, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(165, 1, 165, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(166, 1, 166, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(167, 1, 167, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(168, 1, 168, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(169, 1, 169, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(170, 1, 170, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(171, 1, 171, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(172, 1, 172, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(173, 1, 173, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(174, 1, 174, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(175, 1, 175, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(176, 1, 176, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(177, 1, 177, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(178, 1, 178, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(179, 1, 179, '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(180, 1, 180, '2023-11-19 08:50:59', '2023-11-19 08:50:59');

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

--
-- Table structure for table `salaryHistory`
--

CREATE TABLE `salaryHistory` (
  `id` bigint UNSIGNED NOT NULL,
  `userId` bigint UNSIGNED NOT NULL,
  `salary` double(8,2) NOT NULL,
  `startDate` datetime NOT NULL,
  `endDate` datetime DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `shift`
--

CREATE TABLE `shift` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `startTime` datetime NOT NULL,
  `endTime` datetime NOT NULL,
  `workHour` double(8,2) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `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 `shift`
--

INSERT INTO `shift` (`id`, `name`, `startTime`, `endTime`, `workHour`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Morning', '2023-04-02 09:00:00', '2023-04-02 15:00:00', 8.00, 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(2, 'Afternoon', '2023-04-02 16:00:00', '2023-04-02 00:00:00', 8.00, 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(3, 'Night', '2023-04-02 00:00:00', '2023-04-02 08:00:00', 8.00, 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58');

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

--
-- Table structure for table `subAccount`
--

CREATE TABLE `subAccount` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `accountId` bigint UNSIGNED NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `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 `subAccount`
--

INSERT INTO `subAccount` (`id`, `name`, `accountId`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Cash', 1, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(2, 'Bank', 1, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(3, 'Inventory', 1, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(4, 'Accounts Receivable', 1, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(5, 'Accounts Payable', 2, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(6, 'Capital', 3, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(7, 'Withdrawal', 4, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(8, 'Sales', 5, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(9, 'Cost of Sales', 6, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(10, 'Salary', 6, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(11, 'Rent', 6, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(12, 'Utilities', 6, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(13, 'Discount Earned', 5, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59'),
(14, 'Discount Given', 6, 'true', '2023-11-19 08:50:59', '2023-11-19 08:50:59');

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

--
-- Table structure for table `task`
--

CREATE TABLE `task` (
  `id` bigint UNSIGNED NOT NULL,
  `projectId` bigint UNSIGNED NOT NULL,
  `milestoneId` bigint UNSIGNED NOT NULL,
  `priorityId` bigint UNSIGNED NOT NULL,
  `taskStatusId` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `startDate` datetime NOT NULL,
  `endDate` datetime NOT NULL,
  `completionTime` double(8,2) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `taskStatus`
--

CREATE TABLE `taskStatus` (
  `id` bigint UNSIGNED NOT NULL,
  `projectId` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` bigint UNSIGNED NOT NULL,
  `date` datetime NOT NULL,
  `debitId` bigint UNSIGNED NOT NULL,
  `creditId` bigint UNSIGNED NOT NULL,
  `particulars` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(8,2) NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relatedId` int DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `weeklyHoliday`
--

CREATE TABLE `weeklyHoliday` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `startDay` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `endDay` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `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 `weeklyHoliday`
--

INSERT INTO `weeklyHoliday` (`id`, `name`, `startDay`, `endDay`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Saturday-Thursday', 'Saturday', 'Thursday', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58'),
(2, 'Sunday-Friday', 'Sunday', 'Friday', 'true', '2023-11-19 08:50:58', '2023-11-19 08:50:58');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `assignedTask`
--
ALTER TABLE `assignedTask`
  ADD PRIMARY KEY (`id`),
  ADD KEY `assignedtask_taskid_foreign` (`taskId`),
  ADD KEY `assignedtask_userid_foreign` (`userId`);

--
-- Indexes for table `attendance`
--
ALTER TABLE `attendance`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attendance_userid_foreign` (`userId`);

--
-- Indexes for table `award`
--
ALTER TABLE `award`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `award_name_unique` (`name`);

--
-- Indexes for table `awardHistory`
--
ALTER TABLE `awardHistory`
  ADD PRIMARY KEY (`id`),
  ADD KEY `awardhistory_userid_foreign` (`userId`),
  ADD KEY `awardhistory_awardid_foreign` (`awardId`);

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

--
-- Indexes for table `designation`
--
ALTER TABLE `designation`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `designation_name_unique` (`name`);

--
-- Indexes for table `designationHistory`
--
ALTER TABLE `designationHistory`
  ADD PRIMARY KEY (`id`),
  ADD KEY `designationhistory_userid_foreign` (`userId`),
  ADD KEY `designationhistory_designationid_foreign` (`designationId`);

--
-- Indexes for table `education`
--
ALTER TABLE `education`
  ADD PRIMARY KEY (`id`),
  ADD KEY `education_userid_foreign` (`userId`);

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

--
-- Indexes for table `employmentStatus`
--
ALTER TABLE `employmentStatus`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `employmentstatus_name_unique` (`name`);

--
-- Indexes for table `leaveApplication`
--
ALTER TABLE `leaveApplication`
  ADD PRIMARY KEY (`id`),
  ADD KEY `leaveapplication_userid_foreign` (`userId`);

--
-- Indexes for table `leavePolicy`
--
ALTER TABLE `leavePolicy`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `leavepolicy_name_unique` (`name`);

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

--
-- Indexes for table `milestone`
--
ALTER TABLE `milestone`
  ADD PRIMARY KEY (`id`),
  ADD KEY `milestone_projectid_foreign` (`projectId`);

--
-- Indexes for table `payslip`
--
ALTER TABLE `payslip`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payslip_userid_foreign` (`userId`);

--
-- Indexes for table `permission`
--
ALTER TABLE `permission`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permission_name_unique` (`name`);

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

--
-- Indexes for table `project`
--
ALTER TABLE `project`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_projectmanagerid_foreign` (`projectManagerId`);

--
-- Indexes for table `projectTeam`
--
ALTER TABLE `projectTeam`
  ADD PRIMARY KEY (`id`),
  ADD KEY `projectteam_projectid_foreign` (`projectId`);

--
-- Indexes for table `projectTeamMember`
--
ALTER TABLE `projectTeamMember`
  ADD PRIMARY KEY (`id`),
  ADD KEY `projectteammember_projectteamid_foreign` (`projectTeamId`),
  ADD KEY `projectteammember_userid_foreign` (`userId`);

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

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

--
-- Indexes for table `rolePermission`
--
ALTER TABLE `rolePermission`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rolepermission_roleid_foreign` (`roleId`),
  ADD KEY `rolepermission_permissionid_foreign` (`permissionId`);

--
-- Indexes for table `salaryHistory`
--
ALTER TABLE `salaryHistory`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salaryhistory_userid_foreign` (`userId`);

--
-- Indexes for table `shift`
--
ALTER TABLE `shift`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `shift_name_unique` (`name`);

--
-- Indexes for table `subAccount`
--
ALTER TABLE `subAccount`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subaccount_accountid_foreign` (`accountId`);

--
-- Indexes for table `task`
--
ALTER TABLE `task`
  ADD PRIMARY KEY (`id`),
  ADD KEY `task_projectid_foreign` (`projectId`),
  ADD KEY `task_milestoneid_foreign` (`milestoneId`),
  ADD KEY `task_priorityid_foreign` (`priorityId`),
  ADD KEY `task_taskstatusid_foreign` (`taskStatusId`);

--
-- Indexes for table `taskStatus`
--
ALTER TABLE `taskStatus`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `taskstatus_projectid_name_unique` (`projectId`,`name`);

--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transaction_debitid_foreign` (`debitId`),
  ADD KEY `transaction_creditid_foreign` (`creditId`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `account`
--
ALTER TABLE `account`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `announcement`
--
ALTER TABLE `announcement`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `appSetting`
--
ALTER TABLE `appSetting`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `assignedTask`
--
ALTER TABLE `assignedTask`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `attendance`
--
ALTER TABLE `attendance`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `award`
--
ALTER TABLE `award`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `awardHistory`
--
ALTER TABLE `awardHistory`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `department`
--
ALTER TABLE `department`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `designation`
--
ALTER TABLE `designation`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `designationHistory`
--
ALTER TABLE `designationHistory`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `education`
--
ALTER TABLE `education`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email`
--
ALTER TABLE `email`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employmentStatus`
--
ALTER TABLE `employmentStatus`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `leaveApplication`
--
ALTER TABLE `leaveApplication`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `leavePolicy`
--
ALTER TABLE `leavePolicy`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `milestone`
--
ALTER TABLE `milestone`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payslip`
--
ALTER TABLE `payslip`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permission`
--
ALTER TABLE `permission`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=181;

--
-- AUTO_INCREMENT for table `priority`
--
ALTER TABLE `priority`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `project`
--
ALTER TABLE `project`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `projectTeam`
--
ALTER TABLE `projectTeam`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `projectTeamMember`
--
ALTER TABLE `projectTeamMember`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `publicHoliday`
--
ALTER TABLE `publicHoliday`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `role`
--
ALTER TABLE `role`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `rolePermission`
--
ALTER TABLE `rolePermission`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=181;

--
-- AUTO_INCREMENT for table `salaryHistory`
--
ALTER TABLE `salaryHistory`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `shift`
--
ALTER TABLE `shift`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `subAccount`
--
ALTER TABLE `subAccount`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `task`
--
ALTER TABLE `task`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `taskStatus`
--
ALTER TABLE `taskStatus`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `weeklyHoliday`
--
ALTER TABLE `weeklyHoliday`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `assignedTask`
--
ALTER TABLE `assignedTask`
  ADD CONSTRAINT `assignedtask_taskid_foreign` FOREIGN KEY (`taskId`) REFERENCES `task` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `assignedtask_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `attendance`
--
ALTER TABLE `attendance`
  ADD CONSTRAINT `attendance_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`);

--
-- Constraints for table `awardHistory`
--
ALTER TABLE `awardHistory`
  ADD CONSTRAINT `awardhistory_awardid_foreign` FOREIGN KEY (`awardId`) REFERENCES `award` (`id`),
  ADD CONSTRAINT `awardhistory_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`);

--
-- Constraints for table `designationHistory`
--
ALTER TABLE `designationHistory`
  ADD CONSTRAINT `designationhistory_designationid_foreign` FOREIGN KEY (`designationId`) REFERENCES `designation` (`id`),
  ADD CONSTRAINT `designationhistory_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`);

--
-- Constraints for table `education`
--
ALTER TABLE `education`
  ADD CONSTRAINT `education_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`);

--
-- Constraints for table `leaveApplication`
--
ALTER TABLE `leaveApplication`
  ADD CONSTRAINT `leaveapplication_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`);

--
-- Constraints for table `milestone`
--
ALTER TABLE `milestone`
  ADD CONSTRAINT `milestone_projectid_foreign` FOREIGN KEY (`projectId`) REFERENCES `project` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `payslip`
--
ALTER TABLE `payslip`
  ADD CONSTRAINT `payslip_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`);

--
-- Constraints for table `project`
--
ALTER TABLE `project`
  ADD CONSTRAINT `project_projectmanagerid_foreign` FOREIGN KEY (`projectManagerId`) REFERENCES `users` (`id`);

--
-- Constraints for table `projectTeam`
--
ALTER TABLE `projectTeam`
  ADD CONSTRAINT `projectteam_projectid_foreign` FOREIGN KEY (`projectId`) REFERENCES `project` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `projectTeamMember`
--
ALTER TABLE `projectTeamMember`
  ADD CONSTRAINT `projectteammember_projectteamid_foreign` FOREIGN KEY (`projectTeamId`) REFERENCES `projectTeam` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `projectteammember_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `rolePermission`
--
ALTER TABLE `rolePermission`
  ADD CONSTRAINT `rolepermission_permissionid_foreign` FOREIGN KEY (`permissionId`) REFERENCES `permission` (`id`),
  ADD CONSTRAINT `rolepermission_roleid_foreign` FOREIGN KEY (`roleId`) REFERENCES `role` (`id`);

--
-- Constraints for table `salaryHistory`
--
ALTER TABLE `salaryHistory`
  ADD CONSTRAINT `salaryhistory_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`);

--
-- Constraints for table `subAccount`
--
ALTER TABLE `subAccount`
  ADD CONSTRAINT `subaccount_accountid_foreign` FOREIGN KEY (`accountId`) REFERENCES `account` (`id`);

--
-- Constraints for table `task`
--
ALTER TABLE `task`
  ADD CONSTRAINT `task_milestoneid_foreign` FOREIGN KEY (`milestoneId`) REFERENCES `milestone` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `task_priorityid_foreign` FOREIGN KEY (`priorityId`) REFERENCES `priority` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `task_projectid_foreign` FOREIGN KEY (`projectId`) REFERENCES `project` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `task_taskstatusid_foreign` FOREIGN KEY (`taskStatusId`) REFERENCES `taskStatus` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `taskStatus`
--
ALTER TABLE `taskStatus`
  ADD CONSTRAINT `taskstatus_projectid_foreign` FOREIGN KEY (`projectId`) REFERENCES `project` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `transaction`
--
ALTER TABLE `transaction`
  ADD CONSTRAINT `transaction_creditid_foreign` FOREIGN KEY (`creditId`) REFERENCES `subAccount` (`id`),
  ADD CONSTRAINT `transaction_debitid_foreign` FOREIGN KEY (`debitId`) REFERENCES `subAccount` (`id`);
COMMIT;

