-- Table structure for table `flights`
--

CREATE TABLE `flights` (
  `flight_number` varchar(12) NOT NULL DEFAULT '',
  `identification_type` char(3) DEFAULT NULL,
  `number` varchar(40) DEFAULT NULL,
  `flight_date` date DEFAULT NULL,
  `initial_hour` time DEFAULT NULL,
  `final_hour` time DEFAULT NULL,
  PRIMARY KEY (`flight_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `flights`
--


--
-- Temporary table structure for view `formas_pago`
--

/*!50001 DROP VIEW IF EXISTS `formas_pago`*/;
/*!50001 CREATE VIEW `formas_pago` AS SELECT 
 1 AS `id`,
 1 AS `detalle`*/;

--
-- Temporary table structure for view `habitacion`
--

/*!50001 DROP VIEW IF EXISTS `habitacion`*/;
/*!50001 CREATE VIEW `habitacion` AS SELECT 
 1 AS `id`,
 1 AS `tipdoc`,
 1 AS `cedula`,
 1 AS `nombre`,
 1 AS `nit`,
 1 AS `numhab`,
 1 AS `numero_adultos`,
 1 AS `numero_ninos`,
 1 AS `numero_infantes`,
 1 AS `nota`*/;

--
-- Temporary table structure for view `habitacion_historico`
--

/*!50001 DROP VIEW IF EXISTS `habitacion_historico`*/;
/*!50001 CREATE VIEW `habitacion_historico` AS SELECT 
 1 AS `id`,
 1 AS `tipdoc`,
 1 AS `cedula`,
 1 AS `nombre`,
 1 AS `numhab`,
 1 AS `numero_adultos`,
 1 AS `numero_ninos`,
 1 AS `numero_infantes`,
 1 AS `nota`*/;

--
-- Temporary table structure for view `habitaciones`
--

/*!50001 DROP VIEW IF EXISTS `habitaciones`*/;
/*!50001 CREATE VIEW `habitaciones` AS SELECT 
 1 AS `id`,
 1 AS `clase`,
 1 AS `piso`*/;

--
-- Table structure for table `invepos`
--

CREATE TABLE `invepos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `prefac` char(5) NOT NULL,
  `numfac` int(10) unsigned NOT NULL,
  `fecha` date NOT NULL,
  `almacen` int(10) unsigned NOT NULL,
  `centro_costo` int(10) unsigned NOT NULL,
  `tipo` char(1) NOT NULL,
  `codigo` char(15) NOT NULL,
  `menus_items_id` int(10) unsigned NOT NULL,
  `cantidad` int(10) unsigned NOT NULL,
  `cantidadu` int(10) unsigned NOT NULL,
  `estado` char(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `invepos`
--

INSERT INTO `invepos` VALUES (2,'1',444,'2017-05-31',1,300,'I','17',1,1,0,'N'),(3,'1',445,'2017-06-01',1,300,'I','17',1,1,0,'N'),(4,'1',446,'2017-06-01',1,300,'I','17',1,1,0,'N'),(5,'1',447,'2017-06-02',1,300,'I','17',1,1,0,'N'),(6,'1',448,'2017-06-02',1,300,'I','25',3,1,0,'N'),(7,'1',449,'2017-06-03',1,300,'I','17',1,1,0,'N'),(8,'1',450,'2017-06-04',1,300,'I','17',1,2,0,'N'),(9,'1',451,'2017-06-04',1,300,'I','17',1,1,0,'N'),(10,'1',451,'2017-06-04',1,300,'I','30',2,1,0,'N'),(11,'1',452,'2017-06-04',1,300,'I','17',1,2,0,'N'),(12,'1',453,'2017-06-05',1,300,'I','30',2,2,0,'N'),(13,'1',454,'2017-06-08',1,300,'I','30',2,1,0,'N'),(14,'1',455,'2017-06-09',1,300,'I','30',2,1,0,'N'),(15,'1',456,'2017-06-10',1,300,'I','17',1,1,0,'N'),(16,'1',457,'2017-06-10',1,300,'I','20',4,1,0,'N'),(17,'1',457,'2017-06-10',1,300,'I','17',1,1,0,'N'),(18,'1',458,'2017-06-11',1,300,'I','25',3,1,0,'N'),(19,'1',459,'2017-06-11',1,300,'I','17',1,1,0,'N'),(20,'1',460,'2017-06-11',1,300,'I','17',1,1,0,'N'),(21,'1',461,'2017-06-11',1,300,'I','25',3,1,0,'N'),(22,'1',462,'2017-06-12',1,300,'I','17',1,1,0,'N'),(23,'1',463,'2017-06-12',1,300,'I','17',1,1,0,'N'),(24,'1',464,'2017-06-13',1,300,'I','17',1,2,0,'N'),(25,'1',465,'2017-06-13',1,300,'I','30',2,2,0,'N'),(26,'1',467,'2017-06-14',1,300,'I','17',1,1,0,'N'),(27,'1',468,'2017-06-14',1,300,'I','17',1,3,0,'N'),(28,'1',469,'2017-06-15',1,300,'I','17',1,1,0,'N'),(29,'1',470,'2017-06-16',1,300,'I','20',4,3,0,'N'),(30,'1',471,'2017-06-19',1,300,'I','20',4,1,0,'N'),(31,'1',471,'2017-06-19',1,300,'I','30',2,1,0,'N'),(32,'1',472,'2017-06-19',1,300,'I','20',4,2,0,'N'),(33,'1',473,'2017-06-20',1,300,'I','20',4,1,0,'N'),(34,'1',474,'2017-06-22',1,300,'I','25',3,1,0,'N'),(35,'1',475,'2017-06-24',1,300,'I','25',3,1,0,'N'),(36,'1',476,'2017-06-26',1,300,'I','25',3,1,0,'N'),(37,'1',477,'2017-06-26',1,300,'I','25',3,1,0,'N'),(38,'1',478,'2017-06-27',1,300,'I','25',3,1,0,'N'),(39,'1',480,'2017-06-30',1,300,'I','25',3,2,0,'N'),(40,'1',480,'2017-06-30',1,300,'I','30',2,1,0,'N'),(41,'1',481,'2017-06-30',1,300,'I','17',1,1,0,'N'),(42,'1',481,'2017-06-30',1,300,'I','30',2,1,0,'N'),(43,'1',482,'2017-06-30',1,300,'I','20',4,2,0,'N'),(44,'1',482,'2017-06-30',1,300,'I','17',1,1,0,'N'),(45,'1',483,'2017-07-01',1,300,'I','17',1,1,0,'N'),(46,'1',484,'2017-07-01',1,300,'I','17',1,2,0,'N'),(47,'1',485,'2017-07-01',1,300,'I','17',1,3,0,'N'),(48,'1',486,'2017-07-02',1,300,'I','17',1,1,0,'N'),(49,'1',486,'2017-07-02',1,300,'I','20',4,2,0,'N'),(50,'1',487,'2017-07-02',1,300,'I','30',2,1,0,'N'),(51,'1',488,'2017-07-04',1,300,'I','17',1,1,0,'N'),(52,'1',489,'2017-07-04',1,300,'I','30',2,1,0,'N'),(53,'1',489,'2017-07-04',1,300,'I','17',1,2,0,'N'),(54,'1',490,'2017-07-05',1,300,'I','17',1,2,0,'N'),(55,'1',491,'2017-07-05',1,300,'I','17',1,2,0,'N'),(56,'1',492,'2017-07-05',1,300,'I','17',1,1,0,'N'),(57,'1',493,'2017-07-05',1,300,'I','17',1,2,0,'N'),(58,'1',494,'2017-07-06',1,300,'I','17',1,1,0,'N'),(59,'1',495,'2017-07-06',1,300,'I','17',1,3,0,'N'),(60,'1',496,'2017-07-06',1,300,'I','17',1,2,0,'N'),(61,'1',497,'2017-07-07',1,300,'I','17',1,1,0,'N'),(62,'1',498,'2017-07-07',1,300,'I','17',1,1,0,'N'),(63,'1',499,'2017-07-08',1,300,'I','20',4,2,0,'N'),(64,'1',500,'2017-07-08',1,300,'I','17',1,2,0,'N'),(65,'1',501,'2017-07-09',1,300,'I','17',1,1,0,'N'),(66,'1',502,'2017-07-09',1,300,'I','17',1,1,0,'N'),(67,'1',503,'2017-07-10',1,300,'I','17',1,1,0,'N'),(68,'1',504,'2017-07-10',1,300,'I','17',1,1,0,'N'),(69,'1',505,'2017-07-10',1,300,'I','17',1,4,0,'N'),(70,'1',506,'2017-07-10',1,300,'I','17',1,1,0,'N'),(71,'1',507,'2017-07-10',1,300,'I','20',4,1,0,'N'),(72,'1',508,'2017-07-10',1,300,'I','17',1,1,0,'N'),(73,'1',509,'2017-07-11',1,300,'I','17',1,1,0,'N'),(74,'1',510,'2017-07-11',1,300,'I','17',1,2,0,'N'),(75,'1',511,'2017-07-15',1,300,'I','17',1,4,0,'N'),(76,'1',512,'2017-07-15',1,300,'I','17',1,2,0,'N'),(77,'1',513,'2017-07-15',1,300,'I','30',2,1,0,'N'),(78,'1',514,'2017-07-16',1,300,'I','17',1,1,0,'N'),(79,'1',515,'2017-07-16',1,300,'I','17',1,2,0,'N'),(80,'1',516,'2017-07-17',1,300,'I','20',4,1,0,'N'),(81,'1',517,'2017-07-17',1,300,'I','17',1,1,0,'N'),(82,'1',518,'2017-07-17',1,300,'I','17',1,1,0,'N'),(83,'1',519,'2017-07-17',1,300,'I','30',2,1,0,'N'),(84,'1',520,'2017-07-17',1,300,'I','17',1,1,0,'N'),(85,'1',521,'2017-07-18',1,300,'I','17',1,1,0,'N'),(86,'1',522,'2017-07-18',1,300,'I','30',2,1,0,'N'),(87,'1',523,'2017-07-18',1,300,'I','17',1,1,0,'N'),(88,'1',524,'2017-07-18',1,300,'I','17',1,1,0,'N'),(89,'1',525,'2017-07-19',1,300,'I','17',1,2,0,'N'),(90,'1',526,'2017-07-19',1,300,'I','17',1,1,0,'N'),(91,'1',527,'2017-07-19',1,300,'I','17',1,1,0,'N'),(92,'1',528,'2017-07-21',1,300,'I','17',1,1,0,'N'),(93,'1',529,'2017-07-21',1,300,'I','17',1,1,0,'N'),(94,'1',530,'2017-07-21',1,300,'I','17',1,2,0,'N'),(95,'1',531,'2017-07-21',1,300,'I','17',1,2,0,'N'),(96,'1',532,'2017-07-21',1,300,'I','30',2,1,0,'N'),(97,'1',533,'2017-07-24',1,300,'I','17',1,1,0,'N'),(98,'1',534,'2017-07-24',1,300,'I','20',4,1,0,'N'),(99,'1',535,'2017-07-24',1,300,'I','17',1,1,0,'N'),(100,'1',536,'2017-07-25',1,300,'I','17',1,1,0,'N'),(101,'1',537,'2017-07-25',1,300,'I','20',4,1,0,'N'),(102,'1',538,'2017-07-26',1,300,'I','17',1,1,0,'N'),(103,'1',539,'2017-07-27',1,300,'I','30',2,1,0,'N'),(104,'1',540,'2017-07-27',1,300,'I','30',2,1,0,'N'),(105,'1',541,'2017-07-28',1,300,'I','17',1,4,0,'N'),(106,'1',542,'2017-07-29',1,300,'I','17',1,1,0,'N'),(107,'1',543,'2017-07-31',1,300,'I','20',4,2,0,'N'),(108,'1',544,'2017-07-31',1,300,'I','30',2,1,0,'N'),(109,'1',545,'2017-08-02',1,300,'I','30',2,1,0,'N'),(110,'1',546,'2017-08-03',1,300,'I','25',3,1,0,'N'),(111,'1',547,'2017-08-03',1,300,'I','25',3,1,0,'N'),(112,'1',548,'2017-08-03',1,300,'I','17',1,1,0,'N'),(113,'1',549,'2017-08-03',1,300,'I','30',2,1,0,'N'),(114,'1',550,'2017-08-04',1,300,'I','25',3,1,0,'N'),(115,'1',551,'2017-08-04',1,300,'I','25',3,1,0,'N'),(116,'1',552,'2017-08-07',1,300,'I','30',2,1,0,'N'),(117,'1',553,'2017-08-12',1,300,'I','30',2,1,0,'N'),(118,'1',554,'2017-08-12',1,300,'I','30',2,2,0,'N'),(119,'1',555,'2017-08-12',1,300,'I','17',1,1,0,'N'),(120,'1',555,'2017-08-12',1,300,'I','30',2,2,0,'N'),(121,'1',556,'2017-08-12',1,300,'I','25',3,1,0,'N'),(122,'1',556,'2017-08-12',1,300,'I','30',2,1,0,'N'),(123,'1',557,'2017-08-14',1,300,'I','17',1,1,0,'N'),(124,'1',558,'2017-08-16',1,300,'I','17',1,1,0,'N'),(125,'1',559,'2017-08-21',1,300,'I','17',1,1,0,'S'),(126,'1',560,'2017-08-24',1,300,'I','17',1,2,0,'N'),(127,'1',561,'2017-08-24',1,300,'I','17',1,1,0,'N'),(128,'1',562,'2017-08-25',1,300,'I','17',1,3,0,'N'),(129,'1',563,'2017-08-25',1,300,'I','20',4,3,0,'N'),(130,'1',564,'2017-08-25',1,300,'I','17',1,1,0,'N'),(131,'1',565,'2017-08-26',1,300,'I','17',1,1,0,'S'),(132,'1',566,'2017-08-27',1,300,'I','17',1,1,0,'N'),(133,'1',567,'2017-08-27',1,300,'I','30',2,1,0,'N'),(134,'1',568,'2017-08-27',1,300,'I','17',1,2,0,'N'),(135,'1',569,'2017-08-27',1,300,'I','17',1,1,0,'N'),(136,'1',570,'2017-08-28',1,300,'I','17',1,1,0,'N'),(137,'1',571,'2017-08-28',1,300,'I','17',1,1,0,'N'),(138,'1',572,'2017-08-29',1,300,'I','17',1,1,0,'N'),(139,'1',573,'2017-08-29',1,300,'I','25',3,1,0,'N'),(140,'1',574,'2017-08-29',1,300,'I','20',4,2,0,'N'),(141,'1',575,'2017-09-09',1,300,'I','25',3,2,0,'N'),(142,'1',576,'2017-09-09',1,300,'I','17',1,1,0,'N'),(143,'1',577,'2017-09-09',1,300,'I','17',1,1,0,'N'),(144,'1',578,'2017-09-09',1,300,'I','17',1,1,0,'N'),(145,'1',579,'2017-09-10',1,300,'I','17',1,2,0,'N'),(146,'1',580,'2017-09-10',1,300,'I','17',1,1,0,'N'),(147,'1',581,'2017-09-11',1,300,'I','17',1,1,0,'N'),(148,'1',582,'2017-09-13',1,300,'I','17',1,2,0,'N'),(149,'1',583,'2017-09-13',1,300,'I','30',2,2,0,'N'),(150,'1',584,'2017-09-13',1,300,'I','17',1,1,0,'N'),(151,'1',585,'2017-09-16',1,300,'I','17',1,1,0,'N'),(152,'1',586,'2017-09-16',1,300,'I','17',1,1,0,'N'),(153,'1',587,'2017-09-17',1,300,'I','17',1,2,0,'N'),(154,'1',588,'2017-09-17',1,300,'I','30',2,1,0,'N'),(155,'1',589,'2017-09-22',1,300,'I','17',1,2,0,'N'),(156,'1',590,'2017-09-22',1,300,'I','17',1,1,0,'N'),(157,'1',591,'2017-09-27',1,300,'I','17',1,1,0,'N'),(158,'1',592,'2017-09-28',1,300,'I','17',1,1,0,'N'),(159,'1',592,'2017-09-28',1,300,'I','30',2,1,0,'N'),(160,'1',593,'2017-09-28',1,300,'I','17',1,1,0,'N'),(161,'1',594,'2017-09-29',1,300,'I','17',1,1,0,'N'),(162,'1',595,'2017-09-29',1,300,'I','17',1,2,0,'N'),(163,'1',596,'2017-09-30',1,300,'I','17',1,1,0,'N'),(164,'1',597,'2017-09-30',1,300,'I','17',1,1,0,'N'),(165,'1',598,'2017-10-01',1,300,'I','17',1,2,0,'N'),(166,'1',602,'2017-10-01',1,300,'I','17',1,1,0,'N'),(167,'1',603,'2017-10-02',1,300,'I','17',1,2,0,'N'),(168,'1',604,'2017-10-05',1,300,'I','25',3,1,0,'N'),(169,'1',605,'2017-10-05',1,300,'I','17',1,1,0,'N'),(170,'1',606,'2017-10-05',1,300,'I','17',1,1,0,'N'),(171,'1',607,'2017-10-06',1,300,'I','17',1,1,0,'N'),(172,'1',608,'2017-10-06',1,300,'I','25',3,1,0,'N'),(173,'1',609,'2017-10-07',1,300,'I','30',2,1,0,'N'),(174,'1',610,'2017-10-08',1,300,'I','30',2,1,0,'N'),(175,'1',611,'2017-10-09',1,300,'I','30',2,1,0,'N'),(176,'1',611,'2017-10-09',1,300,'I','25',3,2,0,'N'),(177,'1',612,'2017-10-25',1,300,'I','17',1,1,0,'N'),(178,'1',613,'2017-10-26',1,300,'I','17',1,1,0,'N'),(179,'1',614,'2017-10-28',1,300,'I','17',1,2,0,'N'),(180,'1',615,'2017-10-28',1,300,'I','17',1,2,0,'N'),(181,'1',616,'2017-10-29',1,300,'I','17',1,1,0,'N'),(182,'1',617,'2017-10-29',1,300,'I','17',1,2,0,'N'),(183,'1',618,'2017-10-29',1,300,'I','17',1,1,0,'N'),(184,'1',619,'2017-10-29',1,300,'I','17',1,1,0,'N'),(185,'1',620,'2017-10-29',1,300,'I','17',1,2,0,'N'),(186,'1',621,'2017-10-29',1,300,'I','17',1,1,0,'N'),(187,'1',622,'2017-10-29',1,300,'I','17',1,2,0,'N'),(188,'1',623,'2017-10-29',1,300,'I','17',1,1,0,'N'),(189,'1',624,'2017-10-29',1,300,'I','17',1,1,0,'N'),(190,'1',625,'2017-10-29',1,300,'I','17',1,1,0,'N'),(191,'1',626,'2017-10-30',1,300,'I','17',1,1,0,'N'),(192,'1',627,'2017-10-30',1,300,'I','17',1,1,0,'N'),(193,'1',628,'2017-10-30',1,300,'I','17',1,1,0,'N'),(194,'1',629,'2017-10-30',1,300,'I','17',1,1,0,'N'),(195,'1',630,'2017-10-30',1,300,'I','17',1,1,0,'N'),(196,'1',631,'2017-11-09',1,300,'I','17',1,1,0,'N'),(197,'1',632,'2017-11-10',1,300,'I','17',1,2,0,'N'),(198,'1',633,'2017-11-10',1,300,'I','17',1,1,0,'N'),(199,'1',634,'2017-11-10',1,300,'I','17',1,5,0,'N'),(200,'1',635,'2017-11-10',1,300,'I','17',1,2,0,'N'),(201,'1',636,'2017-11-11',1,300,'I','17',1,1,0,'N'),(202,'1',637,'2017-11-11',1,300,'I','17',1,2,0,'N'),(203,'1',638,'2017-11-11',1,300,'I','17',1,1,0,'N'),(204,'1',639,'2017-11-13',1,300,'I','17',1,2,0,'N'),(205,'1',640,'2017-11-14',1,300,'I','17',1,2,0,'N'),(206,'1',641,'2017-11-14',1,300,'I','17',1,3,0,'N'),(207,'1',642,'2017-11-15',1,300,'I','17',1,2,0,'N'),(208,'1',643,'2017-11-15',1,300,'I','17',1,1,0,'N'),(209,'1',644,'2017-11-15',1,300,'I','17',1,1,0,'N'),(210,'1',645,'2017-11-16',1,300,'I','17',1,1,0,'N'),(211,'1',646,'2017-11-16',1,300,'I','17',1,1,0,'N'),(212,'1',647,'2017-11-16',1,300,'I','17',1,1,0,'N'),(213,'1',648,'2017-11-16',1,300,'I','17',1,1,0,'N'),(214,'1',649,'2017-11-17',1,300,'I','17',1,1,0,'N'),(215,'1',650,'2017-11-17',1,300,'I','17',1,2,0,'N'),(216,'1',651,'2017-11-17',1,300,'I','17',1,1,0,'N'),(217,'1',652,'2017-11-17',1,300,'I','17',1,1,0,'N'),(218,'1',653,'2017-11-17',1,300,'I','17',1,1,0,'N'),(219,'1',654,'2017-11-17',1,300,'I','17',1,1,0,'N'),(220,'1',655,'2017-11-18',1,300,'I','17',1,1,0,'N'),(221,'1',656,'2017-11-18',1,300,'I','17',1,2,0,'N'),(222,'1',657,'2017-11-18',1,300,'I','17',1,1,0,'N'),(223,'1',658,'2017-11-18',1,300,'I','17',1,1,0,'N'),(224,'1',659,'2017-11-19',1,300,'I','17',1,1,0,'N'),(225,'1',660,'2017-11-19',1,300,'I','17',1,2,0,'N'),(226,'1',661,'2017-11-19',1,300,'I','17',1,1,0,'N'),(227,'1',662,'2017-11-20',1,300,'I','20',4,1,0,'N'),(228,'1',662,'2017-11-20',1,300,'I','17',1,2,0,'N'),(229,'1',663,'2017-11-20',1,300,'I','17',1,2,0,'N'),(230,'1',664,'2017-11-21',1,300,'I','17',1,1,0,'N'),(231,'1',665,'2017-11-21',1,300,'I','17',1,1,0,'N'),(232,'1',666,'2017-11-21',1,300,'I','17',1,1,0,'N'),(233,'1',667,'2017-11-21',1,300,'I','17',1,1,0,'N'),(234,'1',668,'2017-11-21',1,300,'I','17',1,2,0,'N'),(235,'1',669,'2017-11-21',1,300,'I','17',1,4,0,'N'),(236,'1',670,'2017-11-22',1,300,'I','17',1,2,0,'N'),(237,'1',671,'2017-11-22',1,300,'I','17',1,1,0,'N'),(238,'1',672,'2017-11-22',1,300,'I','17',1,1,0,'N'),(239,'1',673,'2017-11-22',1,300,'I','17',1,1,0,'N'),(240,'1',674,'2017-11-23',1,300,'I','17',1,1,0,'N'),(241,'1',675,'2017-11-23',1,300,'I','17',1,2,0,'N'),(242,'1',676,'2017-11-23',1,300,'I','20',4,1,0,'N'),(243,'1',677,'2017-11-23',1,300,'I','17',1,2,0,'N'),(244,'1',678,'2017-11-24',1,300,'I','17',1,2,0,'N'),(245,'1',678,'2017-11-24',1,300,'I','20',4,1,0,'N'),(246,'1',679,'2017-11-24',1,300,'I','20',4,2,0,'N'),(247,'1',680,'2017-11-25',1,300,'I','17',1,1,0,'N'),(248,'1',681,'2017-11-25',1,300,'I','17',1,2,0,'N'),(249,'1',682,'2017-11-25',1,300,'I','17',1,2,0,'N'),(250,'1',683,'2017-11-26',1,300,'I','17',1,1,0,'N'),(251,'1',684,'2017-11-27',1,300,'I','17',1,2,0,'N'),(252,'1',685,'2017-11-27',1,300,'I','20',4,2,0,'N'),(253,'1',686,'2017-11-27',1,300,'I','17',1,1,0,'N'),(254,'1',687,'2017-11-27',1,300,'I','20',4,2,0,'N'),(255,'1',688,'2017-11-28',1,300,'I','17',1,2,0,'N'),(256,'1',689,'2017-11-29',1,300,'I','17',1,1,0,'N'),(257,'1',690,'2017-11-30',1,300,'I','17',1,2,0,'N'),(258,'1',691,'2017-11-30',1,300,'I','20',4,2,0,'N'),(259,'1',692,'2017-12-01',1,300,'I','17',1,1,0,'N'),(260,'1',693,'2017-12-01',1,300,'I','17',1,1,0,'N'),(261,'1',694,'2017-12-01',1,300,'I','20',4,1,0,'N'),(262,'1',695,'2017-12-01',1,300,'I','17',1,1,0,'N'),(263,'1',696,'2017-12-02',1,300,'I','17',1,1,0,'N'),(264,'1',697,'2017-12-04',1,300,'I','20',4,1,0,'N'),(265,'1',698,'2017-12-04',1,300,'I','17',1,1,0,'N'),(266,'1',699,'2017-12-04',1,300,'I','17',1,1,0,'N'),(267,'1',699,'2017-12-04',1,300,'I','20',4,2,0,'N'),(268,'1',700,'2017-12-05',1,300,'I','17',1,2,0,'N'),(269,'1',701,'2017-12-05',1,300,'I','17',1,2,0,'N'),(270,'1',702,'2017-12-05',1,300,'I','20',4,1,0,'N'),(271,'1',703,'2017-12-06',1,300,'I','17',1,1,0,'N'),(272,'1',704,'2017-12-06',1,300,'I','17',1,1,0,'N'),(273,'1',705,'2017-12-06',1,300,'I','17',1,2,0,'N'),(274,'1',706,'2017-12-06',1,300,'I','17',1,2,0,'N'),(275,'1',707,'2017-12-06',1,300,'I','17',1,2,0,'N'),(276,'1',707,'2017-12-06',1,300,'I','20',4,1,0,'N'),(277,'1',708,'2017-12-07',1,300,'I','17',1,2,0,'N'),(278,'1',709,'2017-12-08',1,300,'I','17',1,1,0,'N'),(279,'1',710,'2017-12-08',1,300,'I','17',1,2,0,'N'),(280,'1',711,'2017-12-08',1,300,'I','17',1,1,0,'N'),(281,'1',712,'2017-12-08',1,300,'I','17',1,2,0,'N'),(282,'1',713,'2017-12-09',1,300,'I','17',1,1,0,'N'),(283,'1',714,'2017-12-10',1,300,'I','17',1,2,0,'N'),(284,'1',715,'2017-12-10',1,300,'I','17',1,1,0,'N'),(285,'1',716,'2017-12-10',1,300,'I','17',1,2,0,'N'),(286,'1',717,'2017-12-12',1,300,'I','17',1,1,0,'N'),(287,'1',718,'2017-12-13',1,300,'I','17',1,1,0,'N'),(288,'1',719,'2017-12-15',1,300,'I','17',1,3,0,'N'),(289,'1',719,'2017-12-15',1,300,'I','20',4,1,0,'N'),(290,'1',720,'2017-12-16',1,300,'I','17',1,1,0,'N'),(291,'1',721,'2017-12-16',1,300,'I','20',4,1,0,'N'),(292,'1',722,'2017-12-17',1,300,'I','17',1,2,0,'N'),(293,'1',723,'2017-12-18',1,300,'I','20',4,1,0,'N'),(294,'1',724,'2017-12-19',1,300,'I','17',1,1,0,'N'),(295,'1',725,'2017-12-19',1,300,'I','17',1,1,0,'N'),(296,'1',726,'2017-12-21',1,300,'I','17',1,1,0,'N'),(297,'1',727,'2017-12-23',1,300,'I','17',1,1,0,'N'),(298,'1',728,'2017-12-23',1,300,'I','17',1,2,0,'N'),(299,'1',728,'2017-12-23',1,300,'I','20',4,2,0,'N'),(300,'1',729,'2017-12-24',1,300,'I','17',1,1,0,'N'),(301,'1',730,'2017-12-25',1,300,'I','17',1,3,0,'N'),(302,'1',731,'2017-12-26',1,300,'I','20',4,1,0,'N'),(303,'1',732,'2017-12-26',1,300,'I','17',1,1,0,'N'),(304,'1',733,'2017-12-26',1,300,'I','17',1,1,0,'N'),(305,'1',734,'2017-12-28',1,300,'I','17',1,1,0,'N'),(306,'1',735,'2017-12-28',1,300,'I','17',1,3,0,'N'),(307,'1',736,'2017-12-28',1,300,'I','17',1,1,0,'N'),(308,'1',737,'2017-12-29',1,300,'I','20',4,3,0,'N'),(309,'1',738,'2017-12-29',1,300,'I','17',1,1,0,'N'),(310,'1',739,'2017-12-29',1,300,'I','20',4,1,0,'N'),(311,'1',739,'2017-12-29',1,300,'I','17',1,1,0,'N'),(312,'1',740,'2017-12-29',1,300,'I','17',1,1,0,'N'),(313,'1',741,'2017-12-30',1,300,'I','17',1,1,0,'N'),(314,'1',742,'2017-12-31',1,300,'I','17',1,1,0,'N'),(315,'1',743,'2018-01-02',1,300,'I','20',4,1,0,'N'),(316,'1',743,'2018-01-02',1,300,'I','17',1,1,0,'N'),(317,'1',744,'2018-01-02',1,300,'I','17',1,1,0,'N'),(318,'1',745,'2018-01-03',1,300,'I','17',1,1,0,'N'),(319,'1',746,'2018-01-03',1,300,'I','17',1,1,0,'N'),(320,'1',747,'2018-01-03',1,300,'I','17',1,2,0,'N'),(321,'1',748,'2018-01-04',1,300,'I','17',1,1,0,'N'),(322,'1',749,'2018-01-04',1,300,'I','17',1,1,0,'N'),(323,'1',750,'2018-01-05',1,300,'I','17',1,1,0,'N'),(324,'1',751,'2018-01-05',1,300,'I','17',1,2,0,'N'),(325,'1',753,'2018-01-07',1,300,'I','17',1,1,0,'N'),(326,'1',754,'2018-01-08',1,300,'I','17',1,3,0,'N'),(327,'1',755,'2018-01-08',1,300,'I','17',1,1,0,'N'),(328,'1',756,'2018-01-11',1,300,'I','17',1,1,0,'N'),(329,'1',757,'2018-01-11',1,300,'I','17',1,1,0,'N'),(330,'1',758,'2018-01-15',1,300,'I','17',1,1,0,'N'),(331,'1',759,'2018-01-19',1,300,'I','17',1,2,0,'N'),(332,'1',760,'2018-01-19',1,300,'I','25',3,1,0,'N'),(333,'1',761,'2018-01-19',1,300,'I','25',3,1,0,'N'),(334,'1',762,'2018-01-20',1,300,'I','17',1,2,0,'N'),(335,'1',763,'2018-01-20',1,300,'I','17',1,1,0,'N'),(336,'1',764,'2018-01-21',1,300,'I','17',1,1,0,'N'),(337,'1',765,'2018-01-21',1,300,'I','17',1,1,0,'N'),(338,'1',765,'2018-01-21',1,300,'I','25',3,2,0,'N'),(339,'1',766,'2018-01-21',1,300,'I','17',1,2,0,'N'),(340,'1',767,'2018-01-21',1,300,'I','17',1,2,0,'N'),(341,'1',768,'2018-01-22',1,300,'I','17',1,1,0,'N'),(342,'1',769,'2018-01-23',1,300,'I','17',1,1,0,'N'),(343,'1',769,'2018-01-23',1,300,'I','25',3,1,0,'N'),(344,'1',770,'2018-01-23',1,300,'I','17',1,1,0,'N'),(345,'1',771,'2018-01-23',1,300,'I','17',1,1,0,'N'),(346,'1',772,'2018-01-23',1,300,'I','17',1,1,0,'N'),(347,'1',773,'2018-01-23',1,300,'I','17',1,2,0,'N'),(348,'1',774,'2018-01-24',1,300,'I','17',1,2,0,'N'),(349,'1',775,'2018-01-24',1,300,'I','17',1,1,0,'N'),(350,'1',776,'2018-01-25',1,300,'I','25',3,1,0,'N'),(351,'1',777,'2018-01-25',1,300,'I','17',1,1,0,'N'),(352,'1',778,'2018-01-26',1,300,'I','17',1,3,0,'N'),(353,'1',779,'2018-01-27',1,300,'I','17',1,1,0,'N'),(354,'1',780,'2018-01-27',1,300,'I','17',1,1,0,'N'),(355,'1',780,'2018-01-27',1,300,'I','25',3,1,0,'N'),(356,'1',781,'2018-01-27',1,300,'I','25',3,1,0,'N'),(357,'1',782,'2018-01-27',1,300,'I','25',3,1,0,'N'),(358,'1',783,'2018-01-28',1,300,'I','25',3,1,0,'N'),(359,'1',784,'2018-01-28',1,300,'I','17',1,1,0,'N'),(360,'1',785,'2018-01-30',1,300,'I','17',1,1,0,'N'),(361,'1',786,'2018-02-01',1,300,'I','17',1,1,0,'S'),(362,'1',787,'2018-02-03',1,300,'I','17',1,1,0,'S'),(363,'1',788,'2018-02-03',1,300,'I','17',1,2,0,'S'),(364,'1',789,'2018-02-04',1,300,'I','17',1,2,0,'S'),(365,'1',790,'2018-02-05',1,300,'I','17',1,9,0,'S'),(366,'1',791,'2018-02-06',1,300,'I','17',1,2,0,'S'),(367,'1',792,'2018-02-06',1,300,'I','17',1,2,0,'S'),(368,'1',793,'2018-02-07',1,300,'I','17',1,1,0,'S'),(369,'1',794,'2018-02-08',1,300,'I','17',1,1,0,'N'),(370,'1',795,'2018-02-08',1,300,'I','17',1,4,0,'N'),(371,'1',796,'2018-02-09',1,300,'I','17',1,2,0,'N'),(372,'1',797,'2018-02-09',1,300,'I','17',1,1,0,'N'),(373,'1',798,'2018-02-10',1,300,'I','17',1,1,0,'N'),(374,'1',799,'2018-02-11',1,300,'I','17',1,2,0,'N'),(375,'1',800,'2018-02-11',1,300,'I','17',1,1,0,'N'),(376,'1',801,'2018-02-11',1,300,'I','17',1,1,0,'N'),(377,'1',802,'2018-02-12',1,300,'I','17',1,2,0,'N'),(378,'1',803,'2018-02-12',1,300,'I','17',1,2,0,'N'),(379,'1',804,'2018-02-12',1,300,'I','17',1,3,0,'N'),(380,'1',805,'2018-02-13',1,300,'I','17',1,2,0,'N'),(381,'1',806,'2018-02-13',1,300,'I','17',1,2,0,'N'),(382,'1',807,'2018-02-13',1,300,'I','17',1,2,0,'N'),(383,'1',808,'2018-02-14',1,300,'I','25',3,1,0,'N'),(384,'1',809,'2018-02-15',1,300,'I','25',3,1,0,'N'),(385,'1',810,'2018-02-15',1,300,'I','25',3,1,0,'N'),(386,'1',811,'2018-02-17',1,300,'I','17',1,1,0,'N'),(387,'1',812,'2018-02-17',1,300,'I','17',1,2,0,'N'),(388,'1',813,'2018-02-17',1,300,'I','17',1,3,0,'N'),(389,'1',814,'2018-02-18',1,300,'I','17',1,1,0,'N'),(390,'1',815,'2018-02-18',1,300,'I','17',1,2,0,'N'),(391,'1',816,'2018-02-18',1,300,'I','17',1,1,0,'N'),(392,'1',817,'2018-02-21',1,300,'I','17',1,2,0,'N'),(393,'1',818,'2018-02-21',1,300,'I','17',1,1,0,'N'),(394,'1',819,'2018-02-21',1,300,'I','17',1,1,0,'N'),(395,'1',820,'2018-02-22',1,300,'I','17',1,2,0,'N'),(396,'1',821,'2018-02-24',1,300,'I','17',1,2,0,'N'),(397,'1',822,'2018-02-24',1,300,'I','17',1,2,0,'N'),(398,'1',823,'2018-02-26',1,300,'I','17',1,1,0,'N'),(399,'1',824,'2018-02-27',1,300,'I','17',1,1,0,'N'),(400,'1',825,'2018-02-27',1,300,'I','17',1,2,0,'N'),(401,'1',826,'2018-02-28',1,300,'I','17',1,1,0,'N'),(402,'1',827,'2018-02-28',1,300,'I','17',1,1,0,'N'),(403,'1',828,'2018-03-01',1,300,'I','17',1,1,0,'N'),(404,'1',829,'2018-03-01',1,300,'I','17',1,1,0,'N'),(405,'1',830,'2018-03-01',1,300,'I','17',1,1,0,'N'),(406,'1',831,'2018-03-02',1,300,'I','25',3,1,0,'N'),(407,'1',832,'2018-03-02',1,300,'I','17',1,1,0,'N'),(408,'1',833,'2018-03-02',1,300,'I','17',1,3,0,'N'),(409,'1',834,'2018-03-04',1,300,'I','17',1,1,0,'N'),(410,'1',835,'2018-03-04',1,300,'I','25',3,1,0,'N'),(411,'1',836,'2018-03-07',1,300,'I','17',1,1,0,'N'),(412,'1',837,'2018-03-07',1,300,'I','17',1,1,0,'N'),(413,'1',838,'2018-03-12',1,300,'I','17',1,1,0,'N'),(414,'1',839,'2018-03-12',1,300,'I','17',1,4,0,'N'),(415,'1',839,'2018-03-12',1,300,'I','25',3,4,0,'N'),(416,'1',840,'2018-03-12',1,300,'I','17',1,8,0,'N'),(417,'1',840,'2018-03-12',1,300,'I','25',3,5,0,'N'),(418,'1',841,'2018-03-12',1,300,'I','17',1,1,0,'N'),(419,'1',842,'2018-03-12',1,300,'I','17',1,1,0,'N'),(420,'1',843,'2018-03-13',1,300,'I','17',1,1,0,'N'),(421,'1',843,'2018-03-13',1,300,'I','25',3,1,0,'N'),(422,'1',844,'2018-03-13',1,300,'I','25',3,1,0,'N'),(423,'1',845,'2018-03-13',1,300,'I','17',1,1,0,'N'),(424,'1',846,'2018-03-13',1,300,'I','17',1,1,0,'N'),(425,'1',847,'2018-03-14',1,300,'I','17',1,1,0,'N'),(426,'1',848,'2018-03-16',1,300,'I','17',1,1,0,'N'),(427,'1',849,'2018-03-16',1,300,'I','17',1,1,0,'N'),(428,'1',850,'2018-03-22',1,300,'I','17',1,1,0,'N'),(429,'1',851,'2018-03-22',1,300,'I','17',1,2,0,'N'),(430,'1',852,'2018-03-22',1,300,'I','17',1,4,0,'N'),(431,'1',854,'2018-03-23',1,300,'I','17',1,2,0,'N'),(432,'1',855,'2018-03-23',1,300,'I','17',1,2,0,'N'),(433,'1',856,'2018-03-23',1,300,'I','17',1,2,0,'N'),(434,'1',857,'2018-03-28',1,300,'I','17',1,3,0,'N'),(435,'1',858,'2018-03-30',1,300,'I','17',1,2,0,'N'),(436,'1',859,'2018-03-31',1,300,'I','17',1,2,0,'N'),(437,'1',860,'2018-03-31',1,300,'I','17',1,2,0,'N'),(438,'1',861,'2018-04-02',1,300,'I','17',1,2,0,'N'),(439,'1',862,'2018-04-04',1,300,'I','17',1,2,0,'N'),(440,'1',863,'2018-04-04',1,300,'I','17',1,2,0,'N'),(441,'1',864,'2018-04-04',1,300,'I','17',1,2,0,'N'),(442,'1',865,'2018-04-05',1,300,'I','17',1,1,0,'N'),(443,'1',866,'2018-04-05',1,300,'I','17',1,3,0,'N'),(444,'1',867,'2018-04-05',1,300,'I','17',1,1,0,'N'),(445,'1',868,'2018-04-07',1,300,'I','17',1,2,0,'N'),(446,'1',869,'2018-04-07',1,300,'I','17',1,1,0,'N'),(447,'1',870,'2018-04-08',1,300,'I','17',1,1,0,'N'),(448,'1',871,'2018-04-09',1,300,'I','17',1,1,0,'N'),(449,'1',872,'2018-04-09',1,300,'I','17',1,3,0,'N'),(450,'1',873,'2018-04-10',1,300,'I','17',1,2,0,'N'),(451,'1',874,'2018-04-10',1,300,'I','17',1,1,0,'N'),(452,'1',875,'2018-04-11',1,300,'I','17',1,2,0,'N'),(453,'1',876,'2018-04-12',1,300,'I','17',1,1,0,'N'),(454,'1',877,'2018-04-12',1,300,'I','17',1,4,0,'N'),(455,'1',878,'2018-04-13',1,300,'I','17',1,2,0,'N'),(456,'1',879,'2018-04-15',1,300,'I','17',1,4,0,'N'),(457,'1',880,'2018-04-17',1,300,'I','17',1,1,0,'N'),(458,'1',881,'2018-04-17',1,300,'I','17',1,2,0,'N'),(459,'1',882,'2018-04-18',1,300,'I','17',1,1,0,'N'),(460,'1',883,'2018-04-18',1,300,'I','17',1,1,0,'N'),(461,'1',884,'2018-04-19',1,300,'I','25',3,2,0,'N'),(462,'1',885,'2018-04-19',1,300,'I','17',1,1,0,'N'),(463,'1',886,'2018-04-19',1,300,'I','17',1,1,0,'N'),(464,'1',887,'2018-04-19',1,300,'I','25',3,1,0,'N'),(465,'1',888,'2018-04-20',1,300,'I','17',1,1,0,'N'),(466,'1',889,'2018-04-21',1,300,'I','17',1,1,0,'N'),(467,'1',890,'2018-04-22',1,300,'I','17',1,2,0,'N'),(468,'1',891,'2018-04-23',1,300,'I','17',1,1,0,'N'),(469,'1',892,'2018-04-25',1,300,'I','17',1,1,0,'N'),(470,'1',893,'2018-04-25',1,300,'I','17',1,2,0,'N'),(471,'1',894,'2018-04-26',1,300,'I','17',1,1,0,'N'),(472,'1',895,'2018-04-26',1,300,'I','17',1,1,0,'N'),(473,'1',896,'2018-04-26',1,300,'I','17',1,2,0,'N'),(474,'1',896,'2018-04-26',1,300,'I','25',3,2,0,'N'),(475,'1',897,'2018-04-27',1,300,'I','17',1,2,0,'N'),(476,'1',898,'2018-04-27',1,300,'I','17',1,2,0,'N'),(477,'1',899,'2018-04-27',1,300,'I','17',1,2,0,'N'),(478,'1',900,'2018-04-28',1,300,'I','17',1,3,0,'N'),(479,'1',901,'2018-04-30',1,300,'I','17',1,1,0,'N'),(480,'1',902,'2018-04-30',1,300,'I','25',3,1,0,'N'),(481,'1',903,'2018-05-01',1,300,'I','17',1,2,0,'N'),(482,'1',904,'2018-05-01',1,300,'I','17',1,2,0,'N'),(483,'1',905,'2018-05-01',1,300,'I','17',1,1,0,'N'),(484,'1',906,'2018-05-01',1,300,'I','17',1,1,0,'N'),(485,'1',907,'2018-05-02',1,300,'I','25',3,1,0,'N'),(486,'1',908,'2018-05-03',1,300,'I','17',1,2,0,'N'),(487,'1',909,'2018-05-03',1,300,'I','25',3,1,0,'N'),(488,'1',910,'2018-05-08',1,300,'I','17',1,1,0,'N'),(489,'1',910,'2018-05-08',1,300,'I','25',3,1,0,'N'),(490,'1',911,'2018-05-08',1,300,'I','25',3,1,0,'N'),(491,'1',912,'2018-05-09',1,300,'I','17',1,1,0,'N'),(492,'1',912,'2018-05-09',1,300,'I','30',2,1,0,'N'),(493,'1',913,'2018-05-09',1,300,'I','17',1,1,0,'N'),(494,'1',914,'2018-05-09',1,300,'I','17',1,1,0,'N'),(495,'1',915,'2018-05-10',1,300,'I','17',1,1,0,'N'),(496,'1',916,'2018-05-10',1,300,'I','17',1,2,0,'N'),(497,'1',917,'2018-05-10',1,300,'I','17',1,1,0,'N'),(498,'1',918,'2018-05-11',1,300,'I','17',1,1,0,'N'),(499,'1',919,'2018-05-11',1,300,'I','17',1,1,0,'N'),(500,'1',920,'2018-05-11',1,300,'I','17',1,1,0,'N'),(501,'1',921,'2018-05-11',1,300,'I','17',1,1,0,'N'),(502,'1',922,'2018-05-11',1,300,'I','17',1,2,0,'N'),(503,'1',923,'2018-05-11',1,300,'I','17',1,2,0,'N'),(504,'1',924,'2018-05-12',1,300,'I','17',1,1,0,'N'),(505,'1',925,'2018-05-12',1,300,'I','17',1,1,0,'N'),(506,'1',926,'2018-05-12',1,300,'I','17',1,1,0,'N'),(507,'1',927,'2018-05-12',1,300,'I','17',1,1,0,'N'),(508,'1',928,'2018-05-12',1,300,'I','17',1,1,0,'N'),(509,'1',929,'2018-05-13',1,300,'I','17',1,1,0,'N'),(510,'1',930,'2018-05-13',1,300,'I','17',1,1,0,'N'),(511,'1',930,'2018-05-13',1,300,'I','25',3,1,0,'N'),(512,'1',931,'2018-05-13',1,300,'I','25',3,2,0,'N'),(513,'1',933,'2018-05-14',1,300,'I','17',1,1,0,'N'),(514,'1',934,'2018-05-14',1,300,'I','17',1,3,0,'N'),(515,'1',935,'2018-05-15',1,300,'I','17',1,1,0,'N'),(516,'1',936,'2018-05-16',1,300,'I','17',1,1,0,'N'),(517,'1',937,'2018-05-16',1,300,'I','17',1,1,0,'N'),(518,'1',937,'2018-05-16',1,300,'I','25',3,1,0,'N'),(519,'1',938,'2018-05-16',1,300,'I','17',1,4,0,'N'),(520,'1',939,'2018-05-16',1,300,'I','17',1,1,0,'N'),(521,'1',940,'2018-05-17',1,300,'I','17',1,1,0,'N'),(522,'1',941,'2018-05-17',1,300,'I','17',1,3,0,'N'),(523,'1',942,'2018-05-18',1,300,'I','17',1,1,0,'N'),(524,'1',943,'2018-05-20',1,300,'I','17',1,1,0,'N'),(525,'1',944,'2018-05-20',1,300,'I','17',1,1,0,'N'),(526,'1',945,'2018-05-20',1,300,'I','17',1,1,0,'N'),(527,'1',946,'2018-05-21',1,300,'I','17',1,2,0,'N'),(528,'1',947,'2018-05-21',1,300,'I','25',3,1,0,'N'),(529,'1',948,'2018-05-21',1,300,'I','17',1,1,0,'N'),(530,'1',949,'2018-05-22',1,300,'I','17',1,1,0,'N'),(531,'1',950,'2018-05-23',1,300,'I','17',1,1,0,'N'),(532,'1',951,'2018-05-23',1,300,'I','17',1,1,0,'N'),(533,'1',952,'2018-05-25',1,300,'I','17',1,1,0,'N'),(534,'1',953,'2018-05-27',1,300,'I','17',1,1,0,'N'),(535,'1',954,'2018-05-29',1,300,'I','17',1,1,0,'N'),(536,'1',955,'2018-05-30',1,300,'I','17',1,2,0,'N'),(537,'1',956,'2018-06-01',1,300,'I','17',1,1,0,'N'),(538,'1',957,'2018-06-01',1,300,'I','17',1,1,0,'N'),(539,'1',958,'2018-06-02',1,300,'I','17',1,1,0,'N'),(540,'1',959,'2018-06-02',1,300,'I','17',1,1,0,'N'),(541,'1',959,'2018-06-02',1,300,'I','25',3,1,0,'N'),(542,'1',960,'2018-06-03',1,300,'I','17',1,1,0,'N'),(543,'1',961,'2018-06-05',1,300,'I','17',1,1,0,'N'),(544,'1',962,'2018-06-05',1,300,'I','17',1,2,0,'N'),(545,'1',963,'2018-06-06',1,300,'I','17',1,2,0,'N'),(546,'1',964,'2018-06-08',1,300,'I','17',1,1,0,'N'),(547,'1',965,'2018-06-12',1,300,'I','17',1,1,0,'N'),(548,'1',966,'2018-06-12',1,300,'I','17',1,2,0,'N'),(549,'1',967,'2018-06-13',1,300,'I','17',1,2,0,'N'),(550,'1',968,'2018-06-13',1,300,'I','17',1,1,0,'N'),(551,'1',968,'2018-06-13',1,300,'I','25',3,1,0,'N'),(552,'1',969,'2018-06-14',1,300,'I','17',1,1,0,'N'),(553,'1',969,'2018-06-14',1,300,'I','25',3,1,0,'N'),(554,'1',970,'2018-06-16',1,300,'I','17',1,2,0,'N'),(555,'1',971,'2018-06-17',1,300,'I','17',1,1,0,'N'),(556,'1',972,'2018-06-18',1,300,'I','17',1,1,0,'N'),(557,'1',973,'2018-06-18',1,300,'I','17',1,1,0,'N'),(558,'1',974,'2018-06-20',1,300,'I','17',1,1,0,'N'),(559,'1',974,'2018-06-20',1,300,'I','20',4,2,0,'N'),(560,'1',975,'2018-06-21',1,300,'I','17',1,1,0,'N'),(561,'1',976,'2018-06-21',1,300,'I','17',1,1,0,'N'),(562,'1',977,'2018-06-21',1,300,'I','17',1,1,0,'N'),(563,'1',978,'2018-06-21',1,300,'I','17',1,1,0,'N'),(564,'1',979,'2018-06-22',1,300,'I','17',1,3,0,'N'),(565,'1',980,'2018-06-23',1,300,'I','17',1,2,0,'N'),(566,'1',981,'2018-06-23',1,300,'I','17',1,3,0,'N'),(567,'1',982,'2018-06-23',1,300,'I','17',1,1,0,'N'),(568,'1',983,'2018-06-24',1,300,'I','17',1,1,0,'N'),(569,'1',984,'2018-06-24',1,300,'I','17',1,1,0,'N'),(570,'1',985,'2018-06-24',1,300,'I','17',1,1,0,'N'),(571,'1',986,'2018-06-25',1,300,'I','17',1,1,0,'N'),(572,'1',987,'2018-06-25',1,300,'I','17',1,1,0,'N'),(573,'1',988,'2018-06-25',1,300,'I','17',1,2,0,'N'),(574,'1',989,'2018-06-27',1,300,'I','17',1,1,0,'N'),(575,'1',989,'2018-06-27',1,300,'I','25',3,1,0,'N'),(576,'1',990,'2018-06-30',1,300,'I','20',4,2,0,'N'),(577,'1',991,'2018-07-02',1,300,'I','17',1,1,0,'N'),(578,'1',992,'2018-07-02',1,300,'I','17',1,2,0,'N'),(579,'1',993,'2018-07-04',1,300,'I','25',3,1,0,'N'),(580,'1',994,'2018-07-05',1,300,'I','20',4,1,0,'N'),(581,'1',995,'2018-07-06',1,300,'I','17',1,1,0,'N'),(582,'1',996,'2018-07-08',1,300,'I','17',1,1,0,'N'),(583,'1',996,'2018-07-08',1,300,'I','20',4,2,0,'N'),(584,'1',997,'2018-07-08',1,300,'I','17',1,1,0,'N'),(585,'1',998,'2018-07-10',1,300,'I','17',1,2,0,'N'),(586,'1',998,'2018-07-10',1,300,'I','25',3,1,0,'N'),(587,'1',999,'2018-07-13',1,300,'I','17',1,2,0,'N'),(588,'1',1000,'2018-07-13',1,300,'I','17',1,1,0,'N'),(589,'1',1001,'2018-07-15',1,300,'I','17',1,1,0,'N'),(590,'1',1001,'2018-07-15',1,300,'I','20',4,1,0,'N'),(591,'1',1001,'2018-07-15',1,300,'I','25',3,1,0,'N'),(592,'1',1002,'2018-07-17',1,300,'I','17',1,1,0,'N'),(593,'1',1003,'2018-07-17',1,300,'I','20',4,2,0,'N'),(594,'1',1004,'2018-07-18',1,300,'I','17',1,1,0,'N'),(595,'1',1005,'2018-07-19',1,300,'I','17',1,1,0,'N'),(596,'1',1005,'2018-07-19',1,300,'I','20',4,1,0,'N'),(597,'1',1006,'2018-07-21',1,300,'I','17',1,4,0,'N'),(598,'1',1007,'2018-07-22',1,300,'I','20',4,1,0,'N'),(599,'1',1008,'2018-07-23',1,300,'I','17',1,1,0,'N'),(600,'1',1009,'2018-07-23',1,300,'I','17',1,1,0,'N'),(601,'1',1010,'2018-07-27',1,300,'I','20',4,1,0,'N'),(602,'1',1011,'2018-07-27',1,300,'I','17',1,2,0,'N'),(603,'1',1012,'2018-07-28',1,300,'I','17',1,1,0,'N'),(604,'1',1013,'2018-07-30',1,300,'I','17',1,1,0,'N'),(605,'1',1014,'2018-07-31',1,300,'I','17',1,2,0,'N'),(606,'1',1015,'2018-08-01',1,300,'I','17',1,1,0,'N'),(607,'1',1016,'2018-08-02',1,300,'I','17',1,3,0,'N'),(608,'1',1017,'2018-08-04',1,300,'I','17',1,3,0,'N'),(609,'1',1018,'2018-08-05',1,300,'I','17',1,1,0,'N'),(610,'1',1018,'2018-08-05',1,300,'I','25',3,1,0,'N'),(611,'1',1019,'2018-08-06',1,300,'I','17',1,1,0,'N'),(612,'1',1020,'2018-08-07',1,300,'I','17',1,1,0,'N'),(613,'1',1020,'2018-08-07',1,300,'I','25',3,1,0,'N'),(614,'1',1021,'2018-08-08',1,300,'I','17',1,2,0,'N'),(615,'1',1022,'2018-08-08',1,300,'I','17',1,2,0,'N'),(616,'1',1023,'2018-08-08',1,300,'I','17',1,1,0,'N'),(617,'1',1024,'2018-08-08',1,300,'I','17',1,1,0,'N'),(618,'1',1025,'2018-08-08',1,300,'I','25',3,1,0,'N'),(619,'1',1026,'2018-08-09',1,300,'I','17',1,1,0,'N'),(620,'1',1027,'2018-08-09',1,300,'I','17',1,2,0,'N'),(621,'1',1028,'2018-08-10',1,300,'I','17',1,3,0,'N'),(622,'1',1029,'2018-08-11',1,300,'I','25',3,2,0,'N'),(623,'1',1030,'2018-08-11',1,300,'I','17',1,1,0,'N'),(624,'1',1030,'2018-08-11',1,300,'I','25',3,1,0,'N'),(625,'1',1031,'2018-08-12',1,300,'I','25',3,2,0,'N'),(626,'1',1032,'2018-08-14',1,300,'I','17',1,1,0,'N'),(627,'1',1033,'2018-08-15',1,300,'I','17',1,1,0,'N'),(628,'1',1034,'2018-08-15',1,300,'I','17',1,1,0,'N'),(629,'1',1035,'2018-08-16',1,300,'I','17',1,1,0,'N'),(630,'1',1036,'2018-08-16',1,300,'I','17',1,1,0,'N'),(631,'1',1040,'2018-08-22',1,300,'I','17',1,2,0,'N'),(632,'1',1041,'2018-08-22',1,300,'I','17',1,1,0,'N'),(633,'1',1042,'2018-08-22',1,300,'I','17',1,1,0,'N'),(634,'1',1043,'2018-08-22',1,300,'I','17',1,2,0,'N'),(635,'1',1044,'2018-08-24',1,300,'I','17',1,2,0,'N'),(636,'1',1045,'2018-08-26',1,300,'I','17',1,1,0,'N'),(637,'1',1045,'2018-08-26',1,300,'I','20',4,1,0,'N'),(638,'1',1046,'2018-08-27',1,300,'I','17',1,1,0,'N'),(639,'1',1047,'2018-08-28',1,300,'I','17',1,2,0,'N'),(640,'1',1047,'2018-08-28',1,300,'I','25',3,1,0,'N'),(641,'1',1048,'2018-08-29',1,300,'I','17',1,1,0,'N'),(642,'1',1049,'2018-08-31',1,300,'I','17',1,1,0,'N'),(643,'1',1050,'2018-09-01',1,300,'I','17',1,1,0,'N'),(644,'1',1051,'2018-09-01',1,300,'I','17',1,1,0,'N'),(645,'1',1052,'2018-09-01',1,300,'I','25',3,1,0,'N'),(646,'1',1053,'2018-09-01',1,300,'I','17',1,2,0,'N'),(647,'1',1054,'2018-09-03',1,300,'I','17',1,2,0,'N'),(648,'1',1054,'2018-09-03',1,300,'I','20',4,1,0,'N'),(649,'1',1055,'2018-09-05',1,300,'I','17',1,1,0,'N'),(650,'1',1056,'2018-09-09',1,300,'I','17',1,1,0,'N'),(651,'1',1057,'2018-09-09',1,300,'I','17',1,1,0,'N'),(652,'1',1058,'2018-09-10',1,300,'I','17',1,1,0,'N'),(653,'1',1059,'2018-09-10',1,300,'I','17',1,1,0,'N'),(654,'1',1060,'2018-09-11',1,300,'I','17',1,1,0,'N'),(655,'1',1061,'2018-09-11',1,300,'I','17',1,2,0,'N'),(656,'1',1062,'2018-09-11',1,300,'I','17',1,2,0,'N'),(657,'1',1063,'2018-09-11',1,300,'I','17',1,2,0,'N'),(658,'1',1064,'2018-09-11',1,300,'I','20',4,1,0,'N'),(659,'1',1065,'2018-09-13',1,300,'I','17',1,1,0,'N'),(660,'1',1066,'2018-09-14',1,300,'I','17',1,1,0,'N'),(661,'1',1067,'2018-09-14',1,300,'I','17',1,3,0,'N'),(662,'1',1068,'2018-09-15',1,300,'I','25',3,2,0,'N'),(663,'1',1069,'2018-09-15',1,300,'I','17',1,1,0,'N'),(664,'1',1069,'2018-09-15',1,300,'I','25',3,1,0,'N'),(665,'1',1070,'2018-09-15',1,300,'I','17',1,1,0,'N'),(666,'1',1071,'2018-09-17',1,300,'I','20',4,2,0,'N'),(667,'1',1072,'2018-09-19',1,300,'I','17',1,1,0,'N'),(668,'1',1073,'2018-09-19',1,300,'I','17',1,1,0,'N'),(669,'1',1073,'2018-09-19',1,300,'I','20',4,1,0,'N'),(670,'1',1074,'2018-09-21',1,300,'I','17',1,2,0,'N'),(671,'1',1074,'2018-09-21',1,300,'I','20',4,1,0,'N'),(672,'1',1075,'2018-09-23',1,300,'I','17',1,1,0,'N'),(673,'1',1076,'2018-09-24',1,300,'I','17',1,2,0,'N'),(674,'1',1076,'2018-09-24',1,300,'I','20',4,1,0,'N'),(675,'1',1077,'2018-09-25',1,300,'I','17',1,1,0,'N'),(676,'1',1078,'2018-09-25',1,300,'I','17',1,2,0,'N'),(677,'1',1079,'2018-09-26',1,300,'I','17',1,1,0,'N'),(678,'1',1080,'2018-09-27',1,300,'I','17',1,1,0,'N'),(679,'1',1081,'2018-09-29',1,300,'I','17',1,1,0,'N'),(680,'1',1082,'2018-09-29',1,300,'I','17',1,2,0,'N'),(681,'1',1083,'2018-09-30',1,300,'I','17',1,2,0,'N'),(682,'1',1084,'2018-09-30',1,300,'I','25',3,1,0,'N'),(683,'1',1085,'2018-09-30',1,300,'I','25',3,3,0,'N'),(684,'1',1086,'2018-09-30',1,300,'I','17',1,1,0,'N'),(685,'1',1087,'2018-10-01',1,300,'I','17',1,2,0,'N'),(686,'1',1088,'2018-10-01',1,300,'I','20',4,1,0,'N'),(687,'1',1089,'2018-10-02',1,300,'I','17',1,1,0,'N'),(688,'1',1089,'2018-10-02',1,300,'I','25',3,2,0,'N'),(689,'1',1090,'2018-10-03',1,300,'I','17',1,2,0,'N'),(690,'1',1091,'2018-10-03',1,300,'I','17',1,3,0,'N'),(691,'1',1092,'2018-10-04',1,300,'I','17',1,2,0,'N'),(692,'1',1093,'2018-10-04',1,300,'I','17',1,1,0,'N'),(693,'1',1094,'2018-10-05',1,300,'I','17',1,2,0,'N'),(694,'1',1095,'2018-10-07',1,300,'I','17',1,2,0,'N'),(695,'1',1096,'2018-10-07',1,300,'I','25',3,1,0,'N'),(696,'1',1097,'2018-10-07',1,300,'I','17',1,3,0,'N'),(697,'1',1098,'2018-10-07',1,300,'I','17',1,1,0,'N'),(698,'1',1099,'2018-10-10',1,300,'I','17',1,1,0,'N'),(699,'1',1101,'2018-10-12',1,300,'I','17',1,3,0,'N'),(700,'1',1102,'2018-10-13',1,300,'I','17',1,1,0,'N'),(701,'1',1103,'2018-10-13',1,300,'I','17',1,2,0,'N'),(702,'1',1104,'2018-10-14',1,300,'I','17',1,4,0,'N'),(703,'1',1105,'2018-10-16',1,300,'I','25',3,1,0,'N'),(704,'1',1106,'2018-10-16',1,300,'I','17',1,1,0,'N'),(705,'1',1107,'2018-10-17',1,300,'I','17',1,4,0,'N'),(706,'1',1108,'2018-10-17',1,300,'I','17',1,1,0,'N'),(707,'1',1109,'2018-10-17',1,300,'I','17',1,2,0,'N'),(708,'1',1110,'2018-10-17',1,300,'I','25',3,2,0,'N'),(709,'1',1111,'2018-10-18',1,300,'I','17',1,1,0,'N'),(710,'1',1113,'2018-10-19',1,300,'I','17',1,1,0,'N'),(711,'1',1114,'2018-10-19',1,300,'I','17',1,1,0,'N'),(712,'1',1115,'2018-10-19',1,300,'I','17',1,1,0,'N'),(713,'1',1116,'2018-10-19',1,300,'I','17',1,1,0,'N'),(714,'1',1117,'2018-10-20',1,300,'I','17',1,2,0,'N'),(715,'1',1118,'2018-10-20',1,300,'I','17',1,2,0,'N'),(716,'1',1119,'2018-10-20',1,300,'I','17',1,2,0,'N'),(717,'1',1120,'2018-10-20',1,300,'I','17',1,1,0,'N'),(718,'1',1121,'2018-10-20',1,300,'I','17',1,1,0,'N'),(719,'1',1121,'2018-10-20',1,300,'I','25',3,1,0,'N'),(720,'1',1122,'2018-10-20',1,300,'I','17',1,1,0,'N'),(721,'1',1122,'2018-10-20',1,300,'I','25',3,1,0,'N'),(722,'1',1123,'2018-10-22',1,300,'I','17',1,2,0,'N'),(723,'1',1124,'2018-10-22',1,300,'I','17',1,2,0,'N'),(724,'1',1125,'2018-10-23',1,300,'I','17',1,3,0,'N'),(725,'1',1126,'2018-10-23',1,300,'I','17',1,4,0,'N'),(726,'1',1127,'2018-10-23',1,300,'I','17',1,1,0,'N'),(727,'1',1127,'2018-10-23',1,300,'I','20',4,1,0,'N'),(728,'1',1128,'2018-10-23',1,300,'I','17',1,1,0,'N'),(729,'1',1129,'2018-10-24',1,300,'I','17',1,2,0,'N'),(730,'1',1130,'2018-10-24',1,300,'I','17',1,1,0,'N'),(731,'1',1131,'2018-10-24',1,300,'I','17',1,4,0,'N'),(732,'1',1132,'2018-10-26',1,300,'I','5',5,1,0,'N'),(733,'1',1133,'2018-10-26',1,300,'I','17',1,1,0,'N'),(734,'1',1134,'2018-10-26',1,300,'I','5',5,2,0,'N'),(735,'1',1135,'2018-10-26',1,300,'I','17',1,2,0,'N'),(736,'1',1135,'2018-10-26',1,300,'I','5',5,1,0,'N'),(737,'1',1136,'2018-10-27',1,300,'I','17',1,4,0,'N'),(738,'1',1136,'2018-10-27',1,300,'I','5',5,1,0,'N'),(739,'1',1137,'2018-10-30',1,300,'I','17',1,1,0,'N'),(740,'1',1138,'2018-10-30',1,300,'I','17',1,1,0,'N'),(741,'1',1139,'2018-10-30',1,300,'I','17',1,1,0,'N'),(742,'1',1140,'2018-10-30',1,300,'I','17',1,1,0,'N'),(743,'1',1141,'2018-10-30',1,300,'I','17',1,1,0,'N'),(744,'1',1141,'2018-10-30',1,300,'I','5',5,1,0,'N'),(745,'1',1142,'2018-10-30',1,300,'I','5',5,1,0,'N'),(746,'1',1143,'2018-10-30',1,300,'I','17',1,1,0,'N'),(747,'1',1144,'2018-10-31',1,300,'I','5',5,1,0,'N'),(748,'1',1145,'2018-10-31',1,300,'I','30',2,2,0,'N'),(749,'1',1146,'2018-11-02',1,300,'I','20',4,1,0,'N'),(750,'1',1147,'2018-11-05',1,300,'I','5',5,2,0,'N'),(751,'1',1148,'2018-11-06',1,300,'I','5',5,1,0,'N'),(752,'1',1149,'2018-11-06',1,300,'I','17',1,1,0,'N'),(753,'1',1150,'2018-11-06',1,300,'I','17',1,1,0,'N'),(754,'1',1151,'2018-11-07',1,300,'I','17',1,1,0,'N'),(755,'1',1152,'2018-11-07',1,300,'I','17',1,3,0,'N'),(756,'1',1153,'2018-11-07',1,300,'I','17',1,1,0,'N'),(757,'1',1154,'2018-11-07',1,300,'I','17',1,1,0,'N'),(758,'1',1155,'2018-11-07',1,300,'I','17',1,1,0,'N'),(759,'1',1156,'2018-11-08',1,300,'I','17',1,1,0,'N'),(760,'1',1157,'2018-11-08',1,300,'I','17',1,1,0,'N'),(761,'1',1158,'2018-11-08',1,300,'I','17',1,1,0,'N'),(762,'1',1159,'2018-11-09',1,300,'I','17',1,1,0,'N'),(763,'1',1160,'2018-11-09',1,300,'I','17',1,3,0,'N'),(764,'1',1161,'2018-11-09',1,300,'I','17',1,1,0,'N'),(765,'1',1162,'2018-11-10',1,300,'I','17',1,1,0,'N'),(766,'1',1163,'2018-11-10',1,300,'I','17',1,1,0,'N'),(767,'1',1164,'2018-11-11',1,300,'I','17',1,2,0,'N'),(768,'1',1165,'2018-11-11',1,300,'I','17',1,1,0,'N'),(769,'1',1166,'2018-11-12',1,300,'I','17',1,2,0,'N'),(770,'1',1166,'2018-11-12',1,300,'I','5',5,1,0,'N'),(771,'1',1167,'2018-11-12',1,300,'I','5',5,1,0,'N'),(772,'1',1168,'2018-11-13',1,300,'I','20',4,1,0,'N'),(773,'1',1169,'2018-11-13',1,300,'I','17',1,1,0,'N'),(774,'1',1170,'2018-11-13',1,300,'I','17',1,1,0,'N'),(775,'1',1171,'2018-11-14',1,300,'I','17',1,1,0,'N'),(776,'1',1172,'2018-11-14',1,300,'I','17',1,2,0,'N'),(777,'1',1173,'2018-11-14',1,300,'I','5',5,1,0,'N'),(778,'1',1174,'2018-11-15',1,300,'I','17',1,1,0,'N'),(779,'1',1175,'2018-11-16',1,300,'I','17',1,2,0,'N'),(780,'1',1176,'2018-11-16',1,300,'I','17',1,1,0,'N'),(781,'1',1177,'2018-11-17',1,300,'I','17',1,1,0,'N'),(782,'1',1178,'2018-11-17',1,300,'I','17',1,2,0,'N'),(783,'1',1179,'2018-11-18',1,300,'I','17',1,1,0,'N'),(784,'1',1180,'2018-11-19',1,300,'I','17',1,1,0,'N'),(785,'1',1181,'2018-11-19',1,300,'I','17',1,1,0,'N'),(786,'1',1182,'2018-11-20',1,300,'I','17',1,1,0,'N'),(787,'1',1183,'2018-11-20',1,300,'I','17',1,1,0,'N'),(788,'1',1184,'2018-11-20',1,300,'I','17',1,1,0,'N'),(789,'1',1185,'2018-11-21',1,300,'I','17',1,2,0,'N'),(790,'1',1186,'2018-11-22',1,300,'I','17',1,1,0,'N'),(791,'1',1187,'2018-11-22',1,300,'I','17',1,1,0,'N'),(792,'1',1188,'2018-11-22',1,300,'I','5',5,1,0,'N'),(793,'1',1189,'2018-11-23',1,300,'I','5',5,2,0,'N'),(794,'1',1190,'2018-11-24',1,300,'I','17',1,1,0,'N'),(795,'1',1191,'2018-11-24',1,300,'I','17',1,1,0,'N'),(796,'1',1192,'2018-11-24',1,300,'I','17',1,1,0,'N'),(797,'1',1193,'2018-11-25',1,300,'I','17',1,1,0,'N'),(798,'1',1194,'2018-11-28',1,300,'I','17',1,1,0,'N'),(799,'1',1195,'2018-11-29',1,300,'I','5',5,1,0,'N'),(800,'1',1195,'2018-11-29',1,300,'I','17',1,1,0,'N'),(801,'1',1196,'2018-11-30',1,300,'I','17',1,1,0,'N'),(802,'1',1196,'2018-11-30',1,300,'I','5',5,1,0,'N'),(803,'1',1197,'2018-11-30',1,300,'I','17',1,1,0,'N'),(804,'1',1197,'2018-11-30',1,300,'I','5',5,1,0,'N'),(805,'1',1198,'2018-11-30',1,300,'I','5',5,1,0,'N'),(806,'1',1199,'2018-12-02',1,300,'I','17',1,2,0,'N'),(807,'1',1200,'2018-12-02',1,300,'I','17',1,1,0,'N'),(808,'1',1201,'2018-12-03',1,300,'I','17',1,2,0,'N'),(809,'1',1202,'2018-12-03',1,300,'I','17',1,1,0,'N'),(810,'1',1203,'2018-12-03',1,300,'I','17',1,1,0,'N'),(811,'1',1204,'2018-12-03',1,300,'I','17',1,1,0,'N'),(812,'1',1205,'2018-12-03',1,300,'I','17',1,1,0,'N'),(813,'1',1206,'2018-12-03',1,300,'I','17',1,2,0,'N'),(814,'1',1207,'2018-12-03',1,300,'I','17',1,1,0,'N'),(815,'1',1208,'2018-12-04',1,300,'I','17',1,2,0,'N'),(816,'1',1209,'2018-12-05',1,300,'I','17',1,1,0,'N'),(817,'1',1210,'2018-12-05',1,300,'I','17',1,1,0,'N'),(818,'1',1211,'2018-12-05',1,300,'I','17',1,2,0,'N'),(819,'1',1212,'2018-12-05',1,300,'I','17',1,1,0,'N'),(820,'1',1213,'2018-12-05',1,300,'I','17',1,2,0,'N'),(821,'1',1214,'2018-12-07',1,300,'I','17',1,2,0,'N'),(822,'1',1215,'2018-12-08',1,300,'I','17',1,2,0,'N'),(823,'1',1216,'2018-12-08',1,300,'I','17',1,2,0,'N'),(824,'1',1217,'2018-12-08',1,300,'I','5',5,1,0,'N'),(825,'1',1218,'2018-12-09',1,300,'I','17',1,1,0,'N'),(826,'1',1219,'2018-12-09',1,300,'I','17',1,2,0,'N'),(827,'1',1220,'2018-12-09',1,300,'I','17',1,1,0,'N'),(828,'1',1221,'2018-12-09',1,300,'I','17',1,1,0,'N'),(829,'1',1221,'2018-12-09',1,300,'I','5',5,1,0,'N'),(830,'1',1222,'2018-12-11',1,300,'I','17',1,2,0,'N'),(831,'1',1223,'2018-12-12',1,300,'I','17',1,1,0,'N'),(832,'1',1224,'2018-12-12',1,300,'I','17',1,1,0,'N'),(833,'1',1225,'2018-12-13',1,300,'I','17',1,1,0,'N'),(834,'1',1226,'2018-12-13',1,300,'I','17',1,1,0,'N'),(835,'1',1227,'2018-12-15',1,300,'I','17',1,1,0,'N'),(836,'1',1227,'2018-12-15',1,300,'I','5',5,1,0,'N'),(837,'1',1228,'2018-12-16',1,300,'I','17',1,1,0,'N'),(838,'1',1229,'2018-12-16',1,300,'I','5',5,1,0,'N'),(839,'1',1230,'2018-12-16',1,300,'I','17',1,1,0,'N'),(840,'1',1231,'2018-12-16',1,300,'I','17',1,1,0,'N'),(841,'1',1232,'2018-12-17',1,300,'I','17',1,1,0,'N'),(842,'1',1233,'2018-12-17',1,300,'I','17',1,1,0,'N'),(843,'1',1234,'2018-12-18',1,300,'I','17',1,1,0,'N'),(844,'1',1235,'2018-12-19',1,300,'I','17',1,1,0,'N'),(845,'1',1236,'2018-12-19',1,300,'I','5',5,1,0,'N'),(846,'1',1237,'2018-12-21',1,300,'I','17',1,1,0,'N'),(847,'1',1237,'2018-12-21',1,300,'I','5',5,2,0,'N'),(848,'1',1238,'2018-12-22',1,300,'I','17',1,1,0,'N'),(849,'1',1238,'2018-12-22',1,300,'I','5',5,1,0,'N'),(850,'1',1239,'2018-12-22',1,300,'I','17',1,2,0,'N'),(851,'1',1240,'2018-12-23',1,300,'I','17',1,2,0,'N'),(852,'1',1241,'2018-12-23',1,300,'I','17',1,2,0,'N'),(853,'1',1242,'2018-12-23',1,300,'I','17',1,1,0,'N'),(854,'1',1243,'2018-12-24',1,300,'I','17',1,1,0,'N'),(855,'1',1244,'2018-12-24',1,300,'I','17',1,3,0,'N'),(856,'1',1245,'2018-12-25',1,300,'I','17',1,2,0,'N'),(857,'1',1246,'2018-12-26',1,300,'I','17',1,1,0,'N'),(858,'1',1247,'2018-12-26',1,300,'I','17',1,1,0,'N'),(859,'1',1248,'2018-12-26',1,300,'I','17',1,1,0,'N'),(860,'1',1249,'2018-12-27',1,300,'I','17',1,1,0,'N'),(861,'1',1250,'2018-12-28',1,300,'I','30',2,1,0,'N'),(862,'1',1252,'2018-12-28',1,300,'I','17',1,1,0,'N'),(863,'1',1253,'2018-12-28',1,300,'I','17',1,2,0,'N'),(864,'1',1254,'2018-12-28',1,300,'I','17',1,3,0,'N'),(865,'1',1255,'2018-12-29',1,300,'I','17',1,2,0,'N'),(866,'1',1256,'2018-12-30',1,300,'I','17',1,1,0,'N'),(867,'1',1256,'2018-12-30',1,300,'I','5',5,1,0,'N'),(868,'1',1257,'2018-12-30',1,300,'I','17',1,1,0,'N'),(869,'1',1258,'2018-12-30',1,300,'I','17',1,1,0,'N'),(870,'1',1259,'2018-12-31',1,300,'I','17',1,1,0,'N'),(871,'1',1260,'2019-01-01',1,300,'I','17',1,2,0,'N'),(872,'1',1261,'2019-01-01',1,300,'I','17',1,2,0,'N'),(873,'1',1262,'2019-01-02',1,300,'I','17',1,1,0,'N'),(874,'1',1263,'2019-01-02',1,300,'I','17',1,2,0,'N'),(875,'1',1264,'2019-01-02',1,300,'I','17',1,1,0,'N'),(876,'1',1265,'2019-01-03',1,300,'I','17',1,1,0,'N'),(877,'1',1266,'2019-01-03',1,300,'I','17',1,1,0,'N'),(878,'1',1267,'2019-01-03',1,300,'I','17',1,1,0,'N'),(879,'1',1268,'2019-01-03',1,300,'I','17',1,1,0,'N'),(880,'1',1269,'2019-01-04',1,300,'I','17',1,1,0,'N'),(881,'1',1270,'2019-01-04',1,300,'I','17',1,1,0,'N'),(882,'1',1271,'2019-01-04',1,300,'I','17',1,1,0,'N'),(883,'1',1272,'2019-01-05',1,300,'I','17',1,1,0,'N'),(884,'1',1273,'2019-01-05',1,300,'I','17',1,1,0,'N'),(885,'1',1274,'2019-01-05',1,300,'I','17',1,1,0,'N'),(886,'1',1275,'2019-01-06',1,300,'I','17',1,2,0,'N'),(887,'1',1276,'2019-01-07',1,300,'I','17',1,2,0,'N'),(888,'1',1277,'2019-01-09',1,300,'I','5',5,1,0,'N'),(889,'1',1278,'2019-01-09',1,300,'I','17',1,1,0,'N'),(890,'1',1278,'2019-01-09',1,300,'I','5',5,1,0,'N'),(891,'1',1279,'2019-01-09',1,300,'I','17',1,1,0,'N'),(892,'1',1280,'2019-01-10',1,300,'I','17',1,1,0,'N'),(893,'1',1281,'2019-01-10',1,300,'I','17',1,1,0,'N'),(894,'1',1282,'2019-01-13',1,300,'I','17',1,1,0,'N'),(895,'1',1282,'2019-01-13',1,300,'I','5',5,1,0,'N'),(896,'1',1283,'2019-01-13',1,300,'I','5',5,1,0,'N'),(897,'1',1284,'2019-01-13',1,300,'I','17',1,1,0,'N'),(898,'1',1285,'2019-01-13',1,300,'I','5',5,1,0,'N'),(899,'1',1286,'2019-01-13',1,300,'I','5',5,1,0,'N'),(900,'1',1287,'2019-01-13',1,300,'I','17',1,1,0,'N'),(901,'1',1288,'2019-01-15',1,300,'I','17',1,1,0,'N'),(902,'1',1289,'2019-01-16',1,300,'I','17',1,2,0,'N'),(903,'1',1290,'2019-01-16',1,300,'I','5',5,1,0,'N'),(904,'1',1291,'2019-01-16',1,300,'I','17',1,1,0,'N'),(905,'1',1292,'2019-01-17',1,300,'I','17',1,1,0,'N'),(906,'1',1293,'2019-01-17',1,300,'I','17',1,2,0,'N'),(907,'1',1294,'2019-01-18',1,300,'I','17',1,1,0,'N'),(908,'1',1295,'2019-01-18',1,300,'I','17',1,2,0,'N'),(909,'1',1296,'2019-01-19',1,300,'I','17',1,2,0,'N'),(910,'1',1297,'2019-01-19',1,300,'I','5',5,1,0,'N'),(911,'1',1298,'2019-01-21',1,300,'I','5',5,1,0,'N'),(912,'1',1299,'2019-01-22',1,300,'I','17',1,1,0,'N'),(913,'1',1300,'2019-01-22',1,300,'I','17',1,1,0,'N'),(914,'1',1301,'2019-01-22',1,300,'I','17',1,1,0,'N'),(915,'1',1302,'2019-01-23',1,300,'I','17',1,2,0,'N'),(916,'1',1303,'2019-01-23',1,300,'I','17',1,1,0,'N'),(917,'1',1304,'2019-01-23',1,300,'I','17',1,1,0,'N'),(918,'1',1305,'2019-01-25',1,300,'I','17',1,1,0,'N'),(919,'1',1306,'2019-01-25',1,300,'I','17',1,1,0,'N'),(920,'1',1307,'2019-01-26',1,300,'I','17',1,3,0,'N'),(921,'1',1308,'2019-01-27',1,300,'I','17',1,1,0,'N'),(922,'1',1309,'2019-01-27',1,300,'I','5',5,3,0,'N'),(923,'1',1310,'2019-01-27',1,300,'I','17',1,1,0,'N'),(924,'1',1311,'2019-01-28',1,300,'I','17',1,1,0,'N'),(925,'1',1312,'2019-01-30',1,300,'I','17',1,1,0,'N'),(926,'1',1313,'2019-01-30',1,300,'I','17',1,2,0,'N'),(927,'1',1314,'2019-01-30',1,300,'I','17',1,1,0,'N'),(928,'1',1315,'2019-02-17',1,300,'I','17',1,4,0,'N'),(929,'1',1316,'2019-02-17',1,300,'I','17',1,1,0,'N'),(930,'1',1317,'2019-02-18',1,300,'I','17',1,2,0,'N'),(931,'1',1318,'2019-02-19',1,300,'I','17',1,1,0,'N'),(932,'1',1319,'2019-02-19',1,300,'I','17',1,2,0,'N'),(933,'1',1320,'2019-02-19',1,300,'I','17',1,2,0,'N'),(934,'1',1321,'2019-02-19',1,300,'I','17',1,2,0,'N'),(935,'1',1322,'2019-02-19',1,300,'I','17',1,4,0,'N'),(936,'1',1323,'2019-02-20',1,300,'I','17',1,1,0,'N'),(937,'1',1324,'2019-02-20',1,300,'I','17',1,1,0,'N'),(938,'1',1325,'2019-03-01',1,300,'I','17',1,1,0,'N'),(939,'1',1325,'2019-03-01',1,300,'I','5',5,1,0,'N'),(940,'1',1326,'2019-03-02',1,300,'I','17',1,1,0,'N'),(941,'1',1327,'2019-03-02',1,300,'I','17',1,1,0,'N'),(942,'1',1328,'2019-03-02',1,300,'I','17',1,1,0,'N'),(943,'1',1328,'2019-03-02',1,300,'I','5',5,2,0,'N'),(944,'1',1329,'2019-03-02',1,300,'I','5',5,1,0,'N'),(945,'1',1330,'2019-03-03',1,300,'I','17',1,2,0,'N'),(946,'1',1331,'2019-03-05',1,300,'I','17',1,1,0,'N'),(947,'1',1332,'2019-03-06',1,300,'I','17',1,1,0,'N'),(948,'1',1333,'2019-03-07',1,300,'I','17',1,1,0,'N'),(949,'1',1334,'2019-03-14',1,300,'I','30',2,1,0,'N'),(950,'1',1335,'2019-03-18',1,300,'I','5',5,5,0,'N'),(951,'1',1336,'2019-03-18',1,300,'I','17',1,1,0,'N'),(952,'1',1337,'2019-03-18',1,300,'I','17',1,1,0,'N'),(953,'1',1338,'2019-03-18',1,300,'I','17',1,2,0,'N'),(954,'1',1339,'2019-03-18',1,300,'I','17',1,1,0,'N'),(955,'1',1340,'2019-03-20',1,300,'I','17',1,1,0,'N'),(956,'1',1341,'2019-03-20',1,300,'I','17',1,1,0,'N'),(957,'1',1342,'2019-03-21',1,300,'I','17',1,1,0,'N'),(958,'1',1343,'2019-03-21',1,300,'I','17',1,1,0,'N'),(959,'1',1343,'2019-03-21',1,300,'I','5',5,1,0,'N'),(960,'1',1344,'2019-03-22',1,300,'I','17',1,2,0,'N'),(961,'1',1345,'2019-03-22',1,300,'I','17',1,3,0,'N'),(962,'1',1346,'2019-03-23',1,300,'I','17',1,2,0,'N'),(963,'1',1347,'2019-03-28',1,300,'I','17',1,1,0,'N'),(964,'1',1348,'2019-03-30',1,300,'I','17',1,1,0,'N'),(965,'1',1349,'2019-03-30',1,300,'I','17',1,1,0,'N'),(966,'1',1350,'2019-03-30',1,300,'I','17',1,2,0,'N'),(967,'1',1351,'2019-03-30',1,300,'I','17',1,1,0,'N'),(968,'1',1352,'2019-03-30',1,300,'I','17',1,2,0,'N'),(969,'1',1353,'2019-03-31',1,300,'I','17',1,2,0,'N'),(970,'1',1354,'2019-03-31',1,300,'I','17',1,2,0,'N'),(971,'1',1355,'2019-03-31',1,300,'I','17',1,1,0,'N'),(972,'1',1356,'2019-04-01',1,300,'I','17',1,1,0,'N'),(973,'1',1357,'2019-04-02',1,300,'I','17',1,2,0,'N'),(974,'1',1358,'2019-04-02',1,300,'I','17',1,4,0,'N'),(975,'1',1359,'2019-04-02',1,300,'I','17',1,1,0,'N'),(976,'1',1360,'2019-04-03',1,300,'I','17',1,1,0,'N'),(977,'1',1361,'2019-04-04',1,300,'I','17',1,1,0,'N'),(978,'1',1362,'2019-04-04',1,300,'I','17',1,1,0,'N'),(979,'1',1363,'2019-04-04',1,300,'I','17',1,1,0,'N'),(980,'1',1364,'2019-04-04',1,300,'I','17',1,1,0,'N'),(981,'1',1365,'2019-04-04',1,300,'I','17',1,1,0,'N'),(982,'1',1366,'2019-04-05',1,300,'I','17',1,1,0,'N'),(983,'1',1367,'2019-04-06',1,300,'I','17',1,1,0,'N'),(984,'1',1368,'2019-04-08',1,300,'I','17',1,2,0,'N'),(985,'1',1369,'2019-04-09',1,300,'I','17',1,1,0,'N'),(986,'1',1370,'2019-04-09',1,300,'I','17',1,3,0,'N'),(987,'1',1371,'2019-04-09',1,300,'I','17',1,1,0,'N'),(988,'1',1372,'2019-04-09',1,300,'I','17',1,1,0,'N'),(989,'1',1373,'2019-04-10',1,300,'I','17',1,1,0,'N'),(990,'1',1374,'2019-04-11',1,300,'I','17',1,2,0,'N'),(991,'1',1375,'2019-04-11',1,300,'I','17',1,1,0,'N'),(992,'1',1376,'2019-04-13',1,300,'I','17',1,2,0,'N'),(993,'1',1377,'2019-04-13',1,300,'I','17',1,1,0,'N'),(994,'1',1378,'2019-04-13',1,300,'I','17',1,2,0,'N'),(995,'1',1379,'2019-04-14',1,300,'I','17',1,1,0,'N'),(996,'1',1380,'2019-04-14',1,300,'I','17',1,3,0,'N'),(997,'1',1381,'2019-04-14',1,300,'I','17',1,1,0,'N'),(998,'1',1382,'2019-04-15',1,300,'I','17',1,1,0,'N'),(999,'1',1383,'2019-04-16',1,300,'I','17',1,1,0,'N'),(1000,'1',1384,'2019-04-16',1,300,'I','17',1,1,0,'N'),(1001,'1',1385,'2019-04-16',1,300,'I','5',5,4,0,'N'),(1002,'1',1386,'2019-04-17',1,300,'I','5',5,1,0,'N'),(1003,'1',1387,'2019-04-20',1,300,'I','17',1,1,0,'N'),(1004,'1',1388,'2019-04-21',1,300,'I','17',1,1,0,'N'),(1005,'1',1389,'2019-04-22',1,300,'I','17',1,1,0,'N'),(1006,'1',1390,'2019-04-22',1,300,'I','17',1,1,0,'N'),(1007,'1',1391,'2019-04-23',1,300,'I','17',1,1,0,'N'),(1008,'1',1392,'2019-04-24',1,300,'I','17',1,1,0,'N'),(1009,'1',1393,'2019-04-25',1,300,'I','17',1,2,0,'N'),(1010,'1',1394,'2019-04-25',1,300,'I','17',1,1,0,'N'),(1011,'1',1395,'2019-04-25',1,300,'I','17',1,1,0,'N'),(1012,'1',1396,'2019-04-27',1,300,'I','17',1,2,0,'N'),(1013,'1',1397,'2019-04-28',1,300,'I','17',1,1,0,'N'),(1014,'1',1398,'2019-04-28',1,300,'I','17',1,1,0,'N'),(1015,'1',1399,'2019-04-29',1,300,'I','17',1,1,0,'N'),(1016,'1',1400,'2019-04-29',1,300,'I','17',1,1,0,'N'),(1017,'1',1401,'2019-04-29',1,300,'I','5',5,1,0,'N'),(1018,'1',1402,'2019-04-30',1,300,'I','17',1,2,0,'N'),(1019,'1',1403,'2019-04-30',1,300,'I','17',1,2,0,'N'),(1020,'1',1404,'2019-04-30',1,300,'I','17',1,2,0,'N'),(1021,'1',1405,'2019-04-30',1,300,'I','17',1,1,0,'N'),(1022,'1',1406,'2019-04-30',1,300,'I','5',5,1,0,'N'),(1023,'1',1407,'2019-04-30',1,300,'I','17',1,1,0,'N'),(1024,'1',1407,'2019-04-30',1,300,'I','5',5,1,0,'N'),(1025,'1',1408,'2019-04-30',1,300,'I','17',1,2,0,'N'),(1026,'1',1409,'2019-05-01',1,300,'I','17',1,1,0,'N'),(1027,'1',1410,'2019-05-01',1,300,'I','17',1,1,0,'N'),(1028,'1',1411,'2019-05-02',1,300,'I','17',1,1,0,'N'),(1029,'1',1412,'2019-05-02',1,300,'I','17',1,1,0,'N'),(1030,'1',1413,'2019-05-03',1,300,'I','17',1,1,0,'N'),(1031,'1',1414,'2019-05-03',1,300,'I','17',1,1,0,'N'),(1032,'1',1415,'2019-05-03',1,300,'I','17',1,1,0,'N'),(1033,'1',1416,'2019-05-03',1,300,'I','17',1,2,0,'N'),(1034,'1',1417,'2019-05-03',1,300,'I','17',1,1,0,'N'),(1035,'1',1418,'2019-05-04',1,300,'I','17',1,1,0,'N'),(1036,'1',1419,'2019-05-04',1,300,'I','17',1,2,0,'N'),(1037,'1',1420,'2019-05-04',1,300,'I','17',1,1,0,'N'),(1038,'1',1421,'2019-05-04',1,300,'I','17',1,1,0,'N'),(1039,'1',1422,'2019-05-05',1,300,'I','17',1,1,0,'N'),(1040,'1',1423,'2019-05-06',1,300,'I','17',1,2,0,'N'),(1041,'1',1424,'2019-05-07',1,300,'I','17',1,1,0,'N'),(1042,'1',1425,'2019-05-07',1,300,'I','17',1,1,0,'N'),(1043,'1',1426,'2019-05-07',1,300,'I','17',1,3,0,'N'),(1044,'1',1427,'2019-05-08',1,300,'I','17',1,2,0,'N'),(1045,'1',1428,'2019-05-08',1,300,'I','17',1,2,0,'N'),(1046,'1',1429,'2019-05-08',1,300,'I','17',1,2,0,'N'),(1047,'1',1430,'2019-05-09',1,300,'I','17',1,1,0,'N'),(1048,'1',1431,'2019-05-09',1,300,'I','17',1,1,0,'N'),(1049,'1',1432,'2019-05-09',1,300,'I','17',1,1,0,'N'),(1050,'1',1433,'2019-05-09',1,300,'I','17',1,1,0,'N'),(1051,'1',1434,'2019-05-09',1,300,'I','17',1,1,0,'N'),(1052,'1',1435,'2019-05-10',1,300,'I','17',1,2,0,'N'),(1053,'1',1436,'2019-05-10',1,300,'I','17',1,1,0,'N'),(1054,'1',1437,'2019-05-11',1,300,'I','17',1,1,0,'N'),(1055,'1',1438,'2019-05-11',1,300,'I','17',1,2,0,'N'),(1056,'1',1439,'2019-05-14',1,300,'I','17',1,1,0,'N'),(1057,'1',1440,'2019-05-15',1,300,'I','17',1,1,0,'N'),(1058,'1',1441,'2019-05-16',1,300,'I','17',1,4,0,'N'),(1059,'1',1442,'2019-05-16',1,300,'I','17',1,1,0,'N'),(1060,'1',1443,'2019-05-18',1,300,'I','17',1,2,0,'N'),(1061,'1',1444,'2019-05-18',1,300,'I','17',1,2,0,'N'),(1062,'1',1445,'2019-05-18',1,300,'I','17',1,2,0,'N'),(1063,'1',1446,'2019-05-21',1,300,'I','17',1,1,0,'N'),(1064,'1',1447,'2019-05-21',1,300,'I','17',1,1,0,'N'),(1065,'1',1448,'2019-05-21',1,300,'I','17',1,2,0,'N'),(1066,'1',1449,'2019-05-22',1,300,'I','17',1,4,0,'N'),(1067,'1',1450,'2019-05-22',1,300,'I','17',1,1,0,'N'),(1068,'1',1451,'2019-05-22',1,300,'I','17',1,1,0,'N'),(1069,'1',1452,'2019-05-22',1,300,'I','17',1,1,0,'N'),(1070,'1',1453,'2019-05-22',1,300,'I','17',1,1,0,'N'),(1071,'1',1454,'2019-05-23',1,300,'I','17',1,1,0,'N'),(1072,'1',1455,'2019-05-25',1,300,'I','17',1,1,0,'N'),(1073,'1',1456,'2019-05-25',1,300,'I','17',1,3,0,'N'),(1074,'1',1459,'2019-05-26',1,300,'I','17',1,1,0,'N'),(1075,'1',1460,'2019-05-26',1,300,'I','17',1,1,0,'N'),(1076,'1',1462,'2019-05-26',1,300,'I','17',1,1,0,'N'),(1077,'1',1463,'2019-05-26',1,300,'I','17',1,1,0,'N'),(1078,'1',1464,'2019-05-26',1,300,'I','17',1,2,0,'N'),(1079,'1',1465,'2019-05-27',1,300,'I','17',1,1,0,'N'),(1080,'1',1466,'2019-05-27',1,300,'I','17',1,1,0,'N'),(1081,'1',1467,'2019-05-27',1,300,'I','17',1,1,0,'N'),(1082,'1',1468,'2019-05-27',1,300,'I','17',1,2,0,'N'),(1083,'1',1469,'2019-05-27',1,300,'I','17',1,1,0,'N'),(1084,'1',1470,'2019-05-29',1,300,'I','17',1,1,0,'N'),(1085,'1',1471,'2019-05-29',1,300,'I','17',1,1,0,'N'),(1086,'1',1472,'2019-05-29',1,300,'I','17',1,5,0,'N'),(1087,'1',1473,'2019-05-31',1,300,'I','17',1,1,0,'N'),(1088,'1',1474,'2019-05-31',1,300,'I','17',1,1,0,'N'),(1089,'1',1475,'2019-05-31',1,300,'I','17',1,1,0,'N'),(1090,'1',1476,'2019-06-01',1,300,'I','17',1,1,0,'N'),(1091,'1',1477,'2019-06-01',1,300,'I','17',1,2,0,'N'),(1092,'1',1478,'2019-06-01',1,300,'I','17',1,1,0,'N'),(1093,'1',1479,'2019-06-01',1,300,'I','17',1,1,0,'N'),(1094,'1',1480,'2019-06-02',1,300,'I','17',1,1,0,'N'),(1095,'1',1481,'2019-06-04',1,300,'I','17',1,1,0,'N'),(1096,'1',1482,'2019-06-04',1,300,'I','17',1,1,0,'N'),(1097,'1',1483,'2019-06-13',1,300,'I','17',1,1,0,'N'),(1098,'1',1484,'2019-06-14',1,300,'I','17',1,1,0,'N'),(1099,'1',1485,'2019-06-15',1,300,'I','17',1,1,0,'N'),(1100,'1',1487,'2019-06-15',1,300,'I','17',1,1,0,'N'),(1101,'1',1491,'2019-06-15',1,300,'I','17',1,2,0,'N'),(1102,'1',1492,'2019-06-16',1,300,'I','17',1,1,0,'N'),(1103,'1',1493,'2019-06-17',1,300,'I','17',1,2,0,'N'),(1104,'1',1494,'2019-06-18',1,300,'I','17',1,2,0,'N'),(1105,'1',1495,'2019-06-18',1,300,'I','17',1,1,0,'N'),(1106,'1',1496,'2019-06-18',1,300,'I','17',1,2,0,'N'),(1107,'1',1497,'2019-06-21',1,300,'I','17',1,2,0,'N'),(1108,'1',1498,'2019-06-21',1,300,'I','17',1,1,0,'N'),(1109,'1',1499,'2019-06-21',1,300,'I','17',1,2,0,'N'),(1110,'1',1500,'2019-06-23',1,300,'I','17',1,2,0,'N'),(1111,'1',1501,'2019-06-23',1,300,'I','17',1,2,0,'N'),(1112,'1',1502,'2019-06-23',1,300,'I','17',1,1,0,'N'),(1113,'1',1503,'2019-06-23',1,300,'I','17',1,1,0,'N'),(1114,'1',1504,'2019-06-24',1,300,'I','17',1,1,0,'N'),(1115,'1',1505,'2019-06-25',1,300,'I','17',1,1,0,'N'),(1116,'1',1506,'2019-06-27',1,300,'I','17',1,1,0,'N'),(1117,'1',1507,'2019-06-28',1,300,'I','17',1,1,0,'N'),(1118,'1',1508,'2019-06-28',1,300,'I','17',1,1,0,'N'),(1119,'1',1509,'2019-06-29',1,300,'I','17',1,2,0,'N'),(1120,'1',1510,'2019-06-30',1,300,'I','17',1,1,0,'N'),(1121,'1',1511,'2019-06-30',1,300,'I','17',1,1,0,'N'),(1122,'1',1512,'2019-07-02',1,300,'I','17',1,2,0,'N'),(1123,'1',1513,'2019-07-05',1,300,'I','17',1,1,0,'N'),(1124,'1',1514,'2019-07-08',1,300,'I','17',1,1,0,'N'),(1125,'1',1515,'2019-07-09',1,300,'I','17',1,1,0,'N'),(1126,'1',1516,'2019-07-11',1,300,'I','17',1,2,0,'N'),(1127,'1',1517,'2019-07-11',1,300,'I','17',1,1,0,'N'),(1128,'1',1518,'2019-07-11',1,300,'I','17',1,1,0,'N'),(1129,'1',1519,'2019-07-12',1,300,'I','17',1,1,0,'N'),(1130,'1',1520,'2019-07-12',1,300,'I','17',1,2,0,'N'),(1131,'1',1521,'2019-07-12',1,300,'I','17',1,1,0,'N'),(1132,'1',1522,'2019-07-14',1,300,'I','17',1,3,0,'N'),(1133,'1',1523,'2019-07-15',1,300,'I','17',1,2,0,'N'),(1134,'1',1524,'2019-07-19',1,300,'I','17',1,1,0,'N'),(1135,'1',1525,'2019-07-19',1,300,'I','17',1,4,0,'N'),(1136,'1',1526,'2019-07-20',1,300,'I','17',1,1,0,'N'),(1137,'1',1527,'2019-07-20',1,300,'I','17',1,3,0,'N'),(1138,'1',1528,'2019-07-22',1,300,'I','17',1,1,0,'N'),(1139,'1',1529,'2019-07-22',1,300,'I','17',1,2,0,'N'),(1140,'1',1530,'2019-07-23',1,300,'I','17',1,1,0,'N'),(1141,'1',1531,'2019-07-23',1,300,'I','17',1,1,0,'N'),(1142,'1',1532,'2019-07-24',1,300,'I','17',1,1,0,'N'),(1143,'1',1533,'2019-07-25',1,300,'I','17',1,3,0,'N'),(1144,'1',1534,'2019-07-26',1,300,'I','17',1,2,0,'N'),(1145,'1',1535,'2019-07-26',1,300,'I','17',1,4,0,'N'),(1146,'1',1536,'2019-07-26',1,300,'I','17',1,2,0,'N'),(1147,'1',1537,'2019-07-27',1,300,'I','17',1,1,0,'N'),(1148,'1',1538,'2019-07-28',1,300,'I','17',1,1,0,'N'),(1149,'1',1539,'2019-07-28',1,300,'I','17',1,1,0,'N'),(1150,'1',1540,'2019-07-30',1,300,'I','17',1,1,0,'N'),(1151,'1',1541,'2019-07-30',1,300,'I','17',1,2,0,'N'),(1152,'1',1542,'2019-07-30',1,300,'I','17',1,1,0,'N'),(1153,'1',1543,'2019-07-31',1,300,'I','17',1,2,0,'N'),(1154,'1',1544,'2019-07-31',1,300,'I','17',1,2,0,'N'),(1155,'1',1545,'2019-08-02',1,300,'I','17',1,1,0,'N'),(1156,'1',1546,'2019-08-03',1,300,'I','17',1,1,0,'N'),(1157,'1',1547,'2019-08-04',1,300,'I','17',1,2,0,'N'),(1158,'1',1548,'2019-08-04',1,300,'I','17',1,2,0,'N'),(1159,'1',1549,'2019-08-05',1,300,'I','17',1,1,0,'N'),(1160,'1',1550,'2019-08-05',1,300,'I','17',1,2,0,'N'),(1161,'1',1551,'2019-08-06',1,300,'I','17',1,1,0,'N'),(1162,'1',1552,'2019-08-07',1,300,'I','17',1,1,0,'N'),(1163,'1',1553,'2019-08-07',1,300,'I','17',1,1,0,'N'),(1164,'1',1554,'2019-08-07',1,300,'I','17',1,1,0,'N'),(1165,'1',1555,'2019-08-08',1,300,'I','17',1,1,0,'N'),(1166,'1',1556,'2019-08-08',1,300,'I','17',1,1,0,'N'),(1167,'1',1557,'2019-08-09',1,300,'I','17',1,1,0,'N'),(1168,'1',1558,'2019-08-09',1,300,'I','17',1,1,0,'N'),(1169,'1',1559,'2019-08-09',1,300,'I','17',1,1,0,'N'),(1170,'1',1560,'2019-08-11',1,300,'I','17',1,1,0,'N'),(1171,'1',1561,'2019-08-11',1,300,'I','17',1,2,0,'N'),(1172,'1',1562,'2019-08-11',1,300,'I','17',1,1,0,'N'),(1173,'1',1563,'2019-08-13',1,300,'I','17',1,1,0,'N'),(1174,'1',1564,'2019-08-13',1,300,'I','17',1,1,0,'N'),(1175,'1',1565,'2019-08-13',1,300,'I','17',1,4,0,'N'),(1176,'1',1566,'2019-08-14',1,300,'I','17',1,1,0,'N'),(1177,'1',1567,'2019-08-14',1,300,'I','17',1,1,0,'N'),(1178,'1',1568,'2019-08-15',1,300,'I','17',1,1,0,'N'),(1179,'1',1569,'2019-08-15',1,300,'I','17',1,1,0,'N'),(1180,'1',1570,'2019-08-15',1,300,'I','17',1,2,0,'N'),(1181,'1',1571,'2019-08-18',1,300,'I','17',1,2,0,'N'),(1182,'1',1572,'2019-08-18',1,300,'I','17',1,1,0,'N'),(1183,'1',1573,'2019-08-19',1,300,'I','17',1,5,0,'N'),(1184,'1',1574,'2019-08-22',1,300,'I','17',1,4,0,'N'),(1185,'1',1575,'2019-08-22',1,300,'I','17',1,2,0,'N'),(1186,'1',1576,'2019-08-23',1,300,'I','17',1,2,0,'N'),(1187,'1',1577,'2019-08-23',1,300,'I','17',1,2,0,'N'),(1188,'1',1578,'2019-08-25',1,300,'I','17',1,1,0,'N'),(1189,'1',1579,'2019-08-25',1,300,'I','17',1,1,0,'N'),(1190,'1',1580,'2019-08-25',1,300,'I','17',1,2,0,'N'),(1191,'1',1581,'2019-08-25',1,300,'I','17',1,1,0,'N'),(1192,'1',1582,'2019-08-26',1,300,'I','17',1,1,0,'N'),(1193,'1',1583,'2019-08-29',1,300,'I','17',1,2,0,'N'),(1194,'1',1584,'2019-08-30',1,300,'I','17',1,1,0,'N'),(1195,'1',1585,'2019-09-01',1,300,'I','17',1,1,0,'N'),(1196,'1',1586,'2019-09-01',1,300,'I','17',1,1,0,'N'),(1197,'1',1587,'2019-09-03',1,300,'I','17',1,1,0,'N'),(1198,'1',1588,'2019-09-03',1,300,'I','17',1,1,0,'N'),(1199,'1',1589,'2019-09-12',1,300,'I','17',1,1,0,'N'),(1200,'1',1590,'2019-09-12',1,300,'I','17',1,1,0,'N'),(1201,'1',1591,'2019-09-14',1,300,'I','17',1,2,0,'N'),(1202,'1',1592,'2019-09-14',1,300,'I','17',1,4,0,'N'),(1203,'1',1593,'2019-09-15',1,300,'I','17',1,2,0,'N'),(1204,'1',1594,'2019-09-19',1,300,'I','17',1,5,0,'N'),(1205,'1',1595,'2019-09-20',1,300,'I','17',1,1,0,'N'),(1206,'1',1596,'2019-09-20',1,300,'I','17',1,1,0,'N'),(1207,'1',1597,'2019-09-20',1,300,'I','17',1,2,0,'N'),(1208,'1',1599,'2019-09-22',1,300,'I','17',1,1,0,'N'),(1209,'1',1600,'2019-09-22',1,300,'I','17',1,3,0,'N'),(1210,'1',1601,'2019-09-24',1,300,'I','17',1,2,0,'N'),(1211,'1',1602,'2019-09-25',1,300,'I','17',1,1,0,'N'),(1212,'1',1603,'2019-09-26',1,300,'I','17',1,3,0,'N'),(1213,'1',1604,'2019-09-29',1,300,'I','17',1,2,0,'N'),(1214,'1',1605,'2019-09-29',1,300,'I','17',1,1,0,'N'),(1215,'1',1606,'2019-09-29',1,300,'I','17',1,1,0,'N'),(1216,'1',1607,'2019-09-30',1,300,'I','17',1,2,0,'N'),(1217,'1',1608,'2019-09-30',1,300,'I','17',1,1,0,'N'),(1218,'1',1609,'2019-09-30',1,300,'I','17',1,1,0,'N'),(1219,'1',1610,'2019-09-30',1,300,'I','17',1,1,0,'N'),(1220,'1',1611,'2019-10-01',1,300,'I','17',1,4,0,'N'),(1221,'1',1612,'2019-10-01',1,300,'I','17',1,2,0,'N'),(1222,'1',1613,'2019-10-01',1,300,'I','17',1,1,0,'N'),(1223,'1',1614,'2019-10-01',1,300,'I','17',1,1,0,'N'),(1224,'1',1615,'2019-10-02',1,300,'I','17',1,3,0,'N'),(1225,'1',1616,'2019-10-02',1,300,'I','17',1,1,0,'N'),(1226,'1',1617,'2019-10-02',1,300,'I','17',1,2,0,'N'),(1227,'1',1618,'2019-10-03',1,300,'I','17',1,1,0,'N'),(1228,'1',1619,'2019-10-03',1,300,'I','17',1,2,0,'N'),(1229,'1',1620,'2019-10-03',1,300,'I','17',1,2,0,'N'),(1230,'1',1621,'2019-10-03',1,300,'I','17',1,1,0,'N'),(1231,'1',1622,'2019-10-04',1,300,'I','17',1,1,0,'N'),(1232,'1',1623,'2019-10-04',1,300,'I','17',1,4,0,'N'),(1233,'1',1624,'2019-10-05',1,300,'I','17',1,4,0,'N'),(1234,'1',1625,'2019-10-05',1,300,'I','17',1,1,0,'N'),(1235,'1',1626,'2019-10-05',1,300,'I','17',1,1,0,'N'),(1236,'1',1627,'2019-10-05',1,300,'I','17',1,1,0,'N'),(1237,'1',1628,'2019-10-06',1,300,'I','17',1,2,0,'N'),(1238,'1',1629,'2019-10-06',1,300,'I','17',1,1,0,'N'),(1239,'1',1630,'2019-10-10',1,300,'I','17',1,2,0,'N'),(1240,'1',1631,'2019-10-10',1,300,'I','17',1,1,0,'N'),(1241,'1',1632,'2019-10-10',1,300,'I','17',1,1,0,'N'),(1242,'1',1633,'2019-10-11',1,300,'I','17',1,2,0,'N'),(1243,'1',1634,'2019-10-11',1,300,'I','17',1,2,0,'N'),(1244,'1',1635,'2019-10-12',1,300,'I','17',1,2,0,'N'),(1245,'1',1636,'2019-10-12',1,300,'I','17',1,1,0,'N'),(1246,'1',1637,'2019-10-13',1,300,'I','17',1,2,0,'N'),(1247,'1',1638,'2019-10-13',1,300,'I','17',1,2,0,'N'),(1248,'1',1639,'2019-10-13',1,300,'I','17',1,1,0,'N'),(1249,'1',1640,'2019-10-14',1,300,'I','17',1,1,0,'N'),(1250,'1',1641,'2019-10-16',1,300,'I','17',1,1,0,'N'),(1251,'1',1642,'2019-10-17',1,300,'I','17',1,1,0,'N'),(1252,'1',1643,'2019-10-17',1,300,'I','17',1,1,0,'N'),(1253,'1',1644,'2019-10-17',1,300,'I','17',1,1,0,'N'),(1254,'1',1645,'2019-10-17',1,300,'I','17',1,2,0,'N'),(1255,'1',1646,'2019-10-17',1,300,'I','17',1,1,0,'N'),(1256,'1',1647,'2019-10-17',1,300,'I','17',1,1,0,'N'),(1257,'1',1648,'2019-10-17',1,300,'I','17',1,2,0,'N'),(1258,'1',1649,'2019-10-18',1,300,'I','17',1,2,0,'N'),(1259,'1',1650,'2019-10-18',1,300,'I','17',1,1,0,'N'),(1260,'1',1652,'2019-10-19',1,300,'I','17',1,2,0,'N'),(1261,'1',1653,'2019-10-19',1,300,'I','17',1,1,0,'N'),(1262,'1',1654,'2019-10-19',1,300,'I','17',1,3,0,'N'),(1263,'1',1655,'2019-10-19',1,300,'I','17',1,1,0,'N'),(1264,'1',1656,'2019-10-20',1,300,'I','17',1,1,0,'N'),(1265,'1',1657,'2019-10-22',1,300,'I','17',1,1,0,'N'),(1266,'1',1658,'2019-10-22',1,300,'I','17',1,2,0,'N'),(1267,'1',1659,'2019-10-22',1,300,'I','17',1,1,0,'N'),(1268,'1',1660,'2019-10-23',1,300,'I','17',1,1,0,'N'),(1269,'1',1661,'2019-10-24',1,300,'I','17',1,4,0,'N'),(1270,'1',1662,'2019-10-24',1,300,'I','17',1,2,0,'N'),(1271,'1',1663,'2019-10-25',1,300,'I','17',1,1,0,'N'),(1272,'1',1664,'2019-10-27',1,300,'I','17',1,3,0,'N'),(1273,'1',1665,'2019-10-27',1,300,'I','17',1,1,0,'N'),(1274,'1',1666,'2019-10-28',1,300,'I','17',1,1,0,'N'),(1275,'1',1667,'2019-10-29',1,300,'I','17',1,1,0,'N'),(1276,'1',1668,'2019-10-29',1,300,'I','17',1,1,0,'N'),(1277,'1',1669,'2019-10-30',1,300,'I','17',1,3,0,'N'),(1278,'1',1670,'2019-10-30',1,300,'I','17',1,2,0,'N'),(1279,'1',1671,'2019-10-30',1,300,'I','17',1,1,0,'N'),(1280,'1',1672,'2019-10-31',1,300,'I','17',1,1,0,'N'),(1281,'1',1673,'2019-11-01',1,300,'I','17',1,1,0,'N'),(1282,'1',1674,'2019-11-01',1,300,'I','17',1,2,0,'N'),(1283,'1',1675,'2019-11-01',1,300,'I','17',1,4,0,'N'),(1284,'1',1676,'2019-11-02',1,300,'I','17',1,3,0,'N'),(1285,'1',1677,'2019-11-02',1,300,'I','17',1,8,0,'N'),(1286,'1',1678,'2019-11-02',1,300,'I','17',1,2,0,'N'),(1287,'1',1679,'2019-11-03',1,300,'I','17',1,2,0,'N'),(1288,'1',1680,'2019-11-03',1,300,'I','17',1,3,0,'N'),(1289,'1',1681,'2019-11-03',1,300,'I','17',1,1,0,'N'),(1290,'1',1682,'2019-11-03',1,300,'I','17',1,8,0,'N'),(1291,'1',1683,'2019-11-03',1,300,'I','17',1,1,0,'N'),(1292,'1',1684,'2019-11-04',1,300,'I','17',1,1,0,'N'),(1293,'1',1685,'2019-11-04',1,300,'I','17',1,1,0,'N'),(1294,'1',1686,'2019-11-04',1,300,'I','17',1,1,0,'N'),(1295,'1',1687,'2019-11-05',1,300,'I','17',1,1,0,'N'),(1296,'1',1688,'2019-11-05',1,300,'I','17',1,1,0,'N'),(1297,'1',1689,'2019-11-05',1,300,'I','17',1,1,0,'N'),(1298,'1',1690,'2019-11-07',1,300,'I','17',1,1,0,'N'),(1299,'1',1691,'2019-11-07',1,300,'I','17',1,2,0,'N'),(1300,'1',1692,'2019-11-07',1,300,'I','17',1,2,0,'N'),(1301,'1',1693,'2019-11-07',1,300,'I','17',1,1,0,'N'),(1302,'1',1694,'2019-11-08',1,300,'I','17',1,1,0,'N'),(1303,'1',1695,'2019-11-08',1,300,'I','17',1,3,0,'N'),(1304,'1',1696,'2019-11-08',1,300,'I','17',1,1,0,'N'),(1305,'1',1697,'2019-11-08',1,300,'I','17',1,4,0,'N'),(1306,'1',1698,'2019-11-10',1,300,'I','17',1,1,0,'N'),(1307,'1',1701,'2019-11-11',1,300,'I','17',1,2,0,'N'),(1308,'1',1700,'2019-11-11',1,300,'I','17',1,4,0,'N'),(1309,'1',1699,'2019-11-11',1,300,'I','17',1,1,0,'N'),(1310,'1',1702,'2019-11-11',1,300,'I','17',1,2,0,'N'),(1311,'1',1703,'2019-11-11',1,300,'I','17',1,2,0,'N'),(1312,'1',1704,'2019-11-11',1,300,'I','17',1,4,0,'N'),(1313,'1',1705,'2019-11-12',1,300,'I','17',1,2,0,'N'),(1314,'1',1706,'2019-11-12',1,300,'I','17',1,2,0,'N'),(1315,'1',1707,'2019-11-12',1,300,'I','17',1,1,0,'N'),(1316,'1',1708,'2019-11-13',1,300,'I','17',1,1,0,'N'),(1317,'1',1709,'2019-11-13',1,300,'I','17',1,1,0,'N'),(1318,'1',1710,'2019-11-13',1,300,'I','17',1,1,0,'N'),(1319,'1',1711,'2019-11-14',1,300,'I','17',1,1,0,'N'),(1320,'1',1712,'2019-11-14',1,300,'I','17',1,2,0,'N'),(1321,'1',1713,'2019-11-14',1,300,'I','17',1,1,0,'N'),(1322,'1',1714,'2019-11-15',1,300,'I','17',1,1,0,'N'),(1323,'1',1715,'2019-11-15',1,300,'I','17',1,1,0,'N'),(1324,'1',1716,'2019-11-16',1,300,'I','17',1,1,0,'N'),(1325,'1',1717,'2019-11-16',1,300,'I','17',1,2,0,'N'),(1326,'1',1718,'2019-11-16',1,300,'I','17',1,3,0,'N'),(1327,'1',1719,'2019-11-17',1,300,'I','17',1,2,0,'N'),(1328,'1',1720,'2019-11-17',1,300,'I','17',1,2,0,'N'),(1329,'1',1721,'2019-11-17',1,300,'I','17',1,2,0,'N'),(1330,'1',1724,'2019-11-18',1,300,'I','17',1,2,0,'N'),(1331,'1',1723,'2019-11-18',1,300,'I','17',1,1,0,'N'),(1332,'1',1725,'2019-11-18',1,300,'I','17',1,1,0,'N'),(1333,'1',1726,'2019-11-19',1,300,'I','17',1,1,0,'N'),(1334,'1',1727,'2019-11-19',1,300,'I','17',1,1,0,'N'),(1335,'1',1728,'2019-11-20',1,300,'I','17',1,1,0,'N'),(1336,'1',1729,'2019-11-20',1,300,'I','17',1,1,0,'N'),(1337,'1',1730,'2019-11-20',1,300,'I','17',1,2,0,'N'),(1338,'1',1731,'2019-11-21',1,300,'I','17',1,1,0,'N'),(1339,'1',1732,'2019-11-21',1,300,'I','17',1,1,0,'N'),(1340,'1',1733,'2019-11-23',1,300,'I','17',1,3,0,'N'),(1341,'1',1734,'2019-11-23',1,300,'I','17',1,1,0,'N'),(1342,'1',1735,'2019-11-24',1,300,'I','17',1,1,0,'N'),(1343,'1',1736,'2019-11-24',1,300,'I','17',1,1,0,'N'),(1344,'1',1737,'2019-11-25',1,300,'I','17',1,4,0,'N'),(1345,'1',1738,'2019-11-25',1,300,'I','17',1,1,0,'N'),(1346,'1',1739,'2019-11-26',1,300,'I','17',1,2,0,'N'),(1347,'1',1740,'2019-11-27',1,300,'I','17',1,1,0,'N'),(1348,'1',1741,'2019-11-28',1,300,'I','17',1,1,0,'N'),(1349,'1',1742,'2019-11-30',1,300,'I','17',1,3,0,'N'),(1350,'1',1743,'2019-11-30',1,300,'I','17',1,1,0,'N'),(1351,'1',1744,'2019-12-01',1,300,'I','17',1,4,0,'N'),(1352,'1',1745,'2019-12-02',1,300,'I','17',1,1,0,'N'),(1353,'1',1746,'2019-12-02',1,300,'I','17',1,2,0,'N'),(1354,'1',1747,'2019-12-02',1,300,'I','17',1,1,0,'N'),(1355,'1',1748,'2019-12-02',1,300,'I','17',1,1,0,'N'),(1356,'1',1749,'2019-12-03',1,300,'I','17',1,1,0,'N'),(1357,'1',1750,'2019-12-04',1,300,'I','17',1,1,0,'N'),(1358,'1',1751,'2019-12-04',1,300,'I','17',1,1,0,'N'),(1359,'1',1752,'2019-12-05',1,300,'I','17',1,2,0,'N'),(1360,'1',1753,'2019-12-05',1,300,'I','17',1,1,0,'N'),(1361,'1',1754,'2019-12-05',1,300,'I','17',1,1,0,'N'),(1362,'1',1755,'2019-12-05',1,300,'I','17',1,1,0,'N'),(1363,'1',1756,'2019-12-06',1,300,'I','17',1,1,0,'N'),(1364,'1',1757,'2019-12-07',1,300,'I','17',1,2,0,'N'),(1365,'1',1758,'2019-12-07',1,300,'I','17',1,1,0,'N'),(1366,'1',1759,'2019-12-08',1,300,'I','17',1,1,0,'N'),(1367,'1',1760,'2019-12-08',1,300,'I','17',1,2,0,'N'),(1368,'1',1761,'2019-12-08',1,300,'I','17',1,1,0,'N'),(1369,'1',1762,'2019-12-10',1,300,'I','17',1,1,0,'N'),(1370,'1',1763,'2019-12-10',1,300,'I','17',1,4,0,'N'),(1371,'1',1764,'2019-12-11',1,300,'I','17',1,1,0,'N'),(1372,'1',1765,'2019-12-11',1,300,'I','17',1,2,0,'N'),(1373,'1',1766,'2019-12-12',1,300,'I','17',1,1,0,'N'),(1374,'1',1767,'2019-12-12',1,300,'I','17',1,1,0,'N'),(1375,'1',1768,'2019-12-14',1,300,'I','17',1,1,0,'N'),(1376,'1',1769,'2019-12-16',1,300,'I','17',1,1,0,'N'),(1377,'1',1770,'2019-12-16',1,300,'I','17',1,2,0,'N'),(1378,'1',1771,'2019-12-16',1,300,'I','17',1,3,0,'N'),(1379,'1',1772,'2019-12-16',1,300,'I','17',1,1,0,'N'),(1380,'1',1773,'2019-12-17',1,300,'I','17',1,4,0,'N'),(1381,'1',1774,'2019-12-17',1,300,'I','17',1,1,0,'N'),(1382,'1',1775,'2019-12-18',1,300,'I','17',1,1,0,'N'),(1383,'1',1776,'2019-12-18',1,300,'I','17',1,1,0,'N'),(1384,'1',1777,'2019-12-18',1,300,'I','17',1,1,0,'N'),(1385,'1',1778,'2019-12-18',1,300,'I','17',1,3,0,'N'),(1386,'1',1779,'2019-12-18',1,300,'I','17',1,3,0,'N'),(1387,'1',1780,'2019-12-18',1,300,'I','17',1,1,0,'N'),(1388,'1',1781,'2019-12-19',1,300,'I','17',1,1,0,'N'),(1389,'1',1782,'2019-12-19',1,300,'I','17',1,1,0,'N'),(1390,'1',1783,'2019-12-19',1,300,'I','17',1,1,0,'N'),(1391,'1',1784,'2019-12-19',1,300,'I','17',1,2,0,'N'),(1392,'1',1785,'2019-12-20',1,300,'I','17',1,1,0,'N'),(1393,'1',1786,'2019-12-20',1,300,'I','17',1,2,0,'N'),(1394,'1',1787,'2019-12-20',1,300,'I','17',1,2,0,'N'),(1395,'1',1788,'2019-12-21',1,300,'I','17',1,2,0,'N'),(1396,'1',1789,'2019-12-21',1,300,'I','17',1,1,0,'N'),(1397,'1',1790,'2019-12-21',1,300,'I','17',1,1,0,'N'),(1398,'1',1791,'2019-12-22',1,300,'I','17',1,1,0,'N'),(1399,'1',1792,'2019-12-22',1,300,'I','17',1,3,0,'N'),(1400,'1',1793,'2019-12-22',1,300,'I','17',1,1,0,'N'),(1401,'1',1794,'2019-12-23',1,300,'I','17',1,1,0,'N'),(1402,'1',1795,'2019-12-24',1,300,'I','17',1,1,0,'N'),(1403,'1',1796,'2019-12-25',1,300,'I','17',1,1,0,'N'),(1404,'1',1797,'2019-12-25',1,300,'I','17',1,1,0,'N'),(1405,'1',1798,'2019-12-25',1,300,'I','17',1,1,0,'N'),(1406,'1',1799,'2019-12-26',1,300,'I','17',1,1,0,'N'),(1407,'1',1800,'2019-12-26',1,300,'I','17',1,1,0,'N'),(1408,'1',1801,'2019-12-27',1,300,'I','17',1,2,0,'N'),(1409,'1',1802,'2019-12-27',1,300,'I','17',1,1,0,'N'),(1410,'1',1803,'2019-12-28',1,300,'I','17',1,1,0,'N'),(1411,'1',1804,'2019-12-31',1,300,'I','17',1,3,0,'N'),(1412,'1',1805,'2019-12-31',1,300,'I','17',1,1,0,'N'),(1413,'1',1806,'2020-01-01',1,300,'I','17',1,1,0,'N'),(1414,'1',1807,'2020-01-01',1,300,'I','17',1,1,0,'N'),(1415,'1',1808,'2020-01-01',1,300,'I','17',1,1,0,'N'),(1416,'1',1809,'2020-01-02',1,300,'I','17',1,1,0,'N'),(1417,'1',1810,'2020-01-02',1,300,'I','17',1,1,0,'N'),(1418,'1',1811,'2020-01-02',1,300,'I','17',1,1,0,'N'),(1419,'1',1812,'2020-01-03',1,300,'I','17',1,2,0,'N'),(1420,'1',1813,'2020-01-03',1,300,'I','17',1,1,0,'N'),(1421,'1',1814,'2020-01-05',1,300,'I','17',1,1,0,'N'),(1422,'1',1815,'2020-01-05',1,300,'I','17',1,1,0,'N'),(1423,'1',1816,'2020-01-06',1,300,'I','17',1,1,0,'N'),(1424,'1',1817,'2020-01-06',1,300,'I','17',1,1,0,'N'),(1425,'1',1818,'2020-01-06',1,300,'I','17',1,2,0,'N'),(1426,'1',1819,'2020-01-06',1,300,'I','17',1,1,0,'N'),(1427,'1',1820,'2020-01-07',1,300,'I','17',1,1,0,'N'),(1428,'1',1821,'2020-01-08',1,300,'I','17',1,1,0,'N'),(1429,'1',1822,'2020-01-10',1,300,'I','17',1,1,0,'N'),(1430,'1',1823,'2020-01-10',1,300,'I','17',1,1,0,'N'),(1431,'1',1824,'2020-01-10',1,300,'I','17',1,3,0,'N'),(1432,'1',1825,'2020-01-10',1,300,'I','17',1,4,0,'N'),(1433,'1',1826,'2020-01-10',1,300,'I','17',1,1,0,'N'),(1434,'1',1827,'2020-01-11',1,300,'I','17',1,2,0,'N'),(1435,'1',1828,'2020-01-12',1,300,'I','17',1,1,0,'N'),(1436,'1',1829,'2020-01-12',1,300,'I','17',1,2,0,'N'),(1437,'1',1830,'2020-01-12',1,300,'I','17',1,1,0,'N'),(1438,'1',1831,'2020-01-12',1,300,'I','17',1,1,0,'N'),(1439,'1',1832,'2020-01-13',1,300,'I','17',1,2,0,'N'),(1440,'1',1833,'2020-01-14',1,300,'I','17',1,1,0,'N'),(1441,'1',1834,'2020-01-14',1,300,'I','17',1,2,0,'N'),(1442,'1',1835,'2020-01-16',1,300,'I','17',1,2,0,'N'),(1443,'1',1836,'2020-01-17',1,300,'I','17',1,1,0,'N'),(1444,'1',1837,'2020-01-17',1,300,'I','17',1,1,0,'N'),(1445,'1',1838,'2020-01-18',1,300,'I','17',1,1,0,'N'),(1446,'1',1839,'2020-01-18',1,300,'I','17',1,2,0,'N'),(1447,'1',1840,'2020-01-18',1,300,'I','17',1,2,0,'N'),(1448,'1',1841,'2020-01-18',1,300,'I','17',1,1,0,'N'),(1449,'1',1842,'2020-01-19',1,300,'I','17',1,1,0,'N'),(1450,'1',1843,'2020-01-19',1,300,'I','17',1,1,0,'N'),(1451,'1',1844,'2020-01-20',1,300,'I','17',1,1,0,'N'),(1452,'1',1845,'2020-01-20',1,300,'I','17',1,1,0,'N'),(1453,'1',1846,'2020-01-21',1,300,'I','17',1,2,0,'N'),(1454,'1',1847,'2020-01-22',1,300,'I','17',1,2,0,'N'),(1455,'1',1848,'2020-01-23',1,300,'I','17',1,2,0,'N'),(1456,'1',1849,'2020-01-24',1,300,'I','17',1,1,0,'N'),(1457,'1',1850,'2020-01-26',1,300,'I','17',1,1,0,'N'),(1458,'1',1852,'2020-01-28',1,300,'I','17',1,1,0,'N'),(1459,'1',1851,'2020-01-29',1,300,'I','17',1,1,0,'N'),(1460,'1',1853,'2020-01-30',1,300,'I','17',1,2,0,'N'),(1461,'1',1854,'2020-02-01',1,300,'I','17',1,3,0,'N'),(1462,'1',1855,'2020-02-02',1,300,'I','17',1,2,0,'N'),(1463,'1',1856,'2020-02-03',1,300,'I','17',1,2,0,'N'),(1464,'1',1857,'2020-02-03',1,300,'I','17',1,2,0,'N'),(1465,'1',1858,'2020-02-05',1,300,'I','17',1,2,0,'N'),(1466,'1',1859,'2020-02-06',1,300,'I','17',1,1,0,'N'),(1467,'1',1860,'2020-02-06',1,300,'I','17',1,1,0,'N'),(1468,'1',1861,'2020-02-07',1,300,'I','17',1,1,0,'N'),(1469,'1',1862,'2020-02-07',1,300,'I','17',1,1,0,'N'),(1470,'1',1863,'2020-02-07',1,300,'I','17',1,1,0,'N'),(1471,'1',1864,'2020-02-08',1,300,'I','17',1,1,0,'N'),(1472,'1',1865,'2020-02-08',1,300,'I','17',1,1,0,'N'),(1473,'1',1866,'2020-02-09',1,300,'I','17',1,1,0,'N'),(1474,'1',1867,'2020-02-10',1,300,'I','17',1,2,0,'N'),(1475,'1',1868,'2020-02-11',1,300,'I','17',1,1,0,'N'),(1476,'1',1869,'2020-02-11',1,300,'I','17',1,1,0,'N'),(1477,'1',1870,'2020-02-12',1,300,'I','17',1,1,0,'N'),(1478,'1',1871,'2020-02-13',1,300,'I','17',1,1,0,'N'),(1479,'1',1872,'2020-02-14',1,300,'I','17',1,1,0,'N'),(1480,'1',1873,'2020-02-14',1,300,'I','17',1,1,0,'N'),(1481,'1',1874,'2020-02-14',1,300,'I','17',1,1,0,'N'),(1482,'1',1875,'2020-02-16',1,300,'I','17',1,1,0,'N'),(1483,'1',1876,'2020-02-18',1,300,'I','17',1,1,0,'N'),(1484,'1',1877,'2020-02-18',1,300,'I','17',1,1,0,'N'),(1485,'1',1878,'2020-02-19',1,300,'I','17',1,1,0,'N'),(1486,'1',1879,'2020-02-19',1,300,'I','17',1,2,0,'N'),(1487,'1',1880,'2020-02-20',1,300,'I','17',1,1,0,'N'),(1488,'1',1881,'2020-02-20',1,300,'I','17',1,1,0,'N'),(1489,'1',1882,'2020-02-21',1,300,'I','17',1,1,0,'N'),(1490,'1',1883,'2020-02-21',1,300,'I','17',1,1,0,'N'),(1491,'1',1884,'2020-02-22',1,300,'I','17',1,3,0,'N'),(1492,'1',1885,'2020-02-23',1,300,'I','17',1,1,0,'N'),(1493,'1',1886,'2020-02-23',1,300,'I','17',1,1,0,'N'),(1494,'1',1887,'2020-02-24',1,300,'I','17',1,2,0,'N'),(1495,'1',1888,'2020-02-24',1,300,'I','17',1,2,0,'N'),(1496,'1',1889,'2020-02-25',1,300,'I','17',1,2,0,'N'),(1497,'1',1890,'2020-02-25',1,300,'I','17',1,1,0,'N'),(1498,'1',1891,'2020-02-25',1,300,'I','17',1,1,0,'N'),(1499,'1',1892,'2020-02-25',1,300,'I','17',1,1,0,'N'),(1500,'1',1893,'2020-02-25',1,300,'I','17',1,2,0,'N'),(1501,'1',1894,'2020-02-26',1,300,'I','17',1,1,0,'N'),(1502,'1',1895,'2020-02-26',1,300,'I','17',1,1,0,'N'),(1503,'1',1896,'2020-02-27',1,300,'I','17',1,1,0,'N'),(1504,'1',1897,'2020-02-27',1,300,'I','17',1,1,0,'N'),(1505,'1',1898,'2020-02-27',1,300,'I','17',1,2,0,'N'),(1506,'1',1899,'2020-02-28',1,300,'I','17',1,1,0,'N'),(1507,'1',1900,'2020-02-29',1,300,'I','17',1,1,0,'N'),(1508,'1',1901,'2020-02-29',1,300,'I','17',1,1,0,'N'),(1509,'1',1902,'2020-03-01',1,300,'I','17',1,4,0,'N'),(1510,'1',1903,'2020-03-02',1,300,'I','17',1,1,0,'N'),(1511,'1',1904,'2020-03-02',1,300,'I','17',1,1,0,'N'),(1512,'1',1905,'2020-03-04',1,300,'I','17',1,1,0,'N'),(1513,'1',1906,'2020-03-04',1,300,'I','17',1,1,0,'N'),(1514,'1',1907,'2020-03-05',1,300,'I','17',1,1,0,'N'),(1515,'1',1908,'2020-03-05',1,300,'I','17',1,1,0,'N'),(1516,'1',1909,'2020-03-05',1,300,'I','17',1,2,0,'N'),(1517,'1',1910,'2020-03-05',1,300,'I','17',1,1,0,'N'),(1518,'1',1911,'2020-03-06',1,300,'I','17',1,1,0,'N'),(1519,'1',1912,'2020-03-06',1,300,'I','17',1,1,0,'N'),(1520,'1',1913,'2020-03-06',1,300,'I','17',1,1,0,'N'),(1521,'1',1914,'2020-03-07',1,300,'I','17',1,1,0,'N'),(1522,'1',1915,'2020-03-07',1,300,'I','17',1,1,0,'N'),(1523,'1',1916,'2020-03-07',1,300,'I','17',1,1,0,'N'),(1524,'1',1917,'2020-03-07',1,300,'I','17',1,1,0,'N'),(1525,'1',1918,'2020-03-08',1,300,'I','17',1,1,0,'N'),(1526,'1',1919,'2020-03-08',1,300,'I','17',1,2,0,'N'),(1527,'1',1920,'2020-03-08',1,300,'I','17',1,1,0,'N'),(1528,'1',1921,'2020-03-08',1,300,'I','17',1,1,0,'N'),(1529,'1',1922,'2020-03-12',1,300,'I','17',1,1,0,'N'),(1530,'1',1923,'2020-03-13',1,300,'I','17',1,1,0,'N'),(1531,'1',1924,'2020-03-14',1,300,'I','17',1,1,0,'N'),(1532,'1',1925,'2020-03-14',1,300,'I','17',1,3,0,'N'),(1533,'1',1926,'2020-03-14',1,300,'I','17',1,2,0,'N'),(1534,'1',1927,'2020-03-15',1,300,'I','17',1,4,0,'N'),(1535,'1',1928,'2020-03-15',1,300,'I','17',1,2,0,'N'),(1536,'1',1929,'2020-03-16',1,300,'I','17',1,2,0,'N'),(1537,'1',1930,'2020-03-16',1,300,'I','17',1,1,0,'N'),(1538,'1',1931,'2020-03-16',1,300,'I','17',1,1,0,'N'),(1539,'1',1932,'2020-03-17',1,300,'I','17',1,1,0,'N'),(1540,'1',1933,'2020-03-18',1,300,'I','17',1,2,0,'N'),(1541,'1',1934,'2020-03-18',1,300,'I','17',1,1,0,'N'),(1542,'1',1935,'2020-03-19',1,300,'I','17',1,1,0,'N'),(1543,'1',1936,'2020-03-20',1,300,'I','17',1,1,0,'N'),(1544,'1',1937,'2020-03-20',1,300,'I','17',1,2,0,'N'),(1545,'1',1938,'2020-03-22',1,300,'I','17',1,2,0,'N'),(1546,'1',1939,'2020-03-24',1,300,'I','17',1,4,0,'N'),(1547,'1',1940,'2020-03-27',1,300,'I','17',1,1,0,'N'),(1548,'1',1941,'2020-03-27',1,300,'I','17',1,1,0,'N'),(1549,'1',1942,'2020-05-04',1,300,'I','17',1,1,0,'N'),(1550,'1',1943,'2020-05-04',1,300,'I','17',1,1,0,'N'),(1551,'1',1944,'2020-05-05',1,300,'I','17',1,2,0,'N'),(1552,'1',1945,'2020-05-09',1,300,'I','17',1,3,0,'N'),(1553,'1',1946,'2020-05-09',1,300,'I','17',1,2,0,'N'),(1554,'1',1947,'2020-05-13',1,300,'I','17',1,1,0,'N'),(1555,'1',1948,'2020-05-13',1,300,'I','17',1,2,0,'N'),(1556,'1',1949,'2020-05-13',1,300,'I','17',1,2,0,'N'),(1557,'1',1950,'2020-05-15',1,300,'I','17',1,2,0,'N'),(1558,'1',1951,'2020-05-22',1,300,'I','17',1,2,0,'N'),(1559,'1',1952,'2020-05-23',1,300,'I','17',1,2,0,'N'),(1560,'1',1953,'2020-05-23',1,300,'I','17',1,2,0,'N'),(1561,'1',1954,'2020-05-28',1,300,'I','17',1,1,0,'N'),(1562,'1',1955,'2020-05-29',1,300,'I','17',1,2,0,'N'),(1563,'1',1956,'2020-05-30',1,300,'I','17',1,2,0,'N'),(1564,'1',1957,'2020-05-30',1,300,'I','17',1,1,0,'N'),(1565,'1',1958,'2020-05-30',1,300,'I','17',1,2,0,'N'),(1566,'1',1959,'2020-05-31',1,300,'I','17',1,2,0,'N'),(1567,'1',1960,'2020-05-31',1,300,'I','17',1,1,0,'N'),(1568,'1',1961,'2020-06-02',1,300,'I','17',1,1,0,'N'),(1569,'1',1962,'2020-06-02',1,300,'I','17',1,2,0,'N'),(1570,'1',1963,'2020-06-03',1,300,'I','17',1,2,0,'N'),(1571,'1',1964,'2020-06-04',1,300,'I','17',1,1,0,'N'),(1572,'1',1965,'2020-06-04',1,300,'I','17',1,1,0,'N'),(1573,'1',1966,'2020-06-06',1,300,'I','17',1,2,0,'N'),(1574,'1',1967,'2020-06-06',1,300,'I','17',1,1,0,'N'),(1575,'1',1968,'2020-06-09',1,300,'I','17',1,2,0,'N'),(1576,'1',1969,'2020-06-11',1,300,'I','17',1,1,0,'N'),(1577,'1',1970,'2020-06-11',1,300,'I','17',1,1,0,'N'),(1578,'1',1971,'2020-06-13',1,300,'I','17',1,1,0,'N'),(1579,'1',1972,'2020-06-13',1,300,'I','17',1,1,0,'N'),(1580,'1',1973,'2020-06-13',1,300,'I','17',1,2,0,'N'),(1581,'1',1974,'2020-06-13',1,300,'I','17',1,2,0,'N'),(1582,'1',1975,'2020-06-14',1,300,'I','17',1,1,0,'N'),(1583,'1',1976,'2020-06-14',1,300,'I','17',1,1,0,'N'),(1584,'1',1977,'2020-06-15',1,300,'I','17',1,2,0,'N'),(1585,'1',1978,'2020-06-15',1,300,'I','17',1,1,0,'N'),(1586,'1',1979,'2020-06-15',1,300,'I','17',1,1,0,'N'),(1587,'1',1980,'2020-06-15',1,300,'I','17',1,1,0,'N'),(1588,'1',1981,'2020-06-16',1,300,'I','17',1,1,0,'N'),(1589,'1',1982,'2020-06-17',1,300,'I','17',1,1,0,'N'),(1590,'1',1983,'2020-06-17',1,300,'I','17',1,1,0,'N'),(1591,'1',1984,'2020-06-17',1,300,'I','17',1,1,0,'N'),(1592,'1',1985,'2020-06-18',1,300,'I','17',1,1,0,'N'),(1593,'1',1986,'2020-06-19',1,300,'I','17',1,1,0,'N'),(1594,'1',1987,'2020-06-19',1,300,'I','17',1,1,0,'N'),(1595,'1',1988,'2020-06-21',1,300,'I','17',1,1,0,'N'),(1596,'1',1989,'2020-06-23',1,300,'I','17',1,2,0,'N'),(1597,'1',1990,'2020-06-26',1,300,'I','17',1,1,0,'N'),(1598,'1',1991,'2020-06-27',1,300,'I','17',1,1,0,'N'),(1599,'1',1992,'2020-06-29',1,300,'I','17',1,1,0,'N'),(1600,'1',1993,'2020-06-29',1,300,'I','17',1,1,0,'N'),(1601,'1',1994,'2020-06-29',1,300,'I','17',1,2,0,'N'),(1602,'1',1995,'2020-06-30',1,300,'I','17',1,1,0,'N'),(1603,'1',1996,'2020-07-01',1,300,'I','17',1,1,0,'N'),(1604,'1',1997,'2020-07-01',1,300,'I','17',1,2,0,'N'),(1605,'1',1998,'2020-07-02',1,300,'I','17',1,1,0,'N'),(1606,'1',1999,'2020-07-03',1,300,'I','17',1,2,0,'N'),(1607,'1',2000,'2020-07-04',1,300,'I','17',1,1,0,'N'),(1608,'1',2001,'2020-07-04',1,300,'I','17',1,1,0,'N'),(1609,'1',2002,'2020-07-04',1,300,'I','17',1,2,0,'N'),(1610,'1',2003,'2020-07-05',1,300,'I','17',1,1,0,'N'),(1611,'1',2004,'2020-07-06',1,300,'I','17',1,1,0,'N'),(1612,'1',2005,'2020-07-09',1,300,'I','17',1,1,0,'N'),(1613,'1',2006,'2020-07-09',1,300,'I','17',1,2,0,'N'),(1614,'1',2007,'2020-07-09',1,300,'I','17',1,1,0,'N'),(1615,'1',2008,'2020-07-10',1,300,'I','17',1,2,0,'N'),(1616,'1',2009,'2020-07-11',1,300,'I','17',1,1,0,'N'),(1617,'1',2010,'2020-07-11',1,300,'I','17',1,1,0,'N'),(1618,'1',2011,'2020-07-12',1,300,'I','17',1,1,0,'N'),(1619,'1',2012,'2020-07-13',1,300,'I','17',1,1,0,'N'),(1620,'1',2013,'2020-07-13',1,300,'I','17',1,1,0,'N'),(1621,'1',2014,'2020-07-13',1,300,'I','17',1,1,0,'N'),(1622,'1',2015,'2020-07-13',1,300,'I','17',1,1,0,'N'),(1623,'1',2016,'2020-07-14',1,300,'I','17',1,1,0,'N'),(1624,'1',2017,'2020-07-15',1,300,'I','17',1,2,0,'N'),(1625,'1',2018,'2020-07-16',1,300,'I','17',1,1,0,'N'),(1626,'1',2019,'2020-07-19',1,300,'I','17',1,2,0,'N'),(1627,'1',2020,'2020-07-20',1,300,'I','17',1,1,0,'N'),(1628,'1',2021,'2020-07-21',1,300,'I','17',1,1,0,'N'),(1629,'1',2022,'2020-07-21',1,300,'I','17',1,1,0,'N'),(1630,'1',2023,'2020-07-22',1,300,'I','17',1,1,0,'N'),(1645,'1',2035,'2020-09-04',1,300,'I','17',1,1,0,'N');

--
-- Table structure for table `invoice_print`
--

CREATE TABLE `invoice_print` (
  `type` char(1) NOT NULL,
  `size` smallint(6) DEFAULT NULL,
  `list` smallint(6) NOT NULL,
  `position` varchar(8) DEFAULT NULL COMMENT 'C=center;I=left;D=right',
  `pre` char(5) DEFAULT NULL,
  `value` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoice_print`
--


--
-- Temporary table structure for view `lineas`
--

/*!50001 DROP VIEW IF EXISTS `lineas`*/;
/*!50001 CREATE VIEW `lineas` AS SELECT 
 1 AS `almacen`,
 1 AS `linea`,
 1 AS `nombre`,
 1 AS `es_auxiliar`,
 1 AS `cta_compra`,
 1 AS `cta_venta`,
 1 AS `cta_consumo`,
 1 AS `cta_descuento`,
 1 AS `cta_inve`,
 1 AS `cta_costo_venta`,
 1 AS `cta_ret_compra`,
 1 AS `porc_compra`,
 1 AS `minimo_ret`,
 1 AS `cta_dev_ventas`,
 1 AS `cta_dev_compras`,
 1 AS `cta_hortic`,
 1 AS `porc_hortic`,
 1 AS `minimo_v`,
 1 AS `minimo_c`*/;

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(45) NOT NULL,
  `nombre_pedido` varchar(45) NOT NULL,
  `image` varchar(40) DEFAULT NULL,
  `estado` char(1) NOT NULL DEFAULT 'A',
  PRIMARY KEY (`id`),
  KEY `estado` (`estado`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,'MINIBAR ALIMENTOS','Minibar Alimentos',NULL,'A'),(2,'MINIBAR BEBIDAS','Minibar Bebidas',NULL,'A'),(3,'MINIBAR ASEO','Minibar Aseo',NULL,'A'),(4,'CAMILO LARROTA','Camilo Larrota',NULL,'A');

--
-- Table structure for table `menus_items`
--

CREATE TABLE `menus_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menus_id` int(11) NOT NULL,
  `nombre` varchar(45) NOT NULL,
  `nombre_pedido` varchar(45) NOT NULL,
  `codigo_barras` varchar(100) DEFAULT NULL,
  `tipo` char(1) DEFAULT NULL,
  `image` char(40) DEFAULT NULL,
  `valor` decimal(16,2) DEFAULT NULL,
  `costo` decimal(7,2) DEFAULT NULL,
  `porcentaje_iva` decimal(5,2) DEFAULT NULL,
  `porcentaje_impoconsumo` decimal(5,2) DEFAULT '0.00',
  `porcentaje_servicio` decimal(5,2) DEFAULT NULL,
  `tipo_costo` char(1) NOT NULL DEFAULT 'N',
  `codigo_referencia` char(15) DEFAULT NULL,
  `descontar` char(1) NOT NULL DEFAULT 'N',
  `cambio_precio` char(1) DEFAULT NULL,
  `estado` char(1) NOT NULL DEFAULT 'A',
  `cubierto` char(1) DEFAULT 'N',
  `aplconmin` varchar(1) DEFAULT 'S',
  PRIMARY KEY (`id`),
  KEY `estado` (`estado`),
  KEY `menus_id` (`menus_id`),
  KEY `codigo_referencia` (`codigo_referencia`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

--
-- Dumping data for table `menus_items`
--

INSERT INTO `menus_items` VALUES (1,2,'AGUA C/S GAS','Agua C/s Gas',NULL,'B',NULL,2500.00,1254.00,0.00,8.00,0.00,'I','17','N','N','A','N','S'),(2,2,'GASEOSA POSTOBON','Gaseosa Postobon',NULL,'B',NULL,2500.00,1290.00,0.00,8.00,0.00,'I','30','N','N','A','N','S'),(3,2,'MR TEA BOTELLA','Mr Tea Botella',NULL,'B',NULL,3000.00,1525.00,0.00,8.00,0.00,'I','25','N','N','A','N','S'),(4,2,'JUGO HIT','Jugo Hit',NULL,'B',NULL,1800.00,875.00,0.00,8.00,0.00,'I','20','N','N','A','N','S'),(5,2,'GATORADE','Gatorade',NULL,'B',NULL,3500.00,0.00,0.00,8.00,0.00,'I','5','N','N','A','N','S');

--
-- Table structure for table `menus_items_day`
--

CREATE TABLE `menus_items_day` (
  `id` int(18) unsigned NOT NULL AUTO_INCREMENT,
  `salon_id` int(18) unsigned NOT NULL,
  `menus_items_id` int(18) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `menus_items_day`
--


--
-- Table structure for table `menus_items_modifiers`
--

CREATE TABLE `menus_items_modifiers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menus_items_id` int(18) unsigned NOT NULL,
  `modifiers_id` int(18) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `menus_items_id` (`menus_items_id`),
  KEY `modifiers_id` (`modifiers_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `menus_items_modifiers`
--

INSERT INTO `menus_items_modifiers` VALUES (9,104,15),(10,104,16),(14,206,18);

--
-- Table structure for table `modifiers`
--

CREATE TABLE `modifiers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(45) NOT NULL,
  `nombre_pedido` varchar(45) NOT NULL,
  `tipo` char(1) NOT NULL,
  `valor` decimal(10,2) DEFAULT NULL,
  `tipo_costo` char(1) DEFAULT 'N',
  `descontar` char(1) DEFAULT 'N',
  `codigo_referencia` char(15) DEFAULT NULL,
  `estado` char(1) DEFAULT 'A',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `modifiers`
--


--
-- Temporary table structure for view `movimiento_folio`
--

/*!50001 DROP VIEW IF EXISTS `movimiento_folio`*/;
/*!50001 CREATE VIEW `movimiento_folio` AS SELECT 
 1 AS `folio`,
 1 AS `cuenta`,
 1 AS `item`*/;

--
-- Table structure for table `pagos_factura`
--

CREATE TABLE `pagos_factura` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `prefijo_facturacion` char(5) DEFAULT NULL,
  `consecutivo_facturacion` int(11) DEFAULT NULL,
  `tipo` char(1) NOT NULL,
  `formas_pago_id` int(11) DEFAULT NULL,
  `pago` decimal(16,2) DEFAULT NULL,
  `cargo_plan` char(1) DEFAULT NULL,
  `habitacion_id` int(11) DEFAULT NULL,
  `cuenta` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `prefijo_facturacion` (`prefijo_facturacion`,`consecutivo_facturacion`,`tipo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

--
-- Dumping data for table `pagos_factura`
--


--
-- Table structure for table `permisos`
--

CREATE TABLE `permisos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuarios_id` int(11) DEFAULT NULL,
  `salon_id` int(11) DEFAULT NULL,
  `estado` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `salon_id` (`salon_id`),
  KEY `salon_id_2` (`salon_id`,`usuarios_id`,`estado`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

--
-- Dumping data for table `permisos`
--

INSERT INTO `permisos` VALUES (1,1,1,'A'),(3,2,1,'I'),(2,3,1,'A'),(13,4,1,'A'),(12,5,1,'A'),(14,6,1,'A'),(17,7,1,'A'),(18,10,1,'A'),(19,11,1,'A'),(9,1,2,'A'),(6,2,2,'A'),(10,3,2,'A'),(16,7,2,'A'),(8,1,3,'A'),(4,2,3,'A'),(11,3,3,'A'),(15,7,3,'A'),(20,1,4,'A'),(22,2,4,'A'),(26,3,4,'A'),(23,4,4,'A'),(24,5,4,'A'),(25,6,4,'A'),(21,1,5,'I'),(7,2,5,'I'),(27,1,6,'A'),(5,2,6,'A'),(28,3,6,'A'),(34,4,6,'A'),(33,5,6,'A'),(30,6,6,'A'),(31,7,6,'A'),(32,8,6,'A'),(29,9,6,'A'),(35,10,6,'A'),(37,12,6,'A'),(36,13,6,'A'),(38,14,6,'A'),(39,15,6,'A'),(40,16,6,'A'),(41,17,6,'A'),(42,18,6,'A'),(43,19,6,'A'),(44,20,6,'A'),(45,21,6,'A'),(46,22,6,'A');

--
-- Temporary table structure for view `planes`
--

/*!50001 DROP VIEW IF EXISTS `planes`*/;
/*!50001 CREATE VIEW `planes` AS SELECT 
 1 AS `numfol`,
 1 AS `descripcion`,
 1 AS `fecini`,
 1 AS `fecfin`*/;

--
-- Table structure for table `planificador`
--

CREATE TABLE `planificador` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `tipo_servicio_id` int(10) unsigned NOT NULL,
  `salon_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fecha` (`fecha`,`tipo_servicio_id`,`salon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `planificador`
--


--
-- Table structure for table `planificador_detalle`
--

CREATE TABLE `planificador_detalle` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `planificador_id` int(10) unsigned NOT NULL,
  `menus_items_id` int(10) unsigned NOT NULL,
  `cantidad` int(10) unsigned NOT NULL,
  `costo` decimal(10,2) NOT NULL,
  `valor` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `planificador_detalle`
--


--
-- Table structure for table `popularidad`
--

CREATE TABLE `popularidad` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cantidad` int(11) NOT NULL,
  `valor` decimal(22,2) NOT NULL,
  `costo` decimal(22,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `popularidad`
--


--
-- Table structure for table `printers`
--

CREATE TABLE `printers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(40) DEFAULT NULL,
  `ubicacion` varchar(120) DEFAULT NULL,
  `estado` char(1) NOT NULL DEFAULT 'A',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `printers`
--

INSERT INTO `printers` VALUES (2,'Epson TMU220','\\\\\\\\RECEPCION\\\\epson tm-u220','A'),(3,'restautante','restaurante','A');

--
-- Table structure for table `prueba`
--

CREATE TABLE `prueba` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `numero` int(11) DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `hora` time DEFAULT NULL,
  `email` varchar(40) DEFAULT NULL,
  `estado` char(1) DEFAULT NULL,
  `fecha_otro` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `prueba`
--


--
-- Table structure for table `qx__$schema`
--

CREATE TABLE `qx__$schema` (
  `TABLE_NAME` varchar(30) CHARACTER SET latin1 NOT NULL,
  `COLUMN_NAME` varchar(30) CHARACTER SET latin1 NOT NULL,
  `INFORMIX_TYPE_CODE` smallint(6) NOT NULL,
  `INFORMIX_TYPE_DATA` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qx__$schema`
--


--
-- Table structure for table `recetal`
--

CREATE TABLE `recetal` (
  `id` int(10) DEFAULT NULL,
  `tipol` char(1) DEFAULT NULL,
  `almacen` decimal(2,0) DEFAULT NULL,
  `numero_rec` int(11) NOT NULL,
  `item` char(15) NOT NULL,
  `divisor` decimal(4,0) NOT NULL,
  `cantidad` decimal(6,2) NOT NULL,
  `valore` decimal(10,2) DEFAULT NULL,
  `valor` decimal(10,2) DEFAULT NULL,
  UNIQUE KEY `l_recetal` (`almacen`,`numero_rec`,`item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `recetal`
--


--
-- Temporary table structure for view `recetas`
--

/*!50001 DROP VIEW IF EXISTS `recetas`*/;
/*!50001 CREATE VIEW `recetas` AS SELECT 
 1 AS `almacen`,
 1 AS `numero_rec`,
 1 AS `nombre`,
 1 AS `num_personas`,
 1 AS `tipo`,
 1 AS `porc_varios`,
 1 AS `precio_venta`,
 1 AS `iva`,
 1 AS `precio_costo`,
 1 AS `porc_costo`,
 1 AS `costoent`*/;

--
-- Temporary table structure for view `referencias`
--

/*!50001 DROP VIEW IF EXISTS `referencias`*/;
/*!50001 CREATE VIEW `referencias` AS SELECT 
 1 AS `id`,
 1 AS `nombre`,
 1 AS `nombre_unido`,
 1 AS `tipo`*/;

--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL,
  `description` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `resources`
--

INSERT INTO `resources` VALUES (47,'Clientes','Modulo de Clientes'),(48,'Facturas','Modulo de Facturas'),(49,'Pedidos','Modulo de Pedidos');

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(24) DEFAULT NULL,
  `description` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (38,'Administradores','Administran el sistema');

--
-- Temporary table structure for view `saldosd`
--

/*!50001 DROP VIEW IF EXISTS `saldosd`*/;
/*!50001 CREATE VIEW `saldosd` AS SELECT 
 1 AS `item`,
 1 AS `centro_costo`,
 1 AS `dependen`,
 1 AS `ano_mes`,
 1 AS `saldot`,
 1 AS `saldo`,
 1 AS `costo`*/;

--
-- Table structure for table `salon`
--

CREATE TABLE `salon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(50) NOT NULL,
  `autorizacion` char(25) DEFAULT NULL,
  `fecha_autorizacion` date DEFAULT NULL,
  `prefijo_facturacion` char(12) NOT NULL,
  `consecutivo_inicial` int(10) unsigned NOT NULL,
  `consecutivo_final` int(10) unsigned NOT NULL,
  `consecutivo_facturacion` int(10) unsigned NOT NULL,
  `consecutivo_orden` int(10) unsigned NOT NULL,
  `prefijo_orden` char(5) DEFAULT NULL,
  `tipo_comanda` char(1) DEFAULT NULL,
  `consecutivo_comanda` int(11) DEFAULT NULL,
  `usuarios_hotel_id` int(10) unsigned NOT NULL,
  `conceptos_id` int(10) unsigned NOT NULL,
  `centro_costo` int(10) unsigned DEFAULT NULL,
  `porcentaje_servicio` int(3) DEFAULT NULL,
  `pide_asientos` char(1) NOT NULL DEFAULT 'S',
  `pide_personas` char(1) NOT NULL DEFAULT 'S',
  `leyenda_propina` char(1) DEFAULT NULL,
  `texto_propina` text,
  `propina_automatica` char(1) DEFAULT NULL,
  `venta_a` char(1) DEFAULT NULL,
  `texto_impresion` text,
  `descarga_online` char(1) DEFAULT 'N',
  `ancho_mesas` int(3) unsigned NOT NULL,
  `alto_mesas` int(3) unsigned NOT NULL,
  `cierre_pedidos` char(1) DEFAULT 'N',
  `tipo_venta_default` char(1) DEFAULT NULL,
  `estado` char(1) NOT NULL DEFAULT 'A',
  PRIMARY KEY (`id`),
  KEY `estado` (`estado`),
  KEY `conceptos_id` (`conceptos_id`),
  KEY `usuarios_hotel_id` (`usuarios_hotel_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `salon`
--

INSERT INTO `salon` VALUES (6,'MINIBAR','-','2017-01-01','1',1,1,1,2035,NULL,'A',2117,1,67,300,0,'N','N','N',NULL,'N','H',NULL,'N',8,10,'S','H','A');

--
-- Table structure for table `salon_menus_items`
--

CREATE TABLE `salon_menus_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `salon_id` int(11) NOT NULL,
  `menus_items_id` int(11) NOT NULL,
  `valor` decimal(16,2) DEFAULT NULL,
  `descarga` char(1) NOT NULL DEFAULT 'S',
  `almacen` int(11) DEFAULT NULL,
  `conceptos_id` int(11) DEFAULT NULL,
  `printers_id` int(11) DEFAULT NULL,
  `printers_id2` int(11) DEFAULT NULL,
  `screens_id` int(10) unsigned NOT NULL,
  `estado` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `salon_id` (`salon_id`),
  KEY `menus_items_id` (`menus_items_id`),
  KEY `salon_id_2` (`salon_id`,`menus_items_id`,`estado`),
  KEY `screens_id` (`screens_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `salon_menus_items`
--

INSERT INTO `salon_menus_items` VALUES (1,6,1,2500.00,'S',1,5,2,2,0,'A'),(2,6,2,2500.00,'S',1,5,2,2,0,'A'),(3,6,4,1800.00,'S',1,5,2,2,0,'A'),(4,6,3,3000.00,'S',1,5,2,2,0,'A'),(5,6,5,3500.00,'S',1,5,3,3,0,'A');

--
-- Table structure for table `salon_mesas`
--

CREATE TABLE `salon_mesas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `salon_id` int(11) NOT NULL,
  `vpos` char(2) NOT NULL DEFAULT '',
  `hpos` char(2) NOT NULL DEFAULT '',
  `numero` varchar(5) DEFAULT NULL,
  `estado` char(1) DEFAULT 'N',
  PRIMARY KEY (`id`),
  KEY `salon_id` (`salon_id`,`vpos`,`hpos`),
  KEY `salon_id_2` (`salon_id`,`estado`)
) ENGINE=InnoDB AUTO_INCREMENT=421 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `salon_mesas`
--

INSERT INTO `salon_mesas` VALUES (386,6,'0','0','201','N'),(387,6,'0','1','202','N'),(388,6,'0','2','203','N'),(389,6,'0','3','204','N'),(390,6,'0','4','205','N'),(391,6,'0','5','206','N'),(392,6,'0','6','207','N'),(393,6,'0','7','208','N'),(394,6,'0','8','209','N'),(395,6,'1','0','301','N'),(396,6,'1','1','302','N'),(397,6,'1','2','303','N'),(398,6,'1','3','304','N'),(399,6,'1','4','305','N'),(400,6,'1','5','306','N'),(401,6,'1','6','307','N'),(402,6,'1','7','308','N'),(403,6,'1','8','309','N'),(404,6,'2','0','401','N'),(405,6,'2','1','402','N'),(406,6,'2','2','403','N'),(407,6,'2','3','404','N'),(408,6,'2','4','405','N'),(409,6,'2','5','406','N'),(410,6,'2','6','407','N'),(411,6,'2','7','408','N'),(412,6,'2','8','409','N'),(413,6,'3','0','501','N'),(414,6,'3','1','502','N'),(415,6,'3','2','503','N'),(416,6,'3','3','504','N'),(417,6,'3','4','505','N'),(418,6,'3','5','506','N'),(419,6,'3','6','507','N'),(420,6,'3','7','508','N');

--
-- Table structure for table `salon_tipo_venta`
--

CREATE TABLE `salon_tipo_venta` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `salon_id` int(10) unsigned NOT NULL,
  `tipo_venta_id` char(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `salon_id` (`salon_id`),
  KEY `tipo_venta_id` (`tipo_venta_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `salon_tipo_venta`
--

INSERT INTO `salon_tipo_venta` VALUES (1,6,'H'),(2,6,'U');

--
-- Table structure for table `screens`
--

CREATE TABLE `screens` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
  `estado` char(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `screens`
--


--
-- Temporary table structure for view `socios_actual`
--

/*!50001 DROP VIEW IF EXISTS `socios_actual`*/;
/*!50001 CREATE VIEW `socios_actual` AS SELECT 
 1 AS `accion`,
 1 AS `numfol`,
 1 AS `numhab`,
 1 AS `nombre`,
 1 AS `estado`*/;

--
-- Table structure for table `tipo_servicio`
--

CREATE TABLE `tipo_servicio` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(35) COLLATE utf8_unicode_ci NOT NULL,
  `estado` char(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tipo_servicio`
--

INSERT INTO `tipo_servicio` VALUES (1,'SERVICIO ADICIONAL EXTRA','A');

--
-- Table structure for table `tipo_venta`
--

CREATE TABLE `tipo_venta` (
  `id` char(1) NOT NULL,
  `detalle` varchar(45) NOT NULL,
  `costo` char(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tipo_venta`
--

INSERT INTO `tipo_venta` VALUES ('C','CORTESIA','S'),('F','FACTURA','N'),('H','CARGO HABITACION/FOLIO','N'),('P','PLAN','S'),('U','FUNCIONARIO','S');

--
-- Table structure for table `usuarios`
--

CREATE TABLE `usuarios` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clave` char(40) NOT NULL,
  `nombre` char(50) NOT NULL DEFAULT '',
  `perfil` varchar(24) DEFAULT NULL,
  `estado` char(1) DEFAULT 'A',
  PRIMARY KEY (`id`),
  KEY `clave` (`clave`,`estado`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usuarios`
--


--
-- Temporary table structure for view `usuarios_hotel`
--

/*!50001 DROP VIEW IF EXISTS `usuarios_hotel`*/;
/*!50001 CREATE VIEW `usuarios_hotel` AS SELECT 
 1 AS `id`,
 1 AS `nombre`*/;

--
-- Table structure for table `usuarios_pos`
--

CREATE TABLE `usuarios_pos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clave` char(40) NOT NULL,
  `nombre` char(50) NOT NULL DEFAULT '',
  `perfil` varchar(24) DEFAULT NULL,
  `estado` char(1) DEFAULT 'A',
  PRIMARY KEY (`id`),
  KEY `clave` (`clave`,`estado`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usuarios_pos`
--

INSERT INTO `usuarios_pos` VALUES (1,'e28b45cced3c89ad3835fbdf261367ebea91b180','ADMINISTRADOR SOLUTION','Administradores','A'),(2,'51982460d85abe2876c2d0a81a2f7f9db95c0042','PAMELA ECHEVERRY','Cajeros','I'),(3,'8d213cca906fd91eb518588c3a3e97ca5a364637','GINA AVELLANEDA','Administradores','A'),(4,'cb23026edba0278e467358cb9801f80c00c68fc2','PAOLA RUEDA','Cajeros','A'),(5,'204d1b68ca70c70e17417076588df954f47da0da','LORENA LARROTA','Cajeros','I'),(6,'c255e4e00d1e8081e3b3e0e0f1a6682fb90811f6','GERALDIN MEDINA','Cajeros','A'),(7,'aa223abbb86b3521c658660231de17f96ecde53e','GIOVANNA MORENO','Administradores','A'),(8,'a009b39852acf9de0a6b7c938e73c22946218e7e','LIZVTHE ESTUPIÑAN','Administradores','A'),(9,'899a19b6bec5cddc50179f183ba138b628cf94b3','ELIANA VILLALOBOS','Cajeros','A'),(10,'189ee872d4d83256175dd2e108e01a9fe9ae27bd','CATALINA LEON','Cajeros','I'),(11,'d475bd43bdae3488afe8a0f648ee5671fb6cdc40','DEYSY AGUDELO','Administradores','A'),(12,'439ffe66293cf1f5601dcaeb02fa2e668850027e','ROSA RIVAS','Cajeros','A'),(13,'011c945f30ce2cbafc452f39840f025693339c42','BLADIMIR PINILLA','Cajeros','I'),(14,'2a94b50a655ce6b38f78ca33a4b95e39f0521b89','ALEX PARRA','Cajeros','I'),(15,'5b88bcc2c54c2e94c2e91b4f47f09f3031c82c36','CONNY','Cajeros','I'),(16,'2972171f9cf6653aa953426952b5ffd2535d14a3','NATALIA PARRA','Cajeros','I'),(17,'5a478022f33905d2d40410e006fb1aa8564b280c','DANIELA MAYORGA','Cajeros','A'),(18,'1e8d0db4d285c13611cf3affd3dc3119d6569574','SANDRA VELASQUEZ','Cajeros','I'),(19,'0aa9161521f63fce92adf77eb6ad19b9395614d2','CAMILO LARROTA','Cajeros','I'),(20,'3d948cbd662ed4b5741d8b76e07b9331f12fbf86','MAURICIO JAIMES','Cajeros','A'),(21,'10663edb81d4a2f1530506f18c3611889dcd8674','JHON SILVA','Cajeros','A'),(22,'9e3eebdcd3d3586859fd8511a516be87a487bfb4','ANGELICA VELASCO','Cajeros','A');

--
-- Table structure for table `ventas_default`
--

CREATE TABLE `ventas_default` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tipo_venta_id` char(1) NOT NULL,
  `cedula` varchar(15) NOT NULL,
  `valor_minimo` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tipo_venta_id` (`tipo_venta_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ventas_default`
--

INSERT INTO `ventas_default` VALUES (1,'F','222222222',1000000.00);

--
-- Dumping routines for database 'ptorrea'
--

--
-- Final view structure for view `acompanantes`
--

/*!50001 DROP VIEW IF EXISTS `acompanantes`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `acompanantes` AS select `htorrea`.`apofol`.`numfol` AS `numfol`,`htorrea`.`apofol`.`numero` AS `numero`,`htorrea`.`apofol`.`tipdoc` AS `tipdoc`,`htorrea`.`apofol`.`cedula` AS `cedula`,`htorrea`.`apofol`.`nombre` AS `nombre`,`htorrea`.`apofol`.`lugexp` AS `lugexp`,`htorrea`.`apofol`.`codpro` AS `codpro`,`htorrea`.`apofol`.`sexo` AS `sexo` from `htorrea`.`apofol` */;

--
-- Final view structure for view `clientes`
--

/*!50001 DROP VIEW IF EXISTS `clientes`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `clientes` AS select `c`.`cedula` AS `id`,`c`.`nombre` AS `nombre`,`c`.`direccion` AS `direccion`,`c`.`telefono1` AS `telefono` from `htorrea`.`clientes` `c` union select `e`.`nit` AS `id`,`e`.`nombre` AS `nombre`,`e`.`direccion` AS `direccion`,`e`.`telefono` AS `telefono` from `htorrea`.`empresas` `e` */;

--
-- Final view structure for view `conceptos`
--

/*!50001 DROP VIEW IF EXISTS `conceptos`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `conceptos` AS select `htorrea`.`cargos`.`codcar` AS `id`,`htorrea`.`cargos`.`descripcion` AS `descripcion` from `htorrea`.`cargos` where ((`htorrea`.`cargos`.`tipmov` = _utf8'D') and (`htorrea`.`cargos`.`descaj` <> _utf8'S') and (`htorrea`.`cargos`.`estado` = _utf8'A')) */;

--
-- Final view structure for view `cuentas`
--

/*!50001 DROP VIEW IF EXISTS `cuentas`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `cuentas` AS select `f`.`numfol` AS `numfol`,`c`.`numcue` AS `numcue`,`t`.`detalle` AS `nombre`,`f`.`numhab` AS `habitacion_id`,`c`.`estado` AS `estado` from ((`htorrea`.`carghab` `c` join `htorrea`.`folio` `f`) join `htorrea`.`tipcue` `t`) where ((`f`.`numfol` = `c`.`numfol`) and (`f`.`estado` in (_utf8'I',_utf8'C',_utf8'F')) and (`c`.`numcue` = `t`.`numcue`) and (`c`.`estado` = _utf8'N')) order by `f`.`numhab` */;

--
-- Final view structure for view `empresa1`
--

/*!50001 DROP VIEW IF EXISTS `empresa1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `empresa1` AS select `rtorrea`.`empresa1`.`f_cierref` AS `f_cierref`,`rtorrea`.`empresa1`.`f_cierrep` AS `f_cierrep`,`rtorrea`.`empresa1`.`ano_c` AS `ano_c`,`rtorrea`.`empresa1`.`base_ret` AS `base_ret`,`rtorrea`.`empresa1`.`otros` AS `otros` from `rtorrea`.`empresa1` */;

--
-- Final view structure for view `formas_pago`
--

/*!50001 DROP VIEW IF EXISTS `formas_pago`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `formas_pago` AS select `htorrea`.`forpag`.`forpag` AS `id`,`htorrea`.`forpag`.`detalle` AS `detalle` from `htorrea`.`forpag` */;

--
-- Final view structure for view `habitacion`
--

/*!50001 DROP VIEW IF EXISTS `habitacion`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `habitacion` AS select `htorrea`.`folio`.`numfol` AS `id`,`htorrea`.`clientes`.`tipdoc` AS `tipdoc`,if((`htorrea`.`folio`.`cedula` = _utf8'0'),`htorrea`.`folio`.`nit`,`htorrea`.`folio`.`cedula`) AS `cedula`,if((`htorrea`.`folio`.`cedula` = _utf8'0'),`htorrea`.`empresas`.`nombre`,`htorrea`.`clientes`.`nombre`) AS `nombre`,`htorrea`.`folio`.`nit` AS `nit`,`htorrea`.`folio`.`numhab` AS `numhab`,`htorrea`.`folio`.`numadu` AS `numero_adultos`,`htorrea`.`folio`.`numnin` AS `numero_ninos`,`htorrea`.`folio`.`numinf` AS `numero_infantes`,`htorrea`.`folio`.`notaayb` AS `nota` from ((`htorrea`.`folio` join `htorrea`.`clientes`) join `htorrea`.`empresas`) where ((`htorrea`.`folio`.`cedula` = `htorrea`.`clientes`.`cedula`) and (`htorrea`.`folio`.`nit` = `htorrea`.`empresas`.`nit`) and (`htorrea`.`folio`.`estado` in (_utf8'I',_utf8'F')) and (`htorrea`.`folio`.`corregir` = _utf8'N')) order by concat(convert(repeat(_latin1' ',(6 - length(`htorrea`.`folio`.`numhab`))) using utf8),`htorrea`.`folio`.`numhab`) */;

--
-- Final view structure for view `habitacion_historico`
--

/*!50001 DROP VIEW IF EXISTS `habitacion_historico`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `habitacion_historico` AS select `htorrea`.`folio`.`numfol` AS `id`,`htorrea`.`tipdoc`.`tipcoa` AS `tipdoc`,if((`htorrea`.`clientes`.`cedula` <> _utf8'0'),`htorrea`.`clientes`.`cedula`,`htorrea`.`empresas`.`nit`) AS `cedula`,if((`htorrea`.`clientes`.`cedula` <> _utf8'0'),`htorrea`.`clientes`.`nombre`,`htorrea`.`empresas`.`nombre`) AS `nombre`,`htorrea`.`folio`.`numhab` AS `numhab`,`htorrea`.`folio`.`numadu` AS `numero_adultos`,`htorrea`.`folio`.`numnin` AS `numero_ninos`,`htorrea`.`folio`.`numinf` AS `numero_infantes`,`htorrea`.`folio`.`notaayb` AS `nota` from (((`htorrea`.`folio` join `htorrea`.`clientes`) join `htorrea`.`empresas`) join `htorrea`.`tipdoc`) where ((`htorrea`.`tipdoc`.`tipdoc` = `htorrea`.`clientes`.`tipdoc`) and (`htorrea`.`clientes`.`cedula` = `htorrea`.`folio`.`cedula`) and (`htorrea`.`empresas`.`nit` = `htorrea`.`folio`.`nit`)) */;

--
-- Final view structure for view `habitaciones`
--

/*!50001 DROP VIEW IF EXISTS `habitaciones`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `habitaciones` AS select `htorrea`.`habitacion`.`numhab` AS `id`,`htorrea`.`clahab`.`clase` AS `clase`,`htorrea`.`habitacion`.`piso` AS `piso` from (`htorrea`.`habitacion` join `htorrea`.`clahab`) where ((`htorrea`.`habitacion`.`codcla` = `htorrea`.`clahab`.`codcla`) and (`htorrea`.`habitacion`.`tipo` = _utf8'V')) order by `htorrea`.`habitacion`.`numhab` */;

--
-- Final view structure for view `lineas`
--

/*!50001 DROP VIEW IF EXISTS `lineas`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `lineas` AS select `rtorrea`.`lineas`.`almacen` AS `almacen`,`rtorrea`.`lineas`.`linea` AS `linea`,`rtorrea`.`lineas`.`nombre` AS `nombre`,`rtorrea`.`lineas`.`es_auxiliar` AS `es_auxiliar`,`rtorrea`.`lineas`.`cta_compra` AS `cta_compra`,`rtorrea`.`lineas`.`cta_venta` AS `cta_venta`,`rtorrea`.`lineas`.`cta_consumo` AS `cta_consumo`,`rtorrea`.`lineas`.`cta_descuento` AS `cta_descuento`,`rtorrea`.`lineas`.`cta_inve` AS `cta_inve`,`rtorrea`.`lineas`.`cta_costo_venta` AS `cta_costo_venta`,`rtorrea`.`lineas`.`cta_ret_compra` AS `cta_ret_compra`,`rtorrea`.`lineas`.`porc_compra` AS `porc_compra`,`rtorrea`.`lineas`.`minimo_ret` AS `minimo_ret`,`rtorrea`.`lineas`.`cta_dev_ventas` AS `cta_dev_ventas`,`rtorrea`.`lineas`.`cta_dev_compras` AS `cta_dev_compras`,`rtorrea`.`lineas`.`cta_hortic` AS `cta_hortic`,`rtorrea`.`lineas`.`porc_hortic` AS `porc_hortic`,`rtorrea`.`lineas`.`minimo_v` AS `minimo_v`,`rtorrea`.`lineas`.`minimo_c` AS `minimo_c` from `rtorrea`.`lineas` */;

--
-- Final view structure for view `movimiento_folio`
--

/*!50001 DROP VIEW IF EXISTS `movimiento_folio`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `movimiento_folio` AS select `htorrea`.`valcar`.`numfol` AS `folio`,`htorrea`.`valcar`.`numcue` AS `cuenta`,(max(`htorrea`.`valcar`.`item`) + 1) AS `item` from `htorrea`.`valcar` group by `htorrea`.`valcar`.`numfol`,`htorrea`.`valcar`.`numcue` order by `htorrea`.`valcar`.`numfol`,`htorrea`.`valcar`.`numcue` */;

--
-- Final view structure for view `planes`
--

/*!50001 DROP VIEW IF EXISTS `planes`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `planes` AS select `htorrea`.`plafol`.`numfol` AS `numfol`,`htorrea`.`planes`.`descripcion` AS `descripcion`,`htorrea`.`plafol`.`fecini` AS `fecini`,`htorrea`.`plafol`.`fecfin` AS `fecfin` from (`htorrea`.`plafol` join `htorrea`.`planes`) where (`htorrea`.`planes`.`codpla` = `htorrea`.`plafol`.`codpla`) */;

--
-- Final view structure for view `recetas`
--

/*!50001 DROP VIEW IF EXISTS `recetas`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `recetas` AS select `rtorrea`.`recetap`.`almacen` AS `almacen`,`rtorrea`.`recetap`.`numero_rec` AS `numero_rec`,`rtorrea`.`recetap`.`nombre` AS `nombre`,`rtorrea`.`recetap`.`num_personas` AS `num_personas`,`rtorrea`.`recetap`.`tipo` AS `tipo`,`rtorrea`.`recetap`.`porc_varios` AS `porc_varios`,`rtorrea`.`recetap`.`precio_venta` AS `precio_venta`,`rtorrea`.`recetap`.`iva` AS `iva`,`rtorrea`.`recetap`.`precio_costo` AS `precio_costo`,`rtorrea`.`recetap`.`porc_costo` AS `porc_costo`,`rtorrea`.`recetap`.`costoent` AS `costoent` from `rtorrea`.`recetap` */;

--
-- Final view structure for view `referencias`
--

/*!50001 DROP VIEW IF EXISTS `referencias`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `referencias` AS select trim(`rtorrea`.`inve`.`item`) AS `id`,`rtorrea`.`inve`.`descripcion` AS `nombre`,concat(`rtorrea`.`inve`.`item`,_latin1' : ',`rtorrea`.`inve`.`descripcion`,_latin1' - REFERENCIA') AS `nombre_unido`,_utf8'I' AS `tipo` from `rtorrea`.`inve` where (`rtorrea`.`inve`.`estado` = _latin1'A') union select `rtorrea`.`recetap`.`numero_rec` AS `id`,`rtorrea`.`recetap`.`nombre` AS `nombre`,concat(`rtorrea`.`recetap`.`numero_rec`,' : ',`rtorrea`.`recetap`.`nombre`,' - RECETA ') AS `nombre_unido`,_utf8'R' AS `tipo` from `rtorrea`.`recetap` where (`rtorrea`.`recetap`.`almacen` = 1) order by `tipo` */;

--
-- Final view structure for view `saldosd`
--

/*!50001 DROP VIEW IF EXISTS `saldosd`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `saldosd` AS select `rtorrea`.`saldosd`.`item` AS `item`,`rtorrea`.`saldosd`.`centro_costo` AS `centro_costo`,`rtorrea`.`saldosd`.`dependen` AS `dependen`,`rtorrea`.`saldosd`.`ano_mes` AS `ano_mes`,`rtorrea`.`saldosd`.`saldot` AS `saldot`,`rtorrea`.`saldosd`.`saldo` AS `saldo`,`rtorrea`.`saldosd`.`costo` AS `costo` from `rtorrea`.`saldosd` */;

--
-- Final view structure for view `socios_actual`
--

/*!50001 DROP VIEW IF EXISTS `socios_actual`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `socios_actual` AS select `htorrea`.`clientes`.`accion` AS `accion`,`htorrea`.`folio`.`numfol` AS `numfol`,`htorrea`.`folio`.`numhab` AS `numhab`,`htorrea`.`clientes`.`nombre` AS `nombre`,`htorrea`.`folio`.`estado` AS `estado` from (`htorrea`.`folio` join `htorrea`.`clientes`) where ((`htorrea`.`folio`.`cedula` = `htorrea`.`clientes`.`cedula`) and (`htorrea`.`folio`.`estado` in (_utf8'I',_utf8'F'))) */;

--
-- Final view structure for view `usuarios_hotel`
--

/*!50001 DROP VIEW IF EXISTS `usuarios_hotel`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `usuarios_hotel` AS select `htorrea`.`usuarios`.`codusu` AS `id`,`htorrea`.`usuarios`.`nombre` AS `nombre` from `htorrea`.`usuarios` where (`htorrea`.`usuarios`.`estado` = _utf8'A') */;


