-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.45-community-nt-log


/*!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 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema test_db
--

CREATE DATABASE IF NOT EXISTS test_db;
USE test_db;

--
-- Temporary table structure for view `proj_vorgaenge`
--
DROP TABLE IF EXISTS `proj_vorgaenge`;
DROP VIEW IF EXISTS `proj_vorgaenge`;
CREATE TABLE `proj_vorgaenge` (
  `Vor_Nr` int(11),
  `Vor_Nr_int` char(32),
  `Vor_ProJNr` int(11),
  `Vor_Nr_Proj` int(11),
  `Vor_Name` varchar(250),
  `Vor_Typ` char(1),
  `Vor_Verantw` varchar(50),
  `Vor_Dauer_soll` double(15,3),
  `Vor_Einheit` int(11),
  `Vor_Dauer_ist` double(15,3),
  `Vor_TerminFuerStart` datetime,
  `Vor_TerminFuerStartIst` datetime,
  `Vor_MussStartenAmTermin` tinyint(1),
  `Vor_Auf_Nr_intern` varchar(50),
  `Vor_ext` tinyint(1),
  `Vor_abgeschl` double(15,3),
  `Vor_Start` datetime,
  `Vor_End` datetime,
  `Vor_StartPlan` datetime,
  `Vor_EndPlan` datetime,
  `Vor_Color` int(11),
  `Vor_Beware` tinyint(1),
  `Vor_Artikel` int(11),
  `Vor_Stuckzahl` int(11),
  `Vor_KopiertVon` int(11),
  `Vor_ErstelltAm` datetime,
  `Vor_Geteilt` tinyint(1),
  `Vor_Niveau` tinyint(4) unsigned,
  `tmstmp` timestamp,
  `Vor_StartFix` tinyint(1),
  `Vor_EndFix` tinyint(1),
  `Vor_Tag` varchar(64),
  `deleted` tinyint(1),
  `Vor_ExternAdresse` int(11)
);

--
-- Definition of table `proj_vorgaenge_data`
--

DROP TABLE IF EXISTS `proj_vorgaenge_data`;
CREATE TABLE `proj_vorgaenge_data` (
  `Vor_Nr` int(11) NOT NULL auto_increment,
  `Vor_Nr_int` char(32) default NULL,
  `Vor_ProJNr` int(11) default '0',
  `Vor_Nr_Proj` int(11) default '0',
  `Vor_Name` varchar(250) default NULL,
  `Vor_Typ` char(1) default 'n',
  `Vor_Verantw` varchar(50) default NULL,
  `Vor_Dauer_soll` double(15,3) NOT NULL default '0.000',
  `Vor_Einheit` int(11) NOT NULL default '2',
  `Vor_Dauer_ist` double(15,3) NOT NULL default '0.000',
  `Vor_TerminFuerStart` datetime default NULL,
  `Vor_TerminFuerStartIst` datetime default NULL,
  `Vor_MussStartenAmTermin` tinyint(1) default '0',
  `Vor_Auf_Nr_intern` varchar(50) default NULL,
  `Vor_ext` tinyint(1) default '0',
  `Vor_abgeschl` double(15,3) NOT NULL default '0.000',
  `Vor_Start` datetime default NULL,
  `Vor_End` datetime default NULL,
  `Vor_StartPlan` datetime default NULL,
  `Vor_EndPlan` datetime default NULL,
  `Vor_Color` int(11) default '-1',
  `Vor_Beware` tinyint(1) default '0',
  `Vor_Artikel` int(11) default '0',
  `Vor_Stuckzahl` int(11) default '0',
  `Vor_KopiertVon` int(11) default '0',
  `Vor_ErstelltAm` datetime default '0000-00-00 00:00:00',
  `Vor_Geteilt` tinyint(1) default NULL,
  `Vor_Niveau` tinyint(4) unsigned default '0',
  `tmstmp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Vor_StartFix` tinyint(1) default NULL,
  `Vor_EndFix` tinyint(1) default NULL,
  `Vor_Tag` varchar(64) default NULL,
  `deleted` tinyint(1) default '0',
  `Vor_ExternAdresse` int(11) default NULL,
  PRIMARY KEY  (`Vor_Nr`),
  KEY `Vor_Einheit` (`Vor_Einheit`),
  KEY `Vor_ProJNr001` (`Vor_ProJNr`),
  KEY `Vor_Typ` (`Vor_Typ`),
  KEY `FK_proj_vorgaenge_data_1` (`Vor_ExternAdresse`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `proj_vorgaenge_data`
--

/*!40000 ALTER TABLE `proj_vorgaenge_data` DISABLE KEYS */;
INSERT INTO `proj_vorgaenge_data` (`Vor_Nr`,`Vor_Nr_int`,`Vor_ProJNr`,`Vor_Nr_Proj`,`Vor_Name`,`Vor_Typ`,`Vor_Verantw`,`Vor_Dauer_soll`,`Vor_Einheit`,`Vor_Dauer_ist`,`Vor_TerminFuerStart`,`Vor_TerminFuerStartIst`,`Vor_MussStartenAmTermin`,`Vor_Auf_Nr_intern`,`Vor_ext`,`Vor_abgeschl`,`Vor_Start`,`Vor_End`,`Vor_StartPlan`,`Vor_EndPlan`,`Vor_Color`,`Vor_Beware`,`Vor_Artikel`,`Vor_Stuckzahl`,`Vor_KopiertVon`,`Vor_ErstelltAm`,`Vor_Geteilt`,`Vor_Niveau`,`tmstmp`,`Vor_StartFix`,`Vor_EndFix`,`Vor_Tag`,`deleted`,`Vor_ExternAdresse`) VALUES 
 (1,'2',0,0,NULL,'n',NULL,0.000,2,0.000,NULL,NULL,0,NULL,0,0.000,NULL,NULL,NULL,NULL,-1,0,0,0,0,'0000-00-00 00:00:00',NULL,0,'2008-04-24 13:09:27',NULL,NULL,NULL,0,NULL),
 (2,'223',0,0,NULL,'n',NULL,0.000,2,0.000,NULL,NULL,0,NULL,0,0.000,NULL,NULL,NULL,NULL,-1,0,0,0,0,'0000-00-00 00:00:00',NULL,0,'2008-04-24 13:09:29',NULL,NULL,NULL,0,NULL),
 (3,'2234',0,0,NULL,'n',NULL,0.000,2,0.000,NULL,NULL,0,NULL,0,0.000,NULL,NULL,NULL,NULL,-1,0,0,0,0,'0000-00-00 00:00:00',NULL,0,'2008-04-24 13:09:30',NULL,NULL,NULL,0,NULL);
