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

[Brian Johnson]

I would think that null WOULD be a distinct value for one record

Anyway .. discussion closed, code will use "not null" field types



Kai Hofmann (address@hidden) wrote:
>
>
>> 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/
>
>
>
>_______________________________________________
>Phpgroupware-developers mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>

--
Brian Johnson
* This is where my witty signature line would be if I bothered to edit this 
line :) *