<?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">
<entry key="dbSessionID" type="xstring" value="a911c043-b6fd-4933-a070-2ea0a30bdf22"/>
<config key="DBData">
<entry key="sqlQuery" type="xstring" value="SELECT `personId` AS `characterid`, `name` AS `charactername`, `mortal`  FROM (SELECT * FROM `sourcedb1`.`person`) AS `tempTable_1540473876716051561`"/>
<config key="knimeSpec">
<entry key="spec_name" type="xstring" value="database"/>
<entry key="number_columns" type="xint" value="3"/>
<config key="column_spec_0">
<entry key="column_name" type="xstring" value="characterid"/>
<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.IntCell"/>
</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="charactername"/>
<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_2">
<entry key="column_name" type="xstring" value="mortal"/>
<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.BooleanCell"/>
</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="characterid"/>
<entry key="colTypeName" type="xstring" value="INT"/>
<entry key="colType" type="xstring" value="INTEGER"/>
</config>
<config key="dbCol_1">
<entry key="colName" type="xstring" value="charactername"/>
<entry key="colTypeName" type="xstring" value="CHAR"/>
<entry key="colType" type="xstring" value="CHAR"/>
</config>
<config key="dbCol_2">
<entry key="colName" type="xstring" value="mortal"/>
<entry key="colTypeName" type="xstring" value="BIT"/>
<entry key="colType" type="xstring" value="BIT"/>
</config>
</config>
</config>
</config>
