c006 / yii2-migration-utility
Automatically writes the create tables for migrations or create tables in general
Installs: 143 791
Dependents: 5
Suggesters: 0
Security: 0
Stars: 64
Watchers: 10
Forks: 35
Open Issues: 5
Type:yii2-extension
README
Current Version - v2.0.4 2020-06
- 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.
Foreign Key - uses link table and numbering, table / columns had potential to be too long
Supports
- MySQL
- MsSQL
- PgSQL
- SQLite
It automatically writes out all:
- 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.
Either run
php composer.phar require --prefer-source "c006/yii2-migration-utility" ">=2.0.4"
or add
"c006/yii2-migration-utility": ">=2.0.4"
to the require section of your composer.json
file.
Required
Update either config/web.php (basic) or common/config/main.php (advanced)
'modules' => [
'utility' => [
'class' => 'c006\utility\migration\Module',
],
],
The tables must already exist in website schema.
Screen Capture
Image: https://drive.google.com/file/d/18TwwvvN4r9u7zQ537i5LsP3XQe6aizMp/view?usp=sharing
Usage
###http://[Your_Domain]/utility###
or
###http://[Your_Domain]/?r=/utility###
Updates
- Table options per database type
- Table indexes
- Table data
Contributors
Comments / Suggestions
Please provide any helpful feedback or requests.
Thanks.