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

START TRANSACTION;



--
-- Database: `nahar-fabric-backend`
--

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

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

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

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

INSERT INTO `categories` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(6, 'Polyester viscose yarn', 'Active', '2023-06-13 10:59:31', '2023-06-13 10:59:31'),
(11, 'Pv', 'Active', '2024-08-13 17:52:44', '2024-08-21 19:51:41');

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

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

CREATE TABLE `customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `gst` varchar(191) DEFAULT NULL,
  `short_form` varchar(191) DEFAULT NULL,
  `contact_person_number` varchar(191) DEFAULT NULL,
  `bank_name` varchar(191) DEFAULT NULL,
  `ifsc` varchar(191) DEFAULT NULL,
  `ac_no` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `customers` (`id`, `name`, `address`, `gst`, `short_form`, `contact_person_number`, `bank_name`, `ifsc`, `ac_no`, `status`, `created_at`, `updated_at`) VALUES
(3, 'Texwin Clothing Pvt Ltd', 'no 111 pallidora Road Dehiwala srilanka 400060', 'NA', 'NA', 'NA', 'n/a', 'n/a', 'n/a', 'Active', '2023-06-13 10:53:34', '2024-08-26 18:25:57'),
(7, 'YALE DE MEXICO S.A.P.I. DE C.V.', 'JAVIER ROJO GOMEZ # 1330 COL. BARRIO SAN MIGUEL', NULL, 'YALE', 'ANA LUCINA', NULL, NULL, NULL, 'Active', '2024-05-25 12:48:16', '2024-05-25 12:48:16');

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

--
-- Table structure for table `designs`
--

CREATE TABLE `designs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `design_master_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `remarks` varchar(191) DEFAULT NULL,
  `expected_date` varchar(191) DEFAULT NULL,
  `expected_output` varchar(191) DEFAULT NULL,
  `shade` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `wastage_mtr` varchar(100) DEFAULT NULL,
  `wastage_percent` varchar(100) DEFAULT NULL,
  `expected_output_mtr` varchar(100) DEFAULT NULL,
  `expected_output_kgs` varchar(100) DEFAULT NULL,
  `actual_output_mtr` varchar(100) DEFAULT NULL,
  `actual_output_kgs` varchar(100) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `products` mediumtext DEFAULT NULL,
  `supplier_id` int(10) DEFAULT NULL,
  `production_no` varchar(100) DEFAULT NULL,
  `shrinkage` varchar(200) DEFAULT NULL,
  `wastage_percentage` varchar(20) DEFAULT NULL,
  `value_loss` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `designs`
--

INSERT INTO `designs` (`id`, `design_master_id`, `order_id`, `remarks`, `expected_date`, `expected_output`, `shade`, `created_at`, `updated_at`, `wastage_mtr`, `wastage_percent`, `expected_output_mtr`, `expected_output_kgs`, `actual_output_mtr`, `actual_output_kgs`, `status`, `products`, `supplier_id`, `production_no`, `shrinkage`, `wastage_percentage`, `value_loss`) VALUES
(49, 9, 39, 'NA', '2024-08-27', NULL, NULL, '2024-08-27 16:53:25', '2024-08-27 16:53:25', NULL, NULL, '500', '50', NULL, NULL, NULL, '[{\"id\":8,\"design_master_id\":9,\"product_id\":8,\"quantity\":-15}]', NULL, 'PROD00001', '100', '10', '1000');

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

--
-- Table structure for table `design_masters`
--

CREATE TABLE `design_masters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blend` varchar(191) DEFAULT NULL,
  `read` varchar(191) DEFAULT NULL,
  `pick` varchar(191) DEFAULT NULL,
  `glm` varchar(191) DEFAULT NULL,
  `read_space` varchar(191) DEFAULT NULL,
  `design_number` varchar(191) DEFAULT NULL,
  `weave` varchar(191) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `warp_pattern` text DEFAULT NULL,
  `weft_pattern` text DEFAULT NULL,
  `is_warp` tinyint(1) DEFAULT 0,
  `is_waf` tinyint(1) NOT NULL DEFAULT 0,
  `warp_pattern_file` varchar(100) DEFAULT NULL,
  `weft_pattern_file` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `supplier_id` int(10) DEFAULT NULL,
  `production_no` varchar(100) DEFAULT NULL,
  `finish_width` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `design_masters`
--

INSERT INTO `design_masters` (`id`, `blend`, `read`, `pick`, `glm`, `read_space`, `design_number`, `weave`, `remarks`, `warp_pattern`, `weft_pattern`, `is_warp`, `is_waf`, `warp_pattern_file`, `weft_pattern_file`, `created_at`, `updated_at`, `supplier_id`, `production_no`, `finish_width`) VALUES
(9, '70/30 PV', '52', '48', '360', '66', '9544 (without lycra)', 'twill', 'Color black', NULL, NULL, 0, 0, NULL, NULL, NULL, '2023-06-15 11:29:17', 5, NULL, ''),
(10, '70/30 blend', '60', '68', '290', '79', '9544/2', 'twill', 'color naavy', 'null', 'null', 0, 0, '1724656712_ud_it_logo.jpg', '1724656712_user_image1.jpg', '2023-07-18 10:47:47', '2024-08-26 18:11:12', NULL, NULL, 'null');

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

--
-- Table structure for table `design_master_details`
--

CREATE TABLE `design_master_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `design_master_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `quantity` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_warp` tinyint(1) NOT NULL DEFAULT 0,
  `remark` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `design_master_details`
--

INSERT INTO `design_master_details` (`id`, `design_master_id`, `product_id`, `quantity`, `created_at`, `updated_at`, `is_warp`, `remark`) VALUES
(8, 9, 8, '1000', '2023-06-17 13:29:11', '2023-07-19 08:40:53', 1, NULL),
(9, 10, 8, '1', '2023-07-18 10:47:47', '2023-07-18 10:50:28', 1, NULL),
(10, 10, 9, '1', '2023-07-18 10:50:28', '2023-07-18 10:50:28', 0, NULL),
(29, 10, 8, '1', '2024-08-26 18:11:12', '2024-08-26 18:11:12', 1, 'null'),
(30, 10, 8, '1', '2024-08-26 18:11:28', '2024-08-26 18:11:29', 1, 'null'),
(31, 10, 9, '1', '2024-08-26 18:11:29', '2024-08-26 18:11:29', 0, 'null'),
(32, 10, 8, '1', '2024-08-26 18:11:56', '2024-08-26 18:11:56', 1, 'null');

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

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

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

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

--
-- Table structure for table `inventories`
--

CREATE TABLE `inventories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `qty` varchar(191) DEFAULT NULL,
  `lot_no` varchar(191) DEFAULT NULL,
  `inward_date_auto` varchar(191) DEFAULT NULL,
  `remarks` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_05_05_105137_create_payments_table', 2),
(6, '2023_05_05_113506_create_suppliers_table', 2),
(7, '2023_05_08_135327_create_categories_table', 2),
(8, '2023_05_08_135335_create_products_table', 2),
(9, '2023_05_08_135404_create_customers_table', 2),
(10, '2023_05_08_135723_create_orders_table', 2),
(11, '2023_05_08_135731_create_order_details_table', 2),
(12, '2023_05_08_140542_create_processing_houses_table', 2),
(13, '2023_05_08_140618_create_purchase_orders_table', 2),
(14, '2023_05_08_140855_create_purchase_order_details_table', 2),
(15, '2023_05_08_141207_create_design_masters_table', 3),
(16, '2023_05_09_133836_create_design_master_details_table', 3),
(17, '2023_05_09_134102_create_designs_table', 3),
(18, '2023_05_09_134245_create_yarn_issues_table', 3),
(19, '2023_05_09_134427_create_yarn_issue_details_table', 3),
(20, '2023_05_09_134727_create_rolls_table', 3);

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

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

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` varchar(191) DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_id` bigint(20) UNSIGNED DEFAULT NULL,
  `commission` varchar(191) DEFAULT NULL,
  `shipment_date` varchar(191) DEFAULT NULL,
  `transport_mode` varchar(191) DEFAULT NULL,
  `loading_port` varchar(191) DEFAULT NULL,
  `discharge_port` varchar(191) DEFAULT NULL,
  `payment_mode` varchar(191) DEFAULT NULL,
  `total` varchar(191) DEFAULT NULL,
  `signed_stamp` varchar(191) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `terms` text DEFAULT NULL,
  `is_approved` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `agent_name` varchar(191) DEFAULT NULL,
  `total_mtr` varchar(100) DEFAULT NULL,
  `shipping_address` varchar(100) DEFAULT NULL,
  `is_use_status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `order_id`, `customer_id`, `user_id`, `payment_id`, `commission`, `shipment_date`, `transport_mode`, `loading_port`, `discharge_port`, `payment_mode`, `total`, `signed_stamp`, `remarks`, `terms`, `is_approved`, `created_at`, `updated_at`, `agent_name`, `total_mtr`, `shipping_address`, `is_use_status`) VALUES
(39, 'OR_24AUG0001', 3, 2, 1, '10', '2024-08-27', 'NA', 'Mumbai', 'Pune', 'NA', '1000', NULL, 'null', 'null', 0, '2024-08-27 15:25:29', '2024-08-27 20:19:28', 'Shelke Pradip', '10', 'Mumbai', 0);

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

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

