Skip to content

v0.1.2

Choose a tag to compare

@tbson tbson released this 17 Nov 10:42
· 4 commits to main since this release

A release of the schemity command line tool and the Schemity Migration Check action.

Added

  • A MySQL migration that declares a foreign key inline is reported. MySQL 8.4 accepts a column's own REFERENCES without a warning and creates no key; MySQL 9.7 and MariaDB create it:

    ALTER TABLE posts ADD COLUMN author_id INT REFERENCES users (id);

    It now appears under Storage engine, for CREATE TABLE and ADD COLUMN: "Declares the foreign key on posts.author_id inline, which MySQL 8.4 accepts without creating a key; 9.7 creates it, and a FOREIGN KEY constraint works on both". Write the key as CONSTRAINT ... FOREIGN KEY (...) REFERENCES ... to have it on every version. fail-on: storage-engine fails the job on it. MySQL only.

Upgrade

Nothing to change in a workflow that uses schemity/ci@v1 with the default version: latest. A workflow pinned to an earlier version needs version: v0.1.2.

Downloads

File For
schemity-x86_64-unknown-linux-musl.tar.gz Linux x64
schemity-aarch64-unknown-linux-musl.tar.gz Linux ARM64
schemity-aarch64-apple-darwin.tar.gz macOS on Apple silicon

Each archive holds the schemity binary, its license and the licenses of the open source software in it. SHA-256 sums are in checksums.txt.