
# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: application_master_data
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `application_master_data` (
  `uuid` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `value` json DEFAULT NULL,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdBy` varchar(40) NOT NULL,
  `updatedBy` varchar(40) DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`uuid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: customer_survey_results
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `customer_survey_results` (
  `uuid` varchar(50) NOT NULL,
  `customerId` varchar(50) NOT NULL,
  `employeeId` varchar(50) NOT NULL,
  `surveyId` varchar(50) NOT NULL,
  `surveyResult` json DEFAULT NULL,
  `generalComment` text,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdBy` varchar(40) NOT NULL,
  PRIMARY KEY (`uuid`),
  KEY `employeeId` (`employeeId`),
  KEY `customerId` (`customerId`),
  KEY `surveyId` (`surveyId`),
  CONSTRAINT `customer_survey_results_ibfk_1` FOREIGN KEY (`employeeId`) REFERENCES `employees` (`uuid`) ON DELETE CASCADE,
  CONSTRAINT `customer_survey_results_ibfk_2` FOREIGN KEY (`customerId`) REFERENCES `customers` (`uuid`) ON DELETE CASCADE,
  CONSTRAINT `customer_survey_results_ibfk_3` FOREIGN KEY (`surveyId`) REFERENCES `survey_config` (`uuid`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: customers
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `customers` (
  `uuid` varchar(50) NOT NULL,
  `name` varchar(200) NOT NULL,
  `primaryContact` varchar(15) DEFAULT NULL,
  `secondaryContact` varchar(15) NOT NULL,
  `email` varchar(200) NOT NULL,
  `country` varchar(200) NOT NULL,
  `timezone` varchar(200) NOT NULL,
  `createdBy` varchar(40) NOT NULL,
  `status` enum('ACTIVE', 'INACTIVE') DEFAULT 'ACTIVE',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` varchar(40) NOT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`uuid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: employee_application_activities
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `employee_application_activities` (
  `uuid` varchar(50) NOT NULL,
  `employeeId` varchar(50) NOT NULL,
  `activityName` varchar(50) NOT NULL,
  `value` json NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`uuid`),
  KEY `employeeId` (`employeeId`),
  CONSTRAINT `employee_application_activities_ibfk_1` FOREIGN KEY (`employeeId`) REFERENCES `employees` (`uuid`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: employee_docs
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `employee_docs` (
  `uuid` varchar(50) NOT NULL,
  `employeeId` varchar(50) NOT NULL,
  `documentType` varchar(50) NOT NULL,
  `fileName` varchar(100) NOT NULL,
  `hrApprovalStatus` enum('REQUESTED', 'APPROVED', 'REJECTED') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'REQUESTED',
  `hrApproverId` varchar(50) DEFAULT NULL,
  `hrApprovalDate` date DEFAULT NULL,
  `hrApproverComments` text,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdBy` varchar(40) NOT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `updatedBy` varchar(40) NOT NULL,
  PRIMARY KEY (`uuid`),
  KEY `employeeId` (`employeeId`),
  CONSTRAINT `employee_docs_ibfk_1` FOREIGN KEY (`employeeId`) REFERENCES `employees` (`uuid`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: employee_leave_allocation
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `employee_leave_allocation` (
  `uuid` varchar(50) NOT NULL,
  `employeeId` varchar(50) NOT NULL,
  `year` varchar(4) NOT NULL,
  `leaveType` varchar(50) NOT NULL,
  `leavesApplied` decimal(4, 2) NOT NULL DEFAULT '0.00',
  `leavesAllocated` decimal(4, 2) NOT NULL,
  `leavesCarryForwarded` decimal(4, 2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`uuid`),
  KEY `employeeId` (`employeeId`),
  CONSTRAINT `employee_leave_allocation_ibfk_1` FOREIGN KEY (`employeeId`) REFERENCES `employees` (`uuid`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: employee_leaves
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `employee_leaves` (
  `uuid` varchar(50) NOT NULL,
  `requestNumber` int unsigned NOT NULL,
  `employeeId` varchar(50) NOT NULL,
  `leaveType` varchar(50) NOT NULL,
  `reason` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `leaveStartDate` date DEFAULT NULL,
  `leaveEndDate` date DEFAULT NULL,
  `leaveDays` decimal(4, 2) NOT NULL,
  `isHalfDay` tinyint NOT NULL DEFAULT '0',
  `requestedDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `leaveApprovers` json NOT NULL,
  `leaveApprovalStatus` enum('REQUESTED', 'PENDING', 'APPROVED', 'REJECTED') DEFAULT 'REQUESTED',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdBy` varchar(40) NOT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `updatedBy` varchar(40) NOT NULL,
  PRIMARY KEY (`uuid`),
  KEY `employeeId` (`employeeId`),
  CONSTRAINT `employee_leaves_ibfk_1` FOREIGN KEY (`employeeId`) REFERENCES `employees` (`uuid`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: employee_online_status
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `employee_online_status` (
  `uuid` varchar(50) NOT NULL,
  `employeeId` varchar(50) NOT NULL,
  `onlineStatus` enum('ONLINE', 'OFFLINE', 'AWAY') DEFAULT 'OFFLINE',
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`uuid`),
  UNIQUE KEY `unique_employee_id` (`employeeId`),
  CONSTRAINT `employee_online_status_ibfk_1` FOREIGN KEY (`employeeId`) REFERENCES `employees` (`uuid`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: employee_preferences
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `employee_preferences` (
  `uuid` varchar(50) NOT NULL,
  `employeeId` varchar(50) NOT NULL,
  `preference` varchar(50) NOT NULL,
  `value` varchar(50) NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdBy` varchar(40) NOT NULL,
  `updatedBy` varchar(40) DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`uuid`),
  KEY `employeeId` (`employeeId`),
  CONSTRAINT `employee_preferences_ibfk_1` FOREIGN KEY (`employeeId`) REFERENCES `employees` (`uuid`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: employee_survey_results
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `employee_survey_results` (
  `uuid` varchar(50) NOT NULL,
  `employeeId` varchar(50) NOT NULL,
  `surveyId` varchar(50) NOT NULL,
  `surveyResult` json DEFAULT NULL,
  `generalComment` text,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdBy` varchar(40) NOT NULL,
  PRIMARY KEY (`uuid`),
  KEY `employeeId` (`employeeId`),
  KEY `surveyId` (`surveyId`),
  CONSTRAINT `employee_survey_results_ibfk_1` FOREIGN KEY (`employeeId`) REFERENCES `employees` (`uuid`) ON DELETE CASCADE,
  CONSTRAINT `employee_survey_results_ibfk_2` FOREIGN KEY (`surveyId`) REFERENCES `survey_config` (`uuid`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: employee_timesheets
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `employee_timesheets` (
  `uuid` varchar(50) NOT NULL,
  `employeeId` varchar(50) NOT NULL,
  `requestNumber` int unsigned NOT NULL,
  `timesheetDate` date NOT NULL,
  `taskDetails` json NOT NULL,
  `totalHours` decimal(4, 2) NOT NULL,
  `approvalStatus` enum('REQUESTED', 'APPROVED', 'REJECTED') DEFAULT 'REQUESTED',
  `approverId` varchar(50) DEFAULT NULL,
  `approvalDate` date DEFAULT NULL,
  `approverComments` text,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdBy` varchar(40) NOT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `updatedBy` varchar(40) NOT NULL,
  PRIMARY KEY (`uuid`),
  KEY `employeeId` (`employeeId`),
  CONSTRAINT `employee_timesheets_ibfk_1` FOREIGN KEY (`employeeId`) REFERENCES `employees` (`uuid`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: employee_weekly_timesheets
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `employee_weekly_timesheets` (
  `uuid` varchar(50) NOT NULL,
  `employeeId` varchar(50) NOT NULL,
  `requestNumber` int unsigned NOT NULL,
  `weekStartDate` date NOT NULL,
  `weekEndDate` date NOT NULL,
  `taskDetails` json NOT NULL,
  `totalHours` decimal(5, 2) NOT NULL,
  `approvalStatus` enum('REQUESTED', 'APPROVED', 'REJECTED') DEFAULT NULL,
  `approverId` varchar(50) DEFAULT NULL,
  `approverRole` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `approvalDate` date DEFAULT NULL,
  `approverComments` text,
  `timeSheetStatus` enum('REQUESTED', 'APPROVED', 'REJECTED', 'SAVED') DEFAULT 'SAVED',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdBy` varchar(40) NOT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `updatedBy` varchar(40) NOT NULL,
  PRIMARY KEY (`uuid`),
  KEY `employeeId` (`employeeId`),
  CONSTRAINT `employee_weekly_timesheets_ibfk_1` FOREIGN KEY (`employeeId`) REFERENCES `employees` (`uuid`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: migrations
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `migrations` (
  `name` varchar(254) NOT NULL,
  UNIQUE KEY `name` (`name`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: migrations_lock
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `migrations_lock` (
  `is_locked` tinyint(1) NOT NULL,
  UNIQUE KEY `is_locked` (`is_locked`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: org_holidays
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `org_holidays` (
  `uuid` varchar(50) NOT NULL,
  `name` varchar(200) NOT NULL,
  `date` datetime NOT NULL,
  `year` int NOT NULL,
  `countryCode` varchar(3) NOT NULL,
  `createdBy` varchar(40) NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`uuid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: project_resource_allocation
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `project_resource_allocation` (
  `uuid` varchar(50) NOT NULL,
  `allocationCode` varchar(10) NOT NULL,
  `projectId` varchar(50) NOT NULL,
  `customerId` varchar(50) NOT NULL,
  `employeeId` varchar(50) NOT NULL,
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  `role` varchar(255) NOT NULL,
  `customerApprover` tinyint DEFAULT NULL,
  `status` enum('ACTIVE', 'INACTIVE') DEFAULT 'ACTIVE',
  `createdBy` varchar(40) NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` varchar(40) NOT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`uuid`),
  UNIQUE KEY `project_customer_employee` (`projectId`, `customerId`, `employeeId`),
  KEY `customerId` (`customerId`),
  KEY `employeeId` (`employeeId`),
  CONSTRAINT `project_resource_allocation_ibfk_1` FOREIGN KEY (`projectId`) REFERENCES `projects` (`uuid`) ON DELETE CASCADE,
  CONSTRAINT `project_resource_allocation_ibfk_2` FOREIGN KEY (`customerId`) REFERENCES `customers` (`uuid`) ON DELETE CASCADE,
  CONSTRAINT `project_resource_allocation_ibfk_3` FOREIGN KEY (`employeeId`) REFERENCES `employees` (`uuid`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: projects
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `projects` (
  `uuid` varchar(40) NOT NULL,
  `name` varchar(100) NOT NULL,
  `domain` varchar(200) DEFAULT NULL,
  `description` text NOT NULL,
  `location` varchar(255) NOT NULL,
  `status` enum('INITIATED', 'IN PROGRESS', 'COMPLETE', 'ON HOLD') DEFAULT 'INITIATED',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `startDate` datetime DEFAULT NULL,
  `endDate` datetime DEFAULT NULL,
  `createdBy` varchar(40) NOT NULL,
  `updatedBy` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `customerId` varchar(50) DEFAULT NULL,
  `priority` enum('NORMAL', 'HIGH', 'MEDIUM') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'NORMAL',
  `category` varchar(100) DEFAULT NULL,
  `labels` text,
  `projectCode` varchar(15) NOT NULL,
  PRIMARY KEY (`uuid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: survey_config
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `survey_config` (
  `uuid` varchar(50) NOT NULL,
  `surveyType` enum('EMPLOYEE', 'CUSTOMER') NOT NULL,
  `surveyTitle` varchar(50) NOT NULL,
  `startDate` date DEFAULT NULL,
  `endDate` date DEFAULT NULL,
  `formDetails` json DEFAULT NULL,
  `recipientEmails` json NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdBy` varchar(40) NOT NULL,
  `updatedBy` varchar(40) DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`uuid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: application_master_data
# ------------------------------------------------------------

INSERT INTO
  `application_master_data` (
    `uuid`,
    `name`,
    `value`,
    `createdAt`,
    `createdBy`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    'c699a0f5-b8e4-11ee-b607-52540145056b',
    'department',
    '[\"Engineering\", \"Marketing\", \"Human Resource\", \"House Keeping\", \"Finance\", \"Other\"]',
    '2024-01-22 05:12:01',
    'system',
    NULL,
    NULL
  );
INSERT INTO
  `application_master_data` (
    `uuid`,
    `name`,
    `value`,
    `createdAt`,
    `createdBy`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    'c699a2ba-b8e4-11ee-b607-52540145056b',
    'designation',
    '[\"Junior Engineer\", \"Software Engineer\", \"Senior Software Engineer\", \"Manager\", \"Senior Manager\", \"Designer\", \"Tester\", \"Consultant\", \"Senior Consultant\", \"Director\", \"Hr Executive\", \"PHP Developer-Laravel Specialist\", \"Technical Support\", \"Hardware Architect\", \"Operations Executive\", \"Other\"]',
    '2024-01-22 05:12:01',
    'system',
    NULL,
    NULL
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: customer_survey_results
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: customers
# ------------------------------------------------------------

INSERT INTO
  `customers` (
    `uuid`,
    `name`,
    `primaryContact`,
    `secondaryContact`,
    `email`,
    `country`,
    `timezone`,
    `createdBy`,
    `status`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '55600f25-28d3-4864-a30e-adac8ec5b43c',
    'Rajat Shetty Cust',
    '+91 454565454',
    '',
    'uday.worx@gmail.com',
    'Aland Islands',
    'Pacific/Niue',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    'ACTIVE',
    '2024-01-09 20:09:18',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    NULL
  );
INSERT INTO
  `customers` (
    `uuid`,
    `name`,
    `primaryContact`,
    `secondaryContact`,
    `email`,
    `country`,
    `timezone`,
    `createdBy`,
    `status`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '6d6ecf5e-327f-4ac5-b23e-b65dd06d610c',
    'Ronald John Mascarinas',
    '+91 7654543234',
    '',
    'ronald@gmail.com',
    'Japan',
    'Asia/Tokyo',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    'ACTIVE',
    '2023-12-27 07:20:27',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    NULL
  );
INSERT INTO
  `customers` (
    `uuid`,
    `name`,
    `primaryContact`,
    `secondaryContact`,
    `email`,
    `country`,
    `timezone`,
    `createdBy`,
    `status`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    'a7802234-2264-4a7b-a352-4461a895c680',
    'Soni Customer User',
    '+91 7877676579',
    '',
    'soni.user@gmail.com',
    'India',
    'Asia/Calcutta',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    'ACTIVE',
    '2024-01-13 12:54:05',
    'a7802234-2264-4a7b-a352-4461a895c680',
    '2024-01-14 21:04:20'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: employee_application_activities
# ------------------------------------------------------------

INSERT INTO
  `employee_application_activities` (
    `uuid`,
    `employeeId`,
    `activityName`,
    `value`,
    `createdAt`,
    `updatedAt`
  )
VALUES
  (
    '00c548ac-dda6-44d8-886e-5df85bf989cc',
    '72d86bc0-38c2-4128-b04a-55f0b6e6bd06',
    'ACCEPTED_PRIVACY',
    '{\"status\": true}',
    '2024-04-08 14:12:27',
    NULL
  );
INSERT INTO
  `employee_application_activities` (
    `uuid`,
    `employeeId`,
    `activityName`,
    `value`,
    `createdAt`,
    `updatedAt`
  )
VALUES
  (
    '9b82a63e-3dc7-4fb5-9d3b-acf965a9b9f8',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    'ACCEPTED_PRIVACY',
    '{\"status\": true}',
    '2024-01-08 17:19:28',
    NULL
  );
INSERT INTO
  `employee_application_activities` (
    `uuid`,
    `employeeId`,
    `activityName`,
    `value`,
    `createdAt`,
    `updatedAt`
  )
VALUES
  (
    'ce279f62-d3a6-4566-902e-b6baf0763e54',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    'ACCEPTED_PRIVACY',
    '{\"status\": true}',
    '2023-11-23 05:46:00',
    '2023-11-24 04:49:55'
  );
INSERT INTO
  `employee_application_activities` (
    `uuid`,
    `employeeId`,
    `activityName`,
    `value`,
    `createdAt`,
    `updatedAt`
  )
VALUES
  (
    'ea1a43ab-f8ef-4399-a073-2fde25a30bb2',
    '5aaa1492-4ae7-4874-86d1-fffcd959c8dc',
    'ACCEPTED_PRIVACY',
    '{\"status\": true}',
    '2024-01-24 06:12:39',
    '2024-01-24 06:13:42'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: employee_docs
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: employee_leave_allocation
# ------------------------------------------------------------

INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    '0d80ba9c-3ba7-4d57-9b1e-43c5ff7aaec0',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    '2024',
    'Sick Leave',
    2.00,
    8.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    '0f9b7380-3777-4e12-8e64-3619653d8c26',
    'a99eea5e-3f4d-4146-98db-80ac59e90bba',
    '2024',
    'Casual Leave_Privileged Leave',
    0.00,
    13.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    '1890a147-77dc-40ef-9ddd-5b6fb86db9e9',
    '9eb60f32-dade-46d7-a898-34c9809ecc92',
    '2024',
    'Sick Leave',
    0.00,
    8.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    '38f899b9-2457-4e1a-b5df-981eb9e8a1f8',
    '9eb60f32-dade-46d7-a898-34c9809ecc92',
    '2024',
    'Personal Emergency',
    0.00,
    2.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    '4a3d1412-1523-44e5-be59-18dbe65dc5de',
    '9eb60f32-dade-46d7-a898-34c9809ecc92',
    '2024',
    'Casual Leave_Privileged Leave',
    0.00,
    14.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    '5d592c49-1196-416c-80d3-8e0b6f88b32b',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    '2024',
    'Casual Leave_Privileged Leave',
    0.00,
    14.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    '7e106046-e9ab-441e-9638-ccf922c6b336',
    '5aaa1492-4ae7-4874-86d1-fffcd959c8dc',
    '2024',
    'Casual Leave_Privileged Leave',
    0.00,
    14.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    '8c95e8da-a5a4-44a1-84fc-eb1b2e6fb37d',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    '2024',
    'Personal Emergency',
    0.00,
    2.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    'a8685b9e-875b-4088-a108-bb66f9f34868',
    '5aaa1492-4ae7-4874-86d1-fffcd959c8dc',
    '2024',
    'Personal Emergency',
    0.00,
    2.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    'cbcf14bf-efe9-4ace-860b-ea5767af768a',
    '72d86bc0-38c2-4128-b04a-55f0b6e6bd06',
    '2024',
    'Casual Leave_Privileged Leave',
    0.00,
    14.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    'd42ca5cd-86db-4411-934c-228952a56da3',
    '72d86bc0-38c2-4128-b04a-55f0b6e6bd06',
    '2024',
    'Personal Emergency',
    0.00,
    2.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    'd4f9704a-261a-4ea5-ba6b-386d4ac46ad4',
    '5aaa1492-4ae7-4874-86d1-fffcd959c8dc',
    '2024',
    'Sick Leave',
    0.00,
    8.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    'de800e86-43e9-428e-b37e-9d5f3e314380',
    'a99eea5e-3f4d-4146-98db-80ac59e90bba',
    '2024',
    'Sick Leave',
    0.00,
    7.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    'e093aa7b-ee46-4cc2-b19a-f2942449db61',
    '72d86bc0-38c2-4128-b04a-55f0b6e6bd06',
    '2024',
    'Sick Leave',
    0.00,
    8.00,
    0.00
  );
INSERT INTO
  `employee_leave_allocation` (
    `uuid`,
    `employeeId`,
    `year`,
    `leaveType`,
    `leavesApplied`,
    `leavesAllocated`,
    `leavesCarryForwarded`
  )
VALUES
  (
    'f52a5721-f0f0-4d07-ba7e-474104a2e58e',
    'a99eea5e-3f4d-4146-98db-80ac59e90bba',
    '2024',
    'Personal Emergency',
    0.00,
    2.00,
    0.00
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: employee_leaves
# ------------------------------------------------------------

INSERT INTO
  `employee_leaves` (
    `uuid`,
    `requestNumber`,
    `employeeId`,
    `leaveType`,
    `reason`,
    `leaveStartDate`,
    `leaveEndDate`,
    `leaveDays`,
    `isHalfDay`,
    `requestedDate`,
    `leaveApprovers`,
    `leaveApprovalStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    '482a1bc7-63d8-47b7-b799-9299d044a64f',
    499533,
    'e389beba-6526-43aa-a591-0cbd5063b965',
    'Sick Leave',
    'Out sick',
    '2024-01-09',
    '2024-01-09',
    1.00,
    0,
    '2024-01-13 00:00:00',
    '[{\"approverId\": \"5bebf1b8-f149-62js-87h3-52540245096b\", \"approvalDate\": \"2024-01-23 19:41:31\", \"approverRole\": \"super_user\", \"approvalStatus\": \"APPROVED\", \"approverDetail\": \"Uday Dhadve <uday@embeds2.com>\", \"approverComments\": \"Approved\"}, {\"approverId\": \"5aaa1492-4ae7-4874-86d1-fffcd959c8dc\", \"approverRole\": null, \"approvalStatus\": \"REQUESTED\", \"approverDetail\": \"Chetan Bidap <cbidap@embedsquare.com>\"}, {\"approverId\": \"55600f25-28d3-4864-a30e-adac8ec5b43c\", \"approvalDate\": \"2024-01-13 13:08:23\", \"approverRole\": \"customer\", \"approvalStatus\": \"APPROVED\", \"approverDetail\": \"Customer\", \"approverComments\": \"Approve\"}]',
    'APPROVED',
    '2024-01-13 13:07:13',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    '2024-01-23 19:41:31',
    '5bebf1b8-f149-62js-87h3-52540245096b'
  );
INSERT INTO
  `employee_leaves` (
    `uuid`,
    `requestNumber`,
    `employeeId`,
    `leaveType`,
    `reason`,
    `leaveStartDate`,
    `leaveEndDate`,
    `leaveDays`,
    `isHalfDay`,
    `requestedDate`,
    `leaveApprovers`,
    `leaveApprovalStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'b376ee0b-4dbb-4fee-bf70-fc8cd4744890',
    783401,
    'e389beba-6526-43aa-a591-0cbd5063b965',
    'Sick Leave',
    'Sick',
    '2024-01-30',
    '2024-01-30',
    1.00,
    0,
    '2024-01-24 00:00:00',
    '[{\"approverId\": \"5bebf1b8-f149-62js-87h3-52540245096b\", \"approvalDate\": \"2024-01-24 06:22:13\", \"approverRole\": \"super_user\", \"approvalStatus\": \"APPROVED\", \"approverDetail\": \"Uday Dhadve <uday@embeds2.com>\", \"approverComments\": \"approving this leave\"}, {\"approverId\": \"5aaa1492-4ae7-4874-86d1-fffcd959c8dc\", \"approverRole\": \"super_user\", \"approvalStatus\": \"REQUESTED\", \"approverDetail\": \"Chetan Bidap <cbidap@embedsquare.com>\"}, {\"approverId\": \"55600f25-28d3-4864-a30e-adac8ec5b43c\", \"approverRole\": \"customer\", \"approvalStatus\": \"REQUESTED\", \"approverDetail\": \"Customer\"}]',
    'APPROVED',
    '2024-01-24 06:21:23',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    '2024-01-24 06:22:13',
    '5bebf1b8-f149-62js-87h3-52540245096b'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: employee_online_status
# ------------------------------------------------------------

INSERT INTO
  `employee_online_status` (`uuid`, `employeeId`, `onlineStatus`, `updatedAt`)
VALUES
  (
    '39077cf9-12b0-4eb3-bd23-e20ec0d31ace',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    'OFFLINE',
    '2024-05-28 04:24:48'
  );
INSERT INTO
  `employee_online_status` (`uuid`, `employeeId`, `onlineStatus`, `updatedAt`)
VALUES
  (
    '487486c3-ef73-4419-9edd-6e571039a4ad',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    'OFFLINE',
    '2024-04-05 09:59:48'
  );
INSERT INTO
  `employee_online_status` (`uuid`, `employeeId`, `onlineStatus`, `updatedAt`)
VALUES
  (
    'b198881e-14eb-4848-892a-7e19526ab9cb',
    '5aaa1492-4ae7-4874-86d1-fffcd959c8dc',
    'OFFLINE',
    '2024-02-12 14:25:54'
  );
INSERT INTO
  `employee_online_status` (`uuid`, `employeeId`, `onlineStatus`, `updatedAt`)
VALUES
  (
    'ea610f62-c2f5-4155-892f-36ae55e84bab',
    '72d86bc0-38c2-4128-b04a-55f0b6e6bd06',
    'OFFLINE',
    '2024-04-23 12:38:14'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: employee_preferences
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: employee_survey_results
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: employee_timesheets
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: employee_weekly_timesheets
# ------------------------------------------------------------

INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    '3b57cc7a-8910-4ef1-a560-739ff9378c98',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    548716,
    '2024-01-29',
    '2024-02-04',
    '[{\"task\": {\"uuid\": \"7ae120d9-9de3-45f3-9368-ebd37d868f64\", \"value\": \"s\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"e17184e7-9d87-4990-89e2-fd01a525e046\", \"value\": \"10:00\", \"isLocked\": false}, \"Fri-Feb-02\": {\"uuid\": \"7ba68012-ea65-42b7-acaf-60e3d4d8802e\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jan-29\": {\"uuid\": \"e7c066bf-ff49-4c66-a28e-d5d274606ffd\", \"value\": \"01:00\", \"isLocked\": true}, \"Sat-Feb-03\": {\"uuid\": \"0e2ddfbe-680b-4a36-96da-10553191d4e5\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Feb-04\": {\"uuid\": \"face0fdc-c3e4-4d25-81da-23790df19726\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Feb-01\": {\"uuid\": \"92d09874-4dbc-4c03-a927-c1b69b4fd609\", \"value\": \"04:00\", \"isLocked\": false}, \"Tue-Jan-30\": {\"uuid\": \"2d01891e-53e7-455e-8fa0-d1135bbd06b5\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jan-31\": {\"uuid\": \"b4e7752c-ecfd-4249-97d7-460d5841eec6\", \"value\": \"03:00\", \"isLocked\": true}}]',
    10.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-02-02 15:24:19',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    NULL,
    '5bebf1b8-f149-62js-87h3-52540245096b'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    '66eea4f0-51de-4961-9357-1a841ff5cb87',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    890604,
    '2024-01-15',
    '2024-01-21',
    '[{\"task\": {\"uuid\": \"abb580f0-fc60-4ddd-b6b0-5df7363f2669\", \"value\": \"Task 1\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"d7124bd1-3b8a-48fd-89e1-9b66890eb3a4\", \"value\": \"05:00\", \"isLocked\": false}, \"Fri-Jan-19\": {\"uuid\": \"c3a139ed-d9b5-4197-8640-eed40a50f1fc\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jan-15\": {\"uuid\": \"df038801-f180-4520-a877-a02129931612\", \"value\": \"05:00\", \"isLocked\": true}, \"Sat-Jan-20\": {\"uuid\": \"b28b849a-3319-4e16-a33f-509ef6e71925\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-21\": {\"uuid\": \"ba559985-d72d-4308-b526-5efbef8898e4\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-18\": {\"uuid\": \"63c959f7-2a6c-4295-a292-ce853efa6f19\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jan-16\": {\"uuid\": \"e122fdd3-a45f-4114-bba6-827b61baf7a0\", \"value\": \"00:00\", \"isLocked\": false}, \"Wed-Jan-17\": {\"uuid\": \"22d63100-88f3-4e20-bdd2-5963533e7ac8\", \"value\": \"00:00\", \"isLocked\": false}}, {\"task\": {\"uuid\": \"5653d3eb-c9d7-4b2c-a7db-847bfee75538\", \"value\": \"Task 2\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"0203cd51-b53a-4ede-a615-1160efc81c7e\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Jan-19\": {\"uuid\": \"78cf9ff0-f870-4c5b-9c84-edab45cad6ec\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jan-15\": {\"uuid\": \"e3ef1cdd-e92a-4d41-97d8-18d09c892ce2\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Jan-20\": {\"uuid\": \"09b305f6-daba-4440-b3d4-bad6ffb9e7a3\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-21\": {\"uuid\": \"a6c2a6e3-221c-483a-8f9e-df45cd50f0c6\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-18\": {\"uuid\": \"ddae1fe5-7d99-4249-bfe3-e13a8be98d53\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jan-16\": {\"uuid\": \"297e81cf-2580-49b2-9983-83c6e9e6146d\", \"value\": \"00:00\", \"isLocked\": false}, \"Wed-Jan-17\": {\"uuid\": \"e8f79b52-74d1-4401-9040-e1cc1d24c3cc\", \"value\": \"00:00\", \"isLocked\": false}}, {\"task\": {\"uuid\": \"c5982a5b-e05a-46c2-9610-7f75c319aa5e\", \"value\": \"Task 3\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"8889f285-1da9-4da8-bc43-a2d60f8e8885\", \"value\": \"03:00\", \"isLocked\": false}, \"Fri-Jan-19\": {\"uuid\": \"bd5f2db3-2fb2-4c2a-ae4b-e609b41fa69f\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jan-15\": {\"uuid\": \"d103005d-7cdc-45a3-ac50-85ca80386449\", \"value\": \"03:00\", \"isLocked\": true}, \"Sat-Jan-20\": {\"uuid\": \"04c6c086-5224-411d-969b-666768817a6b\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-21\": {\"uuid\": \"7f73ba81-d75e-4501-819f-d5a56a0c0ac6\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-18\": {\"uuid\": \"1a1ad7f9-c93a-4184-902a-c239bcb7d473\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jan-16\": {\"uuid\": \"38ad6be0-6bc1-4639-81ea-9be6ebb0dd66\", \"value\": \"00:00\", \"isLocked\": false}, \"Wed-Jan-17\": {\"uuid\": \"2f110da5-f324-4e5f-baea-e29e5d6a3f02\", \"value\": \"00:00\", \"isLocked\": false}}]',
    10.00,
    'APPROVED',
    '55600f25-28d3-4864-a30e-adac8ec5b43c',
    'customer',
    '2024-01-15',
    'Approved by me as customer',
    'APPROVED',
    '2024-01-15 05:17:17',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    '2024-01-15 00:00:00',
    '55600f25-28d3-4864-a30e-adac8ec5b43c'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    '713591eb-7bf4-4944-9148-c27dcb4cc529',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    706052,
    '2023-12-11',
    '2023-12-17',
    '[{\"task\": {\"uuid\": \"426f0636-d3ef-4cff-b0d5-42ac5a5eef11\", \"value\": \"I worked on one major bug in this week\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"7d4e6f34-46a4-40d1-b6a4-8c56d898f5e3\", \"value\": \"05:00\", \"isLocked\": false}, \"Fri-Dec-15\": {\"uuid\": \"a83e7a2c-2c6a-4c4b-9b62-9e7f1b930f50\", \"value\": \"01:00\", \"isLocked\": false}, \"Mon-Dec-11\": {\"uuid\": \"f66e0f0d-d344-4d96-b9e8-dc9396284971\", \"value\": \"01:00\", \"isLocked\": false}, \"Sat-Dec-16\": {\"uuid\": \"75f986d2-0f12-4b6b-b0e6-7eaa0d6dfe4f\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-17\": {\"uuid\": \"bfb510bf-e045-4db7-b4ac-06a9244f1888\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-14\": {\"uuid\": \"e2cb3e66-f845-4b3c-8d69-e0e08872652a\", \"value\": \"01:00\", \"isLocked\": false}, \"Tue-Dec-12\": {\"uuid\": \"16d10018-89e2-4e2a-86b0-3a6eebe80115\", \"value\": \"01:00\", \"isLocked\": false}, \"Wed-Dec-13\": {\"uuid\": \"58a8ac7c-3baf-4e62-bf87-5e18855c55a2\", \"value\": \"01:00\", \"isLocked\": false}}]',
    5.00,
    'REQUESTED',
    NULL,
    '',
    NULL,
    NULL,
    'REQUESTED',
    '2023-12-14 09:11:28',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2023-12-14 00:00:00',
    '5bebf1b8-f149-62js-87h3-52540245096b'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'a4da1d20-de17-405a-a28b-a44c6ce1fcdc',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    734656,
    '2023-11-27',
    '2023-12-03',
    '[{\"task\": {\"uuid\": \"b489f75e-67b4-4645-8bf8-3eb41650f191\", \"value\": \"Development\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"1a56a2a9-20ac-48c9-912e-8e660b5aeb45\", \"value\": \"15:00\", \"isLocked\": false}, \"Fri-Dec-01\": {\"uuid\": \"0a7aae0b-141f-4f80-97ab-5c4d84e34fc1\", \"value\": \"01:00\", \"isLocked\": false}, \"Mon-Nov-27\": {\"uuid\": \"dd9f40c3-7d74-41ec-8d86-56db2fc7a8d8\", \"value\": \"00:00\", \"isLocked\": false}, \"Sat-Dec-02\": {\"uuid\": \"2833cf4a-6030-4fe9-89eb-6d5bb1f8fb61\", \"value\": \"01:00\", \"isLocked\": false}, \"Sun-Dec-03\": {\"uuid\": \"c16a81e3-dcec-43cd-a8a8-5a27e19c977e\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Nov-30\": {\"uuid\": \"38a8a1a4-b244-45ac-8a8a-dfb5f1d7723b\", \"value\": \"01:00\", \"isLocked\": false}, \"Tue-Nov-28\": {\"uuid\": \"9947617e-0df7-4010-8a8c-37609a8d4093\", \"value\": \"11:00\", \"isLocked\": false}, \"Wed-Nov-29\": {\"uuid\": \"e2b4316c-bb7d-4a18-80e4-19d8e2ea9206\", \"value\": \"01:00\", \"isLocked\": false}}, {\"task\": {\"uuid\": \"c0c778c3-c3cd-4ff9-825b-12d45ab09106\", \"value\": \"Break\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"b6d3009a-96f1-4bfa-b92e-9993a9a38e07\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-Dec-01\": {\"uuid\": \"2eb7f4c0-8c7b-4d49-a9c0-c6e5e3849c95\", \"value\": \"01:00\", \"isLocked\": false}, \"Mon-Nov-27\": {\"uuid\": \"925666e2-8f6f-439e-9dd3-0a439eab3f8a\", \"value\": \"00:00\", \"isLocked\": false}, \"Sat-Dec-02\": {\"uuid\": \"fd57ec2e-4a37-4f05-b2d9-465e8b9503c5\", \"value\": \"01:00\", \"isLocked\": false}, \"Sun-Dec-03\": {\"uuid\": \"703e3f6f-5f0d-4471-bc7b-290fdcf9bb1e\", \"value\": \"01:00\", \"isLocked\": false}, \"Thu-Nov-30\": {\"uuid\": \"3cb88f5e-e793-4e15-aa32-71a66c5be5e8\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Nov-28\": {\"uuid\": \"c0ce4950-b9ae-42cb-9b1c-71e79b076e26\", \"value\": \"01:00\", \"isLocked\": false}, \"Wed-Nov-29\": {\"uuid\": \"dd44f571-1f12-4efb-89db-8228ee2ed70b\", \"value\": \"00:00\", \"isLocked\": false}}]',
    19.00,
    'REQUESTED',
    NULL,
    '',
    NULL,
    NULL,
    'REQUESTED',
    '2023-11-29 05:45:50',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2023-11-29 00:00:00',
    '5bebf1b8-f149-62js-87h3-52540245096b'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'a97a1317-53e5-49c5-a4d0-fd48cadd4395',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    905838,
    '2024-01-01',
    '2024-01-07',
    '[{\"task\": {\"uuid\": \"f56fc461-2b5a-42e1-a362-4b08f1a62f49\", \"value\": \"Task 2\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"5d9d646d-915e-4d9b-b8a3-3944fb22f556\", \"value\": \"21:00\", \"isLocked\": false}, \"Fri-Jan-05\": {\"uuid\": \"3a994f86-334f-4f46-9b77-6cbb010a6773\", \"value\": \"04:00\", \"isLocked\": true}, \"Mon-Jan-01\": {\"uuid\": \"73885842-d6d9-4be5-8a7b-d5f26767a850\", \"value\": \"05:00\", \"isLocked\": true}, \"Sat-Jan-06\": {\"uuid\": \"e0720f06-925f-465b-8441-82f3a14d8fc2\", \"value\": \"04:00\", \"isLocked\": true}, \"Sun-Jan-07\": {\"uuid\": \"948df41f-9c8a-4e4a-9bc3-3e22d5c084ab\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jan-04\": {\"uuid\": \"4c097f37-2e50-4bf3-a71d-13bb2e0a0539\", \"value\": \"04:00\", \"isLocked\": true}, \"Tue-Jan-02\": {\"uuid\": \"1b481f04-5a06-4a91-98dd-6a5db6a4ea6c\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jan-03\": {\"uuid\": \"942ea5eb-2b99-4375-a1f7-4bf1c33ec7db\", \"value\": \"04:00\", \"isLocked\": true}}]',
    21.00,
    'REQUESTED',
    NULL,
    '',
    NULL,
    NULL,
    'REQUESTED',
    '2024-01-09 04:18:58',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    '2024-01-17 00:00:00',
    'e389beba-6526-43aa-a591-0cbd5063b965'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'be469eeb-9ca1-4214-bdb8-2009cbbd5569',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    940909,
    '2024-02-05',
    '2024-02-11',
    '[{\"task\": {\"uuid\": \"8917593d-4b33-4a86-ba1d-3a1f76277617\", \"value\": \"Task12\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"733260ea-1d0c-4608-8c20-95cab9517503\", \"value\": \"11:50\", \"isLocked\": false}, \"Fri-Feb-09\": {\"uuid\": \"a8380fe6-d27f-41a2-9152-4e40af6b5e76\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Feb-05\": {\"uuid\": \"8fbb8560-bc7b-4258-80b5-cce483009e11\", \"value\": \"02:50\", \"isLocked\": true}, \"Sat-Feb-10\": {\"uuid\": \"410de757-4076-4efd-8dff-2f2d3d2bd635\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Feb-11\": {\"uuid\": \"b9d854d9-6ef1-4d34-a7f4-70dd4f95401d\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Feb-08\": {\"uuid\": \"cd3ac7e8-7229-4610-ba76-5b23a1fa50dd\", \"value\": \"05:00\", \"isLocked\": false}, \"Tue-Feb-06\": {\"uuid\": \"ebd89dfc-4805-4a2d-bb9d-43911981dc8d\", \"value\": \"03:00\", \"isLocked\": true}, \"Wed-Feb-07\": {\"uuid\": \"7eafadea-03ef-4bde-bc8b-6e76104db3f2\", \"value\": \"01:00\", \"isLocked\": true}}]',
    11.50,
    'REQUESTED',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    'super_user',
    '2024-02-09',
    're',
    'REQUESTED',
    '2024-02-08 04:38:12',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    '2024-02-09 00:00:00',
    '5bebf1b8-f149-62js-87h3-52540245096b'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'e8838eb9-b199-4ba7-985e-d79619da14fd',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    603810,
    '2024-01-08',
    '2024-01-14',
    '[{\"task\": {\"uuid\": \"7e85b831-4c6f-4c23-a44f-44d2cda6066a\", \"value\": \"Task 1\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"4c707ff6-46f9-4b56-909c-c1c0f458ebf2\", \"value\": \"20:00\", \"isLocked\": false}, \"Fri-Jan-12\": {\"uuid\": \"35f9ce5c-dad5-4b8f-9d9c-2e19f9a74dd1\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jan-08\": {\"uuid\": \"24bb2f17-1e48-4d3c-80f8-5f99e71eb367\", \"value\": \"04:00\", \"isLocked\": true}, \"Sat-Jan-13\": {\"uuid\": \"23484d72-7793-45e2-a52a-4b7de5f6a018\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jan-14\": {\"uuid\": \"c1a451da-1f6a-4f96-b3d9-1735e8482ae1\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jan-11\": {\"uuid\": \"2ef5d98f-b85c-4dbb-a53a-37df12249f68\", \"value\": \"07:00\", \"isLocked\": true}, \"Tue-Jan-09\": {\"uuid\": \"5fda196f-e3a5-4f1a-a42e-d3f62e200842\", \"value\": \"03:00\", \"isLocked\": true}, \"Wed-Jan-10\": {\"uuid\": \"d37c6ac3-3f4a-446c-b896-77c0579430f8\", \"value\": \"06:00\", \"isLocked\": true}}]',
    20.00,
    'REQUESTED',
    NULL,
    '',
    NULL,
    NULL,
    'REQUESTED',
    '2024-01-09 04:16:45',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    '2024-01-17 00:00:00',
    'e389beba-6526-43aa-a591-0cbd5063b965'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'ec57fa76-a06d-4f84-bc6c-60ece66ef1b3',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    361050,
    '2024-01-08',
    '2024-01-14',
    '[{\"task\": {\"uuid\": \"9e9ce2bb-e18a-4a72-b622-07958f1659f3\", \"value\": \"Task 12222\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"40f5ff11-c57d-4bc0-a080-8b6e6db558b4\", \"value\": \"03:00\", \"isLocked\": false}, \"Fri-Jan-12\": {\"uuid\": \"d9a66dce-82b9-4306-87b1-cf8d6e50bc43\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jan-08\": {\"uuid\": \"d15668d5-6c4a-4874-9265-48815c1646b7\", \"value\": \"03:00\", \"isLocked\": true}, \"Sat-Jan-13\": {\"uuid\": \"68ef5f27-18f8-45f0-948d-8c55b8d5c8c5\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jan-14\": {\"uuid\": \"bb7f1a5b-7c6d-4c0c-a09a-01d21b902dcb\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jan-11\": {\"uuid\": \"68e48ec4-5e0e-4c2f-bf70-284eaed2274d\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jan-09\": {\"uuid\": \"2e74ec9e-c49b-467a-939a-93776a1d0343\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jan-10\": {\"uuid\": \"96f87b62-ced0-4934-af9b-5d1178da7f41\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"cfcbcefa-7e6d-40bb-8eaa-3b2f05cfa3a9\", \"value\": \"Task2\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"4c035d0e-4c44-4a8a-927e-1e30e59f04f3\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-Jan-12\": {\"uuid\": \"f4a0a4e3-6a45-4eab-a365-1499eab103e5\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jan-08\": {\"uuid\": \"9364fe23-9c1e-47b8-8e3c-21c59d64a6c9\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jan-13\": {\"uuid\": \"b62f780e-02c2-4f82-823a-66d9d6bb3f89\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jan-14\": {\"uuid\": \"013fb20f-e41d-48c2-a48b-43f2ed6cb00d\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jan-11\": {\"uuid\": \"654136d5-432f-45bf-8ba1-1d5866a007e6\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jan-09\": {\"uuid\": \"f5705a56-581f-4c7a-9c9c-bbfc8a9e72cf\", \"value\": \"04:00\", \"isLocked\": true}, \"Wed-Jan-10\": {\"uuid\": \"4b9f553c-7514-4325-99bf-0753077ce62f\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"61e0657a-0889-4ef6-9afe-8e26eee2b1fc\", \"value\": \"Task 123\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"54f7cf85-cbed-4277-a13c-3edbb4723345\", \"value\": \"20:00\", \"isLocked\": false}, \"Fri-Jan-12\": {\"uuid\": \"95416261-a97a-4bc8-bef4-133872271056\", \"value\": \"04:00\", \"isLocked\": true}, \"Mon-Jan-08\": {\"uuid\": \"386cbabd-23d0-4844-b236-e37ef2d85d42\", \"value\": \"04:00\", \"isLocked\": true}, \"Sat-Jan-13\": {\"uuid\": \"296b636a-5340-4d10-8162-5fb17eefbf77\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jan-14\": {\"uuid\": \"45bafe03-6cb0-40e5-9d8d-cd11205fb07a\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jan-11\": {\"uuid\": \"08653397-1e51-4ee9-807b-9e9250cf2b15\", \"value\": \"04:00\", \"isLocked\": true}, \"Tue-Jan-09\": {\"uuid\": \"79d1a267-16ae-4bb7-8817-d5d6c47fc3da\", \"value\": \"04:00\", \"isLocked\": true}, \"Wed-Jan-10\": {\"uuid\": \"41e85cc7-22b0-49b4-9607-3993756c11b7\", \"value\": \"04:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"82b21002-4e8a-4c75-92e1-96aeaad0ee70\", \"value\": \"Tasj999\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"f139c66c-a6e8-48e4-ae67-87c2c0529b77\", \"value\": \"06:00\", \"isLocked\": false}, \"Fri-Jan-12\": {\"uuid\": \"0488ed6a-1992-4a8d-94d7-0f7281055110\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jan-08\": {\"uuid\": \"de73ea07-01b6-41cf-9605-3bc1add8ae1e\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Jan-13\": {\"uuid\": \"67e87250-7fbf-4425-b12f-8fbbbf25d933\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jan-14\": {\"uuid\": \"4f6c903d-4dff-458a-9f5c-8a2e0a2ff4f1\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jan-11\": {\"uuid\": \"d23082f3-fe0f-4652-8609-575254da3eb5\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jan-09\": {\"uuid\": \"33416b1a-db91-4634-a8d5-9793ea14953f\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jan-10\": {\"uuid\": \"ca36229d-f29e-44e7-be9a-583d46b88d17\", \"value\": \"02:00\", \"isLocked\": true}}]',
    33.00,
    'REQUESTED',
    NULL,
    '',
    NULL,
    NULL,
    'REQUESTED',
    '2024-01-13 12:45:57',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-03-19 00:00:00',
    '5bebf1b8-f149-62js-87h3-52540245096b'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: migrations
# ------------------------------------------------------------

INSERT INTO
  `migrations` (`name`)
VALUES
  ('00001-create-employees-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00002-create-user-tables.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00003-insert-initial-employee.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00004-insert-initial-user.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00005-create-leave-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00006-create-employee-documents.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00007-create-employee-timesheet.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00008-create-employee-leave-allocation.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00009-create-employee-activity-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00010-create-weekly-timesheet-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00011-create-employee-online-status.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00012-create-user-password-reset-request-.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00013-schedule-event-reset-req-expire.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00014-create-holiday-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00015-create-customer-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00016-create-project-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00017-insert-initial-project.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  (
    '00018-create-customer-resource-allocation-table.js'
  );
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00019-create-customer-access-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00020-create-employee-preference-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00021-create-master-data.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00022-insert-initial-fields.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00023-create-survey-config-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00024-create-survey-results-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00025-create-customer-survey-results.js');

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: migrations_lock
# ------------------------------------------------------------

INSERT INTO
  `migrations_lock` (`is_locked`)
VALUES
  (0);

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: org_holidays
# ------------------------------------------------------------

INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '1d710832-f1ef-48fb-a2a9-9810fbc08626',
    'abc',
    '2022-12-27 00:00:00',
    2024,
    'IN',
    '6b9e3f92-3f8b-4af0-912b-751ee8f8bd9c',
    '2023-12-23 08:57:15'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '292d63fb-4cd5-4c1f-8d7e-f970b1951859',
    'New Year Day',
    '2024-01-01 00:00:00',
    2024,
    'IN',
    '6b9e3f92-3f8b-4af0-912b-751ee8f8bd9c',
    '2023-12-23 08:57:15'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: project_resource_allocation
# ------------------------------------------------------------

INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '0922b484-e815-4eed-a5d0-65efdb0517ca',
    'ATXIVPZ',
    'X101',
    '55600f25-28d3-4864-a30e-adac8ec5b43c',
    'e389beba-6526-43aa-a591-0cbd5063b965',
    '2024-01-10',
    '2024-03-27',
    'PHP Developer-Laravel Specialist',
    1,
    'ACTIVE',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-13 13:02:39',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-13 13:02:39'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: projects
# ------------------------------------------------------------

INSERT INTO
  `projects` (
    `uuid`,
    `name`,
    `domain`,
    `description`,
    `location`,
    `status`,
    `createdAt`,
    `startDate`,
    `endDate`,
    `createdBy`,
    `updatedBy`,
    `updatedAt`,
    `customerId`,
    `priority`,
    `category`,
    `labels`,
    `projectCode`
  )
VALUES
  (
    '1018ccba-d0f9-4a47-a444-0c34a013cf02',
    'Commercial building project nanded city',
    'LifeStyle',
    'This is test project created to showcase the creation module. Please ignore this details, for any processing further.',
    'Pune, India ',
    'IN PROGRESS',
    '2024-02-10 21:10:56',
    '2024-02-14 00:00:00',
    '2024-04-30 00:00:00',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    NULL,
    NULL,
    NULL,
    'HIGH',
    'Residential',
    NULL,
    'FJDOZF'
  );
INSERT INTO
  `projects` (
    `uuid`,
    `name`,
    `domain`,
    `description`,
    `location`,
    `status`,
    `createdAt`,
    `startDate`,
    `endDate`,
    `createdBy`,
    `updatedBy`,
    `updatedAt`,
    `customerId`,
    `priority`,
    `category`,
    `labels`,
    `projectCode`
  )
VALUES
  (
    'X101',
    'Default System Project',
    'Default Domain',
    'This is a system-generated project for initial setup.',
    'Default Location',
    'INITIATED',
    '2023-12-27 06:08:15',
    NULL,
    NULL,
    'system_user_id',
    'system_user_id',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    ''
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: survey_config
# ------------------------------------------------------------

INSERT INTO
  `survey_config` (
    `uuid`,
    `surveyType`,
    `surveyTitle`,
    `startDate`,
    `endDate`,
    `formDetails`,
    `recipientEmails`,
    `createdAt`,
    `createdBy`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '03c584a3-877b-4188-b89e-e54566a853b0',
    'CUSTOMER',
    'Customer survey form clone',
    '2024-04-21',
    '2024-04-27',
    '[{\"uuid\": \"5d07dee0-0566-4271-ad44-67c28cce4dd5\", \"question\": \"This is a test form\", \"inputType\": \"comment\"}]',
    '[\"Joe De Employee <uday8486@gmail.com>\", \"Rajat Shetty Cust <uday.worx@gmail.com>\"]',
    '2024-04-20 19:17:13',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    NULL,
    NULL
  );
INSERT INTO
  `survey_config` (
    `uuid`,
    `surveyType`,
    `surveyTitle`,
    `startDate`,
    `endDate`,
    `formDetails`,
    `recipientEmails`,
    `createdAt`,
    `createdBy`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '25143d4e-6866-45d4-acbc-5519e6ccc30f',
    'CUSTOMER',
    'Customer survey form',
    '2024-04-21',
    '2024-04-27',
    '[{\"uuid\": \"0b599b1c-66c8-4a46-9c1a-d955e99f5960\", \"question\": \"This is a test form\", \"inputType\": \"comment\"}]',
    '[\"Joe De Employee <uday8486@gmail.com>\"]',
    '2024-04-20 06:17:08',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    NULL,
    NULL
  );
INSERT INTO
  `survey_config` (
    `uuid`,
    `surveyType`,
    `surveyTitle`,
    `startDate`,
    `endDate`,
    `formDetails`,
    `recipientEmails`,
    `createdAt`,
    `createdBy`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '55e810e5-5345-49c6-a3eb-3efb31dbf963',
    'EMPLOYEE',
    'Employee Engagement survey 2024',
    '2024-04-07',
    '2024-04-13',
    '[{\"uuid\": \"5ea8c73a-c094-49c9-bec7-e923f048c686\", \"question\": \"What is your feeling about the org?\", \"inputType\": \"comment\"}]',
    '[\"Soni Emp User <soni.hr@embeds2.com>\"]',
    '2024-04-07 09:38:48',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-04-07 09:39:14'
  );
INSERT INTO
  `survey_config` (
    `uuid`,
    `surveyType`,
    `surveyTitle`,
    `startDate`,
    `endDate`,
    `formDetails`,
    `recipientEmails`,
    `createdAt`,
    `createdBy`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '6ad7e50e-b6a0-459d-bde0-29d245ad1d72',
    'EMPLOYEE',
    'Employee Engagement survey 2024',
    '2024-04-07',
    '2024-04-13',
    '[{\"uuid\": \"1f0c0ea9-70f0-4c9a-8967-1522967eea39\", \"question\": \"What is your feeling about the org?\", \"inputType\": \"comment\"}]',
    '[\"Soni Emp User <soni.hr@embeds2.com>\"]',
    '2024-04-23 12:41:34',
    '72d86bc0-38c2-4128-b04a-55f0b6e6bd06',
    NULL,
    NULL
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: user_password_reset_request
# ------------------------------------------------------------


