-- phpMyAdmin SQL Dump
-- version 3.2.0.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 19. August 2009 um 23:05
-- Server Version: 5.0.51
-- PHP-Version: 5.2.9-4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `drkverwaltung`
--

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

--
-- Tabellenstruktur für Tabelle `drk_md2`
--

CREATE TABLE IF NOT EXISTS `drk_md2` (
  `id` int(11) NOT NULL auto_increment,
  `import_num` int(6) NOT NULL,
  `mg_num` int(6) NOT NULL,
  `name` varchar(255) collate latin1_german1_ci NOT NULL,
  `vorname` varchar(255) collate latin1_german1_ci NOT NULL,
  `anrede` varchar(255) collate latin1_german1_ci NOT NULL,
  `strasse` varchar(255) collate latin1_german1_ci NOT NULL,
  `plz` int(5) NOT NULL,
  `ort` varchar(255) collate latin1_german1_ci NOT NULL,
  `geburtstag` date NOT NULL,
  `email` varchar(255) collate latin1_german1_ci NOT NULL,
  `tel_priv` varchar(255) collate latin1_german1_ci NOT NULL,
  `tel_dienst` varchar(255) collate latin1_german1_ci NOT NULL,
  `fax` varchar(255) collate latin1_german1_ci NOT NULL,
  `eintritt` date NOT NULL,
  `ov_num` tinyint(2) NOT NULL,
  `zweise` tinyint(1) NOT NULL,
  `zzeitraum` tinyint(1) NOT NULL,
  `beitrag` float(7,2) NOT NULL,
  `jbeitrag` float(7,2) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `lat` float(10,6) default NULL,
  `lng` float(10,6) default NULL,
  `addr_unusable` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `mg_num` (`import_num`,`mg_num`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=47631 ;

--
-- Daten für Tabelle `drk_md2`
--

INSERT INTO `drk_md2` (`id`, `import_num`, `mg_num`, `name`, `vorname`, `anrede`, `strasse`, `plz`, `ort`, `geburtstag`, `email`, `tel_priv`, `tel_dienst`, `fax`, `eintritt`, `ov_num`, `zweise`, `zzeitraum`, `beitrag`, `jbeitrag`, `status`, `lat`, `lng`, `addr_unusable`) VALUES
(47628, 15, 250161, 'Peter', 'Pan', 'Herr', 'Endgasse 3', 67592, 'Dückhausen', '1989-10-10', '', '', '', '', '2006-01-01', 24, 1, 1, 6.50, 6.50, 1, 45.664227, 2.205955, 0),
(47629, 15, 700132, 'Marx', 'Karl', 'Herr', 'Eichennstr. 9', 67590, 'Ulgersheim', '1979-11-07', '', '06241/90234', '0177/6123174', '', '2006-05-12', 24, 1, 1, 6.00, 6.00, 1, 46.639099, 4.222414, 0),
(47630, 15, 992011, 'Weiner', 'Mieke', 'Herr', 'Leipziger Str. 19', 67551, 'Mainz', '1994-06-17', '', '06247/1273', '', '', '1999-01-01', 24, 1, 1, 6.14, 6.14, 1, 46.636787, 4.288330, 0);