yii2-migration-utility Automatically writes the create tables for migrations or create tables in general. Uses MySQL

Yii2 Migration Utility

  1. Installation
  2. Required
  3. Demo
  4. Usage
  5. Updates
  6. Comments / Suggestions

Updated August, 2015

Now supports table indexes, table options for each database type and table data.

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

Supports

  • MySQL
  • MsSQL
  • PgSQL
  • SQLite

It automatically writes out all:

  • tables
  • columns
  • column types
  • column defaults
  • primary 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" "dev-master"

or add

"c006/yii2-migration-utility": "dev-master"

to the require section of your composer.json file.

Required

Update either config/web.php (basic) or config/main.php (advanced)

        'modules'    => [
            ...
            ...
            ...
            'utility' => [
                'class' => 'c006\utility\migration\Module',
            ],
        ],

The tables must already exist in website schema.

Demo

Demo: http://demo.c006.us

Usage

http://___[Your_Domain]___</span>/utility

or

http://___[Your_Domain]___</span>/?r=/utility

Updates

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

Comments / Suggestions

Please provide any helpful feedback or requests.

Thanks.

1 0
10 followers
0 downloads
Yii Version: 2.0
License: MIT
Category: Database
Developed by: jchambers
Created on: Jul 20, 2014
Last updated: 2 years ago

Related Extensions