czproject / sql-schema
Library for describe of the database schema.
Fund package maintenance!
Other
Installs: 2 185
Dependents: 1
Suggesters: 0
Security: 0
Stars: 6
Watchers: 2
Forks: 1
Open Issues: 0
Requires
- php: >=5.6.0
Requires (Dev)
- nette/tester: ^2.0
README
Library for describe of the database schema.
Installation
Download a latest package or use Composer:
composer require czproject/sql-schema
CzProject\SqlSchema requires PHP 5.6.0 or later.
Usage
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/