euskadi31/schema

SQL Schema manager

Maintainers

Details

github.com/euskadi31/Schema

Source

Issues

Installs: 257

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 3

Forks: 1

Open Issues: 2

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

Requires

Requires (Dev)

MIT 1c5272d3fda3e8132a25a472f9e4026fa8ed536b

sqlschemamanager

This package is not auto-updated.

Last update: 2024-12-21 16:05:09 UTC

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