Great catch!

Paul Nielsen posted a script back in 2007 to auto-generate indexes for foreign keys:

http://sqlblog.com/blogs/paul_nielsen/archive/2007/02/08/codegen-to-create-indexes-for-fks.aspx

http://www.sqlserverbible.com/scripts.htm