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

[nomail]

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

date: 2004/04/16 20:59:49;  author: seek3r;  state: Exp;  lines: +194 -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_categories">
                <desc>Table for managing Category data.</desc>
                <field name="cat_id" type="I">
                        <descr>A unique ID assigned to each record.</descr>
                        <KEY/>
                        <AUTOINCREMENT/>
                        <NOTNULL/>
                </field>
                <field name="cat_main" type="I"><NOTNULL/></field>
                <field name="cat_parent" type="I"><NOTNULL/></field>
                <field name="cat_level" type="I"><NOTNULL/></field>
                <field name="cat_owner" type="I"><NOTNULL/></field>
                <field name="cat_location" type="C" 
size="100"><NOTNULL/></field>
                <field name="cat_name" type="C" size="150"><NOTNULL/></field>
                <field name="cat_access" type="C" size="7"><NOTNULL/><DEFAULT 
value="private"/></field>
                <field name="cat_description" type="C" 
size="255"><NOTNULL/></field>
                <field name="cat_data" type="X"><NOTNULL/></field>
                <field name="cat_modified" type="D"><NOTNULL/></field>
                <index name="history_id">
                        <descr>Put a unique index on the user name</descr>
                        <col>history_id</col>
                        <UNIQUE/>
                </index>
        </table>

        <table name="phpgw_datamine">
                <desc>Datamine, used to link application records together</desc>
                <field name="dm_id" type="I">
                        <descr>A unique ID assigned to record</descr>
                        <KEY/>
                        <AUTOINCREMENT/>
                        <NOTNULL/>
                </field>
                <field name="dm_owner" type="I"><NOTNULL/></field>
                <field name="dm_location_from" type="C" 
size="255"><NOTNULL/></field>
                <field name="dm_location_to" type="C" 
size="255"><NOTNULL/></field>
                <index name="dm_id">
                        <descr>Put a unique index on the datamine id</descr>
                        <col>dm_id</col>
                        <UNIQUE/>
                </index>
        </table>

        <table name="phpgw_datamine_locations">
                <desc>Location of ops used by datamine</desc>
                <field name="dml_id" type="I">
                        <descr>A unique ID assigned to record</descr>
                        <KEY/>
                        <AUTOINCREMENT/>
                        <NOTNULL/>
                </field>
                <!-- The dml_type is for future use, it might be removed 
however -->
                <field name="dml_type" type="C" size="1"><NOTNULL/></field>
                <field name="dml_title" type="C" size="255"><NOTNULL/></field>
                <field name="dml_op" type="C" size="255"><NOTNULL/></field>
                <index name="dml_id">
                        <descr>Put a unique index on the dml_id</descr>
                        <col>dml_id</col>
                        <UNIQUE/>
                </index>
        </table>

        <table name="phpgw_apps">
                <desc>Application list and versions.</desc>
                <field name="app_id" type="I">
                        <descr>A unique ID assigned to each app.</descr>
                        <KEY/>
                        <AUTOINCREMENT/>
                        <NOTNULL/>
                </field>
                <field name="app_name" type="C" 
size="50"><UNIQUE/><NOTNULL/></field>
                <field name="app_title" type="C" size="100"><NOTNULL/></field>
                <field name="app_version" type="C" size="10"><NOTNULL/></field>
                <field name="app_enabled" type="I"><NOTNULL/></field>
                <index name="app_id">
                        <descr>Put a unique index on the app id</descr>
                        <col>app_id</col>
                        <UNIQUE/>
                </index>
                <index name="app_name">
                        <descr>Put a unique index on the app name</descr>
                        <col>app_name</col>
                </index>
        </table>

        <table name="phpgw_accounts">
                <desc>A typical users table for our application.</desc>
                <field name="account_id" type="I">
                        <descr>A unique ID assigned to each account.</descr>
                        <KEY/>
                        <AUTOINCREMENT/>
                        <NOTNULL/>
                </field>
                <field name="account_lid" type="C" 
