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
This package is not auto-updated.
Last update: 2024-10-26 15:23:59 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