c006/yii2-migration-utility

Automatically writes the create tables for migrations or create tables in general

Yii2 Migration Utility

Current Version - v2.0.4 2020-06, _(*1)

• Add JqueryAsset to DefaultController

This is a utility that writes the create table statement for migrations. The table(s), indexes, foreign keys must already exist., _(*2)

Foreign Key - uses link table and numbering, table / columns had potential to be too long, _(*3)

Supports, _(*4)

• MySQL
• MsSQL
• PgSQL
• SQLite

It automatically writes out all:, _(*5)

• tables
• columns
• column types
• column defaults
• primary keys
• composite keys
• foreign key
• indexes
• Table data

Installation

The preferred way to install this extension is through composer., _(*6)

Either run, _(*7)

php composer.phar require --prefer-source "c006/yii2-migration-utility" ">=2.0.4"

or add, _(*8)

"c006/yii2-migration-utility": ">=2.0.4"

to the require section of your composer.json file., _(*9)

Required

Update either config/web.php (basic) or common/config/main.php (advanced), _(*10)

> 'modules' => [ 'utility' => [ 'class' => 'c006\utility\migration\Module', ], ],, _(*11)

The tables must already exist in website schema., _(*12)

Screen Capture

Image: https://drive.google.com/file/d/18TwwvvN4r9u7zQ537i5LsP3XQe6aizMp/view?usp=sharing, _(*13)

Usage

http://___[Your_Domain]___/utility

or, _(*14)

http://___[Your_Domain]___/?r=/utility

Updates

• Table options per database type
• Table indexes
• Table data

Contributors

• Insolita
• Deele
• Sedov Sergey
• fedemotta

Comments / Suggestions

Please provide any helpful feedback or requests., _(*15)

Thanks., _(*16)