CREATE TABLE `order_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `design_master_id` bigint(20) UNSIGNED DEFAULT NULL,
  `qty` varchar(191) DEFAULT NULL,
  `rate` varchar(191) DEFAULT NULL,
  `product_total` varchar(191) DEFAULT NULL,
  `currency` varchar(100) DEFAULT NULL,
  `unit` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `shipping_address` varchar(100) DEFAULT NULL,
  `is_use` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_details`
--

INSERT INTO `order_details` (`id`, `order_id`, `design_master_id`, `qty`, `rate`, `product_total`, `currency`, `unit`, `created_at`, `updated_at`, `shipping_address`, `is_use`) VALUES
(37, 33, 9, '100', '100', '10000', 'INR', 'MTRS', '2024-03-04 11:07:34', '2024-03-04 11:07:34', NULL, 0),
(38, 34, 10, '10', '10', '100', 'INR', 'MTRS', '2024-03-23 07:36:36', '2024-03-23 07:37:17', NULL, 0),
(39, 34, 9, '20', '10', '200', 'INR', 'MTRS', '2024-03-23 07:36:36', '2024-03-23 07:37:17', NULL, 0),
(40, 35, 9, '1000', '5', '5000', 'USD', 'MTRS', '2024-08-13 17:27:21', '2024-08-13 17:27:21', NULL, 0),
(41, 36, 10, '3', '3', '9', 'USD', '', '2024-08-13 17:34:14', '2024-08-13 17:34:14', NULL, 0),
(42, 37, 9, '11111111111111', '25', '277777777777775', 'INR', 'MTRS', '2024-08-21 20:06:24', '2024-08-22 17:44:08', NULL, 0),
(43, 38, 9, '10', '400', '4000', 'INR', 'MTRS', '2024-08-22 17:50:40', '2024-08-22 17:50:40', NULL, 0),
(44, 39, 10, '10', '100', '1000', 'INR', 'MTRS', '2024-08-27 15:25:29', '2024-08-27 15:25:29', NULL, 0);

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

--
-- Table structure for table `packaging_lists`
--

CREATE TABLE `packaging_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `design_id` bigint(20) UNSIGNED DEFAULT NULL,
  `manual_no` varchar(191) DEFAULT NULL,
  `sr_no` varchar(191) DEFAULT NULL,
  `design_no` varchar(191) DEFAULT NULL,
  `design_remark` varchar(191) DEFAULT NULL,
  `mtrs_yard` varchar(191) DEFAULT NULL,
  `gross_weight` varchar(191) DEFAULT NULL,
  `net_weight` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_approved` tinyint(1) NOT NULL DEFAULT 0,
  `shade` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packaging_lists`
--

INSERT INTO `packaging_lists` (`id`, `design_id`, `manual_no`, `sr_no`, `design_no`, `design_remark`, `mtrs_yard`, `gross_weight`, `net_weight`, `created_at`, `updated_at`, `is_approved`, `shade`) VALUES
(10, 32, 'MANUAL123444', 'PI_23JUN0008', 'DESIGN123', 'NA', '1000', '100', '100', '2023-06-17 14:17:41', '2023-06-17 14:18:56', 1, NULL),
(11, 36, 'NA', 'PI_24MAR0001', '12', 'NA', '600', '100', '109', '2024-03-01 06:42:33', '2024-03-01 06:42:33', 0, NULL),
(12, 36, '1', 'PI_24MAR0011', '3', '3', '3', '3', '3', '2024-03-01 06:46:23', '2024-03-04 11:24:10', 1, NULL),
(13, 37, '0', 'PI_24MAR0012', '0', '0', '0', '0', '0', '2024-03-01 07:15:15', '2024-03-01 07:15:15', 0, NULL);

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

--
-- Table structure for table `packaging_list_orders`
--

CREATE TABLE `packaging_list_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `packaging_list_id` bigint(20) UNSIGNED DEFAULT NULL,
  `roll_id` bigint(20) UNSIGNED DEFAULT NULL,
  `qty` varchar(191) DEFAULT NULL,
  `rate` varchar(191) DEFAULT NULL,
  `product_total` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `receive_qty` varchar(100) DEFAULT NULL,
  `receive_rate` varchar(100) DEFAULT NULL,
  `diff_qty_percent` varchar(100) DEFAULT NULL,
  `diff_qty_rate` varchar(100) DEFAULT NULL,
  `shade` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packaging_list_orders`
--

INSERT INTO `packaging_list_orders` (`id`, `packaging_list_id`, `roll_id`, `qty`, `rate`, `product_total`, `created_at`, `updated_at`, `receive_qty`, `receive_rate`, `diff_qty_percent`, `diff_qty_rate`, `shade`) VALUES
(23, 10, NULL, NULL, NULL, NULL, '2023-06-17 14:17:57', '2023-06-17 14:17:57', NULL, NULL, NULL, NULL, NULL),
(24, 10, 24, NULL, NULL, NULL, '2023-06-17 14:18:38', '2023-06-17 14:18:38', NULL, NULL, NULL, NULL, NULL),
(25, 10, 23, NULL, NULL, NULL, '2023-07-21 08:09:59', '2023-07-21 08:09:59', NULL, NULL, NULL, NULL, NULL),
(26, 10, 24, NULL, NULL, NULL, '2023-07-21 08:09:59', '2023-07-21 08:09:59', NULL, NULL, NULL, NULL, NULL),
(27, 10, 25, NULL, NULL, NULL, '2023-07-21 08:09:59', '2023-07-21 08:09:59', NULL, NULL, NULL, NULL, NULL),
(29, 12, 61, NULL, NULL, NULL, '2024-03-04 11:23:53', '2024-03-04 11:23:53', NULL, NULL, NULL, NULL, NULL);

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

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

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

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

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

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ac_name` varchar(191) NOT NULL,
  `swift_code` varchar(191) DEFAULT NULL,
  `swift_code_2` varchar(191) DEFAULT NULL,
  `bank_name` varchar(191) DEFAULT NULL,
  `ac_num` varchar(191) DEFAULT NULL,
  `bank` varchar(191) DEFAULT NULL,
  `branch` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `ac_name`, `swift_code`, `swift_code_2`, `bank_name`, `ac_num`, `bank`, `branch`, `created_at`, `updated_at`) VALUES
(1, 'NAHAR ICIC', 'ICI', NULL, 'ICIC', '501002881', 'ICIC', 'Pune', NULL, '2023-09-20 20:36:26'),
(2, 'Nahar HDFc', 'HYVEDEMM300', 'as', 'HDFC', '501002881', 'HDFC', 'Shevgaon', '2023-05-12 12:58:04', '2024-08-21 19:57:57'),
(3, 'Pradip Federal', 'FED123', 'NA', 'Federal12', '0-809843095', 'Federal', 'Mumbai', '2024-03-01 05:04:16', '2024-03-01 05:07:20');

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

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

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

--
-- Dumping data for table `personal_access_tokens`
--

INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `last_used_at`, `created_at`, `updated_at`) VALUES
(1, 'App\\Models\\User', 2, 'myapptoken', 'a81e195a259254fee229f202f1870d4f64bb0cd50538eda2435400a3919e7d7e', '[\"*\"]', '2023-11-28 14:05:10', '2023-05-11 05:10:14', '2023-11-28 14:05:10'),
(2, 'App\\Models\\User', 2, 'myapptoken', '113e2b744dc6d194dae42488181acb070df874b016fe8a6a285c35a899a4ed25', '[\"*\"]', '2023-05-13 08:23:46', '2023-05-11 05:10:22', '2023-05-13 08:23:46'),
(3, 'App\\Models\\User', 2, 'myapptoken', '9e2118c64aeac9013c1da7a143523a2c46dacbd9c328d01b4ab3752d24a24e37', '[\"*\"]', '2023-07-22 07:32:11', '2023-05-11 05:42:20', '2023-07-22 07:32:11'),
(4, 'App\\Models\\User', 2, 'myapptoken', 'cc52a4ccf28dbad4a5a237f95147efb6b114d98fbb7031af6ffd6c24efc1d0cc', '[\"*\"]', '2023-07-19 08:00:28', '2023-05-11 06:05:50', '2023-07-19 08:00:28'),
(5, 'App\\Models\\User', 3, 'myapptoken', '9edb23d93d24449aa3d93265b1888a1e32ce54743143404f2afaec779ec8d9ca', '[\"*\"]', NULL, '2023-05-11 09:17:34', '2023-05-11 09:17:34'),
(6, 'App\\Models\\User', 2, 'myapptoken', '4e53a0b8e9b8df119c97ab60c6a5251690928a1372d130710a4ef1aaa77a8270', '[\"*\"]', '2023-07-21 08:25:27', '2023-05-12 07:08:27', '2023-07-21 08:25:27'),
(7, 'App\\Models\\User', 2, 'myapptoken', '6092e91c6d7b4716f4e20f1b8ae0540d231c3db793dbe5bbf93a7a629dd9c543', '[\"*\"]', '2023-05-19 12:12:05', '2023-05-13 08:24:11', '2023-05-19 12:12:05'),
(8, 'App\\Models\\User', 2, 'myapptoken', 'c2c6314252f7a69a4e9dc527c48838fee374a96885b4552dbd6fe7347ebdd4c4', '[\"*\"]', NULL, '2023-05-16 10:52:48', '2023-05-16 10:52:48'),
(9, 'App\\Models\\User', 2, 'myapptoken', 'ef34ef07b60bad23272c9f26e6f8f8ae1eaf2826c5f29a75ba7a82b6ea09ddb5', '[\"*\"]', '2023-12-11 11:17:24', '2023-05-16 10:53:26', '2023-12-11 11:17:24'),
(10, 'App\\Models\\User', 2, 'myapptoken', '5759a3bf66428ff816569ccbcea4ccb37e909104039f37e45e6cbd331c1733a3', '[\"*\"]', '2023-11-06 06:52:48', '2023-05-17 09:20:38', '2023-11-06 06:52:48'),
(11, 'App\\Models\\User', 2, 'myapptoken', 'c39e1e47c6ab4b53fff1370e8735dc6d996c5555e63dd1582fa159c18ee7f102', '[\"*\"]', '2023-05-19 11:38:31', '2023-05-19 11:37:48', '2023-05-19 11:38:31'),
(12, 'App\\Models\\User', 2, 'myapptoken', '6d2a0dced77b9932021d6159d543f7127bb552f3597e3dcb500da7ceaf8ccad1', '[\"*\"]', '2023-05-23 05:18:24', '2023-05-19 12:38:08', '2023-05-23 05:18:24'),
(13, 'App\\Models\\User', 2, 'myapptoken', '1bf7876a1592d8d9df1955f379e314328829dfbee738ffecc80c3c0f3629e869', '[\"*\"]', '2023-05-29 07:30:16', '2023-05-29 05:20:00', '2023-05-29 07:30:16'),
(14, 'App\\Models\\User', 2, 'myapptoken', 'b31c30e6261dd3ab2f84f93cb44159ba6319300c564b42d32b27cc2a8c87e836', '[\"*\"]', '2023-05-29 11:59:27', '2023-05-29 11:35:42', '2023-05-29 11:59:27'),
(15, 'App\\Models\\User', 2, 'myapptoken', '8c96423e31e073f5c154d63c3651d21bdc564e185117888470f9437d49e4db3c', '[\"*\"]', '2023-05-30 14:53:58', '2023-05-30 07:47:21', '2023-05-30 14:53:58'),
(16, 'App\\Models\\User', 2, 'myapptoken', 'cc78c9f907d8a96fb1e9e0779396f75311bfcadf07e22bc821589ec810434173', '[\"*\"]', '2023-05-31 11:25:53', '2023-05-31 06:34:40', '2023-05-31 11:25:53'),
(17, 'App\\Models\\User', 2, 'myapptoken', '7b6425c5a2a2684184d0c32b1b569bb8a8aaffdea41212e3be291fdc33624251', '[\"*\"]', NULL, '2023-05-31 11:58:17', '2023-05-31 11:58:17'),
(18, 'App\\Models\\User', 2, 'myapptoken', '8d89cf36a47d514aa654a5724f4d78e78203f7e135ffd2976d2e0ec5ca4a629e', '[\"*\"]', '2023-05-31 12:28:26', '2023-05-31 12:27:43', '2023-05-31 12:28:26'),
(19, 'App\\Models\\User', 2, 'myapptoken', 'e000ec1afb6a9f1bc4d06eeff036371fc4a5bf03d2ac2e35a7af9693cb1c5ce1', '[\"*\"]', '2023-06-02 07:28:21', '2023-06-01 11:05:17', '2023-06-02 07:28:21'),
(20, 'App\\Models\\User', 4, 'myapptoken', '4302919e2e66691e06839d0407164b5b468ef9c713d3ca8437975f8b1d19760d', '[\"*\"]', NULL, '2023-06-01 11:06:49', '2023-06-01 11:06:49'),
(21, 'App\\Models\\User', 5, 'myapptoken', 'dccbfd6c7e70ff4de8a5a69a0f9183bd0e041555a302589a53e9cb28007ff90a', '[\"*\"]', NULL, '2023-06-01 11:09:12', '2023-06-01 11:09:12'),
(22, 'App\\Models\\User', 2, 'myapptoken', '082486c920b96ec903e69e066c4bd879d4b74ec2481c3631e74dba660ea8eb1a', '[\"*\"]', '2023-06-03 09:35:51', '2023-06-01 11:29:00', '2023-06-03 09:35:51'),
(23, 'App\\Models\\User', 2, 'myapptoken', '5a67099591868927ebb875b56a40a2aa15243f1508975f802a99a9bea606edf1', '[\"*\"]', '2023-06-08 10:08:40', '2023-06-02 07:29:32', '2023-06-08 10:08:40'),
(24, 'App\\Models\\User', 2, 'myapptoken', '25ab564a3276d11d3f2c31d95ebaad80bc1a69da12a3a4fa98c9adc4d12baacd', '[\"*\"]', '2023-06-08 08:22:11', '2023-06-08 07:24:20', '2023-06-08 08:22:11'),
(25, 'App\\Models\\User', 2, 'myapptoken', '12438f3aa573eefc29573964490dda26789e22f7de575aa4b99309f7ecddbfca', '[\"*\"]', '2024-03-01 09:44:05', '2023-06-08 07:53:54', '2024-03-01 09:44:05'),
(26, 'App\\Models\\User', 2, 'myapptoken', 'f339b2536e7309d0fbdd72688fbde0bc49c3539a616a5aebfceb9fa0e4b8db92', '[\"*\"]', '2023-06-09 08:45:07', '2023-06-08 08:23:44', '2023-06-09 08:45:07'),
(27, 'App\\Models\\User', 2, 'myapptoken', '39dda79371113f55068a2608c2eb6e374d9abec604f02be5670d74b90ee5f62b', '[\"*\"]', '2023-06-10 07:34:58', '2023-06-09 08:45:41', '2023-06-10 07:34:58'),
(28, 'App\\Models\\User', 2, 'myapptoken', '5d868684831c3dd78acfcb456e86454016a606086b56bad04b09dc9c1fb02eea', '[\"*\"]', '2023-06-13 10:33:49', '2023-06-10 10:52:15', '2023-06-13 10:33:49'),
(29, 'App\\Models\\User', 2, 'myapptoken', 'b0481eaa13f7c29386f997c2f9fd84469b5cb1194c94e6370884106b81ece546', '[\"*\"]', '2023-06-12 04:51:32', '2023-06-12 04:42:17', '2023-06-12 04:51:32'),
(30, 'App\\Models\\User', 2, 'myapptoken', 'fd3b663461a9369be326576e5a7f20140ba7cecd23fd831e7bb92c0fd8fa1a81', '[\"*\"]', '2023-06-12 07:41:29', '2023-06-12 07:33:37', '2023-06-12 07:41:29'),
(31, 'App\\Models\\User', 2, 'myapptoken', 'aa444dceef67feb959de6258ffbc35e69ecc58525ad22ecfebf2430e9128a0ba', '[\"*\"]', '2023-06-17 11:16:04', '2023-06-12 11:30:24', '2023-06-17 11:16:04'),
(32, 'App\\Models\\User', 2, 'myapptoken', 'f9158156ee9992f2a097ad6604b191f8fc8b16a00a69445a93903c7e08215338', '[\"*\"]', '2023-11-25 10:49:05', '2023-06-12 11:38:27', '2023-11-25 10:49:05'),
(33, 'App\\Models\\User', 2, 'myapptoken', 'e28826a5e91f12a275ecd6e01c8911be1443acfc5398b8968827d72e554de3a7', '[\"*\"]', '2023-06-15 06:03:55', '2023-06-13 08:19:37', '2023-06-15 06:03:55'),
(34, 'App\\Models\\User', 2, 'myapptoken', '2aa0bfc398e85489000229cc9527013e2e992ad4743699cc2aae34d92463a8aa', '[\"*\"]', NULL, '2023-06-13 09:02:31', '2023-06-13 09:02:31'),
(35, 'App\\Models\\User', 2, 'myapptoken', '580364317478f5c92299a717b863b2b155ead2597c85aadaaa477bb8a086d49d', '[\"*\"]', '2023-06-15 13:46:56', '2023-06-13 11:56:01', '2023-06-15 13:46:56'),
(36, 'App\\Models\\User', 2, 'myapptoken', '237615600f66dd8341e8ca3248677fd791485dfabf89de9c958a7b9ddfd5f421', '[\"*\"]', '2023-06-17 13:38:35', '2023-06-15 13:47:59', '2023-06-17 13:38:35'),
(37, 'App\\Models\\User', 2, 'myapptoken', 'd280aa3e765f2a504b959aff3db8664ee512a81929344849167c3dd2c3b9fbd9', '[\"*\"]', NULL, '2023-06-16 06:45:28', '2023-06-16 06:45:28'),
(38, 'App\\Models\\User', 2, 'myapptoken', '0f8ac702122148527e0ebc22c515e72ef75de2bc30d06d7ee25d663668b58c2d', '[\"*\"]', '2023-06-16 06:48:38', '2023-06-16 06:45:30', '2023-06-16 06:48:38'),
(39, 'App\\Models\\User', 2, 'myapptoken', 'e0f128dbd5ba464fb6c514d6574b3aa68a90a89cd437c432e8d9425ccff62dc2', '[\"*\"]', '2023-06-16 06:52:29', '2023-06-16 06:49:15', '2023-06-16 06:52:29'),
(40, 'App\\Models\\User', 2, 'myapptoken', '054daecdc589c44a328f02dda2b7730fd11dae890959a02aa55c4e88f8e6d1f5', '[\"*\"]', '2023-06-16 07:08:40', '2023-06-16 06:52:51', '2023-06-16 07:08:40'),
(41, 'App\\Models\\User', 2, 'myapptoken', '79289b7e692842d06edcc036d4c7eae3dc687ac95e7e3dbf7a9467d1c9e7f0b5', '[\"*\"]', '2023-06-16 07:32:42', '2023-06-16 07:28:57', '2023-06-16 07:32:42'),
(42, 'App\\Models\\User', 2, 'myapptoken', '5a11dd7485ec195efe926c7a76c10625b7cc08fe304ee70b30394e7b660bd1e4', '[\"*\"]', '2023-06-17 14:18:57', '2023-06-17 14:14:16', '2023-06-17 14:18:57'),
(43, 'App\\Models\\User', 2, 'myapptoken', '29d2bebdf3c0dabd9d64d3525d7906fc749d3c505c6b1e9552afa6ddd3fa5d28', '[\"*\"]', NULL, '2023-07-11 13:06:26', '2023-07-11 13:06:26'),
(44, 'App\\Models\\User', 2, 'myapptoken', 'f004081431d6b92459097c5c393912b04180dce2868eedaa933884504c6aa76e', '[\"*\"]', NULL, '2023-07-12 04:34:03', '2023-07-12 04:34:03'),
(45, 'App\\Models\\User', 2, 'myapptoken', '530cb8701488eb6da2bace3ee6783a61c2de62a51c20948ae0b40c4c43d093c3', '[\"*\"]', '2023-07-18 11:27:52', '2023-07-18 10:05:48', '2023-07-18 11:27:52'),
(46, 'App\\Models\\User', 2, 'myapptoken', '639bbb681aea01716214d833d9c2e3785fa4e805beb9562d63a2c45a73389ce3', '[\"*\"]', '2023-07-18 12:18:06', '2023-07-18 10:23:31', '2023-07-18 12:18:06'),
(47, 'App\\Models\\User', 2, 'myapptoken', '7637897872b8be569777ae012304e94b920f87be5ff56891d3c18d61e2e3cc1c', '[\"*\"]', '2023-07-22 08:20:34', '2023-07-19 06:21:12', '2023-07-22 08:20:34'),
(48, 'App\\Models\\User', 2, 'myapptoken', '744966ab958b40a98fd791403b7048ed866dc882596c0c6c67401609996f9882', '[\"*\"]', '2023-07-19 10:28:55', '2023-07-19 08:42:36', '2023-07-19 10:28:55'),
(49, 'App\\Models\\User', 2, 'myapptoken', 'b298eccfb35b2f1714a7d8fb89e4d3de3c0406bb558df81c72889da092d98794', '[\"*\"]', '2023-07-22 08:34:23', '2023-07-20 08:28:16', '2023-07-22 08:34:23'),
(50, 'App\\Models\\User', 2, 'myapptoken', 'd5f2fb88fa40d1f12d2689a39447205abe4ae6de8a73b3413014fddd3ac3ac2c', '[\"*\"]', '2023-07-22 06:45:17', '2023-07-21 12:04:43', '2023-07-22 06:45:17'),
(51, 'App\\Models\\User', 2, 'myapptoken', '26546b374ae54a1bd1da6608810c4f9b47ac464f30e1d2f25dfa8ada34d2f87a', '[\"*\"]', '2023-07-24 11:45:46', '2023-07-24 10:39:25', '2023-07-24 11:45:46'),
(52, 'App\\Models\\User', 2, 'myapptoken', 'e43defd759be2457a597645126afce6ff0b43d72399797179773f08186a1e40a', '[\"*\"]', '2023-07-24 11:15:58', '2023-07-24 11:04:24', '2023-07-24 11:15:58'),
(53, 'App\\Models\\User', 2, 'myapptoken', 'c8539b8ee4e76aa0dea531ccb901698d4e4af20060f80d0f1f21de9794f4be96', '[\"*\"]', '2023-07-24 11:47:57', '2023-07-24 11:47:44', '2023-07-24 11:47:57'),
(54, 'App\\Models\\User', 2, 'myapptoken', 'e1ebbe8bed0c231566429b99e177629b343ba4572859f317e75af68d1faf8eb4', '[\"*\"]', NULL, '2023-08-17 10:09:07', '2023-08-17 10:09:07'),
(55, 'App\\Models\\User', 2, 'myapptoken', 'e80a6b50ff364cf6e87db1bc89b6718fa735752f35ba51d6b2e1fe872b692c0a', '[\"*\"]', '2023-08-17 10:23:22', '2023-08-17 10:10:36', '2023-08-17 10:23:22'),
(56, 'App\\Models\\User', 2, 'myapptoken', '1012855b6232e67e5b9961c4120f2da72c49a42a0913bbb25c7cd23d2e7eaf0e', '[\"*\"]', '2023-08-17 10:47:39', '2023-08-17 10:47:39', '2023-08-17 10:47:39'),
(57, 'App\\Models\\User', 2, 'myapptoken', 'a3f4fe98a1ca0b6d2e29c7c16f2bddb08c0c7746e3e757a06a61a0a01559f65b', '[\"*\"]', '2023-08-17 10:57:13', '2023-08-17 10:47:43', '2023-08-17 10:57:13'),
(58, 'App\\Models\\User', 2, 'myapptoken', '41b0c62ac5a4e39c98dd619fefe2a1664c746bc8d1dc4918948780af2a2ce069', '[\"*\"]', '2023-08-28 10:20:34', '2023-08-28 09:55:06', '2023-08-28 10:20:34'),
(59, 'App\\Models\\User', 2, 'myapptoken', '9ddc9fccd354ed4ac23f78a4400a97c6903173af12aae4a71a13bb44067c7686', '[\"*\"]', '2023-08-30 17:02:25', '2023-08-30 09:44:19', '2023-08-30 17:02:25'),
(60, 'App\\Models\\User', 2, 'myapptoken', '07e56981ab49c4e426004d9f89ee7cb01923fde6138e497cfaa2b114fe790d7e', '[\"*\"]', '2023-09-04 02:49:59', '2023-09-04 02:49:42', '2023-09-04 02:49:59'),
(61, 'App\\Models\\User', 2, 'myapptoken', 'fdf0397c516e4b2f96512360dcb3a25e159efbf43d217b34c498275869fc4588', '[\"*\"]', '2023-09-20 20:49:05', '2023-09-20 20:35:41', '2023-09-20 20:49:05'),
(62, 'App\\Models\\User', 2, 'myapptoken', '71b6e359efb68dd8c885d4f1a8aa6e18818cc78860113b3b9b517f894d47b96a', '[\"*\"]', '2023-09-20 21:09:40', '2023-09-20 20:49:49', '2023-09-20 21:09:40'),
(63, 'App\\Models\\User', 2, 'myapptoken', '5b8606b63e935d75215bb679bf68c139a957437f68da1891878453c9161bf299', '[\"*\"]', '2023-11-11 05:03:18', '2023-11-11 05:02:55', '2023-11-11 05:03:18'),
(64, 'App\\Models\\User', 2, 'myapptoken', 'a66537996087c670831a38d68f0b11870a11ae8cabb2d6ba769917f43428f396', '[\"*\"]', '2023-11-25 11:03:28', '2023-11-25 08:29:52', '2023-11-25 11:03:28'),
(65, 'App\\Models\\User', 2, 'myapptoken', '0b8c8ec35f6051eeb1962b47ef0c47fa27c08f5e0373a3f9fd0360c3cebdcf44', '[\"*\"]', '2023-12-16 10:15:43', '2023-11-25 11:03:56', '2023-12-16 10:15:43'),
(66, 'App\\Models\\User', 2, 'myapptoken', '58e95e15b3468565e537e64054ecd9f3b2073791a07d906fd1b87eaa467d6501', '[\"*\"]', '2023-11-27 05:42:29', '2023-11-27 05:07:10', '2023-11-27 05:42:29'),
(67, 'App\\Models\\User', 6, 'myapptoken', '0c98c6b118cfa4bbfc6c36da55da78b76418550e6d20a3ec071e9fd1e7b853f0', '[\"*\"]', NULL, '2023-11-27 05:34:39', '2023-11-27 05:34:39'),
(68, 'App\\Models\\User', 7, 'myapptoken', '80a0cec075de38bef9a50aedb8b308daed7e1071d67f20e8872c3197c44253b6', '[\"*\"]', NULL, '2023-11-27 05:36:27', '2023-11-27 05:36:27'),
(69, 'App\\Models\\User', 8, 'myapptoken', '7b82edf60009b50274f5f7f1835970bb3a217de79704d125d537e945b10c460a', '[\"*\"]', NULL, '2023-11-27 05:37:41', '2023-11-27 05:37:41'),
(70, 'App\\Models\\User', 9, 'myapptoken', 'e08908ae8a2af756d202f588e40372638f9ff415b8e56ef45be06441c33d9864', '[\"*\"]', NULL, '2023-11-27 05:40:30', '2023-11-27 05:40:30'),
(71, 'App\\Models\\User', 10, 'myapptoken', 'd0cf339f0aa49dda7a2bc896d92e2d366ba95801ab7d91b9335730c01eb2a016', '[\"*\"]', NULL, '2023-11-27 05:42:28', '2023-11-27 05:42:28'),
(72, 'App\\Models\\User', 7, 'myapptoken', '910f21f0b2a996a03477de15ac63d609be43a1d3764fe21285f79272519a1daf', '[\"*\"]', '2023-11-27 06:26:36', '2023-11-27 06:09:00', '2023-11-27 06:26:36'),
(73, 'App\\Models\\User', 8, 'myapptoken', 'efedc9b485c39a394d8b80ad7f3e9c1dd818629acc9fdefc816751e0115049eb', '[\"*\"]', NULL, '2023-11-27 08:10:40', '2023-11-27 08:10:40'),
(74, 'App\\Models\\User', 8, 'myapptoken', '904088219f8f092ae2831b97af813d52dcdb16a1f14ea100d97d50bcb17498de', '[\"*\"]', '2023-11-27 08:25:22', '2023-11-27 08:12:03', '2023-11-27 08:25:22'),
(75, 'App\\Models\\User', 6, 'myapptoken', 'ccc8383bc83d0eac1fb92a10c80f498a8e7f8629e04714bb2051a346b2676ed8', '[\"*\"]', '2023-11-27 08:28:26', '2023-11-27 08:26:18', '2023-11-27 08:28:26'),
(76, 'App\\Models\\User', 6, 'myapptoken', 'eea1de14ab72e6d853659d9c01673dc99e7a1e52cb782e6aa380752973ed3270', '[\"*\"]', '2023-11-27 08:34:28', '2023-11-27 08:28:43', '2023-11-27 08:34:28'),
(77, 'App\\Models\\User', 9, 'myapptoken', '769e4defcf3a401e4d2009fd8a2f0a4576faa17ea419e9f91d47583a5bd937cb', '[\"*\"]', '2023-11-27 10:09:46', '2023-11-27 08:35:37', '2023-11-27 10:09:46'),
(78, 'App\\Models\\User', 2, 'myapptoken', 'e04f45eb8f336ca7a518eb1333afa98f9af453675a0024237485b152ebe2a459', '[\"*\"]', '2023-11-27 10:25:42', '2023-11-27 10:10:00', '2023-11-27 10:25:42'),
(79, 'App\\Models\\User', 7, 'myapptoken', 'ac4e622b4be6f95f01cc4d1e3c56708f29478c028d3e6342f557b4144ff98098', '[\"*\"]', '2023-11-27 10:39:57', '2023-11-27 10:26:22', '2023-11-27 10:39:57'),
(80, 'App\\Models\\User', 8, 'myapptoken', '0b1b3c61729ad5f3416d1ce0ecd42d8a4b50575428b1b23e2aa9daccd3647ed5', '[\"*\"]', '2023-11-27 10:55:56', '2023-11-27 10:43:43', '2023-11-27 10:55:56'),
(81, 'App\\Models\\User', 6, 'myapptoken', '266fff17b0b567874da96ab0640c93c1859892ad21708916cb2267b23ea2106d', '[\"*\"]', '2023-11-27 10:58:22', '2023-11-27 10:56:34', '2023-11-27 10:58:22'),
(82, 'App\\Models\\User', 9, 'myapptoken', 'd8d8fd2b51c6893060690d131ea0ac76806cb0ac8bcad095f015cb7cb6eb8174', '[\"*\"]', '2023-11-27 11:21:25', '2023-11-27 11:10:14', '2023-11-27 11:21:25'),
(83, 'App\\Models\\User', 10, 'myapptoken', '8a27b19466ccde0cc01157c4fac62a73fce21906b97466f55dc2701c7ea3c57f', '[\"*\"]', '2023-11-27 12:05:43', '2023-11-27 11:23:23', '2023-11-27 12:05:43'),
(84, 'App\\Models\\User', 9, 'myapptoken', 'f478eb73160a44e6f49bbc6b677423e8c0427bf654794c2695d35965057fdc25', '[\"*\"]', '2023-11-27 12:07:07', '2023-11-27 12:06:15', '2023-11-27 12:07:07'),
(85, 'App\\Models\\User', 6, 'myapptoken', 'a7e8c5872261bb5ad37032f9655db9aa1e5a03180c87d61dc4c8771d6c137eb8', '[\"*\"]', '2023-11-27 12:08:45', '2023-11-27 12:08:13', '2023-11-27 12:08:45'),
(86, 'App\\Models\\User', 8, 'myapptoken', '68fb1d5774f701a5d437845e5328f6b8a9c816ccd69dd6569eb390da3454b616', '[\"*\"]', '2023-11-27 12:11:44', '2023-11-27 12:09:18', '2023-11-27 12:11:44'),
(87, 'App\\Models\\User', 11, 'myapptoken', '24dcc90703286fb4e1693a26b357bab4a82fd0100856c7d43a2616f065628e53', '[\"*\"]', '2023-11-28 12:09:33', '2023-11-28 12:09:00', '2023-11-28 12:09:33'),
(88, 'App\\Models\\User', 2, 'myapptoken', 'd813fb17b7888f841641b20b95b81b54f404c4def6aa90c8640fbc4548f6d150', '[\"*\"]', '2023-11-28 14:03:56', '2023-11-28 14:03:46', '2023-11-28 14:03:56'),
(89, 'App\\Models\\User', 2, 'myapptoken', '63f5664a2ec5433eb2d884cc3cb068c0c3962862bb154f5208a0441211c04858', '[\"*\"]', '2023-12-08 18:56:05', '2023-12-03 06:29:46', '2023-12-08 18:56:05'),
(90, 'App\\Models\\User', 2, 'myapptoken', '4642bfca15fba19f84f4fc072a7fd1b46876825ba052f34e3996ba36c9be81d1', '[\"*\"]', '2023-12-04 10:29:10', '2023-12-04 07:53:58', '2023-12-04 10:29:10'),
(91, 'App\\Models\\User', 2, 'myapptoken', '7019a119a6321a0b27a84fc41793957115aca7d8cd119f9dcb0b7bc6401fe08c', '[\"*\"]', '2023-12-11 12:04:24', '2023-12-04 10:20:26', '2023-12-11 12:04:24'),
(92, 'App\\Models\\User', 2, 'myapptoken', '542d74fba71d5a17b8958987c3dc172d31eaa03cedf7cff69b9cb6fded74cd3b', '[\"*\"]', '2023-12-11 06:35:21', '2023-12-11 04:16:19', '2023-12-11 06:35:21'),
(93, 'App\\Models\\User', 2, 'myapptoken', '84cd179caf9eb72dd4174136cd8857026bfef7ad1e76442a24f094004fbc3c15', '[\"*\"]', '2023-12-11 11:08:09', '2023-12-11 07:34:11', '2023-12-11 11:08:09'),
(94, 'App\\Models\\User', 2, 'myapptoken', '9b96c29aa677b347c72c3c8013a9c12d7c2646bd86d5a503546274d9fc780ef0', '[\"*\"]', '2023-12-11 11:31:26', '2023-12-11 08:21:37', '2023-12-11 11:31:26'),
(95, 'App\\Models\\User', 2, 'myapptoken', 'cc87929bd2d85302dcf096f741f0d957b8ed597f1519aea826d8ce8ab143a7dd', '[\"*\"]', '2023-12-11 10:10:18', '2023-12-11 10:09:29', '2023-12-11 10:10:18'),
(96, 'App\\Models\\User', 2, 'myapptoken', '9023daa8f1d40711a5c4a197f486a69ea05165cfa9d3ba1655414bdc1f8f038b', '[\"*\"]', '2024-02-24 16:41:44', '2024-02-24 16:40:32', '2024-02-24 16:41:44'),
(97, 'App\\Models\\User', 2, 'myapptoken', '13d571f0feceff530079df9ad1579ef996ffeace0ad0619b17eacb289887aa23', '[\"*\"]', '2024-03-01 06:48:46', '2024-03-01 04:45:04', '2024-03-01 06:48:46'),
(98, 'App\\Models\\User', 12, 'myapptoken', '776affe581524c1b922881d5f474452e974a7dd5de8b97b271c374c9d6560e60', '[\"*\"]', NULL, '2024-03-01 04:48:10', '2024-03-01 04:48:10'),
(99, 'App\\Models\\User', 2, 'myapptoken', '985a60045ace8af2af35e59dd89a815389ae2ef51ed4d2dec59b318d594edb2b', '[\"*\"]', '2024-03-01 07:26:34', '2024-03-01 07:13:21', '2024-03-01 07:26:34'),
(100, 'App\\Models\\User', 2, 'myapptoken', '09c7c0256f938f9a277a9412a780c1181282b6ac57178b1961c65f655d0e17bc', '[\"*\"]', '2024-03-01 10:09:20', '2024-03-01 09:38:41', '2024-03-01 10:09:20'),
(101, 'App\\Models\\User', 2, 'myapptoken', '909d265cf011d37549e7dd23d97b1ffad7e710dfe59349f6785ca9fc32b2907f', '[\"*\"]', '2024-03-01 10:16:09', '2024-03-01 10:00:08', '2024-03-01 10:16:09'),
(102, 'App\\Models\\User', 2, 'myapptoken', 'd0a31135c093ebb92351e315be3c3db0b5870cbc6a8fbbbff588bbf114615dc1', '[\"*\"]', '2024-03-01 10:10:56', '2024-03-01 10:09:45', '2024-03-01 10:10:56'),
(103, 'App\\Models\\User', 2, 'myapptoken', 'efb2642063617844c08de42b8fec999fba755d4faba4d3ad371f3f112bb95a55', '[\"*\"]', NULL, '2024-03-01 10:14:55', '2024-03-01 10:14:55'),
(104, 'App\\Models\\User', 2, 'myapptoken', 'eb3044eb5ba0eeb64aef2e5859447909ee4d362f688b1a469ce43b53bb412de6', '[\"*\"]', NULL, '2024-03-01 10:19:00', '2024-03-01 10:19:00'),
(105, 'App\\Models\\User', 2, 'myapptoken', '65433e710e96c59577da5cf828444c201b95ffea88a8718199d84b1c734efc0b', '[\"*\"]', '2024-03-01 10:24:48', '2024-03-01 10:19:56', '2024-03-01 10:24:48'),
(106, 'App\\Models\\User', 2, 'myapptoken', 'caf34c6f313c4442625b75342df3f540360594f1e9553ae313b1a0b1a59cf7ca', '[\"*\"]', '2024-03-01 10:49:45', '2024-03-01 10:49:44', '2024-03-01 10:49:45'),
(107, 'App\\Models\\User', 2, 'myapptoken', 'b2b105fe5ab03db0a9fa65e9d0dd1099335688dcf3be1ccdba52daa2e75ee37e', '[\"*\"]', '2024-03-04 11:24:45', '2024-03-04 11:00:53', '2024-03-04 11:24:45'),
(108, 'App\\Models\\User', 2, 'myapptoken', '78fb3728753ffcfaa15c30adf01fc52721835033c8c970b713f1cabc6e970ce3', '[\"*\"]', '2024-03-23 07:24:25', '2024-03-23 07:11:24', '2024-03-23 07:24:25'),
(109, 'App\\Models\\User', 13, 'myapptoken', 'f179a88f6570c0cc08415a0a67a5016efc2e0942287246ad6552b402ed9de337', '[\"*\"]', NULL, '2024-03-23 07:24:06', '2024-03-23 07:24:06'),
(110, 'App\\Models\\User', 13, 'myapptoken', '896ce2339f3f16069aa202b33cfd94b8c48a776c55986b7e640a1a32c676fe0b', '[\"*\"]', '2024-03-23 07:24:42', '2024-03-23 07:24:42', '2024-03-23 07:24:42'),
(111, 'App\\Models\\User', 2, 'myapptoken', 'c22242505b0d753cfa297326a55bfdb90f136aa727b0c9c5b81e8a10727da8b0', '[\"*\"]', '2024-03-23 08:03:17', '2024-03-23 07:25:02', '2024-03-23 08:03:17'),
(112, 'App\\Models\\User', 2, 'myapptoken', 'e10b2d15250d6aae98032a2262f5a3092676c007587b5fab6deae4f614988496', '[\"*\"]', NULL, '2024-05-24 17:43:56', '2024-05-24 17:43:56'),
(113, 'App\\Models\\User', 2, 'myapptoken', '78ad4b0cc05265e119da05ab73ee04f215f0aaf469d5e323199edd45132ba37c', '[\"*\"]', '2024-05-24 18:01:44', '2024-05-24 17:59:27', '2024-05-24 18:01:44'),
(114, 'App\\Models\\User', 2, 'myapptoken', 'e4aa089c482fdd4cd1e64905c46a9b62b7a866f349ee0058319e393b7b0a8042', '[\"*\"]', '2024-08-13 17:53:17', '2024-05-24 19:00:17', '2024-08-13 17:53:17'),
(115, 'App\\Models\\User', 7, 'myapptoken', 'bca7c3ebb695a0995b9ad7ce5a70312525d6be0b7357f7fea580f2b076ca02b9', '[\"*\"]', '2024-05-25 13:14:20', '2024-05-25 12:43:54', '2024-05-25 13:14:20'),
(116, 'App\\Models\\User', 8, 'myapptoken', '4edbb81e06e1e17af8b2961f9f84fc9dce055533cadd19ae814d6d1c941dff49', '[\"*\"]', '2024-05-25 13:22:07', '2024-05-25 13:09:37', '2024-05-25 13:22:07'),
(117, 'App\\Models\\User', 2, 'myapptoken', '429fa22cd23d8223737c8d0b19555bbb8d7ddfeea87bfbda4d7bc5ed714d70c7', '[\"*\"]', '2024-05-30 12:04:34', '2024-05-30 11:47:17', '2024-05-30 12:04:34'),
(118, 'App\\Models\\User', 2, 'myapptoken', 'a8855b19dc62ec98eecfc11847de5b3994d7675a321207e5b97206dbc2d06357', '[\"*\"]', '2024-05-30 12:02:00', '2024-05-30 12:01:20', '2024-05-30 12:02:00'),
(119, 'App\\Models\\User', 2, 'myapptoken', 'ab1a3d076d7e115a6fdd5fe58c380029a88a6b06811df10bcb115e68166953c8', '[\"*\"]', '2024-05-30 16:49:50', '2024-05-30 16:42:44', '2024-05-30 16:49:50'),
(120, 'App\\Models\\User', 10, 'myapptoken', '137ec64506e3231a83478239b13a4ff305d73071d27870139f377a861e0d3237', '[\"*\"]', '2024-05-30 16:50:12', '2024-05-30 16:50:11', '2024-05-30 16:50:12'),
(121, 'App\\Models\\User', 2, 'myapptoken', '8ffe55353dd9922a3095222a57980473c01ee262e042a0e2d1b80140a2d8a0ec', '[\"*\"]', '2024-08-27 16:31:56', '2024-08-13 17:08:05', '2024-08-27 16:31:56'),
(122, 'App\\Models\\User', 2, 'myapptoken', '031a896685feb997ded50c7d242570f0da74e1257c6252b1ff054e495ebc2e6e', '[\"*\"]', '2024-08-13 18:06:01', '2024-08-13 17:32:26', '2024-08-13 18:06:01'),
(123, 'App\\Models\\User', 2, 'myapptoken', 'e9b82ccb465aca894ac6519547d2609d39580daa42e2c79888c9a85526b12b13', '[\"*\"]', '2024-08-21 19:22:37', '2024-08-13 17:53:49', '2024-08-21 19:22:37'),
(124, 'App\\Models\\User', 2, 'myapptoken', 'fdc7be5aa5e8b20791174d8cbe75645b246fc1338e080658bc23b6cc46e630f0', '[\"*\"]', '2024-08-26 14:40:10', '2024-08-21 19:22:48', '2024-08-26 14:40:10'),
(125, 'App\\Models\\User', 2, 'myapptoken', '050e06d8b831f8473fc9c91e8d85eae0d4b7e99ee78ddd18ce518b7093e8c833', '[\"*\"]', '2024-08-21 19:31:19', '2024-08-21 19:24:32', '2024-08-21 19:31:19'),
(126, 'App\\Models\\User', 14, 'myapptoken', '64cc6ee3225345a0c5540157ff75ff14338bc9e869c0fb9c04f52a24e3909529', '[\"*\"]', NULL, '2024-08-21 19:31:52', '2024-08-21 19:31:52'),
(127, 'App\\Models\\User', 2, 'myapptoken', '979d4ca884b2be67026cd185b52b9ed01c6b2e29c39c863f7ac7ac60129d706e', '[\"*\"]', '2024-08-22 14:06:32', '2024-08-21 19:48:04', '2024-08-22 14:06:32'),
(128, 'App\\Models\\User', 2, 'myapptoken', 'bb2cc947f16a6e0e64deecc2b8da63fd8f2f78272a09bd52a3e165eff9ce29ea', '[\"*\"]', '2024-08-22 18:13:44', '2024-08-22 17:08:11', '2024-08-22 18:13:44'),
(129, 'App\\Models\\User', 2, 'myapptoken', '3dc5c43cfd8371a7fa3954ea16dfe60c30704cf3e124012d4a2e3cbd5c07df9c', '[\"*\"]', NULL, '2024-08-23 19:59:13', '2024-08-23 19:59:13'),
(130, 'App\\Models\\User', 2, 'myapptoken', '98b9a765d42a85876b5f26789fd7bda61ed3da052b59e4de96f32df7c59a4384', '[\"*\"]', '2024-08-26 11:27:55', '2024-08-23 20:17:07', '2024-08-26 11:27:55'),
(131, 'App\\Models\\User', 2, 'myapptoken', 'e00e625780dfb38e0017d2d4a0c588fdd67fcd94ce3ef0c109102566cef84a13', '[\"*\"]', '2024-08-26 15:13:53', '2024-08-26 11:28:14', '2024-08-26 15:13:53'),
(132, 'App\\Models\\User', 2, 'myapptoken', 'fd5a7c66612a23953923ab3d403420315b9631eb32103f9c83b4fafdc3ed2199', '[\"*\"]', '2024-08-26 18:08:08', '2024-08-26 12:00:05', '2024-08-26 18:08:08'),
(133, 'App\\Models\\User', 2, 'myapptoken', '5b809a0bce069f5f70e45b9f5c73e3b6e8c48a59a9cdc1a06058c190e636c528', '[\"*\"]', '2024-08-26 18:25:32', '2024-08-26 14:37:12', '2024-08-26 18:25:32'),
(134, 'App\\Models\\User', 2, 'myapptoken', '5559e355bea7a1a21a5ea497969313c813411f65cf382840b014c4120e99f4fd', '[\"*\"]', '2024-08-26 18:28:13', '2024-08-26 16:27:26', '2024-08-26 18:28:13'),
(135, 'App\\Models\\User', 2, 'myapptoken', '0581ae1648fc32f19ded8e19cf67a3977874c9667ae29ad0c996c413a71fdebd', '[\"*\"]', '2024-08-26 17:42:19', '2024-08-26 16:48:42', '2024-08-26 17:42:19'),
(136, 'App\\Models\\User', 2, 'myapptoken', 'e129e3579ab92c6dd6131dec58f803a684f2c2cd2e0250f7d38a94e2150c0e2c', '[\"*\"]', NULL, '2024-08-26 17:06:01', '2024-08-26 17:06:01'),
(137, 'App\\Models\\User', 2, 'myapptoken', '1d1aa502b2ae7912d6a34d18aa5583395333d1c4a4fd95608062149777b90f50', '[\"*\"]', '2024-08-26 17:38:48', '2024-08-26 17:06:50', '2024-08-26 17:38:48'),
(138, 'App\\Models\\User', 15, 'myapptoken', '236cd3e1ce1e85f39af66fd5b2a871b78724786d8d85d516ea1323bd432e8374', '[\"*\"]', NULL, '2024-08-26 17:42:07', '2024-08-26 17:42:07'),
(139, 'App\\Models\\User', 15, 'myapptoken', 'a5bba74d86c68eca7d40599b1af3ab18a2a93b719f4717567ac81a6b8f87bb15', '[\"*\"]', '2024-08-26 17:42:47', '2024-08-26 17:42:46', '2024-08-26 17:42:47'),
(140, 'App\\Models\\User', 2, 'myapptoken', 'c2896cc8b171456eab2fc298447f5c504d8573c0adece355042b456bac5a3881', '[\"*\"]', '2024-08-26 18:28:35', '2024-08-26 17:43:14', '2024-08-26 18:28:35'),
(141, 'App\\Models\\User', 16, 'myapptoken', '7198bae2fbdd194418c9bf07e01965c62d5170d97d8e45f7cc33188d396ac280', '[\"*\"]', NULL, '2024-08-26 17:54:27', '2024-08-26 17:54:27'),
(142, 'App\\Models\\User', 2, 'myapptoken', '52e375652a2b1c049d282b4877b43f8f8d67e0f74818696f1d2cec590c326b28', '[\"*\"]', '2024-08-27 13:13:22', '2024-08-27 12:54:42', '2024-08-27 13:13:22'),
(143, 'App\\Models\\User', 2, 'myapptoken', '5ebad511885bc89e3bc1eefe7cd1de1a74e3317ec627b58a4bef810aff1c9810', '[\"*\"]', '2024-08-27 13:16:42', '2024-08-27 13:16:29', '2024-08-27 13:16:42'),
(144, 'App\\Models\\User', 2, 'myapptoken', 'e2db0d106ba6b069ad5a992948762a7b7cd180f13cabda825726297b7dbc076e', '[\"*\"]', '2024-08-27 14:11:35', '2024-08-27 13:33:26', '2024-08-27 14:11:35'),
(145, 'App\\Models\\User', 2, 'myapptoken', 'bd8e299100a5806ae998227c112663a93d021da68c13b9c217832c9d941bd5e8', '[\"*\"]', '2024-08-27 18:58:11', '2024-08-27 14:29:09', '2024-08-27 18:58:11'),
(146, 'App\\Models\\User', 2, 'myapptoken', 'd2658e590b3eb1b85e8caad549e9e9f263ac6db77c799f50ef2436b9d15ff467', '[\"*\"]', '2024-08-27 20:32:50', '2024-08-27 20:19:08', '2024-08-27 20:32:50');

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

