Hi Alex, On Oct 19, 2007, at 6:52 AM, Alexander Scholler wrote:

what about all the foreign keys defined in scripts/databases/otrs- schema.mysql.sql? * Can they be used?

Yes. But it depends on your MySQL backend. MyISAM for example is not supporting foreign keys (of course in MyISAM you can enter the foreign keys syntax to create one, but nothing will be done in the backend). InnoDB for example is supporting foreign keys.

* What is the benefit (if I suppose that OTRS works on the DB always to leave it consistent although there are no foreign keys constraints defined)?

Yes. OTRS never deletes references. So if you only would use OTRS on the database you will be save. But if you of course it could be possible that OTRS or somebody else is doing an mistake. So in this case the database with foreign keys support would complain.

* What problems can occure?

Normally a database with foreign keys support is a little bit slower (because the database need to do much more checks). But that's all (IMO).

Bye, Alex

-Martin -- ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Address of record: Bad Homburg Local Court: Bad Homburg, HRB 10751 Tax number: 003/240/97521 Chairman: Burchard Steinbild Chief Executive Officer: André Mindermann