absolute pretty links
appearance cleanup
hash should be a char(64) not an int(11)