RE: [Phpgroupware-developers] phpgwapi/setup scripts .. can table have a two field pk with both fields as nullable?

[Kai Hofmann]

> In MySql Primary Keys are not allowed to be nullable. What 
> about useing 
> an odinary value of 0 instead of null. This would work.

A primary key is distinct - so it can not be null in ANY database!
Using 0 as a value for it works for excatly one entry.
So its not possible to have more than one column of a primary key with the
same value.

Greetings

   Kai

-- 
*****    Open Source und Linux im professionellen Einsatz    *****
**  komplexe Mailserver, Groupware, Office: sprechen Sie uns an **
Dipl.-Inform. Kai Hofmann                    Team Softwarelösungen
pro|business AG, EXPO Plaza 1 (Deutscher Pavillon), 30539 Hannover
E-Mail: address@hidden,   Tel.: 0511/60066-332, Fax: -355
WWW: http://www.probusiness.de/