This is kind of pointless since SQLite ignores varchar size limits (it's equivalent to saying TEXT). Also, there are all kinds of different limits for path lengths on different OSes (http://insanecoding.blogspot.com/2007/11/pathmax-simply-isnt.html) so maybe we should just use a SQLite "TEXT" type here instead of putting 1024.

I realize the type declarations in the other tables have varchars with weird limits also. :)