   ADD PRIMARY KEY (`id`);
 
 --
--- Indexes for table `z_techs`
---
-ALTER TABLE `z_techs`
-  ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `z_traderoutes`
---
-ALTER TABLE `z_traderoutes`
-  ADD PRIMARY KEY (`id`);
-
---
 -- Indexes for table `z_units`
 --
 ALTER TABLE `z_units`

  `id_user` int(11) NOT NULL,
  `id_phase` int(11) NOT NULL,
  `round` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  `id_move_error` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

ALTER TABLE `colors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `games`
--
ALTER TABLE `games`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;
--
-- AUTO_INCREMENT for table `has_units`
--
ALTER TABLE `has_units`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;
--
-- AUTO_INCREMENT for table `in_game_phase_info`
--
ALTER TABLE `in_game_phase_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=187;
--
-- AUTO_INCREMENT for table `is_in_game`
--
ALTER TABLE `is_in_game`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=129;
--
-- AUTO_INCREMENT for table `optiontypes`
--
ALTER TABLE `optiontypes`
