--
-- Host: localhost    Database: TAFDB
-- ------------------------------------------------------


--
-- Table structure for table `GL_Journal_Entries`
--

CREATE TABLE `GL_Journal_Entries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reference` varchar(100) DEFAULT NULL,
  `memo` text DEFAULT NULL,
  `timestamp` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `GL_Journal_Entries`
--

INSERT INTO `GL_Journal_Entries` VALUES
(1,'INV-1001','Initial capital','2025-05-01 09:00:00',1,1,0,'2025-06-02 20:55:41'),
(2,'JE001','Opening balance','2025-06-02 20:55:41',1,1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `account_ai_feedback`
--

CREATE TABLE `account_ai_feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) DEFAULT NULL,
  `suggested_code` varchar(50) DEFAULT NULL,
  `chosen_code` varchar(50) DEFAULT NULL,
  `rationale` text DEFAULT NULL,
  `accepted` tinyint(1) DEFAULT 0,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `account_ai_feedback`
--


--
-- Table structure for table `ap_transactions`
--

CREATE TABLE `ap_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gl_transaction_id` int(11) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ap_transactions`
--

INSERT INTO `ap_transactions` VALUES
(1,2,0,'2025-06-02 20:55:41');

--
-- Table structure for table `appeals`
--

CREATE TABLE `appeals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `case_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `reason` text DEFAULT NULL,
  `status` enum('submitted','review','resolved') DEFAULT 'submitted',
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `appeals`
--

INSERT INTO `appeals` VALUES
(1,1,2,'Disputes severity','submitted',0,'2025-06-02 20:55:41');

--
-- Table structure for table `application_documents`
--

CREATE TABLE `application_documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `application_id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_type` varchar(50) NOT NULL,
  `file_path` text NOT NULL,
  `uploaded_by` int(11) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `application_documents`
--

INSERT INTO `application_documents` VALUES
(1,1,'resume.pdf','resume','/docs/applications/resume1.pdf',1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `application_shortlists`
--

CREATE TABLE `application_shortlists` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_id` int(11) NOT NULL,
  `general_comment` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `application_shortlists`
--


--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_id` int(11) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `position_applied` varchar(255) NOT NULL,
  `application_date` date NOT NULL,
  `status` enum('New','Under Review','Interviewing','Rejected','Hired') NOT NULL,
  `shortlisted` tinyint(1) DEFAULT 0,
  `source` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `pendingSync` tinyint(1) DEFAULT 0,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `applications`
--

INSERT INTO `applications` VALUES
(1,1,'George','Miller','george.miller@example.com','+1-555-1000','10 Market St','1990-04-12','Software Engineer','2025-05-20','Under Review',0,'Website',NULL,1,0,0,'2025-06-02 20:55:41');

--
-- Table structure for table `ar_transactions`
--

CREATE TABLE `ar_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gl_transaction_id` int(11) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ar_transactions`
--

INSERT INTO `ar_transactions` VALUES
(1,2,0,'2025-06-02 20:55:41');

--
-- Table structure for table `assessment_numbers`
--

CREATE TABLE `assessment_numbers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `number` varchar(100) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `assessment_numbers`
--

INSERT INTO `assessment_numbers` VALUES
(1,1,'A100',0,'2025-06-02 20:55:41'),
(2,2,'A101',0,'2025-06-02 20:55:41');

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

CREATE TABLE `attendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `hours_worked` decimal(5,2) NOT NULL DEFAULT 0.00,
  `overtime` decimal(5,2) NOT NULL DEFAULT 0.00,
  `approval_status` varchar(20) DEFAULT 'Approved',
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `attendance`
--


--
-- Table structure for table `bank_detail_changes`
--

CREATE TABLE `bank_detail_changes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `bankName` varchar(255) DEFAULT NULL,
  `accountName` varchar(255) DEFAULT NULL,
  `accountNumber` varchar(255) DEFAULT NULL,
  `status` enum('Pending','Approved','Rejected') DEFAULT 'Pending',
  `approved_at` datetime DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bank_detail_changes`
--


--
-- Table structure for table `bank_transactions`
--

CREATE TABLE `bank_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gl_transaction_id` int(11) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bank_transactions`
--

INSERT INTO `bank_transactions` VALUES
(1,1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `benefit_plans`
--

CREATE TABLE `benefit_plans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `deduction_amount` decimal(10,2) NOT NULL,
  `pre_tax` tinyint(1) DEFAULT 1,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `benefit_plans`
--

INSERT INTO `benefit_plans` VALUES
(1,'Health Insurance',150.00,1,0,'2025-06-02 20:55:41'),
(2,'Retirement 401k',200.00,1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `case_evidence`
--

CREATE TABLE `case_evidence` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `case_id` int(11) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `case_evidence`
--

INSERT INTO `case_evidence` VALUES
(1,1,'/evidence/late1.jpg','Time clock screenshot',0,'2025-06-02 20:55:41');

--
-- Table structure for table `case_notes`
--

CREATE TABLE `case_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `matter_id` int(11) NOT NULL,
  `note` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `case_notes`
--


--
-- Table structure for table `case_participants`
--

CREATE TABLE `case_participants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `matter_id` int(11) NOT NULL,
  `person_id` int(11) NOT NULL,
  `role` varchar(100) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `case_participants`
--


--
-- Table structure for table `case_tasks`
--

CREATE TABLE `case_tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `matter_id` int(11) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `due_date` datetime DEFAULT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `case_tasks`
--


--
-- Table structure for table `cash_sessions`
--

CREATE TABLE `cash_sessions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cashier_id` int(11) NOT NULL,
  `opened_at` datetime NOT NULL,
  `closed_at` datetime DEFAULT NULL,
  `opening_balance` decimal(10,2) NOT NULL,
  `closing_balance` decimal(10,2) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cash_sessions`
--


--
-- Table structure for table `check_ins`
--

CREATE TABLE `check_ins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `manager_id` int(11) DEFAULT NULL,
  `scheduled_at` datetime DEFAULT NULL,
  `completed_at` datetime DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `check_ins`
--


--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `country_idx` (`country_id`),
  KEY `name_idx` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` VALUES
(1,1,'Biosecurity Authority of Fiji',0,'2025-06-02 20:55:41');

--
-- Table structure for table `compensation`
--

CREATE TABLE `compensation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `pay_type` enum('salary','hourly') NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `effective_from` date NOT NULL,
  `effective_to` date DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `compensation`
--

INSERT INTO `compensation` VALUES
(1,1,'salary',60000.00,'2025-01-01',NULL,0,'2025-06-02 20:55:41'),
(2,2,'salary',80000.00,'2025-01-01',NULL,0,'2025-06-02 20:55:41'),
(3,3,'salary',50000.00,'2025-01-01',NULL,0,'2025-06-02 20:55:41'),
(4,4,'salary',75000.00,'2025-01-01',NULL,0,'2025-06-02 20:55:41'),
(5,5,'salary',45000.00,'2025-01-01',NULL,0,'2025-06-02 20:55:41');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `name_idx` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES
(1,'Fiji',0,'2025-06-02 20:55:41'),
(2,'United States',0,'2025-06-02 20:55:41'),
(3,'Australia',0,'2025-06-02 20:55:41');

--
-- Table structure for table `country_holidays`
--

CREATE TABLE `country_holidays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country_id` int(11) NOT NULL,
  `holiday_name` varchar(100) NOT NULL,
  `holiday_date` date NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `country_idx` (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `country_holidays`
--

INSERT INTO `country_holidays` VALUES
(1,1,'New Year\'s Day','2025-01-01',0,'2025-06-02 20:55:41'),
(2,1,'Good Friday','2025-04-18',0,'2025-06-02 20:55:41'),
(3,1,'Easter Saturday','2025-04-19',0,'2025-06-02 20:55:41'),
(4,1,'Easter Monday','2025-04-21',0,'2025-06-02 20:55:41'),
(5,1,'Girmit Day','2025-05-12',0,'2025-06-02 20:55:41'),
(6,1,'Ratu Sir Lala Sukuna Day','2025-05-30',0,'2025-06-02 20:55:41'),
(7,1,'Prophet Mohammed\'s Birthday','2025-09-08',0,'2025-06-02 20:55:41'),
(8,1,'Fiji Day','2025-10-10',0,'2025-06-02 20:55:41'),
(9,1,'Diwali','2025-10-21',0,'2025-06-02 20:55:41'),
(10,1,'Christmas Day','2025-12-25',0,'2025-06-02 20:55:41'),
(11,1,'Boxing Day','2025-12-26',0,'2025-06-02 20:55:41');

--
-- Table structure for table `customer_history`
--

CREATE TABLE `customer_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customerId` int(11) NOT NULL,
  `action` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `performedBy` int(11) NOT NULL,
  `performedAt` datetime DEFAULT current_timestamp(),
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customer_history`
--


--
-- Table structure for table `customer_settings`
--

CREATE TABLE `customer_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `value` text NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `customer_setting_unique` (`customer_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customer_settings`
--


--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customerType` enum('individual','corporate','government') NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `tin` varchar(100) DEFAULT NULL,
  `vat` varchar(100) DEFAULT NULL,
  `linkedEntityType` enum('ratepayer','businessRegistration') DEFAULT NULL,
  `linkedEntityId` varchar(255) DEFAULT NULL,
  `riskRating` enum('low','medium','high') DEFAULT NULL,
  `complianceStatus` enum('compliant','non-compliant','pending') DEFAULT NULL,
  `createdBy` int(11) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customers`
--


--
-- Table structure for table `deduction_settings`
--

CREATE TABLE `deduction_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `start_salary` decimal(10,2) NOT NULL,
  `end_salary` decimal(10,2) DEFAULT NULL,
  `base_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `percent` decimal(5,2) NOT NULL DEFAULT 0.00,
  `company_contribution` decimal(5,2) NOT NULL DEFAULT 0.00,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `applies_to` enum('resident','non_resident') NOT NULL,
  `scope` enum('country','company') NOT NULL,
  `country_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `deduction_settings`
--

INSERT INTO `deduction_settings` VALUES
(1,'PAYE',0.00,30000.00,0.00,0.00,0.00,NULL,NULL,'resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(2,'PAYE',30001.00,50000.00,0.00,18.00,0.00,NULL,NULL,'resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(3,'PAYE',50001.00,270000.00,3600.00,20.00,0.00,NULL,NULL,'resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(4,'PAYE',270001.00,300000.00,47600.00,33.00,0.00,NULL,NULL,'resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(5,'PAYE',300001.00,350000.00,57500.00,34.00,0.00,NULL,NULL,'resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(6,'PAYE',350001.00,400000.00,74500.00,35.00,0.00,NULL,NULL,'resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(7,'PAYE',400001.00,450000.00,92000.00,36.00,0.00,NULL,NULL,'resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(8,'PAYE',450001.00,500000.00,110000.00,37.00,0.00,NULL,NULL,'resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(9,'PAYE',500001.00,1000000.00,128500.00,38.00,0.00,NULL,NULL,'resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(10,'PAYE',1000001.00,NULL,318500.00,39.00,0.00,NULL,NULL,'resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(11,'PAYE',0.00,30000.00,0.00,20.00,0.00,NULL,NULL,'non_resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(12,'PAYE',30001.00,50000.00,6000.00,20.00,0.00,NULL,NULL,'non_resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(13,'PAYE',50001.00,270000.00,10000.00,20.00,0.00,NULL,NULL,'non_resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(14,'PAYE',270001.00,300000.00,54000.00,33.00,0.00,NULL,NULL,'non_resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(15,'PAYE',300001.00,350000.00,63900.00,34.00,0.00,NULL,NULL,'non_resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(16,'PAYE',350001.00,400000.00,80900.00,35.00,0.00,NULL,NULL,'non_resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(17,'PAYE',400001.00,450000.00,98400.00,36.00,0.00,NULL,NULL,'non_resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(18,'PAYE',450001.00,500000.00,116400.00,37.00,0.00,NULL,NULL,'non_resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(19,'PAYE',500001.00,1000000.00,134900.00,38.00,0.00,NULL,NULL,'non_resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(20,'PAYE',1000001.00,NULL,324900.00,39.00,0.00,NULL,NULL,'non_resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(21,'FNPF',0.00,NULL,0.00,8.00,10.00,NULL,NULL,'resident','country',1,NULL,0,'2025-06-02 20:55:41'),
(22,'Union Fee',0.00,2000.00,5.00,1.00,1.00,NULL,NULL,'resident','country',NULL,NULL,0,'2025-06-02 20:55:41'),
(23,'Union Fee Tier 2',2000.01,NULL,10.00,2.00,1.50,NULL,NULL,'resident','country',NULL,NULL,0,'2025-06-02 20:55:41');

--
-- Table structure for table `disciplinary_actions`
--

CREATE TABLE `disciplinary_actions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `case_id` int(11) NOT NULL,
  `action` varchar(255) NOT NULL,
  `effective_date` date NOT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `disciplinary_actions`
--

INSERT INTO `disciplinary_actions` VALUES
(1,1,'Written warning','2025-06-01',1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `disciplinary_cases`
--

CREATE TABLE `disciplinary_cases` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `violation_id` int(11) NOT NULL,
  `severity` enum('minor','major','critical') NOT NULL,
  `summary` text DEFAULT NULL,
  `status` enum('open','under_review','closed') DEFAULT 'open',
  `assigned_to` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `disciplinary_cases`
--

INSERT INTO `disciplinary_cases` VALUES
(1,2,1,'minor','Late arrival on 2025-05-01','open',1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `employee_authorized_locations`
--

CREATE TABLE `employee_authorized_locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `employee_idx` (`employee_id`),
  KEY `location_idx` (`location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `employee_authorized_locations`
--


--
-- Table structure for table `employee_benefit_documents`
--

CREATE TABLE `employee_benefit_documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_benefit_id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_type` varchar(50) NOT NULL,
  `file_path` text NOT NULL,
  `uploaded_by` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_benefit_documents`
--


--
-- Table structure for table `employee_benefits`
--

CREATE TABLE `employee_benefits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `benefit_plan_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_benefits`
--

INSERT INTO `employee_benefits` VALUES
(1,1,1,'2025-01-01',NULL,0,'2025-06-02 20:55:41'),
(2,2,2,'2025-01-01',NULL,0,'2025-06-02 20:55:41');

--
-- Table structure for table `employee_exits`
--

CREATE TABLE `employee_exits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `resignation_date` date NOT NULL,
  `status` varchar(50) DEFAULT 'pending',
  `final_pay` decimal(10,2) DEFAULT 0.00,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_exits`
--


--
-- Table structure for table `employee_items`
--

CREATE TABLE `employee_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `item_name` varchar(100) NOT NULL,
  `is_ppe` tinyint(1) NOT NULL DEFAULT 0,
  `expiry_date` date DEFAULT NULL,
  `assignee_user_id` int(11) DEFAULT NULL,
  `assignee_group_id` int(11) DEFAULT NULL,
  `assigned_at` timestamp NULL DEFAULT current_timestamp(),
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `employee_items`
--

INSERT INTO `employee_items` VALUES
(1,2,'Laptop',0,NULL,1,NULL,'2025-06-02 20:55:41',0,'2025-06-02 20:55:41'),
(2,3,'Safety Helmet',1,'2025-12-31',1,NULL,'2025-06-02 20:55:41',0,'2025-06-02 20:55:41');

--
-- Table structure for table `employee_location_changes`
--

CREATE TABLE `employee_location_changes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `stations` varchar(255) NOT NULL,
  `action` varchar(20) NOT NULL,
  `effective_date` date NOT NULL,
  `processed_at` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `emp_idx` (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `employee_location_changes`
--


--
-- Table structure for table `employee_types`
--

CREATE TABLE `employee_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `default_items` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `employee_types`
--

INSERT INTO `employee_types` VALUES
(1,'Full-Time','Laptop,Phone',0,'2025-06-02 20:55:41'),
(2,'Contractor','Laptop',0,'2025-06-02 20:55:41');

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `salary` decimal(10,2) DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `pay_cycle_id` int(11) DEFAULT NULL,
  `manager_id` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` VALUES
(17,1,'Test Admin',NULL,NULL,NULL,NULL,30000.00,1,1,NULL,0,'2025-06-02 20:55:41'),
(69,NULL,'Test Account',NULL,'testnew@example.com',NULL,NULL,NULL,NULL,NULL,NULL,0,'2025-06-23 23:57:07'),
(70,NULL,'Kritesh Sharma - BN252','ICT','ksharma@baf.com.fj','8919900','Mr.',NULL,NULL,NULL,NULL,0,'2025-06-24 00:56:23'),
(71,NULL,'Ronald Prasad - BN029','Trade','rprasad@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-24 00:59:53'),
(72,NULL,'Mohammed Istikar - BN610','ICT','mohammed.istikar@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-24 01:01:23'),
(73,NULL,'Walesi Vulaono Soro - BN031','Operations','wvulaono@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-24 02:07:01'),
(74,NULL,'Tevita Tuikubulau Karikaritu - BN128','ICT','tkarikaritu@baf.com.fj',NULL,NULL,NULL,NULL,NULL,NULL,0,'2025-06-24 02:09:31'),
(75,NULL,'Mereseini Tawakilai Vubaya - BN197','Animals','mvubaya@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 03:08:41'),
(76,NULL,'Ronak Cylvian Sharma - BN196','Board','rcsharma@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 03:10:11'),
(77,NULL,'Yogesh Reddy - BN198','Animals','yreddy@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 03:10:41'),
(78,NULL,'Mohammed Ifraaz - BN207','Plants','mifraaz@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 03:11:40'),
(79,NULL,'Lora Eta Qiqiwaqa - BN246','Plants','lqiqiwaqa@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 03:12:11'),
(80,NULL,'Jiale Siga Mar - BN257','Admin','jmar@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 03:43:19'),
(81,NULL,'Haroon Buksh - BN267','Admin','hbuksh@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 03:58:49'),
(82,NULL,'Matilda Julia  Hazelman - BN296','Admin','mhazelman@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 03:59:49'),
(83,NULL,'Sylvia  Nandani Reddy - BN309','Trade','sreddy@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:00:19'),
(84,NULL,'Panapasa Meke - BN260','Finance','pmeke@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:01:19'),
(85,NULL,'Mereani Vakadromusiga - BN400','HR','mvakadromusiga@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:02:49'),
(86,NULL,'Sonam Kumar - BN435','HR','sonamk@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:03:49'),
(87,NULL,'Kalisiana Vuniwaqa - BN561','HR','kvuniwaqa@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:04:19'),
(88,NULL,'Hanrieta Sina Yadraca - BN574','Legal','hanrieta.yadraca@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:05:49'),
(89,NULL,'Livai Nakuta - BN339','ICT','lnakuta@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:25:30'),
(90,NULL,'Teria Ribauea - BN360','Finance','thedstrom@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:26:00'),
(91,NULL,'Nirlesh Niraj Lal - BN493','Finance','nirlesh_l@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:27:00'),
(92,NULL,'Veniana Wasarua Tuva - BN519','Admin','veniana_t@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:27:30'),
(93,NULL,'Aminio Tuisavusavu','Admin','atuisavusavu@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:32:00'),
(94,NULL,'Tuverea Tuamoto - BN547','Plants','tuverea_t@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:33:00'),
(95,NULL,'Rashnil Jai - BN556','Admin','rashnil.kumar@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:33:30'),
(96,NULL,'Repeka Tukula - BN566','Admin','repeka.tukula@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:34:00'),
(97,NULL,'Sera Rasiga - BN575','Finance','srasiga@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:34:30'),
(98,NULL,'Lily Pickering - BN611','Admin','lily.pickering@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:44:04'),
(99,NULL,'Arieta Marawaqa - BN612','Admin','arieta.marawaqa@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:44:34'),
(100,NULL,'Taina Mocemaiwaiyevo - BN645','Admin','taina.mocemaiwaiyevo@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:45:34'),
(101,NULL,'Edward James Newton - BN646','Communications','ejames@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:46:05'),
(102,NULL,'Surend Pratap - BN046','CEO','spratap@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:46:34'),
(103,NULL,'Nitesh Datt - BN219','Finance','cppo@baf.com.fj',NULL,'Mr.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:47:34'),
(104,NULL,'Iverlyn Maeta - BN655','Finance','iverlyn.maeta@baf.com.fj',NULL,'Ms.',NULL,NULL,NULL,NULL,0,'2025-06-26 04:48:04');

--
-- Table structure for table `employees2locations`
--

CREATE TABLE `employees2locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `location_idx` (`location_id`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employees2locations`
--

INSERT INTO `employees2locations` VALUES
(1,28,1,0,'2025-06-22 21:59:23'),
(2,29,1,0,'2025-06-22 21:59:53'),
(3,30,1,0,'2025-06-22 22:00:24'),
(4,31,1,0,'2025-06-22 22:00:54'),
(5,32,1,0,'2025-06-22 22:01:30'),
(6,33,1,0,'2025-06-22 22:02:30'),
(7,34,1,0,'2025-06-22 22:03:30'),
(8,35,1,0,'2025-06-22 22:04:29'),
(9,36,1,0,'2025-06-22 22:05:29'),
(10,37,1,0,'2025-06-22 22:06:29'),
(11,38,1,0,'2025-06-22 22:07:29'),
(12,39,1,0,'2025-06-22 22:08:30'),
(13,40,1,0,'2025-06-22 22:09:30'),
(14,41,1,0,'2025-06-22 22:10:30'),
(15,42,1,0,'2025-06-22 22:11:29'),
(16,43,1,0,'2025-06-22 22:13:30'),
(17,44,1,0,'2025-06-22 22:14:30'),
(18,45,1,0,'2025-06-22 22:15:30'),
(19,46,1,0,'2025-06-22 22:16:18'),
(20,47,1,0,'2025-06-22 22:16:23'),
(21,48,1,0,'2025-06-22 22:16:53'),
(22,49,1,0,'2025-06-22 22:55:23'),
(26,52,1,0,'2025-06-23 03:07:37'),
(32,51,1,0,'2025-06-23 03:41:05'),
(33,54,1,0,'2025-06-23 03:41:35'),
(34,55,1,0,'2025-06-23 03:42:05'),
(35,57,1,0,'2025-06-23 03:42:35'),
(38,58,1,0,'2025-06-23 03:47:19'),
(39,56,1,0,'2025-06-23 03:49:07'),
(40,59,1,0,'2025-06-23 03:50:37'),
(41,60,1,0,'2025-06-23 03:54:08'),
(43,62,1,0,'2025-06-23 03:59:38'),
(44,63,1,0,'2025-06-23 04:00:38'),
(45,64,1,0,'2025-06-23 04:04:38'),
(46,65,1,0,'2025-06-23 04:08:08'),
(47,66,1,0,'2025-06-23 04:09:08'),
(48,67,1,0,'2025-06-23 20:32:20'),
(49,68,1,0,'2025-06-23 20:45:28'),
(50,69,1,0,'2025-06-23 23:57:07'),
(52,61,1,0,'2025-06-24 00:30:19'),
(53,50,1,0,'2025-06-24 00:33:28'),
(54,70,1,0,'2025-06-24 00:56:23'),
(55,71,1,0,'2025-06-24 00:59:53'),
(56,72,1,0,'2025-06-24 01:01:23'),
(57,73,1,0,'2025-06-24 02:07:01'),
(59,74,1,0,'2025-06-26 03:02:13'),
(61,76,1,0,'2025-06-26 03:10:11'),
(62,77,1,0,'2025-06-26 03:10:41'),
(63,78,1,0,'2025-06-26 03:11:40'),
(65,80,1,0,'2025-06-26 03:43:19'),
(67,82,1,0,'2025-06-26 03:59:49'),
(68,83,1,0,'2025-06-26 04:00:19'),
(69,84,1,0,'2025-06-26 04:01:19'),
(70,85,1,0,'2025-06-26 04:02:49'),
(71,86,1,0,'2025-06-26 04:03:49'),
(72,87,1,0,'2025-06-26 04:04:19'),
(73,88,1,0,'2025-06-26 04:05:49'),
(74,89,1,0,'2025-06-26 04:25:31'),
(75,90,1,0,'2025-06-26 04:26:01'),
(76,91,1,0,'2025-06-26 04:27:01'),
(77,92,1,0,'2025-06-26 04:27:31'),
(78,93,1,0,'2025-06-26 04:32:01'),
(79,94,1,0,'2025-06-26 04:33:01'),
(80,95,1,0,'2025-06-26 04:33:31'),
(81,96,1,0,'2025-06-26 04:34:01'),
(82,97,1,0,'2025-06-26 04:34:31'),
(83,98,1,0,'2025-06-26 04:44:05'),
(84,99,1,0,'2025-06-26 04:44:34'),
(85,100,1,0,'2025-06-26 04:45:34'),
(86,101,1,0,'2025-06-26 04:46:05'),
(87,102,1,0,'2025-06-26 04:46:34'),
(88,103,1,0,'2025-06-26 04:47:35'),
(89,104,1,0,'2025-06-26 04:48:04'),
(90,75,1,0,'2025-07-02 03:39:19'),
(91,79,1,0,'2025-07-02 03:40:25'),
(92,81,1,0,'2025-07-02 03:40:55');

--
-- Table structure for table `employees2users`
--

CREATE TABLE `employees2users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_idx` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employees2users`
--

INSERT INTO `employees2users` VALUES
(6,17,1,0,'2025-06-02 20:55:41'),
(37,69,159,0,'2025-06-23 23:57:07'),
(38,50,160,0,'2025-06-24 00:30:18'),
(39,61,161,0,'2025-06-24 00:30:19'),
(40,70,204,0,'2025-06-24 00:56:23'),
(41,71,205,0,'2025-06-24 00:59:53'),
(42,72,206,0,'2025-06-24 01:01:23'),
(43,73,207,0,'2025-06-24 02:07:01'),
(44,74,350,0,'2025-06-24 02:09:31'),
(45,75,202,0,'2025-06-26 03:08:41'),
(46,76,352,0,'2025-06-26 03:10:11'),
(47,77,353,0,'2025-06-26 03:10:41'),
(48,78,354,0,'2025-06-26 03:11:40'),
(49,79,203,0,'2025-06-26 03:12:11'),
(50,80,356,0,'2025-06-26 03:43:19'),
(51,81,161,0,'2025-06-26 03:58:49'),
(52,82,358,0,'2025-06-26 03:59:49'),
(53,83,359,0,'2025-06-26 04:00:19'),
(54,84,360,0,'2025-06-26 04:01:19'),
(55,85,361,0,'2025-06-26 04:02:49'),
(56,86,362,0,'2025-06-26 04:03:49'),
(57,87,363,0,'2025-06-26 04:04:19'),
(58,88,364,0,'2025-06-26 04:05:49'),
(59,89,365,0,'2025-06-26 04:25:31'),
(60,90,366,0,'2025-06-26 04:26:01'),
(61,91,367,0,'2025-06-26 04:27:01'),
(62,92,368,0,'2025-06-26 04:27:31'),
(63,93,369,0,'2025-06-26 04:32:01'),
(64,94,370,0,'2025-06-26 04:33:01'),
(65,95,371,0,'2025-06-26 04:33:31'),
(66,96,372,0,'2025-06-26 04:34:01'),
(67,97,373,0,'2025-06-26 04:34:31'),
(68,98,374,0,'2025-06-26 04:44:05'),
(69,99,375,0,'2025-06-26 04:44:34'),
(70,100,376,0,'2025-06-26 04:45:34'),
(71,101,377,0,'2025-06-26 04:46:05'),
(72,102,378,0,'2025-06-26 04:46:34'),
(73,103,379,0,'2025-06-26 04:47:35'),
(74,104,380,0,'2025-06-26 04:48:04');

--
-- Table structure for table `exit_approvals`
--

CREATE TABLE `exit_approvals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `exit_id` int(11) NOT NULL,
  `approver_id` int(11) NOT NULL,
  `level` int(11) NOT NULL,
  `status` varchar(50) DEFAULT 'pending',
  `approved_at` datetime DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `exit_approvals`
--


--
-- Table structure for table `exit_clearances`
--

CREATE TABLE `exit_clearances` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `exit_id` int(11) NOT NULL,
  `item` varchar(100) DEFAULT NULL,
  `returned` tinyint(1) DEFAULT 0,
  `access_revoked` tinyint(1) DEFAULT 0,
  `notes` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `exit_clearances`
--


--
-- Table structure for table `exit_feedback`
--

CREATE TABLE `exit_feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `exit_interview_id` int(11) NOT NULL,
  `question` varchar(255) DEFAULT NULL,
  `response` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `exit_feedback`
--


--
-- Table structure for table `exit_interviews`
--

CREATE TABLE `exit_interviews` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `exit_id` int(11) NOT NULL,
  `interviewer_id` int(11) DEFAULT NULL,
  `scheduled_at` datetime DEFAULT NULL,
  `completed_at` datetime DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `exit_interviews`
--


--
-- Table structure for table `feedback_notes`
--

CREATE TABLE `feedback_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `from_user_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `note` text NOT NULL,
  `is_private` tinyint(1) DEFAULT 1,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `feedback_notes`
--


--
-- Table structure for table `gl_accounts`
--

CREATE TABLE `gl_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `tags` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `parent_id` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gl_accounts`
--

INSERT INTO `gl_accounts` VALUES
(1,'1000','Cash','asset','bank',1,NULL,0,'2025-06-02 20:55:41'),
(2,'2000','Accounts Payable','liability','ap',1,NULL,0,'2025-06-02 20:55:41'),
(3,'4000','Sales Revenue','revenue','income',1,NULL,0,'2025-06-02 20:55:41');

--
-- Table structure for table `gl_recurring_entries`
--

CREATE TABLE `gl_recurring_entries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` varchar(255) NOT NULL,
  `account_id` int(11) NOT NULL,
  `type` enum('debit','credit') NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `frequency` enum('daily','weekly','monthly','yearly') NOT NULL,
  `next_run_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gl_recurring_entries`
--


--
-- Table structure for table `gl_transactions`
--

CREATE TABLE `gl_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `journal_entry_id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `type` enum('debit','credit') NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `currency` varchar(10) DEFAULT 'USD',
  `rate` decimal(15,6) DEFAULT 1.000000,
  `timestamp` datetime NOT NULL,
  `memo` text DEFAULT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gl_transactions`
--

INSERT INTO `gl_transactions` VALUES
(1,1,1,'debit',1000.00,'USD',1.000000,'2025-06-02 20:55:41','Opening cash','JE001-1',0,'2025-06-02 20:55:41'),
(2,1,3,'credit',1000.00,'USD',1.000000,'2025-06-02 20:55:41','Opening equity','JE001-2',0,'2025-06-02 20:55:41');

--
-- Table structure for table `goods_receipts`
--

CREATE TABLE `goods_receipts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int(11) NOT NULL,
  `received_date` date DEFAULT NULL,
  `quantity_received` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `goods_receipts`
--


--
-- Table structure for table `group_permissions`
--

CREATE TABLE `group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `resource_id` int(11) NOT NULL,
  `can_view` tinyint(1) DEFAULT 0,
  `can_edit` tinyint(1) DEFAULT 0,
  `can_create` tinyint(1) DEFAULT 0,
  `can_delete` tinyint(1) DEFAULT 0,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `group_permissions`
--

INSERT INTO `group_permissions` VALUES
(1,2,1,1,1,1,1,0,'2025-06-02 20:55:41'),
(2,2,2,1,1,1,1,0,'2025-06-02 20:55:41'),
(3,3,1,1,0,0,0,0,'2025-06-02 20:55:41'),
(4,2,3,1,1,1,1,0,'2025-06-02 20:55:41'),
(5,3,3,1,0,0,0,0,'2025-06-02 20:55:41');

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` VALUES
(1,'HR Admin Group','Full access group',NULL,0,'2025-06-02 20:55:41'),
(2,'Finance Team','Handles company finances',NULL,0,'2025-06-02 20:55:41'),
(3,'Sales Team','Responsible for sales',NULL,0,'2025-06-02 20:55:41');

--
-- Table structure for table `interview_feedback`
--

CREATE TABLE `interview_feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `interview_id` int(11) NOT NULL,
  `reviewer_id` int(11) NOT NULL,
  `score` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `interview_feedback`
--


--
-- Table structure for table `interview_logs`
--

CREATE TABLE `interview_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `case_id` int(11) NOT NULL,
  `person` varchar(255) NOT NULL,
  `notes` text DEFAULT NULL,
  `logged_at` datetime DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `interview_logs`
--

INSERT INTO `interview_logs` VALUES
(1,1,'Bob Smith','Employee admitted being late due to traffic','2025-06-02 20:55:41',0,'2025-06-02 20:55:41');

--
-- Table structure for table `interview_participants`
--

CREATE TABLE `interview_participants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `interview_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `role` varchar(100) DEFAULT NULL,
  `rsvp_status` varchar(50) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `interview_participants`
--


--
-- Table structure for table `interview_stages`
--

CREATE TABLE `interview_stages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `sequence` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `interview_stages`
--


--
-- Table structure for table `interviews`
--

CREATE TABLE `interviews` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `application_id` int(11) DEFAULT NULL,
  `stage_id` int(11) DEFAULT NULL,
  `calendar_event_id` int(11) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `scheduled_start` datetime DEFAULT NULL,
  `scheduled_end` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `interviews`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` VALUES
(1,'Software Engineer',0,'2025-06-02 20:55:41'),
(2,'Sales Representative',0,'2025-06-02 20:55:41'),
(3,'HR Specialist',0,'2025-06-02 20:55:41');

--
-- Table structure for table `leave_requests`
--

CREATE TABLE `leave_requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeName` varchar(100) NOT NULL,
  `leaveType` varchar(50) NOT NULL,
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  `reason` text DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'Pending',
  `createdBy` int(11) DEFAULT NULL,
  `approvedAt` datetime DEFAULT NULL,
  `approvedBy` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `leave_requests`
--

INSERT INTO `leave_requests` VALUES
(1,'Alice Johnson','Annual Leave','2025-07-01','2025-07-10','Vacation','Approved',1,'2025-06-15 00:00:00',1,0,'2025-06-02 20:55:41'),
(2,'Bob Smith','Sick Leave','2025-06-02','2025-06-05','Flu','Approved',1,'2025-06-01 00:00:00',1,0,'2025-06-02 20:55:41');

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

CREATE TABLE `leave_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `code` varchar(10) NOT NULL,
  `description` text DEFAULT NULL,
  `daysPerYear` int(11) NOT NULL,
  `accrualType` varchar(50) NOT NULL,
  `carryForward` tinyint(1) NOT NULL DEFAULT 0,
  `maxCarry` int(11) DEFAULT NULL,
  `approvalRequired` tinyint(1) NOT NULL DEFAULT 1,
  `paid` tinyint(1) NOT NULL DEFAULT 1,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `createdBy` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `leave_types` VALUES
(1,'Annual Leave','AL','Paid annual leave',20,'monthly',1,10,1,1,1,1,0,'2025-06-02 20:55:41'),
(2,'Sick Leave','SL','Paid sick leave',10,'yearly',0,NULL,0,1,1,1,0,'2025-06-02 20:55:41'),
(3,'Unpaid Leave','UL','Leave without pay',0,'none',0,NULL,1,0,1,1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `latitude` decimal(10,6) DEFAULT NULL,
  `longitude` decimal(10,6) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `radius_m` int(11) NOT NULL DEFAULT 50,
  PRIMARY KEY (`id`),
  KEY `company_idx` (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` VALUES
(1,'Suva Headquarters',-18.139796,178.426563,1,0,'2025-06-02 20:55:41',10),
(2,'Sigatoka Office',-18.145800,177.506500,1,0,'2025-06-02 20:55:41',50),
(3,'Suva Export',-18.129200,178.426500,1,0,'2025-06-02 20:55:41',50),
(4,'Nadi Office',-17.753300,177.443500,1,0,'2025-06-02 20:55:41',50),
(5,'Lautoka Office',-17.616700,177.466700,1,0,'2025-06-02 20:55:41',50),
(6,'Ba Office',-17.534100,177.683800,1,0,'2025-06-02 20:55:41',50),
(7,'Nausori Office',-18.024400,178.545100,1,0,'2025-06-02 20:55:41',50),
(8,'Labasa Office',-16.430200,179.382200,1,0,'2025-06-02 20:55:41',50),
(9,'Nausori Station',-18.024400,178.545100,1,0,'2025-06-02 20:55:41',50),
(10,'Savusavu',-16.779400,179.331400,1,0,'2025-06-02 20:55:41',50),
(11,'Navua Station',-18.219400,178.159200,1,0,'2025-06-02 20:55:41',50),
(12,'Rakiraki Office',-17.365800,178.165000,1,0,'2025-06-02 20:55:41',50),
(13,'Rotuma',-12.502500,177.072000,1,0,'2025-06-02 20:55:41',50),
(14,'Lab',-18.049100,178.529800,1,0,'2025-06-02 20:55:41',50),
(15,'Suva Wharf Office',NULL,NULL,NULL,0,'2025-08-04 00:53:17',10);

--
-- Table structure for table `notification_log`
--

CREATE TABLE `notification_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `recipient` varchar(255) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `notification_log`
--

INSERT INTO `notification_log` VALUES
(1,'email','alice.johnson@example.com','Welcome','Welcome to the company!','sent',0,'2025-06-02 20:55:41');

--
-- Table structure for table `ohs_actions`
--

CREATE TABLE `ohs_actions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `incident_id` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `responsible_user_id` int(11) DEFAULT NULL,
  `target_date` date DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `completed_at` datetime DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ohs_actions`
--


--
-- Table structure for table `ohs_emergency_contacts`
--

CREATE TABLE `ohs_emergency_contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `contact_name` varchar(255) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `relation` varchar(100) DEFAULT NULL,
  `pendingSync` tinyint(1) DEFAULT 0,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ohs_emergency_contacts`
--


--
-- Table structure for table `ohs_emergency_drills`
--

CREATE TABLE `ohs_emergency_drills` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `drill_type` varchar(100) NOT NULL,
  `scheduled_for` datetime NOT NULL,
  `conducted_by` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `reminder_sent` tinyint(1) DEFAULT 0,
  `pendingSync` tinyint(1) DEFAULT 0,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ohs_emergency_drills`
--


--
-- Table structure for table `ohs_hazards`
--

CREATE TABLE `ohs_hazards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` text DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `risk_level` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ohs_hazards`
--


--
-- Table structure for table `ohs_health_checks`
--

CREATE TABLE `ohs_health_checks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `check_type` varchar(100) NOT NULL,
  `result` text DEFAULT NULL,
  `check_date` date NOT NULL,
  `notes` text DEFAULT NULL,
  `pendingSync` tinyint(1) DEFAULT 0,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ohs_health_checks`
--


--
-- Table structure for table `ohs_incident_files`
--

CREATE TABLE `ohs_incident_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `incident_id` int(11) NOT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `uploaded_by` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ohs_incident_files`
--


--
-- Table structure for table `ohs_incidents`
--

CREATE TABLE `ohs_incidents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `injury_date` date DEFAULT NULL,
  `injury_time` time DEFAULT NULL,
  `classification` enum('injury','property_damage','environmental','near_miss') NOT NULL DEFAULT 'injury',
  `nature` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `workplace_part` varchar(255) DEFAULT NULL,
  `activity` varchar(255) DEFAULT NULL,
  `unexpected` text DEFAULT NULL,
  `how_sustained` text DEFAULT NULL,
  `preferred_language` varchar(100) DEFAULT NULL,
  `employment_type` varchar(100) DEFAULT NULL,
  `employee_type` varchar(100) DEFAULT NULL,
  `experience` varchar(100) DEFAULT NULL,
  `completed_by` varchar(100) DEFAULT NULL,
  `position` varchar(100) DEFAULT NULL,
  `signature` varchar(255) DEFAULT NULL,
  `completion_date` date DEFAULT NULL,
  `rehabilitation` varchar(100) DEFAULT NULL,
  `outcome` varchar(255) DEFAULT NULL,
  `preventative_action` text DEFAULT NULL,
  `resumption_date` date DEFAULT NULL,
  `days_lost` int(11) DEFAULT NULL,
  `required_training_id` int(11) DEFAULT NULL,
  `damaged_item_id` int(11) DEFAULT NULL,
  `status` enum('reported','investigating','closed') NOT NULL DEFAULT 'reported',
  `pendingSync` tinyint(1) DEFAULT 0,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ohs_incidents`
--


--
-- Table structure for table `ohs_inspection_items`
--

CREATE TABLE `ohs_inspection_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `inspection_id` int(11) NOT NULL,
  `question` varchar(255) NOT NULL,
  `response` varchar(100) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `corrective_action` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ohs_inspection_items`
--


--
-- Table structure for table `ohs_inspections`
--

CREATE TABLE `ohs_inspections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `location` varchar(255) DEFAULT NULL,
  `inspector_id` int(11) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ohs_inspections`
--


--
-- Table structure for table `ohs_medicals`
--

CREATE TABLE `ohs_medicals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `incident_id` int(11) NOT NULL,
  `health_check_id` int(11) DEFAULT NULL,
  `surname` varchar(100) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `other_initials` varchar(100) DEFAULT NULL,
  `sex` varchar(10) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `job_title` varchar(100) DEFAULT NULL,
  `occ_years` int(11) DEFAULT NULL,
  `occ_months` int(11) DEFAULT NULL,
  `occ_days` int(11) DEFAULT NULL,
  `employment_status` varchar(100) DEFAULT NULL,
  `incident_date` date DEFAULT NULL,
  `incident_time` time DEFAULT NULL,
  `incident_type` varchar(255) DEFAULT NULL,
  `agency` varchar(255) DEFAULT NULL,
  `incident_description` text DEFAULT NULL,
  `damage_location` text DEFAULT NULL,
  `corrective_action` varchar(255) DEFAULT NULL,
  `action_date` date DEFAULT NULL,
  `medical_treatment` varchar(255) DEFAULT NULL,
  `medical_practitioner` varchar(255) DEFAULT NULL,
  `date_notified` date DEFAULT NULL,
  `incapacity_years` int(11) DEFAULT NULL,
  `incapacity_months` int(11) DEFAULT NULL,
  `incapacity_days` int(11) DEFAULT NULL,
  `employer_signature` varchar(255) DEFAULT NULL,
  `employer_date` date DEFAULT NULL,
  `employee_signature` varchar(255) DEFAULT NULL,
  `employee_date` date DEFAULT NULL,
  `pendingSync` tinyint(1) DEFAULT 0,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ohs_medicals`
--


--
-- Table structure for table `ohs_risk_reviews`
--

CREATE TABLE `ohs_risk_reviews` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hazard_id` int(11) NOT NULL,
  `reviewer_id` int(11) DEFAULT NULL,
  `review_date` date DEFAULT NULL,
  `residual_risk` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ohs_risk_reviews`
--


--
-- Table structure for table `ohs_root_causes`
--

CREATE TABLE `ohs_root_causes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `incident_id` int(11) NOT NULL,
  `method` varchar(100) DEFAULT NULL,
  `analysis_notes` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ohs_root_causes`
--


--
-- Table structure for table `open_positions`
--

CREATE TABLE `open_positions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `applicant_type` enum('All','Internal Only','External Only') DEFAULT 'All',
  `open_date` date DEFAULT NULL,
  `close_date` date DEFAULT NULL,
  `department` text DEFAULT NULL,
  `qualifications` text DEFAULT NULL,
  `salary` decimal(10,2) DEFAULT NULL,
  `status` enum('Open','Closed','Pending') DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `open_positions`
--

INSERT INTO `open_positions` VALUES
(1,'Junior Developer','Entry level role','Suva',NULL,'All',NULL,NULL,'Engineering',NULL,NULL,'Open',1,0,'2025-06-02 20:55:41'),
(2,'Sales Intern','Assist sales team','Nadi',NULL,'All',NULL,NULL,'Sales',NULL,NULL,'Open',1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `overtime_rules`
--

CREATE TABLE `overtime_rules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `scope` enum('country','company') DEFAULT 'company',
  `country_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `shift_hours` int(11) NOT NULL,
  `first4_rate` decimal(5,2) DEFAULT 1.50,
  `after4_rate` decimal(5,2) DEFAULT 2.00,
  `holiday_rate` decimal(5,2) DEFAULT 2.00,
  `sixth_day_rate` decimal(5,2) DEFAULT 2.00,
  `seventh_day_rate` decimal(5,2) DEFAULT 2.00,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `country_idx` (`country_id`),
  KEY `company_idx` (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `overtime_rules`
--

INSERT INTO `overtime_rules` VALUES
(1,'country',1,NULL,9,1.50,2.00,2.00,2.00,2.00,0,'2025-06-02 20:55:41'),
(2,'country',1,NULL,8,1.50,2.00,2.00,2.00,2.00,0,'2025-06-02 20:55:41'),
(3,'country',2,NULL,8,1.50,2.00,2.00,2.00,2.00,0,'2025-06-02 20:55:41'),
(4,'country',3,NULL,8,1.50,2.00,2.00,2.00,2.00,0,'2025-06-02 20:55:41');

--
-- Table structure for table `pay_cycles`
--

CREATE TABLE `pay_cycles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `frequency` enum('weekly','fortnightly','bi-monthly','monthly') NOT NULL,
  `pay_day` varchar(20) DEFAULT NULL,
  `cutoff_offset` int(11) DEFAULT 0,
  `next_run_date` date NOT NULL,
  `locale` varchar(10) DEFAULT 'en_US',
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pay_cycles`
--

INSERT INTO `pay_cycles` VALUES
(1,'Weekly','weekly','Friday',0,'2025-06-07','en_US',0,'2025-06-02 20:55:41'),
(2,'Fortnightly','fortnightly','Tuesday',4,'2025-06-14','en_US',0,'2025-06-02 20:55:41'),
(3,'Bi-Monthly-15','bi-monthly','15',2,'2025-06-15','en_US',0,'2025-06-02 20:55:41'),
(4,'Bi-Monthly-30','bi-monthly','30',2,'2025-06-30','en_US',0,'2025-06-02 20:55:41'),
(5,'Monthly','monthly','30',2,'2025-06-30','en_US',0,'2025-06-02 20:55:41');

--
-- Table structure for table `pay_rules`
--

CREATE TABLE `pay_rules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rule_name` varchar(100) NOT NULL,
  `overtime_rate` decimal(5,2) DEFAULT 1.50,
  `threshold_hours` int(11) DEFAULT 40,
  `notes` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pay_rules`
--

INSERT INTO `pay_rules` VALUES
(1,'Standard OT',1.50,40,'Overtime after 40 hours',0,'2025-06-02 20:55:41'),
(2,'Holiday OT',2.00,0,'Double pay on holidays',0,'2025-06-02 20:55:41');

--
-- Table structure for table `payroll_adjustments`
--

CREATE TABLE `payroll_adjustments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `payroll_period_id` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `adjustment_type` enum('earning','deduction') NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payroll_adjustments`
--

INSERT INTO `payroll_adjustments` VALUES
(1,1,1,'Bonus',500.00,'earning',0,'2025-06-02 20:55:41'),
(2,2,1,'Health Insurance',-200.00,'deduction',0,'2025-06-02 20:55:41');

--
-- Table structure for table `payroll_anomalies`
--

CREATE TABLE `payroll_anomalies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payroll_run_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `message` varchar(255) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `run_idx` (`payroll_run_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payroll_anomalies`
--

INSERT INTO `payroll_anomalies` VALUES
(1,1,2,'Missing timesheet',0,'2025-06-02 20:55:41');

--
-- Table structure for table `payroll_periods`
--

CREATE TABLE `payroll_periods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pay_cycle_id` int(11) NOT NULL,
  `period_start` date NOT NULL,
  `period_end` date NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payroll_periods`
--

INSERT INTO `payroll_periods` VALUES
(1,2,'2025-05-02','2025-05-15',0,'2025-06-02 20:55:41'),
(2,2,'2025-05-16','2025-05-29',0,'2025-06-02 20:55:41'),
(3,2,'2025-05-30','2025-06-05',0,'2025-06-02 20:55:41'),
(4,2,'2025-06-09','2025-06-20',0,'2025-06-02 20:55:41');

--
-- Table structure for table `payroll_runs`
--

CREATE TABLE `payroll_runs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payroll_period_id` int(11) NOT NULL,
  `run_date` date NOT NULL,
  `status` varchar(50) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `submitted_by` int(11) DEFAULT NULL,
  `submitted_at` datetime DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payroll_runs`
--

INSERT INTO `payroll_runs` VALUES
(1,1,'2025-06-07','completed',NULL,NULL,NULL,0,'2025-06-02 20:55:41'),
(2,2,'2025-06-07','completed',NULL,NULL,NULL,0,'2025-06-02 20:55:41'),
(3,3,'2025-06-01','completed',NULL,NULL,NULL,0,'2025-06-02 20:55:41'),
(4,4,'2025-06-21','completed',NULL,NULL,NULL,0,'2025-06-02 20:55:41');

--
-- Table structure for table `payslip_lines`
--

CREATE TABLE `payslip_lines` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payslip_id` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `line_type` enum('earning','deduction') NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payslip_lines`
--

INSERT INTO `payslip_lines` VALUES
(1,1,'Base Salary',5000.00,'earning',0,'2025-06-02 20:55:41'),
(2,1,'Tax',-1000.00,'deduction',0,'2025-06-02 20:55:41'),
(3,2,'Base Salary',6666.67,'earning',0,'2025-06-02 20:55:41'),
(4,2,'Tax',-1466.67,'deduction',0,'2025-06-02 20:55:41'),
(5,4,'Base Salary',2307.69,'earning',0,'2025-06-02 20:55:41'),
(6,4,'Employee Superannuation',184.62,'deduction',0,'2025-06-02 20:55:41'),
(7,4,'PAYE',215.38,'deduction',0,'2025-06-02 20:55:41'),
(8,4,'Employer Superannuation',230.77,'earning',0,'2025-06-02 20:55:41'),
(9,5,'Base Salary',3076.92,'earning',0,'2025-06-02 20:55:41'),
(10,5,'Employee Superannuation',246.15,'deduction',0,'2025-06-02 20:55:41'),
(11,5,'PAYE',369.23,'deduction',0,'2025-06-02 20:55:41'),
(12,5,'Employer Superannuation',307.69,'earning',0,'2025-06-02 20:55:41'),
(13,6,'Base Salary',1923.08,'earning',0,'2025-06-02 20:55:41'),
(14,6,'Employee Superannuation',153.85,'deduction',0,'2025-06-02 20:55:41'),
(15,6,'PAYE',138.46,'deduction',0,'2025-06-02 20:55:41'),
(16,6,'Employer Superannuation',192.31,'earning',0,'2025-06-02 20:55:41'),
(17,7,'Base Salary',2884.62,'earning',0,'2025-06-02 20:55:41'),
(18,7,'Employee Superannuation',230.77,'deduction',0,'2025-06-02 20:55:41'),
(19,7,'PAYE',330.77,'deduction',0,'2025-06-02 20:55:41'),
(20,7,'Employer Superannuation',288.46,'earning',0,'2025-06-02 20:55:41'),
(21,8,'Base Salary',1730.77,'earning',0,'2025-06-02 20:55:41'),
(22,8,'Employee Superannuation',138.46,'deduction',0,'2025-06-02 20:55:41'),
(23,8,'PAYE',103.85,'deduction',0,'2025-06-02 20:55:41'),
(24,8,'Employer Superannuation',173.08,'earning',0,'2025-06-02 20:55:41');

--
-- Table structure for table `payslips`
--

CREATE TABLE `payslips` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payroll_run_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `gross_pay` decimal(10,2) DEFAULT 0.00,
  `net_pay` decimal(10,2) DEFAULT 0.00,
  `document_path` text DEFAULT NULL,
  `verified_by` int(11) DEFAULT NULL,
  `verified_at` datetime DEFAULT NULL,
  `verification_notes` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payslips`
--

INSERT INTO `payslips` VALUES
(1,1,1,5000.00,4000.00,'/docs/payslips/1.pdf',NULL,NULL,NULL,0,'2025-06-02 20:55:41'),
(2,1,2,6666.67,5200.00,'/docs/payslips/2.pdf',NULL,NULL,NULL,0,'2025-06-02 20:55:41'),
(3,2,3,4166.67,3400.00,'/docs/payslips/3.pdf',NULL,NULL,NULL,0,'2025-06-02 20:55:41'),
(4,4,1,2307.69,1907.69,NULL,NULL,NULL,NULL,0,'2025-06-02 20:55:41'),
(5,4,2,3076.92,2461.54,NULL,NULL,NULL,NULL,0,'2025-06-02 20:55:41'),
(6,4,3,1923.08,1630.77,NULL,NULL,NULL,NULL,0,'2025-06-02 20:55:41'),
(7,4,4,2884.62,2323.08,NULL,NULL,NULL,NULL,0,'2025-06-02 20:55:41'),
(8,4,5,1730.77,1488.46,NULL,NULL,NULL,NULL,0,'2025-06-02 20:55:41');

--
-- Table structure for table `performance_goals`
--

CREATE TABLE `performance_goals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `due_date` date DEFAULT NULL,
  `status` varchar(50) DEFAULT 'pending',
  `progress_pct` decimal(5,2) DEFAULT 0.00,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `performance_goals`
--


--
-- Table structure for table `performance_reviews`
--

CREATE TABLE `performance_reviews` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `cycle_id` int(11) NOT NULL,
  `self_rating` decimal(3,2) DEFAULT NULL,
  `manager_rating` decimal(3,2) DEFAULT NULL,
  `comments` text DEFAULT NULL,
  `status` varchar(50) DEFAULT 'draft',
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `performance_reviews`
--


--
-- Table structure for table `permit_applications`
--

CREATE TABLE `permit_applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permit_type_id` int(11) NOT NULL,
  `applicant_id` int(11) NOT NULL,
  `status` varchar(50) DEFAULT 'Pending',
  `fee_amount` decimal(10,2) DEFAULT 0.00,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `permit_applications`
--


--
-- Table structure for table `permit_documents`
--

CREATE TABLE `permit_documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permit_application_id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_type` varchar(50) NOT NULL,
  `file_path` text NOT NULL,
  `uploaded_by` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `permit_documents`
--


--
-- Table structure for table `permit_inspections`
--

CREATE TABLE `permit_inspections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permit_application_id` int(11) NOT NULL,
  `inspector_id` int(11) NOT NULL,
  `scheduled_for` datetime DEFAULT NULL,
  `result` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `hours_logged` decimal(5,2) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `permit_inspections`
--


--
-- Table structure for table `permit_types`
--

CREATE TABLE `permit_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `permit_types`
--


--
-- Table structure for table `po_line_items`
--

CREATE TABLE `po_line_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `unit_price` decimal(10,2) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `po_line_items`
--


--
-- Table structure for table `procurement_requests`
--

CREATE TABLE `procurement_requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` text NOT NULL,
  `justification` text DEFAULT NULL,
  `estimated_cost` decimal(10,2) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `preferred_vendor` varchar(100) DEFAULT NULL,
  `needed_by` date DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'Pending',
  `requester_id` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `procurement_requests`
--

INSERT INTO `procurement_requests` VALUES
(1,'Office Chairs','Replace old chairs',1200.00,10,'Fiji Furniture','2025-07-01',NULL,'Pending',1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `properties`
--

CREATE TABLE `properties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CouncilID` int(11) DEFAULT NULL,
  `PropertyID` int(11) NOT NULL,
  `AssessmentNumber` int(11) NOT NULL,
  `RatepayerID` int(11) DEFAULT NULL,
  `Zone` varchar(100) DEFAULT NULL,
  `Address` text DEFAULT NULL,
  `Street` varchar(255) DEFAULT NULL,
  `Ward` varchar(100) DEFAULT NULL,
  `LegalDescription` text DEFAULT NULL,
  `NoOfFlats` int(11) DEFAULT NULL,
  `IsActive` tinyint(1) DEFAULT 1,
  `CreatedBy` int(11) DEFAULT NULL,
  `propertyHoldersName` varchar(255) DEFAULT NULL,
  `UCV` decimal(10,2) NOT NULL,
  `RatesStrick` decimal(3,2) NOT NULL,
  `Arrears` decimal(10,2) NOT NULL,
  `AdvancePayment` decimal(10,2) NOT NULL,
  `GarbageFee` decimal(10,2) NOT NULL,
  `GarbageArrears` decimal(10,2) NOT NULL,
  `AdvancePay` decimal(10,2) NOT NULL,
  `LegalFee` decimal(10,2) NOT NULL,
  `UpdatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `properties`
--


--
-- Table structure for table `property_rates`
--

CREATE TABLE `property_rates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Zone` varchar(100) DEFAULT NULL,
  `SubZone` varchar(100) DEFAULT NULL,
  `Category` varchar(100) DEFAULT NULL,
  `BaseRate` decimal(10,2) DEFAULT NULL,
  `RatePer100` decimal(10,2) DEFAULT NULL,
  `RateType` varchar(50) DEFAULT NULL,
  `RateStrick2024` decimal(10,2) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `property_rates`
--


--
-- Table structure for table `purchase_orders`
--

CREATE TABLE `purchase_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rfq_id` int(11) DEFAULT NULL,
  `vendor_id` int(11) NOT NULL,
  `order_date` date DEFAULT NULL,
  `status` varchar(50) DEFAULT 'Open',
  `total_amount` decimal(10,2) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `purchase_orders`
--


--
-- Table structure for table `purchase_requests`
--

CREATE TABLE `purchase_requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` text NOT NULL,
  `justification` text DEFAULT NULL,
  `estimated_cost` decimal(10,2) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `preferred_vendor` varchar(100) DEFAULT NULL,
  `needed_by` date DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `purchase_requests`
--

INSERT INTO `purchase_requests` VALUES
(1,'Laptop','New hire equipment',1500.00,1,'Computer World','2025-06-15',1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `rate_invoices`
--

CREATE TABLE `rate_invoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CouncilID` int(11) DEFAULT NULL,
  `RateID` int(11) NOT NULL,
  `PropertyID` int(11) DEFAULT NULL,
  `Period` date DEFAULT NULL,
  `Arrears` decimal(10,2) DEFAULT NULL,
  `CurrentCharges` decimal(10,2) DEFAULT NULL,
  `Penalty` decimal(10,2) DEFAULT NULL,
  `TotalDue` decimal(10,2) DEFAULT NULL,
  `ReceiptsTotal` decimal(10,2) DEFAULT NULL,
  `Balance` decimal(10,2) DEFAULT NULL,
  `CreatedBy` int(11) DEFAULT NULL,
  `customerId` int(11) DEFAULT NULL,
  `gl_transaction_id` int(11) DEFAULT NULL,
  `UpdatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rate_invoices`
--


--
-- Table structure for table `rate_payments`
--

CREATE TABLE `rate_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CouncilID` int(11) DEFAULT NULL,
  `ReceiptID` int(11) NOT NULL,
  `PropertyID` int(11) DEFAULT NULL,
  `RateID` int(11) DEFAULT NULL,
  `ReferenceNo` varchar(100) DEFAULT NULL,
  `Amount` decimal(10,2) DEFAULT NULL,
  `ReceiptDate` date DEFAULT NULL,
  `Method` varchar(50) DEFAULT NULL,
  `UploadedBy` varchar(100) DEFAULT NULL,
  `ScreenshotPath` text DEFAULT NULL,
  `CreatedBy` int(11) DEFAULT NULL,
  `gl_transaction_id` int(11) DEFAULT NULL,
  `UpdatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rate_payments`
--


--
-- Table structure for table `ratepayers`
--

CREATE TABLE `ratepayers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CouncilID` int(11) DEFAULT NULL,
  `RatepayerID` int(11) NOT NULL,
  `FullName` varchar(255) DEFAULT NULL,
  `PreviousOwner` varchar(255) DEFAULT NULL,
  `TINNumber` varchar(100) DEFAULT NULL,
  `Notes` text DEFAULT NULL,
  `IsDeceased` tinyint(1) DEFAULT 0,
  `IsOverseasOwner` tinyint(1) DEFAULT 0,
  `WorkPlace` varchar(255) DEFAULT NULL,
  `UpdatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ratepayers`
--


--
-- Table structure for table `receipts`
--

CREATE TABLE `receipts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) DEFAULT NULL,
  `receipt_number` varchar(100) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_method` varchar(50) DEFAULT NULL,
  `cashier_id` int(11) DEFAULT NULL,
  `session_id` int(11) DEFAULT NULL,
  `payer_name` varchar(255) DEFAULT NULL,
  `receipt_date` datetime DEFAULT NULL,
  `reference` varchar(255) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `receipts`
--


--
-- Table structure for table `reimbursement_claims`
--

CREATE TABLE `reimbursement_claims` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `claim_date` date NOT NULL,
  `description` text DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` enum('Pending','Approved','Rejected') DEFAULT 'Pending',
  `approved_at` datetime DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `reimbursement_claims`
--


--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `resources`
--


--
-- Table structure for table `review_cycles`
--

CREATE TABLE `review_cycles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `review_cycles`
--


--
-- Table structure for table `rfq_items`
--

CREATE TABLE `rfq_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rfq_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `unit_price` decimal(10,2) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rfq_items`
--


--
-- Table structure for table `rfqs`
--

CREATE TABLE `rfqs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `procurement_request_id` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `status` varchar(50) DEFAULT 'pending',
  `sent_at` datetime DEFAULT NULL,
  `due_at` datetime DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rfqs`
--


--
-- Table structure for table `roles_permissions`
--

CREATE TABLE `roles_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(100) NOT NULL,
  `inheritedFrom` varchar(100) DEFAULT NULL,
  `permissions` text NOT NULL,
  `createdBy` int(11) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles_permissions`
--

INSERT INTO `roles_permissions` VALUES
(1,'Super Admin',NULL,'{\"*\": [\"*\"]}',1,0,'2025-06-02 20:55:41'),
(2,'Procurement Manager',NULL,'{\n        \"procurement_requests\": [\"getAll\",\"create\",\"update\",\"delete\",\"approve\",\"reject\"],\n        \"purchase_requests\": [\"getAll\",\"create\",\"update\",\"delete\",\"approve\",\"reject\"],\n        \"rfqs\": [\"getAll\",\"create\",\"update\",\"delete\",\"approve\",\"close\"],\n        \"purchase_orders\": [\"getAll\",\"create\",\"update\",\"delete\",\"approve\",\"close\"],\n        \"goods_receipts\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"vendor_invoices\": [\"getAll\",\"create\",\"update\",\"delete\",\"approve\"],\n        \"vendors\": [\"getAll\",\"create\",\"update\",\"delete\"]\n    }',1,0,'2025-06-02 20:55:41'),
(3,'Finance Approver',NULL,'{\n        \"procurement_requests\": [\"getAll\",\"approve\"],\n        \"rfqs\": [\"getAll\",\"approve\"],\n        \"purchase_orders\": [\"getAll\",\"approve\"],\n        \"vendor_invoices\": [\"getAll\",\"approve\"]\n    }',1,0,'2025-06-02 20:55:41'),
(4,'CEO Approver',NULL,'{\n        \"procurement_requests\": [\"getAll\",\"approve\"],\n        \"rfqs\": [\"getAll\",\"approve\"],\n        \"purchase_orders\": [\"getAll\",\"approve\"],\n        \"vendor_invoices\": [\"getAll\",\"approve\"]\n    }',1,0,'2025-06-02 20:55:41'),
(5,'Employee',NULL,'{\n        \"disciplinary_cases\": [\"getById\"],\n        \"appeals\": [\"submit\",\"getById\"],\n        \"purchase_requests\": [\"getAll\",\"create\",\"update\"],\n        \"time_clocks\": [\"getAll\"],\n        \"payroll_periods\": [\"getAll\"]\n    }',1,0,'2025-06-02 20:55:41'),
(6,'HR Administrator',NULL,'{\n        \"attendance\": [\"getAll\",\"create\",\"update\",\"delete\",\"approve\",\"reject\"],\n        \"employees\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"employee_types\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"users\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"time_clock_locations\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"payroll\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"payroll_config\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"payslips\": [\"verify\"],\n        \"requisitions\": [\"getAll\",\"create\",\"update\",\"delete\",\"approve\",\"reject\"],\n        \"procurement_requests\": [\"getAll\",\"create\",\"update\",\"delete\",\"approve\",\"reject\"],\n        \"purchase_requests\": [\"getAll\",\"create\",\"update\",\"delete\",\"approve\",\"reject\"],\n        \"vendor\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"groups\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"user_group_memberships\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"group_permissions\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"training_courses\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"resources\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"locations\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"timeclocks\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"time_clocks\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"reports\": [\"company\",\"summaryToday\",\"absenteesToday\",\"locationAlerts\"],\n        \"performance_goals\": [\"*\"],\n        \"performance_reviews\": [\"*\"],\n        \"feedback_notes\": [\"*\"],\n        \"check_ins\": [\"*\"],\n        \"performance_dashboard\": [\"view\"]\n        \"reports\": [\"company\",\"summaryToday\",\"absenteesToday\",\"locationAlerts\"],\n        \"violation_types\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"disciplinary_cases\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"case_evidence\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"interview_logs\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"disciplinary_actions\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"appeals\": [\"getAll\",\"create\",\"update\",\"delete\",\"review\"],\n        \"ohs_actions\": [\"manage\"],\n        \"ohs_inspections\": [\"view\"],\n        \"ohs_regulations\": [\"manage\"]\n    }',1,0,'2025-06-02 20:55:41'),
(7,'Location Officer',NULL,'{\"*\": [\"*\"]}',1,0,'2025-06-02 20:55:41'),
(8,'HR Manager',NULL,'{\n        \"employee_exits\": [\"*\"],\n        \"exit_clearances\": [\"*\"],\n        \"exit_approvals\": [\"*\"],\n        \"exit_interviews\": [\"*\"],\n        \"exit_feedback\": [\"*\"]\n    }',1,0,'2025-06-02 20:55:41'),
(9,'Department Head',NULL,'{\n        \"employee_exits\": [\"*\"],\n        \"exit_clearances\": [\"*\"],\n        \"exit_approvals\": [\"*\"],\n        \"exit_interviews\": [\"*\"],\n        \"exit_feedback\": [\"*\"]\n    }',1,0,'2025-06-02 20:55:41'),
(10,'IT',NULL,'{\n        \"employee_exits\": [\"*\"],\n        \"exit_clearances\": [\"*\"],\n        \"exit_approvals\": [\"*\"],\n        \"exit_interviews\": [\"*\"],\n        \"exit_feedback\": [\"*\"]\n    }',1,0,'2025-06-02 20:55:41'),
(11,'Admin',NULL,'{\n        \"employee_exits\": [\"*\"],\n        \"exit_clearances\": [\"*\"],\n        \"exit_approvals\": [\"*\"],\n        \"exit_interviews\": [\"*\"],\n        \"exit_feedback\": [\"*\"]\n    }',1,0,'2025-06-02 20:55:41'),
(12,'Legal',NULL,'{\n        \"employee_exits\": [\"*\"],\n        \"exit_clearances\": [\"*\"],\n        \"exit_approvals\": [\"*\"],\n        \"exit_interviews\": [\"*\"],\n        \"exit_feedback\": [\"*\"]\n        \"reports\": [\"company\",\"summaryToday\",\"absenteesToday\",\"locationAlerts\"],\n        \"ohs_inspections\": [\"view\"]\n    }',1,0,'2025-06-02 20:55:41'),
(13,'Legal Admin',NULL,'{\"cases\": [\"*\"], \"matters\": [\"*\"], \"case_documents\": [\"*\"], \"case_events\": [\"*\"], \"case_communications\": [\"*\"], \"case_instructions\": [\"*\"]}',1,0,'2025-06-02 20:55:41'),
(14,'Finance Manager',NULL,'{\n        \"glaccounts\": [\"getAll\",\"create\",\"update\",\"delete\",\"toggle\"],\n        \"gltransactions\": [\"getAll\",\"create\",\"update\",\"delete\",\"import\",\"postBatch\",\"split\",\"parseText\"]\n    }',1,0,'2025-06-02 20:55:41'),
(15,'Accountant','Finance Manager','{\n        \"glaccounts\": [\"getAll\",\"update\"],\n        \"gltransactions\": [\"getAll\",\"create\",\"postBatch\",\"split\"]\n    }',1,0,'2025-06-02 20:55:41'),
(16,'Auditor',NULL,'{\n        \"glaccounts\": [\"getAll\"],\n        \"gltransactions\": [\"getAll\"]\n    }',1,0,'2025-06-02 20:55:41'),
(17,'Finance Officer',NULL,'{\n        \"properties\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"ratepayers\": [\"*\"],\n        \"property_rates\": [\"*\"],\n        \"rates_billing\": [\"generate\"],\n        \"rate_payments\": [\"create\"]\n    }',1,0,'2025-06-02 20:55:41'),
(18,'Council Clerk',NULL,'{\n        \"properties\": [\"getAll\",\"create\",\"update\",\"delete\"],\n        \"ratepayers\": [\"*\"],\n        \"property_rates\": [\"*\"],\n        \"rates_billing\": [\"generate\"],\n        \"rate_payments\": [\"create\"]\n    }',1,0,'2025-06-02 20:55:41'),
(19,'SuperAdmin',NULL,'{\"storage_connectors\": [\"*\"], \"documents\": [\"*\"], \"calendar_events\": [\"*\"], \"meetings\": [\"*\"]}',1,0,'2025-06-02 20:55:41'),
(20,'User',NULL,'{\"documents\": [\"getAll\",\"getById\",\"uploadVersion\"]}',1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `value` text NOT NULL,
  `category` varchar(50) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_unique` (`name`),
  KEY `company_idx` (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES
(1,'default_currency','FJD','finance',NULL,0,'2025-06-02 20:55:41'),
(2,'timezone','Pacific/Fiji','system',1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `shortlist_applications`
--

CREATE TABLE `shortlist_applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shortlist_id` int(11) NOT NULL,
  `application_id` int(11) NOT NULL,
  `comment` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `shortlist_applications`
--


--
-- Table structure for table `superannuation_settings`
--

CREATE TABLE `superannuation_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_rate` decimal(5,2) NOT NULL DEFAULT 0.00,
  `employer_rate` decimal(5,2) NOT NULL DEFAULT 0.00,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `superannuation_settings`
--

INSERT INTO `superannuation_settings` VALUES
(1,8.00,10.00,0,'2025-06-02 20:55:41');

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `item_name` varchar(100) DEFAULT NULL,
  `manager_id` int(11) DEFAULT NULL,
  `status` enum('pending','completed') DEFAULT 'pending',
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` VALUES
(1,2,'Submit project report',1,'pending',0,'2025-06-02 20:55:41'),
(2,3,'Client follow up',1,'completed',0,'2025-06-02 20:55:41');

--
-- Table structure for table `tax_brackets`
--

CREATE TABLE `tax_brackets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `min_income` decimal(10,2) NOT NULL,
  `max_income` decimal(10,2) DEFAULT NULL,
  `rate` decimal(5,2) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tax_brackets`
--

INSERT INTO `tax_brackets` VALUES
(4,0.00,30000.00,0.00,0,'2025-06-02 20:55:41'),
(5,30000.01,50000.00,18.00,0,'2025-06-02 20:55:41'),
(6,50000.01,270000.00,20.00,0,'2025-06-02 20:55:41'),
(7,270000.01,300000.00,33.00,0,'2025-06-02 20:55:41');

--
-- Table structure for table `tax_ledger`
--

CREATE TABLE `tax_ledger` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payroll_run_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `tax_type` varchar(50) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `ytd_total` decimal(10,2) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `run_idx` (`payroll_run_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tax_ledger`
--


--
-- Table structure for table `tax_settings`
--

CREATE TABLE `tax_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `value` varchar(100) NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tax_settings`
--

INSERT INTO `tax_settings` VALUES
(1,'federal_tax_rate','10',0,'2025-06-02 20:55:41'),
(2,'state_tax_rate','5',0,'2025-06-02 20:55:41');

--
-- Table structure for table `time_clock_locations`
--

CREATE TABLE `time_clock_locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `shape` enum('circle','polygon') DEFAULT 'circle',
  `center_lat` decimal(10,6) DEFAULT NULL,
  `center_lng` decimal(10,6) DEFAULT NULL,
  `radius_m` int(11) DEFAULT NULL,
  `polygon_points` text DEFAULT NULL,
  `assigned_to_type` varchar(50) DEFAULT NULL,
  `assigned_to_ids` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `time_clock_locations`
--

INSERT INTO `time_clock_locations` VALUES
(1,'Suva HQ','circle',-18.139800,178.426600,50,NULL,'location','1',0,'2025-06-02 20:55:41'),
(2,'Nadi Office','circle',-17.753300,177.443500,50,NULL,'location','4',0,'2025-06-02 20:55:41');

--
-- Table structure for table `time_clocks`
--

CREATE TABLE `time_clocks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `clock_type` varchar(50) NOT NULL,
  `lat` decimal(10,6) DEFAULT NULL,
  `lng` decimal(10,6) DEFAULT NULL,
  `valid_gps` tinyint(1) NOT NULL DEFAULT 0,
  `location_id` int(11) DEFAULT NULL,
  `locationApproved` tinyint(1) NOT NULL DEFAULT 0,
  `security_type` varchar(50) NOT NULL,
  `clocked_at` datetime DEFAULT current_timestamp(),
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2382 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `time_clocks`
--In another file

--
-- Table structure for table `training_certificates`
--

CREATE TABLE `training_certificates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `issued_at` date NOT NULL,
  `expires_at` date DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `training_certificates`
--


--
-- Table structure for table `training_courses`
--

CREATE TABLE `training_courses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `training_courses`
--


--
-- Table structure for table `training_enrollments`
--

CREATE TABLE `training_enrollments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL,
  `session_id` int(11) NOT NULL,
  `status` enum('Enrolled','Cancelled','Completed') DEFAULT 'Enrolled',
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `training_enrollments`
--


--
-- Table structure for table `training_results`
--

CREATE TABLE `training_results` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `enrollment_id` int(11) NOT NULL,
  `score` decimal(5,2) DEFAULT NULL,
  `completed` tinyint(1) DEFAULT 0,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `training_results`
--


--
-- Table structure for table `training_sessions`
--

CREATE TABLE `training_sessions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `training_sessions`
--


--
-- Table structure for table `user_2fa`
--

CREATE TABLE `user_2fa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `secret` varchar(255) DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT 0,
  `verified_at` datetime DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_2fa`
--

INSERT INTO `user_2fa` VALUES
(1,1,'SECRET1',0,NULL,0,'2025-06-02 20:55:41');

--
-- Table structure for table `user_auth_providers`
--

CREATE TABLE `user_auth_providers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `provider` varchar(100) DEFAULT NULL,
  `provider_user_id` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `profile_pic` text DEFAULT NULL,
  `linked_at` datetime DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_auth_providers`
--

INSERT INTO `user_auth_providers` VALUES
(1,1,'google','google-uid-1','admin@example.com','Test Admin',NULL,'2025-06-02 20:55:41',0,'2025-06-02 20:55:41');

--
-- Table structure for table `user_emails`
--

CREATE TABLE `user_emails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=399 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_emails`
--

INSERT INTO `user_emails` VALUES
(1,1,'admin@example.com',0,'2025-06-02 20:55:41'),
(159,159,'testnew@example.com',0,'2025-06-23 23:57:07'),
(204,204,'ksharma@baf.com.fj',0,'2025-06-24 00:56:23'),
(205,205,'rprasad@baf.com.fj',0,'2025-06-24 00:59:53'),
(206,206,'mohammed.istikar@baf.com.fj',0,'2025-06-24 01:01:23'),
(207,207,'wvulaono@baf.com.fj',0,'2025-06-24 02:07:01'),
(349,349,'atuisavusavu@baf.com.fj',0,'2025-06-24 03:37:53'),
(350,350,'tkarikaritu@baf.com.fj',0,'2025-06-26 03:02:13'),
(351,351,'mvubaya@baf.com.fj',0,'2025-06-26 03:08:41'),
(352,352,'rcsharma@baf.com.fj',0,'2025-06-26 03:10:11'),
(353,353,'yreddy@baf.com.fj',0,'2025-06-26 03:10:41'),
(354,354,'mifraaz@baf.com.fj',0,'2025-06-26 03:11:40'),
(355,355,'lqiqiwaqa@baf.com.fj',0,'2025-06-26 03:12:11'),
(356,356,'jmar@baf.com.fj',0,'2025-06-26 03:43:19'),
(357,357,'hbuksh@baf.com.fj',0,'2025-06-26 03:58:49'),
(358,358,'mhazelman@baf.com.fj',0,'2025-06-26 03:59:49'),
(359,359,'sreddy@baf.com.fj',0,'2025-06-26 04:00:19'),
(360,360,'pmeke@baf.com.fj',0,'2025-06-26 04:01:19'),
(361,361,'mvakadromusiga@baf.com.fj',0,'2025-06-26 04:02:49'),
(362,362,'sonamk@baf.com.fj',0,'2025-06-26 04:03:49'),
(363,363,'kvuniwaqa@baf.com.fj',0,'2025-06-26 04:04:19'),
(364,364,'hanrieta.yadraca@baf.com.fj',0,'2025-06-26 04:05:49'),
(365,365,'lnakuta@baf.com.fj',0,'2025-06-26 04:25:31'),
(366,366,'thedstrom@baf.com.fj',0,'2025-06-26 04:26:01'),
(367,367,'nirlesh_l@baf.com.fj',0,'2025-06-26 04:27:01'),
(368,368,'veniana_t@baf.com.fj',0,'2025-06-26 04:27:31'),
(369,369,'atuisavusavu@baf.com.fj',0,'2025-06-26 04:32:01'),
(370,370,'tuverea_t@baf.com.fj',0,'2025-06-26 04:33:01'),
(371,371,'rashnil.kumar@baf.com.fj',0,'2025-06-26 04:33:31'),
(372,372,'repeka.tukula@baf.com.fj',0,'2025-06-26 04:34:01'),
(373,373,'srasiga@baf.com.fj',0,'2025-06-26 04:34:31'),
(374,374,'lily.pickering@baf.com.fj',0,'2025-06-26 04:44:05'),
(375,375,'arieta.marawaqa@baf.com.fj',0,'2025-06-26 04:44:34'),
(376,376,'taina.mocemaiwaiyevo@baf.com.fj',0,'2025-06-26 04:45:34'),
(377,377,'ejames@baf.com.fj',0,'2025-06-26 04:46:05'),
(378,378,'spratap@baf.com.fj',0,'2025-06-26 04:46:34'),
(379,379,'cppo@baf.com.fj',0,'2025-06-26 04:47:35'),
(380,380,'iverlyn.maeta@baf.com.fj',0,'2025-06-26 04:48:04'),
(381,381,'cybexpte1@gmail.com',0,'2025-08-04 22:07:54'),
(382,382,'spatel@baf.com.fj',0,'2025-08-04 22:13:55'),
(383,383,'knaisaboca@baf.com.fj',0,'2025-08-04 22:23:34'),
(384,384,'ngasara@baf.com.fj',0,'2025-08-04 22:24:42'),
(385,385,'pdevi@baf.com.fj',0,'2025-08-04 22:26:14'),
(386,386,'vvarea@baf.com.fj',0,'2025-08-04 22:28:01'),
(387,387,'uraia_m@baf.com.fj',0,'2025-08-04 22:29:08'),
(388,388,'samuela.paula@baf.com.fj',0,'2025-08-04 22:30:03'),
(389,389,'nvalevatu@baf.com.fj',0,'2025-08-04 22:30:53'),
(390,390,'nbibi@baf.com.fj',0,'2025-08-04 22:31:21'),
(391,391,'jloiti@baf.com.fj',0,'2025-08-04 22:31:49'),
(392,392,'sakeasi_n@baf.com.fj',0,'2025-08-04 22:47:29'),
(393,393,'adi_r@baf.com.fj',0,'2025-08-04 22:48:40'),
(394,394,'usharma@baf.com.fj',0,'2025-08-04 22:49:21'),
(395,395,'ahafeez@baf.com.fj',0,'2025-08-04 22:50:02'),
(396,396,'Rahul_P@baf.com.fj',0,'2025-08-04 22:50:43'),
(397,397,'aminiasi.b@baf.com.fj',0,'2025-08-04 22:51:25'),
(398,398,'knaisaboca@baf.com.fj',0,'2025-10-02 02:48:35');

--
-- Table structure for table `user_group_memberships`
--

CREATE TABLE `user_group_memberships` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `role` varchar(100) DEFAULT NULL,
  `joined_at` datetime DEFAULT current_timestamp(),
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_group_memberships`
--

INSERT INTO `user_group_memberships` VALUES
(1,1,1,'Super Admin','2025-06-02 20:55:41',0,'2025-06-02 20:55:41'),
(2,6,1,'Location Officer','2025-06-02 20:55:41',0,'2025-06-02 20:55:41'),
(3,3,1,'Location Officer','2025-06-02 20:55:41',0,'2025-06-02 20:55:41'),
(4,4,1,'Location Officer','2025-06-02 20:55:41',0,'2025-06-02 20:55:41'),
(5,7,1,'Procurement Manager','2025-06-02 20:55:41',0,'2025-06-02 20:55:41'),
(6,8,1,'Finance Approver','2025-06-02 20:55:41',0,'2025-06-02 20:55:41'),
(7,9,1,'CEO Approver','2025-06-02 20:55:41',0,'2025-06-02 20:55:41'),
(8,8,1,'Finance Officer','2025-06-02 20:55:41',0,'2025-06-02 20:55:41'),
(9,9,1,'Council Clerk','2025-06-02 20:55:41',0,'2025-06-02 20:55:41'),
(10,2,2,'Finance Team','2025-06-02 20:55:41',0,'2025-06-02 20:55:41'),
(11,3,3,'Sales Team','2025-06-02 20:55:41',0,'2025-06-02 20:55:41');

--
-- Table structure for table `user_passkeys`
--

CREATE TABLE `user_passkeys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `credential_id` varchar(255) DEFAULT NULL,
  `public_key` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_passkeys`
--

INSERT INTO `user_passkeys` VALUES
(1,1,'cred1','publickeydata',NULL,0,'2025-06-02 20:55:41');

--
-- Table structure for table `user_phones`
--

CREATE TABLE `user_phones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `phone_number` varchar(50) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_phones`
--

INSERT INTO `user_phones` VALUES
(1,1,'+1-555-2001',0,'2025-06-02 20:55:41');

--
-- Table structure for table `user_settings`
--

CREATE TABLE `user_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `value` text NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_setting_unique` (`user_id`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_settings`
--

INSERT INTO `user_settings` VALUES
(1,1,'theme','modern-blue',0,'2025-06-22 21:05:43');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `locations` varchar(255) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=399 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES
(1,'Test Admin','$2y$10$PXEdpEbxI5c11/tC3UdC6OrZr7V2MsHAatf5C6LRzRV/goxQDPTl.',NULL,NULL,0,0,'2025-06-02 20:55:41'),
(159,'Test Account','$2y$10$WpHcYP8A/Rf0kEI7Pf6aje/hOfrPqTOKb4dswYDXtQ0RkcOcR.jpm',NULL,NULL,0,0,'2025-06-23 23:57:07'),
(160,'Kritesh Sharma - BN252','$2y$10$8ZQmySwMj00liJHuVHuhmudHJm/yMawaLHb4EsT8Vy06PUZSYrSgK',NULL,NULL,0,0,'2025-06-24 00:30:18'),
(161,'Haroon Buksh - BN267','$2y$10$daaRqIm5xJEndXsX9buAx.4Qy7OhtPyX1o3FkkTrkecgQy5Im1/FS',NULL,NULL,0,0,'2025-06-24 00:30:19'),
(162,'Mereseini Tawakilai Vubaya - BN197','$2y$10$MoM9vJ7UhkPnmDdEjZf5S.OW1Cpy4MfBfHzFQST79.PnpnMq8l3zS',NULL,NULL,0,0,'2025-06-24 00:30:19'),
(163,'Lora Eta Qiqiwaqa - BN246','$2y$10$aqV4EcYkT2Av4SMIB4CS7eyoQlcyIegx9uVyLAGvPQebP540YiuHe',NULL,NULL,0,0,'2025-06-24 00:30:19'),
(164,'Mereseini Tawakilai Vubaya - BN197','$2y$10$NDUynqYtskSLJDs1oIJcsun6cqThHgZ9f6iFAqL3Iphc4PlMoBe5W',NULL,NULL,0,0,'2025-06-24 00:30:48'),
(165,'Lora Eta Qiqiwaqa - BN246','$2y$10$C8tbLGjhDLANnzkx8AnXju.boKHgKw/mYPh1Um1j21O4ovkZnk1MS',NULL,NULL,0,0,'2025-06-24 00:30:49'),
(166,'Mereseini Tawakilai Vubaya - BN197','$2y$10$D56ug26Hx8RpOW6e57.3o.L2joeTRtN35XlKRMhjINvjBHTGKQHiq',NULL,NULL,0,0,'2025-06-24 00:31:40'),
(167,'Lora Eta Qiqiwaqa - BN246','$2y$10$8KxBm2vcAvB8npxK9DzR8uA5Nowy8OMFRlxKOJfZClT14uNZdxqAi',NULL,NULL,0,0,'2025-06-24 00:31:40'),
(168,'Mereseini Tawakilai Vubaya - BN197','$2y$10$68jvKdnkCVSwQE.vlpJ3ZO2uRgcQEiYZZkqsACXA9ES1T0.6HXOeC',NULL,NULL,0,0,'2025-06-24 00:32:11'),
(169,'Lora Eta Qiqiwaqa - BN246','$2y$10$kYeQ/CElSP6241gYLTK80eo3aQPOvBFBH5QdtSpDqw56.FlHwU3cO',NULL,NULL,0,0,'2025-06-24 00:32:12'),
(170,'Mereseini Tawakilai Vubaya - BN197','$2y$10$09LQVUPZvaZFRrcIGuOTJuX8JvIEpC2MvL1oP68opI13EGfogLUY.',NULL,NULL,0,0,'2025-06-24 00:32:40'),
(171,'Lora Eta Qiqiwaqa - BN246','$2y$10$i8tnvvigDmNtALFTjvLZ5eFSOWTg4Pk2gt7TiEV5CuCtGlJXq83lW',NULL,NULL,0,0,'2025-06-24 00:32:40'),
(172,'Mereseini Tawakilai Vubaya - BN197','$2y$10$.6PUAaz7mk8sjblfgU3j9O.gJbX3OuWpwpC2eS9lf5RVB.wCSU7jy',NULL,NULL,0,0,'2025-06-24 00:33:28'),
(173,'Lora Eta Qiqiwaqa - BN246','$2y$10$dfRjtN1YNBZ8bBNN4Q5Mme2L5bGbmNpRyJ644BhtKJxL.OLLjt1na',NULL,NULL,0,0,'2025-06-24 00:33:28'),
(174,'Mereseini Tawakilai Vubaya - BN197','$2y$10$QbmK/8sVRcA28R1NY9S8nOoNDqXIuh8wnw5OgKZ81tQl4Glc7nr8e',NULL,NULL,0,0,'2025-06-24 00:33:44'),
(175,'Lora Eta Qiqiwaqa - BN246','$2y$10$6BRLGO2inKpKOMJJ4F32eOdBfBsBubEILKYQ.HJPcICVJk4KDykaS',NULL,NULL,0,0,'2025-06-24 00:33:44'),
(176,'Mereseini Tawakilai Vubaya - BN197','$2y$10$ZyDvuGV3pS40mHmDnmzF8OiU7wPEhA0UoTK0oadRR35DmzD9JI5hW',NULL,NULL,0,0,'2025-06-24 00:34:14'),
(177,'Lora Eta Qiqiwaqa - BN246','$2y$10$u5CGrSj54kqjdinipPaNGOqJ7bCZINOZbR3BHuHhEufhPqQ0WxyuG',NULL,NULL,0,0,'2025-06-24 00:34:15'),
(178,'Mereseini Tawakilai Vubaya - BN197','$2y$10$nZ4pRHhF4EsaBR.N2HwsLeeUlZOTj5ZIKeOvjz2kO/VYdOZoaRiPK',NULL,NULL,0,0,'2025-06-24 00:34:40'),
(179,'Lora Eta Qiqiwaqa - BN246','$2y$10$1PLcm2SCqf3wlhAbXMRo9eHGMS3100z8m31oP3Stm4AVRaYFyMf6O',NULL,NULL,0,0,'2025-06-24 00:34:40'),
(180,'Mereseini Tawakilai Vubaya - BN197','$2y$10$W3ef7ANRB4wL5N8lg3GNCuv4LhWRYxHe/c7YSG9jvWv.FO.SLLb8C',NULL,NULL,0,0,'2025-06-24 00:36:40'),
(181,'Lora Eta Qiqiwaqa - BN246','$2y$10$2ZVs0KL1gHqrpLRDhDiAuO35/Ef2D2BVpdLHo3M88Jjt3hjQTjChS',NULL,NULL,0,0,'2025-06-24 00:36:40'),
(182,'Mereseini Tawakilai Vubaya - BN197','$2y$10$0YxY6biB0RciCxf2B7oOQOlCy.zYg7uQ1.FET/czyfVKV1Vdyn0OK',NULL,NULL,0,0,'2025-06-24 00:37:54'),
(183,'Lora Eta Qiqiwaqa - BN246','$2y$10$44pcGvQ4u9Ml/6SGivCz0eVQrJf1gO77b0IwuVT3rtyHEYdO5l0s.',NULL,NULL,0,0,'2025-06-24 00:37:55'),
(184,'Mereseini Tawakilai Vubaya - BN197','$2y$10$8as6hUD3P6tfXD75wRy1rum4WJ/ueRcRZu1nk9jWAYGxIMBSjfXgG',NULL,NULL,0,0,'2025-06-24 00:38:54'),
(185,'Lora Eta Qiqiwaqa - BN246','$2y$10$IEX/lj4lMw8zsuntffm0YugMlXD29eBkS76Z8WL.JWpGF1wbKwGuO',NULL,NULL,0,0,'2025-06-24 00:38:54'),
(186,'Mereseini Tawakilai Vubaya - BN197','$2y$10$HfwxwHjxw8OBPn2U0GwpIOCdi6SDnCyxyC4L45cbxXuEWagjgciqO',NULL,NULL,0,0,'2025-06-24 00:39:54'),
(187,'Lora Eta Qiqiwaqa - BN246','$2y$10$ooM92UEh6Uy8rS5r71iG/uGEmheuTxkPaxJlsRoPcVq.uNn0C5r1O',NULL,NULL,0,0,'2025-06-24 00:39:54'),
(188,'Mereseini Tawakilai Vubaya - BN197','$2y$10$XJrZIfsYfyU9iKqzR1h.WOLXVJTLjwZOGRBjW7y4n7FrQuTWjVApi',NULL,NULL,0,0,'2025-06-24 00:41:13'),
(189,'Lora Eta Qiqiwaqa - BN246','$2y$10$WA3iXe2nPLtraMJ180HSsemhlmGOCfs7p.vhnKUJJsxk/eExmgcOW',NULL,NULL,0,0,'2025-06-24 00:41:14'),
(190,'Mereseini Tawakilai Vubaya - BN197','$2y$10$IE6iJLsZ07ck0ZOp/I0BPeuoqH.5xOkjzfuZBbAOO285AYRmwOj3a',NULL,NULL,0,0,'2025-06-24 00:44:43'),
(191,'Lora Eta Qiqiwaqa - BN246','$2y$10$.zmTTa/hAAK4GEyUOh8mTOEsZiuhCA1uMjr109npd1JWv8jsByf/S',NULL,NULL,0,0,'2025-06-24 00:44:44'),
(192,'Mereseini Tawakilai Vubaya - BN197','$2y$10$6Aa64oDm36656X7IEZ9hWeSAGMRzgu7uGvH3q7O9gJFa1LA0de0pe',NULL,NULL,0,0,'2025-06-24 00:45:43'),
(193,'Lora Eta Qiqiwaqa - BN246','$2y$10$VknhQKId7IcjAt/OyUb1k.wA0Dyzycf5cyoltYX11t3ruUlCNvu6q',NULL,NULL,0,0,'2025-06-24 00:45:44'),
(194,'Mereseini Tawakilai Vubaya - BN197','$2y$10$RUVQxs4enelyxl1/ZZb92.U5Nq0pTdLlvE8NdhT1rOILoO2fbBKsS',NULL,NULL,0,0,'2025-06-24 00:46:43'),
(195,'Lora Eta Qiqiwaqa - BN246','$2y$10$uwQFCIhDTGUppPuY4H2fNuSUPh/bIMFdupp3AslZJ6QQ2sALKDazC',NULL,NULL,0,0,'2025-06-24 00:46:44'),
(196,'Mereseini Tawakilai Vubaya - BN197','$2y$10$/8eeDljnYmXZ9D92rzRy3ebFSAluTXb7iLRhB.gjpLoqzRIBJUfDq',NULL,NULL,0,0,'2025-06-24 00:47:43'),
(197,'Lora Eta Qiqiwaqa - BN246','$2y$10$KS0NuadvAphrHzZpnYM8Xerq.tlY8bjiSOofkyCfJetmyvVUlX9pq',NULL,NULL,0,0,'2025-06-24 00:47:44'),
(198,'Mereseini Tawakilai Vubaya - BN197','$2y$10$uJUkzhtv/dy107WHz7yp1egReBYjeatn3KvQ/pS8c3MfZNnSS2CsK',NULL,NULL,0,0,'2025-06-24 00:48:43'),
(199,'Lora Eta Qiqiwaqa - BN246','$2y$10$bg0u2eTDDkWdil4qS5C23.1SJGNJqtaWhOIoR3xWhu3DtA/80iNVW',NULL,NULL,0,0,'2025-06-24 00:48:44'),
(200,'Mereseini Tawakilai Vubaya - BN197','$2y$10$Ldxz2l5qKmR4M75mHFeQq.sD5vV2j66bhRcFte2b/VIZY6K1pB.Ii',NULL,NULL,0,0,'2025-06-24 00:49:43'),
(201,'Lora Eta Qiqiwaqa - BN246','$2y$10$MzG7oie9VaZNppWCDwsMUOUEg/Khl75jpVbBL2gDpsnG3P4Ed/7UK',NULL,NULL,0,0,'2025-06-24 00:49:44'),
(202,'Mereseini Tawakilai Vubaya - BN197','$2y$10$nA68DTuuXdZW7RL7BJHwtucTvvHwfhLuT5J7eYDNU06rWSrWLjqQm',NULL,NULL,0,0,'2025-06-24 00:50:25'),
(203,'Lora Eta Qiqiwaqa - BN246','$2y$10$VttA/9DVTwv.Fag9tf4uvuH97ztM/ryWaqv2GGlBZZ/U79.7JPkoO',NULL,NULL,0,0,'2025-06-24 00:50:26'),
(204,'Kritesh Sharma - BN252','$2y$10$0WeInx.Rynq7etQpyxrloOqEMe4duzKdaylEUDGO7A3Tfr2aBofuq',NULL,NULL,0,0,'2025-06-24 00:56:23'),
(205,'Ronald Prasad - BN029','$2y$10$A1JH77Hex4C8jNU.FT9UneVUvbEPwFgJ3LI3TIjYCuL0aLcfvu3P2',NULL,NULL,0,0,'2025-06-24 00:59:53'),
(206,'Mohammed Istikar - BN610','$2y$10$Ls5j1k8YkSkUpy7QR6lP6.6nbnyB8dgnuWboxOUu607j3FMPsDysW',NULL,NULL,0,0,'2025-06-24 01:01:23'),
(207,'Walesi Vulaono Soro - BN031','$2y$10$R4fKiESIhJL5.M12lKJmiuGpzhafYG/cgl2UMpb2No1NRsL6FImwi',NULL,NULL,0,0,'2025-06-24 02:07:01'),
(208,'Tevita Tuikubulau Karikaritu','$2y$10$1HaOFlcEfW3biY4Jr0Rix.WjbvYn5ogdo4IuJyfZ58md2YtcC5REa',NULL,NULL,0,0,'2025-06-24 02:09:31'),
(209,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$3mhmTxtQWWZ/n9h9Bwth4u67iOlUk9LImM7aI21Qk5AY/G.gxVJ.K',NULL,NULL,0,0,'2025-06-24 02:10:31'),
(210,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$9ZpPoFR4erHbixW7Dk15u.BFS4E0dCM9DRbs02sms4MjiFT1ohEIi',NULL,NULL,0,0,'2025-06-24 02:11:31'),
(211,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$YLsib26jvh/aunEXMoarv.bAcMVnNhb28oIIYCR/cTB/WPE3QGJEu',NULL,NULL,0,0,'2025-06-24 02:12:31'),
(212,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$jmRVWgyEDpx2z7/jitNM4uCGehHB3jPcAkwEe1mZ8Ojau1zpbAfS2',NULL,NULL,0,0,'2025-06-24 02:13:32'),
(213,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$jf7/wAbQbPGShEktST/9yesvARFqrl9bfSRuH1g7OiNZ02eBNOZAq',NULL,NULL,0,0,'2025-06-24 02:15:10'),
(214,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$NA5hsgEZeyW/4On4sUOtxOG93ZmhtR/Su1xfxbACfLh0gpMHA9YbC',NULL,NULL,0,0,'2025-06-24 02:16:01'),
(215,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$M4DS2lrriRU.209U34IYfu7YNS/HbijiGzihn0yvQPwxzfXolbGT6',NULL,NULL,0,0,'2025-06-24 02:17:01'),
(216,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$DlglT88IJOlvsjRv8/g2m.8c93UMTUc7WxKrS64zYXieDZ6xuN8xS',NULL,NULL,0,0,'2025-06-24 02:18:01'),
(217,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$8gymkSx7K.HJOui1Nw3G4ORNmLVgEDWLXS06p3AtWK.NWlRTabV42',NULL,NULL,0,0,'2025-06-24 02:19:01'),
(218,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$8USSPbAPf8WzG3MwFGleCu3TefRvKtsxmHY2iCkG9zK/igjJbWRLy',NULL,NULL,0,0,'2025-06-24 02:20:02'),
(219,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$l1F031o7m6yRA6gJWRA0zOh/nyZvp5SOfOaxsoaDXxaZr/8xjAku.',NULL,NULL,0,0,'2025-06-24 02:21:01'),
(220,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$w1iYjXBrQVJpcaxf5hEEDOVv1ojALPRGZYuG0G5KtR0B/42i.8psa',NULL,NULL,0,0,'2025-06-24 02:22:01'),
(221,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$6XTP3rgJXeZxAvEqc6u.e.7tO5lVve9NaSK36YAPNY0Cri7L612ki',NULL,NULL,0,0,'2025-06-24 02:23:01'),
(222,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$ttcKCaYqulN6j/gRsACvZequBIYomAuiT7a1jzo4Lz3nHNb/T2VaW',NULL,NULL,0,0,'2025-06-24 02:24:01'),
(223,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$bsnt4OBygF.G72zYuLDS3OP2fbRX71pVU8cfi4dqTUClWgpKRFDze',NULL,NULL,0,0,'2025-06-24 02:25:01'),
(224,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$nJ5XcdFhFDPI3OXyNXf1.OcsohqKCPINURFB6s0J10f812rgPXCcO',NULL,NULL,0,0,'2025-06-24 02:26:01'),
(225,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$73HRYexqlKy/GIvY3rmZJeBFNMqerCNwDAuvQqchmeqSJs9utOe56',NULL,NULL,0,0,'2025-06-24 02:27:01'),
(226,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$NJgbC0aVmRodm4wHrwVO1.A3MK1IJaNdu9booNFRNszDXWrO5YDyO',NULL,NULL,0,0,'2025-06-24 02:28:01'),
(227,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$RGhhgxACjppyWXK13eLs8.w6e2sj.KeAJ.UYm5yY6MM2BLGbIhvym',NULL,NULL,0,0,'2025-06-24 02:29:01'),
(228,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$i.8HRs42/LTMsTSnclir5eR5qASjHK3q2Z7IOMsdTy6eTjH5F1bXm',NULL,NULL,0,0,'2025-06-24 02:30:01'),
(229,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$TDT0SAKOdbJBNH.ODTPO/uuJ74bhkotBD8Q8h5u5HZDAjhjldOIy6',NULL,NULL,0,0,'2025-06-24 02:31:02'),
(230,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$aQ2lT1pR8rEogMete4oQqeRvjtkkp.uVN06rekjBP5fsOFqIIyA9i',NULL,NULL,0,0,'2025-06-24 02:32:40'),
(231,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$FVXYXNHPkbl4kYig6CKyfuJvRUKANlD85VUHxgaR0Wj/W80LCNMZC',NULL,NULL,0,0,'2025-06-24 02:34:00'),
(232,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$dUVmxzIEucia5e76dnxZGe0td4rKpWYMymUecVy/iMHOImyYQ8iLi',NULL,NULL,0,0,'2025-06-24 02:35:01'),
(233,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$wziTakKYLNH5zkEKsVhLleW/TF.GTsnSVjvJ8wxW8Rr/oTG5xwiC6',NULL,NULL,0,0,'2025-06-24 02:36:01'),
(234,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$kDcDmYyPI/9mxabtc.KHROZTzaeSDP0fwoGnzmBaSz7W1bYF/ydSm',NULL,NULL,0,0,'2025-06-24 02:37:01'),
(235,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$Yh/4xk9xqvSi5BtljXGczu8FbKWODC/Fdh584OvYoZouXAS2h.CdK',NULL,NULL,0,0,'2025-06-24 02:38:01'),
(236,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$brzbGtn1nSoRfpZkZevVTOYxoglHbkDhMW3GwNGyR6264tcTiLw92',NULL,NULL,0,0,'2025-06-24 02:39:01'),
(237,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$UbcKIw8.1HJ7O3ZUcWzNuOv3Qpr.GZwPE0WJAMLa8aFUS28GcEW3y',NULL,NULL,0,0,'2025-06-24 02:40:01'),
(238,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$MgxMOiWwGggSfxin4oe/u.GwdHH1vqGCLtaBAQKWnKW3UI1IVp1Fe',NULL,NULL,0,0,'2025-06-24 02:41:01'),
(239,'Aminio Tuisavusavu - BN536','$2y$10$e7vjPOcbOuYne/guQGlN6eNuRyqt.sQjsBsHV/i9uUVDZ3WQWMPdq',NULL,NULL,0,0,'2025-06-24 02:41:11'),
(240,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$2gArteAX9Q0tElGZZ9KEaehvcOkf9V4l8fI/ariTXaNxVP4Q7pQn6',NULL,NULL,0,0,'2025-06-24 02:42:01'),
(241,'Aminio Tuisavusavu - BN536','$2y$10$GnTheOMe4WKkNqHIwR2mxuaFI/CFDXw8L0.ySJzkNl6Iel3tchOjG',NULL,NULL,0,0,'2025-06-24 02:42:10'),
(242,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$Juv7COO9wb5TbsSr6hiaieIWPh6P.WbT5M3CxhANVNvjODVSv68C2',NULL,NULL,0,0,'2025-06-24 02:43:01'),
(243,'Aminio Tuisavusavu - BN536','$2y$10$nZd9O/XC2Pm60BOYF9DFvOjP8qji736kUiSHcS8.UvQod.skZw2iu',NULL,NULL,0,0,'2025-06-24 02:43:10'),
(244,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$Dbvtl53VlyGXrfxDPP66y.wWfGyuguPCc.Ed9XRVVJP.qimx6Bjhq',NULL,NULL,0,0,'2025-06-24 02:44:02'),
(245,'Aminio Tuisavusavu - BN536','$2y$10$cg2x77UyJRxxarPQRsvTDuAjINQxKiK9xu41onuFkxZw.IT77F7ze',NULL,NULL,0,0,'2025-06-24 02:44:13'),
(246,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$.i12q9eYcMhfDLrS8lhvqO2UM25Ho1GY/sLP2lAUwrH2BNV7kPqdC',NULL,NULL,0,0,'2025-06-24 02:45:01'),
(247,'Aminio Tuisavusavu - BN536','$2y$10$Q1QDHR9yAEMbFYDKNLqr.O/LEDD8F/K/De038MV1t0zrNecgf1h/6',NULL,NULL,0,0,'2025-06-24 02:45:10'),
(248,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$.T39MApcI8BJLhYvaujPZOrWa72UTfVzSO4TKbN9Ugk38LDVI7VSq',NULL,NULL,0,0,'2025-06-24 02:46:00'),
(249,'Aminio Tuisavusavu - BN536','$2y$10$sGjy2LpJO1uzWUgb0pa8O.L1mC5gDLWZlg7jsEeCx8wr7di/LOPgS',NULL,NULL,0,0,'2025-06-24 02:46:09'),
(250,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$JO6F6IJ9fSQNpkFUv52xu.jImM6pY.1h2oQNQ2KsLpzqMdsasKxsG',NULL,NULL,0,0,'2025-06-24 02:47:01'),
(251,'Aminio Tuisavusavu - BN536','$2y$10$LXQLh8EZNL673xCqpDQvoetjDbvMLqUWoV5iaQXEnf1RKnb4XgVly',NULL,NULL,0,0,'2025-06-24 02:47:10'),
(252,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$JJZE5Y3C9Gke/L605IwyO.TAclEp9zj1sGeu8xWZD9WfufmCl5y6i',NULL,NULL,0,0,'2025-06-24 02:48:01'),
(253,'Aminio Tuisavusavu - BN536','$2y$10$YQaViIWRw.o.IdngkL8vU.kwYYkkhPWFhN2LOyhK68iDjff7rJwTS',NULL,NULL,0,0,'2025-06-24 02:48:10'),
(254,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$2XyG93acltXdCoqPAaOvqOWSHPKo.03sUzCoMiiaHRmxNRCw.wxgW',NULL,NULL,0,0,'2025-06-24 02:49:01'),
(255,'Aminio Tuisavusavu - BN536','$2y$10$/lcPF9lnIqfCVQFgS2jKLOthObQG4VfXT2x86oi90VCD9UsNwgiDe',NULL,NULL,0,0,'2025-06-24 02:49:10'),
(256,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$RmSQFQlKQTupgvEF1Iio.e1hM7yqCLwcZHyBg1w0bf5dNQN93sRiu',NULL,NULL,0,0,'2025-06-24 02:50:00'),
(257,'Aminio Tuisavusavu - BN536','$2y$10$Jv.O.vquSd44waG6gfDTV.DGvwWKgN7.ZtawBtHVce126EL2W2fxO',NULL,NULL,0,0,'2025-06-24 02:50:09'),
(258,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$iiAdjQ3Ujtbe3Q7WRD1tfeZDvlKtoKFWy6F96xh/N1RNT2BbFe/zK',NULL,NULL,0,0,'2025-06-24 02:51:00'),
(259,'Aminio Tuisavusavu - BN536','$2y$10$yiQWT/0164g4BdMVbBdff.VQ7Wmj0W7OrfUG9QrvAA42VBYxfmxni',NULL,NULL,0,0,'2025-06-24 02:51:12'),
(260,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$lvwKOLcBDNAORM0oNYDtaO91X3GKP.dXzilbpd0S5IXk4YXpQ68x.',NULL,NULL,0,0,'2025-06-24 02:52:00'),
(261,'Aminio Tuisavusavu - BN536','$2y$10$9bb4gx9amYthZ846ZYaSy.o9gA5xCjeBo9pWm.KHUbGQ4i9LqvHnG',NULL,NULL,0,0,'2025-06-24 02:52:09'),
(262,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$0SMMaDAdTurqjbtrtgrvP.guYLWgPQGM6q5JnHKn0tJBQt.aBUfVu',NULL,NULL,0,0,'2025-06-24 02:53:00'),
(263,'Aminio Tuisavusavu - BN536','$2y$10$sNw8PtTa4jrkSMqNZndCBu4spUMWIKijJnQs/lrvNJv3e23xGwF0S',NULL,NULL,0,0,'2025-06-24 02:53:09'),
(264,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$CJT9vCN43iIDHXFYfmyHmut/aZ2UtS9TvEp5zbhLAg5KYMdC48DHS',NULL,NULL,0,0,'2025-06-24 02:54:00'),
(265,'Aminio Tuisavusavu - BN536','$2y$10$wU5NKMLJoNxksi76j0mTP.7QDmhncTawtOKFHkIv9482cSYp2105u',NULL,NULL,0,0,'2025-06-24 02:54:09'),
(266,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$B9.0jdWAlvwsdDh6ceeajOS24QMgRqDDoBVjnj4doQTUzdsIg.GQ6',NULL,NULL,0,0,'2025-06-24 02:55:00'),
(267,'Aminio Tuisavusavu - BN536','$2y$10$vLdrUxd/qZ1.e0RXclmW..ZuUsMNfMwieHxbYLNhBqiqriUm2K2ti',NULL,NULL,0,0,'2025-06-24 02:55:09'),
(268,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$s6tSZvRgGGAWff8MxGygHeSEkih8eyEfd7E.78tZxKf2bPI25v7Ci',NULL,NULL,0,0,'2025-06-24 02:56:00'),
(269,'Aminio Tuisavusavu - BN536','$2y$10$IMdWYPI2DfSluLpcA3sRaebbruzDb/4U1GsAGOHPIlE3Fd21wQtSO',NULL,NULL,0,0,'2025-06-24 02:56:09'),
(270,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$Zd/s9AOq8x7VPIl865bhY.9efLVky2QXxsVOTB58VFrhMShljYYUm',NULL,NULL,0,0,'2025-06-24 02:57:01'),
(271,'Aminio Tuisavusavu - BN536','$2y$10$uqC0AvKxdrCgz6axTm7bYuM9ef30CPbHn59FeI8CEjWc6yyxx/Mia',NULL,NULL,0,0,'2025-06-24 02:57:10'),
(272,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$KILnBOikpZ.JYNwkZ5R35.du8GDpQm.O3H71wXmDeZzmO8ZZGALcC',NULL,NULL,0,0,'2025-06-24 02:58:00'),
(273,'Aminio Tuisavusavu - BN536','$2y$10$XMJJjZhNVYUgeZl5yg29e.5kaodGCfgiclJG6Sx5XY1xuB63s1Avm',NULL,NULL,0,0,'2025-06-24 02:58:09'),
(274,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$/svboeJqXd98ynhycrXUAu9bNHv0WSgxGu6IFTWlzZPBoSymBVSUa',NULL,NULL,0,0,'2025-06-24 02:59:00'),
(275,'Aminio Tuisavusavu - BN536','$2y$10$pIQqPwH4juFWaJHcXiXBO.jZgsEPO4IblnlPiD1bDsOlgybopkAfS',NULL,NULL,0,0,'2025-06-24 02:59:09'),
(276,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$Nhkza6aVP/KtnFIh5V5M9eyFj.X3Tbuz19Rp7jeWJLgvzMnn06zAu',NULL,NULL,0,0,'2025-06-24 03:00:00'),
(277,'Aminio Tuisavusavu - BN536','$2y$10$jEc/aFXGIFlCFuVv6GaHfuPZ5UsMdjSu7f6ZSCrO3fZYzY3.mH6Wq',NULL,NULL,0,0,'2025-06-24 03:00:09'),
(278,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$3gyPS97tTdRB39eipy4MV.pjKOqfg5UUT83EobLKVcKtNoqzWwJuG',NULL,NULL,0,0,'2025-06-24 03:01:00'),
(279,'Aminio Tuisavusavu - BN536','$2y$10$h4lL0Dw0Kb4dth4dOEyH1.mNejOr3tOuEwj8gQa3y1YzeQrtWu5BG',NULL,NULL,0,0,'2025-06-24 03:01:09'),
(280,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$/A1e8bcJeiqtiCq.rMy8KuRvrVnjq.Vb4NN3V/K.zWGuGkEYiXvp.',NULL,NULL,0,0,'2025-06-24 03:02:00'),
(281,'Aminio Tuisavusavu - BN536','$2y$10$duHXSE7Skj9GXJ7VUzh7/.p0JcgfbxiEb1dhT1Md6ME5dIZlq0iZq',NULL,NULL,0,0,'2025-06-24 03:02:09'),
(282,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$eLtzM9S0CFnpb6joQwvBC.DaDOdeNuxHrcIPK24JSbAkn76BeO1Za',NULL,NULL,0,0,'2025-06-24 03:03:00'),
(283,'Aminio Tuisavusavu - BN536','$2y$10$QivsqmQ0khwrSigaGX7eNu37VaKfSsOkAJ2udMDF7ezh77LgGNNKq',NULL,NULL,0,0,'2025-06-24 03:03:09'),
(284,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$FbtlqTrCQPtdmpsfrsd9xuKhoEwdyv8sR1u3R3H/LLdlfD2RY3FnK',NULL,NULL,0,0,'2025-06-24 03:04:00'),
(285,'Aminio Tuisavusavu - BN536','$2y$10$2cmi4ZO0tvih84IwBCxMQOAtSbnsG0zP3efrorOEBev5VEfscBF3.',NULL,NULL,0,0,'2025-06-24 03:04:09'),
(286,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$naxr0uHbBh99LX6XIhqKIOi6LfE7omF9pMn7n1dM3nRpC2Blbs8jm',NULL,NULL,0,0,'2025-06-24 03:05:00'),
(287,'Aminio Tuisavusavu - BN536','$2y$10$jerArpxIoiBlM0Xgnu1sx.cf/J0kgz/PTa55YVdokyjZyZtsW3C4i',NULL,NULL,0,0,'2025-06-24 03:05:09'),
(288,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$RrSegTZIE9UKtNeRP67Bxe5Kj1/s0L7rvj4uOttFR67zpNTUJbcMy',NULL,NULL,0,0,'2025-06-24 03:06:00'),
(289,'Aminio Tuisavusavu - BN536','$2y$10$MJVXQLJ4SbjYdk6tnIkI.elVFNZznge0f.yB9f/dSkfrnJy.d1upO',NULL,NULL,0,0,'2025-06-24 03:06:10'),
(290,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$MqC8tsBqsnKI03n48HG8nudnaUyJ9uGFcyD6msRzYX7zgsGZpWq1y',NULL,NULL,0,0,'2025-06-24 03:07:00'),
(291,'Aminio Tuisavusavu - BN536','$2y$10$FBTHNooM10Jd4OsLRI6U/OPeWZ2wERgXbkX4fkWsD80HxSi14zK9y',NULL,NULL,0,0,'2025-06-24 03:07:09'),
(292,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$xD./flEXcpp3F./RCButW.ZLVMRoVBFqpKOIdmt/CslrKwVyhOvra',NULL,NULL,0,0,'2025-06-24 03:08:00'),
(293,'Aminio Tuisavusavu - BN536','$2y$10$X.btetKo15F4dhb4RGtOJe2GrwYNPGRhtf64h/ArJX1Bapt.eNlZe',NULL,NULL,0,0,'2025-06-24 03:08:09'),
(294,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$apdrmERjE3/S73EjZ57pQ.OB2W9OKfn3tGIpaI2gDENFDUG563IiC',NULL,NULL,0,0,'2025-06-24 03:09:01'),
(295,'Aminio Tuisavusavu - BN536','$2y$10$8gGUiMsXVmqLglaN2koZne151Z5K0aTr/znbyZBp8OSm1lpp3j1Cq',NULL,NULL,0,0,'2025-06-24 03:09:10'),
(296,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$G3HdebLfWCHbR9f20PjEqeCXqUpPGYPqwYSBrG0evw/mQ0FLyh4fC',NULL,NULL,0,0,'2025-06-24 03:10:00'),
(297,'Aminio Tuisavusavu - BN536','$2y$10$slUoVbYaP10QjPWbmEGvm.RL0uHSNArnQP.1s8624KxCM5ogsRwUK',NULL,NULL,0,0,'2025-06-24 03:10:09'),
(298,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$c4Z3oqRTww5RtxFdbGrMZe4X31Nij3XdIuZmPecflDlgl57lSgHDC',NULL,NULL,0,0,'2025-06-24 03:11:00'),
(299,'Aminio Tuisavusavu - BN536','$2y$10$CtXAoEBhsXiR.rbjtNZcSeTlWm0.MaBk9GODYvRmCnZahaRy8Iypi',NULL,NULL,0,0,'2025-06-24 03:11:09'),
(300,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$sc5UjrJ1T5Oc.RAIFMt9quN/J4hkfcRVldd6PJsqaVvZGR/Zytt3a',NULL,NULL,0,0,'2025-06-24 03:12:00'),
(301,'Aminio Tuisavusavu - BN536','$2y$10$FEhzu7lRHYuIp5ZIzmxXo.MttYgBHrWonMGe3.6m6Yu5Uu3o.G1q2',NULL,NULL,0,0,'2025-06-24 03:12:10'),
(302,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$zT9XhuOuQpEpt6IktwNvvOYSlcfBFmISGA4WAQrXsYsqEAub4ESh6',NULL,NULL,0,0,'2025-06-24 03:13:00'),
(303,'Aminio Tuisavusavu - BN536','$2y$10$/wXDpOswBn4ZMVpkMgKF2.8LjsRtRjszHLsHJooPVCKJt9YcDwSze',NULL,NULL,0,0,'2025-06-24 03:13:09'),
(304,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$MK.LMO60lLJ56eTbvWcRV.CZcgo/OzGqfKKxfq39FjxYWo4kBsuKy',NULL,NULL,0,0,'2025-06-24 03:14:01'),
(305,'Aminio Tuisavusavu - BN536','$2y$10$SqM9CGfGbdt/hs2mozHLYu6AehkT2Ky/cMYPPSihl4QGWoayX99ta',NULL,NULL,0,0,'2025-06-24 03:14:10'),
(306,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$sz2YZxWA1fJ52S1XnvunfOVZ4x8TOnEEQmbzEfPCn5lQ7V46KAR2u',NULL,NULL,0,0,'2025-06-24 03:15:00'),
(307,'Aminio Tuisavusavu - BN536','$2y$10$Y2hmRVQA4AVfoSVqtXu/jud790dNhNUbbd2Rjz3vaWUOmhbt4pTkK',NULL,NULL,0,0,'2025-06-24 03:15:09'),
(308,'Iverlyn Maeta - BN655','$2y$10$QSu/nHf1GmUIKKiaRJq6duokl30Ot4.xh1m8hiBYfAxrYF2QdaCaC',NULL,NULL,0,0,'2025-06-24 03:15:48'),
(309,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$ywVVU.6Ut2QsBoutRa0Pmeppnb8Ksxlnql8gJ2qKF0II/jMTIOVyW',NULL,NULL,0,0,'2025-06-24 03:16:00'),
(310,'Aminio Tuisavusavu - BN536','$2y$10$MB6qs0aOnOJxqdLNHNdpNerk9cLugq/KWTLUur.3COK5bpRpljgZO',NULL,NULL,0,0,'2025-06-24 03:16:09'),
(311,'Iverlyn Maeta - BN655','$2y$10$L.E5bfl/zAy6w.rGtQyOC.Q2gELV2pfZmM6RHEUVfhZKMiDE7rbiW',NULL,NULL,0,0,'2025-06-24 03:16:48'),
(312,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$Hz33YjtsdvukrjJH04RlfOPe/cMKNPpdYOKQkPGcgVJyfcvTacAfu',NULL,NULL,0,0,'2025-06-24 03:17:00'),
(313,'Aminio Tuisavusavu - BN536','$2y$10$1F1rbFTM37/ffP2cl8Atyuw9jjVnF9l/K7rtKHYmNaZTCZNI5wNUi',NULL,NULL,0,0,'2025-06-24 03:17:09'),
(314,'Iverlyn Maeta - BN655','$2y$10$MghRBDriHfD7MYPMH4jBa.yvEqYhpindsY4W.eXezT4L7l5Op1GnG',NULL,NULL,0,0,'2025-06-24 03:17:48'),
(315,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$TL8jHfw3/LahXUmSWCEWHO5Yh/CkH8jlWSF7maAgh5pt170CbLzA.',NULL,NULL,0,0,'2025-06-24 03:18:00'),
(316,'Aminio Tuisavusavu - BN536','$2y$10$NMc4GxHPXG6hxy4whu6m.Oe4WiI/hXD9NjQqFKYyt/LK9pkyJz7G2',NULL,NULL,0,0,'2025-06-24 03:18:11'),
(317,'Iverlyn Maeta - BN655','$2y$10$RIWWuAhmIv57grB5mArNpu/qoZakmaIWvP.wdBZ4QTylIbSFIc2OS',NULL,NULL,0,0,'2025-06-24 03:18:48'),
(318,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$7LET4omMx81tnKVSmGGtSeEDzE9QFAiXik/BYEbENiIjKvCMAHPNm',NULL,NULL,0,0,'2025-06-24 03:19:00'),
(319,'Aminio Tuisavusavu - BN536','$2y$10$zI5SdbhxrIEcsDVK9JHVeuRVkUPKvuPX89lDsX61JdvK1luFMuON2',NULL,NULL,0,0,'2025-06-24 03:19:09'),
(320,'Iverlyn Maeta - BN655','$2y$10$Pn9ZDb32cJfRn.WaQOJqMeLfGKas5JRGSlqFrTKFzydKlpDVQXWUu',NULL,NULL,0,0,'2025-06-24 03:19:48'),
(321,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$/DmFMV4jX8sQDJPivobReupMrQ28ZmV8vJeBLAVETja57Tahm9fA.',NULL,NULL,0,0,'2025-06-24 03:20:01'),
(322,'Aminio Tuisavusavu - BN536','$2y$10$upasO5HH5KiHljPgLn2DJe34foI4tH0s0/.Yw.k5QH7OM0.GHFF6K',NULL,NULL,0,0,'2025-06-24 03:20:10'),
(323,'Iverlyn Maeta - BN655','$2y$10$yOkD5gSbntyuM0twDi2Ve.DLBJRgpKkCz.lkAyApzsA9Iy6X5sCLa',NULL,NULL,0,0,'2025-06-24 03:20:49'),
(324,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$ZjSkKZvvQpSA3WWqgNynjuV7TdebxDoI7YvPtbCdjjx72SvHbK2Fe',NULL,NULL,0,0,'2025-06-24 03:21:40'),
(325,'Aminio Tuisavusavu - BN536','$2y$10$wNLXGYZNP18L7pyb6yec6ukzILViQTLRSU6xUqLSgmCm7vpvwO6dm',NULL,NULL,0,0,'2025-06-24 03:21:48'),
(326,'Iverlyn Maeta - BN655','$2y$10$hUZryd1nTvK5TjG/iyW2ueOPfnHCk5Mj0RSm/wmJ5H.Qgx2yhOx66',NULL,NULL,0,0,'2025-06-24 03:22:56'),
(327,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$6KuA0QxCCVuGlu1bkjBPS.fhUy5IQylySi/ArrMCa372iDnwyu28i',NULL,NULL,0,0,'2025-06-24 03:23:40'),
(328,'Aminio Tuisavusavu - BN536','$2y$10$u4kMwr3JoGq75qwU9Q3wm.q2keVBN.6RpUNcrin3.mw0y21.90mo2',NULL,NULL,0,0,'2025-06-24 03:23:47'),
(329,'Iverlyn Maeta - BN655','$2y$10$So6COIPs3XXc9RorSZvU/.GCy4BnANuDrni8LgRm2bNZzu7yBivxu',NULL,NULL,0,0,'2025-06-24 03:24:56'),
(330,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$v/NOEWW20ZnDzTldk7nRqOczwIRSbBVKO1S2y9IwHHkSImha8XUmW',NULL,NULL,0,0,'2025-06-24 03:25:40'),
(331,'Aminio Tuisavusavu - BN536','$2y$10$qEJHi4mu1WuJ51kTVyPLvehiakY7FLceCXPPH0iidQ/ZA.tfq5UfO',NULL,NULL,0,0,'2025-06-24 03:25:48'),
(332,'Iverlyn Maeta - BN655','$2y$10$luxyEI90oQKv0iIVyU2haeOUXCk96b5jyWI4M6CnuealHFu85nDGu',NULL,NULL,0,0,'2025-06-24 03:26:56'),
(333,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$K4J9NIjrVX3e.rUYyAQ3lumKa1sRjLmPHvX6rpRPYjsp9cPKq5NVu',NULL,NULL,0,0,'2025-06-24 03:27:40'),
(334,'Aminio Tuisavusavu - BN536','$2y$10$sfKdOAZQRFkaAoNqq.tQEe/ruFXrjqx3/uTxF.gQMJivueqZWGzZC',NULL,NULL,0,0,'2025-06-24 03:27:47'),
(335,'Iverlyn Maeta - BN655','$2y$10$HY3QtsnEfvl5.8LboIsoYec1bQGz9tgjQ3bu.fHZTQzAbe/piG2tm',NULL,NULL,0,0,'2025-06-24 03:28:56'),
(336,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$lNs4m/F.OGhCaGEzyhxVNOZfRD4pCmkSpEIUX2zuvGC/yS86Rh2Ji',NULL,NULL,0,0,'2025-06-24 03:29:40'),
(337,'Aminio Tuisavusavu - BN536','$2y$10$5A0WGs5X0qO84YO0xpLOI.4OqaR5jtQZMWCsIaIg428L.I/XZPCZC',NULL,NULL,0,0,'2025-06-24 03:29:48'),
(338,'Iverlyn Maeta - BN655','$2y$10$pdTcEaOB49Y57N7hzoWKs.H27QJgfu0vfzyolkJDBraTcM8mTwDDK',NULL,NULL,0,0,'2025-06-24 03:30:56'),
(339,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$BOHKE17DqQ3q0DuYjsCq.u9NnBjjK7YIFA6Tjbzv8faXG89Uck8hW',NULL,NULL,0,0,'2025-06-24 03:31:40'),
(340,'Aminio Tuisavusavu - BN536','$2y$10$RdWJPEzepuB6IwecuZDKG.zTlNSadWhQ/kGAbsOWB6NSNe7beALly',NULL,NULL,0,0,'2025-06-24 03:31:48'),
(341,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$lMDvb9UAFxs.0S.0zI6eAuiaxzEiJFK8IDJOtJIYYifrYCqfaw8nW',NULL,NULL,0,0,'2025-06-24 03:34:16'),
(342,'Iverlyn Maeta - BN655','$2y$10$GaA5sWWB05J.2rW637n6O.ytw4q0X8uuFH6dPiVhqwUrBdtEonXfe',NULL,NULL,0,0,'2025-06-24 03:34:16'),
(343,'Aminio Tuisavusavu - BN536','$2y$10$nBPL52f.K8ZAEanwNUQAQu35xnK6tbPcz5krqOnfIKGt0UU2jR9PC',NULL,NULL,0,0,'2025-06-24 03:34:24'),
(344,'Iverlyn Maeta - BN655','$2y$10$zWsvx0/6pxCknDu7Fp/wpO8Ejcg5aLjL0/MiQGVjoe93oRxXXWMRy',NULL,NULL,0,0,'2025-06-24 03:34:56'),
(345,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$6wkv4nZQnVXa3GSBi5OIj.U6FjchMYGUyi8pOZCTwJhmVEyEwB9ca',NULL,NULL,0,0,'2025-06-24 03:35:40'),
(346,'Aminio Tuisavusavu - BN536','$2y$10$9IQo92OiVbfWOLRri5fMNOfaf2DiBw4Hrn3Npn80BFejEMWGCRGxe',NULL,NULL,0,0,'2025-06-24 03:35:48'),
(347,'Iverlyn Maeta - BN655','$2y$10$EIHECoxXwLLoL0IB5a31jua5SAHOcYM.T3Uzxztbj1D4AEM2G414e',NULL,NULL,0,0,'2025-06-24 03:36:56'),
(348,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$nGcW.VwNL690qIE8FsvoJeeKoIuccyEFU45AZjsNm6/H8UwucHeZ.',NULL,NULL,0,0,'2025-06-24 03:37:43'),
(349,'Aminio Tuisavusavu - BN536','$2y$10$jAyuq9jKoIh22vLoN6yH/elPwYl8EI1qOgPZVjh2kCA9XUaCqS1rO',NULL,NULL,0,0,'2025-06-24 03:37:53'),
(350,'Tevita Tuikubulau Karikaritu - BN128','$2y$10$rBSrvCXE0WBxDyg0GbVzT.ADKBBHOb1b.ys3vCaS9oaZdAYHPg4Ku',NULL,NULL,0,0,'2025-06-26 03:02:13'),
(351,'Mereseini Tawakilai Vubaya - BN197','$2y$10$/e/RIs.1ZjH8wcEfFxLetupGEsAvz1wpo/9Ad0nuwvpKMP6hfTv2q',NULL,NULL,0,0,'2025-06-26 03:08:41'),
(352,'Ronak Cylvian Sharma - BN196','$2y$10$YiPaltYBoXbOd7UsmuDched/oAEHZn7HpQqDCKaQYaXLRS6d.AMxW',NULL,NULL,0,0,'2025-06-26 03:10:11'),
(353,'Yogesh Reddy - BN198','$2y$10$By2BNhJpJvWtBbNGc5bTB.RNg/jnJ91YRepFFnfxtNVh0Gpoa1Zw.',NULL,NULL,0,0,'2025-06-26 03:10:41'),
(354,'Mohammed Ifraaz - BN207','$2y$10$2Xz.aNh0/mjTugHgGb7v6.AoWqcXLthslGdjv7.v4rnbiPKd2mITe',NULL,NULL,0,0,'2025-06-26 03:11:40'),
(355,'Lora Eta Qiqiwaqa - BN246','$2y$10$KyARO/eJbidQoFxrowOGMO2LAjHKzdENapnZUujiCoWrt7O7JstWm',NULL,NULL,0,0,'2025-06-26 03:12:11'),
(356,'Jiale Siga Mar - BN257','$2y$10$O3Qqc.ohkjCVJTJ3va5Q8.SVCai6SJR2.2jWbvoiyzPOiDyNl.pne',NULL,NULL,0,0,'2025-06-26 03:43:19'),
(357,'Haroon Buksh - BN267','$2y$10$wBB79d1plJyOy5fwHMUBJuz9GqkMDH8PX6wMZjF1WHhzWbEtU9y.i',NULL,NULL,0,0,'2025-06-26 03:58:49'),
(358,'Matilda Julia  Hazelman - BN296','$2y$10$M82WiP./eEYSWB4EIKHxAu7K68OnUoIm7pnBUGpkjDiazZniMJSpG',NULL,NULL,0,0,'2025-06-26 03:59:49'),
(359,'Sylvia  Nandani Reddy - BN309','$2y$10$u4oLyJnUEjKmEM3hn6XyU.v/l6AUQbpMpbpdx2JGIPVSiCND0aBIm',NULL,NULL,0,0,'2025-06-26 04:00:19'),
(360,'Panapasa Meke - BN260','$2y$10$3W6JL.GQi0ZHwrj3IFJbIuxr6IlInutj2vKhrpbXTSrXjDazr2faW',NULL,NULL,0,0,'2025-06-26 04:01:19'),
(361,'Mereani Vakadromusiga - BN400','$2y$10$H9er4kdDpYADQkYhNExKuelMsjJkJFw//42xLhK66lo2Axoi.dc0y',NULL,NULL,0,0,'2025-06-26 04:02:49'),
(362,'Sonam Kumar - BN435','$2y$10$YRtIeDh.3/SiWaH65Euuwe.Lm.HYFuN6OQX3OG4nFsr3yJs7r8lEy',NULL,NULL,0,0,'2025-06-26 04:03:49'),
(363,'Kalisiana Vuniwaqa - BN561','$2y$10$ASurAYNsqXtUChKoz7wWYezJjLSwzjXYXHJjUpupp0IuNgKU3BPjW',NULL,NULL,0,0,'2025-06-26 04:04:19'),
(364,'Hanrieta Sina Yadraca - BN574','$2y$10$qO65GoH0t3CKqr3c4.UYTOq9VL7NJDP1qzTif4/wLjB526MILOSKS',NULL,NULL,0,0,'2025-06-26 04:05:49'),
(365,'Livai Nakuta - BN339','$2y$10$ua3DRAVU.IlsuYSfi5hqt.2JG6J9kkyl/EBpieC9RLiK.nj5Y9cHm',NULL,NULL,0,0,'2025-06-26 04:25:31'),
(366,'Teria Ribauea - BN360','$2y$10$s.uXoBPvZFX9TM8HChE5euGirLGXo4wDBXMmotr8aeP.IfkHw6rzq',NULL,NULL,0,0,'2025-06-26 04:26:01'),
(367,'Nirlesh Niraj Lal - BN493','$2y$10$kW/jfsQ5dezGdBf6Blo6FuzHX5EooY86eS2KmwWO7iGkO2mYep60u',NULL,NULL,0,0,'2025-06-26 04:27:01'),
(368,'Veniana Wasarua Tuva - BN519','$2y$10$mHSsx0aaPgW2D9MuVxYnuOyElgz13005cltb0y7o.fmY.MdRo.RcG',NULL,NULL,0,0,'2025-06-26 04:27:31'),
(369,'Aminio Tuisavusavu','$2y$10$aZN5U4CPl6evLHuo2zzNK.rmUB1nkTNl1YJ8pBxcYYiOMtoWPeWw.',NULL,NULL,0,0,'2025-06-26 04:32:01'),
(370,'Tuverea Tuamoto - BN547','$2y$10$k2IwyrYtEbCL8ejfGVKKuOJVDMTrist45Z/iwZK6xt3.imTuocT8u',NULL,NULL,0,0,'2025-06-26 04:33:01'),
(371,'Rashnil Jai - BN556','$2y$10$fCGJmh6goUgyJE2xCggOK.9tQet14X.FZc8tGvOFhN2b8OT1LQtye',NULL,NULL,0,0,'2025-06-26 04:33:31'),
(372,'Repeka Tukula - BN566','$2y$10$cQuDhKfl868vdHAnAiI0WO0z4YtXUVzuxOhvECgnPXsIM37KZLaJy',NULL,NULL,0,0,'2025-06-26 04:34:01'),
(373,'Sera Rasiga - BN575','$2y$10$zOeYyAO1PUf026c9cOfHI.9sSKM9u6peoZtFyYoZS53U4gaRkWxMK',NULL,NULL,0,0,'2025-06-26 04:34:31'),
(374,'Lily Pickering - BN611','$2y$10$TG3UvBMjAoY23xC859hozOUBhNMLK/6x.iO7VLtO86RzfgVYcR6jC',NULL,NULL,0,0,'2025-06-26 04:44:05'),
(375,'Arieta Marawaqa - BN612','$2y$10$N0mvtEcs.54hC8Yk/Jv7huZtLwUh.rIq8vb5sQQwVWEaF.XqZeDuO',NULL,NULL,0,0,'2025-06-26 04:44:34'),
(376,'Taina Mocemaiwaiyevo - BN645','$2y$10$4kH8V4V2F7gBZWn8oPI10.wmzFiBU3jy0rv3uzm8YUuS1goGFBeeK',NULL,NULL,0,0,'2025-06-26 04:45:34'),
(377,'Edward James Newton - BN646','$2y$10$MJyl.YSUpR7NlN0jHPBDr.kzRzYLiokUJBYDCJuD6reqLL50LI8a6',NULL,NULL,0,0,'2025-06-26 04:46:05'),
(378,'Surend Pratap - BN046','$2y$10$LjPU4Fn0/V9bFzYnUnQC7OqPBwhohEEXWAXAfXampL.Fkv8ejow8.',NULL,NULL,0,0,'2025-06-26 04:46:34'),
(379,'Nitesh Datt - BN219','$2y$10$ATz4lqj/TBMPezZFg4MtBOrO1wy5VOBha8U3wsGpZYQHQvqjzVycu',NULL,NULL,0,0,'2025-06-26 04:47:35'),
(380,'Iverlyn Maeta - BN655','$2y$10$VDyZVI6CtBrrEohQPY0bJebKfzBhA.leqhVNxH7ODukIEHGcCEgea',NULL,NULL,0,0,'2025-06-26 04:48:04'),
(381,'Kevin Chand','$2y$10$HaD8t1ocQ9G9z2jVRdkd5uvbkVQe6c6MYavNw9nkrUtvc3.Jblue.',NULL,NULL,0,0,'2025-08-04 22:07:54'),
(382,'Samuel Patel - BN175','$2y$10$8i3IKvZM/0tSnJJgYiaCp.z9Rcityouz8Ntgl.GoKYDgSjF7xP1Wq',NULL,NULL,0,0,'2025-08-04 22:13:55'),
(383,'Keleni Naisaboca - BN022','$2y$10$WRIcBK6hZ/kv1lx5FVwxl.xevwog7LRGhP/KpYYvLFFkizCAzuXNS',NULL,NULL,0,0,'2025-08-04 22:23:34'),
(384,'Naomi Gasara - BN095','$2y$10$FSVP5K0cor33Sbm7PG0H0eQFC6zncWkNJBoOChjsbjuk9q7Tk5nay',NULL,NULL,0,0,'2025-08-04 22:24:42'),
(385,'Poonam Devi - BN099','$2y$10$V7br0..UGtGhTxOWS2c8eO/4P8BwftEDmM8HrjazkDhZwodGwYSfa',NULL,NULL,0,0,'2025-08-04 22:26:14'),
(386,'Vilsoni Varea - BN244','$2y$10$EIojTKqfIX16DwdRb8HdSujZGyUFW1nu6Lk17B2gxgmFPA5noq.2q',NULL,NULL,0,0,'2025-08-04 22:28:01'),
(387,'Uraia Makuiveikau - BN393','$2y$10$6NHrPe9v9Vxe./YiI//gLuDqASa6mbstVxuS92VbZM9urC9Sm2CgG',NULL,NULL,0,0,'2025-08-04 22:29:08'),
(388,'Samuela Paula - BN639','$2y$10$6vTJW1ocofbG4HiYc4xeAOMBAVd6CsfvhkZ/HsKcVw6TKrNHMfGFq',NULL,NULL,0,0,'2025-08-04 22:30:03'),
(389,'Nanise Valevatu - BN090','$2y$10$B2FZSDR2P487j22.JRZ4ceyW0BR3uDoQfxWhhgzFxGWt7WQAFInQS',NULL,NULL,0,0,'2025-08-04 22:30:53'),
(390,'Nafiza Bibi - BN092','$2y$10$NJbHM4pAL8RQZhpNzzs.U.Ma9GGXB44afIjAojhd8mdHVRTjexxhC',NULL,NULL,0,0,'2025-08-04 22:31:21'),
(391,'Jale Loiti - BN156','$2y$10$LvbHxHK0z5HyimD3/gFJs.rLM.3874jcXavH4ZxE6yFYrbcC9J0VO',NULL,NULL,0,0,'2025-08-04 22:31:49'),
(392,'Sakeasi Nasetava - BN377','$2y$10$54VUjVOX5xQGTPPmi9XEZuKYm0536F4DPLwaf6QdPvKIF6toDbJtW',NULL,NULL,0,0,'2025-08-04 22:47:29'),
(393,'Aseri Ravoka - BN411','$2y$10$BqLkmYDUvx34hrX3BGBHGugcS06M8HHqHwzoAqzW1J33c4C0CWgLe',NULL,NULL,0,0,'2025-08-04 22:48:40'),
(394,'Umesh Sharma - BN234','$2y$10$hTtl4FpTVFoNZLryf7XWju11RHNjTvhh0Nh0LKQcrIxzsISJ.3i1K',NULL,NULL,0,0,'2025-08-04 22:49:21'),
(395,'Abdul Hafeez - BN363','$2y$10$Mi9np.xmaEjv6ZO1ugPt2.babcRkuPobSDiBMfabd/ViEPfy.cRUu',NULL,NULL,0,0,'2025-08-04 22:50:02'),
(396,'Rahul Pratap - BN424','$2y$10$ilXf2m6TJAacYLxIXDQ75umJEluOigQP8bEMVxIVVznlCshkpkBfa',NULL,NULL,0,0,'2025-08-04 22:50:43'),
(397,'Aminiasi - BN578','$2y$10$c1jRyupDPCCNeWKXeALncu3ib3UuEHeOj8FF3L.Wu1dE1r0UCHyYG',NULL,NULL,0,0,'2025-08-04 22:51:25'),
(398,'Keleni Naisaboca - BN022','$2y$10$/xuxVNwKT3AqEU7FCOOTfOzm7UBzLtCSiXQqMYQvy8zho2o2uNaKK',NULL,NULL,0,0,'2025-10-02 02:48:35');

--
-- Table structure for table `vendor_addresses`
--

CREATE TABLE `vendor_addresses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_id` int(11) NOT NULL,
  `type` enum('office','postal') NOT NULL,
  `address` text NOT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci WITH SYSTEM VERSIONING;

--
-- Dumping data for table `vendor_addresses`
--

INSERT INTO `vendor_addresses` VALUES
(1,1,'office','123 Main St, Suva',0,'2025-06-02 20:55:41'),
(2,2,'office','456 Tech Park, Nadi',0,'2025-06-02 20:55:41'),
(3,3,'office','789 Catering Rd, Lautoka',0,'2025-06-02 20:55:41');

--
-- Table structure for table `vendor_bank_accounts`
--

CREATE TABLE `vendor_bank_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_id` int(11) NOT NULL,
  `bankName` varchar(255) DEFAULT NULL,
  `bankBranch` varchar(255) DEFAULT NULL,
  `accountName` varchar(255) DEFAULT NULL,
  `accountNumber` varchar(255) DEFAULT NULL,
  `bankCode` varchar(255) DEFAULT NULL,
  `bankAddress` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci WITH SYSTEM VERSIONING;

--
-- Dumping data for table `vendor_bank_accounts`
--

INSERT INTO `vendor_bank_accounts` VALUES
(1,1,'Bank of Fiji','Suva','Fiji Stationers Ltd','123456789','BOF001','1 Bank St, Suva',0,'2025-06-02 20:55:41'),
(2,2,'Fiji Bank','Nadi','Island Tech Solutions','987654321','FJB002','2 Bank St, Nadi',0,'2025-06-02 20:55:41'),
(3,3,'Bank of Pacific','Lautoka','Pacific Catering Co','555666777','BOP003','3 Bank St, Lautoka',0,'2025-06-02 20:55:41');

--
-- Table structure for table `vendor_capabilities`
--

CREATE TABLE `vendor_capabilities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_id` int(11) NOT NULL,
  `goodsServices` text DEFAULT NULL,
  `categoryTags` text DEFAULT NULL,
  `pastClients` text DEFAULT NULL,
  `experienceYears` int(11) DEFAULT NULL,
  `certifications` text DEFAULT NULL,
  `capacity` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci WITH SYSTEM VERSIONING;

--
-- Dumping data for table `vendor_capabilities`
--

INSERT INTO `vendor_capabilities` VALUES
(1,1,'Office Supplies','stationery','Gov Dept',15,'ISO9001','High volume',0,'2025-06-02 20:55:41'),
(2,2,'IT Services','software,hardware','Various clients',10,'Cisco','Medium',0,'2025-06-02 20:55:41'),
(3,3,'Catering Services','food','Hotels',8,'FoodSafe','Large events',0,'2025-06-02 20:55:41');

--
-- Table structure for table `vendor_contacts`
--

CREATE TABLE `vendor_contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_id` int(11) NOT NULL,
  `primaryContactName` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `altContactDetails` text DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci WITH SYSTEM VERSIONING;

--
-- Dumping data for table `vendor_contacts`
--

INSERT INTO `vendor_contacts` VALUES
(1,1,'John Vendor','Manager','contact@fijistationers.com','+679-100-200',NULL,0,'2025-06-02 20:55:41'),
(2,2,'Jane Tech','Director','info@islandtech.com','+679-200-300',NULL,0,'2025-06-02 20:55:41'),
(3,3,'Paul Cater','Owner','service@paccater.com','+679-300-400',NULL,0,'2025-06-02 20:55:41');

--
-- Table structure for table `vendor_documents`
--

CREATE TABLE `vendor_documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_id` int(11) NOT NULL,
  `filetype` varchar(50) NOT NULL,
  `type` varchar(100) NOT NULL,
  `file_url` text NOT NULL,
  `validity` date DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci WITH SYSTEM VERSIONING;

--
-- Dumping data for table `vendor_documents`
--

INSERT INTO `vendor_documents` VALUES
(1,1,'pdf','business_license','/docs/vendors/license1.pdf','2026-12-31',0,'2025-06-02 20:55:41'),
(2,2,'pdf','business_license','/docs/vendors/license2.pdf','2027-05-31',0,'2025-06-02 20:55:41'),
(3,3,'pdf','business_license','/docs/vendors/license3.pdf','2027-10-31',0,'2025-06-02 20:55:41');

--
-- Table structure for table `vendor_invoices`
--

CREATE TABLE `vendor_invoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int(11) NOT NULL,
  `invoice_number` varchar(100) NOT NULL,
  `invoice_date` date DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `status` varchar(50) DEFAULT 'unpaid',
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vendor_invoices`
--


--
-- Table structure for table `vendor_supporting_docs`
--

CREATE TABLE `vendor_supporting_docs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_id` int(11) NOT NULL,
  `filetype` varchar(50) NOT NULL,
  `type` varchar(100) NOT NULL,
  `file_url` text NOT NULL,
  `validity` date DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci WITH SYSTEM VERSIONING;

--
-- Dumping data for table `vendor_supporting_docs`
--

INSERT INTO `vendor_supporting_docs` VALUES
(1,1,'pdf','insurance_certificate','/docs/vendors/insurance1.pdf','2025-12-31',0,'2025-06-02 20:55:41'),
(2,2,'pdf','insurance_certificate','/docs/vendors/insurance2.pdf','2026-12-31',0,'2025-06-02 20:55:41'),
(3,3,'pdf','insurance_certificate','/docs/vendors/insurance3.pdf','2026-12-31',0,'2025-06-02 20:55:41');

--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vendorName` varchar(255) NOT NULL,
  `tradingName` varchar(255) DEFAULT NULL,
  `businessRegNumber` varchar(255) DEFAULT NULL,
  `tin` varchar(255) DEFAULT NULL,
  `vatNumber` varchar(255) DEFAULT NULL,
  `businessType` varchar(255) DEFAULT NULL,
  `incorporationDate` date DEFAULT NULL,
  `registrationCountry` varchar(255) DEFAULT NULL,
  `status` varchar(100) DEFAULT 'pending',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci WITH SYSTEM VERSIONING;

--
-- Dumping data for table `vendors`
--

INSERT INTO `vendors` VALUES
(1,'Fiji Stationers Ltd','Fiji Stationers','BRN12345','TIN54321','VAT11111','LLC','2010-03-15','Fiji','approved',1,1,0,'2025-06-02 20:55:41'),
(2,'Island Tech Solutions','IslandTech','BRN67890','TIN98765','VAT22222','Ltd','2015-07-20','Fiji','pending',1,1,0,'2025-06-02 20:55:41'),
(3,'Pacific Catering Co','PacCater','BRN23456','TIN12321','VAT33333','Ltd','2012-11-10','Fiji','approved',1,1,0,'2025-06-02 20:55:41');

--
-- Table structure for table `violation_types`
--

CREATE TABLE `violation_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handbook_ref` varchar(255) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `violation_types`
--

INSERT INTO `violation_types` VALUES
(1,'Attendance Violation','Section 5.2',0,'2025-06-02 20:55:41'),
(2,'Code of Conduct','Section 3.1',0,'2025-06-02 20:55:41');

--
-- Table structure for table `workflows`
--

CREATE TABLE `workflows` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `trigger_event` varchar(100) NOT NULL,
  `definition` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`definition`)),
  `is_active` tinyint(1) DEFAULT 1,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `workflows`
--

INSERT INTO `workflows` VALUES
(1,'Employee Onboarding','employee.hired','{\n    \"conditions\": [],\n    \"steps\": [\n      { \"type\": \"assign_items\" },\n      { \"type\": \"notify_manager\" },\n      { \"type\": \"trigger_api\", \"items\": [\"365\", \"email_signature\"] }\n    ]\n  }',1,0,'2025-06-02 20:55:41'),
(2,'OHS Incident Reporting','ohs_incident_reported','{\n    \"conditions\": [],\n    \"steps\": [\n      { \"type\": \"wait_approval\", \"role\": \"hs_officer\" },\n      { \"type\": \"update_status\", \"field\": \"status\", \"value\": \"investigating\" }\n    ]\n  }',1,0,'2025-06-02 20:55:41');


