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

[nomail]

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

date: 2004/04/16 20:59:49;  author: seek3r;  state: Exp;  lines: +25 -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_wcm_articles">
                <desc>Table for holding the web content articles.</desc>
                <field name="article_id" type="I">
                        <descr>A unique ID assigned to each record.</descr>
                        <KEY/>
                        <AUTOINCREMENT/>
                        <NOTNULL/>
                </field>
                <field name="title" type="C" size="100"><NOTNULL/></field>
                <field name="section" type="C" size="25"><NOTNULL/></field>
                <field name="topic" type="C" size="25"><NOTNULL/></field>
                <field name="allow_comments" type="I"><NOTNULL/></field>
                <field name="short_story" type="C" size="255"></field>
                <field name="full_story" type="X"></field>
                <field name="notes" type="C" size="255"></field>
                <field name="posted" type="D"><NOTNULL/></field>
                <index name="article_id">
                        <descr>Put a unique index on the id</descr>
                        <col>article_id</col>
                        <UNIQUE/>
                </index>
        </table>
</schema>