PHP Classes

File: driver_test.schema

Recommend this page to a friend!
  Classes of Manuel Lemos   Metabase   driver_test.schema   Download  
File: driver_test.schema
Role: Auxiliary data
Content type: text/plain
Description: Driver class conformance test database schema description.
Class: Metabase
PHP Database abstraction layer RDBMS independent
Author: By
Last change: Added a unique index to the user_id field of the users table.
Date: 12 years ago
Size: 1,500 bytes
 

Contents

Class file image Download
<?xml version="1.0" encoding="ISO-8859-1" ?> <!-- driver_test.schema @(#) $Header: /opt2/ena/metal/metabase/driver_test.schema,v 1.3 2002/01/19 08:41:36 mlemos Exp $ --> <database> <name><variable>name</variable></name> <create><variable>create</variable></create> <table> <name>users</name> <declaration> <field> <name>user_name</name> <type>text</type> <length>12</length> </field> <field> <name>user_password</name> <type>text</type> </field> <field> <name>subscribed</name> <type>boolean</type> </field> <field> <name>user_id</name> <type>integer</type> <default>0</default> <notnull>1</notnull> </field> <field> <name>quota</name> <type>decimal</type> </field> <field> <name>weight</name> <type>float</type> </field> <field> <name>access_date</name> <type>date</type> </field> <field> <name>access_time</name> <type>time</type> </field> <field> <name>approved</name> <type>timestamp</type> </field> <index> <name>users_id_index</name> <unique>1</unique> <field> <name>user_id</name> </field> </index> </declaration> </table> </database>