2017 © Pedro Peláez
 

yii2-extension yii2-migration-utility

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

image

c006/yii2-migration-utility

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

  • Friday, February 2, 2018
  • by c006
  • Repository
  • 11 Watchers
  • 63 Stars
  • 29,772 Installations
  • PHP
  • 7 Dependents
  • 0 Suggesters
  • 33 Forks
  • 4 Open issues
  • 15 Versions
  • 9 % Grown

The README.md

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

Comments / Suggestions

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

Thanks., (*16)

The Versions

02/02 2018

dev-master

9999999-dev

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

17/07 2017

v2.0.3

2.0.3.0

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

24/04 2017

v2.0.2

2.0.2.0

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

05/04 2017

dev-develop

dev-develop

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

05/04 2017

v2.0.1

2.0.1.0

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

05/04 2017

v2.0.0

2.0.0.0

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

01/11 2016

v1.2.2

1.2.2.0

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

11/08 2016

v1.2.1

1.2.1.0

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

02/08 2016

v1.2.0

1.2.0.0

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

11/12 2015

1.1.x-dev

1.1.9999999.9999999-dev

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

11/12 2015

v1.1.2

1.1.2.0

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

10/12 2015

v1.1.1

1.1.1.0

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

09/12 2015

v1.1.0

1.1.0.0

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

08/08 2015

v1.0.0

1.0.0.0

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

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables

19/07 2015

1.x-dev

1.9999999.9999999.9999999-dev

Automatically writes the create tables for migrations or create tables in general. Uses MySQL

  Sources   Download

MIT

by Jon Chambers

extension yii2 migration tables