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

START TRANSACTION;



--
-- Database: `labour_app`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` bigint UNSIGNED NOT NULL,
  `parent_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deemed_positive` tinyint NOT NULL DEFAULT '1',
  `affects_gross_profit` tinyint NOT NULL DEFAULT '0',
  `sort_order` int NOT NULL,
  `default_dr_cr` enum('Dr','Cr') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Dr',
  `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 `accounts`
--

INSERT INTO `accounts` (`id`, `parent_id`, `name`, `deemed_positive`, `affects_gross_profit`, `sort_order`, `default_dr_cr`, `created_at`, `updated_at`) VALUES
(1, 0, 'Capital Account', 0, 0, 10, 'Cr', NULL, NULL),
(2, 0, 'Loans (Liability)', 0, 0, 20, 'Cr', NULL, NULL),
(3, 0, 'Current Liabilities', 0, 0, 30, 'Cr', NULL, NULL),
(4, 0, 'Fixed Assets', 1, 0, 40, 'Dr', NULL, NULL),
(5, 0, 'Investments', 1, 0, 50, 'Dr', NULL, NULL),
(6, 0, 'Current Assets', 1, 0, 60, 'Dr', NULL, NULL),
(7, 0, 'Branch / Divisions', 0, 0, 70, 'Dr', NULL, NULL),
(8, 0, 'Misc. Expenses (ASSET)', 1, 0, 80, 'Dr', NULL, NULL),
(9, 0, 'Suspense A/c', 0, 0, 90, 'Dr', NULL, NULL),
(10, 1, 'Reserves & Surplus', 0, 0, 100, 'Cr', NULL, NULL),
(11, 2, 'Bank OD A/c', 0, 0, 110, 'Cr', NULL, NULL),
(12, 2, 'Secured Loans', 0, 0, 120, 'Cr', NULL, NULL),
(13, 2, 'Unsecured Loans', 0, 0, 130, 'Cr', NULL, NULL),
(14, 3, 'Duties & Taxes', 0, 0, 140, 'Cr', NULL, NULL),
(15, 3, 'Provisions', 0, 0, 150, 'Cr', NULL, NULL),
(16, 3, 'Sundry Creditors', 0, 0, 160, 'Cr', NULL, NULL),
(17, 6, 'Stock-in-hand', 1, 0, 170, 'Dr', NULL, NULL),
(18, 6, 'Deposits (Asset)', 1, 0, 180, 'Dr', NULL, NULL),
(19, 6, 'Loans & Advances (Asset)', 1, 0, 190, 'Dr', NULL, NULL),
(20, 6, 'Sundry Debtors', 1, 0, 200, 'Dr', NULL, NULL),
(21, 6, 'Cash-in-hand', 1, 0, 210, 'Dr', NULL, NULL),
(22, 6, 'Bank Accounts', 1, 0, 220, 'Dr', NULL, NULL),
(23, 0, 'Sales Accounts', 0, 1, 230, 'Cr', NULL, NULL),
(24, 0, 'Purchase Accounts', 1, 1, 240, 'Dr', NULL, NULL),
(25, 0, 'Direct Incomes', 0, 1, 250, 'Cr', NULL, NULL),
(26, 0, 'Direct Expenses', 1, 1, 260, 'Dr', NULL, NULL),
(27, 0, 'Indirect Incomes', 0, 1, 270, 'Cr', NULL, NULL),
(28, 0, 'Indirect Expenses', 1, 1, 280, 'Dr', NULL, NULL),
(29, 2, 'test', 1, 0, 12, 'Cr', '2022-10-31 22:29:44', '2022-10-31 22:29:44');

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

--
-- Table structure for table `cargos`
--

CREATE TABLE `cargos` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `unit_id` bigint UNSIGNED NOT NULL,
  `type_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cargos`
--

INSERT INTO `cargos` (`id`, `name`, `category_id`, `unit_id`, `type_id`, `created_at`, `updated_at`) VALUES
(2, 'cargo 1', 1, 17, 1, '2022-10-11 04:59:48', '2022-12-21 04:00:28'),
(3, 'cargo 2', 2, 22, 2, '2022-12-22 04:21:55', '2022-12-22 04:21:55'),
(4, 'cargo 3', 3, 30, 2, '2022-12-22 04:22:10', '2022-12-22 04:22:10'),
(5, 'cargo 4', 1, 39, 1, '2022-12-22 04:22:28', '2022-12-22 04:22:28'),
(6, 'cargo 5', 3, 20, 1, '2022-12-22 04:22:52', '2022-12-22 04:22:52'),
(7, 'Rice', 1, 39, 2, '2024-06-28 00:00:14', '2024-06-28 00:33:34'),
(8, 'prale biskut', 1, 6, 2, '2024-08-12 18:28:18', '2024-08-12 18:28:18'),
(9, 'Indian Rice', 1, 20, 2, '2024-09-28 09:49:13', '2024-09-28 09:49:13'),
(10, 'KAJU', 1, 39, 1, '2024-09-29 19:41:11', '2024-10-09 20:41:28'),
(11, 'TABLE & CHAIR', 1, 6, 1, '2025-02-24 01:13:52', '2025-02-24 01:13:52');

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

--
-- Table structure for table `categories`
--

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

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Labour', '2022-09-27 05:18:51', '2022-09-27 05:18:51'),
(2, 'Forklift', '2022-09-27 05:18:51', '2022-09-27 05:18:51'),
(3, 'Both', '2022-09-27 05:18:51', '2022-09-29 08:15:16'),
(6, 'admin cat', '2022-10-11 04:59:48', '2022-10-11 04:59:48'),
(8, 'add cat', '2022-10-15 07:45:40', '2022-10-15 07:45:40'),
(9, 'pankaj', '2024-08-12 19:23:07', '2024-08-12 19:23:07');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `gst_details`
--

