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

START TRANSACTION;



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

--
-- Table structure for table `articles`
--

CREATE TABLE `articles` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `tags` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `authored_by` char(36) 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 `articles_comments`
--

CREATE TABLE `articles_comments` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `admin_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `predecessor` char(36) 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 `article_reactions`
--

CREATE TABLE `article_reactions` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `article_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reaction` tinyint NOT NULL COMMENT '(0 = Upvote, 1 = Downvote)',
  `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 `carts`
--

CREATE TABLE `carts` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'FALSE => Pending, TRUE => Closed'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `carts`
--

INSERT INTO `carts` (`id`, `created_at`, `updated_at`, `user_id`, `status`) VALUES
('b92ca626-c6db-414e-abc2-ae25ec8ed3de', '2021-02-15 07:13:48', '2021-02-15 07:13:48', '4d48364b-33d8-448d-b03c-0dfe56923f09', 0),
('c5ce005f-1c49-41b8-aff5-fa631f54d3e9', '2021-02-07 17:29:53', '2021-02-15 07:08:28', '4d48364b-33d8-448d-b03c-0dfe56923f09', 1);

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

--
-- Table structure for table `cart_parts`
--

CREATE TABLE `cart_parts` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cart_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `part_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` bigint UNSIGNED 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 `cart_parts`
--

INSERT INTO `cart_parts` (`id`, `cart_id`, `part_id`, `quantity`, `created_at`, `updated_at`) VALUES
('7cb51087-fa11-4471-aeb8-7339ca354a5c', 'c5ce005f-1c49-41b8-aff5-fa631f54d3e9', '1b32864f-da97-468f-a0c5-53d90f4bcef4', 1, '2021-02-07 17:50:00', '2021-02-07 17:50:00'),
('8c68df2b-09a7-4ae3-b43e-f81115b19584', 'b92ca626-c6db-414e-abc2-ae25ec8ed3de', '1b32864f-da97-468f-a0c5-53d90f4bcef4', 1, '2021-02-15 07:13:55', '2021-02-15 07:13:55');

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

--
-- Table structure for table `cart_products`
--

