degami/sql-schema

Library for describe of the database schema.

Maintainers

Details

github.com/degami/sql-schema

Source

Installs: 293

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 0

Forks: 1

pkg:composer/degami/sql-schema

dev-master 2025-10-12 10:07 UTC

Requires

BSD-3-Clause 7368a83cdf1c1328ef7ee17948a33e5ebe11c67b

This package is auto-updated.

Last update: 2025-10-12 10:07:53 UTC

README

Library for describe of the database schema.

forked from : https://github.com/czproject/sql-schema

Installation

composer require degami/sql-schema

Degami\SqlSchema requires PHP 7.2 or later.

Usage

use Degami\SqlSchema\Index;
$schema = new Degami\SqlSchema\Schema;

$table = $schema->addTable('book');
$table->addColumn('id', 'INT', NULL, array('UNSIGNED'));
      ->addColumn('name', 'VARCHAR', array(200));
      ->addColumn('author_id', 'INT', NULL, array('UNSIGNED'));
      ->addIndex(NULL, 'id', Index::TYPE_PRIMARY);
      ->addIndex('name_author_id', array('name', 'author_id'), Index::TYPE_UNIQUE);

foreach( $schema->getTables() as $table ) {
    echo $table->showCreate()."\n";
}

License: New BSD License