Reason for Field filename in FAQ->createArticle
Hello, I want to use the faqs in my otrs installation... Can anyone tell me what's the reason for the field "filename" in FAQ? Why is the "filename" the primary Key in the mySQL-Table? I thought faq-articles where supposed to be stored in the database and not in the filesystem. Is it a problem for future releases when I make the filename-field in mySQL an auto_increment field? Another question: Is is possible to use attachments in faq-articles? thanks in advance! Volker
On Friday, February 20, 2004 10:21 AM
Maibaum, Volker
Can anyone tell me what's the reason for the field "filename" in FAQ?
There's no concrete reason, it's just there.
Why is the "filename" the primary Key in the mySQL-Table?
It isn't. The primary key is 'id', 'f_name' is just a unique value to not double it among the faq items.
I thought faq-articles where supposed to be stored in the database and not in the filesystem.
You're right. Nonetheless there is the FAQ name, although one might consider it somewhat useless, because it doesn't get displayed, nor can you search after it.
Is it a problem for future releases when I make the filename-field in mySQL an auto_increment field?
Yes, this will pose a problem, because you cannot assign specific values to an auto-increment field, but that's what the source does: It assigns f_name when creating and updating the entry.
Another question: Is is possible to use attachments in faq-articles?
Not atm, sorry. hth, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
participants (2)
-
Maibaum, Volker -
Robert Kehl