<?xml version="1.0"?>
<schema>
  <table name="mytable">
    <field name="row1" type="I">
      <descr>An integer row that's a primary key and autoincrements</descr>
      <KEY/>
      <AUTOINCREMENT/>
    </field>
    <field name="row2" type="C" size="16">
      <descr>A 16 character varchar row that can't be null</descr>
      <NOTNULL/>
    </field>
  </table>
  <index name="myindex" table="mytable">
    <col>row1</col>
    <col>row2</col>
  </index>
  <sql>
    <descr>SQL to be executed only on specific platforms</descr>
    <query platform="postgres|postgres7">
      insert into mytable ( row1, row2 ) values ( 12, 'stuff' )
    </query>
    <query platform="mysql">
      insert into mytable ( row1, row2 ) values ( 12, 'different stuff' )
    </query>
  </sql>
  <table name="obsoletetable"><DROP/></table>
  <index name="obsoleteindex"><DROP/></index>
</schema>