CREATE TABLE `cart_products` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cart_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` bigint UNSIGNED 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 `cart_products`
--

INSERT INTO `cart_products` (`id`, `cart_id`, `product_id`, `quantity`, `created_at`, `updated_at`) VALUES
('6f2cefbb-e4e7-4148-b4e7-12824e6224c3', 'b92ca626-c6db-414e-abc2-ae25ec8ed3de', 'de80d327-b17a-480c-93cc-478c8b1d0765', 1, '2021-02-15 07:13:48', '2021-02-15 07:13:48'),
('78140c1b-c2d5-47cb-a908-85ce0e9905e4', 'c5ce005f-1c49-41b8-aff5-fa631f54d3e9', 'de80d327-b17a-480c-93cc-478c8b1d0765', 1, '2021-02-07 17:49:37', '2021-02-07 17:49:37');

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

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

CREATE TABLE `categories` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) 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 `categories`
--

INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`) VALUES
('309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'Test', '2021-01-27 21:15:58', '2021-01-27 21:15:58');

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

--
-- Table structure for table `category_designs`
--

CREATE TABLE `category_designs` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo_path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` 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 `category_designs`
--

INSERT INTO `category_designs` (`id`, `category_id`, `name_en`, `logo_path`, `color`, `created_at`, `updated_at`) VALUES
('5e5f3651-6601-422c-9179-03accedadfe5', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'afdfasd', '/category/logos/1b4b223aff8277e68d211e79f730b9af--burmese-our-country.jpg', '#9E5050', '2021-01-27 21:15:58', '2021-01-27 21:15:58');

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

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

CREATE TABLE `inventories` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) 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 `inventories`
--

INSERT INTO `inventories` (`id`, `user_id`, `created_at`, `updated_at`) VALUES
('657eb037-65ef-4ab5-a4ba-c4d2d34389f0', '4d48364b-33d8-448d-b03c-0dfe56923f09', NULL, NULL);

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

--
-- Table structure for table `inventory_loading`
--

CREATE TABLE `inventory_loading` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `inventory_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_products` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_parts` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `loaded_at` datetime 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 `inventory_loading`
--

INSERT INTO `inventory_loading` (`id`, `inventory_id`, `code`, `total_products`, `total_parts`, `loaded_at`, `created_at`, `updated_at`) VALUES
('96921b72-8935-4cbd-a5b2-b1a535957a28', '657eb037-65ef-4ab5-a4ba-c4d2d34389f0', '09783660744 (၂၀၂၁-၀၂-၂၆/၀၂-၃၇)', '0', '22', '2021-02-25 02:33:00', '2021-02-25 20:07:17', '2021-02-25 20:07:17'),
('b49d6b37-7466-4455-ab1b-a34dc84f2094', '657eb037-65ef-4ab5-a4ba-c4d2d34389f0', '09783660744 (၂၀၂၁-၀၂-၂၆/၀၂-၂၇)', '24', '24', '2021-01-27 22:04:00', '2021-02-25 19:57:15', '2021-02-25 19:57:15'),
('d4b1c6fa-aaec-406e-84e3-b8fd4589ea73', '657eb037-65ef-4ab5-a4ba-c4d2d34389f0', '09783660744 (၂၀၂၁-၀၂-၂၆/၀၂-၃၅)', '0', '22', '2021-02-25 02:33:00', '2021-02-25 20:05:39', '2021-02-25 20:05:39'),
('ee6dfc70-794f-4477-b057-92a4aeb19c1d', '657eb037-65ef-4ab5-a4ba-c4d2d34389f0', '09783660744 (၂၀၂၁-၀၂-၂၆/၀၂-၃၂)', '0', '16', '2021-01-20 22:04:00', '2021-02-25 20:02:14', '2021-02-25 20:02:14');

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

--
-- Table structure for table `inventory_loading_parts`
--

CREATE TABLE `inventory_loading_parts` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `inventory_loading_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `part_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_parts` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remaining_parts` 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 `inventory_loading_parts`
--

INSERT INTO `inventory_loading_parts` (`id`, `inventory_loading_id`, `part_id`, `total_parts`, `remaining_parts`, `created_at`, `updated_at`) VALUES
('10238070-adcc-4c70-be92-c98e39c42e6c', '96921b72-8935-4cbd-a5b2-b1a535957a28', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', '12', '12', '2021-02-25 20:07:17', '2021-02-25 20:07:17'),
('f5d322d6-d22b-431f-accf-ad47521057ed', '96921b72-8935-4cbd-a5b2-b1a535957a28', '6bcf1b05-b166-4ec4-baef-e6c96a460174', '10', '10', '2021-02-25 20:07:17', '2021-02-25 20:07:17');

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

--
-- Table structure for table `inventory_loading_products`
--

CREATE TABLE `inventory_loading_products` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `inventory_loading_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_products` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remaining_products` 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 `inventory_loading_products`
--

INSERT INTO `inventory_loading_products` (`id`, `inventory_loading_id`, `product_id`, `total_products`, `remaining_products`, `created_at`, `updated_at`) VALUES
('4a8dbadf-26c1-40b5-bcb0-5244272c19f1', 'b49d6b37-7466-4455-ab1b-a34dc84f2094', 'de80d327-b17a-480c-93cc-478c8b1d0765', '12', '12', '2021-02-25 19:57:15', '2021-02-25 19:57:15'),
('e69d442f-a278-4b41-a93c-75f07836fe34', 'b49d6b37-7466-4455-ab1b-a34dc84f2094', 'cc7a2b03-a5ad-46c7-a455-d6504a572bf6', '12', '12', '2021-02-25 19:57:15', '2021-02-25 19:57:15');

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

--
-- Table structure for table `inventory_logs`
--

CREATE TABLE `inventory_logs` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `count` int NOT NULL,
  `type` tinyint(1) NOT NULL COMMENT '0 => Sold, 1 => Loaded',
  `valve_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `actor` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `acted_at` date 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 `inventory_parts`
--

CREATE TABLE `inventory_parts` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `inventory_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `part_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `commisssion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_quantity` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remaining_quantity` varchar(255) 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 `inventory_part_sales_records`
--

CREATE TABLE `inventory_part_sales_records` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `inventory_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `part_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `count` bigint UNSIGNED NOT NULL,
  `customer_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sold_at` date NOT NULL,
  `remarks` 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;

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

--
-- Table structure for table `inventory_products`
--

CREATE TABLE `inventory_products` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `inventory_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `commisssion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_quantity` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remaining_quantity` varchar(255) 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 `inventory_product_sales_records`
--

CREATE TABLE `inventory_product_sales_records` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `inventory_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `count` bigint UNSIGNED NOT NULL,
  `customer_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sold_at` date NOT NULL,
  `remarks` 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;

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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'products, parts',
  `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 UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2020_11_08_153808_create_shops_table', 1),
(4, '2020_11_08_154521_create_admins_table', 1),
(5, '2020_11_08_154522_create_regions_table', 1),
(6, '2020_11_08_154522_create_resources_table', 1),
(7, '2020_11_08_154523_create_categories_table', 1),
(8, '2020_11_08_154523_create_townships_table', 1),
(9, '2020_11_08_154524_create_products_table', 1),
(10, '2020_11_08_154525_create_product_prices_table', 1),
(11, '2020_11_08_154526_create_parts_table', 1),
(12, '2020_11_08_154526_create_product_images_table', 1),
(13, '2020_11_08_154527_create_part_prices_table', 1),
(14, '2020_11_08_154528_create_part_images_table', 1),
(15, '2020_11_08_154529_create_product_parts_table', 1),
(16, '2020_11_08_154530_create_carts_table', 1),
(17, '2020_11_08_154530_create_orders_table', 1),
(18, '2020_11_08_154531_create_order_details_table', 1),
(19, '2020_11_08_154532_create_inventories_table', 1),
(20, '2020_11_08_154533_create_inventory_products_table', 1),
(21, '2020_11_08_154534_create_inventory_parts_table', 1),
(22, '2020_11_08_154534_create_warehouses_table', 1),
(23, '2020_11_08_154535_create_warehouse_contact_points_table', 1),
(24, '2020_11_08_154536_create_warehouse_loading_table', 1),
(25, '2020_11_08_154537_create_warehouse_loading_products_table', 1),
(26, '2020_11_08_154543_create_warehouse_loading_parts_table', 1),
(27, '2020_11_13_151916_create_tags_table', 1),
(28, '2020_11_13_152027_create_articles_table', 1),
(29, '2020_11_13_152523_create_article_reactions_table', 1),
(30, '2020_11_13_152941_create_articles_comments_table', 1),
(31, '2020_12_04_164034_add_title_to_admins_table', 1),
(32, '2021_01_11_061939_add_otp_users_table', 2),
(33, '2021_01_11_062702_modify_users_table', 3),
(34, '2021_01_11_064228_add_otp_status_to_users_table', 4),
(35, '2021_01_13_062459_add_delivery_charge_to_townships_table', 5),
(36, '2021_01_13_064301_change_nullable_to_postal_code_townships_table', 6),
(37, '2021_01_13_165449_add_unique_key_constraint_to_lat_long_regions_table', 7),
(38, '2021_01_13_170504_add_unique_key_constraint_to_lat_long_townships_table', 7),
(39, '2021_01_17_165332_modify_shops_table', 8),
(40, '2021_01_27_205943_add_loaded_at_to_warehouse_loading', 9),
(41, '2021_01_28_015805_create_category_designs_table', 10),
(42, '2021_01_28_021223_drop_name_en_from_category_designs_table', 11),
(43, '2021_01_28_165921_add_compound_unique_key_in_product_parts_table', 12),
(44, '2021_01_28_195807_add_new_compound_unique_key_in_product_parts_table', 13),
(45, '2021_02_07_223829_modify_carts_table', 14),
(46, '2021_02_07_224603_create_cart_products_table', 15),
(47, '2021_02_07_225710_create_cart_parts_table', 15),
(48, '2021_02_15_120631_add_cart_region_township_ids_to_orders_table', 16),
(49, '2021_02_15_122444_add_name_to_orders_table', 17),
(50, '2021_02_15_133428_add_composite_unique_key_to_orders_table', 18),
(51, '2021_02_15_133717_add_composite_unique_key_to_orders_table', 19),
(52, '2021_02_17_141225_add_name_to_products_table', 20),
(53, '2021_02_17_141330_add_name_to_parts_table', 20),
(54, '2021_02_19_102655_create_order_progress_table', 21),
(55, '2021_02_25_021632_create_inventory_loading_table', 22),
(56, '2021_02_25_022106_create_inventory_loading_products_table', 22),
(57, '2021_02_25_022303_create_inventory_loading_parts_table', 22),
(58, '2021_02_25_023640_create_inventory_product_sales_records_table', 22),
(59, '2021_02_25_023942_create_inventory_part_sales_records_table', 22),
(60, '2021_02_26_120322_create_items_table', 23),
(63, '2021_02_26_120323_create_inventory_logs_table', 24);

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

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

CREATE TABLE `orders` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `region_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `township_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cart_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_cost` varchar(255) 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 `orders`
--

INSERT INTO `orders` (`id`, `code`, `region_id`, `township_id`, `cart_id`, `user_id`, `name`, `address`, `phone`, `total_cost`, `created_at`, `updated_at`) VALUES
('7baf40c8-3eb1-45af-8fb3-5b55e58d1f5c', '1613372908', '0f081e1f-1f2c-4cb7-b343-bd7c4e87d351', '144cda67-9065-4c5e-bd45-aaed8ac2d86d', 'c5ce005f-1c49-41b8-aff5-fa631f54d3e9', '4d48364b-33d8-448d-b03c-0dfe56923f09', 'Ye Lu', 'Yangon', '09799276848', '19000', '2021-02-15 07:08:28', '2021-02-15 07:08:28');

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

--
-- Table structure for table `order_progress`
--

CREATE TABLE `order_progress` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint UNSIGNED NOT NULL COMMENT '1 => accepted, 2 => rejected, 3 => delivered, 4 => received',
  `admin` char(36) 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 `order_progress`
--

INSERT INTO `order_progress` (`id`, `order_id`, `status`, `admin`, `created_at`, `updated_at`) VALUES
('28e4a7a9-cd26-40ab-b569-301fe9e95868', '7baf40c8-3eb1-45af-8fb3-5b55e58d1f5c', 1, '', '2021-02-19 05:38:28', '2021-02-19 05:38:28'),
('3a09f5b0-e919-4e27-a1e0-aa4947357ae5', '7baf40c8-3eb1-45af-8fb3-5b55e58d1f5c', 3, '', '2021-02-19 05:59:42', '2021-02-19 05:59:42'),
('42746d12-da51-4e00-8487-e3e4cd3052ee', '7baf40c8-3eb1-45af-8fb3-5b55e58d1f5c', 4, '', '2021-02-19 06:01:58', '2021-02-19 06:01:58');

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

--
-- Table structure for table `parts`
--

CREATE TABLE `parts` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `engine_model` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `valve_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `default_price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `parts`
--

INSERT INTO `parts` (`id`, `engine_model`, `valve_number`, `description`, `thumbnail`, `default_price`, `created_at`, `updated_at`, `name`, `item_id`) VALUES
('1b32864f-da97-468f-a0c5-53d90f4bcef4', 'asfadsfdafadfads', '2343243', '<p>TEST</p>', '/part/thumbnails/Screenshot from 2021-01-20 13-30-34.png', '10000', '2021-01-20 10:43:34', '2021-01-20 10:43:34', NULL, NULL),
('6bcf1b05-b166-4ec4-baef-e6c96a460174', 'sadfdasf', 'fasdfadsfasdfasd', NULL, '/part/thumbnails/Screenshot from 2021-01-20 13-30-34.png', '1000', '2021-01-20 10:04:02', '2021-01-20 10:04:02', NULL, NULL),
('ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 'sadfasdfasdfasdf', 'fasdfadsfasdfasdfadsfas', NULL, '/part/thumbnails/Screenshot from 2021-01-20 13-30-34.png', '10000', '2021-01-20 10:05:58', '2021-01-20 10:05:58', NULL, NULL),
('bc0abcbf-7a7f-4c3a-90ef-b0796b25b2cd', 'rwtrwtrwe', 'terwtwer', NULL, '/part/thumbnails/Screenshot from 2021-01-18 23-35-08.png', '10000', '2021-01-20 10:33:52', '2021-01-20 10:33:52', NULL, NULL);

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

--
-- Table structure for table `part_images`
--

CREATE TABLE `part_images` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `part_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint 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 `part_images`
--

INSERT INTO `part_images` (`id`, `path`, `part_id`, `order`, `created_at`, `updated_at`) VALUES
('02e46ded-8df1-4b22-b09e-d0691322f31e', '/part/images/Screenshot from 2021-01-15 18-50-11.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 6, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('04953032-dbbe-403b-8fab-6d4a45bf6fe0', '/part/images/Screenshot from 2021-01-15 12-06-56.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 7, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('0936a50a-d9c3-403f-b23a-cf74e38801ba', '/part/images/Screenshot from 2021-01-04 18-27-53.png', '1b32864f-da97-468f-a0c5-53d90f4bcef4', 1, '2021-01-20 10:43:34', '2021-01-20 10:43:34'),
('09ed730b-536e-4ef0-a606-2cab729611bc', '/part/images/Screenshot from 2021-01-20 13-30-22.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 2, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('15c52c97-043d-4b0e-abcf-929809ca848d', '/part/images/Screenshot from 2021-01-07 02-08-13.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 15, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('1ca4dd22-5b3a-447d-ba65-d2f614be529c', '/part/images/Screenshot from 2021-01-14 21-53-00.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 8, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('22a55ddf-65c0-48d4-9c61-6f7f0ae66332', '/part/images/Screenshot from 2021-01-14 18-35-44.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 9, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('24f2173c-2d73-468d-9e2b-a1e6f5c828d6', '/part/images/Screenshot from 2021-01-18 21-56-39.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 5, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('3b2cc9de-217a-4337-ba34-519574c579c7', '/part/images/Screenshot from 2021-01-20 13-30-22.png', 'bc0abcbf-7a7f-4c3a-90ef-b0796b25b2cd', 2, '2021-01-20 10:33:52', '2021-01-20 10:33:52'),
('3bbbabe6-302a-4a85-aa6b-6b2cc022fbcf', '/part/images/Screenshot from 2021-01-19 10-46-13.png', 'bc0abcbf-7a7f-4c3a-90ef-b0796b25b2cd', 3, '2021-01-20 10:33:52', '2021-01-20 10:33:52'),
('4a786953-bdd3-4180-b991-e52502fd9da8', '/part/images/Screenshot from 2021-01-20 13-30-34.png', '6bcf1b05-b166-4ec4-baef-e6c96a460174', 1, '2021-01-20 10:04:02', '2021-01-20 10:04:02'),
('513a5351-185a-4549-be95-68f7fefdf32f', '/part/images/Screenshot from 2021-01-07 02-10-30.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 14, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('5b50a5e9-f29a-42c8-8c23-3cb1bb671a3f', '/part/images/Screenshot from 2021-01-20 13-30-34.png', 'bc0abcbf-7a7f-4c3a-90ef-b0796b25b2cd', 1, '2021-01-20 10:33:52', '2021-01-20 10:33:52'),
('5fef4883-01cf-4f8c-80d3-d21ea40420ac', '/part/images/Screenshot from 2021-01-15 18-50-11.png', 'bc0abcbf-7a7f-4c3a-90ef-b0796b25b2cd', 6, '2021-01-20 10:33:52', '2021-01-20 10:33:52'),
('695f396f-0fe3-41d1-831e-a2cbda4f821e', '/part/images/Screenshot from 2021-01-04 18-24-41.png', '1b32864f-da97-468f-a0c5-53d90f4bcef4', 3, '2021-01-20 10:43:34', '2021-01-20 10:43:34'),
('6f8d5ded-7c2b-4ed0-bce4-4328b77df379', '/part/images/Screenshot from 2021-01-18 23-35-08.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 4, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('748a62bc-90d9-4d5e-87b0-7a5304d41606', '/part/images/Screenshot from 2021-01-19 10-46-13.png', '6bcf1b05-b166-4ec4-baef-e6c96a460174', 3, '2021-01-20 10:04:02', '2021-01-20 10:04:02'),
('84fc518c-1bb3-477c-af87-a69b60b5d014', '/part/images/118682291_3389528737773959_7723384368570987833_n.jpg', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 10, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('968e3961-3920-4478-9663-863f090be5d9', '/part/images/Screenshot from 2021-01-08 01-05-53.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 12, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('98fcf42f-0e27-492a-a02b-f7fe34b3e14b', '/part/images/Screenshot from 2021-01-18 23-35-08.png', 'bc0abcbf-7a7f-4c3a-90ef-b0796b25b2cd', 4, '2021-01-20 10:33:52', '2021-01-20 10:33:52'),
('a7af5304-6f85-4c23-82f1-cc8807a557f8', '/part/images/Screenshot from 2021-01-18 21-56-39.png', 'bc0abcbf-7a7f-4c3a-90ef-b0796b25b2cd', 5, '2021-01-20 10:33:52', '2021-01-20 10:33:52'),
('abd0a916-4324-418e-b0bc-b1e46e9b85c7', '/part/images/Screenshot from 2021-01-04 18-23-36.png', '1b32864f-da97-468f-a0c5-53d90f4bcef4', 4, '2021-01-20 10:43:34', '2021-01-20 10:43:34'),
('adaaf891-0af8-4003-a1fc-cc0b35173318', '/part/images/Screenshot from 2021-01-07 11-26-13.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 13, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('af6cc435-9942-442e-a57c-af024d81d5ee', '/part/images/Screenshot from 2021-01-04 18-26-56.png', '1b32864f-da97-468f-a0c5-53d90f4bcef4', 2, '2021-01-20 10:43:34', '2021-01-20 10:43:34'),
('b958c2e2-bd21-46e1-933a-92579329d0fa', '/part/images/Screenshot from 2021-01-18 21-56-39.png', '6bcf1b05-b166-4ec4-baef-e6c96a460174', 5, '2021-01-20 10:04:02', '2021-01-20 10:04:02'),
('bb28b250-3743-477a-b498-df934a1d61eb', '/part/images/Screenshot from 2021-01-20 13-30-22.png', '6bcf1b05-b166-4ec4-baef-e6c96a460174', 2, '2021-01-20 10:04:02', '2021-01-20 10:04:02'),
('c010f251-4df0-4f90-a6fd-b24732d9d851', '/part/images/Screenshot from 2021-01-18 23-35-08.png', '6bcf1b05-b166-4ec4-baef-e6c96a460174', 4, '2021-01-20 10:04:02', '2021-01-20 10:04:02'),
('d2c42367-2635-472f-92aa-a37c7f6dfc22', '/part/images/Screenshot from 2021-01-20 13-30-34.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 1, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('d35578bc-f506-4dce-9ef4-982ed5679487', '/part/images/Screenshot from 2021-01-19 10-46-13.png', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 3, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('f1bdefd2-a67f-4c71-a0f0-9b9d7e9c733f', '/part/images/navaratna.jpg', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 11, '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('fa80380a-cd67-4d6d-8934-384406371286', '/part/images/Screenshot from 2021-01-15 18-50-11.png', '6bcf1b05-b166-4ec4-baef-e6c96a460174', 6, '2021-01-20 10:04:02', '2021-01-20 10:04:02');

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

--
-- Table structure for table `part_prices`
--

CREATE TABLE `part_prices` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `part_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_type` tinyint NOT NULL COMMENT '(1 = member, 2 = vendor)',
  `price` varchar(255) 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 `part_prices`
--

INSERT INTO `part_prices` (`id`, `part_id`, `user_type`, `price`, `created_at`, `updated_at`) VALUES
('1a52d31f-eadd-4f4f-90ae-c3071231c505', '6bcf1b05-b166-4ec4-baef-e6c96a460174', 2, '800', '2021-01-20 10:04:02', '2021-01-20 10:04:02'),
('2dafa2e7-2a79-4de2-933e-50439680d744', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 1, '9000', '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('6713c146-aff9-4d72-a17a-02a1e938bfeb', 'bc0abcbf-7a7f-4c3a-90ef-b0796b25b2cd', 2, '8000', '2021-01-20 10:33:52', '2021-01-20 10:33:52'),
('6b6e37d4-61c2-42cf-8d13-65e274c72c7a', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', 2, '8000', '2021-01-20 10:05:58', '2021-01-20 10:05:58'),
('7e47e7a4-1c75-44b1-9a0d-e752c033da69', '6bcf1b05-b166-4ec4-baef-e6c96a460174', 1, '900', '2021-01-20 10:04:02', '2021-01-20 10:04:02'),
('8feaf47b-6e3f-411d-a3c8-39cea97f5767', 'bc0abcbf-7a7f-4c3a-90ef-b0796b25b2cd', 1, '9000', '2021-01-20 10:33:52', '2021-01-20 10:33:52'),
('c93b4b14-dc5f-4864-bab1-1970038243d2', '1b32864f-da97-468f-a0c5-53d90f4bcef4', 2, '8000', '2021-01-20 10:43:34', '2021-01-20 10:43:34'),
('f823c5f2-3315-4b25-b098-a40df1404dad', '1b32864f-da97-468f-a0c5-53d90f4bcef4', 1, '9000', '2021-01-20 10:43:34', '2021-01-20 10:43:34');

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

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

CREATE TABLE `products` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `engine_model` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `default_price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` (`id`, `engine_model`, `category_id`, `product_number`, `description`, `thumbnail`, `default_price`, `created_at`, `updated_at`, `name`, `item_id`) VALUES
('074fb15c-b7e5-4f24-8a28-2391b48dea39', 'yelu', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'akjsjflasdjflkas', NULL, '/product/thumbnails/navaratna.jpg', '10000', '2021-01-09 21:49:26', '2021-01-09 21:49:26', NULL, NULL),
('2601e15b-7e81-4ff3-98a5-ed874c1db882', 'jhkjhladjsflasdjflkas', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'jfhaskjfadjfl;ass', '<p>TEST</p>', '/product/thumbnails/navaratna.jpg', '10000', '2021-01-09 21:07:24', '2021-01-09 21:07:24', NULL, NULL),
('3ab54a6c-293d-45eb-9ebd-04084f2f62a6', 'RTY124', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'afadfad', NULL, '/product/thumbnails/Screenshot from 2021-01-20 13-30-34.png', '1000', '2021-01-20 10:36:04', '2021-01-20 10:36:04', NULL, NULL),
('4c9bf7db-5400-4726-8e63-bbc4024c273a', 'adfasdfasdfasd', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'asdfadsfdasf', '<p>fasdfasd</p>', '/product/thumbnails/navaratna.jpg', '10000', '2021-01-09 22:28:37', '2021-01-09 22:28:37', NULL, NULL),
('4ee87c45-3814-467f-ad7c-8c48a3a6b483', 'fasfasdfasd', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'afdaskhkjhj', '<p><b>TEST</b></p>', '/product/thumbnails/navaratna.jpg', '1000', '2021-01-09 22:08:44', '2021-01-09 22:08:44', NULL, NULL),
('5de5ef68-a880-4d6c-a0bd-5245822a5566', 'dfasdfasdkfkjlaskdfas', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'asdlfjaslkdfjlkasdjflkasjlk', '<p>TEST</p>', '/product/thumbnails/navaratna.jpg', '1000', '2021-01-09 22:11:08', '2021-01-09 22:11:08', NULL, NULL),
('6a56509c-ba9b-4761-a8a8-e54d871c5425', 'sfasdfasdfasd', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'ffassdfasdfdas', '<p><b>TEST</b></p>', '/product/thumbnails/navaratna.jpg', '10000', '2021-01-09 22:07:10', '2021-01-09 22:07:10', NULL, NULL),
('8545cb6f-249e-41c6-ae05-92322e68a878', 'sadfasdfasdfasdf', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'dsafasd', '<p>TEST</p>', '/product/thumbnails/navaratna.jpg', '10000', '2021-01-09 21:06:32', '2021-01-09 21:06:32', NULL, NULL),
('c387fdce-1b69-49fc-984a-1181bea5d3cb', 'jhasdjflasdjflkajlk', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'kjalsddjflkajflkasjflk', '<p><b>TEST</b></p>', '/product/thumbnails/navaratna.jpg', '10000', '2021-01-09 22:16:51', '2021-01-09 22:16:51', NULL, NULL),
('cc7a2b03-a5ad-46c7-a455-d6504a572bf6', 'sdfasdfadsfadfads232', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'afsdfad121', '<p><b>TEST</b></p>', '/product/thumbnails/Screenshot from 2021-01-20 13-30-34.png', '10000', '2021-01-20 10:42:28', '2021-01-20 10:42:28', NULL, NULL),
('de80d327-b17a-480c-93cc-478c8b1d0765', 'adfkjasdflasdjlfkjal', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'kjdafkjasdflajldkf', '<p>TEST</p>', '/product/thumbnails/navaratna.jpg', '10000', '2021-01-09 21:11:00', '2021-01-09 21:11:00', NULL, NULL),
('e86d642e-21a1-4d93-a0e9-712148e96db2', 'asdfdasfasdfasd', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'asdfasdfdasfdasf', NULL, '/product/thumbnails/navaratna.jpg', '10000', '2021-01-09 22:29:31', '2021-01-09 22:29:31', NULL, NULL),
('f5e9b8fe-68e3-4f95-83be-e9e00c1ebb8e', 'afnjasdflasdflkasjlk', '309e2af9-dd9f-4a0c-b99f-3eae7ac4b577', 'lljlasjflkasdjflkasdjflkasj', '<p><b><u>TEST</u></b></p>', '/product/thumbnails/navaratna.jpg', '10000', '2021-01-09 22:24:28', '2021-01-09 22:24:28', NULL, NULL);

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

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint 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 `product_images`
--

INSERT INTO `product_images` (`id`, `path`, `product_id`, `order`, `created_at`, `updated_at`) VALUES
('008e0e5f-0696-4af5-99ab-239487e8d4a0', '/product/images/Screenshot from 2021-01-04 18-23-36.png', '074fb15c-b7e5-4f24-8a28-2391b48dea39', 3, '2021-01-09 21:49:26', '2021-01-09 21:49:26'),
('0233ea7b-47b3-4f4f-80ad-0d22e0ff6254', '/product/images/Screenshot from 2021-01-04 18-27-53.png', 'de80d327-b17a-480c-93cc-478c8b1d0765', 1, '2021-01-09 21:11:00', '2021-01-09 21:11:00'),
('06a1ec11-f4a1-4864-bb7a-81e1ffd4c6ac', '/product/images/Screenshot from 2021-01-04 18-23-36.png', 'e86d642e-21a1-4d93-a0e9-712148e96db2', 4, '2021-01-09 22:29:31', '2021-01-09 22:29:31'),
('11a17d1c-0661-4ed4-b390-2c07e87d7b4d', '/product/images/Screenshot from 2021-01-04 18-26-56.png', '2601e15b-7e81-4ff3-98a5-ed874c1db882', 2, '2021-01-09 21:07:24', '2021-01-09 21:07:24'),
('11cf5ee4-9e0d-4c84-b684-e6d88c732892', '/product/images/Screenshot from 2021-01-04 18-23-36.png', 'f5e9b8fe-68e3-4f95-83be-e9e00c1ebb8e', 4, '2021-01-09 22:24:28', '2021-01-09 22:24:28'),
('18bdb7ec-3088-4b3a-9a0d-e4e277812183', '/product/images/Screenshot from 2021-01-04 18-24-41.png', '4ee87c45-3814-467f-ad7c-8c48a3a6b483', 3, '2021-01-09 22:08:44', '2021-01-09 22:08:44'),
('1b1d6284-f378-4cf4-a669-eb47805ac23f', '/product/images/Screenshot from 2021-01-04 18-27-53.png', '4ee87c45-3814-467f-ad7c-8c48a3a6b483', 1, '2021-01-09 22:08:44', '2021-01-09 22:08:44'),
('246bbf62-2abe-45a4-a284-0fb74aec16ab', '/product/images/Screenshot from 2021-01-04 18-27-53.png', 'c387fdce-1b69-49fc-984a-1181bea5d3cb', 1, '2021-01-09 22:16:51', '2021-01-09 22:16:51'),
('2de3428d-9fbb-494e-9e41-87b2e6f6d771', '/product/images/Screenshot from 2021-01-04 18-27-53.png', '8545cb6f-249e-41c6-ae05-92322e68a878', 1, '2021-01-09 21:06:32', '2021-01-09 21:06:32'),
('3216e78b-daa1-47b4-8f07-c461cd475683', '/product/images/Screenshot from 2021-01-04 18-23-36.png', '6a56509c-ba9b-4761-a8a8-e54d871c5425', 3, '2021-01-09 22:07:10', '2021-01-09 22:07:10'),
('33c05236-d353-4510-b597-344074e76e94', '/product/images/Screenshot from 2021-01-04 18-26-56.png', 'c387fdce-1b69-49fc-984a-1181bea5d3cb', 2, '2021-01-09 22:16:51', '2021-01-09 22:16:51'),
('361c16bf-946b-40ca-bedd-23356b0f19f8', '/product/images/Screenshot from 2021-01-04 18-26-56.png', '6a56509c-ba9b-4761-a8a8-e54d871c5425', 1, '2021-01-09 22:07:10', '2021-01-09 22:07:10'),
('36a87817-c865-43d4-8892-dc48fce37613', '/product/images/Screenshot from 2021-01-04 18-24-41.png', '074fb15c-b7e5-4f24-8a28-2391b48dea39', 2, '2021-01-09 21:49:26', '2021-01-09 21:49:26'),
('4b44c697-bb82-480f-8bdb-b277af17fe06', '/product/images/Screenshot from 2021-01-05 21-03-59.png', '3ab54a6c-293d-45eb-9ebd-04084f2f62a6', 1, '2021-01-20 10:36:04', '2021-01-20 10:36:04'),
('594483ea-1daf-4840-be09-0fb0bfa2f697', '/product/images/Screenshot from 2021-01-04 18-27-53.png', '2601e15b-7e81-4ff3-98a5-ed874c1db882', 1, '2021-01-09 21:07:24', '2021-01-09 21:07:24'),
('5c3e4bac-aebb-4160-9de0-844a7659a023', '/product/images/Screenshot from 2021-01-04 18-24-41.png', '6a56509c-ba9b-4761-a8a8-e54d871c5425', 2, '2021-01-09 22:07:10', '2021-01-09 22:07:10'),
('60956924-a49c-4081-a7e7-5e1d2fcfbcf7', '/product/images/Screenshot from 2021-01-04 18-24-41.png', 'f5e9b8fe-68e3-4f95-83be-e9e00c1ebb8e', 3, '2021-01-09 22:24:28', '2021-01-09 22:24:28'),
('698f9291-8610-4849-838c-36f915d6fe25', '/product/images/Screenshot from 2021-01-04 18-26-56.png', '5de5ef68-a880-4d6c-a0bd-5245822a5566', 1, '2021-01-09 22:11:08', '2021-01-09 22:11:08'),
('704d66ea-665d-4b96-a0ed-0398d5f89e31', '/product/images/Screenshot from 2021-01-15 12-06-56.png', 'cc7a2b03-a5ad-46c7-a455-d6504a572bf6', 1, '2021-01-20 10:42:28', '2021-01-20 10:42:28'),
('725ee27a-9f14-4e7b-8d65-042dafac6400', '/product/images/Screenshot from 2021-01-04 18-26-56.png', '8545cb6f-249e-41c6-ae05-92322e68a878', 2, '2021-01-09 21:06:32', '2021-01-09 21:06:32'),
('87102b49-afb4-4b96-99a4-51a9dd5f7130', '/product/images/Screenshot from 2021-01-04 18-27-53.png', 'e86d642e-21a1-4d93-a0e9-712148e96db2', 1, '2021-01-09 22:29:31', '2021-01-09 22:29:31'),
('88248031-18e6-4b25-9f94-0cc0b65bb0fc', '/product/images/Screenshot from 2021-01-04 18-24-41.png', '5de5ef68-a880-4d6c-a0bd-5245822a5566', 2, '2021-01-09 22:11:08', '2021-01-09 22:11:08'),
('8ac0bd4a-f42b-44b5-98d8-b9d4bf675115', '/product/images/Screenshot from 2021-01-14 21-53-00.png', 'cc7a2b03-a5ad-46c7-a455-d6504a572bf6', 2, '2021-01-20 10:42:28', '2021-01-20 10:42:28'),
('8e903b5e-3059-4fd6-af5e-c3dcc95b8223', '/product/images/Screenshot from 2021-01-04 18-23-36.png', '2601e15b-7e81-4ff3-98a5-ed874c1db882', 4, '2021-01-09 21:07:24', '2021-01-09 21:07:24'),
('903c02da-9bab-4137-960c-ac946120e190', '/product/images/Screenshot from 2021-01-04 18-26-56.png', '074fb15c-b7e5-4f24-8a28-2391b48dea39', 1, '2021-01-09 21:49:26', '2021-01-09 21:49:26'),
('9417b1a5-9f8b-4ed8-bd48-8ebb4de55026', '/product/images/Screenshot from 2021-01-04 18-26-56.png', '4ee87c45-3814-467f-ad7c-8c48a3a6b483', 2, '2021-01-09 22:08:44', '2021-01-09 22:08:44'),
('96b70261-3e59-4058-9dd3-9f29f709df66', '/product/images/Screenshot from 2021-01-04 18-24-41.png', 'de80d327-b17a-480c-93cc-478c8b1d0765', 3, '2021-01-09 21:11:00', '2021-01-09 21:11:00'),
('97594690-5605-4b0f-8058-4f25bab7a94f', '/product/images/Screenshot from 2021-01-04 18-24-41.png', 'c387fdce-1b69-49fc-984a-1181bea5d3cb', 3, '2021-01-09 22:16:51', '2021-01-09 22:16:51'),
('9aa9a2d8-bc5b-4933-8300-e103d14e22d7', '/product/images/Screenshot from 2021-01-04 18-26-56.png', 'e86d642e-21a1-4d93-a0e9-712148e96db2', 2, '2021-01-09 22:29:31', '2021-01-09 22:29:31'),
('9f32450a-8226-4d51-a72d-501030c0d842', '/product/images/Screenshot from 2021-01-04 18-24-41.png', '4c9bf7db-5400-4726-8e63-bbc4024c273a', 2, '2021-01-09 22:28:37', '2021-01-09 22:28:37'),
('a279da2a-e79e-4014-beb0-927a4803cc17', '/product/images/Screenshot from 2021-01-04 18-26-56.png', 'f5e9b8fe-68e3-4f95-83be-e9e00c1ebb8e', 2, '2021-01-09 22:24:28', '2021-01-09 22:24:28'),
('ac65a37d-e6a9-4ff8-bcef-dd47a45186d9', '/product/images/Screenshot from 2021-01-04 18-26-56.png', '3ab54a6c-293d-45eb-9ebd-04084f2f62a6', 3, '2021-01-20 10:36:04', '2021-01-20 10:36:04'),
('b5a0b243-b366-47ac-8877-2b82ae91c7d9', '/product/images/Screenshot from 2021-01-04 18-26-56.png', 'de80d327-b17a-480c-93cc-478c8b1d0765', 2, '2021-01-09 21:11:00', '2021-01-09 21:11:00'),
('bed74906-ce3c-408e-b93e-5064b8c83469', '/product/images/Screenshot from 2021-01-04 18-23-36.png', '8545cb6f-249e-41c6-ae05-92322e68a878', 4, '2021-01-09 21:06:32', '2021-01-09 21:06:32'),
('c6041315-3599-45ed-a6ac-b2e3daaee362', '/product/images/Screenshot from 2021-01-04 18-24-41.png', 'e86d642e-21a1-4d93-a0e9-712148e96db2', 3, '2021-01-09 22:29:31', '2021-01-09 22:29:31'),
('c68addfa-b83c-4054-95c4-39c4aed7f326', '/product/images/Screenshot from 2021-01-04 18-24-41.png', '2601e15b-7e81-4ff3-98a5-ed874c1db882', 3, '2021-01-09 21:07:24', '2021-01-09 21:07:24'),
('cca356d8-579c-42e9-9948-6ad8a40a2b94', '/product/images/Screenshot from 2021-01-04 18-24-41.png', '8545cb6f-249e-41c6-ae05-92322e68a878', 3, '2021-01-09 21:06:32', '2021-01-09 21:06:32'),
('e070570f-2f5a-4564-9f18-87cb863df5bd', '/product/images/Screenshot from 2021-01-04 18-26-56.png', '4c9bf7db-5400-4726-8e63-bbc4024c273a', 1, '2021-01-09 22:28:37', '2021-01-09 22:28:37'),
('e1448d5d-aa1e-4a08-9603-c7886f756d53', '/product/images/Screenshot from 2021-01-04 18-27-53.png', 'f5e9b8fe-68e3-4f95-83be-e9e00c1ebb8e', 1, '2021-01-09 22:24:28', '2021-01-09 22:24:28'),
('e5d2fcbb-b05b-4b0d-aa5b-f5582871ca23', '/product/images/Screenshot from 2021-01-14 18-35-44.png', 'cc7a2b03-a5ad-46c7-a455-d6504a572bf6', 3, '2021-01-20 10:42:28', '2021-01-20 10:42:28'),
('e5dafb98-8144-42c4-94d5-e540b1ce06e1', '/product/images/Screenshot from 2021-01-04 18-27-53.png', '3ab54a6c-293d-45eb-9ebd-04084f2f62a6', 2, '2021-01-20 10:36:04', '2021-01-20 10:36:04');

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

--
-- Table structure for table `product_parts`
--

CREATE TABLE `product_parts` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `part_id` char(36) 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 `product_parts`
--

INSERT INTO `product_parts` (`id`, `product_id`, `part_id`, `created_at`, `updated_at`) VALUES
('54774551-e132-4a0d-abc6-d0e5b1ca89e1', '4ee87c45-3814-467f-ad7c-8c48a3a6b483', '6bcf1b05-b166-4ec4-baef-e6c96a460174', '2021-01-28 14:10:04', '2021-01-28 14:10:04'),
('a75275b4-aede-4631-9940-ad1003e01655', '3ab54a6c-293d-45eb-9ebd-04084f2f62a6', '1b32864f-da97-468f-a0c5-53d90f4bcef4', '2021-01-28 14:10:04', '2021-01-28 14:10:04'),
('b89df83b-f7fd-4a2f-ac31-8090c6645604', '3ab54a6c-293d-45eb-9ebd-04084f2f62a6', '6bcf1b05-b166-4ec4-baef-e6c96a460174', '2021-01-28 14:10:04', '2021-01-28 14:10:04'),
('c151ecdd-7117-47c6-ae9b-76f58b06bb0f', '4ee87c45-3814-467f-ad7c-8c48a3a6b483', '1b32864f-da97-468f-a0c5-53d90f4bcef4', '2021-01-28 14:10:04', '2021-01-28 14:10:04');

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

--
-- Table structure for table `product_prices`
--

CREATE TABLE `product_prices` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_type` tinyint NOT NULL COMMENT '(1 = member, 2 = vendor)',
  `price` varchar(255) 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 `product_prices`
--

INSERT INTO `product_prices` (`id`, `product_id`, `user_type`, `price`, `created_at`, `updated_at`) VALUES
('11079e8d-263e-4a47-b333-3140e58b084c', '4c9bf7db-5400-4726-8e63-bbc4024c273a', 1, '9000', '2021-01-09 22:28:37', '2021-01-09 22:28:37'),
('152a3ec4-2acf-430d-8c1e-0b735abfb6a5', '2601e15b-7e81-4ff3-98a5-ed874c1db882', 1, '9000', '2021-01-09 21:07:24', '2021-01-09 21:07:24'),
('1650d482-444d-4fca-9dab-242a96ff4e8f', '3ab54a6c-293d-45eb-9ebd-04084f2f62a6', 1, '1000', '2021-01-20 10:36:04', '2021-01-20 10:36:04'),
('1d16d679-c67f-4ee7-832f-b22dded8637f', '5de5ef68-a880-4d6c-a0bd-5245822a5566', 1, '100', '2021-01-09 22:11:08', '2021-01-09 22:11:08'),
('2b04e41f-2fdc-4a1c-b015-12dc91703779', '074fb15c-b7e5-4f24-8a28-2391b48dea39', 2, '8000', '2021-01-09 21:49:26', '2021-01-09 21:49:26'),
('626ff753-e075-4998-a596-c04762af4a57', '4ee87c45-3814-467f-ad7c-8c48a3a6b483', 2, '800', '2021-01-09 22:08:44', '2021-01-09 22:08:44'),
('68851e45-ced9-4536-999e-555c4a1e160c', 'e86d642e-21a1-4d93-a0e9-712148e96db2', 2, '8000', '2021-01-09 22:29:31', '2021-01-09 22:29:31'),
('8eb2b741-76aa-42fb-affd-a831b1139e25', 'f5e9b8fe-68e3-4f95-83be-e9e00c1ebb8e', 2, '8000', '2021-01-09 22:24:28', '2021-01-09 22:24:28'),
('8f91e78a-7daa-4bad-b31e-e39a43f174ba', 'cc7a2b03-a5ad-46c7-a455-d6504a572bf6', 1, '9000', '2021-01-20 10:42:28', '2021-01-20 10:42:28'),
('901859bf-1ccd-4a7a-8436-d7eeac4273c7', 'c387fdce-1b69-49fc-984a-1181bea5d3cb', 2, '8000', '2021-01-09 22:16:51', '2021-01-09 22:16:51'),
('90e6b464-dc31-4d9b-9f2e-bc55e31e07c8', '3ab54a6c-293d-45eb-9ebd-04084f2f62a6', 2, '1000', '2021-01-20 10:36:04', '2021-01-20 10:36:04'),
('a31ab989-a363-4b2c-bd76-6bd2a88e9e51', '8545cb6f-249e-41c6-ae05-92322e68a878', 1, '9000', '2021-01-09 21:06:32', '2021-01-09 21:06:32'),
('ab3956e2-456a-45f2-a4b3-cb710373a4c0', '074fb15c-b7e5-4f24-8a28-2391b48dea39', 1, '9000', '2021-01-09 21:49:26', '2021-01-09 21:49:26'),
('c4bf02f4-cfce-4fe7-b8a0-3d4b27c677d6', 'f5e9b8fe-68e3-4f95-83be-e9e00c1ebb8e', 1, '9000', '2021-01-09 22:24:28', '2021-01-09 22:24:28'),
('ccb7d8b5-c5a0-4e99-bb04-3b1cb5a0598f', 'e86d642e-21a1-4d93-a0e9-712148e96db2', 1, '9000', '2021-01-09 22:29:31', '2021-01-09 22:29:31'),
('d264f301-7616-41a7-bbba-2e2d077ee58c', '6a56509c-ba9b-4761-a8a8-e54d871c5425', 2, '8000', '2021-01-09 22:07:10', '2021-01-09 22:07:10'),
('dcc11931-bf87-4c4e-8291-0bb1e326f5fd', '4c9bf7db-5400-4726-8e63-bbc4024c273a', 2, '8000', '2021-01-09 22:28:37', '2021-01-09 22:28:37'),
('debeface-0203-431a-b47f-0126b0127f32', '6a56509c-ba9b-4761-a8a8-e54d871c5425', 1, '9000', '2021-01-09 22:07:10', '2021-01-09 22:07:10'),
('e0bdb639-4b30-4928-b80d-043f9bb7fed4', '2601e15b-7e81-4ff3-98a5-ed874c1db882', 2, '8000', '2021-01-09 21:07:24', '2021-01-09 21:07:24'),
('e83d7241-78cc-49a7-8676-a9b61873dedb', 'de80d327-b17a-480c-93cc-478c8b1d0765', 1, '9000', '2021-01-09 21:11:00', '2021-01-09 21:11:00'),
('e8643c19-8890-4b7f-8166-0f439e6d449f', '5de5ef68-a880-4d6c-a0bd-5245822a5566', 2, '100', '2021-01-09 22:11:08', '2021-01-09 22:11:08'),
('e96ce2ce-2d9e-46a6-a0eb-6a375020edf0', '4ee87c45-3814-467f-ad7c-8c48a3a6b483', 1, '900', '2021-01-09 22:08:44', '2021-01-09 22:08:44'),
('ee4be9f3-a3d2-49a2-af81-39a1c236c6f6', 'c387fdce-1b69-49fc-984a-1181bea5d3cb', 1, '9000', '2021-01-09 22:16:51', '2021-01-09 22:16:51'),
('f632cc4f-edde-4eca-b08e-daa0570ec97e', 'de80d327-b17a-480c-93cc-478c8b1d0765', 2, '8000', '2021-01-09 21:11:00', '2021-01-09 21:11:00'),
('f646571e-2453-49c2-8e9a-a7a8f6956dc7', 'cc7a2b03-a5ad-46c7-a455-d6504a572bf6', 2, '8000', '2021-01-20 10:42:28', '2021-01-20 10:42:28'),
('fdaa92c6-982c-4642-93b3-74952762cd68', '8545cb6f-249e-41c6-ae05-92322e68a878', 2, '8000', '2021-01-09 21:06:32', '2021-01-09 21:06:32');

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

--
-- Table structure for table `regions`
--

CREATE TABLE `regions` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`id`, `name`, `latitude`, `longitude`, `created_at`, `updated_at`) VALUES
('013db855-45bf-48ed-922d-6ae3a191193c', 'ပဲခူး', '16.84527833333338', '96.13564333333336', '2021-01-13 12:09:47', '2021-01-13 12:09:47'),
('0f081e1f-1f2c-4cb7-b343-bd7c4e87d351', 'ရန်ကုန်', '16.84527833333336', '96.13564333333338', '2021-01-13 12:05:23', '2021-01-13 12:05:23'),
('15960a13-9492-4d2c-ac41-dc13805d167b', 'မန္တလေး', '16.84527833333337', '96.13564333333339', '2021-01-13 12:05:50', '2021-01-13 12:05:50');

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

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

CREATE TABLE `resources` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) 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 `shops`
--

CREATE TABLE `shops` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `township_id` char(36) 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 `shops`
--

INSERT INTO `shops` (`id`, `user_id`, `name`, `address`, `phone`, `latitude`, `longitude`, `region_id`, `township_id`, `created_at`, `updated_at`) VALUES
('5405d22b-1c41-48c7-815b-793cf8b429f2', '978987e6-6dd5-4b6c-b616-e2176d143af2', 'Robin Bike', 'No (101), Thidar street', NULL, NULL, NULL, '0f081e1f-1f2c-4cb7-b343-bd7c4e87d351', '144cda67-9065-4c5e-bd45-aaed8ac2d86d', '2021-01-22 05:05:45', '2021-01-22 05:05:45'),
('9b277f0d-f85a-4384-863f-afce37bd6215', '978987e6-6dd5-4b6c-b616-e2176d143af2', 'Robin Bike', 'No (101), Thidar street', NULL, NULL, NULL, '0f081e1f-1f2c-4cb7-b343-bd7c4e87d351', '144cda67-9065-4c5e-bd45-aaed8ac2d86d', '2021-01-22 06:20:50', '2021-01-22 06:20:50'),
('c1c1e757-e8dc-4fd1-936d-e0a89f32c5ab', '978987e6-6dd5-4b6c-b616-e2176d143af2', 'Robin Bike', 'No (101), Thidar street', NULL, NULL, NULL, '0f081e1f-1f2c-4cb7-b343-bd7c4e87d351', '144cda67-9065-4c5e-bd45-aaed8ac2d86d', '2021-01-24 21:20:41', '2021-01-24 21:20:41'),
('c98ee8a0-14c0-42b6-bf7d-8b8b6b96aeeb', '978987e6-6dd5-4b6c-b616-e2176d143af2', 'Robin Bike', 'No (101), Thidar street', NULL, NULL, NULL, '0f081e1f-1f2c-4cb7-b343-bd7c4e87d351', '144cda67-9065-4c5e-bd45-aaed8ac2d86d', '2021-01-22 06:21:15', '2021-01-22 06:21:15'),
('cac287c1-c8a6-4ddb-aa7b-279e97408485', '978987e6-6dd5-4b6c-b616-e2176d143af2', 'Robin Bike', 'No (101), Thidar street', NULL, NULL, NULL, '0f081e1f-1f2c-4cb7-b343-bd7c4e87d351', '144cda67-9065-4c5e-bd45-aaed8ac2d86d', '2021-01-24 21:19:57', '2021-01-24 21:19:57'),
('cdf3d7db-067e-41b0-a5dd-40b76d94788d', '978987e6-6dd5-4b6c-b616-e2176d143af2', 'Robin Bike', 'No (101), Thidar street', NULL, NULL, NULL, '0f081e1f-1f2c-4cb7-b343-bd7c4e87d351', '144cda67-9065-4c5e-bd45-aaed8ac2d86d', '2021-01-22 05:08:01', '2021-01-22 05:08:01'),
('cffe0fcc-4fd7-4651-bf49-b5716b6b2784', '978987e6-6dd5-4b6c-b616-e2176d143af2', 'Robin Bike', 'No (101), Thidar street', NULL, NULL, NULL, '0f081e1f-1f2c-4cb7-b343-bd7c4e87d351', '144cda67-9065-4c5e-bd45-aaed8ac2d86d', '2021-01-18 21:39:34', '2021-01-18 21:39:34');

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

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) 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 `townships`
--

