-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Oct 26, 2024 at 11:52 PM
-- Server version: 8.0.36
-- PHP Version: 8.2.24

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `garments`
--

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

--
-- Table structure for table `accessories`
--

CREATE TABLE `accessories` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `unit_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit_price` double NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) 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 `accessories`
--

INSERT INTO `accessories` (`id`, `user_id`, `unit_id`, `name`, `unit_price`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'C9700', 1, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 1, 2, 'kundan', 12, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, 1, 2, 'Silk Chiffon', 6, '80% Silk 20 % Chiffon', 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(4, 2, 3, 'kk', 9, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(5, 1, 3, 'rr', 12, 'test', 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(6, 2, 2, 'hasan', 1000, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(7, 2, 3, 'Jeck', 20, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

--
-- Table structure for table `accessory_orders`
--

CREATE TABLE `accessory_orders` (
  `id` bigint UNSIGNED NOT NULL,
  `invoice_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `accessory_id` bigint UNSIGNED NOT NULL,
  `party_id` bigint UNSIGNED NOT NULL,
  `qty_unit` int NOT NULL,
  `unit_price` double NOT NULL,
  `ttl_amount` double 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 `banks`
--

CREATE TABLE `banks` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `holder_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `branch_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `routing_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `balance` double NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_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;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` (`id`, `user_id`, `holder_name`, `bank_name`, `account_number`, `branch_name`, `routing_number`, `balance`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'Shahidul Islam', 'City Bank', '0123532201', 'Farmgate', '555554444', 0, 1, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 1, 'Safiull Alam', 'DBBL', '02556353221', 'Bhuighar', '2222255555', 0, 1, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

--
-- Table structure for table `bookingdetails`
--

CREATE TABLE `bookingdetails` (
  `id` bigint UNSIGNED NOT NULL,
  `booking_id` bigint UNSIGNED NOT NULL,
  `data` longtext COLLATE utf8mb4_unicode_ci,
  `cuff_color` text COLLATE utf8mb4_unicode_ci,
  `collar_size_qty` longtext COLLATE utf8mb4_unicode_ci,
  `cuff_solid` 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 `bookingdetails`
--

INSERT INTO `bookingdetails` (`id`, `booking_id`, `data`, `cuff_color`, `collar_size_qty`, `cuff_solid`, `created_at`, `updated_at`) VALUES
(1, 1, '{\"desc_garments\":[null,null],\"pantone\":[null,null],\"body_fab\":[null,null],\"yarn_count_body\":[null,null],\"garments_qty_dzn\":[null,null],\"body_fab_dzn\":[null,null],\"body_gray_fab\":[null,null],\"desc_garments_rib\":[null,null],\"yarn_count_rib\":[null,null],\"consump_rib_dzn\":[null,null],\"rib_kg\":[null,null],\"yarn_count_rib_lycra\":[null,null],\"receive\":[null,null],\"balance\":[null,null],\"gray_body_fab\":[null,null],\"gray_body_rib\":[null,null],\"revised\":[null,null],\"images\":[]}', '[null,null]', '{\"40_xs\":[null,null],\"41_s\":[null,null],\"42_m\":[null,null],\"43_l\":[null,null],\"44_xl\":[null,null],\"45_xxl\":[null,null],\"46_3xl\":[null,null],\"47_4xl\":[null,null]}', '{\"37_l\":[null,null],\"38_4xl\":[null,null],\"39_5xl\":[null,null],\"40_6xl\":[null,null]}', '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 2, '{\"desc_garments\":[null],\"pantone\":[null],\"body_fab\":[null],\"yarn_count_body\":[null],\"garments_qty_dzn\":[null],\"body_fab_dzn\":[null],\"body_gray_fab\":[null],\"desc_garments_rib\":[null],\"yarn_count_rib\":[null],\"consump_rib_dzn\":[null],\"rib_kg\":[null],\"yarn_count_rib_lycra\":[null],\"receive\":[null],\"balance\":[null],\"gray_body_fab\":[null],\"gray_body_rib\":[null],\"revised\":[null],\"images\":[]}', '[null]', '{\"40_xs\":[null],\"41_s\":[null],\"42_m\":[null],\"43_l\":[null],\"44_xl\":[null],\"45_xxl\":[null],\"46_3xl\":[null],\"47_4xl\":[null]}', '{\"37_l\":[null],\"38_4xl\":[null],\"39_5xl\":[null],\"40_6xl\":[null]}', '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, 3, '{\"desc_garments\":[null],\"pantone\":[null],\"body_fab\":[null],\"yarn_count_body\":[null],\"garments_qty_dzn\":[null],\"body_fab_dzn\":[null],\"body_gray_fab\":[null],\"desc_garments_rib\":[null],\"yarn_count_rib\":[null],\"consump_rib_dzn\":[null],\"rib_kg\":[null],\"yarn_count_rib_lycra\":[null],\"receive\":[null],\"balance\":[null],\"gray_body_fab\":[null],\"gray_body_rib\":[null],\"revised\":[null],\"images\":[\"uploads\\/24\\/08\\/1723469809_66ba0ff1f1ad3.jpg\"]}', '[null]', '{\"40_xs\":[null],\"41_s\":[null],\"42_m\":[null],\"43_l\":[null],\"44_xl\":[null],\"45_xxl\":[null],\"46_3xl\":[null],\"47_4xl\":[null]}', '{\"37_l\":[null],\"38_4xl\":[null],\"39_5xl\":[null],\"40_6xl\":[null]}', '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(4, 4, '{\"desc_garments\":[null,null,null],\"pantone\":[null,null,null],\"body_fab\":[null,null,null],\"yarn_count_body\":[null,null,null],\"garments_qty_dzn\":[null,null,null],\"body_fab_dzn\":[null,null,null],\"body_gray_fab\":[null,null,null],\"desc_garments_rib\":[null,null,null],\"yarn_count_rib\":[null,null,null],\"consump_rib_dzn\":[null,null,null],\"rib_kg\":[null,null,null],\"yarn_count_rib_lycra\":[null,null,null],\"receive\":[null,null,null],\"balance\":[null,null,null],\"gray_body_fab\":[null,null,null],\"gray_body_rib\":[null,null,null],\"revised\":[null,null,null],\"images\":[]}', '[null,null,null]', '{\"40_xs\":[null,null,null],\"41_s\":[null,null,null],\"42_m\":[null,null,null],\"43_l\":[null,null,null],\"44_xl\":[null,null,null],\"45_xxl\":[null,null,null],\"46_3xl\":[null,null,null],\"47_4xl\":[null,null,null]}', '{\"37_l\":[null,null,null],\"38_4xl\":[null,null,null],\"39_5xl\":[null,null,null],\"40_6xl\":[null,null,null]}', '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `order_id` bigint UNSIGNED NOT NULL,
  `booking_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `composition` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `booking_date` date NOT NULL,
  `meta` longtext COLLATE utf8mb4_unicode_ci,
  `header` longtext COLLATE utf8mb4_unicode_ci,
  `status` tinyint NOT NULL DEFAULT '1',
  `reason` varchar(191) 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 `bookings`
--

INSERT INTO `bookings` (`id`, `user_id`, `order_id`, `booking_no`, `composition`, `booking_date`, `meta`, `header`, `status`, `reason`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'BK-0001', NULL, '2024-07-22', '{\"process_loss\":null,\"other_fabric\":null,\"rib\":null,\"collar\":null}', '{\"collar_size_qty_40\":\"40X7.5\",\"collar_size_qty_41\":\"41X7.5\",\"collar_size_qty_42\":\"42X7.5\",\"collar_size_qty_43\":\"43X7.5\",\"collar_size_qty_44\":\"44X7.5\",\"collar_size_qty_45\":\"45X7.5\",\"collar_size_qty_46\":\"46X7.5\",\"collar_size_qty_47\":\"47X7.5\",\"cuff_solid_l\":\"Qty.XS-L\",\"cuff_solid_4xl\":\"Qty.XL-4XL\",\"cuff_solid_5xl\":\"Qty.XS-5XL\",\"cuff_solid_6xl\":\"Qty.XL-6XL\",\"collar_size_qty_xs\":\"XS\",\"collar_size_qty_s\":\"S\",\"collar_size_qty_m\":\"M\",\"collar_size_qty_l\":\"L\",\"collar_size_qty_xl\":\"XL\",\"collar_size_qty_xxl\":\"XXL\",\"collar_size_qty_3xl\":\"3XL\",\"collar_size_qty_4xl\":\"4XL\",\"cuff_solid_37\":\"37X.3.5 CM\",\"cuff_solid_38\":\"40X.3.5 CM\",\"cuff_solid_39\":\"37X.3.5 CM\",\"cuff_solid_40\":\"40X.3.5 CM\"}', 2, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 2, 3, 'BK-0002', '100%COTTON TWILL AOP', '2024-07-25', '{\"process_loss\":null,\"other_fabric\":null,\"rib\":null,\"collar\":null}', '{\"collar_size_qty_40\":\"40X7.5\",\"collar_size_qty_41\":\"41X7.5\",\"collar_size_qty_42\":\"42X7.5\",\"collar_size_qty_43\":\"43X7.5\",\"collar_size_qty_44\":\"44X7.5\",\"collar_size_qty_45\":\"45X7.5\",\"collar_size_qty_46\":\"46X7.5\",\"collar_size_qty_47\":\"47X7.5\",\"cuff_solid_l\":\"Qty.XS-L\",\"cuff_solid_4xl\":\"Qty.XL-4XL\",\"cuff_solid_5xl\":\"Qty.XS-5XL\",\"cuff_solid_6xl\":\"Qty.XL-6XL\",\"collar_size_qty_xs\":\"XS\",\"collar_size_qty_s\":\"S\",\"collar_size_qty_m\":\"M\",\"collar_size_qty_l\":\"L\",\"collar_size_qty_xl\":\"XL\",\"collar_size_qty_xxl\":\"XXL\",\"collar_size_qty_3xl\":\"3XL\",\"collar_size_qty_4xl\":\"4XL\",\"cuff_solid_37\":\"37X.3.5 CM\",\"cuff_solid_38\":\"40X.3.5 CM\",\"cuff_solid_39\":\"37X.3.5 CM\",\"cuff_solid_40\":\"40X.3.5 CM\"}', 2, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, 1, 7, 'BK-0003', NULL, '2024-08-12', '{\"process_loss\":null,\"other_fabric\":null,\"rib\":null,\"collar\":null}', '{\"collar_size_qty_40\":\"40X7.5\",\"collar_size_qty_41\":\"41X7.5\",\"collar_size_qty_42\":\"42X7.5\",\"collar_size_qty_43\":\"43X7.5\",\"collar_size_qty_44\":\"44X7.5\",\"collar_size_qty_45\":\"45X7.5\",\"collar_size_qty_46\":\"46X7.5\",\"collar_size_qty_47\":\"47X7.5\",\"cuff_solid_l\":\"Qty.XS-L\",\"cuff_solid_4xl\":\"Qty.XL-4XL\",\"cuff_solid_5xl\":\"Qty.XS-5XL\",\"cuff_solid_6xl\":\"Qty.XL-6XL\",\"collar_size_qty_xs\":\"XS\",\"collar_size_qty_s\":\"S\",\"collar_size_qty_m\":\"M\",\"collar_size_qty_l\":\"L\",\"collar_size_qty_xl\":\"XL\",\"collar_size_qty_xxl\":\"XXL\",\"collar_size_qty_3xl\":\"3XL\",\"collar_size_qty_4xl\":\"4XL\",\"cuff_solid_37\":\"37X.3.5 CM\",\"cuff_solid_38\":\"40X.3.5 CM\",\"cuff_solid_39\":\"37X.3.5 CM\",\"cuff_solid_40\":\"40X.3.5 CM\"}', 2, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(4, 1, 5, 'BK-0004', NULL, '2024-08-14', '{\"process_loss\":null,\"other_fabric\":null,\"rib\":null,\"collar\":null}', '{\"collar_size_qty_40\":\"40X7.5\",\"collar_size_qty_41\":\"41X7.5\",\"collar_size_qty_42\":\"42X7.5\",\"collar_size_qty_43\":\"43X7.5\",\"collar_size_qty_44\":\"44X7.5\",\"collar_size_qty_45\":\"45X7.5\",\"collar_size_qty_46\":\"46X7.5\",\"collar_size_qty_47\":\"47X7.5\",\"cuff_solid_l\":\"Qty.XS-L\",\"cuff_solid_4xl\":\"Qty.XL-4XL\",\"cuff_solid_5xl\":\"Qty.XS-5XL\",\"cuff_solid_6xl\":\"Qty.XL-6XL\",\"collar_size_qty_xs\":\"XS\",\"collar_size_qty_s\":\"S\",\"collar_size_qty_m\":\"M\",\"collar_size_qty_l\":\"L\",\"collar_size_qty_xl\":\"XL\",\"collar_size_qty_xxl\":\"XXL\",\"collar_size_qty_3xl\":\"3XL\",\"collar_size_qty_4xl\":\"4XL\",\"cuff_solid_37\":\"37X.3.5 CM\",\"cuff_solid_38\":\"40X.3.5 CM\",\"cuff_solid_39\":\"37X.3.5 CM\",\"cuff_solid_40\":\"40X.3.5 CM\"}', 2, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

--
-- Table structure for table `cashes`
--

CREATE TABLE `cashes` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `voucher_id` bigint UNSIGNED DEFAULT NULL,
  `amount` double NOT NULL DEFAULT '0',
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cash_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `deleted_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;

--
-- Dumping data for table `cashes`
--

INSERT INTO `cashes` (`id`, `user_id`, `voucher_id`, `amount`, `type`, `bank_id`, `cash_type`, `date`, `description`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 10000000, 'credit', 'petty_cash', 'main cash', '2024-07-23', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 1, 2, 2000, 'debit', NULL, 'employee_salary', '2024-07-23', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, 1, 3, 5000, 'credit', 'new_party_create', 'customer_payment', '2024-07-24', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(4, 1, 4, 20000, 'debit', '1', 'employee_salary', '2024-07-29', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(5, 9, 5, 2000, 'debit', NULL, 'balance_withdraw', '2024-08-03', 'Remarks', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(6, 2, 6, 200000, 'debit', NULL, 'employee_salary', '2024-08-06', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(7, 3, 7, 1800, 'credit', NULL, 'party_payment', '2024-08-15', 'jhg', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(8, 9, 8, 100, 'debit', NULL, 'balance_withdraw', '2024-08-19', 'Ab', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

--
-- Table structure for table `cheques`
--

CREATE TABLE `cheques` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `voucher_id` bigint UNSIGNED NOT NULL,
  `party_id` bigint UNSIGNED DEFAULT NULL,
  `bank_id` bigint UNSIGNED DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cheque_no` int NOT NULL,
  `amount` double NOT NULL,
  `issue_date` date NOT NULL,
  `status` int NOT NULL DEFAULT '0',
  `deleted_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 `costbudgets`
--

CREATE TABLE `costbudgets` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `order_id` bigint UNSIGNED NOT NULL,
  `order_info` text COLLATE utf8mb4_unicode_ci,
  `pre_cost_date` date NOT NULL,
  `post_cost_date` date NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `yarn_desc` longtext COLLATE utf8mb4_unicode_ci,
  `yarn_cost` double NOT NULL DEFAULT '0',
  `yarn_qty` double NOT NULL DEFAULT '0',
  `knitting_desc` longtext COLLATE utf8mb4_unicode_ci,
  `knitting_cost` double NOT NULL DEFAULT '0',
  `knitting_qty` double NOT NULL DEFAULT '0',
  `dfa_desc` longtext COLLATE utf8mb4_unicode_ci,
  `dfa_cost` double NOT NULL DEFAULT '0',
  `dfa_qty` double NOT NULL DEFAULT '0',
  `fabric_cost` double NOT NULL DEFAULT '0',
  `fabric_qty` double NOT NULL DEFAULT '0',
  `accessories_desc` longtext COLLATE utf8mb4_unicode_ci,
  `accessories_cost` double NOT NULL DEFAULT '0',
  `accessories_qty` double NOT NULL DEFAULT '0',
  `total_making_cost` double NOT NULL DEFAULT '0',
  `total_making_pre_cost` double NOT NULL DEFAULT '0',
  `finance_value` double DEFAULT '0',
  `finance_cost` double NOT NULL DEFAULT '0',
  `finance_pre_cost` double NOT NULL DEFAULT '0',
  `deferred_value` double DEFAULT '0',
  `deferred_cost` double NOT NULL DEFAULT '0',
  `deferred_pre_cost` double NOT NULL DEFAULT '0',
  `other_cost` double DEFAULT '0',
  `grand_cost` double NOT NULL DEFAULT '0',
  `pre_cost_desc` longtext COLLATE utf8mb4_unicode_ci,
  `factory_cm_cost` double NOT NULL DEFAULT '0',
  `factory_cm_pre_cost` double NOT NULL DEFAULT '0',
  `total_expense_cost` double NOT NULL DEFAULT '0',
  `total_expense_pre_cost` double NOT NULL DEFAULT '0',
  `net_earning_cost` double NOT NULL DEFAULT '0',
  `net_earning_pre_cost` double NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  `meta` 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 `costbudgets`
--

INSERT INTO `costbudgets` (`id`, `user_id`, `order_id`, `order_info`, `pre_cost_date`, `post_cost_date`, `image`, `yarn_desc`, `yarn_cost`, `yarn_qty`, `knitting_desc`, `knitting_cost`, `knitting_qty`, `dfa_desc`, `dfa_cost`, `dfa_qty`, `fabric_cost`, `fabric_qty`, `accessories_desc`, `accessories_cost`, `accessories_qty`, `total_making_cost`, `total_making_pre_cost`, `finance_value`, `finance_cost`, `finance_pre_cost`, `deferred_value`, `deferred_cost`, `deferred_pre_cost`, `other_cost`, `grand_cost`, `pre_cost_desc`, `factory_cm_cost`, `factory_cm_pre_cost`, `total_expense_cost`, `total_expense_pre_cost`, `net_earning_cost`, `net_earning_pre_cost`, `status`, `meta`, `created_at`, `updated_at`) VALUES
(1, 1, 2, '{\"style\":\"7100\",\"color\":\"black\",\"shipment_date\":\"2024-07-22\",\"qty\":\"90\",\"unit_price\":\"90\",\"lc\":\"8100\"}', '2024-07-24', '2024-07-25', NULL, '{\"fab_desc\":[\"CARTON CORRUGADO\"],\"supplier_name\":[\"CARTON\"],\"yarn_count\":[\"5\"],\"unit_price\":[\"15\"],\"consumption\":[\"0\"],\"w\":[\"0\"],\"total_qty\":[\"2\"],\"total_cost\":[\"30.000\"],\"pre_cost\":[\"0.370\"]}', 30, 2, '{\"fab_desc\":[\"CINTA\"],\"supplier_name\":[\"CINTA\"],\"yarn_count\":[\"8\"],\"unit_price\":[\"10\"],\"consumption\":[\"0\"],\"w\":[\"0\"],\"total_qty\":[\"5\"],\"total_cost\":[\"50.000\"],\"pre_cost\":[\"0.617\"]}', 50, 5, '{\"fab_desc\":[\"RESISTOL\"],\"supplier_name\":[\"RESISTOL\"],\"yarn_count\":[\"10\"],\"unit_price\":[\"20\"],\"consumption\":[\"0\"],\"w\":[\"0\"],\"total_qty\":[\"15\"],\"total_cost\":[\"300.000\"],\"pre_cost\":[\"3.704\"]}', 300, 15, 380, 22, '{\"accessories_des\":[null],\"supplier_name\":[null],\"unit_price\":[\"0\"],\"unit_number\":[null],\"consumption\":[null],\"w\":[null],\"total_qty\":[\"0\"],\"total_cost\":[\"0.000\"],\"pre_cost\":[\"0.000\"]}', 0, 0, 380, 4.691, 0, 0, 0, 0, 0, 0, NULL, 380, '{\"yarn\":\"0.37\",\"knitting\":\"0.617\",\"dfa\":\"3.704\",\"fabric\":\"4.691\",\"accessories\":\"0\",\"grand\":\"4.691\"}', 380, 4.691, 380, 4.691, 7720, 95.309, 2, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 2, 3, '{\"style\":\"CARGO NR232\",\"color\":\"TIGER PRINT\",\"shipment_date\":\"2024-09-20\",\"qty\":\"20000\",\"unit_price\":\"5.50\",\"lc\":\"110000\"}', '2024-07-25', '2024-08-31', NULL, '{\"fab_desc\":[\"100%COTTON TWILL AOP\"],\"supplier_name\":[\"UNITED TEX\"],\"yarn_count\":[\"168X70\"],\"unit_price\":[\"3.5\"],\"consumption\":[null],\"w\":[\"3%\"],\"total_qty\":[\"15000\"],\"total_cost\":[\"52500.000\"],\"pre_cost\":[\"47.727\"]}', 52500, 15000, '{\"fab_desc\":[null],\"supplier_name\":[null],\"yarn_count\":[null],\"unit_price\":[\"0\"],\"consumption\":[null],\"w\":[null],\"total_qty\":[\"0\"],\"total_cost\":[\"0.000\"],\"pre_cost\":[\"0.000\"]}', 0, 0, '{\"fab_desc\":[null],\"supplier_name\":[null],\"yarn_count\":[null],\"unit_price\":[\"0\"],\"consumption\":[\"0\"],\"w\":[null],\"total_qty\":[\"0\"],\"total_cost\":[\"0.000\"],\"pre_cost\":[\"0.000\"]}', 0, 0, 52500, 15000, '{\"accessories_des\":[\"BATTON\"],\"supplier_name\":[\"DF ACCESSORIES\"],\"unit_price\":[\"0.10\"],\"unit_number\":[\"15000\"],\"consumption\":[null],\"w\":[\"1%\"],\"total_qty\":[\"15000\"],\"total_cost\":[\"1500.000\"],\"pre_cost\":[\"1.364\"]}', 1500, 15000, 54000, 49.090999999999994, 0.6, 660, 0.6, 0, 0, 0, NULL, 54660, '{\"yarn\":\"47.727\",\"knitting\":\"0\",\"dfa\":\"0\",\"fabric\":\"47.727\",\"accessories\":\"1.364\",\"grand\":\"49.690999999999995\"}', 54000, 49.090999999999994, 54660, 49.691, 55340, 50.309, 2, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

--
-- Table structure for table `costings`
--

CREATE TABLE `costings` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `order_id` bigint UNSIGNED NOT NULL,
  `buying_commission` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_info` text COLLATE utf8mb4_unicode_ci,
  `yarn_desc` longtext COLLATE utf8mb4_unicode_ci,
  `yarn_total` double DEFAULT NULL,
  `knitting_desc` longtext COLLATE utf8mb4_unicode_ci,
  `knitting_total` double DEFAULT NULL,
  `dyeing_desc` longtext COLLATE utf8mb4_unicode_ci,
  `dyeing_total` double DEFAULT NULL,
  `print_desc` longtext COLLATE utf8mb4_unicode_ci,
  `print_total` longtext COLLATE utf8mb4_unicode_ci,
  `trim_desc` longtext COLLATE utf8mb4_unicode_ci,
  `trim_total` double DEFAULT NULL,
  `commercial_qty` double DEFAULT NULL,
  `commercial_unit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commercial_price` double DEFAULT NULL,
  `commercial_total` double DEFAULT NULL,
  `cm_cost_composition` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cm_cost_qty` double DEFAULT NULL,
  `cm_cost_unit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cm_cost_price` double DEFAULT NULL,
  `cm_cost_total` double DEFAULT NULL,
  `grand_total` double DEFAULT NULL,
  `grand_total_in_dzn` double DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `reason` varchar(191) 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 `costings`
--

INSERT INTO `costings` (`id`, `user_id`, `order_id`, `buying_commission`, `order_info`, `yarn_desc`, `yarn_total`, `knitting_desc`, `knitting_total`, `dyeing_desc`, `dyeing_total`, `print_desc`, `print_total`, `trim_desc`, `trim_total`, `commercial_qty`, `commercial_unit`, `commercial_price`, `commercial_total`, `cm_cost_composition`, `cm_cost_qty`, `cm_cost_unit`, `cm_cost_price`, `cm_cost_total`, `grand_total`, `grand_total_in_dzn`, `status`, `reason`, `created_at`, `updated_at`) VALUES
(1, 1, 2, NULL, '{\"style\":\"7100\",\"shipment_date\":\"2024-07-22\",\"qty\":\"90\",\"unit_price\":\"90\",\"lc\":\"8100\"}', '{\"items\":[\"CAJA\"],\"composition\":[\"CAJA\"],\"type\":[\"1\"],\"qty\":[\"10\"],\"unit\":[\"15\"],\"price\":[\"15\"],\"total\":[\"150.00\"],\"grand_total\":[null],\"payment\":[\"0\"],\"remarks\":[null]}', 150, '{\"items\":[\"CAJA 2\"],\"composition\":[\"CAJA 2\"],\"type\":[\"5\"],\"qty\":[\"15\"],\"unit\":[\"6\"],\"price\":[\"85\"],\"total\":[\"1275.00\"],\"grand_total\":[null],\"payment\":[\"0\"],\"remarks\":[null]}', 1275, '{\"items\":[\"CAJA 3\"],\"composition\":[\"CAJA 3\"],\"type\":[\"2\"],\"qty\":[\"13\"],\"unit\":[\"2\"],\"price\":[\"4\"],\"total\":[\"52.00\"],\"grand_total\":[null],\"payment\":[\"0\"],\"remarks\":[null]}', 52, '{\"items\":[null],\"composition\":[null],\"type\":[null],\"qty\":[null],\"unit\":[null],\"price\":[null],\"total\":[\"0.00\"],\"grand_total\":[null],\"payment\":[null],\"remarks\":[null]}', '0.00', '{\"items\":[null],\"composition\":[null],\"type\":[null],\"qty\":[null],\"unit\":[null],\"price\":[null],\"total\":[\"0.00\"],\"grand_total\":[null],\"payment\":[null],\"remarks\":[null]}', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, 1477, 123.08, 2, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 3, 3, NULL, '{\"style\":\"CARGO NR232\",\"shipment_date\":\"2024-09-20\",\"qty\":\"20000\",\"unit_price\":\"5.50\",\"lc\":\"110000\"}', '{\"items\":[null],\"composition\":[null],\"type\":[null],\"qty\":[null],\"unit\":[null],\"price\":[null],\"total\":[\"0\"],\"grand_total\":[null],\"payment\":[null],\"remarks\":[null]}', 0, '{\"items\":[null],\"composition\":[null],\"type\":[null],\"qty\":[null],\"unit\":[null],\"price\":[null],\"total\":[\"0\"],\"grand_total\":[null],\"payment\":[null],\"remarks\":[null]}', 0, '{\"items\":[null],\"composition\":[null],\"type\":[null],\"qty\":[null],\"unit\":[null],\"price\":[null],\"total\":[\"0\"],\"grand_total\":[null],\"payment\":[null],\"remarks\":[null]}', 0, '{\"items\":[null],\"composition\":[null],\"type\":[null],\"qty\":[null],\"unit\":[null],\"price\":[null],\"total\":[\"0\"],\"grand_total\":[null],\"payment\":[null],\"remarks\":[null]}', '0', '{\"items\":[null],\"composition\":[null],\"type\":[null],\"qty\":[null],\"unit\":[null],\"price\":[null],\"total\":[\"0\"],\"grand_total\":[null],\"payment\":[null],\"remarks\":[null]}', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, 0, 0, 1, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` double DEFAULT NULL,
  `symbol` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `is_default` tinyint(1) 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 `currencies`
--

INSERT INTO `currencies` (`id`, `name`, `code`, `rate`, `symbol`, `position`, `status`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'Afghani', 'AFN', NULL, '؋', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(2, 'Lek', 'ALL', NULL, 'Lek', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(3, 'Netherlands Antillian Guilder', 'ANG', NULL, 'ƒ', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(4, 'Argentine Peso', 'ARS', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(5, 'Australian Dollar', 'AUD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(6, 'Aruban Guilder', 'AWG', NULL, 'ƒ', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(7, 'Azerbaijanian Manat', 'AZN', NULL, 'ман', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(8, 'Convertible Marks', 'BAM', NULL, 'KM', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(9, 'Barbados Dollar', 'BBD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(10, 'Bangladeshi Taka', 'BDT', NULL, '৳', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(11, 'Bulgarian Lev', 'BGN', NULL, 'лв', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(12, 'Bermudian Dollar', 'BMD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(13, 'Brunei Dollar', 'BND', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(14, 'BOV Boliviano Mvdol', 'BOB', NULL, '$b', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(15, 'Brazilian Real', 'BRL', NULL, 'R$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(16, 'Bahamian Dollar', 'BSD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(17, 'Pula', 'BWP', NULL, 'P', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(18, 'Belarussian Ruble', 'BYR', NULL, 'p.', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(19, 'Belize Dollar', 'BZD', NULL, 'BZ$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(20, 'Canadian Dollar', 'CAD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(21, 'Swiss Franc', 'CHF', NULL, 'CHF', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(22, 'CLF Chilean Peso Unidades de fomento', 'CLP', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(23, 'Yuan Renminbi', 'CNY', NULL, '¥', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(24, 'COU Colombian Peso Unidad de Valor Real', 'COP', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(25, 'Costa Rican Colon', 'CRC', NULL, '₡', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(26, 'CUC Cuban Peso Peso Convertible', 'CUP', NULL, '₱', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(27, 'Czech Koruna', 'CZK', NULL, 'Kč', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(28, 'Danish Krone', 'DKK', NULL, 'kr', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(29, 'Dominican Peso', 'DOP', NULL, 'RD$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(30, 'Egyptian Pound', 'EGP', NULL, '£', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(31, 'Euro', 'EUR', NULL, '€', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(32, 'Fiji Dollar', 'FJD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(33, 'Falkland Islands Pound', 'FKP', NULL, '£', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(34, 'Pound Sterling', 'GBP', NULL, '£', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(35, 'Gibraltar Pound', 'GIP', NULL, '£', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(36, 'Quetzal', 'GTQ', NULL, 'Q', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(37, 'Guyana Dollar', 'GYD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(38, 'Hong Kong Dollar', 'HKD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(39, 'Lempira', 'HNL', NULL, 'L', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(40, 'Croatian Kuna', 'HRK', NULL, 'kn', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(41, 'Forint', 'HUF', NULL, 'Ft', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(42, 'Rupiah', 'IDR', NULL, 'Rp', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(43, 'New Israeli Sheqel', 'ILS', NULL, '₪', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(44, 'Iranian Rial', 'IRR', NULL, '﷼', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(45, 'Iceland Krona', 'ISK', NULL, 'kr', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(46, 'Jamaican Dollar', 'JMD', NULL, 'J$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(47, 'Yen', 'JPY', NULL, '¥', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(48, 'Som', 'KGS', NULL, 'лв', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(49, 'Riel', 'KHR', NULL, '៛', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(50, 'North Korean Won', 'KPW', NULL, '₩', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(51, 'Won', 'KRW', NULL, '₩', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(52, 'Cayman Islands Dollar', 'KYD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(53, 'Tenge', 'KZT', NULL, 'лв', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(54, 'Kip', 'LAK', NULL, '₭', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(55, 'Lebanese Pound', 'LBP', NULL, '£', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(56, 'Sri Lanka Rupee', 'LKR', NULL, '₨', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(57, 'Liberian Dollar', 'LRD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(58, 'Lithuanian Litas', 'LTL', NULL, 'Lt', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(59, 'Latvian Lats', 'LVL', NULL, 'Ls', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(60, 'Denar', 'MKD', NULL, 'ден', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(61, 'Tugrik', 'MNT', NULL, '₮', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(62, 'Mauritius Rupee', 'MUR', NULL, '₨', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(63, 'MXV Mexican Peso Mexican Unidad de Inversion (UDI)', 'MXN', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(64, 'Malaysian Ringgit', 'MYR', NULL, 'RM', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(65, 'Metical', 'MZN', NULL, 'MT', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(66, 'Naira', 'NGN', NULL, '₦', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(67, 'Cordoba Oro', 'NIO', NULL, 'C$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(68, 'Norwegian Krone', 'NOK', NULL, 'kr', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(69, 'Nepalese Rupee', 'NPR', NULL, '₨', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(70, 'New Zealand Dollar', 'NZD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(71, 'Rial Omani', 'OMR', NULL, '﷼', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(72, 'USD Balboa US Dollar', 'PAB', NULL, 'B/.', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(73, 'Nuevo Sol', 'PEN', NULL, 'S/.', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(74, 'Philippine Peso', 'PHP', NULL, 'Php', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(75, 'Pakistan Rupee', 'PKR', NULL, '₨', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(76, 'Zloty', 'PLN', NULL, 'zł', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(77, 'Guarani', 'PYG', NULL, 'Gs', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(78, 'Qatari Rial', 'QAR', NULL, '﷼', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(79, 'Serbian Dinar', 'RSD', NULL, 'Дин.', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(80, 'Russian Ruble', 'RUB', NULL, '₽', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(81, 'Rwanda Franc', 'RWF', NULL, '₣', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(82, 'Saudi Riyal', 'SAR', NULL, '﷼', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(83, 'Solomon Islands Dollar', 'SBD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(84, 'Seychelles Rupee', 'SCR', NULL, '₨', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(85, 'Sudanese Pound', 'SDG', NULL, '£', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(86, 'Swedish Krona', 'SEK', NULL, 'kr', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(87, 'Singapore Dollar', 'SGD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(88, 'Saint Helena Pound', 'SHP', NULL, '£', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(89, 'Leone', 'SLL', NULL, 'Le', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(90, 'Somali Shilling', 'SOS', NULL, 'S', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(91, 'Surinam Dollar', 'SRD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(92, 'Dobra', 'STD', NULL, 'Db', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(93, 'El Salvador Colon', 'SVC', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(94, 'Syrian Pound', 'SYP', NULL, '£', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(95, 'Lilangeni', 'SZL', NULL, 'L', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(96, 'Baht', 'THB', NULL, '฿', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(97, 'Somoni', 'TJS', NULL, 'ЅМ', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(98, 'Manat', 'TMT', NULL, 'T', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(99, 'Tunisian Dinar', 'TND', NULL, 'د.ت', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(100, 'Pa\'anga', 'TOP', NULL, 'T$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(101, 'Turkish Lira', 'TRY', NULL, '₺', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(102, 'Trinidad and Tobago Dollar', 'TTD', NULL, 'TT$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(103, 'New Taiwan Dollar', 'TWD', NULL, 'NT$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(104, 'Tanzanian Shilling', 'TZS', NULL, 'TSh', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(105, 'Hryvnia', 'UAH', NULL, '₴', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(106, 'Uganda Shilling', 'UGX', NULL, 'USh', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(107, 'US Dollar', 'USD', NULL, '$', NULL, 1, 1, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(108, 'USN US Dollar (Next day)', 'USN', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(109, 'Uruguay Peso en Unidades Indexadas', 'UYI', NULL, '$U', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(110, 'Peso Uruguayo', 'UYU', NULL, '$U', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(111, 'Uzbekistan Sum', 'UZS', NULL, 'лв', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(112, 'Venezuelan Bolivar', 'VEF', NULL, 'Bs', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(113, 'Dong', 'VND', NULL, '₫', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(114, 'Vatu', 'VUV', NULL, 'Vt', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(115, 'Tala', 'WST', NULL, 'WS$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(116, 'CFA Franc BEAC', 'XAF', NULL, 'FCFA', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(117, 'East Caribbean Dollar', 'XCD', NULL, '$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(118, 'SDR (Special Drawing Rights)', 'XDR', NULL, 'XDR', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(119, 'CFA Franc BCEAO', 'XOF', NULL, 'CFA', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(120, 'Silver', 'XPD', NULL, 'XPD', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(121, 'Gold', 'XAU', NULL, 'XAU', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(122, 'Bond Markets Unit European Composite Unit (EURCO)', 'XBA', NULL, 'XBA', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(123, 'Bond Markets Unit European Monetary Unit (E.M.U.-6)', 'XBB', NULL, 'XBB', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(124, 'Bond Markets Unit European Unit of Account 9 (E.U.A.-9)', 'XBC', NULL, 'XBC', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(125, 'Bond Markets Unit European Unit of Account 17 (E.U.A.-17)', 'XBD', NULL, 'XBD', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(126, 'CFP Franc', 'XPF', NULL, '₣', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(127, 'Yemeni Rial', 'YER', NULL, '﷼', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(128, 'Rand', 'ZAR', NULL, 'R', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(129, 'Zambian Kwacha', 'ZMK', NULL, 'ZK', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(130, 'Zimbabwe Dollar', 'ZWD', NULL, 'Z$', NULL, 1, 0, '2024-10-26 14:20:49', '2024-10-26 14:20:49');

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

--
-- Table structure for table `designations`
--

CREATE TABLE `designations` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) 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 `designations`
--

INSERT INTO `designations` (`id`, `name`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Manager', 'manager', 0, '2024-07-12 10:23:54', '2024-07-12 10:23:54'),
(2, 'sublimacion', 'sublimacion', 0, '2024-07-21 22:09:16', '2024-07-21 22:09:16');

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

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

CREATE TABLE `employees` (
  `id` bigint UNSIGNED NOT NULL,
  `designation_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salary` double(10,3) NOT NULL DEFAULT '0.000',
  `employee_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `join_date` date DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `meta` 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 `employees`
--

INSERT INTO `employees` (`id`, `designation_id`, `name`, `email`, `address`, `gender`, `phone`, `salary`, `employee_type`, `join_date`, `birth_date`, `status`, `meta`, `created_at`, `updated_at`) VALUES
(1, 1, 'Test', 'ga@gmaio.com', 'dfgdf', 'male', '1234567876', 200000.000, NULL, '2024-07-12', '2000-01-01', 1, '{\"nid_front\":null,\"nid_back\":null}', '2024-07-12 10:24:23', '2024-07-18 10:58:53');

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

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` bigint UNSIGNED NOT NULL,
  `category_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `party_id` bigint UNSIGNED DEFAULT NULL,
  `total_bill` double NOT NULL DEFAULT '0',
  `total_paid` double NOT NULL DEFAULT '0',
  `total_due` double NOT NULL DEFAULT '0',
  `expense_description` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint 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 `expenses`
--

INSERT INTO `expenses` (`id`, `category_name`, `party_id`, `total_bill`, `total_paid`, `total_due`, `expense_description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Supplier Payment', NULL, 0, 0, 0, 'Supplier Payment', 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 'AINV-00001', 4, 2664, 0, 2664, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, 'Transport', NULL, 0, 0, 0, 'Transport', 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(4, 'Daily Expense', NULL, 0, 0, 0, 'Daily Expense', 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(5, 'AINV-00002', 4, 2288, 0, 2288, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(6, 'AINV-00003', 4, 176, 0, 176, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(7, 'AINV-00004', 4, 315, 0, 315, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(8, 'AINV-00005', 4, 49995, 0, 49995, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(191) 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 `files`
--

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

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

--
-- Table structure for table `folders`
--

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

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

--
-- Table structure for table `histories`
--

CREATE TABLE `histories` (
  `id` bigint UNSIGNED NOT NULL,
  `row_id` int NOT NULL,
  `action` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'update',
  `table` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'orders',
  `datas` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `incomes`
--

CREATE TABLE `incomes` (
  `id` bigint UNSIGNED NOT NULL,
  `party_id` bigint UNSIGNED DEFAULT NULL,
  `category_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_bill` double NOT NULL DEFAULT '0',
  `total_paid` double NOT NULL DEFAULT '0',
  `total_due` double NOT NULL DEFAULT '0',
  `income_description` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint 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 `incomes`
--

INSERT INTO `incomes` (`id`, `party_id`, `category_name`, `total_bill`, `total_paid`, `total_due`, `income_description`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Customer Payment', 0, 0, 0, 'Customer Payment', 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 3, '0000001', 390, 0, 390, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, 3, '0000002', 8100, 0, 8100, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(4, 6, '0000003', 110000, 0, 110000, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(5, 5, '0000005', 1320000, 0, 1320000, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(6, 1, '0000007', 650000, 0, 650000, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(7, 6, '0000008', 1800, 1800, 0, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(8, 7, '0000010', 200, 0, 200, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(9, 7, '0000011', 10000, 0, 10000, NULL, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(191) 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_000001_create_currencies_table', 1),
(2, '2014_10_12_000002_create_users_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2022_12_01_060451_create_units_table', 1),
(7, '2022_12_01_070125_create_parties_table', 1),
(8, '2022_12_01_070126_create_accessories_table', 1),
(9, '2022_12_02_061109_create_accessory_orders_table', 1),
(10, '2023_01_15_062742_create_incomes_table', 1),
(11, '2023_01_16_061931_create_expenses_table', 1),
(12, '2023_02_19_083215_create_banks_table', 1),
(13, '2023_02_22_060409_create_orders_table', 1),
(14, '2023_02_22_060551_create_order_details_table', 1),
(15, '2023_02_22_063705_create_bookings_table', 1),
(16, '2023_02_22_073246_create_bookingdetails_table', 1),
(17, '2023_02_28_095500_create_samples_table', 1),
(18, '2023_03_01_095210_create_costbudgets_table', 1),
(19, '2023_03_01_103847_create_costings_table', 1),
(20, '2023_03_27_092605_create_shipments_table', 1),
(21, '2023_03_29_035344_create_options_table', 1),
(22, '2023_04_02_045501_create_vouchers_table', 1),
(23, '2023_04_02_045502_create_cashes_table', 1),
(24, '2023_04_02_045503_create_transfers_table', 1),
(25, '2023_04_05_093606_create_cheques_table', 1),
(26, '2023_04_15_042027_create_productions_table', 1),
(27, '2023_05_04_064705_create_permission_tables', 1),
(28, '2023_05_16_040613_create_folders_table', 1),
(29, '2023_05_16_040622_create_files_table', 1),
(30, '2023_05_20_040815_create_notifications_table', 1),
(31, '2023_07_17_084218_create_histories_table', 1),
(32, '2023_09_03_091641_create_shipment_details_table', 1),
(33, '2023_09_17_111851_create_designations_table', 1),
(34, '2023_09_17_111909_create_employees_table', 1),
(35, '2023_09_17_145253_create_salaries_table', 1);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1),
(2, 'App\\Models\\User', 2),
(3, 'App\\Models\\User', 3),
(4, 'App\\Models\\User', 4),
(5, 'App\\Models\\User', 5),
(6, 'App\\Models\\User', 6),
(7, 'App\\Models\\User', 7),
(8, 'App\\Models\\User', 8),
(9, 'App\\Models\\User', 9),
(10, 'App\\Models\\User', 10);

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

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

CREATE TABLE `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint UNSIGNED NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_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 `options`
--

CREATE TABLE `options` (
  `id` bigint UNSIGNED NOT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) 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 `options`
--

INSERT INTO `options` (`id`, `key`, `value`, `status`, `created_at`, `updated_at`) VALUES
(1, 'company', '{\"_method\":\"put\",\"name\":\"Vishesh Textiles\",\"email\":\"maantheme@gmail.com\",\"remarks\":\"Software company in Dhaka\",\"address\":\"RH Home Center, Level#2, Green Road, Dhaka\",\"website\":\"https:\\/\\/maanerp.acnoo.com\",\"logo\":\"assets\\/images\\/logo\\/backend_logo.svg\",\"favicon\":\"assets\\/images\\/logo\\/favicon.svg\"}', 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 'company_balance', '0', 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

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

CREATE TABLE `orders` (
  `id` bigint UNSIGNED NOT NULL,
  `party_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `merchandiser_id` bigint UNSIGNED NOT NULL,
  `bank_id` bigint UNSIGNED DEFAULT NULL,
  `order_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `department` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fabrication` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gsm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `yarn_count` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipment_mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `season` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta` longtext COLLATE utf8mb4_unicode_ci,
  `invoice_details` longtext COLLATE utf8mb4_unicode_ci,
  `lc` double NOT NULL,
  `status` tinyint 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 `orders`
--

INSERT INTO `orders` (`id`, `party_id`, `user_id`, `merchandiser_id`, `bank_id`, `order_no`, `title`, `image`, `department`, `fabrication`, `gsm`, `yarn_count`, `shipment_mode`, `payment_mode`, `year`, `season`, `description`, `meta`, `invoice_details`, `lc`, `status`, `created_at`, `updated_at`) VALUES
(1, 3, 1, 7, NULL, '0000001', 'ooo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '{\"pantone\":null}', '{\"consignee\":null,\"contact_date\":\"2024-07-21\",\"expire_date\":\"2024-07-21\",\"negotiation\":null,\"loading\":null,\"discharge\":null,\"payment_terms\":null,\"remarks\":null}', 390, 2, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 3, 1, 15, NULL, '0000002', 'uh', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '{\"pantone\":null}', '{\"consignee\":null,\"contact_date\":\"2024-07-22\",\"expire_date\":\"2024-07-22\",\"negotiation\":null,\"loading\":null,\"discharge\":null,\"payment_terms\":null,\"remarks\":null}', 8100, 2, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, 6, 2, 15, 1, '0000003', 'CARGO NR232', NULL, NULL, '100%COTTON TWILL AOP', '120', '168x70', NULL, 'LC', NULL, '2024', 'LADIES LONG PANT', '{\"pantone\":\"234-424 TCS\"}', '{\"consignee\":null,\"contact_date\":\"2024-07-25\",\"expire_date\":\"2024-08-31\",\"negotiation\":null,\"loading\":null,\"discharge\":null,\"payment_terms\":\"LC 120 DAYS\",\"remarks\":null}', 110000, 2, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(4, 6, 8, 15, 1, '0000004', 'yhg', NULL, NULL, 'oioio', '78', '168', NULL, NULL, NULL, NULL, 'hjiojo', '{\"pantone\":null}', '{\"consignee\":null,\"contact_date\":\"2024-07-25\",\"expire_date\":\"2024-07-25\",\"negotiation\":null,\"loading\":null,\"discharge\":null,\"payment_terms\":null,\"remarks\":null}', 6000, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(5, 5, 2, 7, 1, '0000005', 'POLO 5000 PCS', NULL, NULL, 'fsfsdfsfs', 'fsf', 'fefef', 'FOB', 'CASH', '2023', 'fall', 'dsfsf', '{\"pantone\":\"fefe\"}', '{\"consignee\":\"fefe\",\"contact_date\":\"2024-07-27\",\"expire_date\":\"2024-07-27\",\"negotiation\":\"40\",\"loading\":\"BD\",\"discharge\":\"NY\",\"payment_terms\":\"LC\",\"remarks\":null}', 1320000, 2, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(6, 5, 4, 15, NULL, '0000006', 'surat', NULL, NULL, 'fabric, cotton', '90', '3', NULL, NULL, NULL, NULL, 'textle check', '{\"pantone\":null}', '{\"consignee\":null,\"contact_date\":\"2024-08-12\",\"expire_date\":\"2024-08-12\",\"negotiation\":null,\"loading\":null,\"discharge\":null,\"payment_terms\":null,\"remarks\":null}', 240000, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(7, 1, 2, 15, NULL, '0000007', 'Polo', NULL, NULL, 'Single Jersey', '160', NULL, 'Ship', 'Cash', '2024', 'Summer', 'Polo', '{\"pantone\":null}', '{\"consignee\":null,\"contact_date\":\"2024-08-12\",\"expire_date\":\"2024-08-15\",\"negotiation\":null,\"loading\":\"Dhaka\",\"discharge\":\"Dhaka\",\"payment_terms\":\"Cash\",\"remarks\":null}', 650000, 2, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(8, 6, 1, 15, NULL, '0000008', 'rr', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '{\"pantone\":null}', '{\"consignee\":null,\"contact_date\":\"2024-08-15\",\"expire_date\":\"2024-08-15\",\"negotiation\":null,\"loading\":null,\"discharge\":null,\"payment_terms\":null,\"remarks\":null}', 1800, 2, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(9, 7, 8, 15, NULL, 'Aut reprehenderit ve', 'Beatae eos dolor sus', 'uploads/24/08/1724322755.jpg', NULL, 'Qui commodo et lorem', 'Aliquip saepe cupida', 'Consequatur rerum h', 'Et sit vel dicta nu', 'Rerum enim voluptate', '1990', 'Aliquip dolorem veni', 'Consectetur nihil m', '{\"pantone\":\"Qui laudantium labo\"}', '{\"consignee\":\"Nostrum quam modi qu\",\"contact_date\":\"1977-10-22\",\"expire_date\":\"1989-01-30\",\"negotiation\":\"At sequi aliqua Omn\",\"loading\":\"Qui ipsa commodo al\",\"discharge\":\"Odio dolores ipsam v\",\"payment_terms\":\"Dolore eiusmod nulla\",\"remarks\":\"Nostrum aut reiciend\"}', 2298, 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(10, 7, 1, 15, 1, '0000010', 'ORDER', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'asdas', '{\"pantone\":null}', '{\"consignee\":null,\"contact_date\":\"2024-08-22\",\"expire_date\":\"2024-08-22\",\"negotiation\":null,\"loading\":null,\"discharge\":null,\"payment_terms\":null,\"remarks\":null}', 200, 2, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(11, 7, 1, 15, 1, '0000011', 'bb', NULL, NULL, 'bb', '12', '12', NULL, 'bank', NULL, NULL, 'aa', '{\"pantone\":null}', '{\"consignee\":null,\"contact_date\":\"2024-08-22\",\"expire_date\":\"2024-08-22\",\"negotiation\":null,\"loading\":\"12\",\"discharge\":\"12\",\"payment_terms\":\"bank\",\"remarks\":null}', 10000, 2, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

--
-- Table structure for table `order_details`
--

CREATE TABLE `order_details` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` bigint UNSIGNED NOT NULL,
  `style` text COLLATE utf8mb4_unicode_ci,
  `color` text COLLATE utf8mb4_unicode_ci,
  `item` text COLLATE utf8mb4_unicode_ci,
  `shipment_date` text COLLATE utf8mb4_unicode_ci,
  `qty` text COLLATE utf8mb4_unicode_ci,
  `unit_price` text COLLATE utf8mb4_unicode_ci,
  `total_price` 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 `order_details`
--

INSERT INTO `order_details` (`id`, `order_id`, `style`, `color`, `item`, `shipment_date`, `qty`, `unit_price`, `total_price`, `created_at`, `updated_at`) VALUES
(1, 1, 'iii', 'null', 'ooo', '2024-07-21', '5', '12', '60', '2024-07-22 02:17:58', '2024-07-22 02:17:58'),
(2, 1, 'iiii', 'null', 'ooo', '2024-08-01', '22', '15', '330', '2024-07-22 02:17:58', '2024-07-22 02:17:58'),
(3, 2, '7100', 'black', NULL, '2024-07-22', '90', '90', '8100', '2024-07-22 02:21:38', '2024-07-22 02:21:38'),
(4, 3, 'CARGO NR232', 'TIGER PRINT', 'LADIES LONG PANT', '2024-09-20', '20000', '5.50', '110000', '2024-07-26 00:01:41', '2024-07-26 00:01:41'),
(5, 4, 'hhh', 'ty', NULL, '2024-07-25', '600', '10', '6000', '2024-07-26 00:15:04', '2024-07-26 00:15:04'),
(6, 6, 'eb001', 'red', NULL, '2024-08-12', '2000', '120', '240000', '2024-08-12 13:07:43', '2024-08-12 13:07:43'),
(7, 5, 'POLO', 'Black', 'fsfjkefef', '2024-07-27', '10000', '120', '1200000', '2024-08-14 09:15:14', '2024-08-14 09:15:14'),
(8, 5, 'jkjkj', 'white', 'null', '2024-07-26', '500', '20', '10000', '2024-08-14 09:15:14', '2024-08-14 09:15:14'),
(9, 5, 'feiewjfmlwef', 'red', 'null', '2024-07-29', '5000', '22', '110000', '2024-08-14 09:15:14', '2024-08-14 09:15:14'),
(10, 7, 'POLO', 'blue', 'T-shirt', '2024-08-12', '10000', '65', '650000', '2024-08-17 20:09:03', '2024-08-17 20:09:03'),
(11, 9, 'Quaerat aliquip fugi', 'In ex lorem dolorem', 'Sed sunt magni exer', '2000-02-15', '4', '562', '2248', '2024-08-22 17:02:35', '2024-08-22 17:02:35'),
(12, 9, 'vx sf', 'Blue', 'w ds sd', '2024-08-22', '2', '25', '50', '2024-08-22 17:02:35', '2024-08-22 17:02:35'),
(13, 8, 'teee', 'RED', NULL, '2024-08-15', '40', '45', '1800', '2024-08-22 22:03:03', '2024-08-22 22:03:03'),
(14, 10, 'STYLE 1', 'RED', 'pantalones Azul', '2024-08-22', '10', '10', '100', '2024-08-22 23:15:46', '2024-08-22 23:15:46'),
(15, 10, 'STYLE 2', 'BLUE', 'mantendra', '2024-08-22', '10', '10', '100', '2024-08-22 23:15:46', '2024-08-22 23:15:46'),
(16, 11, '12', 'blak', 't10', '2024-08-22', '10', '1000', '10000', '2024-08-23 00:25:20', '2024-08-23 00:25:20');

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

--
-- Table structure for table `parties`
--

CREATE TABLE `parties` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `creator_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `currency_id` bigint UNSIGNED DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_bill` double NOT NULL DEFAULT '0',
  `advance_amount` double NOT NULL DEFAULT '0',
  `due_amount` double NOT NULL DEFAULT '0',
  `pay_amount` double NOT NULL DEFAULT '0',
  `balance` double NOT NULL DEFAULT '0',
  `receivable_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opening_balance` double DEFAULT NULL,
  `opening_balance_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta` text COLLATE utf8mb4_unicode_ci,
  `remarks` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_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;

--
-- Dumping data for table `parties`
--

INSERT INTO `parties` (`id`, `name`, `type`, `creator_id`, `user_id`, `currency_id`, `address`, `total_bill`, `advance_amount`, `due_amount`, `pay_amount`, `balance`, `receivable_type`, `opening_balance`, `opening_balance_type`, `meta`, `remarks`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'LC Waikiki', 'buyer', 1, 11, NULL, NULL, 650000, 0, 650000, 0, 0, NULL, NULL, NULL, '{\"bank_id\":null}', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 'Line 1', 'customer', 1, 12, NULL, NULL, 0, 0, 0, 0, 0, NULL, NULL, NULL, '{\"bank_id\":null}', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, 'Line-2', 'customer', 1, 13, NULL, NULL, 8490, 0, 8490, 0, 0, NULL, NULL, NULL, '{\"bank_id\":null}', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(4, 'COATS', 'supplier', 1, 14, NULL, NULL, 55438, 0, 55438, 0, 0, NULL, NULL, NULL, '{\"bank_id\":null}', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(5, 'RGB Textiles', 'customer', 1, 17, NULL, NULL, 1320000, 4900, 1320000, 0, 4900, 'cash', 5000, 'advance_payment', '{\"bank_id\":null}', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(6, 'NR', 'buyer', 2, 18, NULL, 'afafsfs', 111800, 10000, 110000, 1800, 10000, 'bank', 10000, 'advance_payment', '{\"bank_id\":\"1\"}', 'LC Payment', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(7, '000-B2', 'buyer', 1, 19, NULL, '123456', 10200, 0, 11200, 0, 0, NULL, 1000, 'due_bill', '{\"bank_id\":null}', 'BIG PRODUCT', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

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

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

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

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

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

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

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'dashboard-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(2, 'orders-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(3, 'orders-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(4, 'orders-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(5, 'orders-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(6, 'orders-status', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(7, 'orders-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(8, 'costings-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(9, 'costings-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(10, 'costings-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(11, 'costings-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(12, 'costings-status', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(13, 'costings-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(14, 'budgets-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(15, 'budgets-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(16, 'budgets-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(17, 'budgets-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(18, 'budgets-status', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(19, 'budgets-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(20, 'samples-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(21, 'samples-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(22, 'samples-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(23, 'samples-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(24, 'samples-status', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(25, 'samples-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(26, 'bookings-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(27, 'bookings-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(28, 'bookings-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(29, 'bookings-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(30, 'bookings-status', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(31, 'bookings-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(32, 'accessories-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(33, 'accessories-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(34, 'accessories-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(35, 'accessories-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(36, 'accessories-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(37, 'accessory-orders-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(38, 'accessory-orders-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(39, 'accessory-orders-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(40, 'accessory-orders-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(41, 'accessory-orders-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(42, 'units-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(43, 'units-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(44, 'units-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(45, 'units-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(46, 'units-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(47, 'shipments-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(48, 'shipments-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(49, 'shipments-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(50, 'shipments-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(51, 'shipments-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(52, 'users-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(53, 'users-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(54, 'users-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(55, 'users-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(56, 'banks-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(57, 'banks-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(58, 'banks-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(59, 'banks-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(60, 'banks-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(61, 'cashes-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(62, 'cashes-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(63, 'cashes-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(64, 'cashes-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(65, 'cashes-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(66, 'cheques-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(67, 'cheques-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(68, 'cheques-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(69, 'cheques-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(70, 'transfers-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(71, 'transfers-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(72, 'transfers-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(73, 'transfers-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(74, 'dues-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(75, 'dues-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(76, 'dues-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(77, 'dues-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(78, 'party-ledger-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(79, 'income-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(80, 'income-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(81, 'income-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(82, 'income-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(83, 'expense-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(84, 'expense-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(85, 'expense-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(86, 'expense-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(87, 'credit-vouchers-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(88, 'credit-vouchers-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(89, 'credit-vouchers-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(90, 'credit-vouchers-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(91, 'credit-vouchers-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(92, 'debit-vouchers-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(93, 'debit-vouchers-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(94, 'debit-vouchers-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(95, 'debit-vouchers-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(96, 'debit-vouchers-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(97, 'transactions-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(98, 'transactions-list', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(99, 'loss-profit-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(100, 'designations-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(101, 'designations-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(102, 'designations-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(103, 'designations-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(104, 'employees-read', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(105, 'employees-create', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(106, 'employees-update', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(107, 'employees-delete', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(108, 'salaries-read', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(109, 'salaries-create', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(110, 'salaries-update', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(111, 'salaries-delete', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(112, 'parties-read', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(113, 'parties-create', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(114, 'parties-update', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(115, 'parties-delete', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(116, 'parties-folder', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(117, 'productions-read', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(118, 'productions-create', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(119, 'productions-update', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(120, 'productions-delete', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(121, 'productions-list', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(122, 'reports-read', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(123, 'settings-read', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(124, 'settings-update', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(125, 'currencies-read', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(126, 'currencies-create', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(127, 'currencies-update', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(128, 'currencies-delete', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(129, 'currencies-list', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(130, 'roles-read', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(131, 'roles-create', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(132, 'roles-update', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(133, 'roles-delete', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(134, 'permissions-read', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(135, 'permissions-create', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50');

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

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

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_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 `productions`
--

CREATE TABLE `productions` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `order_id` bigint UNSIGNED NOT NULL,
  `order_info` longtext COLLATE utf8mb4_unicode_ci,
  `cutting` text COLLATE utf8mb4_unicode_ci,
  `print` text COLLATE utf8mb4_unicode_ci,
  `input_line` text COLLATE utf8mb4_unicode_ci,
  `output_line` text COLLATE utf8mb4_unicode_ci,
  `finishing` text COLLATE utf8mb4_unicode_ci,
  `poly` text COLLATE utf8mb4_unicode_ci,
  `remarks` varchar(191) 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 `productions`
--

INSERT INTO `productions` (`id`, `user_id`, `order_id`, `order_info`, `cutting`, `print`, `input_line`, `output_line`, `finishing`, `poly`, `remarks`, `created_at`, `updated_at`) VALUES
(1, 1, 2, '{\"style\":[\"7100\"],\"item\":[\"null\"],\"color\":[\"black\"],\"qty\":[\"90\"]}', '{\"daily\":null,\"ttl_cutting\":null,\"balance\":null}', '{\"today_send\":null,\"ttl_send\":null,\"received\":null,\"balance\":null}', '{\"name\":null,\"daily\":null,\"total\":null,\"balance\":null}', '{\"daily\":null,\"total\":null,\"balance\":null}', '{\"daily_receive\":null,\"total\":null,\"balance\":null}', '{\"daily\":null,\"total\":null,\"balance\":null}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 2, 3, '{\"style\":[\"CARGO NR232\"],\"item\":[\"LADIES LONG PANT\"],\"color\":[\"TIGER PRINT\"],\"qty\":[\"20000\"]}', '{\"daily\":\"500\",\"ttl_cutting\":null,\"balance\":null}', '{\"today_send\":null,\"ttl_send\":null,\"balance\":null,\"received\":null}', '{\"name\":\"Line 3\",\"daily\":\"500\",\"total\":null,\"balance\":null}', '{\"daily\":null,\"total\":null,\"balance\":null}', '{\"daily_receive\":null,\"total\":null,\"balance\":null}', '{\"daily\":null,\"total\":null,\"balance\":null}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, 1, 7, '{\"style\":[\"POLO\"],\"item\":[\"null\"],\"color\":[\"null\"],\"qty\":[\"10000\"]}', '{\"daily\":\"10000\",\"ttl_cutting\":null,\"balance\":null}', '{\"today_send\":null,\"ttl_send\":null,\"balance\":null,\"received\":null}', '{\"name\":\"Line 1\",\"daily\":\"2000\",\"total\":\"10000\",\"balance\":null}', '{\"daily\":\"500\",\"total\":null,\"balance\":null}', '{\"daily_receive\":null,\"total\":null,\"balance\":null}', '{\"daily\":null,\"total\":null,\"balance\":null}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(4, 1, 7, '{\"style\":[\"POLO\"],\"item\":[\"null\"],\"color\":[\"null\"],\"qty\":[\"10000\"]}', '{\"daily\":null,\"ttl_cutting\":null,\"balance\":null}', '{\"today_send\":null,\"ttl_send\":null,\"received\":null,\"balance\":null}', '{\"name\":\"line 2\",\"daily\":null,\"total\":\"5000\",\"balance\":null}', '{\"daily\":\"1000\",\"total\":null,\"balance\":null}', '{\"daily_receive\":null,\"total\":null,\"balance\":null}', '{\"daily\":null,\"total\":null,\"balance\":null}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(5, 2, 7, '{\"style\":[\"POLO\"],\"item\":[\"null\"],\"color\":[\"null\"],\"qty\":[\"10000\"]}', '{\"daily\":\"50\",\"ttl_cutting\":null,\"balance\":null}', '{\"today_send\":null,\"ttl_send\":null,\"received\":null,\"balance\":null}', '{\"name\":null,\"daily\":null,\"total\":null,\"balance\":null}', '{\"daily\":\"50\",\"total\":null,\"balance\":null}', '{\"daily_receive\":\"50\",\"total\":null,\"balance\":null}', '{\"daily\":null,\"total\":null,\"balance\":null}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(6, 1, 11, '{\"style\":[\"12\"],\"item\":[\"t10\"],\"color\":[\"blak\"],\"qty\":[\"10\"]}', '{\"daily\":\"10\",\"ttl_cutting\":\"100\",\"balance\":null}', '{\"today_send\":null,\"ttl_send\":null,\"received\":null,\"balance\":null}', '{\"name\":null,\"daily\":null,\"total\":null,\"balance\":null}', '{\"daily\":null,\"total\":null,\"balance\":null}', '{\"daily_receive\":null,\"total\":null,\"balance\":null}', '{\"daily\":null,\"total\":null,\"balance\":null}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

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

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

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'superadmin', 'web', '2024-10-26 14:20:49', '2024-10-26 14:20:49'),
(2, 'admin', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(3, 'manager', 'web', '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(4, 'buyer', 'web', '2024-10-26 14:20:51', '2024-10-26 14:20:51'),
(5, 'customer', 'web', '2024-10-26 14:20:51', '2024-10-26 14:20:51'),
(6, 'supplier', 'web', '2024-10-26 14:20:51', '2024-10-26 14:20:51'),
(7, 'merchandiser', 'web', '2024-10-26 14:20:51', '2024-10-26 14:20:51'),
(8, 'commercial', 'web', '2024-10-26 14:20:51', '2024-10-26 14:20:51'),
(9, 'accountant', 'web', '2024-10-26 14:20:51', '2024-10-26 14:20:51'),
(10, 'production', 'web', '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

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

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint 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, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(48, 1),
(49, 1),
(50, 1),
(51, 1),
(52, 1),
(53, 1),
(54, 1),
(55, 1),
(56, 1),
(57, 1),
(58, 1),
(59, 1),
(60, 1),
(61, 1),
(62, 1),
(63, 1),
(64, 1),
(65, 1),
(66, 1),
(67, 1),
(68, 1),
(69, 1),
(70, 1),
(71, 1),
(72, 1),
(73, 1),
(74, 1),
(75, 1),
(76, 1),
(77, 1),
(78, 1),
(79, 1),
(80, 1),
(81, 1),
(82, 1),
(83, 1),
(84, 1),
(85, 1),
(86, 1),
(87, 1),
(88, 1),
(89, 1),
(90, 1),
(91, 1),
(92, 1),
(93, 1),
(94, 1),
(95, 1),
(96, 1),
(97, 1),
(98, 1),
(99, 1),
(100, 1),
(101, 1),
(102, 1),
(103, 1),
(104, 1),
(105, 1),
(106, 1),
(107, 1),
(108, 1),
(109, 1),
(110, 1),
(111, 1),
(112, 1),
(113, 1),
(114, 1),
(115, 1),
(116, 1),
(117, 1),
(118, 1),
(119, 1),
(120, 1),
(121, 1),
(122, 1),
(123, 1),
(124, 1),
(125, 1),
(126, 1),
(127, 1),
(128, 1),
(129, 1),
(130, 1),
(131, 1),
(132, 1),
(133, 1),
(134, 1),
(135, 1),
(1, 2),
(2, 2),
(3, 2),
(4, 2),
(5, 2),
(6, 2),
(7, 2),
(8, 2),
(9, 2),
(10, 2),
(11, 2),
(12, 2),
(13, 2),
(14, 2),
(15, 2),
(16, 2),
(17, 2),
(18, 2),
(19, 2),
(20, 2),
(21, 2),
(22, 2),
(23, 2),
(24, 2),
(25, 2),
(26, 2),
(27, 2),
(28, 2),
(29, 2),
(30, 2),
(31, 2),
(32, 2),
(33, 2),
(34, 2),
(35, 2),
(36, 2),
(37, 2),
(38, 2),
(39, 2),
(40, 2),
(41, 2),
(42, 2),
(43, 2),
(44, 2),
(45, 2),
(46, 2),
(47, 2),
(48, 2),
(49, 2),
(50, 2),
(51, 2),
(52, 2),
(53, 2),
(54, 2),
(55, 2),
(56, 2),
(57, 2),
(58, 2),
(59, 2),
(60, 2),
(61, 2),
(62, 2),
(63, 2),
(64, 2),
(65, 2),
(66, 2),
(67, 2),
(68, 2),
(69, 2),
(70, 2),
(71, 2),
(72, 2),
(73, 2),
(74, 2),
(75, 2),
(76, 2),
(77, 2),
(78, 2),
(79, 2),
(80, 2),
(81, 2),
(82, 2),
(83, 2),
(84, 2),
(85, 2),
(86, 2),
(87, 2),
(88, 2),
(89, 2),
(90, 2),
(91, 2),
(92, 2),
(93, 2),
(94, 2),
(95, 2),
(96, 2),
(97, 2),
(98, 2),
(99, 2),
(100, 2),
(101, 2),
(102, 2),
(103, 2),
(104, 2),
(105, 2),
(106, 2),
(107, 2),
(108, 2),
(109, 2),
(110, 2),
(111, 2),
(112, 2),
(113, 2),
(114, 2),
(115, 2),
(116, 2),
(117, 2),
(118, 2),
(119, 2),
(120, 2),
(121, 2),
(122, 2),
(130, 2),
(131, 2),
(132, 2),
(133, 2),
(134, 2),
(135, 2),
(2, 3),
(3, 3),
(4, 3),
(5, 3),
(8, 3),
(9, 3),
(10, 3),
(11, 3),
(14, 3),
(15, 3),
(16, 3),
(17, 3),
(20, 3),
(21, 3),
(22, 3),
(23, 3),
(26, 3),
(27, 3),
(28, 3),
(29, 3),
(32, 3),
(33, 3),
(34, 3),
(35, 3),
(37, 3),
(38, 3),
(39, 3),
(40, 3),
(41, 3),
(47, 3),
(48, 3),
(49, 3),
(50, 3),
(52, 3),
(53, 3),
(54, 3),
(55, 3),
(56, 3),
(57, 3),
(58, 3),
(59, 3),
(60, 3),
(61, 3),
(62, 3),
(63, 3),
(64, 3),
(66, 3),
(67, 3),
(68, 3),
(70, 3),
(72, 3),
(74, 3),
(78, 3),
(79, 3),
(80, 3),
(81, 3),
(82, 3),
(83, 3),
(84, 3),
(85, 3),
(86, 3),
(87, 3),
(88, 3),
(89, 3),
(90, 3),
(92, 3),
(93, 3),
(94, 3),
(95, 3),
(97, 3),
(112, 3),
(113, 3),
(114, 3),
(115, 3),
(123, 3),
(124, 3),
(2, 4),
(3, 4),
(4, 4),
(5, 4),
(14, 4),
(15, 4),
(16, 4),
(17, 4),
(2, 5),
(3, 5),
(4, 5),
(5, 5),
(14, 5),
(15, 5),
(16, 5),
(17, 5),
(2, 6),
(3, 6),
(4, 6),
(5, 6),
(14, 6),
(15, 6),
(16, 6),
(17, 6),
(2, 7),
(3, 7),
(4, 7),
(5, 7),
(14, 7),
(15, 7),
(16, 7),
(17, 7),
(47, 7),
(48, 7),
(49, 7),
(50, 7),
(112, 7),
(116, 7),
(2, 8),
(3, 8),
(4, 8),
(5, 8),
(14, 8),
(15, 8),
(16, 8),
(17, 8),
(56, 9),
(57, 9),
(58, 9),
(59, 9),
(60, 9),
(61, 9),
(62, 9),
(63, 9),
(64, 9),
(65, 9),
(66, 9),
(67, 9),
(68, 9),
(69, 9),
(70, 9),
(71, 9),
(72, 9),
(73, 9),
(74, 9),
(75, 9),
(76, 9),
(77, 9),
(78, 9),
(79, 9),
(80, 9),
(81, 9),
(82, 9),
(83, 9),
(84, 9),
(85, 9),
(86, 9),
(87, 9),
(88, 9),
(89, 9),
(90, 9),
(91, 9),
(92, 9),
(93, 9),
(94, 9),
(95, 9),
(96, 9),
(97, 9),
(98, 9),
(99, 9),
(112, 9),
(113, 9),
(114, 9),
(115, 9),
(116, 9),
(117, 10),
(118, 10),
(119, 10),
(120, 10),
(121, 10);

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

--
-- Table structure for table `salaries`
--

CREATE TABLE `salaries` (
  `id` bigint UNSIGNED NOT NULL,
  `voucher_id` bigint UNSIGNED NOT NULL,
  `employee_id` bigint UNSIGNED NOT NULL,
  `bank_id` bigint UNSIGNED DEFAULT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `year` int NOT NULL,
  `month` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `due_salary` double NOT NULL DEFAULT '0',
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta` longtext COLLATE utf8mb4_unicode_ci,
  `deleted_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;

--
-- Dumping data for table `salaries`
--

INSERT INTO `salaries` (`id`, `voucher_id`, `employee_id`, `bank_id`, `user_id`, `year`, `month`, `payment_method`, `amount`, `due_salary`, `notes`, `meta`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 1, NULL, 1, 2024, 'July', 'cash', 2000, 198000, NULL, '{\"cheque_no\":null,\"issue_date\":\"2024-07-23\"}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 2, 1, 1, 1, 2024, 'July', 'cash', 20000, 178000, NULL, '{\"cheque_no\":null,\"issue_date\":\"2024-07-29\"}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, 3, 1, NULL, 2, 2024, 'August', 'cash', 200000, 0, 'xyz', '{\"cheque_no\":null,\"issue_date\":\"2024-08-06\"}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(4, 4, 1, 1, 1, 2024, 'September', 'bank', 20000, 180000, NULL, '{\"cheque_no\":null,\"issue_date\":\"2024-08-24\"}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

--
-- Table structure for table `samples`
--

CREATE TABLE `samples` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `order_id` bigint UNSIGNED NOT NULL,
  `consignee` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `header` longtext COLLATE utf8mb4_unicode_ci,
  `styles` longtext COLLATE utf8mb4_unicode_ci,
  `colors` longtext COLLATE utf8mb4_unicode_ci,
  `items` longtext COLLATE utf8mb4_unicode_ci,
  `types` longtext COLLATE utf8mb4_unicode_ci,
  `sizes` longtext COLLATE utf8mb4_unicode_ci,
  `quantities` longtext COLLATE utf8mb4_unicode_ci,
  `status` tinyint NOT NULL DEFAULT '1',
  `reason` varchar(191) 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 `samples`
--

INSERT INTO `samples` (`id`, `user_id`, `order_id`, `consignee`, `header`, `styles`, `colors`, `items`, `types`, `sizes`, `quantities`, `status`, `reason`, `created_at`, `updated_at`) VALUES
(1, 3, 5, 'fefe', '{\"size_xs\":\"XS\",\"size_s\":\"S\",\"size_m\":\"M\",\"size_l\":\"L\",\"size_xl\":\"XL\",\"size_xxl\":\"XXL\",\"size_3xl\":\"3XL\",\"size_4xl\":\"4XL\"}', '[\"POLO\",\"jkjkj\",\"feiewjfmlwef\"]', '[\"Black\",\"white\",\"red\"]', '[\"fsfjkefef\",\"null\",\"null\"]', '[null,null,null]', '{\"xs\":[null,null,null],\"s\":[null,null,null],\"m\":[null,null,null],\"l\":[null,null,null],\"xl\":[null,null,null],\"xxl\":[null,null,null],\"3xl\":[null,null,null],\"4xl\":[null,null,null]}', '[\"10000\",\"500\",\"5000\"]', 1, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

--
-- Table structure for table `shipments`
--

CREATE TABLE `shipments` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `order_id` bigint UNSIGNED NOT NULL,
  `invoice_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipments`
--

INSERT INTO `shipments` (`id`, `user_id`, `order_id`, `invoice_no`, `created_at`, `updated_at`) VALUES
(1, 2, 2, 'SHIP-2024-0001', '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 1, 3, 'SHIP-2024-0002', '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, 1, 3, 'SHIP-2024-0005', '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

--
-- Table structure for table `shipment_details`
--

CREATE TABLE `shipment_details` (
  `id` bigint UNSIGNED NOT NULL,
  `shipment_id` bigint UNSIGNED NOT NULL,
  `style` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipment_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `total_cm` double(15,3) NOT NULL DEFAULT '0.000',
  `total_sale` double(15,3) NOT NULL DEFAULT '0.000',
  `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 UNSIGNED NOT NULL,
  `trx_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `voucher_id` bigint UNSIGNED DEFAULT NULL,
  `bank_from` bigint UNSIGNED DEFAULT NULL,
  `bank_to` bigint UNSIGNED DEFAULT NULL,
  `amount` double NOT NULL DEFAULT '0',
  `transfer_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adjust_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date NOT NULL DEFAULT '2024-10-26',
  `note` text COLLATE utf8mb4_unicode_ci,
  `meta` text COLLATE utf8mb4_unicode_ci,
  `deleted_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 `units`
--

CREATE TABLE `units` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) 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 `units`
--

INSERT INTO `units` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'pcs', 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, 'dzn', 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, 'kg', 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(4, 'meter', 1, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) 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 `users`
--

INSERT INTO `users` (`id`, `name`, `role`, `email`, `phone`, `country`, `image`, `password`, `email_verified_at`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'superadmin', 'superadmin@superadmin.com', '01111111', NULL, 'https://api.dicebear.com/9.x/pixel-art/svg?seed=super-admin', '$2y$10$EAWit.RjqLezO0/khx/ay.G5L.CPXtdZaB7fkBSC/abo7KclvT1aq', '2024-10-26 14:20:50', NULL, '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(2, 'Admin', 'admin', 'admin@admin.com', '01111111', NULL, 'https://api.dicebear.com/9.x/pixel-art/svg?seed=admin', '$2y$10$dx2nxVr08W8VwZtbkUZqlegfYsQisenzUa6m9VJNs7ZGRGCRs5.Ja', '2024-10-26 14:20:50', NULL, '2024-10-26 14:20:50', '2024-10-26 14:20:50'),
(3, 'Manager', 'manager', 'manager@manager.com', '01111111', NULL, 'https://api.dicebear.com/9.x/pixel-art/svg?seed=manager', '$2y$10$OVgCMM9TCYW4MWnxX1zTj.OZiCR5.Jysu/ex8kewSestbXy2LK492', '2024-10-26 14:20:51', NULL, '2024-10-26 14:20:51', '2024-10-26 14:20:51'),
(4, 'Buyer', 'buyer', 'buyer@buyer.com', '01111111', NULL, 'https://api.dicebear.com/9.x/pixel-art/svg?seed=buyer', '$2y$10$xf7bcV4r0Zdx4CwpcgQ9HOrLu6QJnYu8OZVtIdESXJh8pl8Pp2udW', '2024-10-26 14:20:51', NULL, '2024-10-26 14:20:51', '2024-10-26 14:20:51'),
(5, 'Customer', 'customer', 'customer@customer.com', '01111111', NULL, 'https://api.dicebear.com/9.x/pixel-art/svg?seed=customer', '$2y$10$CkagtejevdW9ncep5p3MW.ep4kaVvLoW9s9KC0Ol3Hh/blpuuZjhW', '2024-10-26 14:20:51', NULL, '2024-10-26 14:20:51', '2024-10-26 14:20:51'),
(6, 'Supplier', 'supplier', 'supplier@supplier.com', '01111111', NULL, 'https://api.dicebear.com/9.x/pixel-art/svg?seed=supplier', '$2y$10$kOYGZUYtCumUJomRlMKx4eG3pKsCA66WS4uqnmAdi90HgsL4nJQa.', '2024-10-26 14:20:51', NULL, '2024-10-26 14:20:51', '2024-10-26 14:20:51'),
(7, 'Merchandiser', 'merchandiser', 'merchandiser@merchandiser.com', '01111111', NULL, 'https://api.dicebear.com/9.x/pixel-art/svg?seed=merchandiser', '$2y$10$sqBpLknQ8GVsqM8Z0LupmuAdo8b0.ZiJ/GJSBx5TS1C32gW6lGm0e', '2024-10-26 14:20:51', NULL, '2024-10-26 14:20:51', '2024-10-26 14:20:51'),
(8, 'Commercial', 'commercial', 'commercial@commercial.com', '01111111', NULL, 'https://api.dicebear.com/9.x/pixel-art/svg?seed=commercial', '$2y$10$tlc7P2SoFG4mvWChsmv8n.zep9M3kf0/FNONcJI17xjwKbUUCeh3y', '2024-10-26 14:20:51', NULL, '2024-10-26 14:20:51', '2024-10-26 14:20:51'),
(9, 'Accountant', 'accountant', 'accountant@accountant.com', '01111111', NULL, 'https://api.dicebear.com/9.x/pixel-art/svg?seed=accountant', '$2y$10$XpNEJfPVq9Fsv9Bqgc/Njumc/JHJ/7a8.P0LNt2Xjddh/w.NIW/ly', '2024-10-26 14:20:52', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(10, 'Production', 'production', 'production@production.com', '01111111', NULL, 'https://api.dicebear.com/9.x/pixel-art/svg?seed=production', '$2y$10$na0GWphP5BaAweQDXLopFuBfKvm9uGXtEpBXNIwa/pE4MplUfnMK6', '2024-10-26 14:20:52', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(11, 'LC Waikiki', 'buyer', NULL, NULL, NULL, NULL, '$2y$10$Hpt10Q/EYCTW8k8EwMpKaemUBOcRe/el0cIR27Mfh.UZbP1IGFLzi', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(12, 'Line 1', 'customer', NULL, NULL, NULL, NULL, '$2y$10$rOgjLKkw3RG5kbDlBB/87OheYIEqb7lMyoZhIKFTmSdaxeYw.LLmC', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(13, 'Line-2', 'customer', NULL, NULL, NULL, NULL, '$2y$10$dGqukjKr8Sk4yK1XvArV6OQJUxz4Pa9CnZMCsTvCDDtaPhhoqk60m', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(14, 'COATS', 'supplier', NULL, NULL, NULL, NULL, '$2y$10$Cpu3HF./2KeEwsRIdEATi.XCItIY8Bb7T1ZjvLlR5mNd7FRauu3BS', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(15, 'Marlon Marlon Morales', 'merchandiser', 'tuendystore@gmail.com', '04141930904', NULL, NULL, '$2y$10$cuLnh/sZxLFqmiOqjxtMReiF2w02DTvXZ5ArDsMoxSu9bXNEI62tC', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(16, 'joanklin', 'commercial', 'marlonmorales@gmail.com', '04141930904', NULL, NULL, '$2y$10$O7RncaTWkD/oxY5O9.3xIuMFVRsuu6F6hzkwffTXYQVhSNDta7wwK', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(17, 'RGB Textiles', 'customer', 'ehtisamzia1@hotmail.com', NULL, 'United Arab Emirates', NULL, '$2y$10$ak5w8b23F/mnWzi7Lvor5e14ypUWjh3a/wilsYofCSiY5LCAdDep6', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(18, 'NR', 'buyer', 'nr@style.com', '4234242342', 'United States', NULL, '$2y$10$LWTlvvYDQhxhn3pwtN/0z.MZ6IIXuy9XlnfqdNBMvz.oDG/CqZeKq', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(19, '000-B2', 'buyer', 'abubokkar728@gmail.com', '01752220026', 'Colombia', NULL, '$2y$10$P/4/Gv12Z8m8/3l18A8rA.hJwcq3XdEL1CmBIqMoNkQMqPSvjDF2q', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(20, 'uday reddy', 'merchandiser', 'merchandiser@gmail.com', NULL, NULL, NULL, '$2y$10$n0d7onT0p7HUKpRXrrLQXOX81CodYuU5hQ20Kuyscu8CfIZ6p9UtC', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

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

--
-- Table structure for table `vouchers`
--

CREATE TABLE `vouchers` (
  `id` bigint UNSIGNED NOT NULL,
  `bill_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `party_id` bigint UNSIGNED DEFAULT NULL,
  `bank_id` bigint UNSIGNED DEFAULT NULL,
  `expense_id` bigint UNSIGNED DEFAULT NULL,
  `income_id` bigint UNSIGNED DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date DEFAULT NULL,
  `prev_balance` double NOT NULL DEFAULT '0',
  `current_balance` double NOT NULL DEFAULT '0',
  `payment_method` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voucher_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `bill_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_amount` double NOT NULL DEFAULT '0',
  `amount` double NOT NULL,
  `is_profit` tinyint(1) NOT NULL DEFAULT '0',
  `particulars` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarks` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta` text COLLATE utf8mb4_unicode_ci,
  `deleted_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;

--
-- Dumping data for table `vouchers`
--

INSERT INTO `vouchers` (`id`, `bill_no`, `user_id`, `party_id`, `bank_id`, `expense_id`, `income_id`, `type`, `date`, `prev_balance`, `current_balance`, `payment_method`, `voucher_no`, `status`, `bill_type`, `bill_amount`, `amount`, `is_profit`, `particulars`, `remarks`, `meta`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '1', 2, 4, NULL, 2, 2, 'order_invoice', '2024-07-27', 0, 0, NULL, 'AINV-00001', 1, NULL, 2664, 2664, 0, NULL, NULL, NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(2, '3', 2, 4, NULL, 5, 3, 'order_invoice', '2024-08-11', 0, 0, NULL, 'AINV-00002', 1, NULL, 2288, 2288, 0, NULL, NULL, NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(3, '4', 1, NULL, NULL, NULL, NULL, 'credit', '2024-07-23', 0, 10000000, 'cash', NULL, 1, NULL, 0, 10000000, 0, 'different_module', NULL, NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(4, '10', 1, NULL, NULL, NULL, NULL, 'employee_salary', '2024-07-23', 10000000, 9998000, 'cash', NULL, 1, 'employee_salary', 200000, 2000, 0, 'different_module', NULL, '{\"cheque_no\":null,\"issue_date\":\"2024-07-23\"}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(5, '11', 1, 5, NULL, NULL, NULL, 'credit', '2024-07-24', 9998000, 10003000, 'cash', NULL, 1, 'advance_payment', 0, 5000, 0, NULL, NULL, NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(6, '12', 2, 6, 1, NULL, NULL, 'credit', '2024-07-25', 10013000, 10023000, 'bank', NULL, 1, 'advance_payment', 0, 10000, 0, NULL, 'LC Payment', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(7, '13', 1, 4, NULL, 6, 4, 'order_invoice', '2024-08-12', 0, 0, NULL, 'AINV-00003', 1, NULL, 176, 176, 0, NULL, 'LC Payment', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(8, '14', 1, 5, NULL, 7, 5, 'order_invoice', '2024-08-14', 0, 0, NULL, '0000005', 1, NULL, 0, 1320000, 0, NULL, NULL, NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(9, '15', 1, NULL, 1, NULL, NULL, 'employee_salary', '2024-07-29', 10023000, 10003000, 'cash', NULL, 1, 'employee_salary', 200000, 20000, 0, 'different_module', NULL, '{\"cheque_no\":null,\"issue_date\":\"2024-07-29\"}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(10, '16', 9, NULL, 1, NULL, 1, 'credit', '2024-08-03', 10003000, 10023000, 'bank', NULL, 1, NULL, 0, 20000, 0, NULL, NULL, '{\"cheque_no\":null,\"issue_date\":\"2024-08-03\",\"due_amount\":0}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(11, '17', 9, NULL, NULL, 4, NULL, 'debit', '2024-08-03', 10023000, 10021000, 'cash', NULL, 1, NULL, 0, 2000, 0, 'Particulars', 'Remarks', '{\"cheque_no\":null,\"issue_date\":\"2024-08-03\"}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(12, '18', 2, NULL, NULL, NULL, NULL, 'employee_salary', '2024-08-19', 10021000, 9821000, 'cash', NULL, 1, 'employee_salary', 200000, 200000, 0, 'different_module', 'xyz', '{\"cheque_no\":null,\"issue_date\":\"2024-08-06\"}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(13, '19', 2, 1, NULL, 8, 6, 'order_invoice', '2024-08-17', 0, 0, NULL, '0000007', 1, NULL, 0, 650000, 0, NULL, NULL, NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(14, '20', 1, 6, NULL, NULL, 7, 'order_invoice', '2024-08-22', 0, 0, NULL, '0000008', 1, NULL, 0, 1800, 0, NULL, 'LC Payment', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(15, '21', 3, 6, NULL, NULL, 7, 'credit', '2024-08-15', 9821000, 9822800, 'cash', NULL, 1, 'due_bill', 0, 1800, 1, NULL, 'jhg', '{\"cheque_no\":null,\"issue_date\":\"2024-08-15\",\"due_amount\":110000}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(16, '22', 9, 5, NULL, NULL, NULL, 'debit', '2024-08-19', 9822800, 9822700, 'cash', '1', 1, 'balance_withdraw', 0, 100, 0, 'Ab', 'Ab', '{\"cheque_no\":null,\"issue_date\":\"2024-08-19\"}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(17, '23', 1, 7, NULL, NULL, 8, 'order_invoice', '2024-08-22', 0, 0, NULL, '0000010', 1, NULL, 1000, 200, 0, NULL, 'BIG PRODUCT', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(18, '24', 1, 7, NULL, NULL, 9, 'order_invoice', '2024-08-22', 0, 0, NULL, '0000011', 1, NULL, 1000, 10000, 0, NULL, 'BIG PRODUCT', NULL, NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52'),
(19, '25', 1, NULL, 1, NULL, NULL, 'employee_salary', '2024-08-24', 9822700, 9802700, 'bank', NULL, 1, 'employee_salary', 200000, 20000, 0, 'different_module', NULL, '{\"cheque_no\":null,\"issue_date\":\"2024-08-24\"}', NULL, '2024-10-26 14:20:52', '2024-10-26 14:20:52');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accessories`
--
ALTER TABLE `accessories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `accessories_name_unique` (`name`),
  ADD KEY `accessories_user_id_foreign` (`user_id`),
  ADD KEY `accessories_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `accessory_orders`
--
ALTER TABLE `accessory_orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `accessory_orders_invoice_no_unique` (`invoice_no`),
  ADD KEY `accessory_orders_user_id_foreign` (`user_id`),
  ADD KEY `accessory_orders_accessory_id_foreign` (`accessory_id`),
  ADD KEY `accessory_orders_party_id_foreign` (`party_id`);

--
-- Indexes for table `banks`
--
ALTER TABLE `banks`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `banks_account_number_unique` (`account_number`),
  ADD KEY `banks_user_id_foreign` (`user_id`);

--
-- Indexes for table `bookingdetails`
--
ALTER TABLE `bookingdetails`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bookingdetails_booking_id_foreign` (`booking_id`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `bookings_order_id_unique` (`order_id`),
  ADD KEY `bookings_user_id_foreign` (`user_id`);

--
-- Indexes for table `cashes`
--
ALTER TABLE `cashes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cashes_user_id_foreign` (`user_id`),
  ADD KEY `cashes_voucher_id_foreign` (`voucher_id`);

--
-- Indexes for table `cheques`
--
ALTER TABLE `cheques`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cheques_user_id_foreign` (`user_id`),
  ADD KEY `cheques_voucher_id_foreign` (`voucher_id`),
  ADD KEY `cheques_party_id_foreign` (`party_id`),
  ADD KEY `cheques_bank_id_foreign` (`bank_id`);

--
-- Indexes for table `costbudgets`
--
ALTER TABLE `costbudgets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `costbudgets_user_id_foreign` (`user_id`),
  ADD KEY `costbudgets_order_id_foreign` (`order_id`);

--
-- Indexes for table `costings`
--
ALTER TABLE `costings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `costings_user_id_foreign` (`user_id`),
  ADD KEY `costings_order_id_foreign` (`order_id`);

--
-- Indexes for table `currencies`
--
ALTER TABLE `currencies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `currencies_name_unique` (`name`),
  ADD UNIQUE KEY `currencies_code_unique` (`code`);

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

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

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `expenses_party_id_foreign` (`party_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 `files`
--
ALTER TABLE `files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `files_party_id_foreign` (`party_id`),
  ADD KEY `files_folder_id_foreign` (`folder_id`);

--
-- Indexes for table `folders`
--
ALTER TABLE `folders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `folders_party_id_foreign` (`party_id`),
  ADD KEY `folders_parent_id_foreign` (`parent_id`);

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

--
-- Indexes for table `incomes`
--
ALTER TABLE `incomes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `incomes_category_name_unique` (`category_name`),
  ADD KEY `incomes_party_id_foreign` (`party_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  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 `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `orders_order_no_unique` (`order_no`),
  ADD KEY `orders_party_id_foreign` (`party_id`),
  ADD KEY `orders_user_id_foreign` (`user_id`),
  ADD KEY `orders_merchandiser_id_foreign` (`merchandiser_id`),
  ADD KEY `orders_bank_id_foreign` (`bank_id`);

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

--
-- Indexes for table `parties`
--
ALTER TABLE `parties`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parties_creator_id_foreign` (`creator_id`),
  ADD KEY `parties_user_id_foreign` (`user_id`),
  ADD KEY `parties_currency_id_foreign` (`currency_id`);

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

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- 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 `productions`
--
ALTER TABLE `productions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `productions_user_id_foreign` (`user_id`),
  ADD KEY `productions_order_id_foreign` (`order_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- 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 `salaries`
--
ALTER TABLE `salaries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salaries_voucher_id_foreign` (`voucher_id`),
  ADD KEY `salaries_employee_id_foreign` (`employee_id`),
  ADD KEY `salaries_bank_id_foreign` (`bank_id`),
  ADD KEY `salaries_user_id_foreign` (`user_id`);

--
-- Indexes for table `samples`
--
ALTER TABLE `samples`
  ADD PRIMARY KEY (`id`),
  ADD KEY `samples_user_id_foreign` (`user_id`),
  ADD KEY `samples_order_id_foreign` (`order_id`);

--
-- Indexes for table `shipments`
--
ALTER TABLE `shipments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `shipments_invoice_no_unique` (`invoice_no`),
  ADD KEY `shipments_user_id_foreign` (`user_id`),
  ADD KEY `shipments_order_id_foreign` (`order_id`);

--
-- Indexes for table `shipment_details`
--
ALTER TABLE `shipment_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shipment_details_shipment_id_foreign` (`shipment_id`);

--
-- Indexes for table `transfers`
--
ALTER TABLE `transfers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transfers_trx_id_unique` (`trx_id`),
  ADD KEY `transfers_user_id_foreign` (`user_id`),
  ADD KEY `transfers_voucher_id_foreign` (`voucher_id`),
  ADD KEY `transfers_bank_from_foreign` (`bank_from`),
  ADD KEY `transfers_bank_to_foreign` (`bank_to`);

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

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

--
-- Indexes for table `vouchers`
--
ALTER TABLE `vouchers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vouchers_user_id_foreign` (`user_id`),
  ADD KEY `vouchers_party_id_foreign` (`party_id`),
  ADD KEY `vouchers_bank_id_foreign` (`bank_id`),
  ADD KEY `vouchers_expense_id_foreign` (`expense_id`),
  ADD KEY `vouchers_income_id_foreign` (`income_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `accessories`
--
ALTER TABLE `accessories`
  ADD CONSTRAINT `accessories_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `accessories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `accessory_orders`
--
ALTER TABLE `accessory_orders`
  ADD CONSTRAINT `accessory_orders_accessory_id_foreign` FOREIGN KEY (`accessory_id`) REFERENCES `accessories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `accessory_orders_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `parties` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `accessory_orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `banks`
--
ALTER TABLE `banks`
  ADD CONSTRAINT `banks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `bookingdetails`
--
ALTER TABLE `bookingdetails`
  ADD CONSTRAINT `bookingdetails_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `bookings`
--
ALTER TABLE `bookings`
  ADD CONSTRAINT `bookings_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bookings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cashes`
--
ALTER TABLE `cashes`
  ADD CONSTRAINT `cashes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cashes_voucher_id_foreign` FOREIGN KEY (`voucher_id`) REFERENCES `vouchers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cheques`
--
ALTER TABLE `cheques`
  ADD CONSTRAINT `cheques_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cheques_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `parties` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cheques_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cheques_voucher_id_foreign` FOREIGN KEY (`voucher_id`) REFERENCES `vouchers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `costbudgets`
--
ALTER TABLE `costbudgets`
  ADD CONSTRAINT `costbudgets_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `costbudgets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `costings`
--
ALTER TABLE `costings`
  ADD CONSTRAINT `costings_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `costings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `employees`
--
ALTER TABLE `employees`
  ADD CONSTRAINT `employees_designation_id_foreign` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `expenses`
--
ALTER TABLE `expenses`
  ADD CONSTRAINT `expenses_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `parties` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `files`
--
ALTER TABLE `files`
  ADD CONSTRAINT `files_folder_id_foreign` FOREIGN KEY (`folder_id`) REFERENCES `folders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `files_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `parties` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `folders`
--
ALTER TABLE `folders`
  ADD CONSTRAINT `folders_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `folders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `folders_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `parties` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `incomes`
--
ALTER TABLE `incomes`
  ADD CONSTRAINT `incomes_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `parties` (`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 `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `orders_merchandiser_id_foreign` FOREIGN KEY (`merchandiser_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `orders_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `parties` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `parties`
--
ALTER TABLE `parties`
  ADD CONSTRAINT `parties_creator_id_foreign` FOREIGN KEY (`creator_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `parties_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `parties_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `productions`
--
ALTER TABLE `productions`
  ADD CONSTRAINT `productions_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `productions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`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 `salaries`
--
ALTER TABLE `salaries`
  ADD CONSTRAINT `salaries_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `salaries_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `salaries_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `salaries_voucher_id_foreign` FOREIGN KEY (`voucher_id`) REFERENCES `vouchers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `samples`
--
ALTER TABLE `samples`
  ADD CONSTRAINT `samples_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `samples_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `shipments`
--
ALTER TABLE `shipments`
  ADD CONSTRAINT `shipments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `shipments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `shipment_details`
--
ALTER TABLE `shipment_details`
  ADD CONSTRAINT `shipment_details_shipment_id_foreign` FOREIGN KEY (`shipment_id`) REFERENCES `shipments` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transfers`
--
ALTER TABLE `transfers`
  ADD CONSTRAINT `transfers_bank_from_foreign` FOREIGN KEY (`bank_from`) REFERENCES `banks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transfers_bank_to_foreign` FOREIGN KEY (`bank_to`) REFERENCES `banks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transfers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transfers_voucher_id_foreign` FOREIGN KEY (`voucher_id`) REFERENCES `vouchers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `vouchers`
--
ALTER TABLE `vouchers`
  ADD CONSTRAINT `vouchers_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `vouchers_expense_id_foreign` FOREIGN KEY (`expense_id`) REFERENCES `expenses` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `vouchers_income_id_foreign` FOREIGN KEY (`income_id`) REFERENCES `incomes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `vouchers_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `parties` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `vouchers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
