Mysql question

flashingcurser · 07-18-2004, 10:34 AM

I'm trying to set up a mysql back end to proftpd -- I have a table for uid and gid

The problem is that when I try to add a user that has the same gid it gives me an error that number is already in the table. Now this is sort of fine for uid but for the guid it creates a problem. Many users need to be in the same gid.

Anyone know what mysql setting needs to be set so that the column in that table will alow duplicate entrys?

Oops I was writing guid when I ment gid -- sorry for the confusion

nephilim · 07-22-2004, 07:38 AM

The default option of a column is that it can hold duplicate values. If you make the column a primary key or add a UNIQUE constraint, than it can't hold duplicates.

I'm guessing in your case it's the first (primary key columns can NEVER have duplicates).

Maybe you should give a detailed explanation of your problem (table layouts, primary keys, foreign key relationships). That way we can help you out, right now it's all kind of blury.