--
-- Table structure for table `processing_houses`
--

CREATE TABLE `processing_houses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `gst` varchar(191) DEFAULT NULL,
  `short_form` varchar(191) DEFAULT NULL,
  `contact_person_number` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `processing_houses`
--

INSERT INTO `processing_houses` (`id`, `name`, `address`, `gst`, `short_form`, `contact_person_number`, `status`, `created_at`, `updated_at`) VALUES
(3, 'Processing UseR', 'Mumbai', 'ABC123', 'v', '9767169605', 'Active', '2023-06-01 12:49:18', '2024-08-21 19:55:20'),
(6, 'test1', 'test1', '1', '1', 'test1', 'Active', '2024-08-21 19:55:46', '2024-08-27 14:50:12');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `quantity` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `category_id`, `name`, `description`, `status`, `created_at`, `updated_at`, `quantity`) VALUES
(8, 6, '2/30 Pv black', '2/30 67/33 PV', 'Active', '2023-06-13 11:00:30', '2024-08-27 16:54:26', 60),
(9, 6, '2/30 pv lycra', 'stretch 69/29/2', 'Active', '2023-07-18 10:49:48', '2024-08-27 16:54:26', 1391);

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

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

CREATE TABLE `purchase_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `po_id` varchar(191) DEFAULT NULL,
  `supplier_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `total` varchar(191) DEFAULT NULL,
  `delivery_date` varchar(191) DEFAULT NULL,
  `is_approved` tinyint(1) NOT NULL DEFAULT 0,
  `is_inward_approved` tinyint(1) NOT NULL DEFAULT 0,
  `is_inward` tinyint(1) NOT NULL DEFAULT 0,
  `date` date DEFAULT NULL,
  `lot_no` int(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_order_details`
