[Tickets #7146] Create MySQL 5 SQL scripts using VARCHAR(MAX)

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/7146
------------------------------------------------------------------------------
  Ticket             | 7146
  Created By         | Chuck Hagenbuch <chuck at horde.org>
  Summary            | Create MySQL 5 SQL scripts using VARCHAR(MAX)
  Queue              | Horde Base
  Version            | HEAD
  Type               | Enhancement
  State              | Accepted
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


Chuck Hagenbuch <chuck at horde.org> (2008-08-02 19:10) wrote:

A number of places where we currently use TEXT fields in database  
tables don't really need BLOB-size data size - horde_perms.perm_data  
for example. With MySQL 5, VARCHARs can be nearly 64k, which is  
plenty, and per http://arjen-lentz.livejournal.com/126316.html, will  
prevent some temp table usage which will speed up permissions queries.  
We should create db-specific fields that make use of that -  
.mysql5.sql for example - for relevant databases.