Add support for NOT NULL in create statement

Found #179, thought I'd have a go at adding the feature in. If there's a test case that you can think of that I've missed, please let me know and I'll happily add it in.