t/data/xml/schema-basic-attribs.xml

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <!--
   3 Created by SQL::Translator::Producer::SqlfXML
   4 Created on Fri Aug 15 15:08:18 2003
   5
   6  -->
   7
   8 <sqlt:schema xmlns:sqlt="http://sqlfairy.sourceforge.net/sqlfairy.xml">
   9   <sqlt:table order="1" name="Basic">
  10     <sqlt:fields>
  11         <sqlt:field
  12             name="id"
  13             is_primary_key="1"
  14             is_foreign_key="0"
  15             size="10"
  16             data_type="int"
  17             is_auto_increment="1"
  18             order="1"
  19             is_nullable="0" />
  20       <sqlt:field is_primary_key="0" is_foreign_key="0" name="title" size="100" is_auto_increment="0" data_type="varchar" order="2" default_value="hello" is_nullable="0" />
  21       <sqlt:field is_primary_key="0" is_foreign_key="0" name="description" size="0" is_auto_increment="0" data_type="text" order="3" default_value="" is_nullable="1" />
  22       <sqlt:field is_primary_key="0" is_foreign_key="0" name="email" size="255" is_auto_increment="0" data_type="varchar" order="4" is_nullable="1" />
  23       <sqlt:field is_primary_key="0" is_foreign_key="0" name="explicitnulldef" size="0" is_auto_increment="0" data_type="varchar" order="5" is_nullable="1" />
  24       <sqlt:field is_primary_key="0" is_foreign_key="0" name="explicitemptystring" size="0" is_auto_increment="0" data_type="varchar" order="6" default_value="" is_nullable="1" />
  25       <sqlt:field is_primary_key="0" is_foreign_key="0" name="emptytagdef" size="0" is_auto_increment="0" data_type="varchar" order="7" default_value="" is_nullable="1" />
  26     </sqlt:fields>
  27     <sqlt:indices>
  28       <sqlt:index options="" name="titleindex" fields="title" type="NORMAL" />
  29     </sqlt:indices>
  30     <sqlt:constraints>
  31         <sqlt:constraint
  32             name="" type="PRIMARY KEY" fields="id"
  33             reference_table="" options="" deferrable="1"
  34             match_type="" expression="" on_update="" on_delete=""
  35         />
  36       <sqlt:constraint options="" match_type="" deferrable="1" name="emailuniqueindex" on_update="" reference_table="" on_delete="" fields="email" expression="" type="UNIQUE" />
  37     </sqlt:constraints>
  38   </sqlt:table>
  39 </sqlt:schema>