CREATE TABLE `townships` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `region_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `postal_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_charge` bigint UNSIGNED 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 `townships`
--

INSERT INTO `townships` (`id`, `name`, `region_id`, `postal_code`, `latitude`, `longitude`, `delivery_charge`, `created_at`, `updated_at`) VALUES
('144cda67-9065-4c5e-bd45-aaed8ac2d86d', 'အင်းစိန်', '0f081e1f-1f2c-4cb7-b343-bd7c4e87d351', '1103', '16.84527833333335', '96.13564333333335', 1000, '2021-01-13 12:08:52', '2021-01-13 12:08:52'),
('fe2cfd98-b9db-4276-9711-4e835aaf326c', 'ချမ်းမြသာစည်', '15960a13-9492-4d2c-ac41-dc13805d167b', '1101', '16.84527833333333', '96.13564333333333', 1000, '2021-01-13 12:06:37', '2021-01-13 12:06:37'),
('ff74aa67-d66c-42b6-a168-e8a631276951', 'အောင်မြေသာဇံ', '15960a13-9492-4d2c-ac41-dc13805d167b', '1102', '16.84527833333334', '96.13564333333334', 1500, '2021-01-13 12:07:55', '2021-01-13 12:07:55');

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

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

CREATE TABLE `warehouses` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `region_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `township_id` char(36) 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 `warehouses`
--

