PDI Lab - Part 3: Prepare the MySQL database

CREATE DATABASE `pdi_demo`; USE `pdi_demo`; CREATE TABLE `accounts` ( `id` int(10) NOT NULL AUTO_INCREMENT, `id_sf` varchar(18) CHARACTER SET latin1 DEFAULT NULL, `migration_id` varchar(18) CHARACTER SET latin1 DEFAULT NULL, `name` varchar(255) CHARACTER SET latin1 DEFAULT NULL, `account_number` varchar(40) CHARACTER SET latin1 DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8; CREATE TABLE `contacts` ( `id` int(10) NOT NULL AUTO_INCREMENT, `id_sf` varchar(18) CHARACTER SET latin1 DEFAULT NULL, `migration_id` varchar(18) CHARACTER SET latin1 DEFAULT NULL, `accountid_sf` varchar(18) CHARACTER SET latin1 DEFAULT NULL, `accountid_mig` varchar(18) CHARACTER SET latin1 DEFAULT NULL, `lastname` varchar(80) CHARACTER SET latin1 DEFAULT NULL, `firstname` varchar(40) CHARACTER SET latin1 DEFAULT NULL, `name` varchar(121) CHARACTER SET latin1 DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8; CREATE TABLE `opportunities` ( `id` int(10) NOT NULL AUTO_INCREMENT, `id_sf` varchar(18) CHARACTER SET latin1 DEFAULT NULL, `migration_id` varchar(18) CHARACTER SET latin1 DEFAULT NULL, `accountid_sf` varchar(18) CHARACTER SET latin1 DEFAULT NULL, `accountid_mig` varchar(18) CHARACTER SET latin1 DEFAULT NULL, `name` varchar(120) CHARACTER SET latin1 DEFAULT NULL, `pricebook2id` varchar(18) CHARACTER SET latin1 DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;