Support CREATE TABLE IF NOT EXISTS

[egonelbre]

Currently the schema use CREATE TABLE to create the table. This will throw an error in case the table already exists. Using CREATE TABLE IF NOT EXISTS instead would give better results.

However there probably should be a way to verify whether the table matches the specified schema as well to avoid version skew. Basic checks such as whether the table columns match could be a good start.

[azdagron]

The Schema() call isn't really intended for database migration purposes. We've considered building in migration support directly into dbx but haven't settled on a set of features we'd like to support. In the meantime, using dbx alongside something like github.com/go-migrate/go-migrate works pretty good. It does require manual construction of the up/down statements, however.

[egonelbre]

I'm not really looking for database migration at the moment, but rather detecting version skew.

Just realized that it could add a hash of the Schema() to some version table to detect this.