Download the PHP package hzhihua/yii2-dump without Composer
On this page you can find all versions of the php package hzhihua/yii2-dump. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package yii2-dump
yii2-dump
Generate migration file from an existing database
github: https://github.com/Hzhihua/yii2-dump
oschina: http://git.oschina.net/hzhihua/yii2-dump
Demo
Test Environment
- PHP >= 5.5.0
- MySQL(5.6.36)
Installation
Configuration
Add the following in console/config/main.php:
Simple Configuration
Detail Configuration see
Default Table Options
it was defined at "@vendor/hzhihua/yii2-dump/src/Migration.php" file see
Default Limit
Default Filter Table
migration
Tips
You may neet to remove the migration file that its name is "*_init.php" before you run "./yii migrate" commond. because it will generate "{{%user}}" table file when you run "./yii dump" commond and the file name with "*_init.php" also create "{{%user}}" table. it will tip you "{{%user}}" has always exits.
Simple Usage
run
dump
command.
Commands
Check help
print all over the table name without table prefix
generate all over the table migration file(default filter migration table)
generate all over the table migration file but it only had some data between 0 and 10
only generate table1,table2 migration file
only generate table1,table2 migration file and only table1 will be dumped table data
generate all over the migration table file without table1,table2
print all over the code of migration table file(default filter migration table)
Display the 'createTable' code at the terminal.
Display the 'dropTable' code at the terminal.
-type params
Useful commands (for macOS user):
Supports
- Types
- Size
- Unsigned
- NOT NULL
- DEFAULT Value
- COMMENT
- Unique key
- Foreign key
- Primary key
- ENUM type (for MySQL)
- AUTO_INCREMENT
Not Supports
AUTO_INCREMENT