CREATE TABLE `user_tanks` (
  `id` int(10) NOT NULL,
  `id_tank` int(10) NOT NULL,
  `id_user` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `shop_tanks` (
  `id` int(10) NOT NULL,
  `title` varchar(64) NOT NULL,
  `price` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `shop_tanks` (`id`, `title`, `price`) VALUES
(1, 'Т-34', 100),
(2, 'Т-34-85', 100),
(3, 'КВ-1', 100),
(4, 'КВ-2', 100),
(5, 'КВ-3', 100),
(6, 'КВ-4', 100),
(7, 'КВ-5', 100),
(8, 'КВ-1С', 100);

ALTER TABLE `user_tanks` ADD PRIMARY KEY (`id`), ADD KEY `id_tank` (`id_tank`), ADD KEY `id_user` (`id_user`);
ALTER TABLE `shop_tanks`ADD PRIMARY KEY (`id`);
ALTER TABLE `user_tanks` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `shop_tanks` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;