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?
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?
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 |