-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` varchar(100) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `card_number` varchar(10) DEFAULT NULL,
  `card_exp_month` varchar(10) DEFAULT NULL,
  `card_exp_year` varchar(10) DEFAULT NULL,
  `plan_name` varchar(100) DEFAULT NULL,
  `plan_id` int(11) NOT NULL,
  `price` double(8,2) NOT NULL,
  `price_currency` varchar(10) DEFAULT NULL,
  `txn_id` varchar(100) DEFAULT NULL,
  `payment_status` varchar(100) DEFAULT NULL,
  `payment_type` varchar(191) NOT NULL DEFAULT 'Manually',
  `receipt` varchar(191) DEFAULT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `other_payments`
--

CREATE TABLE `other_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` int(11) NOT NULL,
  `title` varchar(191) NOT NULL,
  `amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `type` varchar(191) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `overtimes`
--

CREATE TABLE `overtimes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` int(11) NOT NULL,
  `title` varchar(191) NOT NULL,
  `number_of_days` int(11) NOT NULL,
  `hours` int(11) NOT NULL,
  `rate` int(11) NOT NULL,
  `type` varchar(191) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `overtimes`
--

INSERT INTO `overtimes` (`id`, `employee_id`, `title`, `number_of_days`, `hours`, `rate`, `type`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 1, 'Re', 3, 10, 200, NULL, 1, '2024-10-07 03:43:29', '2024-10-07 03:43:29');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `amount` decimal(16,2) NOT NULL DEFAULT 0.00,
  `account_id` int(11) NOT NULL,
  `chart_account_id` int(11) NOT NULL DEFAULT 0,
  `vender_id` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `recurring` varchar(191) DEFAULT NULL,
  `payment_method` int(11) NOT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `add_receipt` varchar(191) DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payslip_types`
--

CREATE TABLE `payslip_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payslip_types`
--

INSERT INTO `payslip_types` (`id`, `name`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Monthly', 1, '2024-10-07 03:16:10', '2024-10-07 03:16:10');

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

--
-- Table structure for table `pay_slips`
--

CREATE TABLE `pay_slips` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` int(11) NOT NULL,
  `net_payble` int(11) NOT NULL,
  `salary_month` varchar(191) NOT NULL,
  `status` int(11) NOT NULL,
  `basic_salary` int(11) NOT NULL,
  `allowance` text NOT NULL,
  `commission` text NOT NULL,
  `loan` text NOT NULL,
  `saturation_deduction` text NOT NULL,
  `other_payment` text NOT NULL,
  `overtime` text NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pay_slips`
--

INSERT INTO `pay_slips` (`id`, `employee_id`, `net_payble`, `salary_month`, `status`, `basic_salary`, `allowance`, `commission`, `loan`, `saturation_deduction`, `other_payment`, `overtime`, `created_by`, `created_at`, `updated_at`) VALUES
(3, 1, 46200, '2024-10', 0, 40000, '[{\"id\":1,\"employee_id\":\"1\",\"allowance_option\":\"1\",\"title\":\"R\",\"amount\":\"200.00\",\"type\":\"fixed\",\"created_by\":\"1\",\"created_at\":\"2024-10-07T03:42:42.000000Z\",\"updated_at\":\"2024-10-07T03:44:57.000000Z\"}]', '[]', '[]', '[]', '[]', '[{\"id\":1,\"employee_id\":\"1\",\"title\":\"Re\",\"number_of_days\":\"3\",\"hours\":\"10\",\"rate\":\"200\",\"type\":null,\"created_by\":\"1\",\"created_at\":\"2024-10-07T03:43:29.000000Z\",\"updated_at\":\"2024-10-07T03:43:29.000000Z\"}]', 1, '2024-10-07 03:52:07', '2024-10-07 03:52:07'),
(5, 2, 20000, '2024-10', 0, 20000, '[]', '[]', '[]', '[]', '[]', '[]', 1, '2024-10-09 08:59:32', '2024-10-09 08:59:32');

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

--
-- Table structure for table `performance_types`
--

CREATE TABLE `performance_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `performance_types`
--

