[Phpgroupware-cvs] property/setup/tables.xml, 1.3

[nomail]

Update of /property/setup
Added Files:
        Branch: 
          tables.xml

date: 2004/04/23 21:01:26;  author: sigurdne;  state: Exp;  lines: +0 -0

Log Message:
no message
=====================================================================
<?xml version="1.0"?>
<schema version="0.2">
        <table name="phpgw_property">
                <desc>Table for property</desc>
                <field name="property_id" type="I">
                        <descr>A unique ID assigned to each record.</descr>
                        <KEY/>
                        <AUTOINCREMENT/>
                        <NOTNULL/>
                </field>
                <field name="property_owner" type="I"><NOTNULL/></field>
                <field name="property_access" type="C" 
size="7"><NOTNULL/></field>
                <field name="property_category" type="I"><NOTNULL/></field>
                <field name="property_content" type="X"><NOTNULL/></field>
                <field name="property_modified" type="T"><NOTNULL/></field>
                <field name="property_created" type="T"><NOTNULL/></field>
                <index name="property_id">
                        <descr>Put a unique index on property_id</descr>
                        <col>property_id</col>
                        <UNIQUE/>
                </index>
        </table>
</schema>