-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Versión del servidor:         5.7.19 - MySQL Community Server (GPL)
-- SO del servidor:              Win64
-- HeidiSQL Versión:             9.5.0.5196
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Volcando estructura para tabla chefburger.menu
DROP TABLE IF EXISTS `menu`;
CREATE TABLE IF NOT EXISTS `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `parent` int(11) DEFAULT NULL,
  `route` varchar(255) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`),
  CONSTRAINT `menu_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `menu` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- Volcando datos para la tabla chefburger.menu: ~15 rows (aproximadamente)
DELETE FROM `menu`;
/*!40000 ALTER TABLE `menu` DISABLE KEYS */;
INSERT INTO `menu` (`id`, `name`, `parent`, `route`, `order`, `data`) VALUES
	(1, 'Configuración', NULL, NULL, 99, _binary 0x636F6773),
	(2, 'Menú', 1, '/admin/menu/index', 1, _binary 0x62617273),
	(3, 'Roles', 1, '/admin/role/index', 2, _binary 0x7573657273),
	(4, 'Asiganción', 1, '/admin/assignment/index', NULL, _binary 0x757365722D706C7573),
	(5, 'Rutas', 1, '/admin/route/index', NULL, _binary 0x65786368616E6765),
	(6, 'Permisos', 1, '/admin/permission/index', NULL, _binary 0x6375626573),
	(7, 'Usuarios', 1, '/admin/user/index', NULL, _binary 0x75736572),
	(12, 'Listar requisiciones', 18, '/requisition/index', 2, _binary 0x6C6973742D6F6C),
	(13, 'Crear requisición', 18, '/requisition/create', 2, _binary 0x706C7573),
	(14, 'Puntos de venta', NULL, '/configpdv/index', 3, _binary 0x686F6D65),
	(15, 'Usuarios - PDV', NULL, '/usrpdv/index', 4, _binary 0x757365722D706C7573),
	(16, 'Entradas', NULL, NULL, NULL, _binary 0x6172726F772D636972636C652D7570),
	(17, 'Crear entrada', 16, '/entry/create', NULL, _binary 0x706C7573),
	(18, 'Requisiciones', NULL, NULL, NULL, _binary 0x65786368616E6765),
	(19, 'Listar entradas', 16, '/entry/index', 1, _binary 0x6C6973742D6F6C);
/*!40000 ALTER TABLE `menu` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