CREATE TABLE `gst_details` (
  `id` bigint UNSIGNED NOT NULL,
  `dty` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Tax Payer Category',
  `lgnm` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Legal Name',
  `adadr` int NOT NULL COMMENT 'Count Number of ADADR in GSTIN',
  `ntr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nature Of Business',
  `gstin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lstupdt` date NOT NULL COMMENT 'Last Update Date',
  `rgdt` date NOT NULL COMMENT 'Registration Date',
  `pradr_bno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pradr_flno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pradr_bnm` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pradr_st` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pradr_loc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pradr_dst` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pradr_stcd` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pradr_pncd` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pradr_city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pradr_lt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pradr_lg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sts` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Status Of GSTIN',
  `tradeNam` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int NOT NULL,
  `isDeleted` enum('Yes','No') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'No',
  `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 `ledgers`
--

CREATE TABLE `ledgers` (
  `id` bigint UNSIGNED NOT NULL,
  `account_id` bigint UNSIGNED NOT NULL,
  `company_id` bigint UNSIGNED NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `traces_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trades_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `op_bal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `district` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pincode` bigint DEFAULT NULL,
  `person` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fax` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pan_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pan_no_verified` tinyint DEFAULT NULL,
  `tan_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tan_no_verified` tinyint DEFAULT NULL,
  `cha_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_tax_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gst_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gst_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tin_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cst_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarks` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ledgers`
--

INSERT INTO `ledgers` (`id`, `account_id`, `company_id`, `code`, `name`, `traces_name`, `trades_name`, `op_bal`, `address`, `district`, `state`, `city`, `pincode`, `person`, `contact`, `fax`, `email`, `pan_no`, `pan_no_verified`, `tan_no`, `tan_no_verified`, `cha_no`, `service_tax_no`, `gst_no`, `gst_status`, `tin_no`, `cst_no`, `remarks`, `created_at`, `updated_at`) VALUES
(10, 23, 10, '9Lc', 'CONNECT IT HUB', 'Test Company', 'CONNECT IT HUB', '0 Dr', 'Bageshree Township-7,\r\nPlot No. 23', 'Kachchh', 'Gujarat', 'Anjar', 370110, 'Ravi', '7698945785', NULL, 'contact@connectithub.com', 'AANFC9287A', 1, NULL, 1, NULL, NULL, '24AANFC9287A1ZC', 'Active', '1111111111', NULL, 'aa', '2025-02-21 00:17:42', '2025-02-21 00:17:42'),
(11, 1, 11, 'qBK', 'Gajubha Bhimaji Jesar', 'regal group', 'Regal Group', '0 Dr', ',\r\nNavinal', 'Kachchh', 'Gujarat', 'Navinal', 370405, 'REGAL GROUP', '9825528544', NULL, 'regalgroupoffice@gmail.com', 'AJUPJ5566B', 0, 'NA', 0, 'NA', NULL, '24AJUPJ5566B1Z2', 'Active', 'na', NULL, 'test gidc party', '2025-02-22 11:19:14', '2025-02-22 11:19:14');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_09_27_102545_create_categories_table', 1),
(6, '2022_09_27_102644_create_units_table', 1),
(7, '2022_09_27_102843_create_types_table', 1),
(8, '2022_09_27_103025_create_cargos_table', 1),
(9, '2022_09_27_103517_create_accounts_table', 1),
(10, '2022_09_27_112718_create_warehouses_table', 2),
(14, '2022_09_28_095256_create_settings_table', 3),
(15, '2022_09_28_120236_create_gst_details_table', 4),
(17, '2022_09_26_095130_create_work_types_table', 5),
(26, '2022_09_27_113322_create_companies_table', 6),
(27, '2022_09_27_113323_create_ledgers_table', 6),
(29, '2022_09_27_120725_create_orders_table', 7),
(32, '2022_12_21_103909_create_mulajims_table', 8),
(33, '2022_12_22_060001_create_labours_table', 8),
(36, '2022_12_22_121708_create_mulajim_groups_table', 9),
(37, '2022_12_22_122218_create_mulajim_group_labours_table', 9),
(38, '2023_01_11_095805_create_order_containers_table', 10),
(40, '2023_01_12_115504_create_order_accepted_distances_table', 11),
(41, '2023_01_13_051215_create_notifications_table', 12),
(42, '2023_01_12_155552_create_order_accept_logs_table', 13),
(43, '2023_02_21_115407_create_terms_privacies_table', 14),
(44, '2023_03_02_135557_add_company_to_order_accept_table', 15),
(45, '2023_03_02_140349_remove_message_to_order_accepted_distances', 16),
(47, '2023_04_18_101529_add_status_to_order_containers_table', 17),
(48, '2023_04_18_125913_remove_order_id_add_order_container_id_to_order_accepted_distances_table', 18),
(49, '2023_04_18_130046_remove_order_id_add_order_container_id_to_order_accept_logs_table', 19),
(50, '2023_04_19_050716_change_status_in_orders_table', 20),
(52, '2023_04_24_060208_add_order_unique_id_to_orders_table', 21),
(53, '2023_04_24_110456_add_group_unique_id_to_mulajim_groups_table', 22),
(54, '2024_01_16_125718_create_order_mulajims_table', 23),
(55, '2025_03_09_134929_create_transactions_table', 24);

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

--
-- Table structure for table `mulajim_group_labours`
--

CREATE TABLE `mulajim_group_labours` (
  `id` bigint UNSIGNED NOT NULL,
  `mulajim_group_id` bigint UNSIGNED NOT NULL,
  `labour_id` bigint UNSIGNED NOT NULL,
  `is_leader` tinyint NOT NULL DEFAULT '0' COMMENT '0=false, 1=true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mulajim_group_labours`
--

INSERT INTO `mulajim_group_labours` (`id`, `mulajim_group_id`, `labour_id`, `is_leader`, `created_at`, `updated_at`) VALUES
(87, 33, 89, 1, '2025-02-21 00:01:01', '2025-02-21 00:01:01'),
(88, 33, 90, 0, '2025-02-21 00:01:01', '2025-02-21 00:01:01'),
(89, 34, 95, 0, '2025-02-22 11:48:07', '2025-02-22 11:48:07'),
(90, 34, 94, 1, '2025-02-22 11:48:07', '2025-02-22 11:48:07');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint UNSIGNED NOT NULL,
  `receiver_warehouse_id` bigint UNSIGNED DEFAULT NULL,
  `receiver_mulajim_id` bigint UNSIGNED DEFAULT NULL,
  `receiver_labor_id` bigint UNSIGNED DEFAULT NULL,
  `sender_id` bigint NOT NULL,
  `sender_type` tinyint DEFAULT NULL COMMENT '1=warehouse, 2=mulajim, 3=labor',
  `type` tinyint DEFAULT NULL COMMENT '1=Order added',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_read` tinyint NOT NULL DEFAULT '0' COMMENT '0=Unread, 1=Read',
  `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 `notifications`
--

INSERT INTO `notifications` (`id`, `receiver_warehouse_id`, `receiver_mulajim_id`, `receiver_labor_id`, `sender_id`, `sender_type`, `type`, `title`, `message`, `is_read`, `created_at`, `updated_at`) VALUES
(544, NULL, 12, NULL, 1, 1, 1, 'Labour Warehouse', 'Add a New order in warehouse 1', 0, '2025-02-21 00:20:05', '2025-02-21 00:20:05'),
(545, NULL, 12, NULL, 1, 1, 1, 'Labour Warehouse', 'Add a New order in warehouse 1', 0, '2025-02-21 22:40:43', '2025-02-21 22:40:43'),
(546, NULL, NULL, 89, 1, 1, 1, 'Labour Warehouse', 'Add a New order in warehouse 1', 0, '2025-02-21 22:40:43', '2025-02-21 22:40:43'),
(547, NULL, 12, NULL, 1, 1, 1, 'Labour Warehouse', 'Add a New order in warehouse 1', 0, '2025-02-23 05:45:35', '2025-02-23 05:45:35'),
(548, NULL, 13, NULL, 1, 1, 1, 'Labour Warehouse', 'Add a New order in warehouse 1', 0, '2025-02-23 05:45:35', '2025-02-23 05:45:35'),
(549, NULL, NULL, 89, 1, 1, 1, 'Labour Warehouse', 'Add a New order in warehouse 1', 0, '2025-02-23 05:45:36', '2025-02-23 05:45:36'),
(550, NULL, NULL, 95, 1, 1, 1, 'Labour Warehouse', 'Add a New order in warehouse 1', 0, '2025-02-23 05:45:36', '2025-02-23 05:45:36'),
(551, NULL, NULL, 94, 1, 1, 1, 'Labour Warehouse', 'Add a New order in warehouse 1', 0, '2025-02-23 05:45:36', '2025-02-23 05:45:36');

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint UNSIGNED NOT NULL,
  `order_unique_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'auto generated unique id for identify order',
  `company_id` bigint UNSIGNED NOT NULL,
  `warehouse_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Order_type` tinyint DEFAULT NULL COMMENT '1=express order, 2=live order, 3=future order',
  `work_type_id` bigint UNSIGNED NOT NULL,
  `orderFrom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `orderTo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_quantity` bigint DEFAULT NULL,
  `total_size` bigint DEFAULT NULL COMMENT 'in kg',
  `distance` bigint DEFAULT NULL COMMENT 'in meter',
  `height` bigint DEFAULT NULL COMMENT 'in feet',
  `start_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rate` bigint DEFAULT NULL,
  `documents` text COLLATE utf8mb4_unicode_ci,
  `payment` tinyint NOT NULL DEFAULT '0' COMMENT '0=not done, 1=done',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0=pending, 1=in progress, 2=completed, 3=disputed',
  `status_pending` tinyint DEFAULT NULL,
  `status_accepted` tinyint DEFAULT NULL,
  `status_started` tinyint DEFAULT NULL,
  `status_in_transit` tinyint DEFAULT NULL,
  `status_review` tinyint DEFAULT NULL,
  `status_dispute` tinyint DEFAULT NULL,
  `status_hold` tinyint DEFAULT NULL,
  `status_billing` tinyint DEFAULT NULL,
  `status_payment` tinyint DEFAULT NULL,
  `status_completed` tinyint DEFAULT NULL,
  `latest_status` tinyint 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 `orders`
--

INSERT INTO `orders` (`id`, `order_unique_id`, `company_id`, `warehouse_id`, `title`, `description`, `contact`, `latitude`, `longitude`, `Order_type`, `work_type_id`, `orderFrom`, `orderTo`, `total_quantity`, `total_size`, `distance`, `height`, `start_time`, `end_time`, `rate`, `documents`, `payment`, `status`, `status_pending`, `status_accepted`, `status_started`, `status_in_transit`, `status_review`, `status_dispute`, `status_hold`, `status_billing`, `status_payment`, `status_completed`, `latest_status`, `created_at`, `updated_at`) VALUES
(93, '1809220714', 10, 1, 'Rice Unloading', 'aaa', '6666666666', '22.7367883', '69.704351', 2, 1, 'ground', 'container', 175, 175000, 5, 24, '2025-02-21 12:00:00', '2025-02-24 12:00:00', 1750000, 'aaa', 1, 2, NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-02-21 00:20:05', '2025-03-10 03:19:58'),
(94, '1781118590', 10, 1, 'Apple', 'sell Apple Data', '8888888888', NULL, NULL, 2, 2, 'ground', 'ground', 2020, 20002, 10, 10, '2025-02-22 12:00:00', '2025-02-28 12:00:00', 32000, 'App', 1, 2, NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-02-21 22:40:43', '2025-03-09 08:36:54'),
(95, '1808828572', 11, 1, 'test_23_02_2025', 'feb-24 testing', '9016420336', '22.83710629999999', '69.69553429999999', 2, 1, 'ground', 'container', 83, 83000, 6, 10, '2025-02-23 16:48:00', '2025-02-24 12:00:00', 8300, 'test feb-24 by pankaj', 1, 2, NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-02-23 05:45:35', '2025-03-09 08:39:00');

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

--
-- Table structure for table `order_accepted_distances`
--

CREATE TABLE `order_accepted_distances` (
  `id` bigint UNSIGNED NOT NULL,
  `order_container_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL COMMENT 'who accept the order',
  `distance` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'user to warehouse distance(in KM)',
  `time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'time(in minute) for reach order''s warehouse',
  `mulajim_group_id` bigint UNSIGNED NOT NULL,
  `mulajim_id` bigint UNSIGNED DEFAULT NULL COMMENT 'order accept by mulajim',
  `labour_id` bigint UNSIGNED DEFAULT NULL COMMENT 'order accept by labour',
  `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 `order_accepted_distances`
--

INSERT INTO `order_accepted_distances` (`id`, `order_container_id`, `user_id`, `distance`, `time`, `mulajim_group_id`, `mulajim_id`, `labour_id`, `created_at`, `updated_at`) VALUES
(105, 140, 61, '0', '50', 33, 12, NULL, '2025-02-21 23:08:00', '2025-02-21 23:08:00'),
(106, 141, 61, '0', '50', 33, 12, NULL, '2025-02-21 23:08:00', '2025-02-21 23:08:00'),
(107, 147, 61, '0', '50', 33, 12, NULL, '2025-02-22 00:52:32', '2025-02-22 00:52:32'),
(108, 146, 61, '0', '50', 33, 12, NULL, '2025-02-22 00:54:15', '2025-02-22 00:54:15'),
(109, 142, 61, '0', '50', 33, 12, NULL, '2025-02-22 04:47:20', '2025-02-22 04:47:20'),
(110, 143, 61, '0', '50', 33, 12, NULL, '2025-02-22 04:47:20', '2025-02-22 04:47:20'),
(111, 144, 61, '0', '50', 33, 12, NULL, '2025-02-22 04:47:53', '2025-02-22 04:47:53'),
(112, 149, 66, '371', '50', 34, NULL, 94, '2025-02-23 05:49:04', '2025-02-23 05:49:04'),
(113, 145, 66, '371', '50', 34, NULL, 94, '2025-02-23 05:56:34', '2025-02-23 05:56:34'),
(114, 148, 66, '371', '50', 34, NULL, 94, '2025-02-23 05:56:34', '2025-02-23 05:56:34'),
(115, 150, 66, '371', '50', 34, NULL, 94, '2025-02-23 05:59:40', '2025-02-23 05:59:40'),
(116, 151, 66, '369', '50', 34, NULL, 94, '2025-02-24 02:58:19', '2025-02-24 02:58:19');

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

--
-- Table structure for table `order_accept_logs`
--

CREATE TABLE `order_accept_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `order_container_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL COMMENT 'who accept the order',
  `mulajim_group_id` bigint UNSIGNED NOT NULL,
  `mulajim_id` bigint UNSIGNED DEFAULT NULL COMMENT 'order accept by mulajim',
  `labour_id` bigint UNSIGNED DEFAULT NULL COMMENT 'order accept by labour',
  `order_status` tinyint NOT NULL COMMENT 'order is which stage',
  `order_accept_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'time add when order accept by mulajim/labour',
  `order_complete_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'time add when order complete by mulajim/labour',
  `message` longtext COLLATE utf8mb4_unicode_ci,
  `company_id` bigint UNSIGNED DEFAULT NULL COMMENT 'company check complete or dispute order',
  `cmp_message` longtext COLLATE utf8mb4_unicode_ci,
  `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 `order_accept_logs`
--

INSERT INTO `order_accept_logs` (`id`, `order_container_id`, `user_id`, `mulajim_group_id`, `mulajim_id`, `labour_id`, `order_status`, `order_accept_time`, `order_complete_time`, `message`, `company_id`, `cmp_message`, `created_at`, `updated_at`) VALUES
(66, 140, 61, 33, 12, NULL, 1, '2025-02-22 04:38:00', NULL, 'Your message goes here', NULL, NULL, '2025-02-21 23:08:00', '2025-02-22 00:32:42'),
(67, 141, 61, 33, 12, NULL, 1, '2025-02-22 04:38:00', NULL, NULL, NULL, NULL, '2025-02-21 23:08:00', '2025-02-21 23:08:00'),
(68, 147, 61, 33, 12, NULL, 1, '2025-02-22 06:22:32', NULL, NULL, NULL, NULL, '2025-02-22 00:52:32', '2025-02-22 00:52:32'),
(69, 146, 61, 33, 12, NULL, 1, '2025-02-22 06:24:15', NULL, 'Your message goes here', NULL, NULL, '2025-02-22 00:54:15', '2025-02-22 08:11:33'),
(70, 142, 61, 33, 12, NULL, 1, '2025-02-22 10:17:20', NULL, NULL, NULL, NULL, '2025-02-22 04:47:20', '2025-02-22 04:47:20'),
(71, 143, 61, 33, 12, NULL, 1, '2025-02-22 10:17:20', NULL, NULL, NULL, NULL, '2025-02-22 04:47:20', '2025-02-22 04:47:20'),
(72, 144, 61, 33, 12, NULL, 1, '2025-02-22 10:17:53', NULL, NULL, NULL, NULL, '2025-02-22 04:47:53', '2025-02-22 04:47:53'),
(73, 149, 66, 34, NULL, 94, 1, '2025-02-23 11:19:04', NULL, 'Your message goes here', NULL, NULL, '2025-02-23 05:49:04', '2025-02-23 05:53:09'),
(74, 145, 66, 34, NULL, 94, 1, '2025-02-23 11:26:34', NULL, NULL, NULL, NULL, '2025-02-23 05:56:34', '2025-02-23 05:56:34'),
(75, 148, 66, 34, NULL, 94, 1, '2025-02-23 11:26:34', NULL, NULL, NULL, NULL, '2025-02-23 05:56:34', '2025-02-23 05:56:34'),
(76, 150, 66, 34, NULL, 94, 1, '2025-02-23 11:29:40', NULL, 'Your message goes here', NULL, NULL, '2025-02-23 05:59:40', '2025-02-23 06:00:15'),
(77, 151, 66, 34, NULL, 94, 1, '2025-02-24 08:28:19', NULL, NULL, NULL, NULL, '2025-02-24 02:58:19', '2025-02-24 02:58:19');

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

--
-- Table structure for table `order_containers`
--

CREATE TABLE `order_containers` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` bigint UNSIGNED DEFAULT NULL,
  `cargo_id` bigint UNSIGNED DEFAULT NULL,
  `quantity` bigint DEFAULT NULL,
  `size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `per_kg_price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'per Kg Price',
  `amount` bigint DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0=pending, 1=accepted, 2=partial completed, 3=completed, 4=disputed',
  `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 `order_containers`
--

INSERT INTO `order_containers` (`id`, `order_id`, `cargo_id`, `quantity`, `size`, `per_kg_price`, `amount`, `status`, `created_at`, `updated_at`) VALUES
(140, 93, 7, 35, '35000', '10', 350000, 2, '2025-02-21 22:34:21', '2025-02-22 00:32:42'),
(141, 93, 7, 35, '35000', '10', 350000, 1, '2025-02-21 22:34:21', '2025-02-21 23:08:00'),
(142, 93, 7, 35, '35000', '10', 350000, 1, '2025-02-21 22:34:21', '2025-02-22 04:47:20'),
(143, 93, 7, 35, '35000', '10', 350000, 1, '2025-02-21 22:34:21', '2025-02-22 04:47:20'),
(144, 93, 7, 35, '35000', '10', 350000, 1, '2025-02-21 22:34:21', '2025-02-22 04:47:53'),
(145, 94, 2, 1000, '1', '1000', 1000, 1, '2025-02-21 22:40:43', '2025-02-23 05:56:34'),
(146, 94, 3, 10, '10000', '2', 20000, 2, '2025-02-21 22:40:43', '2025-02-22 08:11:33'),
(147, 94, 2, 1000, '1', '1000', 1000, 1, '2025-02-21 22:40:43', '2025-02-22 00:52:32'),
(148, 94, 3, 10, '10000', '1', 10000, 1, '2025-02-21 22:40:43', '2025-02-23 05:56:34'),
(149, 95, 7, 28, '28000', '0.10', 2800, 2, '2025-02-23 05:45:35', '2025-02-23 05:53:09'),
(150, 95, 7, 25, '25000', '0.10', 2500, 2, '2025-02-23 05:45:35', '2025-02-23 06:00:15'),
(151, 95, 7, 30, '30000', '0.10', 3000, 1, '2025-02-23 05:45:35', '2025-02-24 02:58:19');

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

--
-- Table structure for table `order_log`
--

CREATE TABLE `order_log` (
  `id` int NOT NULL,
  `order_container_id` bigint NOT NULL,
  `mulajim_id` bigint DEFAULT NULL,
  `labour_id` bigint DEFAULT NULL,
  `mulajim_group_id` bigint NOT NULL,
  `order_status` tinyint NOT NULL,
  `comments` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_log`
--

INSERT INTO `order_log` (`id`, `order_container_id`, `mulajim_id`, `labour_id`, `mulajim_group_id`, `order_status`, `comments`, `created_at`, `updated_at`) VALUES
(17, 135, 12, 61, 33, 1, NULL, '2025-02-21 01:31:06', '2025-02-21 01:31:06'),
(18, 140, 12, 61, 33, 2, NULL, '2025-02-22 00:32:42', '2025-02-22 00:32:42'),
(19, 146, 12, 61, 33, 2, NULL, '2025-02-22 08:11:34', '2025-02-22 08:11:34'),
(20, 149, NULL, 66, 34, 2, NULL, '2025-02-23 05:53:09', '2025-02-23 05:53:09'),
(21, 150, NULL, 66, 34, 2, NULL, '2025-02-23 06:00:15', '2025-02-23 06:00:15');

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

--
-- Table structure for table `order_mulajims`
--

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

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

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

CREATE TABLE `settings` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `customize` enum('No','Yes') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'No',
  `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`, `user_id`, `name`, `value`, `customize`, `created_at`, `updated_at`) VALUES
(1, 0, 'company_name', 'ABAC', 'No', NULL, '2023-02-22 06:01:36'),
(2, 0, 'company_address', 'AHMEDABAD - 380050', 'No', NULL, '2023-02-22 06:01:36'),
(3, 0, 'company_contact', '+91 5555555555', 'No', NULL, '2023-02-22 06:01:36'),
(4, 0, 'company_email', 'admin@admin.com', 'No', NULL, '2023-02-22 06:01:36'),
(5, 0, 'company_website', '', 'No', NULL, NULL),
(6, 0, 'rows_per_page', '10', 'Yes', NULL, '2023-02-22 06:01:36'),
(7, 0, 'printer_name', '1020', 'Yes', NULL, '2023-02-22 06:01:36'),
(8, 0, 'service_tax', '0', 'No', NULL, '2023-02-22 06:01:36'),
(9, 0, 'hedu_cess', '2', 'No', NULL, '2023-02-22 06:01:36'),
(10, 0, 'edu_cess', '1', 'No', NULL, '2023-02-22 06:01:36'),
(11, 0, 'smtp_host', '', 'Yes', NULL, NULL),
(12, 0, 'smtp_user', '', 'Yes', NULL, NULL),
(13, 0, 'smtp_password', '', 'Yes', NULL, NULL),
(14, 0, 'smtp_port', '587', 'Yes', NULL, '2023-02-22 06:01:36'),
(15, 0, 'default_cc', '', 'No', NULL, NULL),
(19, 0, 'default_company', '1', 'Yes', NULL, '2023-02-22 06:01:36'),
(21, 0, 'imap_host', '', 'No', NULL, NULL),
(22, 0, 'imap_user', '', 'No', NULL, NULL),
(23, 0, 'imap_password', '', 'No', NULL, NULL),
(24, 0, 'imap_port', '', 'No', NULL, NULL),
(25, 0, 'stamp_duty', '0.1', 'No', NULL, '2023-02-22 06:01:36'),
(26, 0, 'theme', 'bootstrap.min.css', 'Yes', NULL, '2023-02-22 06:01:36'),
(27, 0, 'tally_server', '', 'No', NULL, NULL),
(28, 0, 'abatment', '75', 'No', NULL, '2023-02-22 06:01:36'),
(29, 0, 'chat_window', 'No', 'Yes', NULL, '2023-02-22 06:01:36'),
(30, 0, 'tds', '2', 'No', NULL, '2023-02-22 06:01:36'),
(31, 0, 'tds_surcharge', '0', 'No', NULL, '2023-02-22 06:01:36'),
(32, 0, 'tds_edu_cess', '0', 'No', NULL, '2023-02-22 06:01:36'),
(33, 0, 'tds_hedu_cess', '0', 'No', NULL, '2023-02-22 06:01:36'),
(34, 0, 'sms_api_url', 'https://msg.biometricsystems.co.in/api/api_http.php', 'No', NULL, '2023-02-22 06:01:36'),
(35, 0, 'sms_api_username', '', 'No', NULL, NULL),
(36, 0, 'sms_api_password', '', 'No', NULL, NULL),
(37, 0, 'sms_api_senderid', '', 'No', NULL, NULL),
(38, 0, 'sms_api_route', 'Informative', 'No', NULL, '2023-02-22 06:01:36'),
(39, 0, 'sms_api_otp_temp', '{OTP} is your one-time password and it is valid for the next 5 min. Pls, do not share this OTP with anyone.  Thank you  CONNECT IT HUB', 'No', NULL, '2023-02-22 06:01:36'),
(40, 0, 'sms_api_active', 'No', 'No', NULL, '2023-02-22 06:01:36'),
(41, 0, 'eway_test_auth_url', 'http://gstsandbox.charteredinfo.com/ewaybillapi/dec/v1.03/auth?', 'No', NULL, '2023-02-22 06:01:36'),
(42, 0, 'eway_test_ewaybill_url', 'http://gstsandbox.charteredinfo.com/ewaybillapi/dec/v1.03/ewayapi?', 'No', NULL, '2023-02-22 06:01:36'),
(43, 0, 'eway_test_asp_id', '1624731119', 'No', NULL, '2023-02-22 06:01:36'),
(44, 0, 'eway_test_password', 'Martin55!@', 'No', NULL, '2023-02-22 06:01:36'),
(45, 0, 'eway_test_gstin', '34AACCC1596Q002', 'No', NULL, '2023-02-22 06:01:36'),
(46, 0, 'eway_test_username', 'TaxProEnvPON', 'No', NULL, '2023-02-22 06:01:36'),
(47, 0, 'eway_test_ewbpwd', 'abc34*', 'No', NULL, '2023-02-22 06:01:36'),
(48, 0, 'eway_test_active', 'No', 'No', NULL, '2023-02-22 06:01:36'),
(49, 0, 'eway_auth_url', 'https://einvapi.charteredinfo.com/v1.03/dec/auth?', 'No', NULL, '2023-02-22 06:01:36'),
(50, 0, 'eway_ewaybill_url', 'https://einvapi.charteredinfo.com/v1.03/dec/ewayapi?', 'No', NULL, '2023-02-22 06:01:36'),
(51, 0, 'eway_asp_id', '', 'No', NULL, NULL),
(52, 0, 'eway_password', '', 'No', NULL, NULL),
(53, 0, 'eway_gstin', '', 'No', NULL, NULL),
(54, 0, 'eway_username', '', 'No', NULL, NULL),
(55, 0, 'eway_ewbpwd', '', 'No', NULL, NULL),
(56, 0, 'eway_active', 'Yes', 'No', NULL, '2023-02-22 06:01:36'),
(57, 0, 'eway_default_to', '', 'No', NULL, NULL),
(58, 0, 'eway_default_cc', '', 'No', NULL, NULL),
(59, 0, 'eway_default_bcc', '', 'No', NULL, NULL),
(60, 0, 'eway_default_source', 'LIVE', 'No', NULL, '2023-02-22 06:01:36'),
(61, 0, 'user_eway_party', '', 'Yes', NULL, NULL),
(62, 0, 'user_eway_from_place', '', 'Yes', NULL, NULL),
(63, 0, 'vch_out_inq_default_cr_ledger', '', 'No', NULL, NULL),
(64, 0, 'vch_out_quote_default_cr_ledger', '', 'No', NULL, NULL),
(65, 0, 'vch_out_order_default_cr_ledger', '', 'No', NULL, NULL),
(66, 0, 'vch_out_dc_default_cr_ledger', '', 'No', NULL, NULL),
(67, 0, 'vch_out_inv_default_cr_ledger', '', 'No', NULL, NULL),
(68, 0, 'vch_inw_inq_default_cr_ledger', '', 'No', NULL, NULL),
(69, 0, 'vch_inw_quote_default_cr_ledger', '', 'No', NULL, NULL),
(70, 0, 'vch_inw_order_default_cr_ledger', '', 'No', NULL, NULL),
(71, 0, 'vch_inw_dc_default_cr_ledger', '', 'No', NULL, NULL),
(72, 0, 'vch_inw_inv_default_cr_ledger', '', 'No', NULL, NULL),
(73, 0, 'maximum_km', '3000', 'Yes', '2023-01-12 00:06:34', '2023-02-22 06:01:36'),
(74, 0, 'auto_refresh_time', '5', 'Yes', '2023-01-12 00:06:59', '2023-02-22 06:01:36'),
(75, 0, 'commission_admin_to_mulajim', '0.20', 'No', '2025-02-24 03:44:50', '2025-02-24 03:44:50');

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

--
-- Table structure for table `terms_privacies`
--

CREATE TABLE `terms_privacies` (
  `id` bigint UNSIGNED NOT NULL,
  `selection` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '0=inActive, 1=active',
  `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 `terms_privacies`
--

INSERT INTO `terms_privacies` (`id`, `selection`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'terms', '<h2>Illustration paragraph: a 5-step example</h2>\r\n\r\n<p>From the list above, let&rsquo;s choose &ldquo;illustration&rdquo; as our rhetorical purpose. We&rsquo;ll walk through a 5-step process for building a paragraph that illustrates a point in an argument. For each step there is an explanation and example. Our example paragraph will be about human misconceptions of piranhas.</p>\r\n\r\n<h3>Step 1. Decide on a controlling idea and create a topic sentence</h3>\r\n\r\n<p>Paragraph development begins with the formulation of the controlling idea. This idea directs the paragraph&rsquo;s development. Often, the controlling idea of a paragraph will appear in the form of a topic sentence. In some cases, you may need more than one sentence to express a paragraph&rsquo;s controlling idea.</p>\r\n\r\n<p><strong>Controlling idea and topic sentence</strong>&nbsp;&mdash; Despite the fact that piranhas are relatively harmless, many people continue to believe the pervasive myth that piranhas are dangerous to humans.</p>\r\n\r\n<h3>Step 2. Elaborate on the controlling idea</h3>\r\n\r\n<p>Paragraph development continues with an elaboration on the controlling idea, perhaps with an explanation, implication, or statement about significance. Our example offers a possible explanation for the pervasiveness of the myth.</p>\r\n\r\n<p><strong>Elaboration</strong>&nbsp;&mdash; This impression of piranhas is exacerbated by their mischaracterization in popular media.</p>\r\n\r\n<h3>Step 3. Give an example (or multiple examples)</h3>\r\n\r\n<p>Paragraph development progresses with an example (or more) that illustrates the claims made in the previous sentences.</p>\r\n\r\n<p><strong>Example</strong>&nbsp;&mdash; For example, the promotional poster for the 1978 horror film&nbsp;<em>Piranha</em>&nbsp;features an oversized piranha poised to bite the leg of an unsuspecting woman.</p>\r\n\r\n<h3>Step 4. Explain the example(s)</h3>\r\n\r\n<p>The next movement in paragraph development is an explanation of each example and its relevance to the topic sentence. The explanation should demonstrate the value of the example as evidence to support the major claim, or focus, in your paragraph.</p>\r\n\r\n<p>Continue the pattern of giving examples and explaining them until all points/examples that the writer deems necessary have been made and explained. NONE of your examples should be left unexplained. You might be able to explain the relationship between the example and the topic sentence in the same sentence which introduced the example. More often, however, you will need to explain that relationship in a separate sentence.</p>\r\n\r\n<p><strong>Explanation for example</strong>&nbsp;&mdash; Such a terrifying representation easily captures the imagination and promotes unnecessary fear.</p>\r\n\r\n<p>Notice that the example and explanation steps of this 5-step process (steps 3 and 4) can be repeated as needed. The idea is that you continue to use this pattern until you have completely developed the main idea of the paragraph.</p>\r\n\r\n<h3>Step 5. Complete the paragraph&rsquo;s idea or transition into the next paragraph</h3>\r\n\r\n<p>The final movement in paragraph development involves tying up the loose ends of the paragraph. At this point, you can remind your reader about the relevance of the information to the larger paper, or you can make a concluding point for this example. You might, however, simply transition to the next paragraph.</p>\r\n\r\n<p><strong>Sentences for completing a paragraph</strong>&nbsp;&mdash; While the trope of the man-eating piranhas lends excitement to the adventure stories, it bears little resemblance to the real-life piranha. By paying more attention to fact than fiction, humans may finally be able to let go of this inaccurate belief.</p>\r\n\r\n<h3>Finished paragraph</h3>\r\n\r\n<p>Despite the fact that piranhas are relatively harmless, many people continue to believe the pervasive myth that piranhas are dangerous to humans. This impression of piranhas is exacerbated by their mischaracterization in popular media. For example, the promotional poster for the 1978 horror film&nbsp;<em>Piranha</em>&nbsp;features an oversized piranha poised to bite the leg of an unsuspecting woman. Such a terrifying representation easily captures the imagination and promotes unnecessary fear. While the trope of the man-eating piranhas lends excitement to the adventure stories, it bears little resemblance to the real-life piranha. By paying more attention to fact than fiction, humans may finally be able to let go of this inaccurate belief.</p>', 1, '2023-02-21 06:41:24', '2023-02-23 03:29:15'),
(2, 'privacy', '<h2>What this handout is about</h2>\r\n\r\n<p>This handout will help you understand how paragraphs are formed, how to develop stronger paragraphs, and how to completely and clearly express your ideas.</p>\r\n\r\n<h2>What is a paragraph?</h2>\r\n\r\n<p>Paragraphs are the building blocks of papers. Many students define paragraphs in terms of length: a paragraph is a group of at least five sentences, a paragraph is half a page long, etc. In reality, though, the unity and coherence of ideas among sentences is what constitutes a paragraph. A paragraph is defined as &ldquo;a group of sentences or a single sentence that forms a unit&rdquo; (Lunsford and Connors 116). Length and appearance do not determine whether a section in a paper is a paragraph. For instance, in some styles of writing, particularly journalistic styles, a paragraph can be just one sentence long. Ultimately, a paragraph is a sentence or group of sentences that support one main idea. In this handout, we will refer to this as the &ldquo;controlling idea,&rdquo; because it controls what happens in the rest of the paragraph.</p>\r\n\r\n<h2>How do I decide what to put in a paragraph?</h2>\r\n\r\n<p>Before you can begin to determine what the composition of a particular paragraph will be, you must first decide on an&nbsp;<a href=\"https://writingcenter.unc.edu/tips-and-tools/argument/\">argument</a>&nbsp;and a working&nbsp;<a href=\"https://writingcenter.unc.edu/tips-and-tools/thesis-statements/\">thesis statement</a>&nbsp;for your paper. What is the most important idea that you are trying to convey to your reader? The information in each paragraph must be related to that idea. In other words, your paragraphs should remind your reader that there is a recurrent relationship between your thesis and the information in each paragraph. A working thesis functions like a seed from which your paper, and your ideas, will grow. The whole process is an organic one&mdash;a natural progression from a seed to a full-blown paper where there are direct, familial relationships between all of the ideas in the paper.</p>\r\n\r\n<p>The decision about what to put into your paragraphs begins with the germination of a seed of ideas; this &ldquo;germination process&rdquo; is better known as&nbsp;<a href=\"https://writingcenter.unc.edu/tips-and-tools/brainstorming/\">brainstorming</a>. There are many techniques for brainstorming; whichever one you choose, this stage of paragraph development cannot be skipped. Building paragraphs can be like building a skyscraper: there must be a well-planned foundation that supports what you are building. Any cracks, inconsistencies, or other corruptions of the foundation can cause your whole paper to crumble.</p>\r\n\r\n<p>So, let&rsquo;s suppose that you have done some brainstorming to develop your thesis. What else should you keep in mind as you begin to create paragraphs?&nbsp;<strong>Every paragraph in a paper should be</strong>:</p>\r\n\r\n<ul>\r\n	<li><strong>Unified</strong>: All of the sentences in a single paragraph should be related to a single controlling idea (often expressed in the topic sentence of the paragraph).</li>\r\n	<li><strong>Clearly related to the thesis</strong>: The sentences should all refer to the central idea, or thesis, of the paper (Rosen and Behrens 119).</li>\r\n	<li><strong>Coherent</strong>: The sentences should be arranged in a logical manner and should follow a definite plan for development (Rosen and Behrens 119).</li>\r\n	<li><strong>Well-developed</strong>: Every idea discussed in the paragraph should be adequately explained and supported through evidence and details that work together to explain the paragraph&rsquo;s controlling idea (Rosen and Behrens 119).</li>\r\n</ul>', 1, '2023-02-21 07:02:14', '2023-02-21 07:02:14');

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

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

CREATE TABLE `transactions` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` bigint UNSIGNED NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_date` date NOT NULL,
  `transaction_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'payment_from_company, payment_to_labour',
  `transaction_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'pending, completed',
  `amount` decimal(10,2) NOT NULL,
  `comments` text COLLATE utf8mb4_unicode_ci,
  `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 `transactions`
--

INSERT INTO `transactions` (`id`, `order_id`, `transaction_id`, `transaction_date`, `transaction_method`, `transaction_type`, `transaction_status`, `amount`, `comments`, `created_at`, `updated_at`) VALUES
(2, 94, 'SBI3123125435', '2025-03-09', 'cash', 'payment_from_company', 'completed', 20000.00, 'Done', '2025-03-09 08:36:54', '2025-03-09 22:52:19'),
(3, 95, 'SBI31231256545', '2025-03-09', 'cash', 'payment_from_company', 'pending', 40000.00, 'Done', '2025-03-09 08:39:00', '2025-03-09 08:39:00'),
(5, 93, 'SBI4343824y8732', '2025-03-10', 'bank_transfer', 'payment_from_company', 'closed', 1750000.00, 'Paid', '2025-03-10 03:19:58', '2025-03-10 03:25:54'),
(6, 93, 'SBI312312423134213213', '2025-03-10', 'bank_transfer', 'payment_to_mulajim', 'closed', 30000.00, 'PaID', '2025-03-10 03:25:54', '2025-03-10 03:25:54');

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

--
-- Table structure for table `types`
--

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

--
-- Dumping data for table `types`
--

INSERT INTO `types` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Bulk', '2022-09-27 05:19:10', '2022-09-27 05:19:10'),
(2, 'Container', '2022-09-27 05:19:10', '2022-09-27 05:19:10'),
(4, 'admin type', '2022-10-11 04:59:48', '2022-10-11 04:59:48'),
(6, 'add type', '2022-10-15 07:46:07', '2022-10-15 07:46:07');

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

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `id` bigint UNSIGNED NOT NULL,
  `code` char(4) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kg_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'this column value in KG',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0=inActive, 1=active',
  `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 `units`
--

INSERT INTO `units` (`id`, `code`, `name`, `kg_value`, `status`, `created_at`, `updated_at`) VALUES
(1, 'BAG', 'BAGS', NULL, 0, NULL, '2022-12-21 01:11:19'),
(2, 'BAL', 'BALE', '217.7243376', 1, NULL, NULL),
(3, 'BDL', 'BUNDLES', NULL, 1, NULL, '2024-06-14 00:31:04'),
(4, 'BKL', 'BUCKLES', NULL, 1, NULL, '2024-06-14 00:31:08'),
(5, 'BOU', 'BILLIONS OF UNITS', NULL, 1, NULL, '2024-06-14 00:31:07'),
(6, 'BOX', 'BOX', NULL, 1, NULL, '2024-06-14 00:31:09'),
(7, 'BTL', 'BOTTLES', NULL, 1, NULL, '2024-06-14 00:31:10'),
(8, 'BUN', 'BUNCHES', NULL, 1, NULL, '2024-06-14 00:31:10'),
(9, 'CAN', 'CANS', NULL, 1, NULL, '2024-06-14 00:31:12'),
(10, 'CBM', 'CUBIC METER', '1000', 1, NULL, NULL),
(11, 'CCM', 'CUBIC CENTIMETER', '0.001', 1, NULL, NULL),
(12, 'CMS', 'CENTIMETER', '0.01', 1, NULL, NULL),
(13, 'CTN', 'CARTONS', NULL, 0, NULL, '2022-12-21 01:12:44'),
(14, 'DOZ', 'DOZEN', NULL, 0, NULL, '2022-12-21 01:12:45'),
(15, 'DRM', 'DRUM', NULL, 0, NULL, '2022-12-21 01:12:45'),
(16, 'GGR', 'GREAT GROSS', NULL, 0, NULL, '2022-12-21 01:12:46'),
(17, 'GMS', 'GRAMS', '0.001', 1, NULL, NULL),
(18, 'GRS', 'GROSS', '0.003824', 1, NULL, NULL),
(19, 'GYD', 'GROSS YARDS', NULL, 0, NULL, '2022-12-21 01:12:54'),
(20, 'KGS', 'KILOGRAMS', '1', 1, NULL, NULL),
(21, 'KLR', 'KILOLITER', NULL, 0, NULL, '2022-12-21 01:12:59'),
(22, 'KME', 'KILOMETRE', '1000', 1, NULL, NULL),
(23, 'MLT', 'MILLILITRE', NULL, 0, NULL, '2022-12-21 01:13:05'),
(24, 'MTR', 'METERS', '1', 1, NULL, NULL),
(25, 'MTS', 'METRIC TONS', NULL, 0, NULL, '2022-12-21 01:13:10'),
(26, 'NOS', 'NUMBERS', NULL, 0, NULL, '2022-12-21 01:13:15'),
(27, 'PAC', 'PACKS', NULL, 0, NULL, '2022-12-21 01:13:16'),
(28, 'PCS', 'PIECES', NULL, 0, NULL, '2022-12-21 01:13:17'),
(29, 'PRS', 'PAIRS', NULL, 0, NULL, '2022-12-21 01:13:17'),
(30, 'QTL', 'QUINTAL', '100', 1, NULL, NULL),
(31, 'ROL', 'ROLLS', NULL, 0, NULL, '2022-12-21 01:13:27'),
(32, 'SET', 'SETS', NULL, 0, NULL, '2022-12-21 01:13:27'),
(33, 'SQF', 'SQUARE FEET', NULL, 0, NULL, '2022-12-21 01:13:28'),
(34, 'SQM', 'SQUARE METERS', NULL, 0, NULL, '2022-12-21 01:13:29'),
(35, 'SQY', 'SQUARE YARDS', NULL, 0, NULL, '2022-12-21 01:13:30'),
(36, 'TBS', 'TABLETS', NULL, 0, NULL, '2022-12-21 01:13:30'),
(37, 'TGM', 'TEN GROSS', NULL, 0, NULL, '2022-12-21 01:13:31'),
(38, 'THD', 'THOUSANDS', NULL, 0, NULL, '2022-12-21 01:13:32'),
(39, 'TON', 'TONNES', '1000', 1, NULL, NULL),
(40, 'TUB', 'TUBES', NULL, 0, NULL, '2022-12-21 01:13:42'),
(41, 'UGS', 'US GALLONS', NULL, 0, NULL, '2022-12-21 01:13:43'),
(42, 'UNT', 'UNITS', NULL, 0, NULL, '2022-12-21 01:13:44'),
(43, 'YDS', 'YARDS', NULL, 0, NULL, '2022-12-21 01:13:45'),
(44, 'OTH', 'OTHERS', NULL, 0, NULL, '2022-12-21 01:13:46');

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

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

CREATE TABLE `warehouses` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `warehouses` (`id`, `name`, `contact`, `address`, `latitude`, `longitude`, `created_at`, `updated_at`) VALUES
(1, 'warehouse 1', '8799302123', 'ABC', '21.2342725', '72.8712327', '2022-10-22 04:44:22', '2024-10-08 03:06:22'),
(2, 'warehouse 2', '1234567890', '3ewfeasfas', '22.3038945', '70.80215989999999', '2022-10-22 06:36:50', '2022-12-20 06:21:43'),
(3, 'warehouse 3', '6185133405', 'narol ahmedabad', '22.9641614', '72.5903337', '2022-12-22 04:15:26', '2022-12-22 04:15:26'),
(4, 'warehouse 4', '8911387735', 'naroda ahmedabad', '23.0685865', '72.6535961', '2022-12-22 04:15:55', '2022-12-22 04:15:55'),
(5, 'warehouse 5', '0520882976', 'gota ahmedabad', '22.2792533', '70.8356719', '2022-12-22 04:16:19', '2022-12-22 05:27:25'),
(6, 'SeaBird CSF', '8888888888', 'Mundra Port', '22.7917371', '69.68422919999999', '2024-09-28 09:41:04', '2024-09-28 09:41:04');

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

--
-- Table structure for table `work_types`
--

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

--
-- Dumping data for table `work_types`
--

INSERT INTO `work_types` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'stuffing', '2022-12-20 04:46:22', '2022-12-20 04:51:52'),
(2, 'Destuffing', '2024-09-28 09:42:09', '2024-09-28 09:42:09');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `cargos`
--
ALTER TABLE `cargos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cargos_category_id_foreign` (`category_id`),
  ADD KEY `cargos_unit_id_foreign` (`unit_id`),
  ADD KEY `cargos_type_id_foreign` (`type_id`);

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

--
-- Indexes for table `ledgers`
--
ALTER TABLE `ledgers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ledgers_account_id_foreign` (`account_id`),
  ADD KEY `ledgers_company_id_foreign` (`company_id`);

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

--
-- Indexes for table `mulajim_group_labours`
--
ALTER TABLE `mulajim_group_labours`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mulajim_group_labours_mulajim_group_id_foreign` (`mulajim_group_id`),
  ADD KEY `mulajim_group_labours_labour_id_foreign` (`labour_id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_receiver_warehouse_id_foreign` (`receiver_warehouse_id`),
  ADD KEY `notifications_receiver_mulajim_id_foreign` (`receiver_mulajim_id`),
  ADD KEY `notifications_receiver_labor_id_foreign` (`receiver_labor_id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_company_id_foreign` (`company_id`),
  ADD KEY `orders_warehouse_id_foreign` (`warehouse_id`),
  ADD KEY `orders_work_type_id_foreign` (`work_type_id`);

--
-- Indexes for table `order_accepted_distances`
--
ALTER TABLE `order_accepted_distances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_accepted_distances_user_id_foreign` (`user_id`),
  ADD KEY `order_accepted_distances_mulajim_group_id_foreign` (`mulajim_group_id`),
  ADD KEY `order_accepted_distances_mulajim_id_foreign` (`mulajim_id`),
  ADD KEY `order_accepted_distances_labour_id_foreign` (`labour_id`),
  ADD KEY `order_accepted_distances_order_container_id_foreign` (`order_container_id`);

--
-- Indexes for table `order_accept_logs`
--
ALTER TABLE `order_accept_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_accept_logs_user_id_foreign` (`user_id`),
  ADD KEY `order_accept_logs_mulajim_group_id_foreign` (`mulajim_group_id`),
  ADD KEY `order_accept_logs_mulajim_id_foreign` (`mulajim_id`),
  ADD KEY `order_accept_logs_labour_id_foreign` (`labour_id`),
  ADD KEY `order_accept_logs_company_id_foreign` (`company_id`),
  ADD KEY `order_accept_logs_order_container_id_foreign` (`order_container_id`);

--
-- Indexes for table `order_containers`
--
ALTER TABLE `order_containers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_containers_order_id_foreign` (`order_id`),
  ADD KEY `order_containers_cargo_id_foreign` (`cargo_id`);

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

--
-- Indexes for table `order_mulajims`
--
ALTER TABLE `order_mulajims`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_mulajims_order_id_foreign` (`order_id`),
  ADD KEY `order_mulajims_mulajim_id_foreign` (`mulajim_id`);

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `order_log`
--
ALTER TABLE `order_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `cargos`
--
ALTER TABLE `cargos`
  ADD CONSTRAINT `cargos_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `cargos_type_id_foreign` FOREIGN KEY (`type_id`) REFERENCES `types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `cargos_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `ledgers`
--
ALTER TABLE `ledgers`
  ADD CONSTRAINT `ledgers_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `ledgers_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mulajim_group_labours`
--
ALTER TABLE `mulajim_group_labours`
  ADD CONSTRAINT `mulajim_group_labours_labour_id_foreign` FOREIGN KEY (`labour_id`) REFERENCES `labours` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mulajim_group_labours_mulajim_group_id_foreign` FOREIGN KEY (`mulajim_group_id`) REFERENCES `mulajim_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
  ADD CONSTRAINT `notifications_receiver_labor_id_foreign` FOREIGN KEY (`receiver_labor_id`) REFERENCES `labours` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `notifications_receiver_mulajim_id_foreign` FOREIGN KEY (`receiver_mulajim_id`) REFERENCES `mulajims` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `notifications_receiver_warehouse_id_foreign` FOREIGN KEY (`receiver_warehouse_id`) REFERENCES `warehouses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `orders_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `orders_work_type_id_foreign` FOREIGN KEY (`work_type_id`) REFERENCES `work_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `order_accepted_distances`
--
ALTER TABLE `order_accepted_distances`
  ADD CONSTRAINT `order_accepted_distances_labour_id_foreign` FOREIGN KEY (`labour_id`) REFERENCES `labours` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_accepted_distances_mulajim_group_id_foreign` FOREIGN KEY (`mulajim_group_id`) REFERENCES `mulajim_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_accepted_distances_mulajim_id_foreign` FOREIGN KEY (`mulajim_id`) REFERENCES `mulajims` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_accepted_distances_order_container_id_foreign` FOREIGN KEY (`order_container_id`) REFERENCES `order_containers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_accepted_distances_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `order_accept_logs`
--
ALTER TABLE `order_accept_logs`
  ADD CONSTRAINT `order_accept_logs_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_accept_logs_labour_id_foreign` FOREIGN KEY (`labour_id`) REFERENCES `labours` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_accept_logs_mulajim_group_id_foreign` FOREIGN KEY (`mulajim_group_id`) REFERENCES `mulajim_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_accept_logs_mulajim_id_foreign` FOREIGN KEY (`mulajim_id`) REFERENCES `mulajims` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_accept_logs_order_container_id_foreign` FOREIGN KEY (`order_container_id`) REFERENCES `order_containers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_accept_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `order_containers`
--
ALTER TABLE `order_containers`
  ADD CONSTRAINT `order_containers_cargo_id_foreign` FOREIGN KEY (`cargo_id`) REFERENCES `cargos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_containers_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `order_mulajims`
--
ALTER TABLE `order_mulajims`
  ADD CONSTRAINT `order_mulajims_mulajim_id_foreign` FOREIGN KEY (`mulajim_id`) REFERENCES `mulajims` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_mulajims_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;
COMMIT;

