<?xml version="1.0"?>

<sqlgg>
 <stmt name="create_profiles" sql="create table profiles (id int, host text, today_count int)" category="DDL" kind="create" target="profiles" cardinality="0">
  <in/>
  <out/>
 </stmt>
 <stmt name="select_1" sql="select id, host, if(@x &lt; now() - interval 1 day, 0, today_count) from profiles" category="DQL" kind="select" cardinality="n">
  <in>
   <value name="x" type="Datetime"/>
  </in>
  <out>
   <value name="id" type="Int" nullable="true"/>
   <value name="host" type="Text" nullable="true"/>
   <value name="_2" type="Int" nullable="true"/>
  </out>
 </stmt>
 <table name="profiles">
  <schema>
   <value name="id" type="Int" nullable="true"/>
   <value name="host" type="Text" nullable="true"/>
   <value name="today_count" type="Int" nullable="true"/>
  </schema>
 </table>
</sqlgg>
