create database roads character set utf8;
connect roads;
CREATE TABLE `osm_roads3` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `way_id` char(32) default NULL,
  `category` char(32) default NULL,
  `postcode` char(5) default NULL,
  `street` char(124) default NULL,
  `city` char(124) default NULL,
  `idx` char(255) default NULL,
  `ccity` char(255) default NULL,
  UNIQUE KEY `id` (`id`)
);
CREATE TABLE `osm_idx` (
  `id` bigint(20) default NULL,
  `idx` char(255) default NULL
);
CREATE TABLE `osm_plz` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `postcode` char(5) default NULL,
  `city` char(255) default NULL,
  UNIQUE KEY `id` (`id`)
);
-- prefill with postcodes
CREATE TABLE `geo_place` (
  `id` int(11) default NULL,
  `postcode` char(255) default NULL,
  `category` char(255) default NULL,
  `name` char(255) default NULL,
  `sortname` char(255) default NULL
);