INSERT INTO `warehouses` (`id`, `name`, `region_id`, `township_id`, `created_at`, `updated_at`) VALUES
('0b11570b-e594-4c11-8755-aa55f5b0d536', 'အမှတ် (၂)', '15960a13-9492-4d2c-ac41-dc13805d167b', 'fe2cfd98-b9db-4276-9711-4e835aaf326c', '2021-01-20 02:54:37', '2021-01-20 02:54:37'),
('402a5b3b-3ad4-495d-a884-08abf03b24c4', 'အမှတ် (၁)', '0f081e1f-1f2c-4cb7-b343-bd7c4e87d351', '144cda67-9065-4c5e-bd45-aaed8ac2d86d', '2021-01-20 02:50:45', '2021-01-20 02:50:45');

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

--
-- Table structure for table `warehouse_contact_points`
--

CREATE TABLE `warehouse_contact_points` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `warehouse_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` 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;

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

--
-- Table structure for table `warehouse_loading`
--

CREATE TABLE `warehouse_loading` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `warehouse_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_products` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_parts` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `loaded_at` datetime 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 `warehouse_loading`
--

INSERT INTO `warehouse_loading` (`id`, `warehouse_id`, `code`, `total_products`, `total_parts`, `loaded_at`, `created_at`, `updated_at`) VALUES
('657eb037-65ef-4ab5-a4ba-c4d2d34389f0', '0b11570b-e594-4c11-8755-aa55f5b0d536', 'အမှတ် (၂) (၂၀၂၁-၀၁-၂၇/၁၂-၄၇)', '300', '300', NULL, '2021-01-27 06:17:22', '2021-01-27 06:17:22'),
('65fa4729-939e-4d64-85a2-332a7881e8a5', '402a5b3b-3ad4-495d-a884-08abf03b24c4', 'အမှတ် (၁) (၂၀၂၁-၀၁-၂၇/၂၂-၀၄)', '20', '20', '2021-01-27 22:04:00', '2021-01-27 15:34:36', '2021-01-27 15:34:36'),
('8392ed66-651a-4737-94ec-caca6f8d577a', '402a5b3b-3ad4-495d-a884-08abf03b24c4', 'အမှတ် (၁) (၂၀၂၁-၀၁-၂၅/၁၇-၂၂)', '100', '100', NULL, '2021-01-25 10:52:43', '2021-01-25 10:52:43'),
('dda1d9b5-2545-4fa8-9404-80360f5ccc17', '0b11570b-e594-4c11-8755-aa55f5b0d536', 'အမှတ် (၂) (၂၀၂၁-၀၁-၂၅/၁၇-၂၃)', '10', '10', NULL, '2021-01-25 10:53:42', '2021-01-25 10:53:42'),
('f554013d-9a4e-413f-8730-460c51772c70', '402a5b3b-3ad4-495d-a884-08abf03b24c4', 'အမှတ် (၁) (၂၀၂၁-၀၁-၂၅/၂၃-၅၄)', '100', '100', NULL, '2021-01-25 17:24:29', '2021-01-25 17:24:29');

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

--
-- Table structure for table `warehouse_loading_parts`
--

CREATE TABLE `warehouse_loading_parts` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `warehouse_loading_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `part_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_parts` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remaining_parts` varchar(255) 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 `warehouse_loading_parts`
--

INSERT INTO `warehouse_loading_parts` (`id`, `warehouse_loading_id`, `part_id`, `total_parts`, `remaining_parts`, `created_at`, `updated_at`) VALUES
('0e6735f7-b6cb-4721-9858-98bd315dc640', '8392ed66-651a-4737-94ec-caca6f8d577a', '6bcf1b05-b166-4ec4-baef-e6c96a460174', '100', '100', '2021-01-25 10:52:43', '2021-01-25 10:52:43'),
('1d356d5e-e65f-4f08-ab0d-95f2829194d8', 'f554013d-9a4e-413f-8730-460c51772c70', '6bcf1b05-b166-4ec4-baef-e6c96a460174', '100', '100', '2021-01-25 17:24:29', '2021-01-25 17:24:29'),
('3b0aa49e-04b6-4f82-ad54-7c586c8d629e', '65fa4729-939e-4d64-85a2-332a7881e8a5', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', '10', '10', '2021-01-27 15:34:36', '2021-01-27 15:34:36'),
('4033fcb4-bc5e-428c-b55d-e20585c66e05', '657eb037-65ef-4ab5-a4ba-c4d2d34389f0', 'bc0abcbf-7a7f-4c3a-90ef-b0796b25b2cd', '100', '100', '2021-01-27 06:17:23', '2021-01-27 06:17:23'),
('4604036d-2b9d-43e6-bc46-855fe7248240', '65fa4729-939e-4d64-85a2-332a7881e8a5', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', '10', '10', '2021-01-27 15:34:36', '2021-01-27 15:34:36'),
('4f324c5c-23af-44b5-a6dc-89158f58f95b', '657eb037-65ef-4ab5-a4ba-c4d2d34389f0', 'ac2098e4-f3f4-41d9-880a-a7b53ed41a71', '100', '100', '2021-01-27 06:17:23', '2021-01-27 06:17:23'),
('6c92dced-4dc7-40f7-aa19-d55d8281dd8d', '657eb037-65ef-4ab5-a4ba-c4d2d34389f0', '6bcf1b05-b166-4ec4-baef-e6c96a460174', '100', '100', '2021-01-27 06:17:23', '2021-01-27 06:17:23'),
('84fadb90-afa5-484b-83ed-225b9d39c5e6', 'dda1d9b5-2545-4fa8-9404-80360f5ccc17', '6bcf1b05-b166-4ec4-baef-e6c96a460174', '10', '10', '2021-01-25 10:53:42', '2021-01-25 10:53:42');

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

--
-- Table structure for table `warehouse_loading_products`
--

CREATE TABLE `warehouse_loading_products` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `warehouse_loading_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_products` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remaining_products` varchar(255) 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 `warehouse_loading_products`
--

