[rt-users] Adding columns to the Users table?

[Russ Roff]

RT 3.0.9, MySQL

Can anyone give me any suggestions about how to add additional columns of data to the 'Users' table?  I can certainly do this via SQL and make accompanying changes to the html interface, but I suspect there is a better method.  I'd rather not lump them all into the Exra Info or Comments sections if possible, as they'll be tougher to use later.  I need to add additional items (like Supervisor, Department, Employee ID number, etc.) that can be used later in custom scrips (I'm planning a scrip called Escalate, which will change ownership of a ticket to a person's supervisor when the status is changed from "Open" to "Escalate" for example).

Thanks,

Russ

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20040309/94fd543e/attachment.htm>