-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: localhost    Database: xc_data
-- ------------------------------------------------------
-- Server version	5.7.24-log

/*!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 */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `xc_lastvalues`
--

DROP TABLE IF EXISTS `xc_lastvalues`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xc_lastvalues` (
  `STATION_ID` varchar(30) NOT NULL,
  `SENSORNAME` varchar(15) NOT NULL,
  `TIME_TAG` datetime NOT NULL,
  `IS_TEXT` varchar(7) DEFAULT NULL,
  `NUM_VALUE` double DEFAULT NULL,
  `TEXT_VALUE` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`STATION_ID`,`SENSORNAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xc_lastvalues`
--

LOCK TABLES `xc_lastvalues` WRITE;
/*!40000 ALTER TABLE `xc_lastvalues` DISABLE KEYS */;
INSERT INTO `xc_lastvalues` VALUES ('AWS 1 PERNEM','AT','2019-01-30 15:09:00','N',33.3,NULL),('AWS 1 PERNEM','ATAVG','2019-01-30 15:00:00','N',34,NULL),('AWS 1 PERNEM','ATMAX','2019-01-30 15:00:00','N',34.6,NULL),('AWS 1 PERNEM','ATMIN','2019-01-30 15:00:00','N',33.2,NULL),('AWS 1 PERNEM','BATT','2019-01-30 15:00:00','N',13.4,NULL),('AWS 1 PERNEM','BEC20','2019-01-30 15:09:00','N',0,NULL),('AWS 1 PERNEM','BEC5','2019-01-30 15:09:00','N',0,NULL),('AWS 1 PERNEM','BEC50','2019-01-30 15:09:00','N',0,NULL),('AWS 1 PERNEM','RAIN','2019-01-30 15:09:00','N',0,NULL),('AWS 1 PERNEM','RH','2019-01-30 15:09:00','N',31,NULL),('AWS 1 PERNEM','SM20','2019-01-30 15:09:00','N',9.3,NULL),('AWS 1 PERNEM','SM5','2019-01-30 15:09:00','N',9.2,NULL),('AWS 1 PERNEM','SM50','2019-01-30 15:09:00','N',6.1,NULL),('AWS 1 PERNEM','SRAD','2019-01-30 15:09:00','N',390,NULL),('AWS 1 PERNEM','ST20','2019-01-30 15:09:00','N',26.7,NULL),('AWS 1 PERNEM','ST5','2019-01-30 15:09:00','N',26.7,NULL),('AWS 1 PERNEM','ST50','2019-01-30 15:09:00','N',26.7,NULL),('AWS 1 PERNEM','SUNDUR','2019-01-30 00:00:00','N',8,NULL),('AWS 1 PERNEM','WD','2019-01-30 15:09:00','N',307,NULL),('AWS 1 PERNEM','WDVA','2019-01-30 15:00:00','N',216,NULL),('AWS 1 PERNEM','WS','2019-01-30 15:09:00','N',0.8,NULL),('AWS 1 PERNEM','WSMAX','2019-01-30 15:00:00','N',1.6,NULL),('AWS 1 PERNEM','WSMIN','2019-01-30 15:00:00','N',0,NULL),('AWS 1 PERNEM','WSVA','2019-01-30 15:00:00','N',0,NULL),('AWS 2 OLD GOA','AT','2019-01-30 15:09:00','N',32.8,NULL),('AWS 2 OLD GOA','ATAVG','2019-01-30 15:00:00','N',32.8,NULL),('AWS 2 OLD GOA','ATMAX','2019-01-30 15:00:00','N',33.3,NULL),('AWS 2 OLD GOA','ATMIN','2019-01-30 15:00:00','N',32.5,NULL),('AWS 2 OLD GOA','BATT','2019-01-30 15:00:00','N',13.8,NULL),('AWS 2 OLD GOA','BEC20','2018-12-15 08:18:00','N',0,NULL),('AWS 2 OLD GOA','BEC5','2018-12-10 11:03:00','N',0,NULL),('AWS 2 OLD GOA','BEC50','2019-01-30 15:09:00','N',0,NULL),('AWS 2 OLD GOA','RAIN','2019-01-30 15:09:00','N',0,NULL),('AWS 2 OLD GOA','RH','2019-01-30 15:09:00','N',32,NULL),('AWS 2 OLD GOA','SM20','2018-12-15 08:18:00','N',0.1,NULL),('AWS 2 OLD GOA','SM5','2018-12-10 11:03:00','N',0.1,NULL),('AWS 2 OLD GOA','SM50','2019-01-30 15:09:00','N',5.1,NULL),('AWS 2 OLD GOA','SRAD','2019-01-30 15:09:00','N',390,NULL),('AWS 2 OLD GOA','ST20','2018-12-15 08:18:00','N',29.2,NULL),('AWS 2 OLD GOA','ST5','2018-12-10 11:03:00','N',28.6,NULL),('AWS 2 OLD GOA','ST50','2019-01-30 15:09:00','N',28.9,NULL),('AWS 2 OLD GOA','SUNDUR','2019-01-30 00:00:00','N',4,NULL),('AWS 2 OLD GOA','WD','2019-01-30 15:09:00','N',348,NULL),('AWS 2 OLD GOA','WDVA','2019-01-30 15:00:00','N',131,NULL),('AWS 2 OLD GOA','WS','2019-01-30 15:09:00','N',1.6,NULL),('AWS 2 OLD GOA','WSMAX','2019-01-30 15:00:00','N',5.2,NULL),('AWS 2 OLD GOA','WSMIN','2019-01-30 15:00:00','N',0,NULL),('AWS 2 OLD GOA','WSVA','2019-01-30 15:00:00','N',1,NULL),('AWS 3 CODAR','AT','2019-01-10 20:36:00','N',19.3,NULL),('AWS 3 CODAR','ATAVG','2019-01-10 20:00:00','N',21.4,NULL),('AWS 3 CODAR','ATMAX','2019-01-10 20:00:00','N',22.9,NULL),('AWS 3 CODAR','ATMIN','2019-01-10 20:00:00','N',20,NULL),('AWS 3 CODAR','BATT','2019-01-10 20:00:00','N',13.1,NULL),('AWS 3 CODAR','BEC20','2019-01-10 20:36:00','N',0,NULL),('AWS 3 CODAR','BEC5','2019-01-10 20:36:00','N',0,NULL),('AWS 3 CODAR','BEC50','2019-01-10 20:36:00','N',0,NULL),('AWS 3 CODAR','RAIN','2019-01-10 20:36:00','N',0,NULL),('AWS 3 CODAR','RH','2019-01-10 20:33:00','N',88,NULL),('AWS 3 CODAR','SM20','2019-01-10 20:36:00','N',10,NULL),('AWS 3 CODAR','SM5','2019-01-10 20:36:00','N',9.7,NULL),('AWS 3 CODAR','SM50','2019-01-10 20:36:00','N',13,NULL),('AWS 3 CODAR','SRAD','2019-01-10 20:36:00','N',0,NULL),('AWS 3 CODAR','ST20','2019-01-10 20:36:00','N',27.2,NULL),('AWS 3 CODAR','ST5','2019-01-10 20:36:00','N',28,NULL),('AWS 3 CODAR','ST50','2019-01-10 20:36:00','N',27.8,NULL),('AWS 3 CODAR','SUNDUR','2019-01-10 00:00:00','N',9,NULL),('AWS 3 CODAR','WD','2019-01-10 20:36:00','N',181,NULL),('AWS 3 CODAR','WDVA','2019-01-10 20:00:00','N',166,NULL),('AWS 3 CODAR','WS','2019-01-10 20:36:00','N',1,NULL),('AWS 3 CODAR','WSMAX','2019-01-10 20:00:00','N',1.1,NULL),('AWS 3 CODAR','WSMIN','2019-01-10 20:00:00','N',0,NULL),('AWS 3 CODAR','WSVA','2019-01-10 20:00:00','N',0.3,NULL),('AWS 4 KALAY','AT','2019-01-30 15:09:00','N',34.1,NULL),('AWS 4 KALAY','ATAVG','2019-01-30 15:00:00','N',33.7,NULL),('AWS 4 KALAY','ATMAX','2019-01-30 15:00:00','N',34.4,NULL),('AWS 4 KALAY','ATMIN','2019-01-30 15:00:00','N',33.1,NULL),('AWS 4 KALAY','BATT','2019-01-30 15:00:00','N',13.6,NULL),('AWS 4 KALAY','BEC20','2019-01-30 15:09:00','N',0,NULL),('AWS 4 KALAY','BEC5','2019-01-30 15:09:00','N',0,NULL),('AWS 4 KALAY','BEC50','2019-01-30 15:09:00','N',0,NULL),('AWS 4 KALAY','RAIN','2019-01-30 15:09:00','N',0,NULL),('AWS 4 KALAY','RH','2019-01-30 15:09:00','N',34,NULL),('AWS 4 KALAY','SM20','2019-01-30 15:09:00','N',0,NULL),('AWS 4 KALAY','SM5','2019-01-30 15:09:00','N',0,NULL),('AWS 4 KALAY','SM50','2019-01-30 15:09:00','N',0,NULL),('AWS 4 KALAY','SRAD','2019-01-30 15:09:00','N',390,NULL),('AWS 4 KALAY','ST20','2019-01-30 15:09:00','N',26.9,NULL),('AWS 4 KALAY','ST5','2019-01-30 15:09:00','N',27.5,NULL),('AWS 4 KALAY','ST50','2019-01-30 15:09:00','N',27.2,NULL),('AWS 4 KALAY','SUNDUR','2019-01-30 00:00:00','N',1,NULL),('AWS 4 KALAY','WD','2019-01-30 15:09:00','N',173,NULL),('AWS 4 KALAY','WDVA','2019-01-30 15:00:00','N',86,NULL),('AWS 4 KALAY','WS','2019-01-30 15:09:00','N',0.7,NULL),('AWS 4 KALAY','WSMAX','2019-01-30 15:00:00','N',2.2,NULL),('AWS 4 KALAY','WSMIN','2019-01-30 15:00:00','N',0,NULL),('AWS 4 KALAY','WSVA','2019-01-30 15:00:00','N',0.4,NULL),('AWS 5 SULCORNA','AT','2018-12-01 16:27:00','N',30.2,NULL),('AWS 5 SULCORNA','ATAVG','2018-12-01 15:00:00','N',32.4,NULL),('AWS 5 SULCORNA','ATMAX','2018-12-01 15:00:00','N',32.8,NULL),('AWS 5 SULCORNA','ATMIN','2018-12-01 15:00:00','N',31.9,NULL),('AWS 5 SULCORNA','BATT','2018-12-01 16:00:00','N',13.4,NULL),('AWS 5 SULCORNA','BEC20','2018-12-01 16:27:00','N',0,NULL),('AWS 5 SULCORNA','BEC5','2018-12-01 16:24:00','N',0,NULL),('AWS 5 SULCORNA','BEC50','2018-12-01 16:27:00','N',0,NULL),('AWS 5 SULCORNA','RAIN','2018-12-01 16:27:00','N',0,NULL),('AWS 5 SULCORNA','RH','2018-12-01 16:27:00','N',62,NULL),('AWS 5 SULCORNA','SM20','2018-12-01 16:27:00','N',0.1,NULL),('AWS 5 SULCORNA','SM5','2018-12-01 16:27:00','N',0.1,NULL),('AWS 5 SULCORNA','SM50','2018-12-01 16:27:00','N',0.2,NULL),('AWS 5 SULCORNA','SRAD','2018-12-01 16:27:00','N',246,NULL),('AWS 5 SULCORNA','ST20','2018-12-01 16:27:00','N',26.7,NULL),('AWS 5 SULCORNA','ST5','2018-12-01 16:27:00','N',27.8,NULL),('AWS 5 SULCORNA','ST50','2018-12-01 16:27:00','N',27.2,NULL),('AWS 5 SULCORNA','WD','2018-12-01 16:27:00','N',132,NULL),('AWS 5 SULCORNA','WDVA','2018-12-01 15:00:00','N',87,NULL),('AWS 5 SULCORNA','WS','2018-12-01 16:27:00','N',0.6,NULL),('AWS 5 SULCORNA','WSMAX','2018-12-01 15:00:00','N',2.6,NULL),('AWS 5 SULCORNA','WSMIN','2018-12-01 15:00:00','N',0.4,NULL),('AWS 5 SULCORNA','WSVA','2018-12-01 15:00:00','N',1,NULL),('AWS 6 MARGAO','AT','2019-01-30 15:09:00','N',32.5,NULL),('AWS 6 MARGAO','ATAVG','2019-01-30 15:00:00','N',34,NULL),('AWS 6 MARGAO','ATMAX','2019-01-30 15:00:00','N',35,NULL),('AWS 6 MARGAO','ATMIN','2019-01-30 15:00:00','N',33.4,NULL),('AWS 6 MARGAO','BATT','2019-01-30 15:00:00','N',13.6,NULL),('AWS 6 MARGAO','BEC20','2019-01-30 15:09:00','N',0,NULL),('AWS 6 MARGAO','BEC5','2019-01-30 15:09:00','N',0,NULL),('AWS 6 MARGAO','BEC50','2019-01-30 15:09:00','N',0,NULL),('AWS 6 MARGAO','RAIN','2019-01-30 15:09:00','N',0,NULL),('AWS 6 MARGAO','RH','2019-01-30 15:09:00','N',45,NULL),('AWS 6 MARGAO','SM20','2019-01-30 15:09:00','N',1.1,NULL),('AWS 6 MARGAO','SM5','2019-01-30 15:09:00','N',1.3,NULL),('AWS 6 MARGAO','SM50','2019-01-30 15:09:00','N',3,NULL),('AWS 6 MARGAO','SRAD','2019-01-30 15:09:00','N',390,NULL),('AWS 6 MARGAO','ST20','2019-01-30 15:09:00','N',28.9,NULL),('AWS 6 MARGAO','ST5','2019-01-30 15:09:00','N',32.1,NULL),('AWS 6 MARGAO','ST50','2019-01-30 15:09:00','N',29.5,NULL),('AWS 6 MARGAO','SUNDUR','2018-12-02 00:00:00','N',9,NULL),('AWS 6 MARGAO','WD','2019-01-30 15:09:00','N',269,NULL),('AWS 6 MARGAO','WDVA','2019-01-30 15:00:00','N',149,NULL),('AWS 6 MARGAO','WS','2019-01-30 15:09:00','N',0.7,NULL),('AWS 6 MARGAO','WSMAX','2019-01-30 15:00:00','N',3,NULL),('AWS 6 MARGAO','WSMIN','2019-01-30 15:00:00','N',0,NULL),('AWS 6 MARGAO','WSVA','2019-01-30 15:00:00','N',0.5,NULL);
/*!40000 ALTER TABLE `xc_lastvalues` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2019-01-30 16:30:40
