Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

howyi/conv

Repository files navigation

Build Status Coverage Status Total Downloads

conv

Core package for howyi/conv-laravel

Generate MySQL migration queries from actual DB and DDL

composer require howyi/conv --dev

Query sample

tbl_user.sql

CREATE TABLE `tbl_user` (
 `user_id` int(11) NOT NULL COMMENT 'User ID',
 `age` tinyint(3) UNSIGNED COMMENT 'User age',
 PRIMARY KEY (`user_id`),
 KEY `id_age` (`user_id`, `age`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='User management table';

Generated migration

UP

CREATE TABLE `tbl_user` (
 `user_id` int(11) NOT NULL COMMENT 'User ID',
 `age` tinyint(3) UNSIGNED COMMENT 'User age',
 PRIMARY KEY (`user_id`),
 KEY `id_age` (`user_id`, `age`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='User management table';

DOWN

DROP TABLE `tbl_user`;

CONTRIBUTING

install

$ composer install

check (before pull-request)

$ composer check-fix

About

MySQL migration query auto generate from schema

Topics

Resources

License

Stars

Watchers

Forks

Sponsor this project

Packages

No packages published

Contributors 9

AltStyle によって変換されたページ (->オリジナル) /