Clean up create tables.sql

Add delete statements, remove strange useless self-referencing foreign key, get rid of clutter that may interfere with different SQL Server versions, and change all the nchar's to varchar's.