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
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
