-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Mar 16, 2021 at 12:57 PM
-- Server version: 5.7.33
-- PHP Version: 7.3.26

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


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

--
-- Database: `mitalibd_obs`
--

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

--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` int(11) NOT NULL,
  `name_eng` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_local` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `warehouse_id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=on/2=off',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_categories`
--

INSERT INTO `product_categories` (`id`, `code`, `name_eng`, `name_local`, `parent_id`, `warehouse_id`, `status`, `created_by`, `updated_by`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 100, 'Cat - 1', NULL, NULL, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(2, 200, 'Cat - 2', NULL, NULL, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(3, 1, 'Raw Material', 'Raw Material', NULL, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 19:12:30', '2021-02-22 19:12:30'),
(4, 101, 'Raw', 'Raw', 3, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 19:56:39', '2021-02-22 19:56:39'),
(5, 102, 'Packaging', 'Packaging', 3, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 19:57:04', '2021-02-22 19:57:04'),
(6, 103, 'Banolata', 'Banolata', 3, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 19:57:17', '2021-02-22 19:57:17'),
(7, 10101, 'Spice', 'Spice', 4, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 19:57:36', '2021-02-22 19:57:36'),
(8, 10102, 'Milk powder', 'Milk powder', 4, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 19:57:53', '2021-02-22 19:57:53'),
(9, 10103, 'Fat Oil', 'Fat Oil', 4, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 19:58:03', '2021-02-22 19:58:03'),
(10, 10104, 'Flavor', 'Flavor', 4, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 19:58:19', '2021-02-22 19:58:19'),
(11, 10105, 'Raw Materials', 'Raw Materials', 4, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 19:58:41', '2021-02-22 19:58:41'),
(12, 10106, 'Food Color', 'Food Color', 4, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 19:58:52', '2021-02-22 19:58:52'),
(13, 10107, 'Food Chemical', 'Food Chemical', 4, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 19:59:02', '2021-02-22 19:59:02'),
(14, 10108, 'Sauce', 'Sauce', 4, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 19:59:13', '2021-02-22 19:59:13'),
(15, 10201, 'Stationary', 'Stationary', 5, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:00:32', '2021-02-22 20:00:32'),
(16, 10202, 'Maintenance', 'Maintenance', 5, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:00:58', '2021-02-22 20:00:58'),
(17, 10203, 'Tissue', 'Tissue', 5, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:01:29', '2021-02-22 20:01:29'),
(18, 10204, 'Cartoon', 'Cartoon', 5, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:01:50', '2021-02-22 20:01:50'),
(19, 10212, 'Pouch Pack', 'Pouch Pack', 5, 1, 1, 1, 1, NULL, NULL, '2021-02-22 20:02:07', '2021-02-22 20:37:11'),
(20, 10205, 'Tray', 'Tray', 5, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:02:18', '2021-02-22 20:02:18'),
(21, 10206, 'Biscuits Box', 'Biscuits Box', 5, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:02:35', '2021-02-22 20:02:35'),
(22, 10207, 'Label & Sticker', 'Label & Sticker', 5, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:02:47', '2021-02-22 20:02:47'),
(23, 10208, 'BATI', 'BATI', 5, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:03:16', '2021-02-22 20:03:16'),
(24, 10209, 'Others', 'Others', 5, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:03:25', '2021-02-22 20:03:25'),
(25, 10210, 'D Cake box', 'D Cake box', 5, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:03:34', '2021-02-22 20:03:34'),
(26, 10211, 'Jar', 'Jar', 5, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:03:46', '2021-02-22 20:03:46'),
(27, 10301, 'Box', 'Box', 6, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:04:30', '2021-02-22 20:04:30'),
(28, 10302, 'Packet', 'Packet', 6, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:04:46', '2021-02-22 20:04:46'),
(29, 10303, 'Bag', 'Bag', 6, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:04:58', '2021-02-22 20:04:58'),
(30, 200, 'Finished Goods', 'Finished Goods', NULL, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:05:52', '2021-02-22 20:05:52'),
(31, 20001, 'Normal', 'Normal', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:06:10', '2021-02-22 20:06:10'),
(32, 20002, 'Special', 'Special', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:06:20', '2021-02-22 20:06:20'),
(33, 20003, 'Doi & SP/Dry', 'Doi & SP/Dry', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:07:01', '2021-02-22 20:07:01'),
(34, 20004, 'Bread & Bun', 'Bread & Bun', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:07:12', '2021-02-22 20:07:12'),
(35, 20005, 'Snacks', 'Snacks', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:07:33', '2021-02-22 20:07:33'),
(36, 20006, 'Biscuit', 'Biscuit', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:07:45', '2021-02-22 20:07:45'),
(37, 20007, 'Dry Sweets', 'Dry Sweets', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:07:56', '2021-02-22 20:07:56'),
(38, 20008, 'Cake', 'Cake', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:08:15', '2021-02-22 20:08:15'),
(39, 20009, 'Sonargau Item', 'Sonargau Item', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:12:01', '2021-02-22 20:12:01'),
(40, 20010, 'Iftari', 'Iftari', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:12:11', '2021-02-22 20:12:11'),
(41, 20011, 'Halim & Biriani', 'Halim & Biriani', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:12:23', '2021-02-22 20:12:23'),
(42, 20012, 'Firni', 'Firni', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:12:33', '2021-02-22 20:12:33'),
(43, 20013, 'Class Food', 'Class Food', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:12:41', '2021-02-22 20:12:41'),
(44, 20014, 'Fast Food', 'Fast Food', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:12:50', '2021-02-22 20:12:50'),
(45, 20015, 'Not Active', 'Not Active', 30, 1, 1, 1, NULL, NULL, NULL, '2021-02-22 20:13:01', '2021-02-22 20:13:01'),
(46, 100, 'TestC', 'TestCl', NULL, 1, 1, 2, NULL, NULL, NULL, '2021-03-15 16:38:28', '2021-03-15 16:38:28'),
(47, 101, 'TestCategoryName', 'TestLocalCategory', NULL, 1, 1, 2, NULL, NULL, NULL, '2021-03-15 16:40:33', '2021-03-15 16:40:33'),
(48, 10101, 'TestSub1', 'TestSub1L', 47, 1, 1, 2, NULL, NULL, NULL, '2021-03-15 16:43:08', '2021-03-15 16:43:08'),
(49, 1010101, 'TestSub_Sub1', 'TestSub_Sub1L', 48, 1, 1, 2, NULL, NULL, NULL, '2021-03-15 16:45:43', '2021-03-15 16:45:43');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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