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

[nomail]

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

date: 2004/04/16 21:22:00;  author: seek3r;  state: Exp;  lines: +30 -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_tasks">
                <desc>Table for the task manager</desc>
                <field name="task_id" type="I">
                        <descr>A unique ID assigned to each record.</descr>
                        <KEY />
                        <AUTOINCREMENT />
                        <NOTNULL />
                </field>
                <field name="task_owner" type="I"><NOTNULL /></field>
                <field name="task_responsible" type="I"><NOTNULL /></field>
                <field name="task_access" type="C" size="7"><NOTNULL /></field>
                <field name="task_status" type="I"><NOTNULL /></field>
                <field name="task_category" type="I"><NOTNULL /></field>
                <field name="task_dm_type" type="C" size="1"><NOTNULL /></field>
                <field name="task_subject" type="C" size="60"><NOTNULL 
/></field>
                <field name="task_description" type="X"><NOTNULL /></field>
                <field name="task_priority" type="I"><NOTNULL /></field>
                <field name="task_start" type="T"><NOTNULL /></field>
                <field name="task_end" type="T"><NOTNULL /></field>
                <field name="task_modified" type="T"><NOTNULL /></field>
                <field name="task_created" type="T"><NOTNULL /></field>
                <index name="task_id">
                        <descr>Put a unique index on task_id</descr>
                        <col>task_id</col>
                        <UNIQUE />
                </index>
        </table>
</schema>