Is the OTRS database schema documented anywhere? If so, where? -- Stephen Martin Management Concepts http://www.ManagementConcepts.com 703.270.4096
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...
It's a bit old, but still relevant:
http://www.mail-archive.com/otrs@otrs.org/msg05487.html
Maybe a search of the mailinglist next time ;-)?
hth, Edgar
On 4/28/05, 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...
_______________________________________________ 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/
-- 'An approximate answer to the right question is worth a great deal more than a precise answer to the wrong question'
participants (3)
-
Edgar Meij -
s taylor -
Stephen Martin