howyi/conv

MySQL migration query auto generate from schema

, _(*1)

conv

Core package for howyi/conv-laravel, _(*2)

Generate MySQL migration queries from actual DB and DDL, _(*3)

composer require howyi/conv --dev

Query sample

tbl_user.sql, _(*4)

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, _(*5)

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, _(*6)

DROP TABLE `tbl_user`;

CONTRIBUTING

install

$ composer install

check (before pull-request)

$ composer check-fix