[users] val field length

[Michael Krieger]

Within the records table, the 'val' column is set up as a VARCHAR(100).  While this is perfect in most cases, a 'default' domainkeys signature ends up at 230 characters roughly (with a bit more if you set additional options).  SPF could in theory also grow if you want to add a whole load of IPs or networks to the record.

I, in my 0.9.9 installation have changed this to 255 and haven't seen any problems at all.  I checked 1.1.5 and it still appears to be a varchar(100).  MySQL manual states "The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store".  It also states that there is no speed/storage difference for the varchars if they are declared smaller (so there's no real point in having this restriction)..

I'd recommend expanding the default schema to maximize the length of the val column in light of the popularity of spf/domainkeys.

-M