/*!40000 ALTER TABLE `proj_vorgaenge_data` ENABLE KEYS */;


--
-- Definition of view `proj_vorgaenge`
--

DROP TABLE IF EXISTS `proj_vorgaenge`;
DROP VIEW IF EXISTS `proj_vorgaenge`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `proj_vorgaenge` AS select `proj_vorgaenge_data`.`Vor_Nr` AS `Vor_Nr`,`proj_vorgaenge_data`.`Vor_Nr_int` AS `Vor_Nr_int`,`proj_vorgaenge_data`.`Vor_ProJNr` AS `Vor_ProJNr`,`proj_vorgaenge_data`.`Vor_Nr_Proj` AS `Vor_Nr_Proj`,`proj_vorgaenge_data`.`Vor_Name` AS `Vor_Name`,`proj_vorgaenge_data`.`Vor_Typ` AS `Vor_Typ`,`proj_vorgaenge_data`.`Vor_Verantw` AS `Vor_Verantw`,`proj_vorgaenge_data`.`Vor_Dauer_soll` AS `Vor_Dauer_soll`,`proj_vorgaenge_data`.`Vor_Einheit` AS `Vor_Einheit`,`proj_vorgaenge_data`.`Vor_Dauer_ist` AS `Vor_Dauer_ist`,`proj_vorgaenge_data`.`Vor_TerminFuerStart` AS `Vor_TerminFuerStart`,`proj_vorgaenge_data`.`Vor_TerminFuerStartIst` AS `Vor_TerminFuerStartIst`,`proj_vorgaenge_data`.`Vor_MussStartenAmTermin` AS `Vor_MussStartenAmTermin`,`proj_vorgaenge_data`.`Vor_Auf_Nr_intern` AS `Vor_Auf_Nr_intern`,`proj_vorgaenge_data`.`Vor_ext` AS `Vor_ext`,`proj_vorgaenge_data`.`Vor_abgeschl` AS `Vor_abgeschl`,`proj_vorgaenge_data`.`Vor_Start` AS `Vor_Start`,`proj_vorgaenge_data`.`Vor_End` AS `Vor_End`,`proj_vorgaenge_data`.`Vor_StartPlan` AS `Vor_StartPlan`,`proj_vorgaenge_data`.`Vor_EndPlan` AS `Vor_EndPlan`,`proj_vorgaenge_data`.`Vor_Color` AS `Vor_Color`,`proj_vorgaenge_data`.`Vor_Beware` AS `Vor_Beware`,`proj_vorgaenge_data`.`Vor_Artikel` AS `Vor_Artikel`,`proj_vorgaenge_data`.`Vor_Stuckzahl` AS `Vor_Stuckzahl`,`proj_vorgaenge_data`.`Vor_KopiertVon` AS `Vor_KopiertVon`,`proj_vorgaenge_data`.`Vor_ErstelltAm` AS `Vor_ErstelltAm`,`proj_vorgaenge_data`.`Vor_Geteilt` AS `Vor_Geteilt`,`proj_vorgaenge_data`.`Vor_Niveau` AS `Vor_Niveau`,`proj_vorgaenge_data`.`tmstmp` AS `tmstmp`,`proj_vorgaenge_data`.`Vor_StartFix` AS `Vor_StartFix`,`proj_vorgaenge_data`.`Vor_EndFix` AS `Vor_EndFix`,`proj_vorgaenge_data`.`Vor_Tag` AS `Vor_Tag`,`proj_vorgaenge_data`.`deleted` AS `deleted`,`proj_vorgaenge_data`.`Vor_ExternAdresse` AS `Vor_ExternAdresse` from `proj_vorgaenge_data` where (`proj_vorgaenge_data`.`deleted` = 0);



/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;