mysql - Rails 4 从 MySQL 表的迁移

Question

我有一个国家/地区/城市的预种子数据库。是否可以为这些表自动生成迁移文件？

CREATE TABLE IF NOT EXISTS `cities` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` int(11) unsigned NOT NULL,
  `region_id` int(11) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `Latitude` float NOT NULL,
  `Longitude` float NOT NULL,
  `TimeZone` varchar(10) NOT NULL,
  `DmaId` smallint(6) DEFAULT NULL,
  `County` varchar(25) DEFAULT NULL,
  `Code` varchar(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42965 ;

CREATE TABLE IF NOT EXISTS `countries` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `FIPS104` varchar(2) NOT NULL,
  `ISO2` varchar(2) NOT NULL,
  `ISO3` varchar(3) NOT NULL,
  `ISON` varchar(4) NOT NULL,
  `Internet` varchar(2) NOT NULL,
  `Capital` varchar(25) DEFAULT NULL,
  `MapReference` varchar(50) DEFAULT NULL,
  `NationalitySingular` varchar(35) DEFAULT NULL,
  `NationalityPlural` varchar(35) DEFAULT NULL,
  `Currency` varchar(30) DEFAULT NULL,
  `CurrencyCode` varchar(3) DEFAULT NULL,
  `Population` bigint(20) DEFAULT NULL,
  `Title` varchar(50) DEFAULT NULL,
  `Comment` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=276 ;


CREATE TABLE IF NOT EXISTS `regions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` int(11) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `Code` varchar(8) NOT NULL,
  `ADM1Code` char(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5400 ;

Answer 1

您可以使用

rake db:schema:dump