PHP Classes

File: test.schema

Recommend this page to a friend!
  Classes of Manuel Lemos   Metabase   test.schema   Download  
File: test.schema
Role: Auxiliary data
Content type: text/plain
Description: Test database schema definition in Metabase XML format
Class: Metabase
PHP Database abstraction layer RDBMS independent
Author: By
Last change: Changed the main table to use an autoincrement field instead of a sequence.
Date: 12 years ago
Size: 1,680 bytes
 

Contents

Class file image Download 
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!--
     test.schema

     @(#) $Header: /opt2/ena/metal/metabase/test.schema,v 1.5 2005/09/08 05:51:17 mlemos Exp $

  -->

<database>

 <name>test</name>
 <create><variable>create</variable></create>

 <table>
  <name>users</name>
  <declaration>
   <field> <name>id</name>            <autoincrement>1</autoincrement>                                               </field>
   <field> <name>user_name</name>     <type>text</type> <length>20</length> <notnull>1</notnull> <default></default> </field>
   <field> <name>user_password</name> <type>text</type>                                                              </field>
   <field> <name>reminder</name>      <type>text</type>                                                              </field>
   <field> <name>name</name>          <type>text</type>                                                              </field>
   <field> <name>email</name>         <type>text</type>                                                              </field>

   <index>
    <name>user_name_index</name>
    <unique>1</unique>
    <field> <name>user_name</name> </field>
   </index>

  </declaration>
 </table>

 <table>
  <name>groups</name>
  <declaration>
   <field> <name>name</name>        <type>text</type> </field>
   <field> <name>owner_id</name>    <type>text</type> </field>
   <field> <name>description</name> <type>text</type> </field>
  </declaration>
 </table>

 <table>
  <name>group_users</name>
  <declaration>
   <field> <name>group_id</name> <type>text</type> </field>
   <field> <name>user_id</name>  <type>text</type> </field>
  </declaration>
 </table>

</database>