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

[nomail]

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

date: 2004/04/17 06:24:31;  author: jengo;  state: Exp;  lines: +30 -0

Log Message:
Merged this over from the temp CVS server
=====================================================================
<?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>