Mark the node id columns as not null for directory, revision and snapshot
This is an oversight from the migration to split indexes.