--

CREATE TABLE `purchase_order_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `qty` int(10) DEFAULT NULL,
  `rate` varchar(191) DEFAULT NULL,
  `product_total` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `receive_qty` varchar(100) DEFAULT NULL,
  `receive_rate` varchar(100) DEFAULT NULL,
  `diff_qty_percent` varchar(100) DEFAULT NULL,
  `diff_qty_rate` varchar(100) DEFAULT NULL,
  `category_id` int(20) DEFAULT NULL,
  `delivery_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_order_histories`
--

CREATE TABLE `purchase_order_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `purchase_order_detail_id` bigint(20) UNSIGNED DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `rate` varchar(191) DEFAULT NULL,
  `date` varchar(191) 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;

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

--
-- Table structure for table `rolls`
--

CREATE TABLE `rolls` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `design_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `processing_house_id` bigint(20) UNSIGNED DEFAULT NULL,
  `roll_no` varchar(191) DEFAULT NULL,
  `weight` varchar(191) DEFAULT NULL,
  `mtrs` varchar(191) DEFAULT NULL,
  `lum_no` varchar(191) DEFAULT NULL,
  `creation_date` varchar(191) DEFAULT NULL,
  `received_date` varchar(191) DEFAULT NULL,
  `received_mtrs` varchar(191) DEFAULT NULL,
  `shrinkage_percent` varchar(191) DEFAULT NULL,
  `lot_no` varchar(191) DEFAULT NULL,
  `cut_report_status` varchar(191) DEFAULT NULL,
  `weight_after_cut` varchar(191) DEFAULT NULL,
  `mtrs_after_cut` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `wastage_mtr` varchar(100) DEFAULT NULL,
  `wastage_percent` varchar(100) DEFAULT NULL,
  `received_kg` varchar(100) DEFAULT NULL,
  `is_ready_to_dispatch` tinyint(1) NOT NULL DEFAULT 0,
  `cut_pack_mtr` varchar(100) DEFAULT NULL,
  `cut_diff_mtr` varchar(100) DEFAULT NULL,
  `cut_pack_yarn` varchar(100) DEFAULT NULL,
  `date` varchar(100) DEFAULT NULL,
  `cut_pack_percentage` varchar(100) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `roll_new_id` varchar(50) DEFAULT NULL,
  `split_roll` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `gst` varchar(191) DEFAULT NULL,
  `short_form` varchar(191) DEFAULT NULL,
  `contact_person_number` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `ifsc` varchar(100) DEFAULT NULL,
  `ac_no` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` (`id`, `name`, `address`, `gst`, `short_form`, `contact_person_number`, `status`, `created_at`, `updated_at`, `bank_name`, `ifsc`, `ac_no`) VALUES
