t/data/xml/schema-basic.xml

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <!--
   3 Created by SQL::Translator::Producer::XML
   4 Created on Fri Aug  1 11:24:58 2003
   5
   6  -->
   7
   8 <sqlf:schema xmlns:sqlf="http://sqlfairy.sourceforge.net/sqlfairy.xml">
   9
  10   <sqlf:table>
  11     <sqlf:name>Basic</sqlf:name>
  12     <sqlf:order>1</sqlf:order>
  13     <sqlf:fields>
  14       <sqlf:field>
  15         <sqlf:name>id</sqlf:name>
  16         <sqlf:is_primary_key>1</sqlf:is_primary_key>
  17         <sqlf:is_auto_increment>1</sqlf:is_auto_increment>
  18         <sqlf:data_type>int</sqlf:data_type>
  19         <sqlf:size>10</sqlf:size>
  20         <sqlf:order>1</sqlf:order>
  21       </sqlf:field>
  22       <sqlf:field>
  23         <sqlf:name>title</sqlf:name>
  24         <sqlf:data_type>varchar</sqlf:data_type>
  25         <sqlf:size>100</sqlf:size>
  26         <sqlf:default_value>hello</sqlf:default_value>
  27         <sqlf:order>2</sqlf:order>
  28       </sqlf:field>
  29       <sqlf:field>
  30                 <sqlf:name>description</sqlf:name>
  31         <sqlf:data_type>text</sqlf:data_type>
  32         <sqlf:is_nullable>1</sqlf:is_nullable>
  33         <sqlf:order>3</sqlf:order>
  34       </sqlf:field>
  35       <sqlf:field>
  36             <sqlf:name>email</sqlf:name>
  37         <sqlf:data_type>varchar</sqlf:data_type>
  38                 <sqlf:size>255</sqlf:size>
  39         <sqlf:order>4</sqlf:order>
  40       </sqlf:field>
  41         </sqlf:fields>
  42
  43         <sqlf:indices>
  44       <sqlf:index>
  45             <sqlf:fields>title</sqlf:fields>
  46         <sqlf:name>titleindex</sqlf:name>
  47         <sqlf:type>NORMAL</sqlf:type>
  48       </sqlf:index>
  49     </sqlf:indices>
  50
  51         <sqlf:constraints>
  52       <sqlf:constraint>
  53         <sqlf:deferrable>1</sqlf:deferrable>
  54         <sqlf:fields>email</sqlf:fields>
  55         <sqlf:name>emailuniqueindex</sqlf:name>
  56         <sqlf:type>UNIQUE</sqlf:type>
  57       </sqlf:constraint>
  58     </sqlf:constraints>
  59   </sqlf:table>
  60
  61 </sqlf:schema>