/*
 Navicat MySQL Data Transfer

 Source Server         : Localhost
 Source Server Version : 50150
 Source Host           : 10.0.1.5
 Source Database       : foondump2005

 Target Server Version : 50150
 File Encoding         : utf-8

 Date: 09/07/2010 15:53:52 PM
*/

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `geo_postalcoords`
-- ----------------------------
DROP TABLE IF EXISTS `geo_postalcoords`;
CREATE TABLE `geo_postalcoords` (
  `postalcode` char(7) NOT NULL,
  `rd_x` int(11) DEFAULT NULL,
  `rd_y` int(11) DEFAULT NULL,
  `wgs84_lat` double DEFAULT NULL,
  `wgs84_lon` double DEFAULT NULL,
  PRIMARY KEY (`postalcode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `pink_category`
-- ----------------------------
DROP TABLE IF EXISTS `pink_category`;
CREATE TABLE `pink_category` (
  `category` char(5) NOT NULL,
  `description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `pink_city`
-- ----------------------------
DROP TABLE IF EXISTS `pink_city`;
CREATE TABLE `pink_city` (
  `city` varchar(32) NOT NULL,
  PRIMARY KEY (`city`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `pink_info`
-- ----------------------------
DROP TABLE IF EXISTS `pink_info`;
CREATE TABLE `pink_info` (
  `id` int(11) NOT NULL,
  `seq` int(11) NOT NULL,
  `tag` int(11) NOT NULL,
  `infovalue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`,`seq`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `pink_phonenumber`
-- ----------------------------
DROP TABLE IF EXISTS `pink_phonenumber`;
CREATE TABLE `pink_phonenumber` (
  `id` int(11) NOT NULL,
  `phone` varchar(20) NOT NULL,
  PRIMARY KEY (`phone`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `pink_street`
-- ----------------------------
DROP TABLE IF EXISTS `pink_street`;
CREATE TABLE `pink_street` (
  `city` varchar(32) NOT NULL,
  `streetname` varchar(64) NOT NULL,
  PRIMARY KEY (`city`,`streetname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `pink_subscriber`
-- ----------------------------
DROP TABLE IF EXISTS `pink_subscriber`;
CREATE TABLE `pink_subscriber` (
  `id` int(10) unsigned NOT NULL,
  `lastname` varchar(128) DEFAULT NULL,
  `streetname` varchar(64) DEFAULT NULL,
  `housenumber` varchar(24) DEFAULT NULL,
  `postalcode` varchar(9) DEFAULT NULL,
  `city` varchar(80) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `category` char(5) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_lastname` (`lastname`(16)),
  KEY `idx_streetname` (`streetname`),
  KEY `idx_postalcode` (`postalcode`),
  KEY `idx_city` (`city`(10)),
  KEY `idx_category` (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `white_category`
-- ----------------------------
DROP TABLE IF EXISTS `white_category`;
CREATE TABLE `white_category` (
  `category` char(5) NOT NULL,
  `description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `white_city`
-- ----------------------------
DROP TABLE IF EXISTS `white_city`;
CREATE TABLE `white_city` (
  `city` varchar(32) NOT NULL,
  PRIMARY KEY (`city`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `white_info`
-- ----------------------------
DROP TABLE IF EXISTS `white_info`;
CREATE TABLE `white_info` (
  `id` int(11) NOT NULL,
  `seq` int(11) NOT NULL,
  `tag` int(11) NOT NULL,
  `infovalue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`,`seq`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `white_phonenumber`
-- ----------------------------
DROP TABLE IF EXISTS `white_phonenumber`;
CREATE TABLE `white_phonenumber` (
  `id` int(11) NOT NULL,
  `phone` varchar(20) NOT NULL,
  PRIMARY KEY (`phone`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `white_street`
-- ----------------------------
DROP TABLE IF EXISTS `white_street`;
CREATE TABLE `white_street` (
  `city` varchar(32) NOT NULL,
  `streetname` varchar(64) NOT NULL,
  PRIMARY KEY (`city`,`streetname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `white_subscriber`
-- ----------------------------
DROP TABLE IF EXISTS `white_subscriber`;
CREATE TABLE `white_subscriber` (
  `id` int(10) unsigned NOT NULL,
  `title` varchar(40) DEFAULT NULL,
  `firstname` varchar(128) DEFAULT NULL,
  `infix` varchar(40) DEFAULT NULL,
  `lastname` varchar(128) DEFAULT NULL,
  `streetname` varchar(64) DEFAULT NULL,
  `housenumber` varchar(24) DEFAULT NULL,
  `postalcode` varchar(9) DEFAULT NULL,
  `city` varchar(80) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `category` char(5) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_lastname` (`lastname`(16)),
  KEY `idx_streetname` (`streetname`),
  KEY `idx_postalcode` (`postalcode`),
  KEY `idx_city` (`city`(10))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;