Queues with the same name

Moderator: crythias

Locked
rschirin
Znuny newbie
Posts: 35
Joined: 16 Apr 2012, 18:25
Znuny Version: 3.1.2

Queues with the same name

Post by rschirin »

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
rschirin
Znuny newbie
Posts: 35
Joined: 16 Apr 2012, 18:25
Znuny Version: 3.1.2

Re: Queues with the same name

Post by rschirin »

I modified otrs-schema.mysql.sql

Code: Select all

UNIQUE INDEX queue_name (id,name) 
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'?
OTRS 3.1.6 on ubuntu with MySQL
crythias
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

Post by crythias »

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
Locked