<?xml version="1.0" encoding="UTF-8"?>
<component name="dataSourceStorage">
  <data-source source="LOCAL" name="MySQL - tasks@localhost" uuid="c2a557d7-ac30-4c20-8f83-36bdbba56509">
    <database-info product="MySQL" version="5.5.27" jdbc-version="4.0" driver-name="MySQL Connector Java" driver-version="mysql-connector-java-5.1.31 ( Revision: alexander.soklakov@oracle.com-20140520065950-groqzzbvxprqdmnz )">
      <extra-name-characters>#@</extra-name-characters>
      <identifier-quote-string>`</identifier-quote-string>
    </database-info>
    <case-sensitivity plain-identifiers="lower" quoted-identifiers="lower"/>
    <schema name="" catalog="tasks"/>
    <table name="arbeitstage" schema="" catalog="tasks" type="TABLE">
      <column name="bundesland" sqlType="VARCHAR" length="5" precision="0" nullable="false" jdbcType="12" def="Jyc="/>
      <column name="datum" sqlType="DATE" length="10" precision="0" nullable="false" jdbcType="91" def="JzAwMDAtMDAtMDAn"/>
      <column name="wochentag" sqlType="VARCHAR" length="5" precision="0" nullable="false" jdbcType="12" def="Jyc="/>
      <column name="feiertag" sqlType="VARCHAR" length="50" precision="0" nullable="false" jdbcType="12" def="Jyc="/>
      <column name="mofr" sqlType="TINYINT" length="3" precision="0" nullable="false" jdbcType="-6" def="MA=="/>
      <column name="mosa" sqlType="TINYINT" length="3" precision="0" nullable="false" jdbcType="-6" def="MA=="/>
      <column name="moso" sqlType="TINYINT" length="3" precision="0" nullable="false" jdbcType="-6" def="MA=="/>
      <column name="diso" sqlType="TINYINT" length="3" precision="0" nullable="false" jdbcType="-6" def="MA=="/>
      <primary-key name="PRIMARY" columns="bundesland,datum"/>
    </table>
    <table name="kunden" schema="" catalog="tasks" type="TABLE">
      <column name="kunde" sqlType="VARCHAR" length="50" precision="0" nullable="false" jdbcType="12"/>
      <column name="system" sqlType="VARCHAR" length="50" precision="0" nullable="false" jdbcType="12"/>
      <column name="start" sqlType="TIME" length="8" precision="0" nullable="false" jdbcType="92"/>
      <column name="ende" sqlType="TIME" length="8" precision="0" nullable="false" jdbcType="92"/>
      <column name="erster_status" sqlType="DATE" length="10" precision="0" nullable="false" jdbcType="91"/>
      <column name="aktiv" sqlType="TINYINT" length="3" precision="0" nullable="false" jdbcType="-6" def="MQ=="/>
      <column name="woche" sqlType="VARCHAR" length="10" precision="0" nullable="false" jdbcType="12" def="J01vLVNhJw=="/>
      <column name="bundesland" sqlType="VARCHAR" length="5" precision="0" nullable="false" jdbcType="12" def="J0hFJw=="/>
      <primary-key name="PRIMARY" columns="kunde"/>
    </table>
    <table name="statusmail" schema="" catalog="tasks" type="TABLE">
      <column name="kunde" sqlType="VARCHAR" length="50" precision="0" nullable="false" jdbcType="12"/>
      <column name="datum" sqlType="DATE" length="10" precision="0" nullable="false" jdbcType="91"/>
      <column name="start" sqlType="TIME" length="8" precision="0" nullable="false" jdbcType="92"/>
      <column name="ende" sqlType="TIME" length="8" precision="0" nullable="false" jdbcType="92"/>
      <column name="logdatei" sqlType="TEXT" length="65535" precision="0" nullable="false" jdbcType="-1"/>
      <column name="fehlerbericht" sqlType="TEXT" length="65535" precision="0" nullable="false" jdbcType="-1"/>
      <column name="anzahl" sqlType="TINYINT" length="3" precision="0" nullable="false" jdbcType="-6"/>
      <column name="bearbeitet" sqlType="TINYINT" length="3" precision="0" nullable="false" jdbcType="-6"/>
      <column name="kommentar" sqlType="TEXT" length="65535" precision="0" nullable="false" jdbcType="-1"/>
      <primary-key name="PRIMARY" columns="kunde,datum,start"/>
    </table>
  </data-source>
</component>