-- Base de datos: `dbtest`

CREATE TABLE `destino` (
  `id` int(6) UNSIGNED NOT NULL,
  `valor1` int(11) NOT NULL,
  `valor2` int(11) NOT NULL,
  `valor3` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `destino` (`id`, `valor1`, `valor2`, `valor3`) VALUES
(1, 1, 1, 2),
(5, 5, 5, 5);

CREATE TABLE `origen` (
  `id` int(6) UNSIGNED NOT NULL,
  `valor1` int(11) NOT NULL,
  `valor2` int(11) NOT NULL,
  `valor3` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `origen` (`id`, `valor1`, `valor2`, `valor3`) VALUES
(1, 1, 1, 1),
(2, 2, 2, 2),
(3, 3, 3, 3),
(4, 4, 4, 4);

ALTER TABLE `destino`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `origen`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `destino`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

ALTER TABLE `origen`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;