euskadi31/schema

SQL Schema manager

v0.1.0 2013-08-09 20:38 UTC

Requires

• php: >=5.3.3
• doctrine/dbal: ~2.3
• symfony/console: ~2.3
• symfony/finder: ~2.3
• symfony/process: ~2.3
• symfony/yaml: ~2.3

Requires (Dev)

• atoum/atoum: dev-master

MIT

• Axel Etcheverry

• sql
• schema
• manager

README

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)

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

Yaml format (schema.yml)

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

Usage

Create database schema.

php schema.phar create

Update database schema.

php schema.phar update --force

Dump database schema.

php schema.phar dump --format=sql