 INSERT INTO `roles` (`id`, `role_name`, `created_at`, `updated_at`) VALUES
 (1, 'Admin', NULL, NULL),
 (2, 'Users', NULL, NULL);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `suppliers`
+--
+
+CREATE TABLE `suppliers` (
+  `id` int(10) UNSIGNED NOT NULL,
+  `sup_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `sup_fullname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `sup_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `sup_phone` int(11) DEFAULT NULL,
+  `sup_address` text COLLATE utf8mb4_unicode_ci,
+  `key_person` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `sup_image` 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;
 
 -- --------------------------------------------------------
 

(4, '2017_10_07_092102_create_menus_table', 2),
(10, '2017_10_07_110820_create_item_types_table', 3),
(16, '2017_10_07_110933_create_item_categories_table', 4),
(17, '2017_10_07_133115_create_items_table', 4);

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


-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 10, 2017 at 09:55 PM
-- Server version: 5.7.11
-- PHP Version: 7.0.3

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