 /*!50001 CREATE VIEW `view_administrador` AS SELECT 
  1 AS `id`,
  1 AS `nombre`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Temporary view structure for view `view_laboratorio`
+--
+
+DROP TABLE IF EXISTS `view_laboratorio`;
+/*!50001 DROP VIEW IF EXISTS `view_laboratorio`*/;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `view_laboratorio` AS SELECT 
+ 1 AS `id`,
+ 1 AS `nombre`,
+ 1 AS `capacidad`,
+ 1 AS `descripcion`,
+ 1 AS `j1_hora_apertura`,
+ 1 AS `j1_hora_cierre`,
+ 1 AS `j2_hora_apertura`,
+ 1 AS `j2_hora_cierre`*/;
 SET character_set_client = @saved_cs_client;
 
 --

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horario` (
  `id` varchar(10) NOT NULL,
  `id_jornada1` varchar(10) DEFAULT NULL,
  `id_jornada2` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_horario_1_idx` (`id_jornada1`),
  KEY `fk_horario_2_idx` (`id_jornada2`),
  CONSTRAINT `fk_horario_1` FOREIGN KEY (`id_jornada1`) REFERENCES `jornada` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_horario_2` FOREIGN KEY (`id_jornada2`) REFERENCES `jornada` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lector` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_laboratorio` varchar(10) DEFAULT NULL,
  `ip` varchar(55) DEFAULT NULL,
  `mac` varchar(70) DEFAULT NULL,
  `token` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_lector_1_idx` (`id_laboratorio`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