(10, 'Pradip', 'Mumbai', '0', 'NA', '9767169605', 'Active', '2024-08-26 18:18:17', '2024-08-26 18:25:31', 'HDFC Bank', 'IFSC1231', '5010028811'),
(11, 't', 't', 't', 't', 't', 'Active', '2024-08-26 18:27:36', '2024-08-26 18:27:36', 't', 't', 't');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `father_name` varchar(255) DEFAULT NULL,
  `surname_name` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `pincode` varchar(255) DEFAULT NULL,
  `forget_password_token` varchar(255) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `first_name`, `email`, `phone`, `role`, `father_name`, `surname_name`, `address`, `pincode`, `forget_password_token`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(2, 'admin', 'admin@admin.com', '67678', 'admin', NULL, 'admin', 'kanpur', '7872', NULL, NULL, '$2y$10$DBKzsbV68gy/wEQJcGo47O5Uux1S6x5iPRmfkNIbxQ70IFdsUsGva', NULL, '2023-04-07 09:19:14', '2023-04-07 09:19:14'),
(6, 'accounts', 'accounts@gmail.com', '987654321', 'Accounts', 'NA', 'NA', 'NA', 'NA', NULL, NULL, '$2y$10$jdV6X/17Kc1MGBFUIUxIgOaps2FE6xoAllHhRfgfrcdGXIzXnnL9q', NULL, '2023-11-27 05:34:39', '2023-11-27 05:34:39'),
(7, 'Export Department', 'exportdept@gmail.com', '9595959595', 'Export Department', 'NA', 'NA', 'NA', '414509', NULL, NULL, '$2y$10$63jhU/TTflW2Xq8BMmz0WOFmR7IsELYEgKESxKEbU3HpP5HlX8WSW', NULL, '2023-11-27 05:36:27', '2023-11-27 05:36:27'),
(8, 'Design Department', 'designdept@gmail.com', '045474154', 'Design Department', 'NA', 'NA', 'NA', 'NA', NULL, NULL, '$2y$10$Zuj9y5x0a4pxNMX2F58TYe3CnNbp2qdGwvmxOaUAwX7ZvP7JdSHke', NULL, '2023-11-27 05:37:41', '2023-11-27 05:37:41'),
(9, 'Production Department', 'productiondept@gmail.com', '534846535', 'Production Department', 'NA', 'NA', 'NA', 'NA', NULL, NULL, '$2y$10$3SHHZGcM/V2phGRfqYtDQ.EMvX6xUivkZ0xg8soD/eJB6JFyFd1iy', NULL, '2023-11-27 05:40:30', '2023-11-27 05:40:30'),
(10, 'Dispatch Department', 'dispatchdept@gmail.com', '99', 'Dispatch Department', 'NA', 'NA', 'NA', 'NA', NULL, NULL, '$2y$10$40DkhIsR9WrEj1V01g.XPOvNZ8fhEhW3bZGbBb6Ol/5Ao5VECra/q', NULL, '2023-11-27 05:42:28', '2023-11-27 05:42:28'),
(11, 'admin', 'admin2@admin.com', '1234567890', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, '$2y$10$IlFDZ2XzMaswwOHpscUHLO9B43ZeJde.X8ao0TP9zdIpF7GwNduDK', NULL, '2023-11-28 12:09:00', '2023-11-28 12:09:00'),
(15, 'Pradip', 'pradipshelke12440@gmail.com', '9767169605', 'admin', NULL, 'Shelke', NULL, NULL, NULL, NULL, '$2y$10$CNrb5z6ahuLycUAXRUdnLeqqmyis1rlsGtTFWAkMekfdcuO7Vq8Uq', NULL, '2024-08-26 17:42:07', '2024-08-26 17:42:18'),
(16, 'Pradip', 'pradipshelke124401@gmail.com', '9767169606', 'Accounts', NULL, 'Shelke', 'Pune', NULL, NULL, NULL, '$2y$10$EdlQZOrN0fI9H7DL.BZjEOBxKEpzXMsOFFh.8tII/kK1AlvKFMuXm', NULL, '2024-08-26 17:54:27', '2024-08-26 17:54:27');

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

