<?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 `tempTable_5064055747748356029`.`questId` AS `questId`,`tempTable_5064055747748356029`.`name` AS `name`,`tempTable_5064055747748356029`.`dialogue` AS `dialogue`,`tempTable_5725043308792478204`.`personId` AS `personId`  FROM (SELECT * FROM `sourcedb1`.`quest`%%00010) `tempTable_5064055747748356029` JOIN (SELECT * FROM `sourcedb1`.`questParticipation`%%00010) `tempTable_5725043308792478204` ON `tempTable_5064055747748356029`.`questId`=`tempTable_5725043308792478204`.`questId`"/>
<config key="knimeSpec">
<entry key="spec_name" type="xstring" value="database"/>
<entry key="number_columns" type="xint" value="4"/>
<config key="column_spec_0">
<entry key="column_name" type="xstring" value="questId"/>
<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="name"/>
<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="dialogue"/>
<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_3">
<entry key="column_name" type="xstring" value="personId"/>
<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>
<config key="dbSpec">
<config key="dbCol_0">
<entry key="colName" type="xstring" value="questId"/>
<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="name"/>
<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="dialogue"/>
<entry key="colTypeName" type="xstring" value="TEXT"/>
<entry key="colType" type="xstring" value="LONGVARCHAR"/>
</config>
<config key="dbCol_3">
<entry key="colName" type="xstring" value="personId"/>
<entry key="colTypeName" type="xstring" value="INT"/>
<entry key="colType" type="xstring" value="INTEGER"/>
</config>
</config>
</config>
</config>