size="25"><UNIQUE/><NOTNULL/></field>
                <field name="account_pwd" type="C" size="32"><NOTNULL/></field>
                <field name="account_firstname" type="C" 
size="50"><NOTNULL/></field>
                <field name="account_lastname" type="C" 
size="50"><NOTNULL/></field>
                <field name="account_lastpwd_change" type="T"></field>
                <field name="account_status" type="C" 
size="1"><NOTNULL/><DEFAULT value="A"/></field>
                <field name="account_expires" type="T"><NOTNULL/></field>
                <field name="account_type" type="C" size="1"></field>
                <index name="account_id">
                        <descr>Put a unique index on the user id</descr>
                        <col>account_id</col>
                        <UNIQUE/>
                </index>
                <index name="account_lid">
                        <descr>Put a unique index on the user name</descr>
                        <col>account_lid</col>
                        <UNIQUE/>
                </index>
        </table>

        <table name="phpgw_history">
                <desc>Table for managing history data.</desc>
                <field name="history_id" type="I">
                        <descr>A unique ID assigned to each record.</descr>
                        <KEY/>
                        <AUTOINCREMENT/>
                        <NOTNULL/>
                </field>
                <field name="history_owner" type="I8"><NOTNULL/></field>
                <field name="history_location" type="C" 
size="50"><NOTNULL/></field>
                <field name="history_field" type="C" 
size="30"><NOTNULL/></field>
                <field name="history_action" type="C" 
size="1"><NOTNULL/></field>
                <field name="history_o_value" type="X"></field>
                <field name="history_n_value" type="X"><NOTNULL/></field>
                <field name="history_timestamp" type="T"></field>
                <index name="history_id">
                        <descr>Put a unique index on the user name</descr>
                        <col>history_id</col>
                        <UNIQUE/>
                </index>
        </table>


        <table name="phpgw_acl_locations">
                <desc>Table to store a list of all the major acl 
locations.</desc>
                <field name="loc_id" type="I">
                        <descr>A unique ID assigned to each record.</descr>
                        <KEY/>
                        <AUTOINCREMENT/>
                        <NOTNULL/>
                </field>
                <field name="loc_op" type="C" size="50"><NOTNULL/></field>
                <field name="loc_title" type="C" size="50"><NOTNULL/></field>
                <field name="loc_value" type="I"><NOTNULL/></field>
                <index name="loc_id">
                        <descr>Put a unique index on the id</descr>
                        <col>loc_id</col>
                        <UNIQUE/>
                </index>
                <index name="loc_op">
                        <descr>Put a unique index on the op to improve 
performance</descr>
                        <col>loc_op</col>
                </index>
        </table>

        <table name="phpgw_acl">
                <desc>Table to store the acl records.</desc>
                <field name="acl_host" type="I"><NOTNULL/></field>
                <field name="acl_account" type="I"><NOTNULL/></field>
                <field name="acl_op" type="C" size="50"><NOTNULL/></field>
                <field name="acl_isop" type="I"><NOTNULL/></field>
                <field name="acl_rights" type="I"><NOTNULL/></field>
                <field name="acl_type" type="I"></field>
                <field name="acl_data" type="X"></field>
        </table>

        <table name="phpgw_hooks">
                <desc>Table to store a the hooks.</desc>
                <field name="hook_name" type="C" size="100"><NOTNULL/></field>
                <field name="hook_op" type="C" size="100"><NOTNULL/></field>
                <index name="hook_op">
                        <descr>Put a unique index on the id</descr>
                        <col>hook_op</col>
                </index>
        </table>
        
        <table name="phpgw_prefs">
                <desc>Table to store a the user preferences.</desc>
                <field name="pref_app" type="C" size="50"><NOTNULL/></field>
                <field name="pref_name" type="C" size="100"><NOTNULL/></field>
                <field name="pref_value" type="C" size="100"></field>
                <field name="pref_account" type="C" size="15"><NOTNULL/></field>
                <index name="pref_account">
                        <descr>Put a unique index on the id</descr>
                        <col>pref_account</col>
                </index>
        </table>
        
</schema>