SV: [rt-users] Table relations in RT

[Hilde T Lauvset Rafaelsen]

Hi,

We want to have a registration form outside RT where users can
registrate and report about problems. The reason we want this is because
some users (we are at a university) use the phone instead of using RT
and email.

The info the user registrates in the application form is registrated in
the RT database and will pop up as a new ticket in our main queue.

I know it is not recommended to interact directly with the database, but
the application form is strongly wanted from my leaders.

Hilde 

-----Opprinnelig melding-----
Fra: Ruslan Zakirov [mailto:ruslan.zakirov at gmail.com] 
Sendt: 31. august 2005 17:32
Til: Hilde T Lauvset Rafaelsen
Kopi: rt-users at lists.bestpractical.com
Emne: Re: [rt-users] Table relations in RT

On 8/31/05, Hilde T Lauvset Rafaelsen <hilde.rafaelsen at cc.uit.no> wrote:
> Hi,
> 
> When a new Ticket is created in RT which tables are updated? Is a new
item insertet in Principals, CachedGroupMembers, GroupMembers and Groups
every time a new ticket is created?
Yes, RT always creates role groups while Ticket creation.

> 
> I have looked at the RT database schema and tried to analyze the
relation between all tables, but isn't 100% sure I understand
everything. It would have been helpful if I could have looked at an
insert example, but I don't know where all the insert, select and delete
queries are hide in RT.
> 
Did you see DBSchema on the wiki?

> Hope anyone can help me here.
I think no one can help you becuase we don't know what are you trying to
do. Direct interactions with RT DB are not recommended. RT development
process doesn't guaranty any compatibility of the DB schema in future
versions. RT API is backward-compatible in most cases.

> 
> --
> Hilde
> 

--
Best regards, Ruslan.