Comment 4 for bug 824598

Data Storage Requirements are defined here:
  http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html
According to we get the following desired row size:
  varchars (255) has 89 instances at 4*255 bytes each
 datetime has 8 instances at 8 bytes each
 blob has 1 instance at 12 bytes
 binary(16) has 2 instances at 16 bytes each
 int (11) has 2 instances at 4 bytes each
which amounts to 90896 bytes which far exceeds the 65,535 byte limit.

One possible solution:
  There are 18 varchars(255) that also have an index on them... these are either the id , parentid, or those that we have a report limit associated to it. I suggest we change all the varchars (255) which do not have a key to text which requires only 12 bytes each. Doing so for this report we should have:
 varchars (255) has 18 instances at 4*255 bytes each
 text has 71 instances at 12 bytes each
 datetime has 8 instances at 8 bytes each
 blob has 1 instance at 12 bytes
 binary(16) has 2 instances at 16 bytes each
 int (11) has 2 instances at 4 bytes each
which should result in 19328 bytes.