INSERT INTO `warehouse_loading_products` (`id`, `warehouse_loading_id`, `product_id`, `total_products`, `remaining_products`, `created_at`, `updated_at`) VALUES
('184289f0-41cd-4995-95fa-8c45719fc5bb', '657eb037-65ef-4ab5-a4ba-c4d2d34389f0', 'de80d327-b17a-480c-93cc-478c8b1d0765', '100', '100', '2021-01-27 06:17:23', '2021-01-27 06:17:23'),
('2011079a-94b9-415d-b17a-b04a45747a2c', '65fa4729-939e-4d64-85a2-332a7881e8a5', 'cc7a2b03-a5ad-46c7-a455-d6504a572bf6', '10', '10', '2021-01-27 15:34:36', '2021-01-27 15:34:36'),
('2a2e3c49-c4b0-44f3-9492-d8df4f0ee9c2', '657eb037-65ef-4ab5-a4ba-c4d2d34389f0', '4ee87c45-3814-467f-ad7c-8c48a3a6b483', '100', '100', '2021-01-27 06:17:23', '2021-01-27 06:17:23'),
('2f9e16d1-e544-4a9e-b68e-fe870e414633', '657eb037-65ef-4ab5-a4ba-c4d2d34389f0', 'f5e9b8fe-68e3-4f95-83be-e9e00c1ebb8e', '100', '100', '2021-01-27 06:17:23', '2021-01-27 06:17:23'),
('a6794ee6-dd72-4c32-ab18-17a54caa72a4', '65fa4729-939e-4d64-85a2-332a7881e8a5', '3ab54a6c-293d-45eb-9ebd-04084f2f62a6', '10', '10', '2021-01-27 15:34:36', '2021-01-27 15:34:36'),
('de4d89c0-f27e-4963-bb83-ec26eab374e9', 'dda1d9b5-2545-4fa8-9404-80360f5ccc17', '4c9bf7db-5400-4726-8e63-bbc4024c273a', '10', '10', '2021-01-25 10:53:42', '2021-01-25 10:53:42'),
('e4b1ca2a-f20a-451d-8832-74a34a100d52', 'f554013d-9a4e-413f-8730-460c51772c70', '4ee87c45-3814-467f-ad7c-8c48a3a6b483', '100', '100', '2021-01-25 17:24:29', '2021-01-25 17:24:29'),
('ed969669-b5ad-49f1-93b5-2e956b7fa389', '8392ed66-651a-4737-94ec-caca6f8d577a', '8545cb6f-249e-41c6-ae05-92322e68a878', '100', '100', '2021-01-25 10:52:43', '2021-01-25 10:52:43');

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

