[Phpgroupware-cvs] phpgroupware/notes/setup/tables.xml, 1.1.2.1

[nomail]

Update of /phpgroupware/notes/setup
Added Files:
        Branch: proposal-branch
          tables.xml

date: 2004/04/16 21:22:00;  author: seek3r;  state: Exp;  lines: +24 -0

Log Message:
bringing savannah cvs back up to date with what we were doing on our private 
cvs server. We will not be doing dev from this cvs tree
=====================================================================
<?xml version="1.0"?>
<schema version="0.2">
        <table name="phpgw_notes">
                <desc>Table for notes</desc>
                <field name="note_id" type="I">
                        <descr>A unique ID assigned to each record.</descr>
                        <KEY />
                        <AUTOINCREMENT />
                        <NOTNULL />
                </field>
                <field name="note_owner" type="I"><NOTNULL /></field>
                <field name="note_access" type="C" size="7"><NOTNULL /></field>
                <field name="note_dm_type" type="C" size="1"><NOTNULL /></field>
                <field name="note_category" type="I"><NOTNULL /></field>
                <field name="note_content" type="X"><NOTNULL /></field>
                <field name="note_modified" type="T"><NOTNULL /></field>
                <field name="note_created" type="T"><NOTNULL /></field>
                <index name="note_id">
                        <descr>Put a unique index on note_id</descr>
                        <col>note_id</col>
                        <UNIQUE />
                </index>
        </table>
</schema>