[dev] horde_alarms primary key

[Jan Schneider]

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.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/