--
-- Table structure for table `yarn_issues`
--

CREATE TABLE `yarn_issues` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `outward_date` varchar(191) DEFAULT NULL,
  `remarks` varchar(191) DEFAULT NULL,
  `process_type` varchar(191) DEFAULT NULL,
  `challan_number` varchar(191) DEFAULT NULL,
  `desgin_detail_id` int(20) DEFAULT NULL,
  `order_id` int(20) 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 `yarn_issues`
--

INSERT INTO `yarn_issues` (`id`, `outward_date`, `remarks`, `process_type`, `challan_number`, `desgin_detail_id`, `order_id`, `created_at`, `updated_at`) VALUES
(5, '2023-12-04', 'NA', 'Weft return', 'ABC@123', NULL, NULL, '2023-12-04 08:03:47', '2023-12-04 08:04:30'),
(6, '2024-03-01', 'NA', 'Warp issue', 'TEST123', NULL, NULL, '2024-03-01 06:40:48', '2024-03-01 06:40:48');

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

--
-- Table structure for table `yarn_issue_details`
--

CREATE TABLE `yarn_issue_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `design_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `yarn_issue_id` bigint(20) UNSIGNED DEFAULT NULL,
  `qty` varchar(191) DEFAULT NULL,
  `lot_no` int(20) 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 `yarn_issue_details`
