[dev] horde_alarms primary key

[Didi Rieder]

--On Friday, February 23, 2007 02:23:56 PM +0100 Jan Schneider 
<jan at horde.org> wrote:

> Zitat von Didi Rieder <adrieder at sbox.tugraz.at>:
>
>> Hi,
>>
>> there is a problem with the key length when using a mySQL 4.0.27
>> DB-backend:
>>
>> ALTER TABLE horde_alarms ADD PRIMARY KEY (alarm_id, alarm_uid);
>> ERROR 1071: Specified key was too long. Max key length is 500
>
> Ah, these old MySQL versions again.
>
>> I don't think it is possible to change the my key length in mySQL 4.0
>>
>> Any hint, other than upgrading, which is not possible for us right now?
>
> Shorten the alarm_id and alarm_uid fields to 250 bytes.

OK, I'll do that. I hope, that these ids won't be longer than 250, then....

Didi

-- 
---------------------------------
Didi Rieder
adrieder at sbox.tugraz.at
PGPKey ID: 3431D0B0
---------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.horde.org/archives/dev/attachments/20070223/72b9a322/attachment.bin