RT MySQL Database Structure

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)

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”.

http://www.oreilly.com/catalog/rtessentials/

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

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 http://wiki.bestpractical.com/index.cgi?DBSchema

Steve