--
-- Host: localhost    Database: d1
-- ------------------------------------------------------


--
-- Current Database: `d1`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `d1` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `d1`;

--
-- Temporary table structure for view `tab1`
--

/*!50001 DROP VIEW IF EXISTS `tab1`*/;
/*!50001 CREATE TABLE `tab1` (
  `TVPPID` tinyint NOT NULL,
  `PDID` tinyint NOT NULL,
  `PAID` tinyint NOT NULL,
  `AKTIONSID` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `tab2`
--

/*!50001 DROP VIEW IF EXISTS `tab2`*/;
/*!50001 CREATE TABLE `tab2` (
  `PDID` tinyint NOT NULL,
  `PAID` tinyint NOT NULL,
  `aktuelleaktion` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Current Database: `d2`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `d2` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `d2`;

--
-- Table structure for table `tab1`
--

CREATE TABLE `tab1` (
  `TVPPID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `PDID` int(11) NOT NULL DEFAULT '0',
  `PAID` int(11) NOT NULL DEFAULT '0',
  `AKTIONSID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`TVPPID`),
  KEY `PDID` (`PDID`),
  KEY `PAID` (`PAID`)
) ENGINE=MyISAM AUTO_INCREMENT=318909 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tab1`
--

INSERT INTO `tab1` VALUES (318908,431,777458,14390),(318907,431,777458,14390),(318906,431,767471,14390),(318905,431,767471,14390),(318904,431,767471,14390),(318903,431,767471,14390),(318902,431,767471,14390),(318901,431,767471,14390),(318900,431,767471,14390),(318899,431,767471,14390),(318898,431,773869,14390),(318897,431,773869,14390),(318896,431,773869,14390),(318895,431,773869,14390),(318894,431,773869,14390),(318893,431,773869,14390),(318892,431,773869,14390),(318891,431,773869,14390),(318890,431,776430,14390),(318889,431,776430,14390),(318888,431,776430,14390),(318887,431,776430,14390),(318886,431,776430,14390),(318885,431,776430,14390),(318884,431,776430,14390),(318883,431,776430,14390),(318882,431,776430,14390);

--
-- Current Database: `d3`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `d3` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `d3`;

--
-- Table structure for table `tab2`
--

CREATE TABLE `tab2` (
  `PDID` int(11) unsigned NOT NULL DEFAULT '623',
  `PAID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `aktuelleaktion` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`PAID`),
  KEY `aktuelleaktion` (`aktuelleaktion`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tab2`
--

INSERT INTO `tab2` VALUES (623,50,17065),(623,49,17065),(623,48,17065),(623,47,17065),(623,46,17065),(623,45,17065),(623,44,17065),(623,43,17065),(623,42,17065),(623,41,17065),(623,11,16698),(623,12,16698),(623,13,16698),(623,14,16698),(623,15,16698),(623,16,16698),(623,17,16698),(623,18,16698),(623,19,16698),(623,20,16698),(623,38,17065),(623,39,17065),(623,40,17065),(623,31,17065),(623,32,17065),(623,33,17065),(623,34,17065),(623,35,17065);

--
-- Current Database: `d1`
--

USE `d1`;

--
-- Final view structure for view `tab1`
--

/*!50001 DROP TABLE IF EXISTS `tab1`*/;
/*!50001 DROP VIEW IF EXISTS `tab1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `tab1` AS select `d2`.`tab1`.`TVPPID` AS `TVPPID`,`d2`.`tab1`.`PDID` AS `PDID`,`d2`.`tab1`.`PAID` AS `PAID`,`d2`.`tab1`.`AKTIONSID` AS `AKTIONSID` from `d2`.`tab1` */;

--
-- Final view structure for view `tab2`
--

/*!50001 DROP TABLE IF EXISTS `tab2`*/;
/*!50001 DROP VIEW IF EXISTS `tab2`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `tab2` AS select `d3`.`tab2`.`PDID` AS `PDID`,`d3`.`tab2`.`PAID` AS `PAID`,`d3`.`tab2`.`aktuelleaktion` AS `aktuelleaktion` from `d3`.`tab2` */;

--
-- Current Database: `d2`
--

USE `d2`;

--
-- Current Database: `d3`
--

USE `d3`;


