[1, 21:40:14] CREATE DATABASE xc_data: Running... [1, 21:40:14] CREATE DATABASE xc_data: 1 row(s) affected [2, 21:40:40] CREATE DATABASE xc_data: Running... [2, 21:40:40] CREATE DATABASE xc_data: Error Code: 1007. Can't create database 'xc_data'; database exists [1, 21:40:56] CREATE DATABASE xc_data: Running... [1, 21:40:56] CREATE DATABASE xc_data: Error Code: 1007. Can't create database 'xc_data'; database exists [1, 21:44:59] USE XC_DATA: Running... [1, 21:44:59] USE XC_DATA: 0 row(s) affected [2, 21:44:59] CREATE TABLE XC_SITES ( STATION_ID VARCHAR(30) NOT NULL , ENABLED VARCHAR(1) NOT NULL , UNIT_ID VARCHAR(15) , SITE_TYPE INT , STATUS INT , IPADDRESS VARCHAR(20) , RADIO_PATH_LIST VARCHAR(30) , PHONE_NUMBER_LIST VARCHAR(40) , PHONE_NUMBER2 VARCHAR(20) , USER_NAME VARCHAR(10) , PASSWORD VARCHAR(10) , COMPORT_LIST VARCHAR(15) , ACKDELAY_LIST VARCHAR(10) , RESPONSE_TIMEOUT_LIST VARCHAR(10) , POLL_TYPE INT , LOGIN_REQD VARCHAR(1) , QUICK_PROTOCOL VARCHAR(1) , AUTO_PROTOCOL VARCHAR(1) , CONCENTRATOR VARCHAR(1) , HOURS_AHEAD DOUBLE , RDI_BASE_TIME DATETIME , RDI_INTERVAL DATETIME , RDI_STAYON DATETIME , TEMPLATE_NAME VARCHAR(50) , SITE_COMMENT VARCHAR(32) , SITE_LONG_NAME VARCHAR(50) , SITE_CODE INTEGER , USGS_ID VARCHAR(10) , INSTALLATION_DATE DATETIME , AGENCY VARCHAR(32) , COUNTRY VARCHAR(32) , DISTRICT VARCHAR(32) , CITY VARCHAR(32) , STATE VARCHAR(20) , COUNTY VARCHAR(32) , RESERVOIR VARCHAR(32) , BASIN VARCHAR(32) , RIVER_MILE DOUBLE , LATITUDE DOUBLE , LONGITUDE DOUBLE , ELEVATION DOUBLE , COEFFICIENT1 DOUBLE , COEFFICIENT2 DOUBLE , COEFFICIENT3 DOUBLE , WEIGHTING_FACTOR DOUBLE , SATELLITE_ID VARCHAR(8) , PRIMARY_CHANNEL INT , RANDOM_CHANNEL INT , REPORTING_TIME DATETIME , REPORTING_INTERVAL DOUBLE , LAST_UPDATE DATETIME , TZONE_CODE VARCHAR(4) , GMT_OFFSET DOUBLE , SHEF_ID VARCHAR(8) , ALTERNATE_CHAR_ID_1 VARCHAR(10) , ALTERNATE_CHAR_ID_2 VARCHAR(10) , GPSTRING1 VARCHAR(20) , GPSTRING2 VARCHAR(20) , GPNUMBER1 DOUBLE , GPNUMBER2 DOUBLE , SETUP_FILE_NAME VARCHAR(255) , LOG_FILE_NAME VARCHAR(255) , PICTURE_FILE_NAME VARCHAR(255) , MODEM_INIT_STRING VARCHAR(20) , MODEM_HANGUP_STRING VARCHAR(20) , LAST_POLL DATETIME , TEMPLATE_FLAG INT NULL DEFAULT 1, MBDEVICE_ID VARCHAR(4) , MBCONSEC_REGISTER VARCHAR(1) , MBBASE_REGISTER INT , MBREGISTER_TYPE INT , MBREGISTER_COUNT INT , MSGPARITY INT , IMEI_ID VARCHAR(15) , SMS_ID VARCHAR(15) , CONSTRAINT STE_PK PRIMARY KEY(STATION_ID) ): Running... [2, 21:45:00] CREATE TABLE XC_SITES ( STATION_ID VARCHAR(30) NOT NULL , ENABLED VARCHAR(1) NOT NULL , UNIT_ID VARCHAR(15) , SITE_TYPE INT , STATUS INT , IPADDRESS VARCHAR(20) , RADIO_PATH_LIST VARCHAR(30) , PHONE_NUMBER_LIST VARCHAR(40) , PHONE_NUMBER2 VARCHAR(20) , USER_NAME VARCHAR(10) , PASSWORD VARCHAR(10) , COMPORT_LIST VARCHAR(15) , ACKDELAY_LIST VARCHAR(10) , RESPONSE_TIMEOUT_LIST VARCHAR(10) , POLL_TYPE INT , LOGIN_REQD VARCHAR(1) , QUICK_PROTOCOL VARCHAR(1) , AUTO_PROTOCOL VARCHAR(1) , CONCENTRATOR VARCHAR(1) , HOURS_AHEAD DOUBLE , RDI_BASE_TIME DATETIME , RDI_INTERVAL DATETIME , RDI_STAYON DATETIME , TEMPLATE_NAME VARCHAR(50) , SITE_COMMENT VARCHAR(32) , SITE_LONG_NAME VARCHAR(50) , SITE_CODE INTEGER , USGS_ID VARCHAR(10) , INSTALLATION_DATE DATETIME , AGENCY VARCHAR(32) , COUNTRY VARCHAR(32) , DISTRICT VARCHAR(32) , CITY VARCHAR(32) , STATE VARCHAR(20) , COUNTY VARCHAR(32) , RESERVOIR VARCHAR(32) , BASIN VARCHAR(32) , RIVER_MILE DOUBLE , LATITUDE DOUBLE , LONGITUDE DOUBLE , ELEVATION DOUBLE , COEFFICIENT1 DOUBLE , COEFFICIENT2 DOUBLE , COEFFICIENT3 DOUBLE , WEIGHTING_FACTOR DOUBLE , SATELLITE_ID VARCHAR(8) , PRIMARY_CHANNEL INT , RANDOM_CHANNEL INT , REPORTING_TIME DATETIME , REPORTING_INTERVAL DOUBLE , LAST_UPDATE DATETIME , TZONE_CODE VARCHAR(4) , GMT_OFFSET DOUBLE , SHEF_ID VARCHAR(8) , ALTERNATE_CHAR_ID_1 VARCHAR(10) , ALTERNATE_CHAR_ID_2 VARCHAR(10) , GPSTRING1 VARCHAR(20) , GPSTRING2 VARCHAR(20) , GPNUMBER1 DOUBLE , GPNUMBER2 DOUBLE , SETUP_FILE_NAME VARCHAR(255) , LOG_FILE_NAME VARCHAR(255) , PICTURE_FILE_NAME VARCHAR(255) , MODEM_INIT_STRING VARCHAR(20) , MODEM_HANGUP_STRING VARCHAR(20) , LAST_POLL DATETIME , TEMPLATE_FLAG INT NULL DEFAULT 1, MBDEVICE_ID VARCHAR(4) , MBCONSEC_REGISTER VARCHAR(1) , MBBASE_REGISTER INT , MBREGISTER_TYPE INT , MBREGISTER_COUNT INT , MSGPARITY INT , IMEI_ID VARCHAR(15) , SMS_ID VARCHAR(15) , CONSTRAINT STE_PK PRIMARY KEY(STATION_ID) ): 0 row(s) affected [3, 21:45:00] CREATE TABLE XC_SITESENSORS ( STE_STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , ENABLED VARCHAR(1) NOT NULL , DATA_TABLE VARCHAR(12) NOT NULL , TAGNAME VARCHAR(15) , RAWLIST VARCHAR(30) , RIGHT_DIGIT INT , LEFT_DIGIT INT , IS_TEXT VARCHAR(7) , ROUNDOFF_TIME INT , DATA_STORE_INTERVAL INT , UNITS VARCHAR(10) , TEMPLATE_NAME VARCHAR(50) , STATUS INT , DESCRIPTION VARCHAR(32) , MANUFACTURER VARCHAR(20) , MODEL_NUMBER VARCHAR(20) , SHEF_PE_CODE VARCHAR(7) , PARAMETER_CODE VARCHAR(12) , ALT_PARAMETER_CODE_1 VARCHAR(12) , ALT_PARAMETER_CODE_2 VARCHAR(12) , EQUATION VARCHAR(128) , RATING_TABLE VARCHAR(128) , OFFSET DOUBLE , SHIFT DOUBLE , HIGH_HIGH_LIMIT DOUBLE , HIGH_HIGH_ALARM INT , HIGH_LIMIT DOUBLE , HIGH_ALARM INT , LOW_LIMIT DOUBLE , LOW_ALARM INT , LOW_LOW_LIMIT DOUBLE , LOW_LOW_ALARM INT , ROC_LIMIT DOUBLE , ROC_ALARM INT , ROC_INTERVAL DOUBLE , DEADBAND DOUBLE , NO_CHANGE_INTERVAL DOUBLE , NO_CHANGE_ALARM INT , TEXT_LIMIT VARCHAR(9) , TEXT_ALARM INT , STD_DEV_LIMIT DOUBLE , STD_DEV_ALARM INT , STD_DEV_INTERVAL DOUBLE , AVG_LIMIT DOUBLE , AVG_ALARM INT , AVG_INTERVAL DOUBLE , GPNUMBER1 DOUBLE , GPNUMBER2 DOUBLE , GPSTRING1 VARCHAR(20) , GPSTRING2 VARCHAR(20) , ALERT_ID DOUBLE , ALERT_TYPE VARCHAR(10) , COEFFICIENT1 DOUBLE , COEFFICIENT2 DOUBLE , COEFFICIENT3 DOUBLE , COEFFICIENT4 DOUBLE , COEFFICIENT5 DOUBLE , REFERENCE_1 DOUBLE , REFERENCE_2 DOUBLE , DATA_EXCH_NUM VARCHAR(100) , MIKE11_LABEL_1 VARCHAR(50) , MIKE11_LABEL_2 VARCHAR(50) , NO_ALARM_INTERVAL DOUBLE , MBBASE_REGISTER INT , MBREGISTER_TYPE INT , MBTAG_TYPE INT , MBMSW INT , USE_REJECT_LOW VARCHAR(1) , REJECT_LOW_LIMIT DOUBLE , USE_REJECT_HIGH VARCHAR(1) , REJECT_HIGH_LIMIT DOUBLE , CONSTRAINT SITSEN_PK PRIMARY KEY (SENSORNAME,STE_STATION_ID), CONSTRAINT SITSEN_STE_FK FOREIGN KEY (STE_STATION_ID) REFERENCES XC_SITES (STATION_ID) ): Running... [3, 21:45:02] CREATE TABLE XC_SITESENSORS ( STE_STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , ENABLED VARCHAR(1) NOT NULL , DATA_TABLE VARCHAR(12) NOT NULL , TAGNAME VARCHAR(15) , RAWLIST VARCHAR(30) , RIGHT_DIGIT INT , LEFT_DIGIT INT , IS_TEXT VARCHAR(7) , ROUNDOFF_TIME INT , DATA_STORE_INTERVAL INT , UNITS VARCHAR(10) , TEMPLATE_NAME VARCHAR(50) , STATUS INT , DESCRIPTION VARCHAR(32) , MANUFACTURER VARCHAR(20) , MODEL_NUMBER VARCHAR(20) , SHEF_PE_CODE VARCHAR(7) , PARAMETER_CODE VARCHAR(12) , ALT_PARAMETER_CODE_1 VARCHAR(12) , ALT_PARAMETER_CODE_2 VARCHAR(12) , EQUATION VARCHAR(128) , RATING_TABLE VARCHAR(128) , OFFSET DOUBLE , SHIFT DOUBLE , HIGH_HIGH_LIMIT DOUBLE , HIGH_HIGH_ALARM INT , HIGH_LIMIT DOUBLE , HIGH_ALARM INT , LOW_LIMIT DOUBLE , LOW_ALARM INT , LOW_LOW_LIMIT DOUBLE , LOW_LOW_ALARM INT , ROC_LIMIT DOUBLE , ROC_ALARM INT , ROC_INTERVAL DOUBLE , DEADBAND DOUBLE , NO_CHANGE_INTERVAL DOUBLE , NO_CHANGE_ALARM INT , TEXT_LIMIT VARCHAR(9) , TEXT_ALARM INT , STD_DEV_LIMIT DOUBLE , STD_DEV_ALARM INT , STD_DEV_INTERVAL DOUBLE , AVG_LIMIT DOUBLE , AVG_ALARM INT , AVG_INTERVAL DOUBLE , GPNUMBER1 DOUBLE , GPNUMBER2 DOUBLE , GPSTRING1 VARCHAR(20) , GPSTRING2 VARCHAR(20) , ALERT_ID DOUBLE , ALERT_TYPE VARCHAR(10) , COEFFICIENT1 DOUBLE , COEFFICIENT2 DOUBLE , COEFFICIENT3 DOUBLE , COEFFICIENT4 DOUBLE , COEFFICIENT5 DOUBLE , REFERENCE_1 DOUBLE , REFERENCE_2 DOUBLE , DATA_EXCH_NUM VARCHAR(100) , MIKE11_LABEL_1 VARCHAR(50) , MIKE11_LABEL_2 VARCHAR(50) , NO_ALARM_INTERVAL DOUBLE , MBBASE_REGISTER INT , MBREGISTER_TYPE INT , MBTAG_TYPE INT , MBMSW INT , USE_REJECT_LOW VARCHAR(1) , REJECT_LOW_LIMIT DOUBLE , USE_REJECT_HIGH VARCHAR(1) , REJECT_HIGH_LIMIT DOUBLE , CONSTRAINT SITSEN_PK PRIMARY KEY (SENSORNAME,STE_STATION_ID), CONSTRAINT SITSEN_STE_FK FOREIGN KEY (STE_STATION_ID) REFERENCES XC_SITES (STATION_ID) ): 0 row(s) affected [4, 21:45:02] CREATE TABLE XC_DATA1 ( STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , ORIG_VALUE DOUBLE NOT NULL , ED_VALUE DOUBLE , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , FLAG4 VARCHAR(1) , HIGH_HIGH_FLAG INT , HIGH_FLAG INT , LOW_FLAG INT , LOW_LOW_FLAG INT , ROC_FLAG INT , NO_CHG_FLAG INT , ALARM_FLAG INT , STD_DEV_FLAG INT , AVG_FLAG INT , CONSTRAINT DAT1_PK PRIMARY KEY ( TIME_TAG , SOURCE , STATION_ID, SENSORNAME ) ): Running... [4, 21:45:02] CREATE TABLE XC_DATA1 ( STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , ORIG_VALUE DOUBLE NOT NULL , ED_VALUE DOUBLE , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , FLAG4 VARCHAR(1) , HIGH_HIGH_FLAG INT , HIGH_FLAG INT , LOW_FLAG INT , LOW_LOW_FLAG INT , ROC_FLAG INT , NO_CHG_FLAG INT , ALARM_FLAG INT , STD_DEV_FLAG INT , AVG_FLAG INT , CONSTRAINT DAT1_PK PRIMARY KEY ( TIME_TAG , SOURCE , STATION_ID, SENSORNAME ) ): 0 row(s) affected [5, 21:45:02] CREATE TABLE XC_TXTDATA1 ( STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , TEXT_VALUE VARCHAR(255) NOT NULL , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , FLAG4 VARCHAR(1) , MESSAGE_STATUS VARCHAR(2) , TXT_ALARM_FLAG INT , CONSTRAINT TXD1_PK PRIMARY KEY (TIME_TAG ,SOURCE ,STATION_ID ,SENSORNAME) ): Running... [5, 21:45:03] CREATE TABLE XC_TXTDATA1 ( STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , TEXT_VALUE VARCHAR(255) NOT NULL , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , FLAG4 VARCHAR(1) , MESSAGE_STATUS VARCHAR(2) , TXT_ALARM_FLAG INT , CONSTRAINT TXD1_PK PRIMARY KEY (TIME_TAG ,SOURCE ,STATION_ID ,SENSORNAME) ): 0 row(s) affected [6, 21:45:03] CREATE TABLE XC_GOESQC ( NESDIS_ID VARCHAR(8) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , STATION_ID VARCHAR(30) , FAILURE_CODE VARCHAR(1) , SIG_STRENGTH DOUBLE , FREQ_OFFSET DOUBLE , MOD_INDEX VARCHAR(1) , MOD_QUAL VARCHAR(1) , CHANNEL INT , SAT_LOC VARCHAR(1) , UC_STATUS VARCHAR(2) , MESSAGE_LEN INT , ACTUAL_LEN INT , PARITY INT , BUFFER_EMPTY INT , BATTERY_VOLTAGE DOUBLE , SPARE1 DOUBLE , SPARE2 DOUBLE , CONSTRAINT GOESQC_PK PRIMARY KEY (NESDIS_ID ,TIME_TAG ,SOURCE) ): Running... [6, 21:45:04] CREATE TABLE XC_GOESQC ( NESDIS_ID VARCHAR(8) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , STATION_ID VARCHAR(30) , FAILURE_CODE VARCHAR(1) , SIG_STRENGTH DOUBLE , FREQ_OFFSET DOUBLE , MOD_INDEX VARCHAR(1) , MOD_QUAL VARCHAR(1) , CHANNEL INT , SAT_LOC VARCHAR(1) , UC_STATUS VARCHAR(2) , MESSAGE_LEN INT , ACTUAL_LEN INT , PARITY INT , BUFFER_EMPTY INT , BATTERY_VOLTAGE DOUBLE , SPARE1 DOUBLE , SPARE2 DOUBLE , CONSTRAINT GOESQC_PK PRIMARY KEY (NESDIS_ID ,TIME_TAG ,SOURCE) ): 0 row(s) affected [7, 21:45:04] CREATE TABLE XC_RTUQC ( STATION_ID VARCHAR(30) NOT NULL , TIME_TAG DATETIME NOT NULL , RX_TX VARCHAR(1) NOT NULL , PORT VARCHAR(30) , SEQUENCENUM DOUBLE , OPCODE DOUBLE , STATUS INT , RETRIES INT , GOOD INT , BAD INT , CRC INT , BATTERY_VOLTAGE DOUBLE , SPARE1 DOUBLE , SPARE2 DOUBLE , CONSTRAINT RTU_PK PRIMARY KEY ( STATION_ID, TIME_TAG, RX_TX ) ): Running... [7, 21:45:04] CREATE TABLE XC_RTUQC ( STATION_ID VARCHAR(30) NOT NULL , TIME_TAG DATETIME NOT NULL , RX_TX VARCHAR(1) NOT NULL , PORT VARCHAR(30) , SEQUENCENUM DOUBLE , OPCODE DOUBLE , STATUS INT , RETRIES INT , GOOD INT , BAD INT , CRC INT , BATTERY_VOLTAGE DOUBLE , SPARE1 DOUBLE , SPARE2 DOUBLE , CONSTRAINT RTU_PK PRIMARY KEY ( STATION_ID, TIME_TAG, RX_TX ) ): 0 row(s) affected [8, 21:45:04] CREATE TABLE XC_PPLIST ( STATION_ID VARCHAR(30) NOT NULL , DATA_LABEL VARCHAR(20) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , FUNCTION_NAME VARCHAR(10) NOT NULL , CONSTRAINT PPLIST_PK PRIMARY KEY (STATION_ID ,SENSORNAME ,DATA_LABEL ,FUNCTION_NAME) ): Running... [8, 21:45:05] CREATE TABLE XC_PPLIST ( STATION_ID VARCHAR(30) NOT NULL , DATA_LABEL VARCHAR(20) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , FUNCTION_NAME VARCHAR(10) NOT NULL , CONSTRAINT PPLIST_PK PRIMARY KEY (STATION_ID ,SENSORNAME ,DATA_LABEL ,FUNCTION_NAME) ): 0 row(s) affected [9, 21:45:05] CREATE TABLE XC_PPDATA1 ( STATION_ID VARCHAR(30) NOT NULL , DATA_LABEL VARCHAR(20) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , FUNCTION_NAME VARCHAR(10) NOT NULL , TIME_TAG DATETIME NOT NULL , TIME_PERIOD DOUBLE NOT NULL , PP_VALUE DOUBLE NOT NULL , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , VALUE_TIME_TAG DATETIME , PROCESS_TIME_TAG DATETIME NOT NULL , ALTERNATE_LABEL VARCHAR(20) , CONSTRAINT PPDAT1_PK PRIMARY KEY (STATION_ID ,SENSORNAME ,DATA_LABEL ,FUNCTION_NAME ,TIME_TAG ,TIME_PERIOD) ): Running... [9, 21:45:06] CREATE TABLE XC_PPDATA1 ( STATION_ID VARCHAR(30) NOT NULL , DATA_LABEL VARCHAR(20) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , FUNCTION_NAME VARCHAR(10) NOT NULL , TIME_TAG DATETIME NOT NULL , TIME_PERIOD DOUBLE NOT NULL , PP_VALUE DOUBLE NOT NULL , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , VALUE_TIME_TAG DATETIME , PROCESS_TIME_TAG DATETIME NOT NULL , ALTERNATE_LABEL VARCHAR(20) , CONSTRAINT PPDAT1_PK PRIMARY KEY (STATION_ID ,SENSORNAME ,DATA_LABEL ,FUNCTION_NAME ,TIME_TAG ,TIME_PERIOD) ): 0 row(s) affected [10, 21:45:06] CREATE TABLE XC_SITESENSORSDECODE ( STATION VARCHAR(30) NOT NULL , SENSOR VARCHAR(15) NOT NULL , TOPIC VARCHAR(25) NOT NULL , SEQNUM INT NOT NULL , ENABLED VARCHAR(1) NOT NULL , FORMAT VARCHAR(10) , RELATIVE_TIME VARCHAR(1) , RELATIVE_POS VARCHAR(1) , ADD_BASE VARCHAR(1) , BYTE_SIZE INT , BIT_SIZE INT , BOUND1 INT , BOUND2 INT , BLOCK_ID VARCHAR(50) , BYTE_POS INT , BIT_POS INT , NEXT INT , BIT_NEXT INT , AMOUNT INT , DELTA_TIME INT , OFFSET_TIME INT , ROUNDOFF_TIME INT , SKIP_BLANK INT , SKIP_COMMA INT , SKIP_LF INT , SKIP_PLUS INT , IGNORE_CASE VARCHAR(1) , TEMPLATE_NAME VARCHAR(50) , CONSTRAINT SITSENDCD_PK PRIMARY KEY (STATION, SENSOR, TOPIC, SEQNUM) ): Running... [10, 21:45:07] CREATE TABLE XC_SITESENSORSDECODE ( STATION VARCHAR(30) NOT NULL , SENSOR VARCHAR(15) NOT NULL , TOPIC VARCHAR(25) NOT NULL , SEQNUM INT NOT NULL , ENABLED VARCHAR(1) NOT NULL , FORMAT VARCHAR(10) , RELATIVE_TIME VARCHAR(1) , RELATIVE_POS VARCHAR(1) , ADD_BASE VARCHAR(1) , BYTE_SIZE INT , BIT_SIZE INT , BOUND1 INT , BOUND2 INT , BLOCK_ID VARCHAR(50) , BYTE_POS INT , BIT_POS INT , NEXT INT , BIT_NEXT INT , AMOUNT INT , DELTA_TIME INT , OFFSET_TIME INT , ROUNDOFF_TIME INT , SKIP_BLANK INT , SKIP_COMMA INT , SKIP_LF INT , SKIP_PLUS INT , IGNORE_CASE VARCHAR(1) , TEMPLATE_NAME VARCHAR(50) , CONSTRAINT SITSENDCD_PK PRIMARY KEY (STATION, SENSOR, TOPIC, SEQNUM) ): 0 row(s) affected [11, 21:45:07] CREATE TABLE XC_POLLGROUPS ( GROUP_NUM VARCHAR(2) NOT NULL , ENABLED VARCHAR(1) NOT NULL , STATION_LIST VARCHAR(2000) NULL , BASE_TIME INTEGER NULL , `INTERVAL` INTEGER NULL , POLL_TYPE INT NULL , CONTROL VARCHAR(128) NULL , CONTROL_ONLY VARCHAR(1) NULL , TIME_SYNC INTEGER NULL , TIME_SYNC_PORT VARCHAR(5) NULL , TIME_LIMIT DATE NULL , OVERRIDE_ORDER VARCHAR(1) NULL , DESCRIPTION VARCHAR(30) NULL , CLIENTS VARCHAR(255) NULL , LOG_FILE VARCHAR(20) NULL , LOG_FILE_PATH VARCHAR(50) NULL , OWNER VARCHAR(20) NULL , RESET_RTABLE VARCHAR(1) NULL, CONSTRAINT POLLGROUPS_PK PRIMARY KEY (GROUP_NUM) ): Running... [11, 21:45:08] CREATE TABLE XC_POLLGROUPS ( GROUP_NUM VARCHAR(2) NOT NULL , ENABLED VARCHAR(1) NOT NULL , STATION_LIST VARCHAR(2000) NULL , BASE_TIME INTEGER NULL , `INTERVAL` INTEGER NULL , POLL_TYPE INT NULL , CONTROL VARCHAR(128) NULL , CONTROL_ONLY VARCHAR(1) NULL , TIME_SYNC INTEGER NULL , TIME_SYNC_PORT VARCHAR(5) NULL , TIME_LIMIT DATE NULL , OVERRIDE_ORDER VARCHAR(1) NULL , DESCRIPTION VARCHAR(30) NULL , CLIENTS VARCHAR(255) NULL , LOG_FILE VARCHAR(20) NULL , LOG_FILE_PATH VARCHAR(50) NULL , OWNER VARCHAR(20) NULL , RESET_RTABLE VARCHAR(1) NULL, CONSTRAINT POLLGROUPS_PK PRIMARY KEY (GROUP_NUM) ): 0 row(s) affected [12, 21:45:08] CREATE TABLE XC_USERS ( USER_NAME VARCHAR(15) NOT NULL , PASSWORD VARCHAR(64) NOT NULL , DESCRIPTION VARCHAR(64) NULL , USER_ACCESS VARCHAR(30) NULL , CONSTRAINT USERS_PK PRIMARY KEY (USER_NAME) ): Running... [12, 21:45:09] CREATE TABLE XC_USERS ( USER_NAME VARCHAR(15) NOT NULL , PASSWORD VARCHAR(64) NOT NULL , DESCRIPTION VARCHAR(64) NULL , USER_ACCESS VARCHAR(30) NULL , CONSTRAINT USERS_PK PRIMARY KEY (USER_NAME) ): 0 row(s) affected [13, 21:45:09] CREATE TABLE XC_LOG ( TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(20) NOT NULL , DESCRIPTION VARCHAR(128) NULL , CONSTRAINT LOG_PK PRIMARY KEY (TIME_TAG, SOURCE) ): Running... [13, 21:45:09] CREATE TABLE XC_LOG ( TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(20) NOT NULL , DESCRIPTION VARCHAR(128) NULL , CONSTRAINT LOG_PK PRIMARY KEY (TIME_TAG, SOURCE) ): 0 row(s) affected [14, 21:45:09] CREATE TABLE XC_TEMPLATES ( TEMPLATE_NAME VARCHAR(45) NOT NULL , TEMPLATE_TYPE INTEGER NULL , CONSTRAINT TEMPLATES_PK PRIMARY KEY (TEMPLATE_NAME) ): Running... [14, 21:45:10] CREATE TABLE XC_TEMPLATES ( TEMPLATE_NAME VARCHAR(45) NOT NULL , TEMPLATE_TYPE INTEGER NULL , CONSTRAINT TEMPLATES_PK PRIMARY KEY (TEMPLATE_NAME) ): 0 row(s) affected [15, 21:45:10] CREATE TABLE XC_LASTVALUES( STATION_ID VARCHAR(30) NOT NULL, SENSORNAME VARCHAR(15) NOT NULL, TIME_TAG DATETIME NOT NULL, IS_TEXT VARCHAR(7) NULL, NUM_VALUE DOUBLE NULL, TEXT_VALUE VARCHAR(255) NULL, PRIMARY KEY(STATION_ID,SENSORNAME) ): Running... [15, 21:45:11] CREATE TABLE XC_LASTVALUES( STATION_ID VARCHAR(30) NOT NULL, SENSORNAME VARCHAR(15) NOT NULL, TIME_TAG DATETIME NOT NULL, IS_TEXT VARCHAR(7) NULL, NUM_VALUE DOUBLE NULL, TEXT_VALUE VARCHAR(255) NULL, PRIMARY KEY(STATION_ID,SENSORNAME) ): 0 row(s) affected [16, 21:45:11] CREATE TABLE XC_RECORDIDS( STE_STATION_ID VARCHAR(30) NOT NULL , RECORD_ID VARCHAR(10) NOT NULL , SENSORS VARCHAR(255) NULL , CONSTRAINT RECORDIDS_PK PRIMARY KEY (STE_STATION_ID, RECORD_ID) ): Running... [16, 21:45:12] CREATE TABLE XC_RECORDIDS( STE_STATION_ID VARCHAR(30) NOT NULL , RECORD_ID VARCHAR(10) NOT NULL , SENSORS VARCHAR(255) NULL , CONSTRAINT RECORDIDS_PK PRIMARY KEY (STE_STATION_ID, RECORD_ID) ): 0 row(s) affected [17, 21:45:12] CREATE TABLE XC_VER ( VERSION INT ): Running... [17, 21:45:13] CREATE TABLE XC_VER ( VERSION INT ): 0 row(s) affected [18, 21:45:13] INSERT INTO XC_VER VALUES ( 104 ): Running... [18, 21:45:13] INSERT INTO XC_VER VALUES ( 104 ): 1 row(s) affected [19, 21:45:52] USE xc_data: Running... [19, 21:45:52] USE xc_data: 0 row(s) affected [20, 21:45:52] CREATE USER 'XCManager'@'localhost': Running... [20, 21:45:52] CREATE USER 'XCManager'@'localhost': 0 row(s) affected [21, 21:45:52] CREATE USER 'XConnect'@'localhost': Running... [21, 21:45:52] CREATE USER 'XConnect'@'localhost': 0 row(s) affected [22, 21:45:52] SET PASSWORD FOR 'XCManager'@'localhost'=PASSWORD('sutron'): Running... [22, 21:45:52] SET PASSWORD FOR 'XCManager'@'localhost'=PASSWORD('sutron'): 0 row(s) affected, 1 warning(s): 1287 'SET PASSWORD FOR = PASSWORD('')' is deprecated and will be removed in a future release. Please use SET PASSWORD FOR = '' instead [23, 21:45:52] SET PASSWORD FOR 'XConnect'@'localhost'=PASSWORD('xconnect'): Running... [23, 21:45:52] SET PASSWORD FOR 'XConnect'@'localhost'=PASSWORD('xconnect'): 0 row(s) affected, 1 warning(s): 1287 'SET PASSWORD FOR = PASSWORD('')' is deprecated and will be removed in a future release. Please use SET PASSWORD FOR = '' instead [24, 21:45:52] GRANT ALL PRIVILEGES ON xc_data.* TO 'XCManager'@'localhost': Running... [24, 21:45:52] GRANT ALL PRIVILEGES ON xc_data.* TO 'XCManager'@'localhost': 0 row(s) affected [25, 21:45:52] GRANT SELECT ON xc_data.* TO 'XConnect'@'localhost': Running... [25, 21:45:52] GRANT SELECT ON xc_data.* TO 'XConnect'@'localhost': 0 row(s) affected [1, 15:00:57] SELECT * FROM xc_data.xc_pollgroups LIMIT 0, 1000 : Running... [1, 15:00:57] SELECT * FROM xc_data.xc_pollgroups LIMIT 0, 1000 : Fetching... [1, 15:00:57] SELECT * FROM xc_data.xc_pollgroups LIMIT 0, 1000 : 6 row(s) returned [1, 15:13:09] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Running... [1, 15:13:09] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Fetching... [1, 15:13:09] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : 1000 row(s) returned [1, 16:45:35] DROP TABLE `xc_data`.`xc_pollgroups`: Running... [1, 16:45:35] DROP TABLE `xc_data`.`xc_pollgroups`: 0 row(s) affected [2, 16:49:38] SELECT * FROM xc_data.xc_pollgroups LIMIT 0, 1000 : Running... [2, 16:49:38] SELECT * FROM xc_data.xc_pollgroups LIMIT 0, 1000 : Fetching... [2, 16:49:38] SELECT * FROM xc_data.xc_pollgroups LIMIT 0, 1000 : 6 row(s) returned [3, 17:29:43] CREATE DATABASE xc_data2: Running... [3, 17:29:43] CREATE DATABASE xc_data2: 1 row(s) affected [4, 17:50:03] DROP DATABASE `xc_data2`: Running... [4, 17:50:03] DROP DATABASE `xc_data2`: 0 row(s) affected [5, 18:48:14] DROP DATABASE `xc_data`: Running... [5, 18:48:16] DROP DATABASE `xc_data`: 16 row(s) affected [6, 18:48:45] CREATE DATABASE xc_data: Running... [6, 18:48:45] CREATE DATABASE xc_data: 1 row(s) affected [7, 18:52:18] DROP DATABASE `xc_data`: Running... [7, 18:52:18] DROP DATABASE `xc_data`: 0 row(s) affected [1, 18:56:53] CREATE DATABASE xc_data: Running... [1, 18:56:53] CREATE DATABASE xc_data: 1 row(s) affected [2, 18:57:11] USE XC_DATA: Running... [2, 18:57:11] USE XC_DATA: 0 row(s) affected [3, 18:57:11] CREATE TABLE XC_SITES ( STATION_ID VARCHAR(30) NOT NULL , ENABLED VARCHAR(1) NOT NULL , UNIT_ID VARCHAR(15) , SITE_TYPE INT , STATUS INT , IPADDRESS VARCHAR(20) , RADIO_PATH_LIST VARCHAR(30) , PHONE_NUMBER_LIST VARCHAR(40) , PHONE_NUMBER2 VARCHAR(20) , USER_NAME VARCHAR(10) , PASSWORD VARCHAR(10) , COMPORT_LIST VARCHAR(15) , ACKDELAY_LIST VARCHAR(10) , RESPONSE_TIMEOUT_LIST VARCHAR(10) , POLL_TYPE INT , LOGIN_REQD VARCHAR(1) , QUICK_PROTOCOL VARCHAR(1) , AUTO_PROTOCOL VARCHAR(1) , CONCENTRATOR VARCHAR(1) , HOURS_AHEAD DOUBLE , RDI_BASE_TIME DATETIME , RDI_INTERVAL DATETIME , RDI_STAYON DATETIME , TEMPLATE_NAME VARCHAR(50) , SITE_COMMENT VARCHAR(32) , SITE_LONG_NAME VARCHAR(50) , SITE_CODE INTEGER , USGS_ID VARCHAR(10) , INSTALLATION_DATE DATETIME , AGENCY VARCHAR(32) , COUNTRY VARCHAR(32) , DISTRICT VARCHAR(32) , CITY VARCHAR(32) , STATE VARCHAR(20) , COUNTY VARCHAR(32) , RESERVOIR VARCHAR(32) , BASIN VARCHAR(32) , RIVER_MILE DOUBLE , LATITUDE DOUBLE , LONGITUDE DOUBLE , ELEVATION DOUBLE , COEFFICIENT1 DOUBLE , COEFFICIENT2 DOUBLE , COEFFICIENT3 DOUBLE , WEIGHTING_FACTOR DOUBLE , SATELLITE_ID VARCHAR(8) , PRIMARY_CHANNEL INT , RANDOM_CHANNEL INT , REPORTING_TIME DATETIME , REPORTING_INTERVAL DOUBLE , LAST_UPDATE DATETIME , TZONE_CODE VARCHAR(4) , GMT_OFFSET DOUBLE , SHEF_ID VARCHAR(8) , ALTERNATE_CHAR_ID_1 VARCHAR(10) , ALTERNATE_CHAR_ID_2 VARCHAR(10) , GPSTRING1 VARCHAR(20) , GPSTRING2 VARCHAR(20) , GPNUMBER1 DOUBLE , GPNUMBER2 DOUBLE , SETUP_FILE_NAME VARCHAR(255) , LOG_FILE_NAME VARCHAR(255) , PICTURE_FILE_NAME VARCHAR(255) , MODEM_INIT_STRING VARCHAR(20) , MODEM_HANGUP_STRING VARCHAR(20) , LAST_POLL DATETIME , TEMPLATE_FLAG INT NULL DEFAULT 1, MBDEVICE_ID VARCHAR(4) , MBCONSEC_REGISTER VARCHAR(1) , MBBASE_REGISTER INT , MBREGISTER_TYPE INT , MBREGISTER_COUNT INT , MSGPARITY INT , IMEI_ID VARCHAR(15) , SMS_ID VARCHAR(15) , CONSTRAINT STE_PK PRIMARY KEY(STATION_ID) ): Running... [3, 18:57:12] CREATE TABLE XC_SITES ( STATION_ID VARCHAR(30) NOT NULL , ENABLED VARCHAR(1) NOT NULL , UNIT_ID VARCHAR(15) , SITE_TYPE INT , STATUS INT , IPADDRESS VARCHAR(20) , RADIO_PATH_LIST VARCHAR(30) , PHONE_NUMBER_LIST VARCHAR(40) , PHONE_NUMBER2 VARCHAR(20) , USER_NAME VARCHAR(10) , PASSWORD VARCHAR(10) , COMPORT_LIST VARCHAR(15) , ACKDELAY_LIST VARCHAR(10) , RESPONSE_TIMEOUT_LIST VARCHAR(10) , POLL_TYPE INT , LOGIN_REQD VARCHAR(1) , QUICK_PROTOCOL VARCHAR(1) , AUTO_PROTOCOL VARCHAR(1) , CONCENTRATOR VARCHAR(1) , HOURS_AHEAD DOUBLE , RDI_BASE_TIME DATETIME , RDI_INTERVAL DATETIME , RDI_STAYON DATETIME , TEMPLATE_NAME VARCHAR(50) , SITE_COMMENT VARCHAR(32) , SITE_LONG_NAME VARCHAR(50) , SITE_CODE INTEGER , USGS_ID VARCHAR(10) , INSTALLATION_DATE DATETIME , AGENCY VARCHAR(32) , COUNTRY VARCHAR(32) , DISTRICT VARCHAR(32) , CITY VARCHAR(32) , STATE VARCHAR(20) , COUNTY VARCHAR(32) , RESERVOIR VARCHAR(32) , BASIN VARCHAR(32) , RIVER_MILE DOUBLE , LATITUDE DOUBLE , LONGITUDE DOUBLE , ELEVATION DOUBLE , COEFFICIENT1 DOUBLE , COEFFICIENT2 DOUBLE , COEFFICIENT3 DOUBLE , WEIGHTING_FACTOR DOUBLE , SATELLITE_ID VARCHAR(8) , PRIMARY_CHANNEL INT , RANDOM_CHANNEL INT , REPORTING_TIME DATETIME , REPORTING_INTERVAL DOUBLE , LAST_UPDATE DATETIME , TZONE_CODE VARCHAR(4) , GMT_OFFSET DOUBLE , SHEF_ID VARCHAR(8) , ALTERNATE_CHAR_ID_1 VARCHAR(10) , ALTERNATE_CHAR_ID_2 VARCHAR(10) , GPSTRING1 VARCHAR(20) , GPSTRING2 VARCHAR(20) , GPNUMBER1 DOUBLE , GPNUMBER2 DOUBLE , SETUP_FILE_NAME VARCHAR(255) , LOG_FILE_NAME VARCHAR(255) , PICTURE_FILE_NAME VARCHAR(255) , MODEM_INIT_STRING VARCHAR(20) , MODEM_HANGUP_STRING VARCHAR(20) , LAST_POLL DATETIME , TEMPLATE_FLAG INT NULL DEFAULT 1, MBDEVICE_ID VARCHAR(4) , MBCONSEC_REGISTER VARCHAR(1) , MBBASE_REGISTER INT , MBREGISTER_TYPE INT , MBREGISTER_COUNT INT , MSGPARITY INT , IMEI_ID VARCHAR(15) , SMS_ID VARCHAR(15) , CONSTRAINT STE_PK PRIMARY KEY(STATION_ID) ): 0 row(s) affected [4, 18:57:12] CREATE TABLE XC_SITESENSORS ( STE_STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , ENABLED VARCHAR(1) NOT NULL , DATA_TABLE VARCHAR(12) NOT NULL , TAGNAME VARCHAR(15) , RAWLIST VARCHAR(30) , RIGHT_DIGIT INT , LEFT_DIGIT INT , IS_TEXT VARCHAR(7) , ROUNDOFF_TIME INT , DATA_STORE_INTERVAL INT , UNITS VARCHAR(10) , TEMPLATE_NAME VARCHAR(50) , STATUS INT , DESCRIPTION VARCHAR(32) , MANUFACTURER VARCHAR(20) , MODEL_NUMBER VARCHAR(20) , SHEF_PE_CODE VARCHAR(7) , PARAMETER_CODE VARCHAR(12) , ALT_PARAMETER_CODE_1 VARCHAR(12) , ALT_PARAMETER_CODE_2 VARCHAR(12) , EQUATION VARCHAR(128) , RATING_TABLE VARCHAR(128) , OFFSET DOUBLE , SHIFT DOUBLE , HIGH_HIGH_LIMIT DOUBLE , HIGH_HIGH_ALARM INT , HIGH_LIMIT DOUBLE , HIGH_ALARM INT , LOW_LIMIT DOUBLE , LOW_ALARM INT , LOW_LOW_LIMIT DOUBLE , LOW_LOW_ALARM INT , ROC_LIMIT DOUBLE , ROC_ALARM INT , ROC_INTERVAL DOUBLE , DEADBAND DOUBLE , NO_CHANGE_INTERVAL DOUBLE , NO_CHANGE_ALARM INT , TEXT_LIMIT VARCHAR(9) , TEXT_ALARM INT , STD_DEV_LIMIT DOUBLE , STD_DEV_ALARM INT , STD_DEV_INTERVAL DOUBLE , AVG_LIMIT DOUBLE , AVG_ALARM INT , AVG_INTERVAL DOUBLE , GPNUMBER1 DOUBLE , GPNUMBER2 DOUBLE , GPSTRING1 VARCHAR(20) , GPSTRING2 VARCHAR(20) , ALERT_ID DOUBLE , ALERT_TYPE VARCHAR(10) , COEFFICIENT1 DOUBLE , COEFFICIENT2 DOUBLE , COEFFICIENT3 DOUBLE , COEFFICIENT4 DOUBLE , COEFFICIENT5 DOUBLE , REFERENCE_1 DOUBLE , REFERENCE_2 DOUBLE , DATA_EXCH_NUM VARCHAR(100) , MIKE11_LABEL_1 VARCHAR(50) , MIKE11_LABEL_2 VARCHAR(50) , NO_ALARM_INTERVAL DOUBLE , MBBASE_REGISTER INT , MBREGISTER_TYPE INT , MBTAG_TYPE INT , MBMSW INT , USE_REJECT_LOW VARCHAR(1) , REJECT_LOW_LIMIT DOUBLE , USE_REJECT_HIGH VARCHAR(1) , REJECT_HIGH_LIMIT DOUBLE , CONSTRAINT SITSEN_PK PRIMARY KEY (SENSORNAME,STE_STATION_ID), CONSTRAINT SITSEN_STE_FK FOREIGN KEY (STE_STATION_ID) REFERENCES XC_SITES (STATION_ID) ): Running... [4, 18:57:12] CREATE TABLE XC_SITESENSORS ( STE_STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , ENABLED VARCHAR(1) NOT NULL , DATA_TABLE VARCHAR(12) NOT NULL , TAGNAME VARCHAR(15) , RAWLIST VARCHAR(30) , RIGHT_DIGIT INT , LEFT_DIGIT INT , IS_TEXT VARCHAR(7) , ROUNDOFF_TIME INT , DATA_STORE_INTERVAL INT , UNITS VARCHAR(10) , TEMPLATE_NAME VARCHAR(50) , STATUS INT , DESCRIPTION VARCHAR(32) , MANUFACTURER VARCHAR(20) , MODEL_NUMBER VARCHAR(20) , SHEF_PE_CODE VARCHAR(7) , PARAMETER_CODE VARCHAR(12) , ALT_PARAMETER_CODE_1 VARCHAR(12) , ALT_PARAMETER_CODE_2 VARCHAR(12) , EQUATION VARCHAR(128) , RATING_TABLE VARCHAR(128) , OFFSET DOUBLE , SHIFT DOUBLE , HIGH_HIGH_LIMIT DOUBLE , HIGH_HIGH_ALARM INT , HIGH_LIMIT DOUBLE , HIGH_ALARM INT , LOW_LIMIT DOUBLE , LOW_ALARM INT , LOW_LOW_LIMIT DOUBLE , LOW_LOW_ALARM INT , ROC_LIMIT DOUBLE , ROC_ALARM INT , ROC_INTERVAL DOUBLE , DEADBAND DOUBLE , NO_CHANGE_INTERVAL DOUBLE , NO_CHANGE_ALARM INT , TEXT_LIMIT VARCHAR(9) , TEXT_ALARM INT , STD_DEV_LIMIT DOUBLE , STD_DEV_ALARM INT , STD_DEV_INTERVAL DOUBLE , AVG_LIMIT DOUBLE , AVG_ALARM INT , AVG_INTERVAL DOUBLE , GPNUMBER1 DOUBLE , GPNUMBER2 DOUBLE , GPSTRING1 VARCHAR(20) , GPSTRING2 VARCHAR(20) , ALERT_ID DOUBLE , ALERT_TYPE VARCHAR(10) , COEFFICIENT1 DOUBLE , COEFFICIENT2 DOUBLE , COEFFICIENT3 DOUBLE , COEFFICIENT4 DOUBLE , COEFFICIENT5 DOUBLE , REFERENCE_1 DOUBLE , REFERENCE_2 DOUBLE , DATA_EXCH_NUM VARCHAR(100) , MIKE11_LABEL_1 VARCHAR(50) , MIKE11_LABEL_2 VARCHAR(50) , NO_ALARM_INTERVAL DOUBLE , MBBASE_REGISTER INT , MBREGISTER_TYPE INT , MBTAG_TYPE INT , MBMSW INT , USE_REJECT_LOW VARCHAR(1) , REJECT_LOW_LIMIT DOUBLE , USE_REJECT_HIGH VARCHAR(1) , REJECT_HIGH_LIMIT DOUBLE , CONSTRAINT SITSEN_PK PRIMARY KEY (SENSORNAME,STE_STATION_ID), CONSTRAINT SITSEN_STE_FK FOREIGN KEY (STE_STATION_ID) REFERENCES XC_SITES (STATION_ID) ): 0 row(s) affected [5, 18:57:12] CREATE TABLE XC_DATA1 ( STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , ORIG_VALUE DOUBLE NOT NULL , ED_VALUE DOUBLE , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , FLAG4 VARCHAR(1) , HIGH_HIGH_FLAG INT , HIGH_FLAG INT , LOW_FLAG INT , LOW_LOW_FLAG INT , ROC_FLAG INT , NO_CHG_FLAG INT , ALARM_FLAG INT , STD_DEV_FLAG INT , AVG_FLAG INT , CONSTRAINT DAT1_PK PRIMARY KEY ( TIME_TAG , SOURCE , STATION_ID, SENSORNAME ) ): Running... [5, 18:57:13] CREATE TABLE XC_DATA1 ( STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , ORIG_VALUE DOUBLE NOT NULL , ED_VALUE DOUBLE , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , FLAG4 VARCHAR(1) , HIGH_HIGH_FLAG INT , HIGH_FLAG INT , LOW_FLAG INT , LOW_LOW_FLAG INT , ROC_FLAG INT , NO_CHG_FLAG INT , ALARM_FLAG INT , STD_DEV_FLAG INT , AVG_FLAG INT , CONSTRAINT DAT1_PK PRIMARY KEY ( TIME_TAG , SOURCE , STATION_ID, SENSORNAME ) ): 0 row(s) affected [6, 18:57:13] CREATE TABLE XC_TXTDATA1 ( STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , TEXT_VALUE VARCHAR(255) NOT NULL , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , FLAG4 VARCHAR(1) , MESSAGE_STATUS VARCHAR(2) , TXT_ALARM_FLAG INT , CONSTRAINT TXD1_PK PRIMARY KEY (TIME_TAG ,SOURCE ,STATION_ID ,SENSORNAME) ): Running... [6, 18:57:14] CREATE TABLE XC_TXTDATA1 ( STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , TEXT_VALUE VARCHAR(255) NOT NULL , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , FLAG4 VARCHAR(1) , MESSAGE_STATUS VARCHAR(2) , TXT_ALARM_FLAG INT , CONSTRAINT TXD1_PK PRIMARY KEY (TIME_TAG ,SOURCE ,STATION_ID ,SENSORNAME) ): 0 row(s) affected [7, 18:57:14] CREATE TABLE XC_GOESQC ( NESDIS_ID VARCHAR(8) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , STATION_ID VARCHAR(30) , FAILURE_CODE VARCHAR(1) , SIG_STRENGTH DOUBLE , FREQ_OFFSET DOUBLE , MOD_INDEX VARCHAR(1) , MOD_QUAL VARCHAR(1) , CHANNEL INT , SAT_LOC VARCHAR(1) , UC_STATUS VARCHAR(2) , MESSAGE_LEN INT , ACTUAL_LEN INT , PARITY INT , BUFFER_EMPTY INT , BATTERY_VOLTAGE DOUBLE , SPARE1 DOUBLE , SPARE2 DOUBLE , CONSTRAINT GOESQC_PK PRIMARY KEY (NESDIS_ID ,TIME_TAG ,SOURCE) ): Running... [7, 18:57:14] CREATE TABLE XC_GOESQC ( NESDIS_ID VARCHAR(8) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , STATION_ID VARCHAR(30) , FAILURE_CODE VARCHAR(1) , SIG_STRENGTH DOUBLE , FREQ_OFFSET DOUBLE , MOD_INDEX VARCHAR(1) , MOD_QUAL VARCHAR(1) , CHANNEL INT , SAT_LOC VARCHAR(1) , UC_STATUS VARCHAR(2) , MESSAGE_LEN INT , ACTUAL_LEN INT , PARITY INT , BUFFER_EMPTY INT , BATTERY_VOLTAGE DOUBLE , SPARE1 DOUBLE , SPARE2 DOUBLE , CONSTRAINT GOESQC_PK PRIMARY KEY (NESDIS_ID ,TIME_TAG ,SOURCE) ): 0 row(s) affected [8, 18:57:14] CREATE TABLE XC_RTUQC ( STATION_ID VARCHAR(30) NOT NULL , TIME_TAG DATETIME NOT NULL , RX_TX VARCHAR(1) NOT NULL , PORT VARCHAR(30) , SEQUENCENUM DOUBLE , OPCODE DOUBLE , STATUS INT , RETRIES INT , GOOD INT , BAD INT , CRC INT , BATTERY_VOLTAGE DOUBLE , SPARE1 DOUBLE , SPARE2 DOUBLE , CONSTRAINT RTU_PK PRIMARY KEY ( STATION_ID, TIME_TAG, RX_TX ) ): Running... [8, 18:57:14] CREATE TABLE XC_RTUQC ( STATION_ID VARCHAR(30) NOT NULL , TIME_TAG DATETIME NOT NULL , RX_TX VARCHAR(1) NOT NULL , PORT VARCHAR(30) , SEQUENCENUM DOUBLE , OPCODE DOUBLE , STATUS INT , RETRIES INT , GOOD INT , BAD INT , CRC INT , BATTERY_VOLTAGE DOUBLE , SPARE1 DOUBLE , SPARE2 DOUBLE , CONSTRAINT RTU_PK PRIMARY KEY ( STATION_ID, TIME_TAG, RX_TX ) ): 0 row(s) affected [9, 18:57:14] CREATE TABLE XC_PPLIST ( STATION_ID VARCHAR(30) NOT NULL , DATA_LABEL VARCHAR(20) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , FUNCTION_NAME VARCHAR(10) NOT NULL , CONSTRAINT PPLIST_PK PRIMARY KEY (STATION_ID ,SENSORNAME ,DATA_LABEL ,FUNCTION_NAME) ): Running... [9, 18:57:15] CREATE TABLE XC_PPLIST ( STATION_ID VARCHAR(30) NOT NULL , DATA_LABEL VARCHAR(20) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , FUNCTION_NAME VARCHAR(10) NOT NULL , CONSTRAINT PPLIST_PK PRIMARY KEY (STATION_ID ,SENSORNAME ,DATA_LABEL ,FUNCTION_NAME) ): 0 row(s) affected [10, 18:57:15] CREATE TABLE XC_PPDATA1 ( STATION_ID VARCHAR(30) NOT NULL , DATA_LABEL VARCHAR(20) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , FUNCTION_NAME VARCHAR(10) NOT NULL , TIME_TAG DATETIME NOT NULL , TIME_PERIOD DOUBLE NOT NULL , PP_VALUE DOUBLE NOT NULL , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , VALUE_TIME_TAG DATETIME , PROCESS_TIME_TAG DATETIME NOT NULL , ALTERNATE_LABEL VARCHAR(20) , CONSTRAINT PPDAT1_PK PRIMARY KEY (STATION_ID ,SENSORNAME ,DATA_LABEL ,FUNCTION_NAME ,TIME_TAG ,TIME_PERIOD) ): Running... [10, 18:57:15] CREATE TABLE XC_PPDATA1 ( STATION_ID VARCHAR(30) NOT NULL , DATA_LABEL VARCHAR(20) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , FUNCTION_NAME VARCHAR(10) NOT NULL , TIME_TAG DATETIME NOT NULL , TIME_PERIOD DOUBLE NOT NULL , PP_VALUE DOUBLE NOT NULL , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , VALUE_TIME_TAG DATETIME , PROCESS_TIME_TAG DATETIME NOT NULL , ALTERNATE_LABEL VARCHAR(20) , CONSTRAINT PPDAT1_PK PRIMARY KEY (STATION_ID ,SENSORNAME ,DATA_LABEL ,FUNCTION_NAME ,TIME_TAG ,TIME_PERIOD) ): 0 row(s) affected [11, 18:57:15] CREATE TABLE XC_SITESENSORSDECODE ( STATION VARCHAR(30) NOT NULL , SENSOR VARCHAR(15) NOT NULL , TOPIC VARCHAR(25) NOT NULL , SEQNUM INT NOT NULL , ENABLED VARCHAR(1) NOT NULL , FORMAT VARCHAR(10) , RELATIVE_TIME VARCHAR(1) , RELATIVE_POS VARCHAR(1) , ADD_BASE VARCHAR(1) , BYTE_SIZE INT , BIT_SIZE INT , BOUND1 INT , BOUND2 INT , BLOCK_ID VARCHAR(50) , BYTE_POS INT , BIT_POS INT , NEXT INT , BIT_NEXT INT , AMOUNT INT , DELTA_TIME INT , OFFSET_TIME INT , ROUNDOFF_TIME INT , SKIP_BLANK INT , SKIP_COMMA INT , SKIP_LF INT , SKIP_PLUS INT , IGNORE_CASE VARCHAR(1) , TEMPLATE_NAME VARCHAR(50) , CONSTRAINT SITSENDCD_PK PRIMARY KEY (STATION, SENSOR, TOPIC, SEQNUM) ): Running... [11, 18:57:15] CREATE TABLE XC_SITESENSORSDECODE ( STATION VARCHAR(30) NOT NULL , SENSOR VARCHAR(15) NOT NULL , TOPIC VARCHAR(25) NOT NULL , SEQNUM INT NOT NULL , ENABLED VARCHAR(1) NOT NULL , FORMAT VARCHAR(10) , RELATIVE_TIME VARCHAR(1) , RELATIVE_POS VARCHAR(1) , ADD_BASE VARCHAR(1) , BYTE_SIZE INT , BIT_SIZE INT , BOUND1 INT , BOUND2 INT , BLOCK_ID VARCHAR(50) , BYTE_POS INT , BIT_POS INT , NEXT INT , BIT_NEXT INT , AMOUNT INT , DELTA_TIME INT , OFFSET_TIME INT , ROUNDOFF_TIME INT , SKIP_BLANK INT , SKIP_COMMA INT , SKIP_LF INT , SKIP_PLUS INT , IGNORE_CASE VARCHAR(1) , TEMPLATE_NAME VARCHAR(50) , CONSTRAINT SITSENDCD_PK PRIMARY KEY (STATION, SENSOR, TOPIC, SEQNUM) ): 0 row(s) affected [12, 18:57:15] CREATE TABLE XC_POLLGROUPS ( GROUP_NUM VARCHAR(2) NOT NULL , ENABLED VARCHAR(1) NOT NULL , STATION_LIST VARCHAR(2000) NULL , BASE_TIME INTEGER NULL , `INTERVAL` INTEGER NULL , POLL_TYPE INT NULL , CONTROL VARCHAR(128) NULL , CONTROL_ONLY VARCHAR(1) NULL , TIME_SYNC INTEGER NULL , TIME_SYNC_PORT VARCHAR(5) NULL , TIME_LIMIT DATE NULL , OVERRIDE_ORDER VARCHAR(1) NULL , DESCRIPTION VARCHAR(30) NULL , CLIENTS VARCHAR(255) NULL , LOG_FILE VARCHAR(20) NULL , LOG_FILE_PATH VARCHAR(50) NULL , OWNER VARCHAR(20) NULL , RESET_RTABLE VARCHAR(1) NULL, CONSTRAINT POLLGROUPS_PK PRIMARY KEY (GROUP_NUM) ): Running... [12, 18:57:16] CREATE TABLE XC_POLLGROUPS ( GROUP_NUM VARCHAR(2) NOT NULL , ENABLED VARCHAR(1) NOT NULL , STATION_LIST VARCHAR(2000) NULL , BASE_TIME INTEGER NULL , `INTERVAL` INTEGER NULL , POLL_TYPE INT NULL , CONTROL VARCHAR(128) NULL , CONTROL_ONLY VARCHAR(1) NULL , TIME_SYNC INTEGER NULL , TIME_SYNC_PORT VARCHAR(5) NULL , TIME_LIMIT DATE NULL , OVERRIDE_ORDER VARCHAR(1) NULL , DESCRIPTION VARCHAR(30) NULL , CLIENTS VARCHAR(255) NULL , LOG_FILE VARCHAR(20) NULL , LOG_FILE_PATH VARCHAR(50) NULL , OWNER VARCHAR(20) NULL , RESET_RTABLE VARCHAR(1) NULL, CONSTRAINT POLLGROUPS_PK PRIMARY KEY (GROUP_NUM) ): 0 row(s) affected [13, 18:57:16] CREATE TABLE XC_USERS ( USER_NAME VARCHAR(15) NOT NULL , PASSWORD VARCHAR(64) NOT NULL , DESCRIPTION VARCHAR(64) NULL , USER_ACCESS VARCHAR(30) NULL , CONSTRAINT USERS_PK PRIMARY KEY (USER_NAME) ): Running... [13, 18:57:16] CREATE TABLE XC_USERS ( USER_NAME VARCHAR(15) NOT NULL , PASSWORD VARCHAR(64) NOT NULL , DESCRIPTION VARCHAR(64) NULL , USER_ACCESS VARCHAR(30) NULL , CONSTRAINT USERS_PK PRIMARY KEY (USER_NAME) ): 0 row(s) affected [14, 18:57:16] CREATE TABLE XC_LOG ( TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(20) NOT NULL , DESCRIPTION VARCHAR(128) NULL , CONSTRAINT LOG_PK PRIMARY KEY (TIME_TAG, SOURCE) ): Running... [14, 18:57:17] CREATE TABLE XC_LOG ( TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(20) NOT NULL , DESCRIPTION VARCHAR(128) NULL , CONSTRAINT LOG_PK PRIMARY KEY (TIME_TAG, SOURCE) ): 0 row(s) affected [15, 18:57:17] CREATE TABLE XC_TEMPLATES ( TEMPLATE_NAME VARCHAR(45) NOT NULL , TEMPLATE_TYPE INTEGER NULL , CONSTRAINT TEMPLATES_PK PRIMARY KEY (TEMPLATE_NAME) ): Running... [15, 18:57:17] CREATE TABLE XC_TEMPLATES ( TEMPLATE_NAME VARCHAR(45) NOT NULL , TEMPLATE_TYPE INTEGER NULL , CONSTRAINT TEMPLATES_PK PRIMARY KEY (TEMPLATE_NAME) ): 0 row(s) affected [16, 18:57:17] CREATE TABLE XC_LASTVALUES( STATION_ID VARCHAR(30) NOT NULL, SENSORNAME VARCHAR(15) NOT NULL, TIME_TAG DATETIME NOT NULL, IS_TEXT VARCHAR(7) NULL, NUM_VALUE DOUBLE NULL, TEXT_VALUE VARCHAR(255) NULL, PRIMARY KEY(STATION_ID,SENSORNAME) ): Running... [16, 18:57:17] CREATE TABLE XC_LASTVALUES( STATION_ID VARCHAR(30) NOT NULL, SENSORNAME VARCHAR(15) NOT NULL, TIME_TAG DATETIME NOT NULL, IS_TEXT VARCHAR(7) NULL, NUM_VALUE DOUBLE NULL, TEXT_VALUE VARCHAR(255) NULL, PRIMARY KEY(STATION_ID,SENSORNAME) ): 0 row(s) affected [17, 18:57:17] CREATE TABLE XC_RECORDIDS( STE_STATION_ID VARCHAR(30) NOT NULL , RECORD_ID VARCHAR(10) NOT NULL , SENSORS VARCHAR(255) NULL , CONSTRAINT RECORDIDS_PK PRIMARY KEY (STE_STATION_ID, RECORD_ID) ): Running... [17, 18:57:18] CREATE TABLE XC_RECORDIDS( STE_STATION_ID VARCHAR(30) NOT NULL , RECORD_ID VARCHAR(10) NOT NULL , SENSORS VARCHAR(255) NULL , CONSTRAINT RECORDIDS_PK PRIMARY KEY (STE_STATION_ID, RECORD_ID) ): 0 row(s) affected [18, 18:57:18] CREATE TABLE XC_VER ( VERSION INT ): Running... [18, 18:57:18] CREATE TABLE XC_VER ( VERSION INT ): 0 row(s) affected [19, 18:57:18] INSERT INTO XC_VER VALUES ( 104 ): Running... [19, 18:57:18] INSERT INTO XC_VER VALUES ( 104 ): 1 row(s) affected [20, 18:57:43] USE xc_data: Running... [20, 18:57:43] USE xc_data: 0 row(s) affected [21, 18:57:43] CREATE USER 'XCManager'@'localhost': Running... [21, 18:57:43] CREATE USER 'XCManager'@'localhost': Error Code: 1396. Operation CREATE USER failed for 'XCManager'@'localhost' [22, 19:02:55] DROP DATABASE `xc_data`: Running... [22, 19:02:57] DROP DATABASE `xc_data`: 16 row(s) affected [1, 19:03:52] CREATE DATABASE xc_data: Running... [1, 19:03:52] CREATE DATABASE xc_data: 1 row(s) affected [2, 19:04:09] USE xc_data: Running... [2, 19:04:09] USE xc_data: 0 row(s) affected [3, 19:04:09] CREATE USER 'XCManager'@'localhost': Running... [3, 19:04:09] CREATE USER 'XCManager'@'localhost': Error Code: 1396. Operation CREATE USER failed for 'XCManager'@'localhost' [4, 19:15:23] USE XC_DATA: Running... [4, 19:15:23] USE XC_DATA: 0 row(s) affected [5, 19:15:23] CREATE TABLE XC_SITES ( STATION_ID VARCHAR(30) NOT NULL , ENABLED VARCHAR(1) NOT NULL , UNIT_ID VARCHAR(15) , SITE_TYPE INT , STATUS INT , IPADDRESS VARCHAR(20) , RADIO_PATH_LIST VARCHAR(30) , PHONE_NUMBER_LIST VARCHAR(40) , PHONE_NUMBER2 VARCHAR(20) , USER_NAME VARCHAR(10) , PASSWORD VARCHAR(10) , COMPORT_LIST VARCHAR(15) , ACKDELAY_LIST VARCHAR(10) , RESPONSE_TIMEOUT_LIST VARCHAR(10) , POLL_TYPE INT , LOGIN_REQD VARCHAR(1) , QUICK_PROTOCOL VARCHAR(1) , AUTO_PROTOCOL VARCHAR(1) , CONCENTRATOR VARCHAR(1) , HOURS_AHEAD DOUBLE , RDI_BASE_TIME DATETIME , RDI_INTERVAL DATETIME , RDI_STAYON DATETIME , TEMPLATE_NAME VARCHAR(50) , SITE_COMMENT VARCHAR(32) , SITE_LONG_NAME VARCHAR(50) , SITE_CODE INTEGER , USGS_ID VARCHAR(10) , INSTALLATION_DATE DATETIME , AGENCY VARCHAR(32) , COUNTRY VARCHAR(32) , DISTRICT VARCHAR(32) , CITY VARCHAR(32) , STATE VARCHAR(20) , COUNTY VARCHAR(32) , RESERVOIR VARCHAR(32) , BASIN VARCHAR(32) , RIVER_MILE DOUBLE , LATITUDE DOUBLE , LONGITUDE DOUBLE , ELEVATION DOUBLE , COEFFICIENT1 DOUBLE , COEFFICIENT2 DOUBLE , COEFFICIENT3 DOUBLE , WEIGHTING_FACTOR DOUBLE , SATELLITE_ID VARCHAR(8) , PRIMARY_CHANNEL INT , RANDOM_CHANNEL INT , REPORTING_TIME DATETIME , REPORTING_INTERVAL DOUBLE , LAST_UPDATE DATETIME , TZONE_CODE VARCHAR(4) , GMT_OFFSET DOUBLE , SHEF_ID VARCHAR(8) , ALTERNATE_CHAR_ID_1 VARCHAR(10) , ALTERNATE_CHAR_ID_2 VARCHAR(10) , GPSTRING1 VARCHAR(20) , GPSTRING2 VARCHAR(20) , GPNUMBER1 DOUBLE , GPNUMBER2 DOUBLE , SETUP_FILE_NAME VARCHAR(255) , LOG_FILE_NAME VARCHAR(255) , PICTURE_FILE_NAME VARCHAR(255) , MODEM_INIT_STRING VARCHAR(20) , MODEM_HANGUP_STRING VARCHAR(20) , LAST_POLL DATETIME , TEMPLATE_FLAG INT NULL DEFAULT 1, MBDEVICE_ID VARCHAR(4) , MBCONSEC_REGISTER VARCHAR(1) , MBBASE_REGISTER INT , MBREGISTER_TYPE INT , MBREGISTER_COUNT INT , MSGPARITY INT , IMEI_ID VARCHAR(15) , SMS_ID VARCHAR(15) , CONSTRAINT STE_PK PRIMARY KEY(STATION_ID) ): Running... [5, 19:15:23] CREATE TABLE XC_SITES ( STATION_ID VARCHAR(30) NOT NULL , ENABLED VARCHAR(1) NOT NULL , UNIT_ID VARCHAR(15) , SITE_TYPE INT , STATUS INT , IPADDRESS VARCHAR(20) , RADIO_PATH_LIST VARCHAR(30) , PHONE_NUMBER_LIST VARCHAR(40) , PHONE_NUMBER2 VARCHAR(20) , USER_NAME VARCHAR(10) , PASSWORD VARCHAR(10) , COMPORT_LIST VARCHAR(15) , ACKDELAY_LIST VARCHAR(10) , RESPONSE_TIMEOUT_LIST VARCHAR(10) , POLL_TYPE INT , LOGIN_REQD VARCHAR(1) , QUICK_PROTOCOL VARCHAR(1) , AUTO_PROTOCOL VARCHAR(1) , CONCENTRATOR VARCHAR(1) , HOURS_AHEAD DOUBLE , RDI_BASE_TIME DATETIME , RDI_INTERVAL DATETIME , RDI_STAYON DATETIME , TEMPLATE_NAME VARCHAR(50) , SITE_COMMENT VARCHAR(32) , SITE_LONG_NAME VARCHAR(50) , SITE_CODE INTEGER , USGS_ID VARCHAR(10) , INSTALLATION_DATE DATETIME , AGENCY VARCHAR(32) , COUNTRY VARCHAR(32) , DISTRICT VARCHAR(32) , CITY VARCHAR(32) , STATE VARCHAR(20) , COUNTY VARCHAR(32) , RESERVOIR VARCHAR(32) , BASIN VARCHAR(32) , RIVER_MILE DOUBLE , LATITUDE DOUBLE , LONGITUDE DOUBLE , ELEVATION DOUBLE , COEFFICIENT1 DOUBLE , COEFFICIENT2 DOUBLE , COEFFICIENT3 DOUBLE , WEIGHTING_FACTOR DOUBLE , SATELLITE_ID VARCHAR(8) , PRIMARY_CHANNEL INT , RANDOM_CHANNEL INT , REPORTING_TIME DATETIME , REPORTING_INTERVAL DOUBLE , LAST_UPDATE DATETIME , TZONE_CODE VARCHAR(4) , GMT_OFFSET DOUBLE , SHEF_ID VARCHAR(8) , ALTERNATE_CHAR_ID_1 VARCHAR(10) , ALTERNATE_CHAR_ID_2 VARCHAR(10) , GPSTRING1 VARCHAR(20) , GPSTRING2 VARCHAR(20) , GPNUMBER1 DOUBLE , GPNUMBER2 DOUBLE , SETUP_FILE_NAME VARCHAR(255) , LOG_FILE_NAME VARCHAR(255) , PICTURE_FILE_NAME VARCHAR(255) , MODEM_INIT_STRING VARCHAR(20) , MODEM_HANGUP_STRING VARCHAR(20) , LAST_POLL DATETIME , TEMPLATE_FLAG INT NULL DEFAULT 1, MBDEVICE_ID VARCHAR(4) , MBCONSEC_REGISTER VARCHAR(1) , MBBASE_REGISTER INT , MBREGISTER_TYPE INT , MBREGISTER_COUNT INT , MSGPARITY INT , IMEI_ID VARCHAR(15) , SMS_ID VARCHAR(15) , CONSTRAINT STE_PK PRIMARY KEY(STATION_ID) ): 0 row(s) affected [6, 19:15:23] CREATE TABLE XC_SITESENSORS ( STE_STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , ENABLED VARCHAR(1) NOT NULL , DATA_TABLE VARCHAR(12) NOT NULL , TAGNAME VARCHAR(15) , RAWLIST VARCHAR(30) , RIGHT_DIGIT INT , LEFT_DIGIT INT , IS_TEXT VARCHAR(7) , ROUNDOFF_TIME INT , DATA_STORE_INTERVAL INT , UNITS VARCHAR(10) , TEMPLATE_NAME VARCHAR(50) , STATUS INT , DESCRIPTION VARCHAR(32) , MANUFACTURER VARCHAR(20) , MODEL_NUMBER VARCHAR(20) , SHEF_PE_CODE VARCHAR(7) , PARAMETER_CODE VARCHAR(12) , ALT_PARAMETER_CODE_1 VARCHAR(12) , ALT_PARAMETER_CODE_2 VARCHAR(12) , EQUATION VARCHAR(128) , RATING_TABLE VARCHAR(128) , OFFSET DOUBLE , SHIFT DOUBLE , HIGH_HIGH_LIMIT DOUBLE , HIGH_HIGH_ALARM INT , HIGH_LIMIT DOUBLE , HIGH_ALARM INT , LOW_LIMIT DOUBLE , LOW_ALARM INT , LOW_LOW_LIMIT DOUBLE , LOW_LOW_ALARM INT , ROC_LIMIT DOUBLE , ROC_ALARM INT , ROC_INTERVAL DOUBLE , DEADBAND DOUBLE , NO_CHANGE_INTERVAL DOUBLE , NO_CHANGE_ALARM INT , TEXT_LIMIT VARCHAR(9) , TEXT_ALARM INT , STD_DEV_LIMIT DOUBLE , STD_DEV_ALARM INT , STD_DEV_INTERVAL DOUBLE , AVG_LIMIT DOUBLE , AVG_ALARM INT , AVG_INTERVAL DOUBLE , GPNUMBER1 DOUBLE , GPNUMBER2 DOUBLE , GPSTRING1 VARCHAR(20) , GPSTRING2 VARCHAR(20) , ALERT_ID DOUBLE , ALERT_TYPE VARCHAR(10) , COEFFICIENT1 DOUBLE , COEFFICIENT2 DOUBLE , COEFFICIENT3 DOUBLE , COEFFICIENT4 DOUBLE , COEFFICIENT5 DOUBLE , REFERENCE_1 DOUBLE , REFERENCE_2 DOUBLE , DATA_EXCH_NUM VARCHAR(100) , MIKE11_LABEL_1 VARCHAR(50) , MIKE11_LABEL_2 VARCHAR(50) , NO_ALARM_INTERVAL DOUBLE , MBBASE_REGISTER INT , MBREGISTER_TYPE INT , MBTAG_TYPE INT , MBMSW INT , USE_REJECT_LOW VARCHAR(1) , REJECT_LOW_LIMIT DOUBLE , USE_REJECT_HIGH VARCHAR(1) , REJECT_HIGH_LIMIT DOUBLE , CONSTRAINT SITSEN_PK PRIMARY KEY (SENSORNAME,STE_STATION_ID), CONSTRAINT SITSEN_STE_FK FOREIGN KEY (STE_STATION_ID) REFERENCES XC_SITES (STATION_ID) ): Running... [6, 19:15:23] CREATE TABLE XC_SITESENSORS ( STE_STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , ENABLED VARCHAR(1) NOT NULL , DATA_TABLE VARCHAR(12) NOT NULL , TAGNAME VARCHAR(15) , RAWLIST VARCHAR(30) , RIGHT_DIGIT INT , LEFT_DIGIT INT , IS_TEXT VARCHAR(7) , ROUNDOFF_TIME INT , DATA_STORE_INTERVAL INT , UNITS VARCHAR(10) , TEMPLATE_NAME VARCHAR(50) , STATUS INT , DESCRIPTION VARCHAR(32) , MANUFACTURER VARCHAR(20) , MODEL_NUMBER VARCHAR(20) , SHEF_PE_CODE VARCHAR(7) , PARAMETER_CODE VARCHAR(12) , ALT_PARAMETER_CODE_1 VARCHAR(12) , ALT_PARAMETER_CODE_2 VARCHAR(12) , EQUATION VARCHAR(128) , RATING_TABLE VARCHAR(128) , OFFSET DOUBLE , SHIFT DOUBLE , HIGH_HIGH_LIMIT DOUBLE , HIGH_HIGH_ALARM INT , HIGH_LIMIT DOUBLE , HIGH_ALARM INT , LOW_LIMIT DOUBLE , LOW_ALARM INT , LOW_LOW_LIMIT DOUBLE , LOW_LOW_ALARM INT , ROC_LIMIT DOUBLE , ROC_ALARM INT , ROC_INTERVAL DOUBLE , DEADBAND DOUBLE , NO_CHANGE_INTERVAL DOUBLE , NO_CHANGE_ALARM INT , TEXT_LIMIT VARCHAR(9) , TEXT_ALARM INT , STD_DEV_LIMIT DOUBLE , STD_DEV_ALARM INT , STD_DEV_INTERVAL DOUBLE , AVG_LIMIT DOUBLE , AVG_ALARM INT , AVG_INTERVAL DOUBLE , GPNUMBER1 DOUBLE , GPNUMBER2 DOUBLE , GPSTRING1 VARCHAR(20) , GPSTRING2 VARCHAR(20) , ALERT_ID DOUBLE , ALERT_TYPE VARCHAR(10) , COEFFICIENT1 DOUBLE , COEFFICIENT2 DOUBLE , COEFFICIENT3 DOUBLE , COEFFICIENT4 DOUBLE , COEFFICIENT5 DOUBLE , REFERENCE_1 DOUBLE , REFERENCE_2 DOUBLE , DATA_EXCH_NUM VARCHAR(100) , MIKE11_LABEL_1 VARCHAR(50) , MIKE11_LABEL_2 VARCHAR(50) , NO_ALARM_INTERVAL DOUBLE , MBBASE_REGISTER INT , MBREGISTER_TYPE INT , MBTAG_TYPE INT , MBMSW INT , USE_REJECT_LOW VARCHAR(1) , REJECT_LOW_LIMIT DOUBLE , USE_REJECT_HIGH VARCHAR(1) , REJECT_HIGH_LIMIT DOUBLE , CONSTRAINT SITSEN_PK PRIMARY KEY (SENSORNAME,STE_STATION_ID), CONSTRAINT SITSEN_STE_FK FOREIGN KEY (STE_STATION_ID) REFERENCES XC_SITES (STATION_ID) ): 0 row(s) affected [7, 19:15:23] CREATE TABLE XC_DATA1 ( STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , ORIG_VALUE DOUBLE NOT NULL , ED_VALUE DOUBLE , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , FLAG4 VARCHAR(1) , HIGH_HIGH_FLAG INT , HIGH_FLAG INT , LOW_FLAG INT , LOW_LOW_FLAG INT , ROC_FLAG INT , NO_CHG_FLAG INT , ALARM_FLAG INT , STD_DEV_FLAG INT , AVG_FLAG INT , CONSTRAINT DAT1_PK PRIMARY KEY ( TIME_TAG , SOURCE , STATION_ID, SENSORNAME ) ): Running... [7, 19:15:24] CREATE TABLE XC_DATA1 ( STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , ORIG_VALUE DOUBLE NOT NULL , ED_VALUE DOUBLE , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , FLAG4 VARCHAR(1) , HIGH_HIGH_FLAG INT , HIGH_FLAG INT , LOW_FLAG INT , LOW_LOW_FLAG INT , ROC_FLAG INT , NO_CHG_FLAG INT , ALARM_FLAG INT , STD_DEV_FLAG INT , AVG_FLAG INT , CONSTRAINT DAT1_PK PRIMARY KEY ( TIME_TAG , SOURCE , STATION_ID, SENSORNAME ) ): 0 row(s) affected [8, 19:15:24] CREATE TABLE XC_TXTDATA1 ( STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , TEXT_VALUE VARCHAR(255) NOT NULL , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , FLAG4 VARCHAR(1) , MESSAGE_STATUS VARCHAR(2) , TXT_ALARM_FLAG INT , CONSTRAINT TXD1_PK PRIMARY KEY (TIME_TAG ,SOURCE ,STATION_ID ,SENSORNAME) ): Running... [8, 19:15:24] CREATE TABLE XC_TXTDATA1 ( STATION_ID VARCHAR(30) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , TEXT_VALUE VARCHAR(255) NOT NULL , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , FLAG4 VARCHAR(1) , MESSAGE_STATUS VARCHAR(2) , TXT_ALARM_FLAG INT , CONSTRAINT TXD1_PK PRIMARY KEY (TIME_TAG ,SOURCE ,STATION_ID ,SENSORNAME) ): 0 row(s) affected [9, 19:15:24] CREATE TABLE XC_GOESQC ( NESDIS_ID VARCHAR(8) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , STATION_ID VARCHAR(30) , FAILURE_CODE VARCHAR(1) , SIG_STRENGTH DOUBLE , FREQ_OFFSET DOUBLE , MOD_INDEX VARCHAR(1) , MOD_QUAL VARCHAR(1) , CHANNEL INT , SAT_LOC VARCHAR(1) , UC_STATUS VARCHAR(2) , MESSAGE_LEN INT , ACTUAL_LEN INT , PARITY INT , BUFFER_EMPTY INT , BATTERY_VOLTAGE DOUBLE , SPARE1 DOUBLE , SPARE2 DOUBLE , CONSTRAINT GOESQC_PK PRIMARY KEY (NESDIS_ID ,TIME_TAG ,SOURCE) ): Running... [9, 19:15:25] CREATE TABLE XC_GOESQC ( NESDIS_ID VARCHAR(8) NOT NULL , TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(1) NOT NULL , STATION_ID VARCHAR(30) , FAILURE_CODE VARCHAR(1) , SIG_STRENGTH DOUBLE , FREQ_OFFSET DOUBLE , MOD_INDEX VARCHAR(1) , MOD_QUAL VARCHAR(1) , CHANNEL INT , SAT_LOC VARCHAR(1) , UC_STATUS VARCHAR(2) , MESSAGE_LEN INT , ACTUAL_LEN INT , PARITY INT , BUFFER_EMPTY INT , BATTERY_VOLTAGE DOUBLE , SPARE1 DOUBLE , SPARE2 DOUBLE , CONSTRAINT GOESQC_PK PRIMARY KEY (NESDIS_ID ,TIME_TAG ,SOURCE) ): 0 row(s) affected [10, 19:15:25] CREATE TABLE XC_RTUQC ( STATION_ID VARCHAR(30) NOT NULL , TIME_TAG DATETIME NOT NULL , RX_TX VARCHAR(1) NOT NULL , PORT VARCHAR(30) , SEQUENCENUM DOUBLE , OPCODE DOUBLE , STATUS INT , RETRIES INT , GOOD INT , BAD INT , CRC INT , BATTERY_VOLTAGE DOUBLE , SPARE1 DOUBLE , SPARE2 DOUBLE , CONSTRAINT RTU_PK PRIMARY KEY ( STATION_ID, TIME_TAG, RX_TX ) ): Running... [10, 19:15:25] CREATE TABLE XC_RTUQC ( STATION_ID VARCHAR(30) NOT NULL , TIME_TAG DATETIME NOT NULL , RX_TX VARCHAR(1) NOT NULL , PORT VARCHAR(30) , SEQUENCENUM DOUBLE , OPCODE DOUBLE , STATUS INT , RETRIES INT , GOOD INT , BAD INT , CRC INT , BATTERY_VOLTAGE DOUBLE , SPARE1 DOUBLE , SPARE2 DOUBLE , CONSTRAINT RTU_PK PRIMARY KEY ( STATION_ID, TIME_TAG, RX_TX ) ): 0 row(s) affected [11, 19:15:25] CREATE TABLE XC_PPLIST ( STATION_ID VARCHAR(30) NOT NULL , DATA_LABEL VARCHAR(20) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , FUNCTION_NAME VARCHAR(10) NOT NULL , CONSTRAINT PPLIST_PK PRIMARY KEY (STATION_ID ,SENSORNAME ,DATA_LABEL ,FUNCTION_NAME) ): Running... [11, 19:15:25] CREATE TABLE XC_PPLIST ( STATION_ID VARCHAR(30) NOT NULL , DATA_LABEL VARCHAR(20) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , FUNCTION_NAME VARCHAR(10) NOT NULL , CONSTRAINT PPLIST_PK PRIMARY KEY (STATION_ID ,SENSORNAME ,DATA_LABEL ,FUNCTION_NAME) ): 0 row(s) affected [12, 19:15:25] CREATE TABLE XC_PPDATA1 ( STATION_ID VARCHAR(30) NOT NULL , DATA_LABEL VARCHAR(20) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , FUNCTION_NAME VARCHAR(10) NOT NULL , TIME_TAG DATETIME NOT NULL , TIME_PERIOD DOUBLE NOT NULL , PP_VALUE DOUBLE NOT NULL , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , VALUE_TIME_TAG DATETIME , PROCESS_TIME_TAG DATETIME NOT NULL , ALTERNATE_LABEL VARCHAR(20) , CONSTRAINT PPDAT1_PK PRIMARY KEY (STATION_ID ,SENSORNAME ,DATA_LABEL ,FUNCTION_NAME ,TIME_TAG ,TIME_PERIOD) ): Running... [12, 19:15:26] CREATE TABLE XC_PPDATA1 ( STATION_ID VARCHAR(30) NOT NULL , DATA_LABEL VARCHAR(20) NOT NULL , SENSORNAME VARCHAR(15) NOT NULL , FUNCTION_NAME VARCHAR(10) NOT NULL , TIME_TAG DATETIME NOT NULL , TIME_PERIOD DOUBLE NOT NULL , PP_VALUE DOUBLE NOT NULL , FLAG1 VARCHAR(1) , FLAG2 VARCHAR(1) , FLAG3 VARCHAR(1) , VALUE_TIME_TAG DATETIME , PROCESS_TIME_TAG DATETIME NOT NULL , ALTERNATE_LABEL VARCHAR(20) , CONSTRAINT PPDAT1_PK PRIMARY KEY (STATION_ID ,SENSORNAME ,DATA_LABEL ,FUNCTION_NAME ,TIME_TAG ,TIME_PERIOD) ): 0 row(s) affected [13, 19:15:26] CREATE TABLE XC_SITESENSORSDECODE ( STATION VARCHAR(30) NOT NULL , SENSOR VARCHAR(15) NOT NULL , TOPIC VARCHAR(25) NOT NULL , SEQNUM INT NOT NULL , ENABLED VARCHAR(1) NOT NULL , FORMAT VARCHAR(10) , RELATIVE_TIME VARCHAR(1) , RELATIVE_POS VARCHAR(1) , ADD_BASE VARCHAR(1) , BYTE_SIZE INT , BIT_SIZE INT , BOUND1 INT , BOUND2 INT , BLOCK_ID VARCHAR(50) , BYTE_POS INT , BIT_POS INT , NEXT INT , BIT_NEXT INT , AMOUNT INT , DELTA_TIME INT , OFFSET_TIME INT , ROUNDOFF_TIME INT , SKIP_BLANK INT , SKIP_COMMA INT , SKIP_LF INT , SKIP_PLUS INT , IGNORE_CASE VARCHAR(1) , TEMPLATE_NAME VARCHAR(50) , CONSTRAINT SITSENDCD_PK PRIMARY KEY (STATION, SENSOR, TOPIC, SEQNUM) ): Running... [13, 19:15:26] CREATE TABLE XC_SITESENSORSDECODE ( STATION VARCHAR(30) NOT NULL , SENSOR VARCHAR(15) NOT NULL , TOPIC VARCHAR(25) NOT NULL , SEQNUM INT NOT NULL , ENABLED VARCHAR(1) NOT NULL , FORMAT VARCHAR(10) , RELATIVE_TIME VARCHAR(1) , RELATIVE_POS VARCHAR(1) , ADD_BASE VARCHAR(1) , BYTE_SIZE INT , BIT_SIZE INT , BOUND1 INT , BOUND2 INT , BLOCK_ID VARCHAR(50) , BYTE_POS INT , BIT_POS INT , NEXT INT , BIT_NEXT INT , AMOUNT INT , DELTA_TIME INT , OFFSET_TIME INT , ROUNDOFF_TIME INT , SKIP_BLANK INT , SKIP_COMMA INT , SKIP_LF INT , SKIP_PLUS INT , IGNORE_CASE VARCHAR(1) , TEMPLATE_NAME VARCHAR(50) , CONSTRAINT SITSENDCD_PK PRIMARY KEY (STATION, SENSOR, TOPIC, SEQNUM) ): 0 row(s) affected [14, 19:15:26] CREATE TABLE XC_POLLGROUPS ( GROUP_NUM VARCHAR(2) NOT NULL , ENABLED VARCHAR(1) NOT NULL , STATION_LIST VARCHAR(2000) NULL , BASE_TIME INTEGER NULL , `INTERVAL` INTEGER NULL , POLL_TYPE INT NULL , CONTROL VARCHAR(128) NULL , CONTROL_ONLY VARCHAR(1) NULL , TIME_SYNC INTEGER NULL , TIME_SYNC_PORT VARCHAR(5) NULL , TIME_LIMIT DATE NULL , OVERRIDE_ORDER VARCHAR(1) NULL , DESCRIPTION VARCHAR(30) NULL , CLIENTS VARCHAR(255) NULL , LOG_FILE VARCHAR(20) NULL , LOG_FILE_PATH VARCHAR(50) NULL , OWNER VARCHAR(20) NULL , RESET_RTABLE VARCHAR(1) NULL, CONSTRAINT POLLGROUPS_PK PRIMARY KEY (GROUP_NUM) ): Running... [14, 19:15:26] CREATE TABLE XC_POLLGROUPS ( GROUP_NUM VARCHAR(2) NOT NULL , ENABLED VARCHAR(1) NOT NULL , STATION_LIST VARCHAR(2000) NULL , BASE_TIME INTEGER NULL , `INTERVAL` INTEGER NULL , POLL_TYPE INT NULL , CONTROL VARCHAR(128) NULL , CONTROL_ONLY VARCHAR(1) NULL , TIME_SYNC INTEGER NULL , TIME_SYNC_PORT VARCHAR(5) NULL , TIME_LIMIT DATE NULL , OVERRIDE_ORDER VARCHAR(1) NULL , DESCRIPTION VARCHAR(30) NULL , CLIENTS VARCHAR(255) NULL , LOG_FILE VARCHAR(20) NULL , LOG_FILE_PATH VARCHAR(50) NULL , OWNER VARCHAR(20) NULL , RESET_RTABLE VARCHAR(1) NULL, CONSTRAINT POLLGROUPS_PK PRIMARY KEY (GROUP_NUM) ): 0 row(s) affected [15, 19:15:26] CREATE TABLE XC_USERS ( USER_NAME VARCHAR(15) NOT NULL , PASSWORD VARCHAR(64) NOT NULL , DESCRIPTION VARCHAR(64) NULL , USER_ACCESS VARCHAR(30) NULL , CONSTRAINT USERS_PK PRIMARY KEY (USER_NAME) ): Running... [15, 19:15:27] CREATE TABLE XC_USERS ( USER_NAME VARCHAR(15) NOT NULL , PASSWORD VARCHAR(64) NOT NULL , DESCRIPTION VARCHAR(64) NULL , USER_ACCESS VARCHAR(30) NULL , CONSTRAINT USERS_PK PRIMARY KEY (USER_NAME) ): 0 row(s) affected [16, 19:15:27] CREATE TABLE XC_LOG ( TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(20) NOT NULL , DESCRIPTION VARCHAR(128) NULL , CONSTRAINT LOG_PK PRIMARY KEY (TIME_TAG, SOURCE) ): Running... [16, 19:15:27] CREATE TABLE XC_LOG ( TIME_TAG DATETIME NOT NULL , SOURCE VARCHAR(20) NOT NULL , DESCRIPTION VARCHAR(128) NULL , CONSTRAINT LOG_PK PRIMARY KEY (TIME_TAG, SOURCE) ): 0 row(s) affected [17, 19:15:27] CREATE TABLE XC_TEMPLATES ( TEMPLATE_NAME VARCHAR(45) NOT NULL , TEMPLATE_TYPE INTEGER NULL , CONSTRAINT TEMPLATES_PK PRIMARY KEY (TEMPLATE_NAME) ): Running... [17, 19:15:27] CREATE TABLE XC_TEMPLATES ( TEMPLATE_NAME VARCHAR(45) NOT NULL , TEMPLATE_TYPE INTEGER NULL , CONSTRAINT TEMPLATES_PK PRIMARY KEY (TEMPLATE_NAME) ): 0 row(s) affected [18, 19:15:27] CREATE TABLE XC_LASTVALUES( STATION_ID VARCHAR(30) NOT NULL, SENSORNAME VARCHAR(15) NOT NULL, TIME_TAG DATETIME NOT NULL, IS_TEXT VARCHAR(7) NULL, NUM_VALUE DOUBLE NULL, TEXT_VALUE VARCHAR(255) NULL, PRIMARY KEY(STATION_ID,SENSORNAME) ): Running... [18, 19:15:28] CREATE TABLE XC_LASTVALUES( STATION_ID VARCHAR(30) NOT NULL, SENSORNAME VARCHAR(15) NOT NULL, TIME_TAG DATETIME NOT NULL, IS_TEXT VARCHAR(7) NULL, NUM_VALUE DOUBLE NULL, TEXT_VALUE VARCHAR(255) NULL, PRIMARY KEY(STATION_ID,SENSORNAME) ): 0 row(s) affected [19, 19:15:28] CREATE TABLE XC_RECORDIDS( STE_STATION_ID VARCHAR(30) NOT NULL , RECORD_ID VARCHAR(10) NOT NULL , SENSORS VARCHAR(255) NULL , CONSTRAINT RECORDIDS_PK PRIMARY KEY (STE_STATION_ID, RECORD_ID) ): Running... [19, 19:15:28] CREATE TABLE XC_RECORDIDS( STE_STATION_ID VARCHAR(30) NOT NULL , RECORD_ID VARCHAR(10) NOT NULL , SENSORS VARCHAR(255) NULL , CONSTRAINT RECORDIDS_PK PRIMARY KEY (STE_STATION_ID, RECORD_ID) ): 0 row(s) affected [20, 19:15:28] CREATE TABLE XC_VER ( VERSION INT ): Running... [20, 19:15:28] CREATE TABLE XC_VER ( VERSION INT ): 0 row(s) affected [21, 19:15:28] INSERT INTO XC_VER VALUES ( 104 ): Running... [21, 19:15:29] INSERT INTO XC_VER VALUES ( 104 ): 1 row(s) affected [1, 11:50:55] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Running... [1, 11:50:55] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Fetching... [1, 11:50:55] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : 1000 row(s) returned [1, 12:30:52] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Running... [1, 12:30:52] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Fetching... [1, 12:30:52] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : 1000 row(s) returned [2, 12:32:38] SELECT * FROM xc_data.xc_data1 where TIME_TAG'2019-02-28': Running... [2, 12:32:38] SELECT * FROM xc_data.xc_data1 where TIME_TAG'2019-02-28': Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2019-02-28'' at line 1 [3, 12:32:49] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' LIMIT 0, 1000 : Running... [3, 12:32:49] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' LIMIT 0, 1000 : Fetching... [3, 12:32:49] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' LIMIT 0, 1000 : 9 row(s) returned [4, 12:36:26] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 3 CODAR' LIMIT 0, 1000 : Running... [4, 12:36:26] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 3 CODAR' LIMIT 0, 1000 : Fetching... [4, 12:36:26] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 3 CODAR' LIMIT 0, 1000 : 0 row(s) returned [5, 12:36:39] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 3 KALAY' LIMIT 0, 1000 : Running... [5, 12:36:39] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 3 KALAY' LIMIT 0, 1000 : Fetching... [5, 12:36:39] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 3 KALAY' LIMIT 0, 1000 : 0 row(s) returned [6, 12:37:49] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Running... [6, 12:37:49] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Fetching... [6, 12:37:49] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : 1000 row(s) returned [7, 14:58:44] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 3 KALAY' LIMIT 0, 1000 : Running... [7, 14:58:44] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 3 KALAY' LIMIT 0, 1000 : Fetching... [7, 14:58:44] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 3 KALAY' LIMIT 0, 1000 : 0 row(s) returned [8, 14:58:49] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 3 KALAY' LIMIT 0, 1000 : Running... [8, 14:58:49] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 3 KALAY' LIMIT 0, 1000 : Fetching... [8, 14:58:49] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 3 KALAY' LIMIT 0, 1000 : 0 row(s) returned [9, 14:58:50] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Running... [9, 14:58:50] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Fetching... [9, 14:58:51] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : 1000 row(s) returned [10, 14:59:02] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 5 SULCORNA' LIMIT 0, 1000 : Running... [10, 14:59:02] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 5 SULCORNA' LIMIT 0, 1000 : Fetching... [10, 14:59:02] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2019-02-28' and STATION_ID='AWS 5 SULCORNA' LIMIT 0, 1000 : 0 row(s) returned [11, 15:00:27] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-09-28' and STATION_ID='AWS 5 SULCORNA' LIMIT 0, 1000 : Running... [11, 15:00:27] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-09-28' and STATION_ID='AWS 5 SULCORNA' LIMIT 0, 1000 : Fetching... [11, 15:00:27] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-09-28' and STATION_ID='AWS 5 SULCORNA' LIMIT 0, 1000 : 0 row(s) returned [12, 15:00:39] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Running... [12, 15:00:39] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Fetching... [12, 15:00:39] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : 1000 row(s) returned [13, 15:00:52] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-09-28' and STATION_ID='AWS 2 OLD GOA' LIMIT 0, 1000 : Running... [13, 15:00:52] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-09-28' and STATION_ID='AWS 2 OLD GOA' LIMIT 0, 1000 : Fetching... [13, 15:00:52] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-09-28' and STATION_ID='AWS 2 OLD GOA' LIMIT 0, 1000 : 0 row(s) returned [14, 15:01:31] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-09-28' and STATION_ID='AWS 2 PERNEM' LIMIT 0, 1000 : Running... [14, 15:01:31] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-09-28' and STATION_ID='AWS 2 PERNEM' LIMIT 0, 1000 : Fetching... [14, 15:01:31] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-09-28' and STATION_ID='AWS 2 PERNEM' LIMIT 0, 1000 : 0 row(s) returned [15, 15:01:43] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-09-28' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : Running... [15, 15:01:43] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-09-28' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : Fetching... [15, 15:01:43] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-09-28' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : 0 row(s) returned [16, 15:03:36] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-11-28' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : Running... [16, 15:03:36] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-11-28' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : Fetching... [16, 15:03:36] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-11-28' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : 0 row(s) returned [17, 15:03:48] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-30-28' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : Running... [17, 15:03:48] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-30-28' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : Fetching... [17, 15:03:48] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-30-28' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : 0 row(s) returned [18, 15:04:41] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-11-02' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : Running... [18, 15:04:41] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-11-02' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : Fetching... [18, 15:04:41] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-11-02' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : 0 row(s) returned [19, 15:07:08] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Running... [19, 15:07:08] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Fetching... [19, 15:07:08] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : 1000 row(s) returned [20, 15:07:24] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-11-02' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : Running... [20, 15:07:24] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-11-02' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : Fetching... [20, 15:07:24] SELECT * FROM xc_data.xc_data1 where TIME_TAG='2018-11-02' and STATION_ID='AWS 2 CODAR' LIMIT 0, 1000 : 0 row(s) returned [1, 15:35:10] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Running... [1, 15:35:10] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : Fetching... [1, 15:35:11] SELECT * FROM xc_data.xc_data1 LIMIT 0, 1000 : 1000 row(s) returned [2, 15:36:24] SELECT * FROM xc_data.xc_data1 where TIME_TAG="2019-08-14 17:57:00" LIMIT 0, 1000 : Running... [2, 15:36:24] SELECT * FROM xc_data.xc_data1 where TIME_TAG="2019-08-14 17:57:00" LIMIT 0, 1000 : Fetching... [2, 15:36:24] SELECT * FROM xc_data.xc_data1 where TIME_TAG="2019-08-14 17:57:00" LIMIT 0, 1000 : 74 row(s) returned