[otrs] Database Schema

[Stephen Martin]

Is the OTRS database schema documented anywhere? If so, where?

--
Stephen Martin
Management Concepts
http://www.ManagementConcepts.com
703.270.4096

[s taylor]

Hello.

I haven't run across anything other than the files that created the tables
themselves:

in the OTRS subdir's 'scripts' and 'scripts/database' folders, are the .sql
files that created the tables for the various databases. For example, for
mysql, in the 'scripts/database' folder, is a file named,
"otrs-schema.mysql.sql". The upgrade file version is located in the
'scripts' folder.

Another way is, of course, via phpAdmin.

Hope this provides you with a starting point...

[Edgar Meij]

It's a bit old, but still relevant:
http://www.mail-archive.com/***@otrs.org/msg05487.html

Maybe a search of the mailinglist next time ;-)?

hth, Edgar

Post by s taylor
Hello.
I haven't run across anything other than the files that created the tables
in the OTRS subdir's 'scripts' and 'scripts/database' folders, are the .sql
files that created the tables for the various databases. For example, for
mysql, in the 'scripts/database' folder, is a file named,
"otrs-schema.mysql.sql". The upgrade file version is located in the
'scripts' folder.
Another way is, of course, via phpAdmin.
Hope this provides you with a starting point...
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/