--
-- Host: localhost    Database: morbach
-- ------------------------------------------------------


--
-- Table structure for table `categorias`
--

CREATE TABLE `categorias` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categorias`
--

INSERT INTO `categorias` VALUES (1,'xxxxx','ativo','2017-10-24 02:43:51','2017-10-24 02:43:51');

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

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (15,'2014_10_12_000000_create_users_table',1),(16,'2014_10_12_100000_create_password_resets_table',1),(17,'2017_10_09_234559_create_produtos_table',1),(18,'2017_10_11_020731_create_pedidos_table',1),(19,'2017_10_15_233348_create_produto_pedidos_table',1),(20,'2017_10_21_000446_create_categorias_table',1);

--
-- Table structure for table `pedidos`
--

CREATE TABLE `pedidos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cliente_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pedidos`
--

INSERT INTO `pedidos` VALUES (1,'1','2017-10-24 02:47:30','2017-10-24 02:47:30'),(2,'1','2017-10-24 03:35:40','2017-10-24 03:35:40');

--
-- Table structure for table `produto_pedidos`
--

CREATE TABLE `produto_pedidos` (
  `pedido_id` int(11) NOT NULL,
  `produto` int(11) NOT NULL,
  `quantidade` 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;

--
-- Dumping data for table `produto_pedidos`
--

INSERT INTO `produto_pedidos` VALUES (1,1,1,'2017-10-24 02:47:31','2017-10-24 02:47:31'),(2,2,1,'2017-10-24 03:35:40','2017-10-24 03:35:40'),(2,1,1,'2017-10-24 03:35:40','2017-10-24 03:35:40');

--
-- Table structure for table `produtos`
--

CREATE TABLE `produtos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categoria` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descricao` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `imagem` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `produtos`
--

INSERT INTO `produtos` VALUES (1,'xxxxxxq','1','qqqqqqqq','79650-memedio.jpg','ativo','2017-10-24 02:44:08','2017-10-24 02:44:08'),(2,'ssss','1','qqqqqq','14430-demais.png','ativo','2017-10-24 02:44:42','2017-10-24 02:44:42');


