Preferences documentation for PTS 12/02/96 --------------------------------------------------------- $Id: prefs,v 1.1.1.1 1997/06/17 17:33:52 shevett Exp $ --------------------------------------------------------- The 'prefs' table within PTS contains default and user- specific data for all users within the system. The structure of the table is: +-----------------+----------+--------+----------+-----+ | Field | Type | Length | Not Null | Key | +-----------------+----------+--------+----------+-----+ | login | char | 10 | N | N | | flag | char | 10 | N | N | | cvalue | char | 40 | N | N | | ivalue | int | 4 | N | N | +-----------------+----------+--------+----------+-----+ The fields are: 'login' The username this preference belongs to. If it is set to 'default', all pages will have that value set unless there is one specific to the user. 'flag' The name of the variable being set. 'cvalue' A character value. 'ivalue' An integer value. Currently all defaults within PTS are characters, so ivalue should be NULL for everything. Variables supported: +------------+------------+------------------------------------------+ | login | flag | cvalue | +------------+------------+------------------------------------------+ | default | bgcolor | #CCCCCC | | default | projmail | no | | default | taskmail | no | | default | _dataset | NULL | | default | _tech | NULL | | default | _expand | no | | default | bgproject | #00A020 | | default | fgproject | #FFFF00 | | default | bgcolumn | #A62A2A | | default | fgcolumn | #F5CCB0 | | default | bgheader | #0000FF | | default | fgheader | #FFFF00 | | default | fgcolor | #000000 | +------------+------------+------------------------------------------+ Summary: bgcolor, etc are self explanatory. _expand yes/no whether the default behavior is to show a browse window 'expanded' to show subtasks or subprojects or not. _tech (any valid login name or 'all') The default login name to show projects / tasks for in the primary browse screen, unless otherwise specified. Useful for a 'guest' login where the user would want to see 'all' users and all projects. _dataset (tasks / projects) Sets the default for the browse screen, whether to display tasks or projects, unless otherwise specified. taskmail (yes/no) Send mail to this user whenever a change happens to a task they own. projmail (yes/no) Send mail to this user whenever a change happens to a project they own.