--
-- Host: localhost    Database: hershey
-- ------------------------------------------------------


--
-- Table structure for table `tbl_administradores_permisos`
--

CREATE TABLE `tbl_administradores_permisos` (
  `pk_permiso` int(11) NOT NULL AUTO_INCREMENT,
  `permiso` varchar(255) DEFAULT NULL,
  `fk_estatus` int(11) DEFAULT '1',
  PRIMARY KEY (`pk_permiso`),
  UNIQUE KEY `pk_permiso` (`pk_permiso`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tbl_administradores_permisos`
--

INSERT INTO `tbl_administradores_permisos` VALUES (1,'Administrators',1),(2,'Banners',1),(3,'Banners zones',1),(4,'Categories',1),(5,'Celebrities',1),(6,'Customers',1),(7,'Colors',1),(8,'Couriers',1),(9,'Editorial',1),(10,'Events',1),(11,'Orders',1),(12,'Products',1),(13,'-',0),(14,'-',0),(15,'-',0),(16,'-',0);

--
-- Table structure for table `tbl_administradores_vs_permisos`
--

CREATE TABLE `tbl_administradores_vs_permisos` (
  `pk_admin_vs_permiso` int(11) NOT NULL AUTO_INCREMENT,
  `fk_administrador` int(11) DEFAULT '0',
  `fk_permiso` int(11) DEFAULT '0',
  `fk_estatus` int(11) DEFAULT '1',
  UNIQUE KEY `pk_admin_vs_permiso` (`pk_admin_vs_permiso`),
  KEY `fk_administrador` (`fk_administrador`),
  KEY `fk_permiso` (`fk_permiso`)
) ENGINE=MyISAM AUTO_INCREMENT=204 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;

--
-- Dumping data for table `tbl_administradores_vs_permisos`
--

INSERT INTO `tbl_administradores_vs_permisos` VALUES (1,1,1,0),(2,1,1,0),(3,1,4,0),(4,1,4,0),(5,1,1,0),(6,1,4,0),(7,1,2,0),(8,1,3,0),(9,1,5,0),(10,1,6,0),(11,1,7,0),(12,1,8,0),(13,1,1,0),(14,1,4,0),(15,1,2,0),(16,1,3,0),(17,1,5,0),(18,1,6,0),(19,1,7,0),(20,1,8,0),(21,1,1,0),(22,1,4,0),(23,1,2,0),(24,1,3,0),(25,1,5,0),(26,1,6,0),(27,1,7,0),(28,1,8,0),(29,1,1,0),(30,1,4,0),(31,1,2,0),(32,1,3,0),(33,1,5,0),(34,1,6,0),(35,1,7,0),(36,1,8,0),(37,1,9,0),(38,1,10,0),(39,1,1,0),(40,1,4,0),(41,1,2,0),(42,1,3,0),(43,1,5,0),(44,1,6,0),(45,1,7,0),(46,1,8,0),(47,1,9,0),(48,1,10,0),(49,1,11,0),(50,1,12,0),(51,1,13,0),(52,1,14,0),(53,1,15,0),(54,1,16,0),(55,2,1,0),(56,2,2,0),(57,2,3,0),(58,2,4,0),(59,2,1,0),(60,2,2,0),(61,2,3,0),(62,3,3,1),(63,3,4,1),(64,3,1,1),(65,3,2,1),(66,2,4,0),(67,4,1,0),(68,4,2,0),(69,4,3,0),(70,4,4,0),(71,2,1,1),(72,2,2,1),(73,2,3,1),(74,2,4,1),(75,2,6,1),(76,2,5,1),(77,4,1,0),(78,4,2,0),(79,4,3,0),(80,4,4,0),(81,4,5,0),(82,4,1,1),(83,4,2,1),(84,4,3,1),(85,4,4,1),(86,4,5,1),(87,4,6,1),(88,1,1,0),(89,1,2,0),(90,1,3,0),(91,1,4,0),(92,1,5,0),(93,1,1,0),(94,1,1,0),(95,1,4,0),(96,1,1,0),(97,1,4,0),(98,1,1,0),(99,1,4,0),(100,1,2,0),(101,1,1,0),(102,1,4,0),(103,1,2,0),(104,1,1,0),(105,1,4,0),(106,1,2,0),(107,1,1,0),(108,1,4,0),(109,1,2,0),(110,5,5,1),(111,5,4,1),(112,5,3,1),(113,5,2,1),(114,5,1,1),(115,6,5,0),(116,6,4,0),(117,6,3,0),(118,6,5,0),(119,6,4,0),(120,6,3,0),(121,6,1,0),(122,6,2,0),(123,6,5,0),(124,6,4,0),(125,6,3,0),(126,6,2,0),(127,1,1,0),(128,1,4,0),(129,1,2,0),(130,1,12,0),(131,6,5,0),(132,6,4,0),(133,6,3,0),(134,6,2,0),(135,6,5,0),(136,6,4,0),(137,6,3,0),(138,6,2,0),(139,6,5,1),(140,6,4,1),(141,6,3,1),(142,6,2,1),(143,6,6,1),(144,1,1,0),(145,1,4,0),(146,1,2,0),(147,1,12,0),(148,1,11,0),(149,1,10,0),(150,1,9,0),(151,1,8,0),(152,1,7,0),(153,1,6,0),(154,1,5,0),(155,1,3,0),(156,1,1,0),(157,1,4,0),(158,1,2,0),(159,1,12,0),(160,1,11,0),(161,1,10,0),(162,1,9,0),(163,1,8,0),(164,1,7,0),(165,1,6,0),(166,1,5,0),(167,1,3,0),(168,1,1,0),(169,1,2,0),(170,1,3,0),(171,1,4,0),(172,1,5,0),(173,1,6,0),(174,1,7,0),(175,1,8,0),(176,1,9,0),(177,1,10,0),(178,1,11,0),(179,1,12,0),(180,1,1,0),(181,1,2,0),(182,1,3,0),(183,1,4,0),(184,1,5,0),(185,1,6,0),(186,1,7,0),(187,1,8,0),(188,1,9,0),(189,1,10,0),(190,1,11,0),(191,1,12,0),(192,1,1,1),(193,1,2,1),(194,1,3,1),(195,1,4,1),(196,1,5,1),(197,1,6,1),(198,1,7,1),(199,1,8,1),(200,1,9,1),(201,1,10,1),(202,1,11,1),(203,1,12,1);

--
-- Table structure for table `tbl_facturas`
--

CREATE TABLE `tbl_facturas` (
  `pk_factura` int(11) NOT NULL AUTO_INCREMENT,
  `fecha_agregado` datetime DEFAULT NULL,
  `fecha_modificado` datetime DEFAULT NULL,
  `nombres` varchar(255) DEFAULT NULL,
  `apellidos` varchar(255) DEFAULT NULL,
  `tipo` varchar(10) DEFAULT NULL,
  `numero` varchar(50) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `establecimiento` varchar(255) DEFAULT NULL,
  `factura` varchar(255) DEFAULT NULL,
  `fk_estatus` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`pk_factura`),
  UNIQUE KEY `tipo` (`tipo`,`numero`,`factura`),
  KEY `fk_estatus` (`fk_estatus`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_facturas`
--



