UNIQUE project name definition

[gipsea]

Dear all,

I'm trying to use mantis as a kind of "bug tracker" but the situation I have is to have project with similar structure like:
proj name
-sub proj: purchase
-sub proj: production
-sub proj: after sales
and replicate the same structure to all my main project

sofar in the project table the name field is setted as UNIQUE, I can't do that (if I understand properly sql definitions). I can chenge this setting but I'm guessing that this would be effect badly on SQL select actions if they work only with the name field

Has by chances someone end up to the same problem and solved somehow?

thank you really much

ciao

gipsea