czproject/sql-schema

Library for describe of the database schema.

CzProject\SqlSchema

, _(*1)

Library for describe of the database schema., _(*2)

, _(*3)

Installation

Download a latest package or use Composer:, _(*4)

composer require czproject/sql-schema

CzProject\SqlSchema requires PHP 8.0 or later., _(*5)

Usage

``` php use CzProject\SqlSchema\Index; $schema = new CzProject\SqlSchema\Schema;, <sub>(*6)</sub>

$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);, <sub>(*7)</sub>

$schema->getTables(); ```, <sub>(*8)</sub>

License: New BSD License
Author: Jan Pecha, https://www.janpecha.cz/, <sub>(*9)</sub>