RT MySQL Database Structure

RT Developers
1

Hi everyone-

I am wondering if anyone has a write-up on the MySQL database
structure of RT. I’ve gone in and tried to get the general jist of it
but it seems pretty complex. I’m trying to perform a MySQL query from
PHP in order to graph some statistics. Seems like a bunch of people
use DBIx::SearchBuilder but I’d kind of like to write the thing with
php.

Thanks,
Alex

smime.p7s (2.32 KB)

2

Hello!On Fri, 2006-01-27 at 11:01, Alex Meyer wrote:

I am wondering if anyone has a write-up on the MySQL database
structure of RT. I’ve gone in and tried to get the general jist of it
but it seems pretty complex. I’m trying to perform a MySQL query from
PHP in order to graph some statistics. Seems like a bunch of people
use DBIx::SearchBuilder but I’d kind of like to write the thing with
php.

Best writeup I’ve seen is in the O’Reilly book, “RT Essentials”.

Available online in O’Reilly’s Safari bookshelf, which has a free 14-day
trial.

Cheers!

–j
Jim Meyer, Geek at Large purp@acm.org

3

At Friday 1/27/2006 02:01 PM, Alex Meyer wrote:

Hi everyone-

I am wondering if anyone has a write-up on the MySQL database
structure of RT. I’ve gone in and tried to get the general jist of it
but it seems pretty complex. I’m trying to perform a MySQL query from
PHP in order to graph some statistics. Seems like a bunch of people
use DBIx::SearchBuilder but I’d kind of like to write the thing with
php.

Thanks,
Alex

Ales,

See Request Tracker Wiki

Steve