# ************************************************************
# Sequel Ace SQL dump
# Versión 20090
#
# https://sequel-ace.com/
# https://github.com/Sequel-Ace/Sequel-Ace
#
# Equipo: 34.39.132.51 (MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1)
# Base de datos: aguas
# Tiempo de generación: 2025-06-04 01:52:46 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
SET NAMES utf8mb4;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE='NO_AUTO_VALUE_ON_ZERO', SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Volcado de tabla estados
# ------------------------------------------------------------

CREATE TABLE `estados` (
  `idEstado` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(50) NOT NULL,
  `leyenda` varchar(100) DEFAULT NULL,
  `descripcion` text DEFAULT NULL,
  PRIMARY KEY (`idEstado`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

LOCK TABLES `estados` WRITE;
/*!40000 ALTER TABLE `estados` DISABLE KEYS */;

INSERT INTO `estados` (`idEstado`, `nombre`, `leyenda`, `descripcion`)
VALUES
	(1,'Habilitado','Habilitado','Medidor Habilitado'),
	(2,'Normal','Normal','Medidor Normal'),
	(3,'Falla','Falla','Medidor en Falla');

/*!40000 ALTER TABLE `estados` ENABLE KEYS */;
UNLOCK TABLES;


# Volcado de tabla mediciones
# ------------------------------------------------------------

CREATE TABLE `mediciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idEstado` int(11) NOT NULL,
  `idMedidor` int(11) NOT NULL,
  `fecha_recepcion` datetime NOT NULL,
  `rssi` int(11) NOT NULL,
  `cumul_flow_unit` double DEFAULT NULL,
  `cumul_flow_value` int(11) DEFAULT NULL,
  `daily_flow_unit` double DEFAULT NULL,
  `daily_flow_value` int(11) DEFAULT NULL,
  `reverse_flow_unit` double DEFAULT NULL,
  `reverse_flow_value` int(11) DEFAULT NULL,
  `flow_rate_unit` double DEFAULT NULL,
  `flow_rate_value` int(11) DEFAULT NULL,
  `temperatura` double DEFAULT NULL,
  `meter_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idEstado` (`idEstado`),
  KEY `idMedidor` (`idMedidor`),
  CONSTRAINT `mediciones_ibfk_1` FOREIGN KEY (`idEstado`) REFERENCES `estados` (`idEstado`),
  CONSTRAINT `mediciones_ibfk_2` FOREIGN KEY (`idMedidor`) REFERENCES `medidores` (`idMedidor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;



# Volcado de tabla medidores
# ------------------------------------------------------------

CREATE TABLE `medidores` (
  `idMedidor` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(80) NOT NULL,
  `identificador` varchar(20) NOT NULL,
  `ubicacion` varchar(80) NOT NULL,
  `idOrganizacion` int(11) NOT NULL,
  `idModelo` int(11) NOT NULL,
  `timeRep` int(11) NOT NULL,
  `latitud` double NOT NULL,
  `longitud` double NOT NULL,
  `lastUpdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`idMedidor`),
  UNIQUE KEY `identificador` (`identificador`),
  KEY `idOrganizacion` (`idOrganizacion`),
  KEY `medidores_ibfk_modelo` (`idModelo`),
  CONSTRAINT `medidores_ibfk_1` FOREIGN KEY (`idOrganizacion`) REFERENCES `organizaciones` (`idOrganizacion`),
  CONSTRAINT `medidores_ibfk_modelo` FOREIGN KEY (`idModelo`) REFERENCES `modelos` (`idModelo`)
) ENGINE=InnoDB AUTO_INCREMENT=277 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

LOCK TABLES `medidores` WRITE;
/*!40000 ALTER TABLE `medidores` DISABLE KEYS */;

INSERT INTO `medidores` (`idMedidor`, `nombre`, `identificador`, `ubicacion`, `idOrganizacion`, `idModelo`, `timeRep`, `latitud`, `longitud`, `lastUpdate`)
VALUES
	(1,'Medidor 1','E0EDE715091C0072','.',1,1,0,0,0,'0000-00-00 00:00:00'),
	(2,'Medidor 2','0400E8EB1B538BCE','.',1,1,0,0,0,'0000-00-00 00:00:00'),
	(3,'Medidor 3','E0EDE7160218001C','1',1,1,0,0,0,'0000-00-00 00:00:00'),
	(4,'68753500112181','8CF957200013D522','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(5,'68753500112252','8CF957200013DFF0','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(6,'68753500112104','8CF957200013E013','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(7,'68753500112103','8CF957200013E070','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(8,'68753500112086','8CF957200013D202','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(9,'68753500112098','8CF957200013DE2F','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(10,'68753500112177','8CF957200013D299','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(11,'68753500112031','8CF957200013D5DA','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(12,'68753500112064','8CF957200013D4DD','S.E.C. -RAW. - ',2,1,0,0,0,'0000-00-00 00:00:00'),
	(13,'68753500112157','8CF957200013E0D2','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(14,'68753500112233','8CF957200013DFA7','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(15,'68753500112153','8CF957200013D292','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(16,'68753500112081','8CF957200013E0AD','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(17,'68753500112176','8CF957200013DDAC','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(18,'68753500112250','8CF957200013D45D','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(19,'68753500112100','8CF957200013D598','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(20,'68753500112121','8CF957200013DFAC','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(21,'68753500112131','8CF957200013D433','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(22,'68753500112199','8CF957200013D2D3','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(23,'68753500112018','8CF957200013DF48','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(24,'68753500112080','8CF957200013D5AB','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(25,'68753500112023','8CF957200013D271','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(26,'68753500112148','8CF957200013E06A','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(27,'68753500112026','8CF957200013D784','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(28,'68753500112113','8CF957200013D4D3','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(29,'68753500112048','8CF957200013D1DB','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(30,'68753500112227','8CF957200013D1F8','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(31,'68753500112183','8CF957200013D4F7','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(32,'68753500112154','8CF957200013D273','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(33,'68753500112272','8CF957200013D4E8','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(34,'68753500112070','8CF957200013E1A6','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(35,'68753500112242','8CF957200013E0C3','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(36,'68753500112166','8CF957200013D80A','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(37,'68753500112210','8CF957200013D424','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(38,'68753500112049','8CF957200013DDB7','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(39,'68753500112073','8CF957200013D2C5','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(40,'68753500112045','8CF957200013D568','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(41,'68753500112205','8CF957200013D525','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(42,'68753500112124','8CF957200013D45A','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(43,'68753500112038','8CF957200013D361','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(44,'68753500112265','8CF957200013D9C9','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(45,'68753500112107','8CF957200013DE81','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(46,'68753500112021','8CF957200013D4CC','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(47,'68753500112248','8CF957200013D4DC','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(48,'68753500112270','8CF957200013DDD3','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(49,'68753500112158','8CF957200013D451','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(50,'68753500112223','8CF957200013DE2E','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(51,'68753500112134','8CF957200013D2B3','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(52,'68753500112255','8CF957200013D41C','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(53,'68753500112105','8CF957200013E185','Calle',2,1,0,0,0,'0000-00-00 00:00:00'),
	(54,'68753500112039','8CF957200013D47D','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(55,'68753500112099','8CF957200013D585','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(56,'68753500112259','8CF957200013D4D8','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(57,'68753500112228','8CF957200013D297','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(58,'68753500112120','8CF957200013D455','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(59,'68753500112034','8CF957200013DF93','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(60,'68753500112028','8CF957200013D777','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(61,'68753500112016','8CF957200013D2F4','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(62,'68753500112106','8CF957200013D4DF','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(63,'68753500112076','8CF957200013D54A','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(64,'68753500112020','8CF957200013E06B','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(65,'68753500112108','8CF957200013D20D','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(66,'68753500112092','8CF957200013DF73','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(67,'68753500112044','8CF957200013D457','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(68,'68753500112145','8CF957200013DF6C','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(69,'68753500112032','8CF957200013D562','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(70,'68753500112230','8CF957200013E0FC','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(71,'68753500112097','8CF957200013E015','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(72,'68753500112136','8CF957200013D3FB','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(73,'68753500112052','8CF957200013E0EE','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(74,'68753500112096','8CF957200013D1CB','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(75,'68753500112088','8CF957200013E1ED','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(76,'68753500112029','8CF957200013DEAB','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(77,'68753500112057','8CF957200013D5C2','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(78,'68753500112109','8CF957200013E1F1','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(79,'68753500112068','8CF957200013D38F','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(80,'68753500112033','8CF957200013D54B','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(81,'68753500112261','8CF957200013DDFE','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(82,'68753500112126','8CF957200013D9E2','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(83,'68753500112091','8CF957200013D9DF','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(84,'68753500112208','8CF957200013D5B2','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(85,'68753500112036','8CF957200013DF8F','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(86,'68753500112053','8CF957200013D4EB','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(87,'68753500112089','8CF957200013D51C','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(88,'68753500112072','8CF957200013DDA2','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(89,'68753500112165','8CF957200013D788','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(90,'68753500112273','8CF957200013DE06','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(91,'68753500112249','8CF957200013D7F4','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(92,'68753500112236','8CF957200013DE63','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(93,'68753500112027','8CF957200013D404','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(94,'68753500112116','8CF957200013D2F3','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(95,'68753500112190','8CF957200013D9AB','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(96,'68753500112122','8CF957200013E1CD','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(97,'68753500112022','8CF957200013D501','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(98,'68753500112216','8CF957200013DE34','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(99,'68753500112066','8CF957200013D294','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(100,'68753500112192','8CF957200013D35B','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(101,'68753500112280','8CF957200013DDEB','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(102,'68753500112187','8CF957200013E075','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(103,'68753500112178','8CF957200013D550','Calle',3,1,0,0,0,'0000-00-00 00:00:00'),
	(104,'68753500112201','8CF957200013DE89','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(105,'68753500112161','8CF957200013DE92','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(106,'68753500112151','8CF957200013D332','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(107,'68753500112030','8CF957200013DEA3','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(108,'68753500112244','8CF957200013D3A9','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(109,'68753500112185','8CF957200013D2B2','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(110,'68753500112281','8CF957200013DFA0','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(111,'68753500112085','8CF957200013D2CA','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(112,'68753500112269','8CF957200013E1EF','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(113,'68753500112195','8CF957200013D2D8','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(114,'68753500112237','8CF957200013D55A','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(115,'68753500112239','8CF957200013D51F','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(116,'68753500112278','8CF957200013E068','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(117,'68753500112172','8CF957200013D2F2','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(118,'68753500112229','8CF957200013DEDA','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(119,'68753500112180','8CF957200013D2B1','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(120,'68753500112193','8CF957200013D4F9','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(121,'68753500112198','8CF957200013D753','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(122,'68753500112209','8CF957200013D752','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(123,'68753500112069','8CF957200013E049','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(124,'68753500112266','8CF957200013DEB2','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(125,'68753500112204','8CF957200013D5D5','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(126,'68753500112260','8CF957200013D27E','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(127,'68753500112130','8CF957200013DD93','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(128,'68753500112138','8CF957200013DE30','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(129,'68753500112282','8CF957200013D7EA','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(130,'68753500112169','8CF957200013D288','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(131,'68753500112093','8CF957200013E1A4','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(132,'68753500112207','8CF957200013DA0F','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(133,'68753500112163','8CF957200013D2D5','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(134,'68753500112279','8CF957200013DEA0','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(135,'68753500112214','8CF957200013DD9B','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(136,'68753500112075','8CF957200013E019','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(137,'68753500112240','8CF957200013D200','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(138,'68753500112132','8CF957200013D293','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(139,'68753500112191','8CF957200013D4E0','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(140,'68753500112065','8CF957200013DECB','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(141,'68753500112275','8CF957200013CEB9','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(142,'68753500112262','8CF957200013DF54','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(143,'68753500112115','8CF957200013D2CC','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(144,'68753500112133','8CF957200013E184','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(145,'68753500112042','8CF957200013D9F3','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(146,'68753500112150','8CF957200013DD9E','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(147,'68753500112246','8CF957200013D3E1','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(148,'68753500112143','8CF957200013D2E7','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(149,'68753500112146','8CF957200013D4E4','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(150,'68753500112141','8CF957200013D1F2','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(151,'68753500112129','8CF957200013D5C7','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(152,'68753500112206','8CF957200013DF50','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(153,'68753500112114','8CF957200013DF91','Calle',4,1,0,0,0,'0000-00-00 00:00:00'),
	(154,'68753500112203','8CF957200013B66B','CONSEJO DE EDUCACION ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(155,'68753500112213','8CF957200013D4F6','CANNITO Nº: 386 - AUTOSERV. SUR',5,1,0,0,0,'0000-00-00 00:00:00'),
	(156,'68753500112245','8CF957200013D7E3','ALMIRANTE BROWN 394',5,1,0,0,0,'0000-00-00 00:00:00'),
	(157,'68753500112037','8CF957200013DA21','Calle',5,1,0,0,0,'0000-00-00 00:00:00'),
	(158,'68753500112128','8CF957200013D208','ESCUELA Nº: 4 ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(159,'68753500112015','8CF957200013DE8D','CONSEJO DE EDUCACION ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(160,'68753500112041','8CF957200013D1F5','DON TULIO',5,1,0,0,0,'0000-00-00 00:00:00'),
	(161,'68753500112226','8CF957200013D3B9','LOS PIONEROS 1856',5,1,0,0,0,'0000-00-00 00:00:00'),
	(162,'68753500112277','8CF957200013D207','SUPER FERIA - SAN MARTIN',5,1,0,0,0,'0000-00-00 00:00:00'),
	(163,'68753500112056','8CF957200013E052','VACHINA N: 415',5,1,0,0,0,'0000-00-00 00:00:00'),
	(164,'68753500112182','8CF957200013D538','BIGORNIA CLUB',5,1,0,0,0,'0000-00-00 00:00:00'),
	(165,'68753500112084','8CF957200013D78E','RIO PICO 391',5,1,0,0,0,'0000-00-00 00:00:00'),
	(166,'68753500112196','8CF957200013DF2B','COMIENZOS S.R.L',5,1,0,0,0,'0000-00-00 00:00:00'),
	(167,'68753500112159','8CF957200013DE73','SUPER FERIA -CONESA',5,1,0,0,0,'0000-00-00 00:00:00'),
	(168,'68753500112253','8CF957200013DE85','AV. LAPORTE 231',5,1,0,0,0,'0000-00-00 00:00:00'),
	(169,'68753500112184','8CF957200013DF9C','IGLESIA DEL MORMON',5,1,0,0,0,'0000-00-00 00:00:00'),
	(170,'68753500112256','8CF957200013D4FF','Calle',5,1,0,0,0,'0000-00-00 00:00:00'),
	(171,'68753500112094','8CF957200013D545','LAS QUINTAS 2195',5,1,0,0,0,'0000-00-00 00:00:00'),
	(172,'68753500112060','8CF957200013D5A1','RAMON Y CAJAL Nº: 8 ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(173,'68753500112054','8CF957200013E105','Calle',5,1,0,0,0,'0000-00-00 00:00:00'),
	(174,'68753500112119','8CF957200013D405','LA PILETA ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(175,'68753500112024','8CF957200013E0F7','SARMIENTO 640 - SOL PROTEC',5,1,0,0,0,'0000-00-00 00:00:00'),
	(176,'68753500112063','8CF957200013D5D9','CENTRO COMUN.- LUIS VERNET',5,1,0,0,0,'0000-00-00 00:00:00'),
	(177,'68753500112202','8CF957200013D1FD','HOTEL DEPORTIVO',5,1,0,0,0,'0000-00-00 00:00:00'),
	(178,'68753500112123','8CF957200013D459','ESC. SEC. V. DE OBLIGADO Y BERRUET',5,1,0,0,0,'0000-00-00 00:00:00'),
	(179,'68753500112264','8CF957200013DE82','LOS CALAFATES 496',5,1,0,0,0,'0000-00-00 00:00:00'),
	(180,'68753500112110','8CF957200013D5B7','RICARDO ROJAS 104',5,1,0,0,0,'0000-00-00 00:00:00'),
	(181,'68753500112170','8CF957200013D42F','ESCUELA Nº: 20',5,1,0,0,0,'0000-00-00 00:00:00'),
	(182,'68753500112160','8CF957200013D2AE','UNIDAD Nº 6 ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(183,'68753500112058','8CF957200013DE5B','SUPER FERIA -  DEPOSITO',5,1,0,0,0,'0000-00-00 00:00:00'),
	(184,'68753500112147','8CF957200013E10A','VIALIDAD PROV.- CALLE CASTELLI',5,1,0,0,0,'0000-00-00 00:00:00'),
	(185,'68753500112144','8CF957200013D526','ESC. ESPECIAL 504',5,1,0,0,0,'0000-00-00 00:00:00'),
	(186,'68753500112263','8CF957200013D1CE','ITALIA 1315 CENTRO DE SALUD',5,1,0,0,0,'0000-00-00 00:00:00'),
	(187,'68753500112224','8CF957200013DE7C','ESCUELA COMERCIO ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(188,'68753500112247','8CF957200013DEDF','Calle',5,1,0,0,0,'0000-00-00 00:00:00'),
	(189,'68753500112235','8CF957200013D785','HUDSON 566',5,1,0,0,0,'0000-00-00 00:00:00'),
	(190,'68753500112067','8CF957200013E0C7','ESCUELA Nº: 4 ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(191,'68753500112017','8CF957200013E014','Calle',5,1,0,0,0,'0000-00-00 00:00:00'),
	(192,'68753500112074','8CF957200013D559','UNIDAD Nº 6 ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(193,'68753500112162','8CF957200013D204','ESCUELA COMERCIO ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(194,'68753500112171','8CF957200013D1E8','LEGISLATURA ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(195,'68753500112071','8CF957200013D1E0','EST. DE SERVICIO YPF ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(196,'68753500112221','8CF957200013DFF4','BUEN PASTOR 228',5,1,0,0,0,'0000-00-00 00:00:00'),
	(197,'68753500112241','8CF957200013D73D','Calle',5,1,0,0,0,'0000-00-00 00:00:00'),
	(198,'68753500112167','8CF957200013D4D9','PLAZA GUEMES',5,1,0,0,0,'0000-00-00 00:00:00'),
	(199,'68753500112035','8CF957200013DFAF','CASA OFIC. Nº 17',5,1,0,0,0,'0000-00-00 00:00:00'),
	(200,'68753500112090','8CF957200013D2A2','SEROS - 9 DE JULIO ',5,1,0,0,0,'0000-00-00 00:00:00'),
	(201,'68753500112218','8CF957200013D1DE','Calle',5,1,0,0,0,'0000-00-00 00:00:00'),
	(202,'68753500112139','8CF957200013DDDB','Calle',5,1,0,0,0,'0000-00-00 00:00:00'),
	(203,'68753500112283','8CF957200013D1FF','AGUARAGUAZU  50 - COMPLEJO',5,1,0,0,0,'0000-00-00 00:00:00'),
	(204,'68753500112019','8CF957200013DE8B','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(205,'68753500112135','8CF957200013D2A3','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(206,'68753500112142','8CF957200013D580','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(207,'68753500112095','8CF957200013D9DB','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(208,'68753500112217','8CF957200013D4D0','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(209,'68753500112268','8CF957200013D4FD','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(210,'68753500112025','8CF957200013DDAF','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(211,'68753500112137','8CF957200013D51B','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(212,'68753500112118','8CF957200013D27D','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(213,'68753500112175','8CF957200013D2C6','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(214,'68753500112059','8CF957200013D4F3','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(215,'68753500112173','8CF957200013DE7A','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(216,'68753500112101','8CF957200013D797','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(217,'68753500112117','8CF957200013D38D','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(218,'68753500112127','8CF957200013D5AD','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(219,'68753500112243','8CF957200013D53C','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(220,'68753500112155','8CF957200013DE86','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(221,'68753500112274','8CF957200013D1F3','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(222,'68753500112267','8CF957200013D60B','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(223,'68753500112257','8CF957200013D9BF','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(224,'68753500112284','8CF957200013D4D2','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(225,'68753500112179','8CF957200013D42B','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(226,'68753500112077','8CF957200013DFAB','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(227,'68753500112140','8CF957200013D9E6','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(228,'68753500112212','8CF957200013DA20','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(229,'68753500112078','8CF957200013D401','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(230,'68753500112061','8CF957200013DDA6','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(231,'68753500112219','8CF957200013D77E','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(232,'68753500112102','8CF957200013D42D','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(233,'68753500112194','8CF957200013D59E','Calle',6,1,0,0,0,'0000-00-00 00:00:00'),
	(234,'68753500112079','8CF957200013DEDB','Sandra Agüero',7,1,0,0,0,'0000-00-00 00:00:00'),
	(235,'68753500112168','8CF957200013DA17','Comisaria (Casas Personal Atras)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(236,'68753500112156','8CF957200013B78D','Corralon Municipal (Casa Pepe)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(237,'68753500112047','8CF957200013DE99','Luis Lagos (Casa)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(238,'68753500112220','8CF957200013DF4E','Puerto Palos Hospedaje (Cardenas)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(239,'68753500112046','8CF957200013DDD4','Comisaria (Casa Comisario)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(240,'68753500112188','8CF957200013D45B','La Covacha (Debajo Cartel)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(241,'68753500112043','8CF957200013D3ED','Souter Spirit (Galpon)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(242,'68753500112189','8CF957200013D42E','Dario Bernal',7,1,0,0,0,'0000-00-00 00:00:00'),
	(243,'68753500112174','8CF957200013DF7A','Jovita Lagos / Maldonado',7,1,0,0,0,'0000-00-00 00:00:00'),
	(244,'68753500112050','8CF957200013D418','Botazzi (Local)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(245,'68753500112251','8CF957200013E011','Predio Trabajadores (General)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(246,'68753500112200','8CF957200013B581','Estancia del Sol (Hospedaje)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(247,'68753500112152','8CF957200013DDD8','Natalia Liendo',7,1,0,0,0,'0000-00-00 00:00:00'),
	(248,'68753500112040','8CF957200013E19D','Hydro Sport (Galpon)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(249,'68753500112164','8CF957200013D287','El Medano Hospedaje',7,1,0,0,0,'0000-00-00 00:00:00'),
	(250,'68753500112149','8CF957200013D2DF','Alicia Cora (Hospedaje)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(251,'68753500112238','8CF957200013D53D','Raises Hospedaje (Elis Marco)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(252,'68753500112211','8CF957200013DEDD','Omar Segul',7,1,0,0,0,'0000-00-00 00:00:00'),
	(253,'68753500112125','8CF957200013D5A5','Hugo Hernandez (Cotito)',7,1,0,0,0,'0000-00-00 00:00:00'),
	(254,'68753500112111','8CF957200013D79A','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(255,'68753500112186','8CF957200013D2B6','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(256,'68753500112055','8CF957200013D45E','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(257,'68753500112258','8CF957200013D283','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(258,'68753500112062','8CF957200013DED0','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(259,'68753500112087','8CF957200013E045','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(260,'68753500112215','8CF957200013D563','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(261,'68753500112222','8CF957200013D29A','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(262,'68753500112083','8CF957200013D720','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(263,'68753500112225','8CF957200013E0B5','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(264,'68753500112231','8CF957200013DD99','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(265,'68753500112254','8CF957200013DEAC','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(266,'68753500112234','8CF957200013D53F','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(267,'68753500112197','8CF957200013D9C1','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(268,'68753500112276','8CF957200013D41B','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(269,'68753500112082','8CF957200013D502','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(270,'68753500113340','8CF957200013D5D6','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(271,'68753500113341','8CF957200013D58B','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(272,'68753500113342','8CF957200013D2F0','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(273,'68753500113343','8CF957200013DF2F','Calle',8,1,0,0,0,'0000-00-00 00:00:00'),
	(274,'Medidor tester 1','0400e8eb1b53934b','Laboratorio',3,1,0,0,0,'0000-00-00 00:00:00'),
	(275,'Medidor Tester 2','0400e8eb1b538d6d','Laboratorio',1,1,0,0,0,'0000-00-00 00:00:00'),
	(276,'68753500049148','e0ede71605110126','Laboratorio',1,1,0,0,0,'0000-00-00 00:00:00');

/*!40000 ALTER TABLE `medidores` ENABLE KEYS */;
UNLOCK TABLES;


# Volcado de tabla modelos
# ------------------------------------------------------------

CREATE TABLE `modelos` (
  `idModelo` int(11) NOT NULL AUTO_INCREMENT,
  `marca` varchar(100) NOT NULL,
  `modelo` varchar(100) NOT NULL,
  PRIMARY KEY (`idModelo`),
  UNIQUE KEY `uk_modelo_marca` (`marca`,`modelo`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

LOCK TABLES `modelos` WRITE;
/*!40000 ALTER TABLE `modelos` DISABLE KEYS */;

INSERT INTO `modelos` (`idModelo`, `marca`, `modelo`)
VALUES
	(1,' ','Shengda');

/*!40000 ALTER TABLE `modelos` ENABLE KEYS */;
UNLOCK TABLES;


# Volcado de tabla organizaciones
# ------------------------------------------------------------

CREATE TABLE `organizaciones` (
  `idOrganizacion` int(11) NOT NULL AUTO_INCREMENT,
  `nombreOrganizacion` varchar(80) NOT NULL,
  `descripcion` text DEFAULT NULL,
  PRIMARY KEY (`idOrganizacion`),
  UNIQUE KEY `nombreOrganizacion` (`nombreOrganizacion`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

LOCK TABLES `organizaciones` WRITE;
/*!40000 ALTER TABLE `organizaciones` DISABLE KEYS */;

INSERT INTO `organizaciones` (`idOrganizacion`, `nombreOrganizacion`, `descripcion`)
VALUES
	(1,'Absolut',''),
	(2,'Madryn',''),
	(3,'Comodoro',''),
	(4,'Trelew',''),
	(5,'Rawson',''),
	(6,'Esquel',''),
	(7,'Piramide',''),
	(8,'Gaiman','');

/*!40000 ALTER TABLE `organizaciones` ENABLE KEYS */;
UNLOCK TABLES;


# Volcado de tabla tiempo_real
# ------------------------------------------------------------

CREATE TABLE `tiempo_real` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idMedidor` int(11) NOT NULL,
  `lastReporte` datetime NOT NULL,
  `estado` int(11) NOT NULL,
  `urlVideo` varchar(500) NOT NULL,
  `ip` varchar(80) NOT NULL,
  `latitud` double NOT NULL,
  `longitud` double NOT NULL,
  `acumulado` int(11) DEFAULT NULL,
  `diario` int(11) DEFAULT NULL,
  `rssi` int(11) DEFAULT NULL,
  `temperatura` double DEFAULT NULL,
  `cumulFlowUnit` double DEFAULT NULL,
  `dailyFlowUnit` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_idMedidor` (`idMedidor`),
  CONSTRAINT `tiempo_real_ibfk_1` FOREIGN KEY (`idMedidor`) REFERENCES `medidores` (`idMedidor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;




/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
