-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 12. März 2006 um 13:47
-- Server Version: 4.0.23
-- PHP-Version: 4.3.1
-- 
-- Datenbank: `lkif`
-- 

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

-- 
-- Tabellenstruktur für Tabelle `PmMitarbeiter`
-- 

CREATE TABLE IF NOT EXISTS `PmMitarbeiter` (
  `ID` int(6) unsigned NOT NULL auto_increment,
  `Nachname` varchar(40) NOT NULL default '''''',
  `Vorname` varchar(40) NOT NULL default '''''',
  `TelPrivat` varchar(29) default NULL,
  `TelDienstlich` varchar(20) default NULL,
  `TelMobil` varchar(20) default NULL,
  `StrasseNr` varchar(60) default NULL,
  `PLZ` int(8) default NULL,
  `Ort` varchar(60) default NULL,
  `EMail` varchar(60) default NULL,
  `ICQ` int(10) default NULL,
  `Stundenlohn` float NOT NULL default '0',
  `aktiv` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

-- 
-- Daten für Tabelle `PmMitarbeiter`
-- 

INSERT IGNORE INTO `PmMitarbeiter` VALUES (1, 'Groll', 'Florian', '02171-32783', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15, 1),
(2, 'Herbertz', 'Markus', '0214-3106923', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15, 1),
(3, 'Kaechele', 'Felix', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15, 1),
(4, 'Klein', 'Christian', '123456', NULL, '', '', 0, '', NULL, NULL, 15, 1),
(5, 'Preis', 'Paul', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15, 1),
(6, 'Ditscheid', 'Benedict', '', NULL, '', '', 0, '', NULL, NULL, 15, 1),
(8, 'vonHausen', 'Sarah', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15, 1),
(9, 'Gehrmann', 'Marcel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0),
(10, 'Dummy', 'Dummy', '', NULL, '', '', 0, '', NULL, NULL, 0, 1),
(11, 'Dummy2', 'Dummy2', '', NULL, '', '', 0, '', NULL, NULL, 0, 1),
(12, 'Dummy3', 'Dummy3', '', NULL, '', '', 0, '', NULL, NULL, 30.5, 1);