<?xml version="1.0" encoding="UTF-8"?>
<config xmlns="http://www.knime.org/2008/09/XMLConfig" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.knime.org/2008/09/XMLConfig http://www.knime.org/XMLConfig_2008_09.xsd" key="DBSession">
    <config key="Session Info">
        <entry key="sessionID" type="xstring" value="f0564083-a9e5-4e76-9dce-21ff8d370c8c"/>
        <entry key="dbTypeId" type="xstring" value="mysql"/>
        <entry key="dialectId" type="xstring" value="mysql"/>
    </config>
    <config key="Driver Definition">
        <entry key="driverId" type="xstring" value="built-in-mysql-8.0.29"/>
        <entry key="driverName" type="xstring" value="Driver for MySQL v.8.0.29"/>
        <entry key="driverVersion" type="xstring" value="8.0.0"/>
        <entry key="driverClass" type="xstring" value="com.mysql.cj.jdbc.Driver"/>
        <entry key="driverDescription" type="xstring" value=""/>
        <entry key="driverOrigin" type="xstring" value="EXTENSION"/>
        <entry key="deprecated" type="xboolean" value="false"/>
    </config>
    <config key="Attributes"/>
    <config key="DBData">
        <entry key="sqlQuery" type="xstring" value="SELECT * FROM (SELECT * FROM `weatherdata`.`test_table`%%00010) AS `table`"/>
        <config key="knimeSpec">
            <entry key="spec_name" type="xstring" value="database"/>
            <entry key="number_columns" type="xint" value="7"/>
            <config key="column_spec_0">
                <entry key="column_name" type="xstring" value="RecDate"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.time.localdatetime.LocalDateTimeCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
            <config key="column_spec_1">
                <entry key="column_name" type="xstring" value="WindDir"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.def.DoubleCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
            <config key="column_spec_2">
                <entry key="column_name" type="xstring" value="SLPressure"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.def.DoubleCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
            <config key="column_spec_3">
                <entry key="column_name" type="xstring" value="Date_part"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.time.localdate.LocalDateCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
            <config key="column_spec_4">
                <entry key="column_name" type="xstring" value="Comments"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.def.StringCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
            <config key="column_spec_5">
                <entry key="column_name" type="xstring" value="Imputed"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.def.StringCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
            <config key="column_spec_6">
                <entry key="column_name" type="xstring" value="Method"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.def.StringCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
        </config>
        <config key="dbSpec">
            <config key="dbCol_0">
                <entry key="colName" type="xstring" value="RecDate"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="DATETIME"/>
                <entry key="colType" type="xstring" value="TIMESTAMP"/>
            </config>
            <config key="dbCol_1">
                <entry key="colName" type="xstring" value="WindDir"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="DECIMAL"/>
                <entry key="colType" type="xstring" value="DECIMAL"/>
            </config>
            <config key="dbCol_2">
                <entry key="colName" type="xstring" value="SLPressure"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="DECIMAL"/>
                <entry key="colType" type="xstring" value="DECIMAL"/>
            </config>
            <config key="dbCol_3">
                <entry key="colName" type="xstring" value="Date_part"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="DATE"/>
                <entry key="colType" type="xstring" value="DATE"/>
            </config>
            <config key="dbCol_4">
                <entry key="colName" type="xstring" value="Comments"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="VARCHAR"/>
                <entry key="colType" type="xstring" value="VARCHAR"/>
            </config>
            <config key="dbCol_5">
                <entry key="colName" type="xstring" value="Imputed"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="VARCHAR"/>
                <entry key="colType" type="xstring" value="VARCHAR"/>
            </config>
            <config key="dbCol_6">
                <entry key="colName" type="xstring" value="Method"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="VARCHAR"/>
                <entry key="colType" type="xstring" value="VARCHAR"/>
            </config>
        </config>
    </config>
</config>