--

INSERT INTO `yarn_issue_details` (`id`, `design_id`, `product_id`, `yarn_issue_id`, `qty`, `lot_no`, `created_at`, `updated_at`) VALUES
(8, NULL, 9, 5, '100', NULL, '2023-12-04 08:03:47', '2023-12-04 08:03:47'),
(9, NULL, 8, 6, '100', NULL, '2024-03-01 06:40:48', '2024-03-01 06:40:48');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `designs`
--
ALTER TABLE `designs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `designs_design_master_id_foreign` (`design_master_id`),
  ADD KEY `designs_order_id_foreign` (`order_id`);

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

--
-- Indexes for table `design_master_details`
--
ALTER TABLE `design_master_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `design_master_details_design_master_id_foreign` (`design_master_id`),
  ADD KEY `design_master_details_product_id_foreign` (`product_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 `inventories`
--
ALTER TABLE `inventories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventories_product_id_foreign` (`product_id`);

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_payment_id_foreign` (`payment_id`);

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

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

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

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

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

--
-- Indexes for table `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 `processing_houses`
--
ALTER TABLE `processing_houses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_category_id_foreign` (`category_id`);

--
-- Indexes for table `purchase_orders`
--
ALTER TABLE `purchase_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `purchase_orders_supplier_id_foreign` (`supplier_id`),
  ADD KEY `purchase_orders_order_id_foreign` (`order_id`);

--
-- Indexes for table `purchase_order_details`
--
ALTER TABLE `purchase_order_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `purchase_order_details_purchase_order_id_foreign` (`purchase_order_id`),
  ADD KEY `purchase_order_details_product_id_foreign` (`product_id`);

--
-- Indexes for table `purchase_order_histories`
--
ALTER TABLE `purchase_order_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `purchase_order_histories_purchase_order_id_foreign` (`purchase_order_id`),
  ADD KEY `purchase_order_histories_product_id_foreign` (`product_id`),
  ADD KEY `purchase_order_histories_purchase_order_detail_id_foreign` (`purchase_order_detail_id`);

--
-- Indexes for table `rolls`
--
ALTER TABLE `rolls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rolls_design_id_foreign` (`design_id`),
  ADD KEY `rolls_product_id_foreign` (`product_id`),
  ADD KEY `rolls_processing_house_id_foreign` (`processing_house_id`);

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

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

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

--
-- Indexes for table `yarn_issue_details`
--
ALTER TABLE `yarn_issue_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `yarn_issue_details_design_id_foreign` (`design_id`),
  ADD KEY `yarn_issue_details_product_id_foreign` (`product_id`),
  ADD KEY `yarn_issue_details_yarn_issue_id_foreign` (`yarn_issue_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `designs`
--
ALTER TABLE `designs`
  ADD CONSTRAINT `designs_design_master_id_foreign` FOREIGN KEY (`design_master_id`) REFERENCES `design_masters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `design_master_details`
--
ALTER TABLE `design_master_details`
  ADD CONSTRAINT `design_master_details_design_master_id_foreign` FOREIGN KEY (`design_master_id`) REFERENCES `design_masters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `design_master_details_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `inventories`
--
ALTER TABLE `inventories`
  ADD CONSTRAINT `inventories_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `purchase_orders`
--
ALTER TABLE `purchase_orders`
  ADD CONSTRAINT `purchase_orders_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `purchase_order_details`
--
ALTER TABLE `purchase_order_details`
  ADD CONSTRAINT `purchase_order_details_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `purchase_order_details_purchase_order_id_foreign` FOREIGN KEY (`purchase_order_id`) REFERENCES `purchase_orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `purchase_order_histories`
--
ALTER TABLE `purchase_order_histories`
  ADD CONSTRAINT `purchase_order_histories_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `purchase_order_histories_purchase_order_detail_id_foreign` FOREIGN KEY (`purchase_order_detail_id`) REFERENCES `purchase_order_details` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `purchase_order_histories_purchase_order_id_foreign` FOREIGN KEY (`purchase_order_id`) REFERENCES `purchase_orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `rolls`
--
ALTER TABLE `rolls`
  ADD CONSTRAINT `rolls_design_id_foreign` FOREIGN KEY (`design_id`) REFERENCES `designs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `rolls_processing_house_id_foreign` FOREIGN KEY (`processing_house_id`) REFERENCES `processing_houses` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `rolls_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `yarn_issue_details`
--
ALTER TABLE `yarn_issue_details`
  ADD CONSTRAINT `yarn_issue_details_design_id_foreign` FOREIGN KEY (`design_id`) REFERENCES `designs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `yarn_issue_details_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `yarn_issue_details_yarn_issue_id_foreign` FOREIGN KEY (`yarn_issue_id`) REFERENCES `yarn_issues` (`id`) ON DELETE CASCADE;
COMMIT;

