[Tickets #5280] a fix for alarm sql scripts under MySQL

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=5280
-----------------------------------------------------------------------
 Ticket             | 5280
 Created By         | vilius at lnk.lt
 Summary            | a fix for alarm sql scripts under MySQL
 Queue              | Horde Base
 Version            | HEAD
 Type               | Bug
 State              | Unconfirmed
 Priority           | 1. Low
 Owners             | 
+New Attachment     | alarm.patch
-----------------------------------------------------------------------


vilius at lnk.lt (2007-04-21 12:31) wrote:

Under MySQL installations where default charset is UTF-8 VARCHAR(250) +
VARCHAR(250) is 1500 bytes long. However even newest MySQL doesn't support
more than 1000 bytes for primary keys (see
http://bugs.mysql.com/bug.php?id=4541). I made a little bit smaller
alarm_uid field and a lot smaller alarm_id because it is not so important
as alarm_uid and in most extreme cases will be shorter as first part of
the uid is always fixed.