New Major Release

• Minimum PHP version is now 8.2
• Stricter type-hinting that may lead to backward compatibility issues for users of version 3.x of this package that may have extended some classes in this package

Full Changelog: 3.1.2...4.0.0

Minor Release

• Added code to cache a query that is always run in the constructor of the MysqlSchema class
• Some other under the hood tweaks

Full Changelog: 3.1.1...3.1.2

Maintenance Release

In ./src/SqliteSchema.php changed

protected function setRawCols(array &$cols, $schema, $table, $create)

to

protected function setRawCols(array &$cols, string $schema, string $table, string $create)

and

protected function addColFromRaw(array &$cols, array $val, $create)

to

protected function addColFromRaw(array &$cols, array $val, string $create)

Full Changelog: 3.1.0...3.1.1

New Major Release

• First version for rotexsoft/sqlschema
• changed Aura\SqlSchema to Rotexsoft\SqlSchema
• added BSD-3 License for rotexsoft/sqlschema enhancements
• more stricter type-hinting applied across the code-base

Contains these changes too:

• https://github.com/rotexdegba/Aura.SqlSchema/releases/tag/3.0.0
• https://github.com/rotexdegba/Aura.SqlSchema/releases/tag/3.0.1

Full Changelog: 2.x...3.1.0

Maintenance Release

• Added script to run tests against multiple versions of MySQL, Mariadb & Postgres
• Added logic to detect Mariadb10.11.6+ in the test setup which like Mysql 8.0+ makes a timestamp column (that wasn't explicitly declared as NOT NULL) to be nullable by default

Full Changelog: 3.0.0...3.0.1

PHP 8.1 Compatible Version

• Refactored code to work with PHP 8.1 with no errors or deprecation warnings.
• Updated Tests to work with PHPUnit 10 and reorganized some of the test setup code
• PHP 8.1 now min version
• Added rector as a dev dependency
• Added more strict typing all over the code base. Definitely no longer backward compatible with version 2.0.x
• Added code to make the package work with mariadb, leveraged some Atlas/Info code to get this done.
• Added code to make the package work with Postgresql, version 2.0.x was not working with Postgresql, leveraged some Atlas/Info code to get this done.

Tested in Rocky Linux 9 With Podman 4.6.1 with PHP 8.1.27 and the follwoing database versions with all tests passing (Didn't test Sql Server):

Mariadb 10.4.32
Mariadb 10.5.23
Mariadb 10.6.16
Mariadb 10.11.6
Mariadb 11.0.4
Mariadb 11.1.3
Mariadb 11.2.2

Mysql 5.6.51
Mysql 5.7.44
Mysql 8.0.36
Mysql 8.3.0

Postgres 12.17
Postgres 13.13
Postgres 14.10
Postgres 15.5
Postgres 16.1

Mysql Containers

podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mysql:5.6.51
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mysql:5.7.44
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mysql:8.0.36
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mysql:8.3.0

Mariadb Containers

podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:10.4.32
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:10.5.23
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:10.6.16
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:10.11.6
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:11.0.4
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:11.1.3
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:11.2.2

Postgres Containers

podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:12.17
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:13.13
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:14.10
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:15.5
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:16.1

Full Changelog: https://github.com/rotexdegba/Aura.SqlSchema/commits/3.0.0