Queues with the same name
Moderator: crythias
Queues with the same name
can I modify db to have two or more different queues with the same name? to recognize them, I will use the ID and the comment fields. have I to modify the otrs-schema.mysql.sql file?
OTRS 3.1.6 on ubuntu with MySQL
Re: Queues with the same name
I modified otrs-schema.mysql.sql
I added the field 'id' to create a couple of unique data for the index. can it create problems?
is it better to make index not unique and maintain only the field 'name'?
Code: Select all
UNIQUE INDEX queue_name (id,name)
is it better to make index not unique and maintain only the field 'name'?
OTRS 3.1.6 on ubuntu with MySQL
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Queues with the same name
For what purpose will you do this? (Summary: don't do this. If you want to reuse a name, make the name a subqueue.)
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask