php-extended/php-db-schema-mysql

Release 9.5.2

A library to abstract the mysql database schema rules

Homepage Packagist

Keywords
database, php, db, mysql, schema
License
MIT

Documentation

php-db-schema-mysql

A library to abstract the mysql database schema rules

Installation

The installation of this library is made via composer. Download composer.phar from their website. Then add to your composer.json :

	"require": {
		...
		"php-extended/php-db-schema-mysql": "^8"
		...
	}

Then run php composer.phar update to install this library. The autoloading of all classes of this library is made through composer's autoloader.

Basic Usage

This library can generate CREATE DATABASE statements.


use PhpExtended\DbSchema\MysqlTableFactory;
use PhpExtended\DbSchema\MysqlDialect;
use PhpExtended\DbSchema\MysqlTypeNumber;
use PhpExtended\DbSchema\MysqlTypeString;

$factory = new MysqlTableFactory();
$dialect = new MysqlDialect();

$factory->setName('<tableName>');

// <tableColumnId> INT(11) NOT NULL AUTO_INCREMENT COMMENT 'The primary key'
$factory->addColumn('<tableColumnId>', MysqlTypeNumber::INT(), 11, null, null, false, true, 'The primary key');
// <nameColumn> VARCHAR(255) NOT NULL COMMENT 'The name of the <xxx>'
$factory->addColumn('<nameColumn>', MysqlTypeString::VARCHAR(), 255, null, null, false, false, 'The name of the <xxx>');
$factory->addsToPrimaryKey('<tableColumnId>');

$sql = $dialect->showCreateTable($factory->getTable());	// CREATE TABLE ...

License

MIT (See license file).

Stats

Dependencies
2
Dependent packages
4
Dependent repositories
2
Total releases
86
Latest release
First release
Stars
0
Forks
0
Contributors
0
SourceRank
11

Development practices

Source repo 2FA enabled
TEXT!
Package manager 2FA enabled
TEXT!
Is security responsive
TEXT!
Dependencies are managed
TEXT!
Issue-free release available
TEXT!
Succession plan available
TEXT!
Package manager 2FA enabled
TEXT!

The Tidelift Subscription provides access to a continuously curated stream of human-researched and maintainer-verified data on open source packages and their licenses, releases, vulnerabilities, and development practices.

Learn more →

Releases

9.5.2
9.5.1
9.5.0
9.4.7
9.4.6
9.4.5
9.4.4
9.4.3
9.4.2
9.4.1
See all 86 releases

Something wrong with this page? Make a suggestion

Export .ABOUT file for this package

Last synced: 2024-04-08 20:10:20 UTC

Login to resync this project