home *** CD-ROM | disk | FTP | other *** search
/ Enter 2004 June / ENTER.ISO / files / xampp-win32-1.4.5-installer.exe / xampp / test.schema < prev    next >
Encoding:
Extensible Markup Language  |  2004-03-24  |  1.7 KB  |  55 lines
  1. <?xml version="1.0" encoding="ISO-8859-1" ?>
  2. <!--
  3.      test.schema
  4.  
  5.      @(#) $Header: /repository/pear/MDB/tests/test.schema,v 1.1 2002/03/22 20:20:47 lsmith Exp $
  6.  
  7.   -->
  8.  
  9. <database>
  10.  
  11.  <name>test</name>
  12.  <create><variable>create</variable></create>
  13.  
  14.  <table>
  15.   <name>users</name>
  16.   <declaration>
  17.    <field> <name>user_id</name>       <type>integer</type> <default>0</default> <notnull>1</notnull> </field>
  18.    <field> <name>user_name</name>     <type>text</type>                                              </field>
  19.    <field> <name>user_password</name> <type>text</type>                                              </field>
  20.    <field> <name>reminder</name>      <type>text</type>                                              </field>
  21.    <field> <name>name</name>          <type>text</type>                                              </field>
  22.    <field> <name>email</name>         <type>text</type>                                              </field>
  23.    <index>
  24.     <name>users_id_index</name>
  25.     <unique>1</unique>
  26.     <field> <name>user_id</name> </field>
  27.    </index>
  28.   </declaration>
  29.  </table>
  30.  
  31.  <sequence>
  32.   <name>user_id</name>
  33.   <start>1</start>
  34.   <on> <table>users</table> <field>user_id</field> </on>
  35.  </sequence>
  36.  
  37.  <table>
  38.   <name>groups</name>
  39.   <declaration>
  40.    <field> <name>name</name>        <type>text</type> </field>
  41.    <field> <name>owner_id</name>    <type>text</type> </field>
  42.    <field> <name>description</name> <type>text</type> </field>
  43.   </declaration>
  44.  </table>
  45.  
  46.  <table>
  47.   <name>group_users</name>
  48.   <declaration>
  49.    <field> <name>group_id</name> <type>text</type> </field>
  50.    <field> <name>user_id</name>  <type>text</type> </field>
  51.   </declaration>
  52.  </table>
  53.  
  54. </database>
  55.