[rt-users] Adding columns, changing variable names for rt2 table

Mike Patterson map at eecs.berkeley.edu
Tue Nov 12 17:37:45 EST 2002


1) I would like to add several columns to the "rt2.Ticket" table.  I 
assume that the mysql statements used (inserts, selects, etc) are 
written based on variable name rather than order the columns are in 
(because if they're not adding columns would be problematic).  Am I 
correct in assuming that column order doesn't matter?

2) I would like to change the name of the variable "id" to "job_num" and 
fix all references to "id" to use "job_num" instead as well as 
references to "Ticket" table to use "jobreq" table instead.  Is there 
one central configuration file I use can change to do that?  If not 
which files would I need to modify?

3) Also what is the difference between "id" and "EffectiveID"?

Why am I doing this you ask?
I am adding RT to our existing custom "job request" (mysql PHP) system.
I would like the numbering to be consistent and allow RT to update 
"Tickets" on our original system and allow our original system to update 
RT.  The only way I can think to do that is to add the RT tables to our 
"job request" database and make it use one shared column for numbering 
(e.g. if we get "job request" to original system it gets assigned Ticket 
#1013, another request to RT gets #1014, etc..).

Help regarding locations of these files or better yet a better way to do 
that are appreciated (e.g. can I do the equivalent of 
symlinking/aliasing tables and column names from mysql itself rather 
than changing DB structure and perl scripts that reference it?)

snippet of rt2.Tickets table pasted below:
===========================================
mysql> desc Tickets;
+------------+--------------+------+-----+--------------+------------+
| Field      | Type         | Null | Key | Default      | Extra
+------------+--------------+------+-----+--------------+------------+
| id         | int(11)      |      | PRI | NULL         | auto_increment
| EffectiveId| int(11)      | YES  | MUL | NULL         |
===========================================




More information about the rt-users mailing list