--
-- Host: localhost    Database: xc_data
-- ------------------------------------------------------


--
-- Table structure for table `xc_sites`
--

CREATE TABLE `xc_sites` (
  `STATION_ID` varchar(30) NOT NULL,
  `ENABLED` varchar(1) NOT NULL,
  `UNIT_ID` varchar(15) DEFAULT NULL,
  `SITE_TYPE` int(11) DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  `IPADDRESS` varchar(20) DEFAULT NULL,
  `RADIO_PATH_LIST` varchar(30) DEFAULT NULL,
  `PHONE_NUMBER_LIST` varchar(40) DEFAULT NULL,
  `PHONE_NUMBER2` varchar(20) DEFAULT NULL,
  `USER_NAME` varchar(10) DEFAULT NULL,
  `PASSWORD` varchar(10) DEFAULT NULL,
  `COMPORT_LIST` varchar(15) DEFAULT NULL,
  `ACKDELAY_LIST` varchar(10) DEFAULT NULL,
  `RESPONSE_TIMEOUT_LIST` varchar(10) DEFAULT NULL,
  `POLL_TYPE` int(11) DEFAULT NULL,
  `LOGIN_REQD` varchar(1) DEFAULT NULL,
  `QUICK_PROTOCOL` varchar(1) DEFAULT NULL,
  `AUTO_PROTOCOL` varchar(1) DEFAULT NULL,
  `CONCENTRATOR` varchar(1) DEFAULT NULL,
  `HOURS_AHEAD` double DEFAULT NULL,
  `RDI_BASE_TIME` datetime DEFAULT NULL,
  `RDI_INTERVAL` datetime DEFAULT NULL,
  `RDI_STAYON` datetime DEFAULT NULL,
  `TEMPLATE_NAME` varchar(50) DEFAULT NULL,
  `SITE_COMMENT` varchar(32) DEFAULT NULL,
  `SITE_LONG_NAME` varchar(50) DEFAULT NULL,
  `SITE_CODE` int(11) DEFAULT NULL,
  `USGS_ID` varchar(10) DEFAULT NULL,
  `INSTALLATION_DATE` datetime DEFAULT NULL,
  `AGENCY` varchar(32) DEFAULT NULL,
  `COUNTRY` varchar(32) DEFAULT NULL,
  `DISTRICT` varchar(32) DEFAULT NULL,
  `CITY` varchar(32) DEFAULT NULL,
  `STATE` varchar(20) DEFAULT NULL,
  `COUNTY` varchar(32) DEFAULT NULL,
  `RESERVOIR` varchar(32) DEFAULT NULL,
  `BASIN` varchar(32) DEFAULT NULL,
  `RIVER_MILE` double DEFAULT NULL,
  `LATITUDE` double DEFAULT NULL,
  `LONGITUDE` double DEFAULT NULL,
  `ELEVATION` double DEFAULT NULL,
  `COEFFICIENT1` double DEFAULT NULL,
  `COEFFICIENT2` double DEFAULT NULL,
  `COEFFICIENT3` double DEFAULT NULL,
  `WEIGHTING_FACTOR` double DEFAULT NULL,
  `SATELLITE_ID` varchar(8) DEFAULT NULL,
  `PRIMARY_CHANNEL` int(11) DEFAULT NULL,
  `RANDOM_CHANNEL` int(11) DEFAULT NULL,
  `REPORTING_TIME` datetime DEFAULT NULL,
  `REPORTING_INTERVAL` double DEFAULT NULL,
  `LAST_UPDATE` datetime DEFAULT NULL,
  `TZONE_CODE` varchar(4) DEFAULT NULL,
  `GMT_OFFSET` double DEFAULT NULL,
  `SHEF_ID` varchar(8) DEFAULT NULL,
  `ALTERNATE_CHAR_ID_1` varchar(10) DEFAULT NULL,
  `ALTERNATE_CHAR_ID_2` varchar(10) DEFAULT NULL,
  `GPSTRING1` varchar(20) DEFAULT NULL,
  `GPSTRING2` varchar(20) DEFAULT NULL,
  `GPNUMBER1` double DEFAULT NULL,
  `GPNUMBER2` double DEFAULT NULL,
  `SETUP_FILE_NAME` varchar(255) DEFAULT NULL,
  `LOG_FILE_NAME` varchar(255) DEFAULT NULL,
  `PICTURE_FILE_NAME` varchar(255) DEFAULT NULL,
  `MODEM_INIT_STRING` varchar(20) DEFAULT NULL,
  `MODEM_HANGUP_STRING` varchar(20) DEFAULT NULL,
  `LAST_POLL` datetime DEFAULT NULL,
  `TEMPLATE_FLAG` int(11) DEFAULT '1',
  `MBDEVICE_ID` varchar(4) DEFAULT NULL,
  `MBCONSEC_REGISTER` varchar(1) DEFAULT NULL,
  `MBBASE_REGISTER` int(11) DEFAULT NULL,
  `MBREGISTER_TYPE` int(11) DEFAULT NULL,
  `MBREGISTER_COUNT` int(11) DEFAULT NULL,
  `MSGPARITY` int(11) DEFAULT NULL,
  `IMEI_ID` varchar(15) DEFAULT NULL,
  `SMS_ID` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`STATION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `xc_sites`
--

INSERT INTO `xc_sites` VALUES ('AWS 1 PERNEM','Y','AWS 1 PERNEM',3,0,NULL,'AWS 1 PERNEM',NULL,NULL,NULL,NULL,'1003',NULL,NULL,0,'N','Y','Y','N',0,'1899-12-30 00:00:00','1899-12-30 00:00:00','1899-12-30 00:00:00',NULL,NULL,NULL,0,NULL,'1984-12-31 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,NULL,0,0,'1899-12-30 00:00:00',0,'2019-01-30 15:09:00',NULL,0,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'[default]',NULL,NULL,NULL,'2019-01-30 15:09:00',1,NULL,'N',1,0,0,1,NULL,'9607960771'),('AWS 2 OLD GOA','Y','AWS 2 OLD GOA',3,0,NULL,'AWS 2 OLD GOA',NULL,NULL,NULL,NULL,'1003',NULL,NULL,0,'N','Y','Y','N',0,'1899-12-30 00:00:00','1899-12-30 00:00:00','1899-12-30 00:00:00',NULL,NULL,NULL,0,NULL,'1984-12-31 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,NULL,0,0,'1899-12-30 00:00:00',0,'2019-01-30 15:09:00',NULL,0,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'[default]',NULL,NULL,NULL,'2019-01-30 15:09:00',1,NULL,'N',1,0,0,1,NULL,'9607960772'),('AWS 3 CODAR','Y','AWS 3 CODAR',3,0,NULL,'AWS 3 CODAR',NULL,NULL,NULL,NULL,'1003',NULL,NULL,0,'N','Y','Y','N',0,'1899-12-30 00:00:00','1899-12-30 00:00:00','1899-12-30 00:00:00',NULL,NULL,NULL,0,NULL,'1984-12-31 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,NULL,0,0,'1899-12-30 00:00:00',0,'2019-01-10 20:36:00',NULL,0,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'[default]',NULL,NULL,NULL,'2019-01-10 20:36:00',1,NULL,'N',1,0,0,1,NULL,'9607960773'),('AWS 4 KALAY','Y','AWS 4 KALAY',3,0,NULL,'AWS 4 KALAY',NULL,NULL,NULL,NULL,'1003',NULL,NULL,0,'N','Y','Y','N',0,'1899-12-30 00:00:00','1899-12-30 00:00:00','1899-12-30 00:00:00',NULL,NULL,NULL,0,NULL,'1984-12-31 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,NULL,0,0,'1899-12-30 00:00:00',0,'2019-01-30 15:09:00',NULL,0,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'[default]',NULL,NULL,NULL,'2019-01-30 15:09:00',1,NULL,'N',1,0,0,1,NULL,'9607960774'),('AWS 5 SULCORNA','Y','AWS 5 SULCORNA',3,0,NULL,'AWS 5 SULCORNA',NULL,NULL,NULL,NULL,'1003',NULL,NULL,0,'N','Y','Y','N',0,'1899-12-30 00:00:00','1899-12-30 00:00:00','1899-12-30 00:00:00',NULL,NULL,NULL,0,NULL,'1984-12-31 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,NULL,0,0,'1899-12-30 00:00:00',0,'2018-12-01 16:27:00',NULL,0,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'[default]',NULL,NULL,NULL,'2018-12-01 16:27:00',1,NULL,'N',1,0,0,1,NULL,'9607960775'),('AWS 6 MARGAO','Y','AWS 6 MARGAO',3,0,NULL,'AWS 6 MARGAO',NULL,NULL,NULL,NULL,'1003',NULL,NULL,0,'N','Y','Y','N',0,'1899-12-30 00:00:00','1899-12-30 00:00:00','1899-12-30 00:00:00',NULL,NULL,NULL,0,NULL,'1984-12-31 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,NULL,0,0,'1899-12-30 00:00:00',0,'2019-01-30 15:09:00',NULL,0,NULL,NULL,NULL,NULL,NULL,0,0,NULL,'[default]',NULL,NULL,NULL,'2019-01-30 15:09:00',1,NULL,'N',1,0,0,1,NULL,'9607960776');


