Library for describe of the database schema.
Download a latest package or use Composer:
composer require czproject/sql-schema CzProject\SqlSchema requires PHP 8.0 or later.
use CzProject\SqlSchema\Index; $schema = new CzProject\SqlSchema\Schema; $table = $schema->addTable('book'); $table->addColumn('id', 'INT', NULL, array('UNSIGNED')); $table->addColumn('name', 'VARCHAR', array(200)); $table->addColumn('author_id', 'INT', NULL, array('UNSIGNED')); $table->addIndex(NULL, 'id', Index::TYPE_PRIMARY); $table->addIndex('name_author_id', array('name', 'author_id'), Index::TYPE_UNIQUE); $schema->getTables();License: New BSD License
Author: Jan Pecha, https://www.janpecha.cz/