Hi! With OTRS you don't need to access the database directly, except in very rare occasions (disaster recovery, corrupted tables, etc). To disable the default queues you have 2 options: - Rename them to something usefull for you. - Disable them, so they won't be shown (mark as invalid in admin interface). Anyway, they can be used for things not related directly to your clients, as 'Junk' to store spam (and delete it automatically with the generic agent) or "Postmaster" to store system or administrative messages. Also, it's usefull to have some test queues, to test all kind of things without disturbing your clients queues. I've renamed 'Raw' and 'Misc' as 'TestQ1' and TestQ2' ;-) Regards, On 27 May 2005 at 10:26, Jerome Alet wrote:
Hi,
I've setup the OTRS 1.3.2p01-5 Debian package and it now works like a charm with PostgreSQL. OTRS is really great stuff !
Now I'm wondering : I'd like to propose to customers the choice between only two queues with names I'll choose, but actually there are several predefined queues : 'Raw', 'Junk', 'Postmaster' and 'Misc' which are of no interest to me.
I've read the documentation, especially "What is a ticket queue" section, but it doesn't seem to explain if these predefined queues are needed or not.
I'd like to delete them if possible (this I know how to do), but what happens if I delete these predefined queues ?
Now another question : the PostgreSQL database schema doesn't contain statements to ensure the database integrity when someone tries to do some manual modifications : for example (with my need), if I delete from table 'queue' and still have datas matching the deleted queues in 'personal_queues' the database is incoherent, but a foreign key which references the other table would have prevented this to happen.
So is this sort of things fixed in the 2.0 branch ?
Thanks to all in advance
Jerome Alet _______________________________________________ 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/
--- Victor R. Rodriguez Departamento de Sistemas Valoraciones del Mediterraneo, S.A. ---