flexologist_migration_from.sql

CREATE DATABASE  `flexologist_migration_from` ;

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `firstName` varchar(255) NOT NULL,
  `lastName` varchar(255) NOT NULL,
  `age` int(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

INSERT INTO `users` VALUES(1, 'johns', 'John', 'Smith', 35);
INSERT INTO `users` VALUES(2, 'janes', 'Jane', 'Smith', 24);
INSERT INTO `users` VALUES(3, 'joeb', 'Joe', 'Bloggs', 65);

flexologist_migration_to.sql

CREATE DATABASE  `flexologist_migration_to` ;

CREATE TABLE `members` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `surname` varchar(255) NOT NULL,
  `age` int(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;