--
-- Indexes for table `articles_comments`
--
ALTER TABLE `articles_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `articles_comments_user_id_foreign` (`user_id`),
  ADD KEY `articles_comments_admin_id_foreign` (`admin_id`);

--
-- Indexes for table `article_reactions`
--
ALTER TABLE `article_reactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `article_reactions_user_id_foreign` (`user_id`),
  ADD KEY `article_reactions_article_id_foreign` (`article_id`);

--
-- Indexes for table `carts`
--
ALTER TABLE `carts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `carts_user_id_foreign` (`user_id`);

--
-- Indexes for table `cart_parts`
--
ALTER TABLE `cart_parts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cart_parts_part_id_foreign` (`part_id`),
  ADD KEY `cart_parts_cart_id_part_id_index` (`cart_id`,`part_id`);

--
-- Indexes for table `cart_products`
--
ALTER TABLE `cart_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cart_products_product_id_foreign` (`product_id`),
  ADD KEY `cart_products_cart_id_product_id_index` (`cart_id`,`product_id`);

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

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

--
-- Indexes for table `inventories`
--
ALTER TABLE `inventories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventories_user_id_foreign` (`user_id`);

--
-- Indexes for table `inventory_loading`
--
ALTER TABLE `inventory_loading`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `inventory_loading_code_unique` (`code`),
  ADD KEY `inventory_loading_inventory_id_foreign` (`inventory_id`);

--
-- Indexes for table `inventory_loading_parts`
--
ALTER TABLE `inventory_loading_parts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_loading_parts_inventory_loading_id_foreign` (`inventory_loading_id`),
  ADD KEY `inventory_loading_parts_part_id_foreign` (`part_id`);

--
-- Indexes for table `inventory_loading_products`
--
ALTER TABLE `inventory_loading_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_loading_products_inventory_loading_id_foreign` (`inventory_loading_id`),
  ADD KEY `inventory_loading_products_product_id_foreign` (`product_id`);

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

--
-- Indexes for table `inventory_parts`
--
ALTER TABLE `inventory_parts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_parts_inventory_id_foreign` (`inventory_id`),
  ADD KEY `inventory_parts_part_id_foreign` (`part_id`);

--
-- Indexes for table `inventory_part_sales_records`
--
ALTER TABLE `inventory_part_sales_records`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_part_sales_records_inventory_id_foreign` (`inventory_id`),
  ADD KEY `inventory_part_sales_records_part_id_foreign` (`part_id`);

