[Phpgroupware-cvs] phpgwapi/inc/adodb/tests/xmlschema.xml, 1.2

[nomail]

Update of /phpgwapi/inc/adodb/tests
Added Files:
        Branch: 
          xmlschema.xml

date: 2004/12/30 06:47:33;  author: skwashd;  state: Exp;  lines: +30 -0

Log Message:
new HEAD
=====================================================================
<?xml version="1.0"?>
<schema version="0.2">
  <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>
    <index name="myindex">
      <col>row1</col>
      <col>row2</col>
    </index>
  </table>
  <sql>
    <descr>SQL to be executed only on specific platforms</descr>
    <query platform="postgres|postgres7">
      insert into mytable ( row1, row2 ) values ( 12, 'postgres stuff' )
    </query>
    <query platform="mysql">
      insert into mytable ( row1, row2 ) values ( 12, 'mysql stuff' )
    </query>
  </sql>
  <table name="obsoletetable">
    <DROP/>
  </table>
</schema>