Soft deletes and foreign keys

Added changes required in database to allow soft deletes and foreign keys when creating database
Merge branch 'softDelete'