INSERT INTO `performance_types` (`id`, `name`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Good', 1, '2024-10-07 03:24:47', '2024-10-07 03:24:47'),
(2, 'General', 1, '2024-10-07 03:24:55', '2024-10-07 03:24:55'),
(3, 'Best', 1, '2024-10-07 03:25:02', '2024-10-07 03:25:02');

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'show pos dashboard', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(2, 'show crm dashboard', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(3, 'show hrm dashboard', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(4, 'copy invoice', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(5, 'show project dashboard', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(6, 'show account dashboard', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(7, 'manage user', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(8, 'create user', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(9, 'edit user', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(10, 'delete user', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(11, 'create language', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(12, 'manage role', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(13, 'create role', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(14, 'edit role', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(15, 'delete role', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(16, 'manage permission', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(17, 'create permission', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(18, 'edit permission', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(19, 'delete permission', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(20, 'manage company settings', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(21, 'manage print settings', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(22, 'manage business settings', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(23, 'manage stripe settings', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(24, 'manage expense', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(25, 'create expense', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(26, 'edit expense', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(27, 'delete expense', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(28, 'manage invoice', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(29, 'create invoice', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(30, 'edit invoice', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(31, 'delete invoice', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(32, 'show invoice', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(33, 'create payment invoice', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(34, 'delete payment invoice', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(35, 'send invoice', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(36, 'delete invoice product', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(37, 'convert invoice', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(38, 'manage constant unit', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(39, 'create constant unit', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(40, 'edit constant unit', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(41, 'delete constant unit', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(42, 'manage constant tax', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(43, 'create constant tax', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(44, 'edit constant tax', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(45, 'delete constant tax', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(46, 'manage constant category', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(47, 'create constant category', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(48, 'edit constant category', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(49, 'delete constant category', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(50, 'manage product & service', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(51, 'create product & service', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(52, 'edit product & service', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(53, 'delete product & service', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(54, 'manage customer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(55, 'create customer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(56, 'edit customer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(57, 'delete customer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(58, 'show customer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(59, 'manage vender', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(60, 'create vender', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(61, 'edit vender', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(62, 'delete vender', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(63, 'show vender', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(64, 'manage bank account', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(65, 'create bank account', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(66, 'edit bank account', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(67, 'delete bank account', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(68, 'manage bank transfer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(69, 'create bank transfer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(70, 'edit bank transfer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(71, 'delete bank transfer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(72, 'manage transaction', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(73, 'manage revenue', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(74, 'create revenue', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(75, 'edit revenue', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(76, 'delete revenue', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(77, 'manage bill', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(78, 'create bill', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(79, 'edit bill', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(80, 'delete bill', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(81, 'show bill', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(82, 'manage payment', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(83, 'create payment', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(84, 'edit payment', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(85, 'delete payment', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(86, 'delete bill product', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(87, 'send bill', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(88, 'create payment bill', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(89, 'delete payment bill', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(90, 'manage order', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(91, 'income report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(92, 'expense report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(93, 'income vs expense report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(94, 'invoice report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(95, 'bill report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(96, 'stock report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(97, 'tax report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(98, 'loss & profit report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(99, 'manage customer payment', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(100, 'manage customer transaction', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(101, 'manage customer invoice', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(102, 'vender manage bill', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(103, 'manage vender bill', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(104, 'manage vender payment', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(105, 'manage vender transaction', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(106, 'manage credit note', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(107, 'create credit note', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(108, 'edit credit note', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(109, 'delete credit note', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(110, 'manage debit note', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(111, 'create debit note', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(112, 'edit debit note', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(113, 'delete debit note', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(114, 'duplicate invoice', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(115, 'duplicate bill', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(116, 'manage proposal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(117, 'create proposal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(118, 'edit proposal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(119, 'delete proposal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(120, 'duplicate proposal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(121, 'show proposal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(122, 'send proposal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(123, 'delete proposal product', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(124, 'manage customer proposal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(125, 'manage goal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(126, 'create goal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(127, 'edit goal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(128, 'delete goal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(129, 'manage assets', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(130, 'create assets', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(131, 'edit assets', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(132, 'delete assets', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(133, 'statement report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(134, 'manage constant custom field', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(135, 'create constant custom field', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(136, 'edit constant custom field', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(137, 'delete constant custom field', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(138, 'manage chart of account', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(139, 'create chart of account', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(140, 'edit chart of account', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(141, 'delete chart of account', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(142, 'manage journal entry', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(143, 'create journal entry', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(144, 'edit journal entry', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(145, 'delete journal entry', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(146, 'show journal entry', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(147, 'balance sheet report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(148, 'ledger report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(149, 'trial balance report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(150, 'manage client', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(151, 'create client', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(152, 'edit client', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(153, 'delete client', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(154, 'manage lead', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(155, 'create lead', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(156, 'view lead', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(157, 'edit lead', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(158, 'delete lead', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(159, 'move lead', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(160, 'create lead call', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(161, 'edit lead call', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(162, 'delete lead call', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(163, 'create lead email', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(164, 'manage pipeline', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(165, 'create pipeline', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(166, 'edit pipeline', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(167, 'delete pipeline', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(168, 'manage lead stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(169, 'create lead stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(170, 'edit lead stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(171, 'delete lead stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(172, 'convert lead to deal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(173, 'manage source', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(174, 'create source', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(175, 'edit source', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(176, 'delete source', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(177, 'manage label', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(178, 'create label', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(179, 'edit label', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(180, 'delete label', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(181, 'manage deal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(182, 'create deal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(183, 'view task', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(184, 'create task', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(185, 'edit task', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(186, 'delete task', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(187, 'edit deal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(188, 'view deal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(189, 'delete deal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(190, 'move deal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(191, 'create deal call', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(192, 'edit deal call', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(193, 'delete deal call', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(194, 'create deal email', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(195, 'manage stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(196, 'create stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(197, 'edit stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(198, 'delete stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(199, 'manage employee', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(200, 'create employee', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(201, 'view employee', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(202, 'edit employee', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(203, 'delete employee', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(204, 'manage employee profile', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(205, 'show employee profile', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(206, 'manage department', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(207, 'create department', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(208, 'view department', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(209, 'edit department', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(210, 'delete department', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(211, 'manage designation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(212, 'create designation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(213, 'view designation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(214, 'edit designation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(215, 'delete designation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(216, 'manage branch', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(217, 'create branch', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(218, 'edit branch', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(219, 'delete branch', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(220, 'manage document type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(221, 'create document type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(222, 'edit document type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(223, 'delete document type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(224, 'manage document', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(225, 'create document', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(226, 'edit document', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(227, 'delete document', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(228, 'manage payslip type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(229, 'create payslip type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(230, 'edit payslip type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(231, 'delete payslip type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(232, 'create allowance', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(233, 'edit allowance', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(234, 'delete allowance', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(235, 'create commission', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(236, 'edit commission', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(237, 'delete commission', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(238, 'manage allowance option', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(239, 'create allowance option', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(240, 'edit allowance option', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(241, 'delete allowance option', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(242, 'manage loan option', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(243, 'create loan option', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(244, 'edit loan option', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(245, 'delete loan option', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(246, 'manage deduction option', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(247, 'create deduction option', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(248, 'edit deduction option', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(249, 'delete deduction option', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(250, 'create loan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(251, 'edit loan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(252, 'delete loan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(253, 'create saturation deduction', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(254, 'edit saturation deduction', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(255, 'delete saturation deduction', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(256, 'create other payment', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(257, 'edit other payment', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(258, 'delete other payment', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(259, 'create overtime', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(260, 'edit overtime', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(261, 'delete overtime', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(262, 'manage set salary', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(263, 'edit set salary', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(264, 'manage pay slip', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(265, 'create set salary', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(266, 'create pay slip', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(267, 'manage company policy', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(268, 'create company policy', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(269, 'edit company policy', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(270, 'manage appraisal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(271, 'create appraisal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(272, 'edit appraisal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(273, 'show appraisal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(274, 'delete appraisal', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(275, 'manage goal tracking', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(276, 'create goal tracking', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(277, 'edit goal tracking', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(278, 'delete goal tracking', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(279, 'manage goal type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(280, 'create goal type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(281, 'edit goal type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(282, 'delete goal type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(283, 'manage indicator', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(284, 'create indicator', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(285, 'edit indicator', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(286, 'show indicator', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(287, 'delete indicator', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(288, 'manage training', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(289, 'create training', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(290, 'edit training', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(291, 'delete training', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(292, 'show training', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(293, 'manage trainer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(294, 'create trainer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(295, 'edit trainer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(296, 'delete trainer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(297, 'manage training type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(298, 'create training type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(299, 'edit training type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(300, 'delete training type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(301, 'manage award', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(302, 'create award', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(303, 'edit award', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(304, 'delete award', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(305, 'manage award type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(306, 'create award type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(307, 'edit award type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(308, 'delete award type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(309, 'manage resignation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(310, 'create resignation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(311, 'edit resignation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(312, 'delete resignation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(313, 'manage travel', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(314, 'create travel', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(315, 'edit travel', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(316, 'delete travel', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(317, 'manage promotion', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(318, 'create promotion', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(319, 'edit promotion', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(320, 'delete promotion', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(321, 'manage complaint', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(322, 'create complaint', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(323, 'edit complaint', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(324, 'delete complaint', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(325, 'manage warning', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(326, 'create warning', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(327, 'edit warning', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(328, 'delete warning', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(329, 'manage termination', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(330, 'create termination', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(331, 'edit termination', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(332, 'delete termination', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(333, 'manage termination type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(334, 'create termination type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(335, 'edit termination type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(336, 'delete termination type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(337, 'manage job application', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(338, 'create job application', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(339, 'show job application', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(340, 'delete job application', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(341, 'move job application', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(342, 'add job application skill', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(343, 'add job application note', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(344, 'delete job application note', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(345, 'manage job onBoard', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(346, 'manage job category', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(347, 'create job category', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(348, 'edit job category', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(349, 'delete job category', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(350, 'manage job', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(351, 'create job', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(352, 'edit job', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(353, 'show job', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(354, 'delete job', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(355, 'manage job stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(356, 'create job stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(357, 'edit job stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(358, 'delete job stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(359, 'Manage Competencies', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(360, 'Create Competencies', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(361, 'Edit Competencies', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(362, 'Delete Competencies', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(363, 'manage custom question', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(364, 'create custom question', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(365, 'edit custom question', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(366, 'delete custom question', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(367, 'create interview schedule', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(368, 'edit interview schedule', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(369, 'delete interview schedule', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(370, 'show interview schedule', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(371, 'create estimation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(372, 'view estimation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(373, 'edit estimation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(374, 'delete estimation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(375, 'edit holiday', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(376, 'create holiday', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(377, 'delete holiday', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(378, 'manage holiday', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(379, 'show career', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(380, 'manage meeting', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(381, 'create meeting', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(382, 'edit meeting', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(383, 'delete meeting', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(384, 'manage event', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(385, 'create event', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(386, 'edit event', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(387, 'delete event', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(388, 'manage transfer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(389, 'create transfer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(390, 'edit transfer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(391, 'delete transfer', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(392, 'manage announcement', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(393, 'create announcement', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(394, 'edit announcement', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(395, 'delete announcement', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(396, 'manage leave', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(397, 'create leave', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(398, 'edit leave', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(399, 'delete leave', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(400, 'manage leave type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(401, 'create leave type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(402, 'edit leave type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(403, 'delete leave type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(404, 'manage attendance', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(405, 'create attendance', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(406, 'edit attendance', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(407, 'delete attendance', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(408, 'manage report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(409, 'manage project', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(410, 'create project', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(411, 'view project', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(412, 'edit project', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(413, 'delete project', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(414, 'share project', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(415, 'create milestone', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(416, 'edit milestone', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(417, 'delete milestone', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(418, 'view milestone', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(419, 'view grant chart', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(420, 'manage project stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(421, 'create project stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(422, 'edit project stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(423, 'delete project stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(424, 'view timesheet', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(425, 'view expense', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(426, 'manage project task', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(427, 'create project task', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(428, 'edit project task', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(429, 'view project task', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(430, 'delete project task', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(431, 'view activity', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(432, 'view CRM activity', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(433, 'manage project task stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(434, 'edit project task stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(435, 'create project task stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(436, 'delete project task stage', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(437, 'manage timesheet', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(438, 'create timesheet', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(439, 'edit timesheet', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(440, 'delete timesheet', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(441, 'manage bug report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(442, 'create bug report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(443, 'edit bug report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(444, 'delete bug report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(445, 'move bug report', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(446, 'manage bug status', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(447, 'create bug status', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(448, 'edit bug status', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(449, 'delete bug status', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(450, 'manage client dashboard', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(451, 'manage super admin dashboard', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(452, 'manage system settings', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(453, 'manage plan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(454, 'create plan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(455, 'edit plan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(456, 'manage coupon', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(457, 'create coupon', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(458, 'edit coupon', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(459, 'delete coupon', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(460, 'manage company plan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(461, 'buy plan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(462, 'manage form builder', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(463, 'create form builder', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(464, 'edit form builder', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(465, 'delete form builder', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(466, 'manage performance type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(467, 'create performance type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(468, 'edit performance type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(469, 'delete performance type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(470, 'manage form field', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(471, 'create form field', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(472, 'edit form field', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(473, 'delete form field', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(474, 'view form response', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(475, 'create budget plan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(476, 'edit budget plan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(477, 'manage budget plan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(478, 'delete budget plan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(479, 'view budget plan', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(480, 'manage warehouse', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(481, 'create warehouse', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(482, 'edit warehouse', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(483, 'show warehouse', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(484, 'delete warehouse', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(485, 'manage purchase', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(486, 'create purchase', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(487, 'edit purchase', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(488, 'show purchase', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(489, 'delete purchase', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(490, 'send purchase', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(491, 'create payment purchase', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(492, 'delete payment purchase', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(493, 'manage pos', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(494, 'manage contract type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(495, 'create contract type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(496, 'edit contract type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(497, 'delete contract type', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(498, 'manage contract', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(499, 'create contract', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(500, 'edit contract', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(501, 'delete contract', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(502, 'show contract', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(503, 'create barcode', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(504, 'create webhook', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(505, 'edit webhook', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(506, 'delete webhook', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(507, 'manage project expense', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(508, 'create project expense', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(509, 'edit project expense', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(510, 'delete project expense', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(511, 'manage quotation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(512, 'create quotation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(513, 'edit quotation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(514, 'delete quotation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(515, 'show quotation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(516, 'show pos', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(517, 'convert quotation', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(518, 'manage zoom meeting', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(519, 'create zoom meeting', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(520, 'show zoom meeting', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(521, 'delete zoom meeting', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(522, 'delete company policy', 'web', '2024-09-05 22:46:50', '2024-09-05 22:46:50');

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pipelines`
--

CREATE TABLE `pipelines` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pipelines`
--

INSERT INTO `pipelines` (`id`, `name`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Sales', 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51');

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

--
-- Table structure for table `pos`
--

CREATE TABLE `pos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pos_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `customer_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `warehouse_id` int(11) NOT NULL DEFAULT 0,
  `pos_date` date DEFAULT NULL,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 0,
  `shipping_display` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pos_payments`
--

CREATE TABLE `pos_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pos_id` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  `amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `discount` double(8,2) DEFAULT NULL,
  `discount_amount` decimal(15,2) DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pos_products`
--

CREATE TABLE `pos_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pos_id` int(11) NOT NULL DEFAULT 0,
  `product_id` int(11) NOT NULL DEFAULT 0,
  `quantity` double(25,2) NOT NULL DEFAULT 0.00,
  `tax` varchar(191) NOT NULL DEFAULT '0.00',
  `discount` double(8,2) DEFAULT 0.00,
  `price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_services`
--

CREATE TABLE `product_services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `sku` varchar(191) NOT NULL,
  `sale_price` decimal(16,2) NOT NULL DEFAULT 0.00,
  `purchase_price` decimal(16,2) NOT NULL DEFAULT 0.00,
  `quantity` double(8,2) NOT NULL DEFAULT 0.00,
  `tax_id` varchar(50) DEFAULT NULL,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `unit_id` int(11) NOT NULL DEFAULT 0,
  `type` varchar(191) NOT NULL,
  `sale_chartaccount_id` int(11) NOT NULL DEFAULT 0,
  `expense_chartaccount_id` int(11) NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `pro_image` varchar(191) DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_service_categories`
--

CREATE TABLE `product_service_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL DEFAULT '0',
  `chart_account_id` int(11) NOT NULL DEFAULT 0,
  `color` varchar(191) NOT NULL DEFAULT '#fc544b',
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_service_units`
--

CREATE TABLE `product_service_units` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `project_name` varchar(191) NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `project_image` varchar(191) DEFAULT NULL,
  `budget` int(11) DEFAULT NULL,
  `client_id` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `status` varchar(191) NOT NULL,
  `estimated_hrs` varchar(191) DEFAULT NULL,
  `password` varchar(191) DEFAULT NULL,
  `copylinksetting` text DEFAULT NULL,
  `tags` text DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `projectstages`
--

CREATE TABLE `projectstages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `color` varchar(15) DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `project_email_templates`
--

CREATE TABLE `project_email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `template_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `project_expenses`
--

CREATE TABLE `project_expenses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `date` date NOT NULL,
  `description` text DEFAULT NULL,
  `amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `attachment` text NOT NULL,
  `project_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `project_invoices`
--

CREATE TABLE `project_invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `tax_id` bigint(20) UNSIGNED NOT NULL,
  `due_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `project_tasks`
--

CREATE TABLE `project_tasks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` text DEFAULT NULL,
  `estimated_hrs` int(11) NOT NULL DEFAULT 0,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `priority` varchar(50) NOT NULL DEFAULT 'medium',
  `priority_color` varchar(50) DEFAULT NULL,
  `assign_to` text DEFAULT NULL,
  `project_id` int(11) NOT NULL DEFAULT 0,
  `milestone_id` int(11) NOT NULL DEFAULT 0,
  `stage_id` int(11) NOT NULL DEFAULT 0,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `is_favourite` int(11) NOT NULL DEFAULT 0,
  `is_complete` int(11) NOT NULL DEFAULT 0,
  `marked_at` date DEFAULT NULL,
  `progress` varchar(5) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `project_users`
--

CREATE TABLE `project_users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `project_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `invited_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `promotions`
--

CREATE TABLE `promotions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` int(11) NOT NULL DEFAULT 0,
  `designation_id` int(11) NOT NULL DEFAULT 0,
  `promotion_title` varchar(191) DEFAULT NULL,
  `promotion_date` date NOT NULL,
  `description` varchar(191) DEFAULT NULL,
  `created_by` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `proposals`
--

CREATE TABLE `proposals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `proposal_id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `issue_date` date NOT NULL,
  `send_date` date DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `discount_apply` int(11) NOT NULL DEFAULT 0,
  `is_convert` int(11) NOT NULL DEFAULT 0,
  `converted_invoice_id` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `proposal_products`
--

CREATE TABLE `proposal_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `proposal_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` double(25,2) NOT NULL DEFAULT 0.00,
  `tax` varchar(50) DEFAULT NULL,
  `discount` double(8,2) NOT NULL DEFAULT 0.00,
  `price` decimal(16,2) NOT NULL DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchases`
--

CREATE TABLE `purchases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_id` varchar(191) NOT NULL DEFAULT '0',
  `vender_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `purchase_date` date NOT NULL,
  `purchase_number` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 0,
  `shipping_display` int(11) NOT NULL DEFAULT 1,
  `send_date` date DEFAULT NULL,
  `discount_apply` int(11) NOT NULL DEFAULT 0,
  `category_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_payments`
--

CREATE TABLE `purchase_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `account_id` int(11) NOT NULL,
  `payment_method` int(11) NOT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `add_receipt` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_products`
--

CREATE TABLE `purchase_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` double(25,2) NOT NULL DEFAULT 0.00,
  `tax` varchar(50) DEFAULT NULL,
  `discount` double(8,2) NOT NULL DEFAULT 0.00,
  `price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `quotations`
--

CREATE TABLE `quotations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quotation_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `customer_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `warehouse_id` int(11) NOT NULL DEFAULT 0,
  `quotation_date` date DEFAULT NULL,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 0,
  `converted_pos_id` int(11) NOT NULL DEFAULT 0,
  `is_converted` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `quotation_products`
--

CREATE TABLE `quotation_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quotation_id` int(11) NOT NULL DEFAULT 0,
  `product_id` int(11) NOT NULL DEFAULT 0,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `tax` varchar(191) NOT NULL DEFAULT '0.00',
  `discount` double(8,2) DEFAULT 0.00,
  `price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `resignations`
--

CREATE TABLE `resignations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` int(11) NOT NULL DEFAULT 0,
  `notice_date` date NOT NULL,
  `resignation_date` date NOT NULL,
  `description` varchar(191) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `revenues`
--

CREATE TABLE `revenues` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `amount` decimal(16,2) NOT NULL DEFAULT 0.00,
  `account_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `payment_method` int(11) NOT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `add_receipt` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'super admin', 'web', 0, '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(2, 'customer', 'web', 0, '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(3, 'vender', 'web', 0, '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(4, 'company', 'web', 0, '2024-09-05 22:46:50', '2024-09-05 22:46:50'),
(5, 'accountant', 'web', 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(6, 'Employee', 'web', 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(7, 'client', 'web', 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 4),
(2, 4),
(2, 6),
(3, 4),
(3, 6),
(4, 4),
(5, 4),
(5, 6),
(6, 4),
(6, 5),
(6, 6),
(7, 4),
(7, 6),
(8, 4),
(9, 4),
(10, 4),
(12, 4),
(13, 4),
(14, 4),
(15, 4),
(16, 4),
(16, 6),
(17, 4),
(17, 6),
(18, 4),
(18, 6),
(19, 4),
(19, 6),
(20, 4),
(20, 6),
(21, 4),
(21, 5),
(22, 4),
(24, 4),
(24, 5),
(25, 4),
(25, 5),
(26, 4),
(26, 5),
(27, 4),
(27, 5),
(28, 4),
(28, 5),
(28, 6),
(29, 4),
(29, 5),
(29, 6),
(30, 4),
(30, 5),
(30, 6),
(31, 4),
(31, 5),
(32, 2),
(32, 4),
(32, 5),
(32, 6),
(33, 4),
(33, 5),
(33, 6),
(34, 4),
(34, 5),
(35, 4),
(35, 5),
(35, 6),
(36, 4),
(36, 5),
(36, 6),
(37, 4),
(37, 5),
(38, 4),
(38, 5),
(38, 6),
(39, 4),
(39, 5),
(39, 6),
(40, 4),
(40, 5),
(40, 6),
(41, 4),
(41, 5),
(42, 4),
(42, 5),
(42, 6),
(43, 4),
(43, 5),
(43, 6),
(44, 4),
(44, 5),
(44, 6),
(45, 4),
(45, 5),
(46, 4),
(46, 5),
(46, 6),
(47, 4),
(47, 5),
(47, 6),
(48, 4),
(48, 5),
(48, 6),
(49, 4),
(49, 5),
(50, 4),
(50, 5),
(50, 6),
(51, 4),
(51, 5),
(51, 6),
(52, 4),
(52, 5),
(52, 6),
(53, 4),
(53, 5),
(54, 4),
(54, 5),
(54, 6),
(55, 4),
(55, 5),
(55, 6),
(56, 4),
(56, 5),
(56, 6),
(57, 4),
(57, 5),
(58, 2),
(58, 4),
(58, 5),
(58, 6),
(59, 4),
(59, 5),
(59, 6),
(60, 4),
(60, 5),
(60, 6),
(61, 4),
(61, 5),
(61, 6),
(62, 4),
(62, 5),
(63, 3),
(63, 4),
(63, 5),
(63, 6),
(64, 4),
(64, 5),
(64, 6),
(65, 4),
(65, 5),
(65, 6),
(66, 4),
(66, 5),
(66, 6),
(67, 4),
(67, 5),
(68, 4),
(68, 5),
(68, 6),
(69, 4),
(69, 5),
(69, 6),
(70, 4),
(70, 5),
(70, 6),
(71, 4),
(71, 5),
(72, 4),
(72, 5),
(72, 6),
(73, 4),
(73, 5),
(73, 6),
(74, 4),
(74, 5),
(74, 6),
(75, 4),
(75, 5),
(75, 6),
(76, 4),
(76, 5),
(77, 4),
(77, 5),
(77, 6),
(78, 4),
(78, 5),
(78, 6),
(79, 4),
(79, 5),
(79, 6),
(80, 4),
(80, 5),
(81, 3),
(81, 4),
(81, 5),
(81, 6),
(82, 4),
(82, 5),
(82, 6),
(83, 4),
(83, 5),
(83, 6),
(84, 4),
(84, 5),
(84, 6),
(85, 4),
(85, 5),
(86, 4),
(86, 5),
(86, 6),
(87, 4),
(87, 5),
(87, 6),
(88, 4),
(88, 5),
(88, 6),
(89, 4),
(89, 5),
(90, 4),
(91, 4),
(91, 5),
(91, 6),
(92, 4),
(92, 5),
(92, 6),
(93, 4),
(93, 5),
(94, 4),
(94, 5),
(94, 6),
(95, 4),
(95, 5),
(95, 6),
(96, 4),
(96, 5),
(97, 4),
(97, 5),
(97, 6),
(98, 4),
(98, 5),
(99, 2),
(100, 2),
(101, 2),
(102, 3),
(103, 3),
(104, 3),
(105, 3),
(106, 4),
(106, 5),
(106, 6),
(107, 4),
(107, 5),
(107, 6),
(108, 4),
(108, 5),
(108, 6),
(109, 4),
(109, 5),
(110, 4),
(110, 5),
(110, 6),
(111, 4),
(111, 5),
(111, 6),
(112, 4),
(112, 5),
(112, 6),
(113, 4),
(113, 5),
(114, 4),
(114, 6),
(115, 4),
(115, 6),
(116, 4),
(116, 5),
(116, 6),
(117, 4),
(117, 5),
(117, 6),
(118, 4),
(118, 5),
(118, 6),
(119, 4),
(119, 5),
(120, 4),
(120, 5),
(120, 6),
(121, 2),
(121, 4),
(121, 5),
(121, 6),
(122, 4),
(122, 5),
(122, 6),
(123, 4),
(123, 5),
(123, 6),
(124, 2),
(125, 4),
(125, 5),
(125, 6),
(126, 4),
(126, 5),
(126, 6),
(127, 4),
(127, 5),
(127, 6),
(128, 4),
(128, 5),
(129, 4),
(129, 5),
(129, 6),
(130, 4),
(130, 5),
(130, 6),
(131, 4),
(131, 5),
(131, 6),
(132, 4),
(132, 5),
(133, 4),
(133, 5),
(134, 4),
(134, 5),
(134, 6),
(135, 4),
(135, 5),
(135, 6),
(136, 4),
(136, 5),
(136, 6),
(137, 4),
(137, 5),
(138, 4),
(138, 5),
(138, 6),
(139, 4),
(139, 5),
(139, 6),
(140, 4),
(140, 5),
(140, 6),
(141, 4),
(141, 5),
(142, 4),
(142, 5),
(142, 6),
(143, 4),
(143, 5),
(143, 6),
(144, 4),
(144, 5),
(144, 6),
(145, 4),
(145, 5),
(146, 4),
(146, 5),
(146, 6),
(147, 4),
(147, 5),
(148, 4),
(148, 5),
(148, 6),
(149, 4),
(149, 5),
(149, 6),
(150, 4),
(150, 6),
(151, 4),
(151, 6),
(152, 4),
(152, 6),
(153, 4),
(154, 4),
(155, 4),
(156, 4),
(157, 4),
(158, 4),
(159, 4),
(160, 4),
(161, 4),
(162, 4),
(163, 4),
(164, 4),
(164, 6),
(164, 7),
(165, 4),
(165, 6),
(166, 4),
(166, 6),
(167, 4),
(167, 6),
(168, 4),
(168, 6),
(168, 7),
(169, 4),
(169, 6),
(170, 4),
(170, 6),
(171, 4),
(171, 6),
(172, 4),
(173, 4),
(173, 6),
(173, 7),
(174, 4),
(174, 6),
(175, 4),
(175, 6),
(176, 4),
(176, 6),
(177, 4),
(177, 6),
(177, 7),
(178, 4),
(178, 6),
(179, 4),
(179, 6),
(180, 4),
(180, 6),
(181, 4),
(181, 7),
(182, 4),
(183, 4),
(183, 6),
(183, 7),
(184, 4),
(184, 6),
(185, 4),
(185, 6),
(186, 4),
(186, 6),
(187, 4),
(188, 4),
(188, 7),
(189, 4),
(190, 4),
(190, 7),
(191, 4),
(192, 4),
(193, 4),
(194, 4),
(195, 4),
(195, 6),
(195, 7),
(196, 4),
(196, 6),
(197, 4),
(197, 6),
(198, 4),
(198, 6),
(199, 4),
(199, 6),
(200, 4),
(200, 6),
(201, 4),
(201, 6),
(202, 4),
(203, 4),
(203, 6),
(204, 4),
(204, 6),
(205, 4),
(205, 6),
(206, 4),
(206, 6),
(207, 4),
(207, 6),
(208, 4),
(208, 6),
(209, 4),
(210, 4),
(210, 6),
(211, 4),
(211, 6),
(212, 4),
(212, 6),
(213, 4),
(213, 6),
(214, 4),
(215, 4),
(215, 6),
(216, 4),
(216, 6),
(217, 4),
(217, 6),
(218, 4),
(218, 6),
(219, 4),
(220, 4),
(220, 6),
(221, 4),
(221, 6),
(222, 4),
(222, 6),
(223, 4),
(224, 4),
(224, 6),
(225, 4),
(225, 6),
(226, 4),
(226, 6),
(227, 4),
(228, 4),
(228, 6),
(229, 4),
(229, 6),
(230, 4),
(230, 6),
(231, 4),
(232, 4),
(232, 6),
(233, 4),
(233, 6),
(234, 4),
(234, 6),
(235, 4),
(235, 6),
(236, 4),
(236, 6),
(237, 4),
(237, 6),
(238, 4),
(238, 6),
(239, 4),
(239, 6),
(240, 4),
(240, 6),
(241, 4),
(242, 4),
(242, 6),
(243, 4),
(243, 6),
(244, 4),
(244, 6),
(245, 4),
(246, 4),
(246, 6),
(247, 4),
(247, 6),
(248, 4),
(248, 6),
(249, 4),
(250, 4),
(250, 6),
(251, 4),
(251, 6),
(252, 4),
(252, 6),
(253, 4),
(253, 6),
(254, 4),
(254, 6),
(255, 4),
(255, 6),
(256, 4),
(256, 6),
(257, 4),
(257, 6),
(258, 4),
(258, 6),
(259, 4),
(259, 6),
(260, 4),
(260, 6),
(261, 4),
(261, 6),
(262, 4),
(262, 6),
(263, 4),
(263, 6),
(264, 4),
(264, 6),
(265, 4),
(265, 6),
(266, 4),
(266, 6),
(267, 4),
(267, 6),
(268, 4),
(268, 6),
(269, 4),
(269, 6),
(270, 4),
(270, 6),
(271, 4),
(271, 6),
(272, 4),
(272, 6),
(273, 4),
(273, 6),
(274, 4),
(275, 4),
(275, 6),
(276, 4),
(276, 6),
(277, 4),
(277, 6),
(278, 4),
(279, 4),
(279, 6),
(280, 4),
(280, 6),
(281, 4),
(281, 6),
(282, 4),
(283, 4),
(283, 6),
(284, 4),
(284, 6),
(285, 4),
(285, 6),
(286, 4),
(286, 6),
(287, 4),
(288, 4),
(288, 6),
(289, 4),
(289, 6),
(290, 4),
(290, 6),
(291, 4),
(292, 4),
(292, 6),
(293, 4),
(293, 6),
(294, 4),
(294, 6),
(295, 4),
(295, 6),
(296, 4),
(297, 4),
(297, 6),
(298, 4),
(298, 6),
(299, 4),
(299, 6),
(300, 4),
(301, 4),
(301, 6),
(302, 4),
(302, 6),
(303, 4),
(303, 6),
(304, 4),
(305, 4),
(305, 6),
(306, 4),
(306, 6),
(307, 4),
(307, 6),
(308, 4),
(309, 4),
(309, 6),
(310, 4),
(310, 6),
(311, 4),
(311, 6),
(312, 4),
(313, 4),
(313, 6),
(314, 4),
(314, 6),
(315, 4),
(315, 6),
(316, 4),
(317, 4),
(317, 6),
(318, 4),
(318, 6),
(319, 4),
(319, 6),
(320, 4),
(321, 4),
(321, 6),
(322, 4),
(322, 6),
(323, 4),
(323, 6),
(324, 4),
(325, 4),
(325, 6),
(326, 4),
(326, 6),
(327, 4),
(327, 6),
(328, 4),
(329, 4),
(329, 6),
(330, 4),
(330, 6),
(331, 4),
(331, 6),
(332, 4),
(333, 4),
(333, 6),
(334, 4),
(334, 6),
(335, 4),
(335, 6),
(336, 4),
(337, 4),
(337, 6),
(338, 4),
(338, 6),
(339, 4),
(339, 6),
(340, 4),
(341, 4),
(341, 6),
(342, 4),
(343, 4),
(343, 6),
(344, 4),
(344, 6),
(345, 4),
(345, 6),
(346, 4),
(346, 6),
(347, 4),
(347, 6),
(348, 4),
(348, 6),
(349, 4),
(350, 4),
(350, 6),
(351, 4),
(351, 6),
(352, 4),
(352, 6),
(353, 4),
(353, 6),
(354, 4),
(355, 4),
(355, 6),
(356, 4),
(356, 6),
(357, 4),
(357, 6),
(358, 4),
(359, 4),
(360, 4),
(361, 4),
(362, 4),
(363, 4),
(363, 6),
(364, 4),
(364, 6),
(365, 4),
(365, 6),
(366, 4),
(367, 4),
(367, 6),
(368, 4),
(368, 6),
(369, 4),
(369, 6),
(370, 4),
(371, 4),
(371, 6),
(372, 4),
(372, 6),
(373, 4),
(373, 6),
(374, 4),
(375, 4),
(375, 6),
(376, 4),
(376, 6),
(377, 4),
(378, 4),
(378, 6),
(379, 4),
(380, 4),
(380, 6),
(381, 4),
(381, 6),
(382, 4),
(382, 6),
(383, 4),
(384, 4),
(384, 6),
(385, 4),
(385, 6),
(386, 4),
(386, 6),
(387, 4),
(388, 4),
(388, 6),
(389, 4),
(389, 6),
(390, 4),
(390, 6),
(391, 4),
(392, 4),
(392, 6),
(393, 4),
(393, 6),
(394, 4),
(394, 6),
(395, 4),
(396, 4),
(396, 6),
(397, 4),
(397, 6),
(398, 4),
(398, 6),
(399, 4),
(400, 4),
(400, 6),
(401, 4),
(401, 6),
(402, 4),
(402, 6),
(403, 4),
(404, 4),
(404, 6),
(405, 4),
(405, 6),
(406, 4),
(406, 6),
(407, 4),
(408, 4),
(408, 6),
(409, 4),
(409, 6),
(409, 7),
(410, 4),
(410, 6),
(411, 4),
(411, 6),
(411, 7),
(412, 4),
(412, 6),
(413, 4),
(413, 6),
(414, 4),
(415, 4),
(415, 6),
(416, 4),
(416, 6),
(417, 4),
(417, 6),
(418, 4),
(418, 6),
(419, 4),
(419, 6),
(419, 7),
(420, 4),
(420, 6),
(421, 4),
(421, 6),
(422, 4),
(422, 6),
(423, 4),
(423, 6),
(424, 4),
(424, 6),
(424, 7),
(425, 4),
(426, 4),
(426, 6),
(426, 7),
(427, 4),
(427, 6),
(427, 7),
(428, 4),
(428, 6),
(428, 7),
(429, 4),
(429, 6),
(429, 7),
(430, 4),
(430, 6),
(430, 7),
(431, 4),
(431, 6),
(431, 7),
(432, 4),
(432, 6),
(433, 4),
(433, 6),
(434, 4),
(434, 6),
(435, 4),
(435, 6),
(436, 4),
(436, 6),
(437, 4),
(437, 6),
(437, 7),
(438, 4),
(438, 6),
(439, 4),
(439, 6),
(440, 4),
(440, 6),
(441, 4),
(441, 6),
(441, 7),
(442, 4),
(442, 6),
(442, 7),
(443, 4),
(443, 6),
(443, 7),
(444, 4),
(444, 6),
(444, 7),
(445, 4),
(445, 6),
(445, 7),
(446, 4),
(446, 6),
(447, 4),
(447, 6),
(448, 4),
(448, 6),
(449, 4),
(449, 6),
(450, 7),
(453, 4),
(460, 4),
(461, 4),
(462, 4),
(463, 4),
(464, 4),
(465, 4),
(466, 4),
(467, 4),
(468, 4),
(469, 4),
(470, 4),
(471, 4),
(472, 4),
(473, 4),
(474, 4),
(474, 6),
(475, 4),
(475, 5),
(476, 4),
(476, 5),
(477, 4),
(477, 5),
(478, 4),
(478, 5),
(479, 4),
(479, 5),
(480, 4),
(480, 6),
(481, 4),
(481, 6),
(482, 4),
(482, 6),
(483, 4),
(483, 6),
(484, 4),
(485, 4),
(485, 6),
(486, 4),
(486, 6),
(487, 4),
(487, 6),
(488, 4),
(488, 6),
(489, 4),
(490, 4),
(490, 6),
(491, 4),
(491, 6),
(492, 4),
(493, 4),
(493, 6),
(494, 4),
(494, 6),
(495, 4),
(495, 6),
(496, 4),
(496, 6),
(497, 4),
(497, 6),
(498, 4),
(498, 7),
(499, 4),
(500, 4),
(501, 4),
(502, 4),
(502, 7),
(503, 4),
(503, 5),
(503, 6),
(504, 4),
(504, 5),
(505, 4),
(505, 5),
(506, 4),
(506, 5),
(507, 4),
(507, 6),
(508, 4),
(508, 6),
(509, 4),
(509, 6),
(510, 4),
(510, 6),
(511, 4),
(511, 6),
(512, 4),
(512, 6),
(513, 4),
(513, 6),
(514, 4),
(515, 4),
(515, 6),
(516, 4),
(516, 6),
(517, 4),
(518, 4),
(518, 6),
(519, 4),
(519, 6),
(520, 4),
(521, 4),
(521, 6),
(522, 4);

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

--
-- Table structure for table `saturation_deductions`
--

CREATE TABLE `saturation_deductions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` int(11) NOT NULL,
  `deduction_option` int(11) NOT NULL,
  `title` varchar(191) NOT NULL,
  `amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `type` varchar(191) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `value` text DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `name`, `value`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'local_storage_validation', 'jpg,jpeg,png,xlsx,xls,csv,pdf', 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(2, 'wasabi_storage_validation', 'jpg,jpeg,png,xlsx,xls,csv,pdf', 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(3, 's3_storage_validation', 'jpg,jpeg,png,xlsx,xls,csv,pdf', 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(4, 'local_storage_max_upload_size', '2048000', 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(5, 'wasabi_max_upload_size', '2048000', 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(6, 's3_max_upload_size', '2048000', 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(7, 'title_text', NULL, 1, NULL, NULL),
(8, 'footer_text', NULL, 1, NULL, NULL),
(9, 'default_language', 'en', 1, NULL, NULL),
(10, 'display_landing_page', 'on', 1, NULL, NULL),
(11, 'color', 'theme-6', 1, NULL, NULL),
(12, 'color_flag', 'false', 1, NULL, NULL),
(13, 'cust_theme_bg', 'on', 1, NULL, NULL),
(14, 'SITE_RTL', 'off', 1, NULL, NULL),
(15, 'gdpr_cookie', 'off', 1, NULL, NULL),
(16, 'cust_darklayout', 'off', 1, NULL, NULL),
(37, 'site_currency', 'USD', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(38, 'site_currency_symbol', '$', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(39, 'site_currency_symbol_position', 'pre', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(40, 'decimal_number', '2', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(41, 'site_date_format', 'M j, Y', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(42, 'site_time_format', 'g:i A', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(43, 'customer_prefix', '#CUST', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(44, 'vender_prefix', '#VEND', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(45, 'proposal_prefix', '#PROP', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(46, 'invoice_prefix', '#INVO', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(47, 'bill_prefix', '#BILL', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(48, 'quotation_prefix', '#QUO', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(49, 'purchase_prefix', '#PUR', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(50, 'pos_prefix', '#POS', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(51, 'journal_prefix', '#JUR', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(52, 'expense_prefix', '#EXP', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(53, 'shipping_display', 'on', 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(54, 'footer_title', NULL, 1, '2024-09-05 22:55:12', '2024-09-05 22:55:12'),
(111, 'footer_notes', '<p>gdgd</p>', 1, '2024-10-07 04:55:23', '2024-10-07 04:55:23'),
(123, 'purchase_template', 'template4', 1, NULL, NULL),
(124, 'purchase_color', 'ffffff', 1, NULL, NULL);

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

--
-- Table structure for table `set_salaries`
--

CREATE TABLE `set_salaries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sources`
--

CREATE TABLE `sources` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sources`
--

INSERT INTO `sources` (`id`, `name`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Websites', 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(2, 'Facebook', 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(3, 'Naukari.com', 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(4, 'Phone', 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(5, 'LinkedIn', 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51');

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

--
-- Table structure for table `stages`
--

CREATE TABLE `stages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `pipeline_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stages`
--

INSERT INTO `stages` (`id`, `name`, `pipeline_id`, `created_by`, `order`, `created_at`, `updated_at`) VALUES
(1, 'Draft', 1, 1, 0, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(2, 'Sent', 1, 1, 0, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(3, 'Open', 1, 1, 0, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(4, 'Revised', 1, 1, 0, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(5, 'Declined', 1, 1, 0, '2024-09-05 22:46:51', '2024-09-05 22:46:51');

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

--
-- Table structure for table `stock_reports`
--

CREATE TABLE `stock_reports` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` int(11) NOT NULL DEFAULT 0,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `type` varchar(191) NOT NULL,
  `type_id` int(11) NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `supports`
--

CREATE TABLE `supports` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `subject` varchar(191) NOT NULL,
  `ticket_created` int(11) NOT NULL DEFAULT 0,
  `user` int(11) NOT NULL DEFAULT 0,
  `priority` varchar(191) NOT NULL,
  `end_date` date NOT NULL,
  `ticket_code` varchar(191) DEFAULT NULL,
  `status` varchar(191) NOT NULL DEFAULT '0',
  `attachment` varchar(191) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_replies`
--

CREATE TABLE `support_replies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `support_id` int(11) NOT NULL,
  `user` int(11) NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `is_read` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `task_checklists`
--

CREATE TABLE `task_checklists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `task_id` int(11) NOT NULL,
  `user_type` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `task_comments`
--

CREATE TABLE `task_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `comment` text NOT NULL,
  `task_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_type` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `task_files`
--

CREATE TABLE `task_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `file` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `extension` varchar(191) NOT NULL,
  `file_size` varchar(191) NOT NULL,
  `task_id` int(11) NOT NULL,
  `user_type` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `task_stages`
--

CREATE TABLE `task_stages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `complete` tinyint(1) NOT NULL DEFAULT 0,
  `project_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `color` varchar(15) DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `task_stages`
--

INSERT INTO `task_stages` (`id`, `name`, `complete`, `project_id`, `color`, `order`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'To Do', 0, 0, NULL, 0, 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(2, 'In Progress', 0, 0, NULL, 1, 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(3, 'Review', 0, 0, NULL, 2, 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(4, 'Done', 0, 0, NULL, 3, 1, '2024-09-05 22:46:51', '2024-09-05 22:46:51');

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

--
-- Table structure for table `taxes`
--

CREATE TABLE `taxes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `rate` text NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `template_name` varchar(191) NOT NULL,
  `prompt` text NOT NULL,
  `module` varchar(191) NOT NULL,
  `field_json` text NOT NULL,
  `is_tone` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `terminations`
--

CREATE TABLE `terminations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` int(11) NOT NULL DEFAULT 0,
  `notice_date` date NOT NULL,
  `termination_date` date NOT NULL,
  `termination_type` varchar(191) DEFAULT NULL,
  `description` varchar(191) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `termination_types`
--

CREATE TABLE `termination_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `termination_types`
--

INSERT INTO `termination_types` (`id`, `name`, `created_by`, `created_at`, `updated_at`) VALUES
(1, '3 Month Termination', 1, '2024-10-07 03:23:19', '2024-10-07 03:23:19');

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

--
-- Table structure for table `timesheets`
--

CREATE TABLE `timesheets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `project_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL DEFAULT 0,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `description` text DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `time_trackers`
--

CREATE TABLE `time_trackers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `project_id` int(11) DEFAULT NULL,
  `task_id` int(11) DEFAULT NULL,
  `tag_id` text DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `is_billable` int(11) NOT NULL DEFAULT 0,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `total_time` varchar(191) NOT NULL DEFAULT '0',
  `is_active` varchar(191) NOT NULL DEFAULT '1',
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `track_photos`
--

CREATE TABLE `track_photos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `track_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `img_path` varchar(191) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `trainers`
--

CREATE TABLE `trainers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `branch` varchar(191) NOT NULL,
  `firstname` varchar(191) NOT NULL,
  `lastname` varchar(191) NOT NULL,
  `contact` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `address` text DEFAULT NULL,
  `expertise` text DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `trainings`
--

CREATE TABLE `trainings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `branch` int(11) NOT NULL,
  `trainer_option` int(11) NOT NULL,
  `training_type` int(11) NOT NULL,
  `trainer` int(11) NOT NULL,
  `training_cost` double(8,2) NOT NULL DEFAULT 0.00,
  `employee` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `description` text DEFAULT NULL,
  `performance` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 0,
  `remarks` text DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `training_types`
--

CREATE TABLE `training_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `training_types`
--

INSERT INTO `training_types` (`id`, `name`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'New Training', 1, '2024-10-07 03:22:41', '2024-10-07 03:22:41');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_type` varchar(191) NOT NULL,
  `account` int(11) NOT NULL,
  `type` varchar(191) DEFAULT NULL,
  `amount` decimal(16,2) NOT NULL DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `date` date NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `payment_id` int(11) NOT NULL DEFAULT 0,
  `category` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `transaction_lines`
--

CREATE TABLE `transaction_lines` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `account_id` int(11) NOT NULL,
  `reference` varchar(191) NOT NULL,
  `reference_id` int(11) NOT NULL,
  `reference_sub_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `credit` decimal(15,2) NOT NULL DEFAULT 0.00,
  `debit` decimal(15,2) NOT NULL DEFAULT 0.00,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `transfers`
--

CREATE TABLE `transfers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` int(11) NOT NULL DEFAULT 0,
  `branch_id` int(11) NOT NULL DEFAULT 0,
  `department_id` int(11) NOT NULL DEFAULT 0,
  `transfer_date` date NOT NULL,
  `description` varchar(191) DEFAULT NULL,
  `created_by` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `travels`
--

CREATE TABLE `travels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` int(11) NOT NULL DEFAULT 0,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `purpose_of_visit` varchar(191) DEFAULT NULL,
  `place_of_visit` varchar(191) DEFAULT NULL,
  `description` varchar(191) DEFAULT NULL,
  `created_by` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `email` varchar(191) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) DEFAULT NULL,
  `plan` int(11) DEFAULT NULL,
  `plan_expire_date` date DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `avatar` varchar(191) NOT NULL DEFAULT 'avatar.png',
  `messenger_color` varchar(191) NOT NULL DEFAULT '#2180f3',
  `lang` varchar(100) DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `default_pipeline` int(11) DEFAULT NULL,
  `active_status` tinyint(1) NOT NULL DEFAULT 0,
  `delete_status` int(11) NOT NULL DEFAULT 1,
  `mode` varchar(10) NOT NULL DEFAULT 'light',
  `dark_mode` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `is_enable_login` int(11) NOT NULL DEFAULT 1,
  `last_login_at` datetime DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `plan`, `plan_expire_date`, `type`, `avatar`, `messenger_color`, `lang`, `created_by`, `default_pipeline`, `active_status`, `delete_status`, `mode`, `dark_mode`, `is_active`, `is_enable_login`, `last_login_at`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'company', 'company@example.com', NULL, '$2y$10$YF77d3CGD8E2DyGcEgfwo.yMOSuLncsEyYDnW6Qyhs5GBIxG0N9V6', 1, NULL, 'company', '', '#2180f3', 'en', 1, 1, 0, 1, 'light', 0, 1, 1, '2024-10-13 02:48:32', NULL, '2024-09-05 22:46:51', '2024-10-13 02:48:32'),
(2, 'Abdullah Md. Muraiem', 'accountant@example.com', NULL, '$2y$10$VdjxNILmPLBltoFlrB5qiOcynvGZ5kg2babhLPJJURVFXlfZZxk1G', NULL, NULL, 'accountant', '', '#2180f3', 'en', 1, 1, 0, 1, 'light', 0, 1, 1, '2024-10-09 05:25:05', NULL, '2024-09-05 22:46:51', '2024-10-09 05:25:05'),
(4, 'client', 'client@example.com', NULL, '$2y$10$7xbXAF8Bn8FgeGJ1w1KZEu5ccggQ8aISnnQKZbSSMNDLngLgFeIta', NULL, NULL, 'client', '', '#2180f3', 'en', 1, 1, 0, 1, 'light', 0, 1, 1, NULL, NULL, '2024-09-05 22:46:51', '2024-09-05 22:46:51'),
(5, 'erazehan', 'jpkerazehan@gmail.com', NULL, '$2y$10$K9nzthTTWIK9PoTSxsn42uUWrsedrnex3Z/iaiIb9IHpVOswPPDzy', NULL, NULL, 'Employee', 'avatar.png', '#2180f3', 'en', 1, NULL, 0, 1, 'light', 0, 1, 1, '2024-10-13 02:13:37', NULL, '2024-10-10 05:50:23', '2024-10-13 02:13:37'),
(6, 'mdkamrulhasan', 'mdkamrulhasan@erazehanintl.com', NULL, '$2y$10$u4reAsoLRK6w5R49gnprNeRP1MUYYVS9y4UoN/jC5EtW/RsgULAg2', NULL, NULL, 'Employee', 'avatar.png', '#2180f3', 'en', 1, NULL, 0, 1, 'light', 0, 1, 1, NULL, NULL, '2024-10-12 06:15:08', '2024-10-12 06:15:08'),
(7, 'sumayatabassum', 'sumayatabassum@erazehanintl.com', NULL, '$2y$10$VQXkpVTL8bcNASQtFcAmd.jMKnqNIWlg076RLNIfbfMHiYdbpqJKi', NULL, NULL, 'Employee', 'avatar.png', '#2180f3', 'en', 1, NULL, 0, 1, 'light', 0, 1, 1, '2024-10-13 02:13:58', NULL, '2024-10-12 06:16:17', '2024-10-13 02:13:58'),
(8, 'shahidurrahamanshahid', 'shahidurrahamanshahid@erazehanintl.com', NULL, '$2y$10$kOi0m8N6at2NpFqkzQyGk.3j/7Xc3topP6ghrC9OWz4oCM9QBHXoa', NULL, NULL, 'Employee', 'avatar.png', '#2180f3', 'en', 1, NULL, 0, 1, 'light', 0, 1, 1, '2024-10-13 02:49:25', NULL, '2024-10-12 06:17:11', '2024-10-13 02:49:25'),
(9, 'mdnasirkhan', 'mdnasirkhan@khanplacementltd.com', NULL, '$2y$10$iuTQEsgbDobQAtSF.FFcuOfW9Js51ROcvpVrREBF9Aebe2u6wb4US', NULL, NULL, 'Employee', 'avatar.png', '#2180f3', 'en', 1, NULL, 0, 1, 'light', 0, 1, 1, NULL, NULL, '2024-10-12 06:17:56', '2024-10-12 06:17:56'),
(10, 'mdzakariahabib', 'mdzakariahabib@erazehanintl.com', NULL, '$2y$10$atY0rNWOM0VClzpEXhnwbOBxyX5vnRGi/XtzsJzB7Ub0sLclj87By', NULL, NULL, 'Employee', 'avatar.png', '#2180f3', 'en', 1, NULL, 0, 1, 'light', 0, 1, 1, NULL, NULL, '2024-10-12 06:18:44', '2024-10-12 06:18:44');

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

--
-- Table structure for table `user_contacts`
--

CREATE TABLE `user_contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_coupons`
--

CREATE TABLE `user_coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user` int(11) NOT NULL,
  `coupon` int(11) NOT NULL,
  `order` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_deals`
--

CREATE TABLE `user_deals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `deal_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_email_templates`
--

CREATE TABLE `user_email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `template_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_email_templates`
--

INSERT INTO `user_email_templates` (`id`, `template_id`, `user_id`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(2, 2, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(3, 3, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(4, 4, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(5, 5, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(6, 6, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(7, 7, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(8, 8, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(9, 9, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(10, 10, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(11, 11, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(12, 12, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(13, 13, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(14, 14, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(15, 15, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(16, 16, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(17, 17, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(18, 18, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(19, 19, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(20, 20, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(21, 21, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(22, 22, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52'),
(23, 23, 1, 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52');

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

--
-- Table structure for table `user_leads`
--

CREATE TABLE `user_leads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_to_dos`
--

CREATE TABLE `user_to_dos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `is_complete` tinyint(1) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `venders`
--

CREATE TABLE `venders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `vender_id` int(11) NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `email` varchar(191) NOT NULL,
  `tax_number` varchar(191) DEFAULT NULL,
  `password` varchar(191) DEFAULT NULL,
  `contact` varchar(191) DEFAULT NULL,
  `avatar` varchar(100) NOT NULL DEFAULT '',
  `created_by` int(11) NOT NULL DEFAULT 0,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `billing_name` varchar(191) DEFAULT NULL,
  `billing_country` varchar(191) DEFAULT NULL,
  `billing_state` varchar(191) DEFAULT NULL,
  `billing_city` varchar(191) DEFAULT NULL,
  `billing_phone` varchar(191) DEFAULT NULL,
  `billing_zip` varchar(191) DEFAULT NULL,
  `billing_address` text DEFAULT NULL,
  `shipping_name` varchar(191) DEFAULT NULL,
  `shipping_country` varchar(191) DEFAULT NULL,
  `shipping_state` varchar(191) DEFAULT NULL,
  `shipping_city` varchar(191) DEFAULT NULL,
  `shipping_phone` varchar(191) DEFAULT NULL,
  `shipping_zip` varchar(191) DEFAULT NULL,
  `shipping_address` text DEFAULT NULL,
  `lang` varchar(191) NOT NULL DEFAULT 'en',
  `balance` double(8,2) NOT NULL DEFAULT 0.00,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `vendors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_details` text NOT NULL,
  `attachment` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `visa_type` varchar(191) DEFAULT NULL,
  `vendor_name` varchar(191) DEFAULT NULL,
  `amount_paid` decimal(10,2) NOT NULL DEFAULT 0.00,
  `amount_due` decimal(10,2) NOT NULL DEFAULT 0.00,
  `unique_code` varchar(191) DEFAULT NULL,
  `unit_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `refund` decimal(10,2) NOT NULL DEFAULT 0.00,
  `attachment2` varchar(191) DEFAULT NULL,
  `attachmen3` varchar(191) DEFAULT NULL,
  `visa_country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `attachment4` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vexcat`
--

CREATE TABLE `vexcat` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_name` varchar(191) NOT NULL,
  `category_description` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vexpense`
--

CREATE TABLE `vexpense` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `expense_name` varchar(191) DEFAULT NULL,
  `expense_type` varchar(191) DEFAULT NULL,
  `expense_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `expense_date` date DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `vexcat_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vledger`
--

CREATE TABLE `vledger` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` date DEFAULT NULL,
  `paid_for` varchar(191) DEFAULT NULL,
  `unit_pirce` double(10,2) NOT NULL DEFAULT 0.00,
  `number_of_unit` int(11) NOT NULL DEFAULT 1,
  `payment_mode` varchar(191) DEFAULT NULL,
  `amount` double(10,2) NOT NULL DEFAULT 0.00,
  `advance` double(10,2) NOT NULL DEFAULT 0.00,
  `due` double(10,2) NOT NULL DEFAULT 0.00,
  `refund` double(10,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `warehouses`
--

CREATE TABLE `warehouses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `address` text NOT NULL,
  `city` varchar(191) NOT NULL,
  `city_zip` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `warehouses`
--

INSERT INTO `warehouses` (`id`, `name`, `address`, `city`, `city_zip`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'North Warehouse', '723 N. Tillamook Street Portland, OR Portland, United States', 'Portland', '97227', 1, '2024-09-05 22:46:52', '2024-09-05 22:46:52');

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

--
-- Table structure for table `warehouse_products`
--

CREATE TABLE `warehouse_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `warehouse_id` int(11) NOT NULL DEFAULT 0,
  `product_id` int(11) NOT NULL DEFAULT 0,
  `quantity` double(25,2) NOT NULL DEFAULT 0.00,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `warehouse_transfers`
--

CREATE TABLE `warehouse_transfers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `from_warehouse` int(11) NOT NULL DEFAULT 0,
  `to_warehouse` int(11) NOT NULL DEFAULT 0,
  `product_id` int(11) NOT NULL DEFAULT 0,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `date` date DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `warnings`
--

CREATE TABLE `warnings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `warning_to` int(11) NOT NULL,
  `warning_by` int(11) NOT NULL,
  `subject` varchar(191) DEFAULT NULL,
  `warning_date` date NOT NULL,
  `description` varchar(191) DEFAULT NULL,
  `created_by` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `webhook_settings`
--

CREATE TABLE `webhook_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `module` varchar(191) DEFAULT NULL,
  `url` varchar(191) DEFAULT NULL,
  `method` varchar(191) DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `zoom_meetings`
--

CREATE TABLE `zoom_meetings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `meeting_id` int(11) NOT NULL DEFAULT 0,
  `project_id` int(11) NOT NULL DEFAULT 0,
  `user_id` varchar(191) DEFAULT NULL,
  `client_id` int(11) NOT NULL DEFAULT 0,
  `password` varchar(191) DEFAULT NULL,
  `start_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `duration` int(11) NOT NULL DEFAULT 0,
  `start_url` text DEFAULT NULL,
  `join_url` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT 'waiting',
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `admin_payment_settings`
--
ALTER TABLE `admin_payment_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_payment_settings_name_created_by_unique` (`name`,`created_by`);

--
-- Indexes for table `agents`
--
ALTER TABLE `agents`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `agents_unique_code_unique` (`unique_code`),
  ADD KEY `agents_visa_country_id_foreign` (`visa_country_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `clients_unique_code_unique` (`unique_code`),
  ADD KEY `clients_agent_id_foreign` (`agent_id`),
  ADD KEY `clients_vendor_id_foreign` (`vendor_id`),
  ADD KEY `clients_visa_country_id_foreign` (`visa_country_id`);

--
-- Indexes for table `client_deals`
--
ALTER TABLE `client_deals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `client_deals_client_id_foreign` (`client_id`),
  ADD KEY `client_deals_deal_id_foreign` (`deal_id`);

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

--
-- Indexes for table `company_payment_settings`
--
ALTER TABLE `company_payment_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `company_payment_settings_name_created_by_unique` (`name`,`created_by`);

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `custom_field_values`
--
ALTER TABLE `custom_field_values`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `custom_field_values_record_id_field_id_unique` (`record_id`,`field_id`),
  ADD KEY `custom_field_values_field_id_foreign` (`field_id`);

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

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

--
-- Indexes for table `deal_calls`
--
ALTER TABLE `deal_calls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deal_calls_deal_id_foreign` (`deal_id`);

--
-- Indexes for table `deal_discussions`
--
ALTER TABLE `deal_discussions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deal_discussions_deal_id_foreign` (`deal_id`);

--
-- Indexes for table `deal_emails`
--
ALTER TABLE `deal_emails`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deal_emails_deal_id_foreign` (`deal_id`);

--
-- Indexes for table `deal_files`
--
ALTER TABLE `deal_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deal_files_deal_id_foreign` (`deal_id`);

--
-- Indexes for table `deal_tasks`
--
ALTER TABLE `deal_tasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deal_tasks_deal_id_foreign` (`deal_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `form_builders`
--
ALTER TABLE `form_builders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `form_builders_code_unique` (`code`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `join_us`
--
ALTER TABLE `join_us`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `join_us_email_unique` (`email`);

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

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

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

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

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

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

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

--
-- Indexes for table `lead_calls`
--
ALTER TABLE `lead_calls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lead_calls_lead_id_foreign` (`lead_id`);

--
-- Indexes for table `lead_discussions`
--
ALTER TABLE `lead_discussions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lead_discussions_lead_id_foreign` (`lead_id`);

--
-- Indexes for table `lead_emails`
--
ALTER TABLE `lead_emails`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lead_emails_lead_id_foreign` (`lead_id`);

--
-- Indexes for table `lead_files`
--
ALTER TABLE `lead_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lead_files_lead_id_foreign` (`lead_id`);

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

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

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

--
-- Indexes for table `ledger`
--
ALTER TABLE `ledger`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ledger_agent_id_foreign` (`agent_id`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

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

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

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `orders_order_id_unique` (`order_id`);

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

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

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

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

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

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

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_name_created_by_unique` (`name`,`created_by`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

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

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

--
-- Indexes for table `user_deals`
--
ALTER TABLE `user_deals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_deals_user_id_foreign` (`user_id`),
  ADD KEY `user_deals_deal_id_foreign` (`deal_id`);

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

--
-- Indexes for table `user_leads`
--
ALTER TABLE `user_leads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_leads_user_id_foreign` (`user_id`),
  ADD KEY `user_leads_lead_id_foreign` (`lead_id`);

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

--
-- Indexes for table `venders`
--
ALTER TABLE `venders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `venders_email_unique` (`email`);

--
-- Indexes for table `vendors`
--
ALTER TABLE `vendors`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `vendors_unique_code_unique` (`unique_code`),
  ADD KEY `vendors_visa_country_id_foreign` (`visa_country_id`);

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

--
-- Indexes for table `vexpense`
--
ALTER TABLE `vexpense`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vexpense_vexcat_id_foreign` (`vexcat_id`);

--
-- Indexes for table `vledger`
--
ALTER TABLE `vledger`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vledger_vendor_id_foreign` (`vendor_id`);

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_logs`
--
ALTER TABLE `activity_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_payment_settings`
--
ALTER TABLE `admin_payment_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `agents`
--
ALTER TABLE `agents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `allowances`
--
ALTER TABLE `allowances`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `allowance_options`
--
ALTER TABLE `allowance_options`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `announcements`
--
ALTER TABLE `announcements`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `announcement_employees`
--
ALTER TABLE `announcement_employees`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `appraisals`
--
ALTER TABLE `appraisals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `assets`
--
ALTER TABLE `assets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `attendance_employees`
--
ALTER TABLE `attendance_employees`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `awards`
--
ALTER TABLE `awards`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `award_types`
--
ALTER TABLE `award_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `bank_accounts`
--
ALTER TABLE `bank_accounts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `bank_transfers`
--
ALTER TABLE `bank_transfers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bills`
--
ALTER TABLE `bills`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bill_accounts`
--
ALTER TABLE `bill_accounts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bill_payments`
--
ALTER TABLE `bill_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bill_products`
--
ALTER TABLE `bill_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `branches`
--
ALTER TABLE `branches`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `budgets`
--
ALTER TABLE `budgets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bugs`
--
ALTER TABLE `bugs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bug_comments`
--
ALTER TABLE `bug_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bug_files`
--
ALTER TABLE `bug_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bug_statuses`
--
ALTER TABLE `bug_statuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `chart_of_accounts`
--
ALTER TABLE `chart_of_accounts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;

--
-- AUTO_INCREMENT for table `chart_of_account_parents`
--
ALTER TABLE `chart_of_account_parents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `chart_of_account_sub_types`
--
ALTER TABLE `chart_of_account_sub_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `chart_of_account_types`
--
ALTER TABLE `chart_of_account_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `client_deals`
--
ALTER TABLE `client_deals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `commissions`
--
ALTER TABLE `commissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `company_payment_settings`
--
ALTER TABLE `company_payment_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `company_policies`
--
ALTER TABLE `company_policies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `competencies`
--
ALTER TABLE `competencies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `complaints`
--
ALTER TABLE `complaints`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contracts`
--
ALTER TABLE `contracts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contract_attachment`
--
ALTER TABLE `contract_attachment`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contract_comment`
--
ALTER TABLE `contract_comment`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contract_notes`
--
ALTER TABLE `contract_notes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contract_types`
--
ALTER TABLE `contract_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `credit_notes`
--
ALTER TABLE `credit_notes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `custom_fields`
--
ALTER TABLE `custom_fields`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `custom_field_values`
--
ALTER TABLE `custom_field_values`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `custom_questions`
--
ALTER TABLE `custom_questions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deals`
--
ALTER TABLE `deals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deal_calls`
--
ALTER TABLE `deal_calls`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deal_discussions`
--
ALTER TABLE `deal_discussions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deal_emails`
--
ALTER TABLE `deal_emails`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deal_files`
--
ALTER TABLE `deal_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deal_tasks`
--
ALTER TABLE `deal_tasks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `debit_notes`
--
ALTER TABLE `debit_notes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deduction_options`
--
ALTER TABLE `deduction_options`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `departments`
--
ALTER TABLE `departments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `designations`
--
ALTER TABLE `designations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `ducument_uploads`
--
ALTER TABLE `ducument_uploads`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `email_template_langs`
--
ALTER TABLE `email_template_langs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=362;

--
-- AUTO_INCREMENT for table `employees`
--
ALTER TABLE `employees`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `employee_documents`
--
ALTER TABLE `employee_documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `estimations`
--
ALTER TABLE `estimations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `event_employees`
--
ALTER TABLE `event_employees`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `experience_certificates`
--
ALTER TABLE `experience_certificates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `form_builders`
--
ALTER TABLE `form_builders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `form_fields`
--
ALTER TABLE `form_fields`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `form_field_responses`
--
ALTER TABLE `form_field_responses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `form_responses`
--
ALTER TABLE `form_responses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `generate_offer_letters`
--
ALTER TABLE `generate_offer_letters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `genrate_payslip_options`
--
ALTER TABLE `genrate_payslip_options`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `goals`
--
ALTER TABLE `goals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `goal_trackings`
--
ALTER TABLE `goal_trackings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `goal_types`
--
ALTER TABLE `goal_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `holidays`
--
ALTER TABLE `holidays`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `indicators`
--
ALTER TABLE `indicators`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `interview_schedules`
--
ALTER TABLE `interview_schedules`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoices`
--
ALTER TABLE `invoices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice_bank_transfers`
--
ALTER TABLE `invoice_bank_transfers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice_payments`
--
ALTER TABLE `invoice_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice_products`
--
ALTER TABLE `invoice_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ip_restricts`
--
ALTER TABLE `ip_restricts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `job_applications`
--
ALTER TABLE `job_applications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `job_application_notes`
--
ALTER TABLE `job_application_notes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `job_categories`
--
ALTER TABLE `job_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `job_on_boards`
--
ALTER TABLE `job_on_boards`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `job_stages`
--
ALTER TABLE `job_stages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `joining_letters`
--
ALTER TABLE `joining_letters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `join_us`
--
ALTER TABLE `join_us`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `journal_entries`
--
ALTER TABLE `journal_entries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `journal_items`
--
ALTER TABLE `journal_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `labels`
--
ALTER TABLE `labels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `landing_page_settings`
--
ALTER TABLE `landing_page_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `leads`
--
ALTER TABLE `leads`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lead_activity_logs`
--
ALTER TABLE `lead_activity_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lead_calls`
--
ALTER TABLE `lead_calls`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lead_discussions`
--
ALTER TABLE `lead_discussions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lead_emails`
--
ALTER TABLE `lead_emails`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lead_files`
--
ALTER TABLE `lead_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lead_stages`
--
ALTER TABLE `lead_stages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `leaves`
--
ALTER TABLE `leaves`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `leave_types`
--
ALTER TABLE `leave_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `ledger`
--
ALTER TABLE `ledger`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `loans`
--
ALTER TABLE `loans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loan_options`
--
ALTER TABLE `loan_options`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `login_details`
--
ALTER TABLE `login_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `log_activities`
--
ALTER TABLE `log_activities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meetings`
--
ALTER TABLE `meetings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meeting_employees`
--
ALTER TABLE `meeting_employees`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=226;

--
-- AUTO_INCREMENT for table `milestones`
--
ALTER TABLE `milestones`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `noc_certificates`
--
ALTER TABLE `noc_certificates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notification_templates`
--
ALTER TABLE `notification_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `notification_template_langs`
--
ALTER TABLE `notification_template_langs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=417;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `other_payments`
--
ALTER TABLE `other_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `overtimes`
--
ALTER TABLE `overtimes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payslip_types`
--
ALTER TABLE `payslip_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pay_slips`
--
ALTER TABLE `pay_slips`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `performance_types`
--
ALTER TABLE `performance_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=523;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pipelines`
--
ALTER TABLE `pipelines`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pos`
--
ALTER TABLE `pos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pos_payments`
--
ALTER TABLE `pos_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pos_products`
--
ALTER TABLE `pos_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_services`
--
ALTER TABLE `product_services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_service_categories`
--
ALTER TABLE `product_service_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_service_units`
--
ALTER TABLE `product_service_units`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `projectstages`
--
ALTER TABLE `projectstages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `project_email_templates`
--
ALTER TABLE `project_email_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `project_expenses`
--
ALTER TABLE `project_expenses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `project_invoices`
--
ALTER TABLE `project_invoices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `project_tasks`
--
ALTER TABLE `project_tasks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `project_users`
--
ALTER TABLE `project_users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `promotions`
--
ALTER TABLE `promotions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `proposals`
--
ALTER TABLE `proposals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `proposal_products`
--
ALTER TABLE `proposal_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchases`
--
ALTER TABLE `purchases`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_payments`
--
ALTER TABLE `purchase_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_products`
--
ALTER TABLE `purchase_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quotations`
--
ALTER TABLE `quotations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quotation_products`
--
ALTER TABLE `quotation_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `resignations`
--
ALTER TABLE `resignations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `revenues`
--
ALTER TABLE `revenues`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `saturation_deductions`
--
ALTER TABLE `saturation_deductions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125;

--
-- AUTO_INCREMENT for table `set_salaries`
--
ALTER TABLE `set_salaries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sources`
--
ALTER TABLE `sources`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `stages`
--
ALTER TABLE `stages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `stock_reports`
--
ALTER TABLE `stock_reports`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supports`
--
ALTER TABLE `supports`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `support_replies`
--
ALTER TABLE `support_replies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `task_checklists`
--
ALTER TABLE `task_checklists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `task_comments`
--
ALTER TABLE `task_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `task_files`
--
ALTER TABLE `task_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `task_stages`
--
ALTER TABLE `task_stages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `taxes`
--
ALTER TABLE `taxes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `templates`
--
ALTER TABLE `templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `terminations`
--
ALTER TABLE `terminations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `termination_types`
--
ALTER TABLE `termination_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `timesheets`
--
ALTER TABLE `timesheets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `time_trackers`
--
ALTER TABLE `time_trackers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `track_photos`
--
ALTER TABLE `track_photos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `trainers`
--
ALTER TABLE `trainers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `trainings`
--
ALTER TABLE `trainings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `training_types`
--
ALTER TABLE `training_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transaction_lines`
--
ALTER TABLE `transaction_lines`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transfers`
--
ALTER TABLE `transfers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `travels`
--
ALTER TABLE `travels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `user_contacts`
--
ALTER TABLE `user_contacts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_coupons`
--
ALTER TABLE `user_coupons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_deals`
--
ALTER TABLE `user_deals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_email_templates`
--
ALTER TABLE `user_email_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `user_leads`
--
ALTER TABLE `user_leads`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_to_dos`
--
ALTER TABLE `user_to_dos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `venders`
--
ALTER TABLE `venders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendors`
--
ALTER TABLE `vendors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `vexcat`
--
ALTER TABLE `vexcat`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `vexpense`
--
ALTER TABLE `vexpense`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vledger`
--
ALTER TABLE `vledger`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `warehouses`
--
ALTER TABLE `warehouses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `warehouse_products`
--
ALTER TABLE `warehouse_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `warehouse_transfers`
--
ALTER TABLE `warehouse_transfers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `warnings`
--
ALTER TABLE `warnings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `webhook_settings`
--
ALTER TABLE `webhook_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `zoom_meetings`
--
ALTER TABLE `zoom_meetings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `agents`
--
ALTER TABLE `agents`
  ADD CONSTRAINT `agents_visa_country_id_foreign` FOREIGN KEY (`visa_country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `clients`
--
ALTER TABLE `clients`
  ADD CONSTRAINT `clients_agent_id_foreign` FOREIGN KEY (`agent_id`) REFERENCES `agents` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `clients_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `clients_visa_country_id_foreign` FOREIGN KEY (`visa_country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `client_deals`
--
ALTER TABLE `client_deals`
  ADD CONSTRAINT `client_deals_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `client_deals_deal_id_foreign` FOREIGN KEY (`deal_id`) REFERENCES `deals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `custom_field_values`
--
ALTER TABLE `custom_field_values`
  ADD CONSTRAINT `custom_field_values_field_id_foreign` FOREIGN KEY (`field_id`) REFERENCES `custom_fields` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `deal_calls`
--
ALTER TABLE `deal_calls`
  ADD CONSTRAINT `deal_calls_deal_id_foreign` FOREIGN KEY (`deal_id`) REFERENCES `deals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `deal_discussions`
--
ALTER TABLE `deal_discussions`
  ADD CONSTRAINT `deal_discussions_deal_id_foreign` FOREIGN KEY (`deal_id`) REFERENCES `deals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `deal_emails`
--
ALTER TABLE `deal_emails`
  ADD CONSTRAINT `deal_emails_deal_id_foreign` FOREIGN KEY (`deal_id`) REFERENCES `deals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `deal_files`
--
ALTER TABLE `deal_files`
  ADD CONSTRAINT `deal_files_deal_id_foreign` FOREIGN KEY (`deal_id`) REFERENCES `deals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `deal_tasks`
--
ALTER TABLE `deal_tasks`
  ADD CONSTRAINT `deal_tasks_deal_id_foreign` FOREIGN KEY (`deal_id`) REFERENCES `deals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `lead_calls`
--
ALTER TABLE `lead_calls`
  ADD CONSTRAINT `lead_calls_lead_id_foreign` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `lead_discussions`
--
ALTER TABLE `lead_discussions`
  ADD CONSTRAINT `lead_discussions_lead_id_foreign` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `lead_emails`
--
ALTER TABLE `lead_emails`
  ADD CONSTRAINT `lead_emails_lead_id_foreign` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `lead_files`
--
ALTER TABLE `lead_files`
  ADD CONSTRAINT `lead_files_lead_id_foreign` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `ledger`
--
ALTER TABLE `ledger`
  ADD CONSTRAINT `ledger_agent_id_foreign` FOREIGN KEY (`agent_id`) REFERENCES `agents` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_deals`
--
ALTER TABLE `user_deals`
  ADD CONSTRAINT `user_deals_deal_id_foreign` FOREIGN KEY (`deal_id`) REFERENCES `deals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_deals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_leads`
--
ALTER TABLE `user_leads`
  ADD CONSTRAINT `user_leads_lead_id_foreign` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_leads_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `vendors`
--
ALTER TABLE `vendors`
  ADD CONSTRAINT `vendors_visa_country_id_foreign` FOREIGN KEY (`visa_country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `vexpense`
--
ALTER TABLE `vexpense`
  ADD CONSTRAINT `vexpense_vexcat_id_foreign` FOREIGN KEY (`vexcat_id`) REFERENCES `vexcat` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `vledger`
--
ALTER TABLE `vledger`
  ADD CONSTRAINT `vledger_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE;
COMMIT;