--
-- Indexes for table `inventory_products`
--
ALTER TABLE `inventory_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_products_inventory_id_foreign` (`inventory_id`),
  ADD KEY `inventory_products_product_id_foreign` (`product_id`);

--
-- Indexes for table `inventory_product_sales_records`
--
ALTER TABLE `inventory_product_sales_records`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_product_sales_records_inventory_id_foreign` (`inventory_id`),
  ADD KEY `inventory_product_sales_records_product_id_foreign` (`product_id`);

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `orders_code_unique` (`code`),
  ADD UNIQUE KEY `orders_cart_id_user_id_unique` (`cart_id`,`user_id`),
  ADD KEY `orders_user_id_foreign` (`user_id`),
  ADD KEY `orders_township_id_foreign` (`township_id`),
  ADD KEY `orders_region_id_foreign` (`region_id`),
  ADD KEY `orders_cart_id_user_id_index` (`cart_id`,`user_id`);

--
-- Indexes for table `order_progress`
--
ALTER TABLE `order_progress`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_progress_order_id_status_unique` (`order_id`,`status`);

--
-- Indexes for table `parts`
--
ALTER TABLE `parts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `parts_valve_number_unique` (`valve_number`),
  ADD KEY `parts_item_id_foreign` (`item_id`);

--
-- Indexes for table `part_images`
--
ALTER TABLE `part_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `part_images_part_id_foreign` (`part_id`);

