[dev] scripts/databases/otrs-schema.mysql.sql / foreign keys?

[Martin Edenhofer]

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