euskadi31/schema

SQL Schema manager

SQL Schema Manager

Feature

• MySQL only (more next time).
• Schema file format json and yaml.
• Dump current database schema to json, yaml and sql format.

Schema

Json format (schema.json), _(*1)

{
    "config": {
        "driver": "pdo_mysql",
        "host": "127.0.0.1",
        "port": "3306",
        "dbname": "demo",
        "user": "demo",
        "password": "demo",
        "charset": "utf8"
    },
    "schemas": []
}

Yaml format (schema.yml), _(*2)

config:
    driver: pdo_mysql
    host: 127.0.0.1
    port: '3306'
    dbname: demo
    user: demo
    password: demo
    charset: utf8
schemas: ~

Usage

Create database schema., _(*3)

php schema.phar create

Update database schema., _(*4)

php schema.phar update --force

Dump database schema., _(*5)

php schema.phar dump --format=sql