--
-- Indexes for table `part_prices`
--
ALTER TABLE `part_prices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `part_prices_part_id_foreign` (`part_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_product_number_unique` (`product_number`),
  ADD KEY `products_category_id_foreign` (`category_id`),
  ADD KEY `products_item_id_foreign` (`item_id`);

--
-- Indexes for table `product_images`
--
ALTER TABLE `product_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_images_product_id_foreign` (`product_id`);

--
-- Indexes for table `product_parts`
--
ALTER TABLE `product_parts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `product_parts_product_id_part_id_index` (`product_id`,`part_id`) USING BTREE,
  ADD KEY `product_parts_part_id_foreign` (`part_id`);

--
-- Indexes for table `product_prices`
--
ALTER TABLE `product_prices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_prices_product_id_foreign` (`product_id`);

--
-- Indexes for table `regions`
--
ALTER TABLE `regions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `regions_name_unique` (`name`),
  ADD UNIQUE KEY `regions_latitude_unique` (`latitude`),
  ADD UNIQUE KEY `regions_longitude_unique` (`longitude`);

--
-- Indexes for table `resources`
--
ALTER TABLE `resources`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `resources_name_unique` (`name`),
  ADD UNIQUE KEY `resources_url_unique` (`url`);

--
-- Indexes for table `shops`
--
ALTER TABLE `shops`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shops_user_id_foreign` (`user_id`),
  ADD KEY `shops_region_id_foreign` (`region_id`),
  ADD KEY `shops_township_id_foreign` (`township_id`);

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

--
-- Indexes for table `townships`
--
ALTER TABLE `townships`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `townships_name_unique` (`name`),
  ADD UNIQUE KEY `townships_postal_code_unique` (`postal_code`),
  ADD UNIQUE KEY `townships_latitude_unique` (`latitude`),
  ADD UNIQUE KEY `townships_longitude_unique` (`longitude`),
  ADD KEY `townships_region_id_foreign` (`region_id`);

--
-- Indexes for table `warehouses`
--
ALTER TABLE `warehouses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `warehouses_region_id_foreign` (`region_id`),
  ADD KEY `warehouses_township_id_foreign` (`township_id`);

--
-- Indexes for table `warehouse_contact_points`
--
ALTER TABLE `warehouse_contact_points`
  ADD PRIMARY KEY (`id`),
  ADD KEY `warehouse_contact_points_warehouse_id_foreign` (`warehouse_id`);

--
-- Indexes for table `warehouse_loading`
--
ALTER TABLE `warehouse_loading`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `warehouse_loading_code_unique` (`code`),
  ADD KEY `warehouse_loading_warehouse_id_foreign` (`warehouse_id`);

--
-- Indexes for table `warehouse_loading_parts`
--
ALTER TABLE `warehouse_loading_parts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `warehouse_loading_parts_warehouse_loading_id_foreign` (`warehouse_loading_id`),
  ADD KEY `warehouse_loading_parts_part_id_foreign` (`part_id`);

--
-- Indexes for table `warehouse_loading_products`
--
ALTER TABLE `warehouse_loading_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `warehouse_loading_products_warehouse_loading_id_foreign` (`warehouse_loading_id`),
  ADD KEY `warehouse_loading_products_product_id_foreign` (`product_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `articles_comments`
--
ALTER TABLE `articles_comments`
  ADD CONSTRAINT `articles_comments_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`),
  ADD CONSTRAINT `articles_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `article_reactions`
--
ALTER TABLE `article_reactions`
  ADD CONSTRAINT `article_reactions_article_id_foreign` FOREIGN KEY (`article_id`) REFERENCES `articles` (`id`),
  ADD CONSTRAINT `article_reactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `carts`
--
ALTER TABLE `carts`
  ADD CONSTRAINT `carts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `cart_parts`
--
ALTER TABLE `cart_parts`
  ADD CONSTRAINT `cart_parts_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cart_parts_part_id_foreign` FOREIGN KEY (`part_id`) REFERENCES `parts` (`id`);

--
-- Constraints for table `cart_products`
--
ALTER TABLE `cart_products`
  ADD CONSTRAINT `cart_products_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cart_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `category_designs`
--
ALTER TABLE `category_designs`
  ADD CONSTRAINT `category_designs_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`);

--
-- Constraints for table `inventories`
--
ALTER TABLE `inventories`
  ADD CONSTRAINT `inventories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `inventory_loading`
--
ALTER TABLE `inventory_loading`
  ADD CONSTRAINT `inventory_loading_inventory_id_foreign` FOREIGN KEY (`inventory_id`) REFERENCES `inventories` (`id`);

--
-- Constraints for table `inventory_loading_parts`
--
ALTER TABLE `inventory_loading_parts`
  ADD CONSTRAINT `inventory_loading_parts_inventory_loading_id_foreign` FOREIGN KEY (`inventory_loading_id`) REFERENCES `inventory_loading` (`id`),
  ADD CONSTRAINT `inventory_loading_parts_part_id_foreign` FOREIGN KEY (`part_id`) REFERENCES `parts` (`id`);

--
-- Constraints for table `inventory_loading_products`
--
ALTER TABLE `inventory_loading_products`
  ADD CONSTRAINT `inventory_loading_products_inventory_loading_id_foreign` FOREIGN KEY (`inventory_loading_id`) REFERENCES `inventory_loading` (`id`),
  ADD CONSTRAINT `inventory_loading_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `inventory_parts`
--
ALTER TABLE `inventory_parts`
  ADD CONSTRAINT `inventory_parts_inventory_id_foreign` FOREIGN KEY (`inventory_id`) REFERENCES `inventories` (`id`),
  ADD CONSTRAINT `inventory_parts_part_id_foreign` FOREIGN KEY (`part_id`) REFERENCES `parts` (`id`);

--
-- Constraints for table `inventory_part_sales_records`
--
ALTER TABLE `inventory_part_sales_records`
  ADD CONSTRAINT `inventory_part_sales_records_inventory_id_foreign` FOREIGN KEY (`inventory_id`) REFERENCES `inventories` (`id`),
  ADD CONSTRAINT `inventory_part_sales_records_part_id_foreign` FOREIGN KEY (`part_id`) REFERENCES `parts` (`id`);

--
-- Constraints for table `inventory_products`
--
ALTER TABLE `inventory_products`
  ADD CONSTRAINT `inventory_products_inventory_id_foreign` FOREIGN KEY (`inventory_id`) REFERENCES `inventories` (`id`),
  ADD CONSTRAINT `inventory_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `inventory_product_sales_records`
--
ALTER TABLE `inventory_product_sales_records`
  ADD CONSTRAINT `inventory_product_sales_records_inventory_id_foreign` FOREIGN KEY (`inventory_id`) REFERENCES `inventories` (`id`),
  ADD CONSTRAINT `inventory_product_sales_records_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`),
  ADD CONSTRAINT `orders_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`),
  ADD CONSTRAINT `orders_township_id_foreign` FOREIGN KEY (`township_id`) REFERENCES `townships` (`id`),
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

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

--
-- Constraints for table `parts`
--
ALTER TABLE `parts`
  ADD CONSTRAINT `parts_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`);

--
-- Constraints for table `part_images`
--
ALTER TABLE `part_images`
  ADD CONSTRAINT `part_images_part_id_foreign` FOREIGN KEY (`part_id`) REFERENCES `parts` (`id`);

--
-- Constraints for table `part_prices`
--
ALTER TABLE `part_prices`
  ADD CONSTRAINT `part_prices_part_id_foreign` FOREIGN KEY (`part_id`) REFERENCES `parts` (`id`);

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  ADD CONSTRAINT `products_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`);

--
-- Constraints for table `product_images`
--
ALTER TABLE `product_images`
  ADD CONSTRAINT `product_images_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `product_parts`
--
ALTER TABLE `product_parts`
  ADD CONSTRAINT `product_parts_part_id_foreign` FOREIGN KEY (`part_id`) REFERENCES `parts` (`id`),
  ADD CONSTRAINT `product_parts_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `product_prices`
--
ALTER TABLE `product_prices`
  ADD CONSTRAINT `product_prices_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `shops`
--
ALTER TABLE `shops`
  ADD CONSTRAINT `shops_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`),
  ADD CONSTRAINT `shops_township_id_foreign` FOREIGN KEY (`township_id`) REFERENCES `townships` (`id`),
  ADD CONSTRAINT `shops_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `townships`
--
ALTER TABLE `townships`
  ADD CONSTRAINT `townships_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`);

--
-- Constraints for table `warehouses`
--
ALTER TABLE `warehouses`
  ADD CONSTRAINT `warehouses_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`),
  ADD CONSTRAINT `warehouses_township_id_foreign` FOREIGN KEY (`township_id`) REFERENCES `townships` (`id`);

--
-- Constraints for table `warehouse_contact_points`
--
ALTER TABLE `warehouse_contact_points`
  ADD CONSTRAINT `warehouse_contact_points_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`);

--
-- Constraints for table `warehouse_loading`
--
ALTER TABLE `warehouse_loading`
  ADD CONSTRAINT `warehouse_loading_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`);

--
-- Constraints for table `warehouse_loading_parts`
--
ALTER TABLE `warehouse_loading_parts`
  ADD CONSTRAINT `warehouse_loading_parts_part_id_foreign` FOREIGN KEY (`part_id`) REFERENCES `parts` (`id`),
  ADD CONSTRAINT `warehouse_loading_parts_warehouse_loading_id_foreign` FOREIGN KEY (`warehouse_loading_id`) REFERENCES `warehouse_loading` (`id`);

--
-- Constraints for table `warehouse_loading_products`
--
ALTER TABLE `warehouse_loading_products`
  ADD CONSTRAINT `warehouse_loading_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  ADD CONSTRAINT `warehouse_loading_products_warehouse_loading_id_foreign` FOREIGN KEY (`warehouse_loading_id`) REFERENCES `warehouse_loading` (`id`);
COMMIT;

