phpMyAdmin can provide a detailed look at the current table definition (if you have the needed permissions).
In practice, this is unused, with the exception of the "m_user_create" field.
Field | Notes |
---|---|
user_id | the ID of the person this applies to. |
real_name | unused |
password | If password starts with 'md5=', then the rest of the string is an MD5 hash of the clear-text password. |
unused | |
phone | unused |
office | unused |
department | MFCF addition |
comments | unused |
admin_rt | TRUE → allows table data to be dumped. |
date_updated | |
mail_trans | MFCF addition: mail user on transaction |
m_user_create | TRUE → mail someone when an item is created with their ID mentioned in the list of requestors. |