Respect foreign keys on CockroachDB change_column (gobuffalo#97)

* Add failing test cases for CockroachDB

* Do not fail fixture mismatches when REFRESH_FIXTURES is set

* Respect foreign keys on CockroachDB change_column

Add failing test case for drop_column (gobuffalo#96)

* Add failing test case for rename_column

* Improve rename_column SQLite behavior

`ALTER TABLE .. RENAME COLUMN .. TO ..` is officially supported and does not need the temporary table workaround.

* Add failing test case for drop_column

* Preserve foreign keys in SQLite on drop_column

Closes gobuffalo/pop#574

* Bump CockroachDB to non-EOL version

CockroachDB v2.1 has reached EOL on 7/1/20. The next version v19.1 already reached maintenance support and will reach EOL in 11/1/20 which is why this was bumped to v19.2 right away.

* Resolve missing keys and broken NULL constraints

Resolves an issue where CockroachDB would be missing e.g. UNIQUE indices when using `change_column`. Also fixes a bug when using `change_column` with `NOT NUL` but without `DEFAULT`.

* Add missing PostgreSQL E2E fixtures

* Add missing MySQL E2E fixtures

Handle foreign keys and indices properly in SQLite and add e2e tests (g…

…obuffalo#94)

This patch resolves issues with `change_column` and `drop_column` which previously caused duplicate or missing indices and foreign keys. To prevent future regressions and help debugging,
a new e2e-test pipeline has been added to the project and the CI. Documentation for running the tests has been added to the README.

End-to-end tests currently support MySQL, PostgreSQL, and SQLite and do not yet cover other SQL dialects.

During review, please help ensure that the SQL fixtures are not missing something :)

Closes gobuffalo#92

Move from lib/pq to jackc/pgx (gobuffalo#93)

See gobuffalo/pop#562

Migrate MySQL tests to GitHub actions (gobuffalo#88)

Migrate to plush v4 (gobuffalo#86)

*move away from cockroach v1 support (gobuffalo#85)

*fixed local tests after postgres change and removal of cockroach v1 support

Ignore SQLite system indices (gobuffalo#81)

* Ignore SQLite system indices

This resolves an issue where SQLite system indices were re-created when executing `change_column`, which throws an error in SQLite.

* Add underscore to SQLite index filter prefix

dependency diet (gobuffalo#59)

* dependency diet

* Bump Go version for Azure tests

* Fix MySQL version scan

Co-authored-by: Stanislas Michalak <[email protected]>

Fix a case with timestamps

Timestamp columns provided manually but same as default definition must
use the Timestamps() macro instead of their full definition.