text: -- phpMyAdmin SQL Dump
  -- version 4.8.4
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Feb 08, 2019 at 10:01 AM
  -- Server version: 10.1.37-MariaDB
  -- PHP Version: 7.3.1
  
  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: `zamanstore`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `migrations`
  --
  
  CREATE TABLE `migrations` (
    `id` int(10) UNSIGNED NOT NULL,
    `migration` varchar(255) COLLATE utf8mb4_unicode_ci 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, '2018_07_05_095304_create_tbl_admin_table', 1),
  (2, '2018_07_07_052749_create_tbl_category_table', 1),
  (3, '2018_07_08_092619_create_tbl_manufacture_table', 1),
  (4, '2018_07_10_052631_create_tbl_products_table', 1),
  (5, '2018_07_12_115319_create_tbl_slider_table', 1),
  (6, '2018_07_18_202731_create_tbl_customer_table', 1),
  (7, '2018_07_19_155157_create_tbl_shipping_table', 1),
  (8, '2018_07_21_103710_create_tbl_order_table', 1),
  (9, '2018_07_21_103952_create_tbl_payment_table', 1),
  (10, '2018_07_21_104039_create_tbl_order_details_table', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_admin`
  --
  
  CREATE TABLE `tbl_admin` (
    `admin_id` int(10) UNSIGNED NOT NULL,
    `admin_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `admin_password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `admin_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `admin_phone` 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 `tbl_admin`
  --
  
  INSERT INTO `tbl_admin` (`admin_id`, `admin_email`, `admin_password`, `admin_name`, `admin_phone`, `created_at`, `updated_at`) VALUES
  (1, 'admin@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 'Syed Zaman Mostafiz', '01740301579', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_category`
  --
  
  CREATE TABLE `tbl_category` (
    `category_id` int(10) UNSIGNED NOT NULL,
    `category_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `category_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `publication_status` int(11) 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 `tbl_category`
  --
  
  INSERT INTO `tbl_category` (`category_id`, `category_name`, `category_description`, `publication_status`, `created_at`, `updated_at`) VALUES
  (1, 'Mulberry', 'Mulberry Category<br>', 1, NULL, NULL),
  (2, 'Black Berry', 'Black Berry Category<br>', 1, NULL, NULL),
  (3, 'Tree', 'Tree', 1, NULL, NULL),
  (4, 'Green Tree', 'Green Tree<br>', 1, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_customer`
  --
  
  CREATE TABLE `tbl_customer` (
    `customer_id` int(10) UNSIGNED NOT NULL,
    `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `customer_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `mobile_number` 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 `tbl_customer`
  --
  
  INSERT INTO `tbl_customer` (`customer_id`, `customer_name`, `customer_email`, `password`, `mobile_number`, `created_at`, `updated_at`) VALUES
  (1, 'Syed Zaman Mostafiz', 'zamancsediue44@gmail.com', '202cb962ac59075b964b07152d234b70', '01740301579', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_manufacture`
  --
  
  CREATE TABLE `tbl_manufacture` (
    `manufacture_id` int(10) UNSIGNED NOT NULL,
    `manufacture_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `manufacture_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `publication_status` 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 `tbl_manufacture`
  --
  
  INSERT INTO `tbl_manufacture` (`manufacture_id`, `manufacture_name`, `manufacture_description`, `publication_status`, `created_at`, `updated_at`) VALUES
  (1, 'Tree', 'Tree', '1', NULL, NULL),
  (2, 'Green Tree', 'Green Tree<br>', '1', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_order`
  --
  
  CREATE TABLE `tbl_order` (
    `order_id` int(10) UNSIGNED NOT NULL,
    `customer_id` int(11) NOT NULL,
    `shipping_id` int(11) NOT NULL,
    `payment_id` int(11) NOT NULL,
    `order_total` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `order_status` int(11) 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 `tbl_order_details`
  --
  
  CREATE TABLE `tbl_order_details` (
    `order_details_id` int(10) UNSIGNED NOT NULL,
    `order_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `product_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `product_price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `product_sales_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 `tbl_payment`
  --
  
  CREATE TABLE `tbl_payment` (
    `payment_id` int(10) UNSIGNED NOT NULL,
    `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `tbl_payment`
  --
  
  INSERT INTO `tbl_payment` (`payment_id`, `payment_method`, `payment_status`, `created_at`, `updated_at`) VALUES
  (5, 'handcash', 'pending', '2019-02-07 03:41:13', '2019-02-07 03:41:13');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_products`
  --
  
  CREATE TABLE `tbl_products` (
    `product_id` int(10) UNSIGNED NOT NULL,
    `product_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `category_id` int(11) NOT NULL,
    `manufacture_id` int(11) NOT NULL,
    `product_short_description` longtext COLLATE utf8mb4_unicode_ci,
    `product_long_description` longtext COLLATE utf8mb4_unicode_ci,
    `product_price` double(8,2) NOT NULL,
    `product_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `product_size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `product_color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `publication_status` int(11) 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 `tbl_products`
  --
  
  INSERT INTO `tbl_products` (`product_id`, `product_name`, `category_id`, `manufacture_id`, `product_short_description`, `product_long_description`, `product_price`, `product_image`, `product_size`, `product_color`, `publication_status`, `created_at`, `updated_at`) VALUES
  (1, 'tree', 3, 1, 'Tree', 'tree', 100.00, 'images/SD5aDMXnG7Nf0pERVMRP.png', 'None', 'Green', 1, NULL, NULL),
  (2, 'Fig Tree', 3, 1, 'Fig Tree<br>', '<br>', 200.00, 'images/YtvipB2vxiVJmMr41syU.png', 'None', 'Green', 1, NULL, NULL),
  (3, 'Strawberry', 3, 1, 'Strawberry', 'Strawberry Strawberry', 300.00, 'images/lfPQQA7Fe0zhmb25TKxi.png', NULL, NULL, 1, NULL, NULL),
  (4, 'Guava Tree', 4, 2, '<br>', '<br>', 400.00, 'images/DBvD3yCbhs1pGHFyB5vi.png', NULL, NULL, 1, NULL, NULL),
  (5, 'Apple Tree', 3, 1, '<br>', '<br>', 500.00, 'images/mOZzsDSjV7UkvJZY0boH.png', NULL, NULL, 1, NULL, NULL),
  (6, 'Propiedades', 4, 2, 'Propiedades', 'Propiedades Propiedades<br>', 600.00, 'images/6AvCrzDqsPibmrYcRkic.png', NULL, NULL, 1, NULL, NULL),
  (7, 'Best Cherry', 4, 2, '<br>', '<br>', 700.00, 'images/xtGVUb5hF1q8n0w6qnKQ.png', NULL, NULL, 1, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_shipping`
  --
  
  CREATE TABLE `tbl_shipping` (
    `shipping_id` int(10) UNSIGNED NOT NULL,
    `shipping_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `shipping_first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `shipping_last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `shipping_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `shipping_mobile_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `shipping_city` 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 `tbl_shipping`
  --
  
  INSERT INTO `tbl_shipping` (`shipping_id`, `shipping_email`, `shipping_first_name`, `shipping_last_name`, `shipping_address`, `shipping_mobile_number`, `shipping_city`, `created_at`, `updated_at`) VALUES
  (1, 'irin@gmail.com', 'irin', 'Mostafiz', 'Balubari', '01740301577', 'Dinajpur', NULL, NULL),
  (2, 'irin@gmail.com', 'Irin', 'Mostafiz', 'Balubari', '01740301577', 'Dinajpur', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_slider`
  --
  
  CREATE TABLE `tbl_slider` (
    `slider_id` int(10) UNSIGNED NOT NULL,
    `slider_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `publication_status` 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;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `tbl_admin`
  --
  ALTER TABLE `tbl_admin`
    ADD PRIMARY KEY (`admin_id`);
  
  --
  -- Indexes for table `tbl_category`
  --
  ALTER TABLE `tbl_category`
    ADD PRIMARY KEY (`category_id`);
  
  --
  -- Indexes for table `tbl_customer`
  --
  ALTER TABLE `tbl_customer`
    ADD PRIMARY KEY (`customer_id`);
  
  --
  -- Indexes for table `tbl_manufacture`
  --
  ALTER TABLE `tbl_manufacture`
    ADD PRIMARY KEY (`manufacture_id`);
  
  --
  -- Indexes for table `tbl_order`
  --
  ALTER TABLE `tbl_order`
    ADD PRIMARY KEY (`order_id`);
  
  --
  -- Indexes for table `tbl_order_details`
  --
  ALTER TABLE `tbl_order_details`
    ADD PRIMARY KEY (`order_details_id`);
  
  --
  -- Indexes for table `tbl_payment`
  --
  ALTER TABLE `tbl_payment`
    ADD PRIMARY KEY (`payment_id`);
  
  --
  -- Indexes for table `tbl_products`
  --
  ALTER TABLE `tbl_products`
    ADD PRIMARY KEY (`product_id`);
  
  --
  -- Indexes for table `tbl_shipping`
  --
  ALTER TABLE `tbl_shipping`
    ADD PRIMARY KEY (`shipping_id`);
  
  --
  -- Indexes for table `tbl_slider`
  --
  ALTER TABLE `tbl_slider`
    ADD PRIMARY KEY (`slider_id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  
  --
  -- AUTO_INCREMENT for table `tbl_admin`
  --
  ALTER TABLE `tbl_admin`
    MODIFY `admin_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `tbl_category`
  --
  ALTER TABLE `tbl_category`
    MODIFY `category_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `tbl_customer`
  --
  ALTER TABLE `tbl_customer`
    MODIFY `customer_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `tbl_manufacture`
  --
  ALTER TABLE `tbl_manufacture`
    MODIFY `manufacture_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `tbl_order`
  --
  ALTER TABLE `tbl_order`
    MODIFY `order_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `tbl_order_details`
  --
  ALTER TABLE `tbl_order_details`
    MODIFY `order_details_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `tbl_payment`
  --
  ALTER TABLE `tbl_payment`
    MODIFY `payment_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `tbl_products`
  --
  ALTER TABLE `tbl_products`
    MODIFY `product_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- AUTO_INCREMENT for table `tbl_shipping`
  --
  ALTER TABLE `tbl_shipping`
    MODIFY `shipping_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `tbl_slider`
  --
  ALTER TABLE `tbl_slider`
    MODIFY `slider_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  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 */;
  