home *** CD-ROM | disk | FTP | other *** search
/ PC Professionell 2005 June / PCpro_2005_06.ISO / files / opensource / xamp / xampp-win32.exe / xampp / driver_test.schema < prev    next >
Encoding:
Extensible Markup Language  |  2004-03-24  |  1.5 KB  |  36 lines
  1. <?xml version="1.0" encoding="ISO-8859-1" ?>
  2. <!--
  3.      driver_test.schema
  4.  
  5.      @(#) $Header: /repository/pear/MDB/tests/driver_test.schema,v 1.1 2002/03/22 20:20:47 lsmith Exp $
  6.  
  7.   -->
  8.  
  9. <database>
  10.  
  11.  <name><variable>name</variable></name>
  12.  <create><variable>create</variable></create>
  13.  
  14.  
  15.  <table>
  16.   <name>users</name>
  17.   <declaration>
  18.    <field> <name>user_name</name>     <type>text</type>      <length>12</length>                       </field>
  19.    <field> <name>user_password</name> <type>text</type>                                                </field>
  20.    <field> <name>subscribed</name>    <type>boolean</type>                                             </field>
  21.    <field> <name>user_id</name>       <type>integer</type>   <default>0</default> <notnull>1</notnull> </field>
  22.    <field> <name>quota</name>         <type>decimal</type>                                             </field>
  23.    <field> <name>weight</name>        <type>float</type>                                               </field>
  24.    <field> <name>access_date</name>   <type>date</type>                                                </field>
  25.    <field> <name>access_time</name>   <type>time</type>                                                </field>
  26.    <field> <name>approved</name>      <type>timestamp</type>                                           </field>
  27.    <index>
  28.     <name>users_id_index</name>
  29.     <unique>1</unique>
  30.     <field> <name>user_id</name> </field>
  31.    </index>
  32.   </declaration>
  33.  </table>
  34.  
  35. </database>
  36.