-- MySQL dump 10.13 Distrib 5.5.20, for Linux (x86_64) -- -- Host: localhost Database: xmt -- ------------------------------------------------------ -- Server version 5.5.24-debug-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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `tblvpe3_5iem_233` -- DROP TABLE IF EXISTS `tblvpe3_5iem_233`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblvpe3_5iem_233` ( `Col_0` int(11) DEFAULT NULL, `Col_1` varchar(300) DEFAULT NULL, `Col_2` varchar(300) DEFAULT NULL, `Col_3` varchar(300) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table21_fktblvpe3_5iem_233` (`Key_0`), KEY `fk_y4in_r4sy_222_Table26_fktblvpe3_5iem_233` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableV3_fktblvpe3_5iem_233` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableV1_fktblvpe3_5iem_233` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_TableV1_fktblvpe3_5iem_233` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableV1` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table21_fktblvpe3_5iem_233` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table21` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table26_fktblvpe3_5iem_233` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table26` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV3_fktblvpe3_5iem_233` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableV3` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblvpe3_5iem_233` -- LOCK TABLES `tblvpe3_5iem_233` WRITE; /*!40000 ALTER TABLE `tblvpe3_5iem_233` DISABLE KEYS */; /*!40000 ALTER TABLE `tblvpe3_5iem_233` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblwsf8_txi9_552` -- DROP TABLE IF EXISTS `tblwsf8_txi9_552`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblwsf8_txi9_552` ( `Col_0` int(11) DEFAULT NULL, `Col_1` varchar(300) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` varchar(300) DEFAULT NULL, `Col_4` varchar(300) DEFAULT NULL, `Col_5` varchar(300) DEFAULT NULL, `Col_6` float DEFAULT NULL, `Col_7` varchar(300) DEFAULT NULL, `Col_8` varchar(300) DEFAULT NULL, `Col_9` varchar(300) DEFAULT NULL, `Col_10` varchar(300) DEFAULT NULL, `Col_11` float DEFAULT NULL, `Col_12` float DEFAULT NULL, `Col_13` float DEFAULT NULL, `Col_14` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table21_fktblwsf8_txi9_552` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableV10_fktblwsf8_txi9_552` (`Key_1`), KEY `fk_y4in_r4sy_222_Table25_fktblwsf8_txi9_552` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableV15_fktblwsf8_txi9_552` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_TableV15_fktblwsf8_txi9_552` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableV15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table21_fktblwsf8_txi9_552` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table21` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table25_fktblwsf8_txi9_552` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table25` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV10_fktblwsf8_txi9_552` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableV10` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblwsf8_txi9_552` -- LOCK TABLES `tblwsf8_txi9_552` WRITE; /*!40000 ALTER TABLE `tblwsf8_txi9_552` DISABLE KEYS */; /*!40000 ALTER TABLE `tblwsf8_txi9_552` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table14` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table14`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table14` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableV2_fktbly4in_r4sy_222_Table14` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC9_fktbly4in_r4sy_222_Table14` (`Key_1`), KEY `fk_zrnt_3pme_141_ui_fktbly4in_r4sy_222_Table14` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableV8_fktbly4in_r4sy_222_Table14` (`Key_3`), KEY `fk_y4in_r4sy_222_Table21_fktbly4in_r4sy_222_Table14` (`Key_4`), CONSTRAINT `fk_y4in_r4sy_222_Table21_fktbly4in_r4sy_222_Table14` FOREIGN KEY (`Key_4`) REFERENCES `tbly4in_r4sy_222_Table21` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC9_fktbly4in_r4sy_222_Table14` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC9` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV2_fktbly4in_r4sy_222_Table14` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableV2` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV8_fktbly4in_r4sy_222_Table14` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableV8` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_ui_fktbly4in_r4sy_222_Table14` FOREIGN KEY (`Key_2`) REFERENCES `tblzrnt_3pme_141_ui` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table14` -- LOCK TABLES `tbly4in_r4sy_222_Table14` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table14` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table14` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table15` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table15`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table15` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zrnt_3pme_141_model_fktbly4in_r4sy_222_Table15` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC7_fktbly4in_r4sy_222_Table15` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC8_fktbly4in_r4sy_222_Table15` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableV13_fktbly4in_r4sy_222_Table15` (`Key_3`), KEY `fk_zbf7_3pkj_223_TableV8_fktbly4in_r4sy_222_Table15` (`Key_4`), CONSTRAINT `fk_zbf7_3pkj_223_TableV8_fktbly4in_r4sy_222_Table15` FOREIGN KEY (`Key_4`) REFERENCES `tblzbf7_3pkj_223_TableV8` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC7_fktbly4in_r4sy_222_Table15` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC7` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC8_fktbly4in_r4sy_222_Table15` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC8` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV13_fktbly4in_r4sy_222_Table15` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableV13` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_model_fktbly4in_r4sy_222_Table15` FOREIGN KEY (`Key_0`) REFERENCES `tblzrnt_3pme_141_model` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table15` -- LOCK TABLES `tbly4in_r4sy_222_Table15` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table15` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table15` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table16` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table16`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table16` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC9_fktbly4in_r4sy_222_Table16` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC10_fktbly4in_r4sy_222_Table16` (`Key_1`), CONSTRAINT `fk_zbf7_3pkj_223_TableC10_fktbly4in_r4sy_222_Table16` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC10` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC9_fktbly4in_r4sy_222_Table16` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC9` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table16` -- LOCK TABLES `tbly4in_r4sy_222_Table16` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table16` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table16` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table17` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table17`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table17` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zrnt_3pme_141_es_fin_fktbly4in_r4sy_222_Table17` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableV1_fktbly4in_r4sy_222_Table17` (`Key_1`), CONSTRAINT `fk_zbf7_3pkj_223_TableV1_fktbly4in_r4sy_222_Table17` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableV1` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_es_fin_fktbly4in_r4sy_222_Table17` FOREIGN KEY (`Key_0`) REFERENCES `tblzrnt_3pme_141_es_fin` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table17` -- LOCK TABLES `tbly4in_r4sy_222_Table17` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table17` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table17` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table18` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table18`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table18` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_yvrm_bgu2_392_natural_gas_c_fktbly4in_r4sy_222_Table18` (`Key_0`), KEY `fk_zrnt_3pme_141_iu_profiling__fktbly4in_r4sy_222_Table18` (`Key_1`), KEY `fk_y4in_r4sy_222_Table23_fktbly4in_r4sy_222_Table18` (`Key_2`), KEY `fk_vpe3_5iem_233_fktbly4in_r4sy_222_Table18` (`Key_3`), CONSTRAINT `fk_vpe3_5iem_233_fktbly4in_r4sy_222_Table18` FOREIGN KEY (`Key_3`) REFERENCES `tblvpe3_5iem_233` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table23_fktbly4in_r4sy_222_Table18` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table23` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_yvrm_bgu2_392_natural_gas_c_fktbly4in_r4sy_222_Table18` FOREIGN KEY (`Key_0`) REFERENCES `tblyvrm_bgu2_392_natural_gas_comsumption` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_iu_profiling__fktbly4in_r4sy_222_Table18` FOREIGN KEY (`Key_1`) REFERENCES `tblzrnt_3pme_141_iu_profiling_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table18` -- LOCK TABLES `tbly4in_r4sy_222_Table18` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table18` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table18` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table19` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table19`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table19` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, `Key_5` bigint(20) DEFAULT NULL, `Key_6` bigint(20) DEFAULT NULL, `Key_7` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_vpe3_5iem_233_fktbly4in_r4sy_222_Table19` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC14_fktbly4in_r4sy_222_Table19` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC10_fktbly4in_r4sy_222_Table19` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC4_fktbly4in_r4sy_222_Table19` (`Key_3`), KEY `fk_zbf7_3pkj_223_TableV8_fktbly4in_r4sy_222_Table19` (`Key_4`), KEY `fk_zbf7_3pkj_223_TableC15_fktbly4in_r4sy_222_Table19` (`Key_5`), KEY `fk_y4in_r4sy_222_Table22_fktbly4in_r4sy_222_Table19` (`Key_6`), KEY `fk_y4in_r4sy_222_Table28_fktbly4in_r4sy_222_Table19` (`Key_7`), CONSTRAINT `fk_y4in_r4sy_222_Table28_fktbly4in_r4sy_222_Table19` FOREIGN KEY (`Key_7`) REFERENCES `tbly4in_r4sy_222_Table28` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_vpe3_5iem_233_fktbly4in_r4sy_222_Table19` FOREIGN KEY (`Key_0`) REFERENCES `tblvpe3_5iem_233` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table22_fktbly4in_r4sy_222_Table19` FOREIGN KEY (`Key_6`) REFERENCES `tbly4in_r4sy_222_Table22` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC10_fktbly4in_r4sy_222_Table19` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC10` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC14_fktbly4in_r4sy_222_Table19` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC15_fktbly4in_r4sy_222_Table19` FOREIGN KEY (`Key_5`) REFERENCES `tblzbf7_3pkj_223_TableC15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC4_fktbly4in_r4sy_222_Table19` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC4` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV8_fktbly4in_r4sy_222_Table19` FOREIGN KEY (`Key_4`) REFERENCES `tblzbf7_3pkj_223_TableV8` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table19` -- LOCK TABLES `tbly4in_r4sy_222_Table19` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table19` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table19` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table20` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table20`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table20` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_yvrm_bgu2_392_natural_gas_c_fktbly4in_r4sy_222_Table20` (`Key_0`), KEY `fk_zrnt_3pme_141_es_fin_fktbly4in_r4sy_222_Table20` (`Key_1`), KEY `fk_y4in_r4sy_222_Table24_fktbly4in_r4sy_222_Table20` (`Key_2`), KEY `fk_zbf7_3pkj_223_Table14_fktbly4in_r4sy_222_Table20` (`Key_3`), KEY `fk_zrnt_3pme_141_wia_adult_fktbly4in_r4sy_222_Table20` (`Key_4`), CONSTRAINT `fk_zrnt_3pme_141_wia_adult_fktbly4in_r4sy_222_Table20` FOREIGN KEY (`Key_4`) REFERENCES `tblzrnt_3pme_141_wia_adult` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table24_fktbly4in_r4sy_222_Table20` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table24` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_yvrm_bgu2_392_natural_gas_c_fktbly4in_r4sy_222_Table20` FOREIGN KEY (`Key_0`) REFERENCES `tblyvrm_bgu2_392_natural_gas_comsumption` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table14_fktbly4in_r4sy_222_Table20` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_Table14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_es_fin_fktbly4in_r4sy_222_Table20` FOREIGN KEY (`Key_1`) REFERENCES `tblzrnt_3pme_141_es_fin` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table20` -- LOCK TABLES `tbly4in_r4sy_222_Table20` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table20` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table20` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table21` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table21`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table21` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` varchar(300) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `Col_10` int(11) DEFAULT NULL, `Col_11` varchar(300) DEFAULT NULL, `Col_12` int(11) DEFAULT NULL, `Col_13` int(11) DEFAULT NULL, `Col_14` int(11) DEFAULT NULL, `Col_15` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC9_fktbly4in_r4sy_222_Table21` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC12_fktbly4in_r4sy_222_Table21` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC13_fktbly4in_r4sy_222_Table21` (`Key_2`), KEY `fk_y4in_r4sy_222_Table23_fktbly4in_r4sy_222_Table21` (`Key_3`), KEY `fk_zbf7_3pkj_223_TableV12_fktbly4in_r4sy_222_Table21` (`Key_4`), CONSTRAINT `fk_zbf7_3pkj_223_TableV12_fktbly4in_r4sy_222_Table21` FOREIGN KEY (`Key_4`) REFERENCES `tblzbf7_3pkj_223_TableV12` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table23_fktbly4in_r4sy_222_Table21` FOREIGN KEY (`Key_3`) REFERENCES `tbly4in_r4sy_222_Table23` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC12_fktbly4in_r4sy_222_Table21` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC12` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC13_fktbly4in_r4sy_222_Table21` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC13` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC9_fktbly4in_r4sy_222_Table21` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC9` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table21` -- LOCK TABLES `tbly4in_r4sy_222_Table21` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table21` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table21` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table22` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table22`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table22` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC4_fktbly4in_r4sy_222_Table22` (`Key_0`), KEY `fk_zbf7_3pkj_223_Table19_fktbly4in_r4sy_222_Table22` (`Key_1`), CONSTRAINT `fk_zbf7_3pkj_223_Table19_fktbly4in_r4sy_222_Table22` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_Table19` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC4_fktbly4in_r4sy_222_Table22` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC4` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table22` -- LOCK TABLES `tbly4in_r4sy_222_Table22` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table22` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table22` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table23` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table23`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table23` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC9_fktbly4in_r4sy_222_Table23` (`Key_0`), KEY `fk_zrnt_3pme_141_iu_profiling__fktbly4in_r4sy_222_Table23` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableV7_fktbly4in_r4sy_222_Table23` (`Key_2`), KEY `fk_zbf7_3pkj_223_Table14_fktbly4in_r4sy_222_Table23` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_Table14_fktbly4in_r4sy_222_Table23` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_Table14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC9_fktbly4in_r4sy_222_Table23` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC9` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV7_fktbly4in_r4sy_222_Table23` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableV7` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_iu_profiling__fktbly4in_r4sy_222_Table23` FOREIGN KEY (`Key_1`) REFERENCES `tblzrnt_3pme_141_iu_profiling_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table23` -- LOCK TABLES `tbly4in_r4sy_222_Table23` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table23` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table23` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table24` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table24`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table24` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `Col_10` int(11) DEFAULT NULL, `Col_11` int(11) DEFAULT NULL, `Col_12` int(11) DEFAULT NULL, `Col_13` int(11) DEFAULT NULL, `Col_14` int(11) DEFAULT NULL, `Col_15` int(11) DEFAULT NULL, `Col_16` int(11) DEFAULT NULL, `Col_17` int(11) DEFAULT NULL, `Col_18` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, `Key_5` bigint(20) DEFAULT NULL, `Key_6` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_Table19_fktbly4in_r4sy_222_Table24` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC8_fktbly4in_r4sy_222_Table24` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableV15_fktbly4in_r4sy_222_Table24` (`Key_2`), KEY `fk_y4in_r4sy_222_Table20_fktbly4in_r4sy_222_Table24` (`Key_3`), KEY `fk_zbf7_3pkj_223_TableC9_fktbly4in_r4sy_222_Table24` (`Key_4`), KEY `fk_zrnt_3pme_141_economy_final_fktbly4in_r4sy_222_Table24` (`Key_5`), KEY `fk_zrnt_3pme_141_iu_profiling__fktbly4in_r4sy_222_Table24` (`Key_6`), CONSTRAINT `fk_zrnt_3pme_141_iu_profiling__fktbly4in_r4sy_222_Table24` FOREIGN KEY (`Key_6`) REFERENCES `tblzrnt_3pme_141_iu_profiling_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table20_fktbly4in_r4sy_222_Table24` FOREIGN KEY (`Key_3`) REFERENCES `tbly4in_r4sy_222_Table20` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table19_fktbly4in_r4sy_222_Table24` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_Table19` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC8_fktbly4in_r4sy_222_Table24` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC8` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC9_fktbly4in_r4sy_222_Table24` FOREIGN KEY (`Key_4`) REFERENCES `tblzbf7_3pkj_223_TableC9` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV15_fktbly4in_r4sy_222_Table24` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableV15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_economy_final_fktbly4in_r4sy_222_Table24` FOREIGN KEY (`Key_5`) REFERENCES `tblzrnt_3pme_141_economy_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table24` -- LOCK TABLES `tbly4in_r4sy_222_Table24` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table24` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table24` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table25` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table25`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table25` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableV15_fktbly4in_r4sy_222_Table25` (`Key_0`), KEY `fk_y4in_r4sy_222_Table22_fktbly4in_r4sy_222_Table25` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableV10_fktbly4in_r4sy_222_Table25` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC8_fktbly4in_r4sy_222_Table25` (`Key_3`), KEY `fk_zbf7_3pkj_223_Table19_fktbly4in_r4sy_222_Table25` (`Key_4`), CONSTRAINT `fk_zbf7_3pkj_223_Table19_fktbly4in_r4sy_222_Table25` FOREIGN KEY (`Key_4`) REFERENCES `tblzbf7_3pkj_223_Table19` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table22_fktbly4in_r4sy_222_Table25` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table22` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC8_fktbly4in_r4sy_222_Table25` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC8` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV10_fktbly4in_r4sy_222_Table25` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableV10` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV15_fktbly4in_r4sy_222_Table25` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableV15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table25` -- LOCK TABLES `tbly4in_r4sy_222_Table25` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table25` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table25` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table26` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table26`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table26` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableV3_fktbly4in_r4sy_222_Table26` (`Key_0`), KEY `fk_y4in_r4sy_222_Table18_fktbly4in_r4sy_222_Table26` (`Key_1`), KEY `fk_zbf7_3pkj_223_Table14_fktbly4in_r4sy_222_Table26` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC15_fktbly4in_r4sy_222_Table26` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_TableC15_fktbly4in_r4sy_222_Table26` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table18_fktbly4in_r4sy_222_Table26` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table18` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table14_fktbly4in_r4sy_222_Table26` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_Table14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV3_fktbly4in_r4sy_222_Table26` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableV3` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table26` -- LOCK TABLES `tbly4in_r4sy_222_Table26` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table26` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table26` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table27` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table27`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table27` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableV6_fktbly4in_r4sy_222_Table27` (`Key_0`), KEY `fk_zbf7_3pkj_223_Table16_fktbly4in_r4sy_222_Table27` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC5_fktbly4in_r4sy_222_Table27` (`Key_2`), CONSTRAINT `fk_zbf7_3pkj_223_TableC5_fktbly4in_r4sy_222_Table27` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC5` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table16_fktbly4in_r4sy_222_Table27` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_Table16` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV6_fktbly4in_r4sy_222_Table27` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableV6` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table27` -- LOCK TABLES `tbly4in_r4sy_222_Table27` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table27` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table27` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbly4in_r4sy_222_Table28` -- DROP TABLE IF EXISTS `tbly4in_r4sy_222_Table28`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbly4in_r4sy_222_Table28` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC14_fktbly4in_r4sy_222_Table28` (`Key_0`), KEY `fk_zrnt_3pme_141_es_fin_fktbly4in_r4sy_222_Table28` (`Key_1`), KEY `fk_y4in_r4sy_222_Table26_fktbly4in_r4sy_222_Table28` (`Key_2`), CONSTRAINT `fk_y4in_r4sy_222_Table26_fktbly4in_r4sy_222_Table28` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table26` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC14_fktbly4in_r4sy_222_Table28` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_es_fin_fktbly4in_r4sy_222_Table28` FOREIGN KEY (`Key_1`) REFERENCES `tblzrnt_3pme_141_es_fin` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbly4in_r4sy_222_Table28` -- LOCK TABLES `tbly4in_r4sy_222_Table28` WRITE; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table28` DISABLE KEYS */; /*!40000 ALTER TABLE `tbly4in_r4sy_222_Table28` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblyvrm_bgu2_392_natural_gas_comsumption` -- DROP TABLE IF EXISTS `tblyvrm_bgu2_392_natural_gas_comsumption`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblyvrm_bgu2_392_natural_gas_comsumption` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_Table20_fktblyvrm_bgu2_392_natural_gas_comsump` (`Key_0`), KEY `fk_y4in_r4sy_222_Table18_fktblyvrm_bgu2_392_natural_gas_comsump` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC6_fktblyvrm_bgu2_392_natural_gas_comsump` (`Key_2`), KEY `fk_zrnt_3pme_141_ui_fktblyvrm_bgu2_392_natural_gas_comsumption` (`Key_3`), CONSTRAINT `fk_zrnt_3pme_141_ui_fktblyvrm_bgu2_392_natural_gas_comsumption` FOREIGN KEY (`Key_3`) REFERENCES `tblzrnt_3pme_141_ui` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table18_fktblyvrm_bgu2_392_natural_gas_comsump` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table18` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table20_fktblyvrm_bgu2_392_natural_gas_comsump` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_Table20` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC6_fktblyvrm_bgu2_392_natural_gas_comsump` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC6` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblyvrm_bgu2_392_natural_gas_comsumption` -- LOCK TABLES `tblyvrm_bgu2_392_natural_gas_comsumption` WRITE; /*!40000 ALTER TABLE `tblyvrm_bgu2_392_natural_gas_comsumption` DISABLE KEYS */; /*!40000 ALTER TABLE `tblyvrm_bgu2_392_natural_gas_comsumption` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_Table14` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_Table14`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_Table14` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC1_fktblzbf7_3pkj_223_Table14` (`Key_0`), KEY `fk_zrnt_3pme_141_model_fktblzbf7_3pkj_223_Table14` (`Key_1`), KEY `fk_y4in_r4sy_222_Table16_fktblzbf7_3pkj_223_Table14` (`Key_2`), KEY `fk_y4in_r4sy_222_Table28_fktblzbf7_3pkj_223_Table14` (`Key_3`), CONSTRAINT `fk_y4in_r4sy_222_Table28_fktblzbf7_3pkj_223_Table14` FOREIGN KEY (`Key_3`) REFERENCES `tbly4in_r4sy_222_Table28` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table16_fktblzbf7_3pkj_223_Table14` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table16` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC1_fktblzbf7_3pkj_223_Table14` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC1` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_model_fktblzbf7_3pkj_223_Table14` FOREIGN KEY (`Key_1`) REFERENCES `tblzrnt_3pme_141_model` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_Table14` -- LOCK TABLES `tblzbf7_3pkj_223_Table14` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_Table14` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_Table14` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_Table15` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_Table15`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_Table15` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_Table16_fktblzbf7_3pkj_223_Table15` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC5_fktblzbf7_3pkj_223_Table15` (`Key_1`), KEY `fk_vpe3_5iem_233_fktblzbf7_3pkj_223_Table15` (`Key_2`), CONSTRAINT `fk_vpe3_5iem_233_fktblzbf7_3pkj_223_Table15` FOREIGN KEY (`Key_2`) REFERENCES `tblvpe3_5iem_233` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table16_fktblzbf7_3pkj_223_Table15` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_Table16` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC5_fktblzbf7_3pkj_223_Table15` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC5` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_Table15` -- LOCK TABLES `tblzbf7_3pkj_223_Table15` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_Table15` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_Table15` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_Table16` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_Table16`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_Table16` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC15_fktblzbf7_3pkj_223_Table16` (`Key_0`), KEY `fk_y4in_r4sy_222_Table27_fktblzbf7_3pkj_223_Table16` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC6_fktblzbf7_3pkj_223_Table16` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC12_fktblzbf7_3pkj_223_Table16` (`Key_3`), KEY `fk_y4in_r4sy_222_Table15_fktblzbf7_3pkj_223_Table16` (`Key_4`), CONSTRAINT `fk_y4in_r4sy_222_Table15_fktblzbf7_3pkj_223_Table16` FOREIGN KEY (`Key_4`) REFERENCES `tbly4in_r4sy_222_Table15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table27_fktblzbf7_3pkj_223_Table16` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table27` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC12_fktblzbf7_3pkj_223_Table16` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC12` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC15_fktblzbf7_3pkj_223_Table16` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC6_fktblzbf7_3pkj_223_Table16` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC6` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_Table16` -- LOCK TABLES `tblzbf7_3pkj_223_Table16` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_Table16` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_Table16` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_Table18` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_Table18`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_Table18` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table15_fktblzbf7_3pkj_223_Table18` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC13_fktblzbf7_3pkj_223_Table18` (`Key_1`), KEY `fk_zrnt_3pme_141_ui_fktblzbf7_3pkj_223_Table18` (`Key_2`), CONSTRAINT `fk_zrnt_3pme_141_ui_fktblzbf7_3pkj_223_Table18` FOREIGN KEY (`Key_2`) REFERENCES `tblzrnt_3pme_141_ui` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table15_fktblzbf7_3pkj_223_Table18` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC13_fktblzbf7_3pkj_223_Table18` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC13` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_Table18` -- LOCK TABLES `tblzbf7_3pkj_223_Table18` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_Table18` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_Table18` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_Table19` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_Table19`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_Table19` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, `Key_5` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table28_fktblzbf7_3pkj_223_Table19` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableV10_fktblzbf7_3pkj_223_Table19` (`Key_1`), KEY `fk_zbf7_3pkj_223_Table16_fktblzbf7_3pkj_223_Table19` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC2_fktblzbf7_3pkj_223_Table19` (`Key_3`), KEY `fk_zbf7_3pkj_223_Table14_fktblzbf7_3pkj_223_Table19` (`Key_4`), KEY `fk_zbf7_3pkj_223_TableC9_fktblzbf7_3pkj_223_Table19` (`Key_5`), CONSTRAINT `fk_zbf7_3pkj_223_TableC9_fktblzbf7_3pkj_223_Table19` FOREIGN KEY (`Key_5`) REFERENCES `tblzbf7_3pkj_223_TableC9` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table28_fktblzbf7_3pkj_223_Table19` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table28` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table14_fktblzbf7_3pkj_223_Table19` FOREIGN KEY (`Key_4`) REFERENCES `tblzbf7_3pkj_223_Table14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table16_fktblzbf7_3pkj_223_Table19` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_Table16` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC2_fktblzbf7_3pkj_223_Table19` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC2` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV10_fktblzbf7_3pkj_223_Table19` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableV10` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_Table19` -- LOCK TABLES `tblzbf7_3pkj_223_Table19` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_Table19` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_Table19` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_Table20` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_Table20`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_Table20` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC12_fktblzbf7_3pkj_223_Table20` (`Key_0`), KEY `fk_zrnt_3pme_141_iu_profiling__fktblzbf7_3pkj_223_Table20` (`Key_1`), KEY `fk_y4in_r4sy_222_Table15_fktblzbf7_3pkj_223_Table20` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableV11_fktblzbf7_3pkj_223_Table20` (`Key_3`), KEY `fk_zbf7_3pkj_223_Table14_fktblzbf7_3pkj_223_Table20` (`Key_4`), CONSTRAINT `fk_zbf7_3pkj_223_Table14_fktblzbf7_3pkj_223_Table20` FOREIGN KEY (`Key_4`) REFERENCES `tblzbf7_3pkj_223_Table14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table15_fktblzbf7_3pkj_223_Table20` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC12_fktblzbf7_3pkj_223_Table20` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC12` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV11_fktblzbf7_3pkj_223_Table20` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableV11` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_iu_profiling__fktblzbf7_3pkj_223_Table20` FOREIGN KEY (`Key_1`) REFERENCES `tblzrnt_3pme_141_iu_profiling_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_Table20` -- LOCK TABLES `tblzbf7_3pkj_223_Table20` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_Table20` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_Table20` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC1` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC1` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC10_fktblzbf7_3pkj_223_TableC1` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC3_fktblzbf7_3pkj_223_TableC1` (`Key_1`), KEY `fk_zbf7_3pkj_223_Table16_fktblzbf7_3pkj_223_TableC1` (`Key_2`), KEY `fk_zbf7_3pkj_223_Table19_fktblzbf7_3pkj_223_TableC1` (`Key_3`), KEY `fk_vpe3_5iem_233_fktblzbf7_3pkj_223_TableC1` (`Key_4`), CONSTRAINT `fk_vpe3_5iem_233_fktblzbf7_3pkj_223_TableC1` FOREIGN KEY (`Key_4`) REFERENCES `tblvpe3_5iem_233` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table16_fktblzbf7_3pkj_223_TableC1` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_Table16` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table19_fktblzbf7_3pkj_223_TableC1` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_Table19` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC10_fktblzbf7_3pkj_223_TableC1` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC10` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC3_fktblzbf7_3pkj_223_TableC1` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC3` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC1` -- LOCK TABLES `tblzbf7_3pkj_223_TableC1` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC1` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC1` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC10` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC10`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC10` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zrnt_3pme_141_model_fktblzbf7_3pkj_223_TableC10` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableV5_fktblzbf7_3pkj_223_TableC10` (`Key_1`), CONSTRAINT `fk_zbf7_3pkj_223_TableV5_fktblzbf7_3pkj_223_TableC10` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableV5` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_model_fktblzbf7_3pkj_223_TableC10` FOREIGN KEY (`Key_0`) REFERENCES `tblzrnt_3pme_141_model` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC10` -- LOCK TABLES `tblzbf7_3pkj_223_TableC10` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC10` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC10` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC11` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC11`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC11` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC5_fktblzbf7_3pkj_223_TableC11` (`Key_0`), KEY `fk_yvrm_bgu2_392_natural_gas_c_fktblzbf7_3pkj_223_TableC11` (`Key_1`), KEY `fk_zrnt_3pme_141_economy_final_fktblzbf7_3pkj_223_TableC11` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC4_fktblzbf7_3pkj_223_TableC11` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_TableC4_fktblzbf7_3pkj_223_TableC11` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC4` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_yvrm_bgu2_392_natural_gas_c_fktblzbf7_3pkj_223_TableC11` FOREIGN KEY (`Key_1`) REFERENCES `tblyvrm_bgu2_392_natural_gas_comsumption` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC5_fktblzbf7_3pkj_223_TableC11` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC5` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_economy_final_fktblzbf7_3pkj_223_TableC11` FOREIGN KEY (`Key_2`) REFERENCES `tblzrnt_3pme_141_economy_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC11` -- LOCK TABLES `tblzbf7_3pkj_223_TableC11` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC11` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC11` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC12` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC12`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC12` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC4_fktblzbf7_3pkj_223_TableC12` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC10_fktblzbf7_3pkj_223_TableC12` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableV11_fktblzbf7_3pkj_223_TableC12` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableV2_fktblzbf7_3pkj_223_TableC12` (`Key_3`), KEY `fk_zbf7_3pkj_223_TableV5_fktblzbf7_3pkj_223_TableC12` (`Key_4`), CONSTRAINT `fk_zbf7_3pkj_223_TableV5_fktblzbf7_3pkj_223_TableC12` FOREIGN KEY (`Key_4`) REFERENCES `tblzbf7_3pkj_223_TableV5` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC10_fktblzbf7_3pkj_223_TableC12` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC10` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC4_fktblzbf7_3pkj_223_TableC12` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC4` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV11_fktblzbf7_3pkj_223_TableC12` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableV11` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV2_fktblzbf7_3pkj_223_TableC12` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableV2` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC12` -- LOCK TABLES `tblzbf7_3pkj_223_TableC12` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC12` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC12` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC13` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC13`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC13` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableV4_fktblzbf7_3pkj_223_TableC13` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableV8_fktblzbf7_3pkj_223_TableC13` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC14_fktblzbf7_3pkj_223_TableC13` (`Key_2`), CONSTRAINT `fk_zbf7_3pkj_223_TableC14_fktblzbf7_3pkj_223_TableC13` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV4_fktblzbf7_3pkj_223_TableC13` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableV4` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV8_fktblzbf7_3pkj_223_TableC13` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableV8` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC13` -- LOCK TABLES `tblzbf7_3pkj_223_TableC13` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC13` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC13` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC14` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC14`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC14` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC10_fktblzbf7_3pkj_223_TableC14` (`Key_0`), KEY `fk_y4in_r4sy_222_Table19_fktblzbf7_3pkj_223_TableC14` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC4_fktblzbf7_3pkj_223_TableC14` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableV11_fktblzbf7_3pkj_223_TableC14` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_TableV11_fktblzbf7_3pkj_223_TableC14` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableV11` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table19_fktblzbf7_3pkj_223_TableC14` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table19` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC10_fktblzbf7_3pkj_223_TableC14` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC10` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC4_fktblzbf7_3pkj_223_TableC14` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC4` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC14` -- LOCK TABLES `tblzbf7_3pkj_223_TableC14` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC14` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC14` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC15` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC15`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC15` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, `Key_5` bigint(20) DEFAULT NULL, `Key_6` bigint(20) DEFAULT NULL, `Key_7` bigint(20) DEFAULT NULL, `Key_8` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table24_fktblzbf7_3pkj_223_TableC15` (`Key_0`), KEY `fk_y4in_r4sy_222_Table16_fktblzbf7_3pkj_223_TableC15` (`Key_1`), KEY `fk_zrnt_3pme_141_final_fktblzbf7_3pkj_223_TableC15` (`Key_2`), KEY `fk_y4in_r4sy_222_Table22_fktblzbf7_3pkj_223_TableC15` (`Key_3`), KEY `fk_zbf7_3pkj_223_TableV6_fktblzbf7_3pkj_223_TableC15` (`Key_4`), KEY `fk_zbf7_3pkj_223_Table14_fktblzbf7_3pkj_223_TableC15` (`Key_5`), KEY `fk_zbf7_3pkj_223_TableV4_fktblzbf7_3pkj_223_TableC15` (`Key_6`), KEY `fk_zbf7_3pkj_223_TableC14_fktblzbf7_3pkj_223_TableC15` (`Key_7`), KEY `fk_zrnt_3pme_141_wia_adult_fktblzbf7_3pkj_223_TableC15` (`Key_8`), CONSTRAINT `fk_zrnt_3pme_141_wia_adult_fktblzbf7_3pkj_223_TableC15` FOREIGN KEY (`Key_8`) REFERENCES `tblzrnt_3pme_141_wia_adult` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table16_fktblzbf7_3pkj_223_TableC15` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table16` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table22_fktblzbf7_3pkj_223_TableC15` FOREIGN KEY (`Key_3`) REFERENCES `tbly4in_r4sy_222_Table22` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table24_fktblzbf7_3pkj_223_TableC15` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table24` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table14_fktblzbf7_3pkj_223_TableC15` FOREIGN KEY (`Key_5`) REFERENCES `tblzbf7_3pkj_223_Table14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC14_fktblzbf7_3pkj_223_TableC15` FOREIGN KEY (`Key_7`) REFERENCES `tblzbf7_3pkj_223_TableC14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV4_fktblzbf7_3pkj_223_TableC15` FOREIGN KEY (`Key_6`) REFERENCES `tblzbf7_3pkj_223_TableV4` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV6_fktblzbf7_3pkj_223_TableC15` FOREIGN KEY (`Key_4`) REFERENCES `tblzbf7_3pkj_223_TableV6` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_final_fktblzbf7_3pkj_223_TableC15` FOREIGN KEY (`Key_2`) REFERENCES `tblzrnt_3pme_141_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC15` -- LOCK TABLES `tblzbf7_3pkj_223_TableC15` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC15` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC15` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC2` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC2`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC2` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` varchar(300) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_Table15_fktblzbf7_3pkj_223_TableC2` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableV14_fktblzbf7_3pkj_223_TableC2` (`Key_1`), CONSTRAINT `fk_zbf7_3pkj_223_TableV14_fktblzbf7_3pkj_223_TableC2` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableV14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table15_fktblzbf7_3pkj_223_TableC2` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_Table15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC2` -- LOCK TABLES `tblzbf7_3pkj_223_TableC2` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC2` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC2` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC3` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC3`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC3` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zrnt_3pme_141_ui_fktblzbf7_3pkj_223_TableC3` (`Key_0`), KEY `fk_zrnt_3pme_141_economy_final_fktblzbf7_3pkj_223_TableC3` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableV15_fktblzbf7_3pkj_223_TableC3` (`Key_2`), KEY `fk_y4in_r4sy_222_Table21_fktblzbf7_3pkj_223_TableC3` (`Key_3`), KEY `fk_y4in_r4sy_222_Table25_fktblzbf7_3pkj_223_TableC3` (`Key_4`), CONSTRAINT `fk_y4in_r4sy_222_Table25_fktblzbf7_3pkj_223_TableC3` FOREIGN KEY (`Key_4`) REFERENCES `tbly4in_r4sy_222_Table25` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table21_fktblzbf7_3pkj_223_TableC3` FOREIGN KEY (`Key_3`) REFERENCES `tbly4in_r4sy_222_Table21` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV15_fktblzbf7_3pkj_223_TableC3` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableV15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_economy_final_fktblzbf7_3pkj_223_TableC3` FOREIGN KEY (`Key_1`) REFERENCES `tblzrnt_3pme_141_economy_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_ui_fktblzbf7_3pkj_223_TableC3` FOREIGN KEY (`Key_0`) REFERENCES `tblzrnt_3pme_141_ui` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC3` -- LOCK TABLES `tblzbf7_3pkj_223_TableC3` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC3` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC3` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC4` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC4`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC4` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table16_fktblzbf7_3pkj_223_TableC4` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC7_fktblzbf7_3pkj_223_TableC4` (`Key_1`), KEY `fk_zrnt_3pme_141_iu_profiling__fktblzbf7_3pkj_223_TableC4` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableV15_fktblzbf7_3pkj_223_TableC4` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_TableV15_fktblzbf7_3pkj_223_TableC4` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableV15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table16_fktblzbf7_3pkj_223_TableC4` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table16` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC7_fktblzbf7_3pkj_223_TableC4` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC7` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_iu_profiling__fktblzbf7_3pkj_223_TableC4` FOREIGN KEY (`Key_2`) REFERENCES `tblzrnt_3pme_141_iu_profiling_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC4` -- LOCK TABLES `tblzbf7_3pkj_223_TableC4` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC4` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC4` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC5` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC5`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC5` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `Col_10` int(11) DEFAULT NULL, `Col_11` int(11) DEFAULT NULL, `Col_12` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_vpe3_5iem_233_fktblzbf7_3pkj_223_TableC5` (`Key_0`), KEY `fk_yvrm_bgu2_392_natural_gas_c_fktblzbf7_3pkj_223_TableC5` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableV3_fktblzbf7_3pkj_223_TableC5` (`Key_2`), KEY `fk_y4in_r4sy_222_Table21_fktblzbf7_3pkj_223_TableC5` (`Key_3`), CONSTRAINT `fk_y4in_r4sy_222_Table21_fktblzbf7_3pkj_223_TableC5` FOREIGN KEY (`Key_3`) REFERENCES `tbly4in_r4sy_222_Table21` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_vpe3_5iem_233_fktblzbf7_3pkj_223_TableC5` FOREIGN KEY (`Key_0`) REFERENCES `tblvpe3_5iem_233` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_yvrm_bgu2_392_natural_gas_c_fktblzbf7_3pkj_223_TableC5` FOREIGN KEY (`Key_1`) REFERENCES `tblyvrm_bgu2_392_natural_gas_comsumption` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV3_fktblzbf7_3pkj_223_TableC5` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableV3` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC5` -- LOCK TABLES `tblzbf7_3pkj_223_TableC5` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC5` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC5` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC6` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC6`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC6` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, `Key_5` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zrnt_3pme_141_iu_profiling__fktblzbf7_3pkj_223_TableC6` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC12_fktblzbf7_3pkj_223_TableC6` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC9_fktblzbf7_3pkj_223_TableC6` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC10_fktblzbf7_3pkj_223_TableC6` (`Key_3`), KEY `fk_y4in_r4sy_222_Table18_fktblzbf7_3pkj_223_TableC6` (`Key_4`), KEY `fk_zbf7_3pkj_223_TableV13_fktblzbf7_3pkj_223_TableC6` (`Key_5`), CONSTRAINT `fk_zbf7_3pkj_223_TableV13_fktblzbf7_3pkj_223_TableC6` FOREIGN KEY (`Key_5`) REFERENCES `tblzbf7_3pkj_223_TableV13` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table18_fktblzbf7_3pkj_223_TableC6` FOREIGN KEY (`Key_4`) REFERENCES `tbly4in_r4sy_222_Table18` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC10_fktblzbf7_3pkj_223_TableC6` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC10` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC12_fktblzbf7_3pkj_223_TableC6` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC12` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC9_fktblzbf7_3pkj_223_TableC6` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC9` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_iu_profiling__fktblzbf7_3pkj_223_TableC6` FOREIGN KEY (`Key_0`) REFERENCES `tblzrnt_3pme_141_iu_profiling_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC6` -- LOCK TABLES `tblzbf7_3pkj_223_TableC6` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC6` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC6` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC7` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC7`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC7` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_Table15_fktblzbf7_3pkj_223_TableC7` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC2_fktblzbf7_3pkj_223_TableC7` (`Key_1`), KEY `fk_zrnt_3pme_141_final_fktblzbf7_3pkj_223_TableC7` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC14_fktblzbf7_3pkj_223_TableC7` (`Key_3`), KEY `fk_zbf7_3pkj_223_TableC5_fktblzbf7_3pkj_223_TableC7` (`Key_4`), CONSTRAINT `fk_zbf7_3pkj_223_TableC5_fktblzbf7_3pkj_223_TableC7` FOREIGN KEY (`Key_4`) REFERENCES `tblzbf7_3pkj_223_TableC5` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table15_fktblzbf7_3pkj_223_TableC7` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_Table15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC14_fktblzbf7_3pkj_223_TableC7` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC2_fktblzbf7_3pkj_223_TableC7` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC2` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_final_fktblzbf7_3pkj_223_TableC7` FOREIGN KEY (`Key_2`) REFERENCES `tblzrnt_3pme_141_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC7` -- LOCK TABLES `tblzbf7_3pkj_223_TableC7` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC7` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC7` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC8` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC8`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC8` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableV7_fktblzbf7_3pkj_223_TableC8` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableV15_fktblzbf7_3pkj_223_TableC8` (`Key_1`), KEY `fk_y4in_r4sy_222_Table26_fktblzbf7_3pkj_223_TableC8` (`Key_2`), CONSTRAINT `fk_y4in_r4sy_222_Table26_fktblzbf7_3pkj_223_TableC8` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table26` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV15_fktblzbf7_3pkj_223_TableC8` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableV15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV7_fktblzbf7_3pkj_223_TableC8` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableV7` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC8` -- LOCK TABLES `tblzbf7_3pkj_223_TableC8` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC8` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC8` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableC9` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableC9`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableC9` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_wsf8_txi9_552_fktblzbf7_3pkj_223_TableC9` (`Key_0`), KEY `fk_y4in_r4sy_222_Table19_fktblzbf7_3pkj_223_TableC9` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableV13_fktblzbf7_3pkj_223_TableC9` (`Key_2`), KEY `fk_zbf7_3pkj_223_Table19_fktblzbf7_3pkj_223_TableC9` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_Table19_fktblzbf7_3pkj_223_TableC9` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_Table19` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_wsf8_txi9_552_fktblzbf7_3pkj_223_TableC9` FOREIGN KEY (`Key_0`) REFERENCES `tblwsf8_txi9_552` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table19_fktblzbf7_3pkj_223_TableC9` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table19` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV13_fktblzbf7_3pkj_223_TableC9` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableV13` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableC9` -- LOCK TABLES `tblzbf7_3pkj_223_TableC9` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC9` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableC9` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV1` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV1` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC14_fktblzbf7_3pkj_223_TableV1` (`Key_0`), KEY `fk_vpe3_5iem_233_fktblzbf7_3pkj_223_TableV1` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableV4_fktblzbf7_3pkj_223_TableV1` (`Key_2`), CONSTRAINT `fk_zbf7_3pkj_223_TableV4_fktblzbf7_3pkj_223_TableV1` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableV4` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_vpe3_5iem_233_fktblzbf7_3pkj_223_TableV1` FOREIGN KEY (`Key_1`) REFERENCES `tblvpe3_5iem_233` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC14_fktblzbf7_3pkj_223_TableV1` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC14` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV1` -- LOCK TABLES `tblzbf7_3pkj_223_TableV1` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV1` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV1` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV10` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV10`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV10` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` varchar(300) DEFAULT NULL, `Col_10` varchar(300) DEFAULT NULL, `Col_11` varchar(300) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC15_fktblzbf7_3pkj_223_TableV10` (`Key_0`), KEY `fk_y4in_r4sy_222_Table23_fktblzbf7_3pkj_223_TableV10` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableV6_fktblzbf7_3pkj_223_TableV10` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC5_fktblzbf7_3pkj_223_TableV10` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_TableC5_fktblzbf7_3pkj_223_TableV10` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC5` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table23_fktblzbf7_3pkj_223_TableV10` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table23` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC15_fktblzbf7_3pkj_223_TableV10` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV6_fktblzbf7_3pkj_223_TableV10` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableV6` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV10` -- LOCK TABLES `tblzbf7_3pkj_223_TableV10` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV10` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV10` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV11` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV11`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV11` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` varchar(300) DEFAULT NULL, `Col_10` varchar(300) DEFAULT NULL, `Col_11` varchar(300) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table26_fktblzbf7_3pkj_223_TableV11` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC8_fktblzbf7_3pkj_223_TableV11` (`Key_1`), KEY `fk_y4in_r4sy_222_Table18_fktblzbf7_3pkj_223_TableV11` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC4_fktblzbf7_3pkj_223_TableV11` (`Key_3`), KEY `fk_yvrm_bgu2_392_natural_gas_c_fktblzbf7_3pkj_223_TableV11` (`Key_4`), CONSTRAINT `fk_yvrm_bgu2_392_natural_gas_c_fktblzbf7_3pkj_223_TableV11` FOREIGN KEY (`Key_4`) REFERENCES `tblyvrm_bgu2_392_natural_gas_comsumption` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table18_fktblzbf7_3pkj_223_TableV11` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table18` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table26_fktblzbf7_3pkj_223_TableV11` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table26` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC4_fktblzbf7_3pkj_223_TableV11` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC4` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC8_fktblzbf7_3pkj_223_TableV11` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC8` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV11` -- LOCK TABLES `tblzbf7_3pkj_223_TableV11` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV11` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV11` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV12` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV12`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV12` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table22_fktblzbf7_3pkj_223_TableV12` (`Key_0`), KEY `fk_y4in_r4sy_222_Table26_fktblzbf7_3pkj_223_TableV12` (`Key_1`), KEY `fk_y4in_r4sy_222_Table18_fktblzbf7_3pkj_223_TableV12` (`Key_2`), KEY `fk_y4in_r4sy_222_Table15_fktblzbf7_3pkj_223_TableV12` (`Key_3`), CONSTRAINT `fk_y4in_r4sy_222_Table15_fktblzbf7_3pkj_223_TableV12` FOREIGN KEY (`Key_3`) REFERENCES `tbly4in_r4sy_222_Table15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table18_fktblzbf7_3pkj_223_TableV12` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table18` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table22_fktblzbf7_3pkj_223_TableV12` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table22` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table26_fktblzbf7_3pkj_223_TableV12` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table26` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV12` -- LOCK TABLES `tblzbf7_3pkj_223_TableV12` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV12` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV12` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV13` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV13`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV13` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC10_fktblzbf7_3pkj_223_TableV13` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC13_fktblzbf7_3pkj_223_TableV13` (`Key_1`), KEY `fk_zrnt_3pme_141_wia_adult_fktblzbf7_3pkj_223_TableV13` (`Key_2`), KEY `fk_wsf8_txi9_552_fktblzbf7_3pkj_223_TableV13` (`Key_3`), CONSTRAINT `fk_wsf8_txi9_552_fktblzbf7_3pkj_223_TableV13` FOREIGN KEY (`Key_3`) REFERENCES `tblwsf8_txi9_552` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC10_fktblzbf7_3pkj_223_TableV13` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC10` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC13_fktblzbf7_3pkj_223_TableV13` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC13` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_wia_adult_fktblzbf7_3pkj_223_TableV13` FOREIGN KEY (`Key_2`) REFERENCES `tblzrnt_3pme_141_wia_adult` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV13` -- LOCK TABLES `tblzbf7_3pkj_223_TableV13` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV13` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV13` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV14` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV14`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV14` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC15_fktblzbf7_3pkj_223_TableV14` (`Key_0`), KEY `fk_zrnt_3pme_141_model_fktblzbf7_3pkj_223_TableV14` (`Key_1`), KEY `fk_y4in_r4sy_222_Table28_fktblzbf7_3pkj_223_TableV14` (`Key_2`), KEY `fk_zbf7_3pkj_223_Table15_fktblzbf7_3pkj_223_TableV14` (`Key_3`), KEY `fk_zbf7_3pkj_223_TableC12_fktblzbf7_3pkj_223_TableV14` (`Key_4`), CONSTRAINT `fk_zbf7_3pkj_223_TableC12_fktblzbf7_3pkj_223_TableV14` FOREIGN KEY (`Key_4`) REFERENCES `tblzbf7_3pkj_223_TableC12` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table28_fktblzbf7_3pkj_223_TableV14` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table28` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table15_fktblzbf7_3pkj_223_TableV14` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_Table15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC15_fktblzbf7_3pkj_223_TableV14` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_model_fktblzbf7_3pkj_223_TableV14` FOREIGN KEY (`Key_1`) REFERENCES `tblzrnt_3pme_141_model` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV14` -- LOCK TABLES `tblzbf7_3pkj_223_TableV14` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV14` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV14` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV15` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV15`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV15` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `Col_10` int(11) DEFAULT NULL, `Col_11` int(11) DEFAULT NULL, `Col_12` int(11) DEFAULT NULL, `Col_13` int(11) DEFAULT NULL, `Col_14` int(11) DEFAULT NULL, `Col_15` int(11) DEFAULT NULL, `Col_16` int(11) DEFAULT NULL, `Col_17` int(11) DEFAULT NULL, `Col_18` int(11) DEFAULT NULL, `Col_19` int(11) DEFAULT NULL, `Col_20` int(11) DEFAULT NULL, `Col_21` int(11) DEFAULT NULL, `Col_22` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_wsf8_txi9_552_fktblzbf7_3pkj_223_TableV15` (`Key_0`), KEY `fk_y4in_r4sy_222_Table19_fktblzbf7_3pkj_223_TableV15` (`Key_1`), KEY `fk_vpe3_5iem_233_fktblzbf7_3pkj_223_TableV15` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableV7_fktblzbf7_3pkj_223_TableV15` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_TableV7_fktblzbf7_3pkj_223_TableV15` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableV7` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_vpe3_5iem_233_fktblzbf7_3pkj_223_TableV15` FOREIGN KEY (`Key_2`) REFERENCES `tblvpe3_5iem_233` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_wsf8_txi9_552_fktblzbf7_3pkj_223_TableV15` FOREIGN KEY (`Key_0`) REFERENCES `tblwsf8_txi9_552` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table19_fktblzbf7_3pkj_223_TableV15` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table19` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV15` -- LOCK TABLES `tblzbf7_3pkj_223_TableV15` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV15` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV15` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV2` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV2`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV2` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table25_fktblzbf7_3pkj_223_TableV2` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC2_fktblzbf7_3pkj_223_TableV2` (`Key_1`), KEY `fk_y4in_r4sy_222_Table27_fktblzbf7_3pkj_223_TableV2` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC1_fktblzbf7_3pkj_223_TableV2` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_TableC1_fktblzbf7_3pkj_223_TableV2` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC1` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table25_fktblzbf7_3pkj_223_TableV2` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table25` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table27_fktblzbf7_3pkj_223_TableV2` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table27` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC2_fktblzbf7_3pkj_223_TableV2` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC2` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV2` -- LOCK TABLES `tblzbf7_3pkj_223_TableV2` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV2` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV2` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV3` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV3`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV3` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableV4_fktblzbf7_3pkj_223_TableV3` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC12_fktblzbf7_3pkj_223_TableV3` (`Key_1`), KEY `fk_y4in_r4sy_222_Table23_fktblzbf7_3pkj_223_TableV3` (`Key_2`), KEY `fk_y4in_r4sy_222_Table15_fktblzbf7_3pkj_223_TableV3` (`Key_3`), CONSTRAINT `fk_y4in_r4sy_222_Table15_fktblzbf7_3pkj_223_TableV3` FOREIGN KEY (`Key_3`) REFERENCES `tbly4in_r4sy_222_Table15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table23_fktblzbf7_3pkj_223_TableV3` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table23` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC12_fktblzbf7_3pkj_223_TableV3` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC12` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV4_fktblzbf7_3pkj_223_TableV3` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableV4` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV3` -- LOCK TABLES `tblzbf7_3pkj_223_TableV3` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV3` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV3` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV4` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV4`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV4` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `Col_10` int(11) DEFAULT NULL, `Col_11` int(11) DEFAULT NULL, `Col_12` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table16_fktblzbf7_3pkj_223_TableV4` (`Key_0`), KEY `fk_zbf7_3pkj_223_Table19_fktblzbf7_3pkj_223_TableV4` (`Key_1`), KEY `fk_y4in_r4sy_222_Table17_fktblzbf7_3pkj_223_TableV4` (`Key_2`), CONSTRAINT `fk_y4in_r4sy_222_Table17_fktblzbf7_3pkj_223_TableV4` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table17` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table16_fktblzbf7_3pkj_223_TableV4` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table16` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table19_fktblzbf7_3pkj_223_TableV4` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_Table19` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV4` -- LOCK TABLES `tblzbf7_3pkj_223_TableV4` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV4` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV4` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV5` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV5`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV5` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableV11_fktblzbf7_3pkj_223_TableV5` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableV4_fktblzbf7_3pkj_223_TableV5` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC15_fktblzbf7_3pkj_223_TableV5` (`Key_2`), CONSTRAINT `fk_zbf7_3pkj_223_TableC15_fktblzbf7_3pkj_223_TableV5` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV11_fktblzbf7_3pkj_223_TableV5` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableV11` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV4_fktblzbf7_3pkj_223_TableV5` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableV4` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV5` -- LOCK TABLES `tblzbf7_3pkj_223_TableV5` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV5` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV5` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV6` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV6`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV6` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_Table16_fktblzbf7_3pkj_223_TableV6` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC3_fktblzbf7_3pkj_223_TableV6` (`Key_1`), KEY `fk_y4in_r4sy_222_Table17_fktblzbf7_3pkj_223_TableV6` (`Key_2`), CONSTRAINT `fk_y4in_r4sy_222_Table17_fktblzbf7_3pkj_223_TableV6` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table17` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table16_fktblzbf7_3pkj_223_TableV6` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_Table16` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC3_fktblzbf7_3pkj_223_TableV6` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC3` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV6` -- LOCK TABLES `tblzbf7_3pkj_223_TableV6` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV6` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV6` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV7` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV7`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV7` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table23_fktblzbf7_3pkj_223_TableV7` (`Key_0`), KEY `fk_zbf7_3pkj_223_Table20_fktblzbf7_3pkj_223_TableV7` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC9_fktblzbf7_3pkj_223_TableV7` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC13_fktblzbf7_3pkj_223_TableV7` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_TableC13_fktblzbf7_3pkj_223_TableV7` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC13` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table23_fktblzbf7_3pkj_223_TableV7` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table23` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table20_fktblzbf7_3pkj_223_TableV7` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_Table20` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC9_fktblzbf7_3pkj_223_TableV7` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC9` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV7` -- LOCK TABLES `tblzbf7_3pkj_223_TableV7` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV7` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV7` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV8` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV8`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV8` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, `Key_5` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC15_fktblzbf7_3pkj_223_TableV8` (`Key_0`), KEY `fk_y4in_r4sy_222_Table27_fktblzbf7_3pkj_223_TableV8` (`Key_1`), KEY `fk_zrnt_3pme_141_final_fktblzbf7_3pkj_223_TableV8` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableC10_fktblzbf7_3pkj_223_TableV8` (`Key_3`), KEY `fk_y4in_r4sy_222_Table19_fktblzbf7_3pkj_223_TableV8` (`Key_4`), KEY `fk_y4in_r4sy_222_Table22_fktblzbf7_3pkj_223_TableV8` (`Key_5`), CONSTRAINT `fk_y4in_r4sy_222_Table22_fktblzbf7_3pkj_223_TableV8` FOREIGN KEY (`Key_5`) REFERENCES `tbly4in_r4sy_222_Table22` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table19_fktblzbf7_3pkj_223_TableV8` FOREIGN KEY (`Key_4`) REFERENCES `tbly4in_r4sy_222_Table19` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table27_fktblzbf7_3pkj_223_TableV8` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table27` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC10_fktblzbf7_3pkj_223_TableV8` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableC10` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC15_fktblzbf7_3pkj_223_TableV8` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_final_fktblzbf7_3pkj_223_TableV8` FOREIGN KEY (`Key_2`) REFERENCES `tblzrnt_3pme_141_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV8` -- LOCK TABLES `tblzbf7_3pkj_223_TableV8` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV8` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV8` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzbf7_3pkj_223_TableV9` -- DROP TABLE IF EXISTS `tblzbf7_3pkj_223_TableV9`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzbf7_3pkj_223_TableV9` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` varchar(300) DEFAULT NULL, `Col_10` varchar(300) DEFAULT NULL, `Col_11` varchar(300) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableC6_fktblzbf7_3pkj_223_TableV9` (`Key_0`), KEY `fk_zrnt_3pme_141_economy_final_fktblzbf7_3pkj_223_TableV9` (`Key_1`), KEY `fk_zrnt_3pme_141_es_fin_fktblzbf7_3pkj_223_TableV9` (`Key_2`), CONSTRAINT `fk_zrnt_3pme_141_es_fin_fktblzbf7_3pkj_223_TableV9` FOREIGN KEY (`Key_2`) REFERENCES `tblzrnt_3pme_141_es_fin` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC6_fktblzbf7_3pkj_223_TableV9` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableC6` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_economy_final_fktblzbf7_3pkj_223_TableV9` FOREIGN KEY (`Key_1`) REFERENCES `tblzrnt_3pme_141_economy_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzbf7_3pkj_223_TableV9` -- LOCK TABLES `tblzbf7_3pkj_223_TableV9` WRITE; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV9` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzbf7_3pkj_223_TableV9` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzrnt_3pme_141_economy_final` -- DROP TABLE IF EXISTS `tblzrnt_3pme_141_economy_final`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzrnt_3pme_141_economy_final` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` varchar(300) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` float DEFAULT NULL, `Col_5` float DEFAULT NULL, `Col_6` float DEFAULT NULL, `Col_7` float DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, `Key_5` bigint(20) DEFAULT NULL, `Key_6` bigint(20) DEFAULT NULL, `Key_7` bigint(20) DEFAULT NULL, `Key_8` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table17_fktblzrnt_3pme_141_economy_final` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableV2_fktblzrnt_3pme_141_economy_final` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC2_fktblzrnt_3pme_141_economy_final` (`Key_2`), KEY `fk_zrnt_3pme_141_model_fktblzrnt_3pme_141_economy_final` (`Key_3`), KEY `fk_vpe3_5iem_233_fktblzrnt_3pme_141_economy_final` (`Key_4`), KEY `fk_y4in_r4sy_222_Table25_fktblzrnt_3pme_141_economy_final` (`Key_5`), KEY `fk_yvrm_bgu2_392_natural_gas_c_fktblzrnt_3pme_141_economy_final` (`Key_6`), KEY `fk_zbf7_3pkj_223_TableV10_fktblzrnt_3pme_141_economy_final` (`Key_7`), KEY `fk_zbf7_3pkj_223_TableV15_fktblzrnt_3pme_141_economy_final` (`Key_8`), CONSTRAINT `fk_zbf7_3pkj_223_TableV15_fktblzrnt_3pme_141_economy_final` FOREIGN KEY (`Key_8`) REFERENCES `tblzbf7_3pkj_223_TableV15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_vpe3_5iem_233_fktblzrnt_3pme_141_economy_final` FOREIGN KEY (`Key_4`) REFERENCES `tblvpe3_5iem_233` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table17_fktblzrnt_3pme_141_economy_final` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table17` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table25_fktblzrnt_3pme_141_economy_final` FOREIGN KEY (`Key_5`) REFERENCES `tbly4in_r4sy_222_Table25` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_yvrm_bgu2_392_natural_gas_c_fktblzrnt_3pme_141_economy_final` FOREIGN KEY (`Key_6`) REFERENCES `tblyvrm_bgu2_392_natural_gas_comsumption` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC2_fktblzrnt_3pme_141_economy_final` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC2` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV10_fktblzrnt_3pme_141_economy_final` FOREIGN KEY (`Key_7`) REFERENCES `tblzbf7_3pkj_223_TableV10` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV2_fktblzrnt_3pme_141_economy_final` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableV2` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_model_fktblzrnt_3pme_141_economy_final` FOREIGN KEY (`Key_3`) REFERENCES `tblzrnt_3pme_141_model` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzrnt_3pme_141_economy_final` -- LOCK TABLES `tblzrnt_3pme_141_economy_final` WRITE; /*!40000 ALTER TABLE `tblzrnt_3pme_141_economy_final` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzrnt_3pme_141_economy_final` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzrnt_3pme_141_es_fin` -- DROP TABLE IF EXISTS `tblzrnt_3pme_141_es_fin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzrnt_3pme_141_es_fin` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` varchar(300) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, `Key_4` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table21_fktblzrnt_3pme_141_es_fin` (`Key_0`), KEY `fk_y4in_r4sy_222_Table16_fktblzrnt_3pme_141_es_fin` (`Key_1`), KEY `fk_yvrm_bgu2_392_natural_gas_c_fktblzrnt_3pme_141_es_fin` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableV2_fktblzrnt_3pme_141_es_fin` (`Key_3`), KEY `fk_zbf7_3pkj_223_TableC5_fktblzrnt_3pme_141_es_fin` (`Key_4`), CONSTRAINT `fk_zbf7_3pkj_223_TableC5_fktblzrnt_3pme_141_es_fin` FOREIGN KEY (`Key_4`) REFERENCES `tblzbf7_3pkj_223_TableC5` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table16_fktblzrnt_3pme_141_es_fin` FOREIGN KEY (`Key_1`) REFERENCES `tbly4in_r4sy_222_Table16` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table21_fktblzrnt_3pme_141_es_fin` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table21` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_yvrm_bgu2_392_natural_gas_c_fktblzrnt_3pme_141_es_fin` FOREIGN KEY (`Key_2`) REFERENCES `tblyvrm_bgu2_392_natural_gas_comsumption` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV2_fktblzrnt_3pme_141_es_fin` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableV2` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzrnt_3pme_141_es_fin` -- LOCK TABLES `tblzrnt_3pme_141_es_fin` WRITE; /*!40000 ALTER TABLE `tblzrnt_3pme_141_es_fin` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzrnt_3pme_141_es_fin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzrnt_3pme_141_final` -- DROP TABLE IF EXISTS `tblzrnt_3pme_141_final`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzrnt_3pme_141_final` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `Col_10` int(11) DEFAULT NULL, `Col_11` int(11) DEFAULT NULL, `Col_12` int(11) DEFAULT NULL, `Col_13` int(11) DEFAULT NULL, `Col_14` int(11) DEFAULT NULL, `Col_15` int(11) DEFAULT NULL, `Col_16` int(11) DEFAULT NULL, `Col_17` int(11) DEFAULT NULL, `Col_18` int(11) DEFAULT NULL, `Col_19` int(11) DEFAULT NULL, `Col_20` int(11) DEFAULT NULL, `Col_21` int(11) DEFAULT NULL, `Col_22` int(11) DEFAULT NULL, `Col_23` int(11) DEFAULT NULL, `Col_24` int(11) DEFAULT NULL, `Col_25` int(11) DEFAULT NULL, `Col_26` int(11) DEFAULT NULL, `Col_27` int(11) DEFAULT NULL, `Col_28` int(11) DEFAULT NULL, `Col_29` int(11) DEFAULT NULL, `Col_30` int(11) DEFAULT NULL, `Col_31` int(11) DEFAULT NULL, `Col_32` int(11) DEFAULT NULL, `Col_33` int(11) DEFAULT NULL, `Col_34` int(11) DEFAULT NULL, `Col_35` int(11) DEFAULT NULL, `Col_36` int(11) DEFAULT NULL, `Col_37` int(11) DEFAULT NULL, `Col_38` int(11) DEFAULT NULL, `Col_39` int(11) DEFAULT NULL, `Col_40` int(11) DEFAULT NULL, `Col_41` int(11) DEFAULT NULL, `Col_42` int(11) DEFAULT NULL, `Col_43` int(11) DEFAULT NULL, `Col_44` int(11) DEFAULT NULL, `Col_45` int(11) DEFAULT NULL, `Col_46` int(11) DEFAULT NULL, `Col_47` int(11) DEFAULT NULL, `Col_48` int(11) DEFAULT NULL, `Col_49` int(11) DEFAULT NULL, `Col_50` int(11) DEFAULT NULL, `Col_51` int(11) DEFAULT NULL, `Col_52` int(11) DEFAULT NULL, `Col_53` int(11) DEFAULT NULL, `Col_54` int(11) DEFAULT NULL, `Col_55` int(11) DEFAULT NULL, `Col_56` int(11) DEFAULT NULL, `Col_57` int(11) DEFAULT NULL, `Col_58` varchar(300) DEFAULT NULL, `Col_59` varchar(300) DEFAULT NULL, `Col_60` int(11) DEFAULT NULL, `Col_61` int(11) DEFAULT NULL, `Col_62` int(11) DEFAULT NULL, `Col_63` int(11) DEFAULT NULL, `Col_64` int(11) DEFAULT NULL, `Col_65` int(11) DEFAULT NULL, `Col_66` int(11) DEFAULT NULL, `Col_67` int(11) DEFAULT NULL, `Col_68` int(11) DEFAULT NULL, `Col_69` int(11) DEFAULT NULL, `Col_70` int(11) DEFAULT NULL, `Col_71` int(11) DEFAULT NULL, `Col_72` int(11) DEFAULT NULL, `Col_73` int(11) DEFAULT NULL, `Col_74` int(11) DEFAULT NULL, `Col_75` int(11) DEFAULT NULL, `Col_76` int(11) DEFAULT NULL, `Col_77` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table15_fktblzrnt_3pme_141_final` (`Key_0`), KEY `fk_wsf8_txi9_552_fktblzrnt_3pme_141_final` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableC9_fktblzrnt_3pme_141_final` (`Key_2`), KEY `fk_y4in_r4sy_222_Table28_fktblzrnt_3pme_141_final` (`Key_3`), CONSTRAINT `fk_y4in_r4sy_222_Table28_fktblzrnt_3pme_141_final` FOREIGN KEY (`Key_3`) REFERENCES `tbly4in_r4sy_222_Table28` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_wsf8_txi9_552_fktblzrnt_3pme_141_final` FOREIGN KEY (`Key_1`) REFERENCES `tblwsf8_txi9_552` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table15_fktblzrnt_3pme_141_final` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC9_fktblzrnt_3pme_141_final` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableC9` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzrnt_3pme_141_final` -- LOCK TABLES `tblzrnt_3pme_141_final` WRITE; /*!40000 ALTER TABLE `tblzrnt_3pme_141_final` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzrnt_3pme_141_final` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzrnt_3pme_141_iu_profiling_final` -- DROP TABLE IF EXISTS `tblzrnt_3pme_141_iu_profiling_final`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzrnt_3pme_141_iu_profiling_final` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` varchar(300) DEFAULT NULL, `Col_2` float DEFAULT NULL, `Col_3` float DEFAULT NULL, `Col_4` float DEFAULT NULL, `Col_5` float DEFAULT NULL, `Col_6` float DEFAULT NULL, `Col_7` float DEFAULT NULL, `Col_8` float DEFAULT NULL, `Col_9` float DEFAULT NULL, `Col_10` float DEFAULT NULL, `Col_11` float DEFAULT NULL, `Col_12` float DEFAULT NULL, `Col_13` float DEFAULT NULL, `Col_14` float DEFAULT NULL, `Col_15` float DEFAULT NULL, `Col_16` float DEFAULT NULL, `Col_17` float DEFAULT NULL, `Col_18` float DEFAULT NULL, `Col_19` float DEFAULT NULL, `Col_20` float DEFAULT NULL, `Col_21` float DEFAULT NULL, `Col_22` float DEFAULT NULL, `Col_23` float DEFAULT NULL, `Col_24` float DEFAULT NULL, `Col_25` int(11) DEFAULT NULL, `Col_26` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_Table19_fktblzrnt_3pme_141_iu_profiling_final` (`Key_0`), KEY `fk_zbf7_3pkj_223_TableC6_fktblzrnt_3pme_141_iu_profiling_final` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableV4_fktblzrnt_3pme_141_iu_profiling_final` (`Key_2`), CONSTRAINT `fk_zbf7_3pkj_223_TableV4_fktblzrnt_3pme_141_iu_profiling_final` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableV4` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table19_fktblzrnt_3pme_141_iu_profiling_final` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_Table19` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableC6_fktblzrnt_3pme_141_iu_profiling_final` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_TableC6` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzrnt_3pme_141_iu_profiling_final` -- LOCK TABLES `tblzrnt_3pme_141_iu_profiling_final` WRITE; /*!40000 ALTER TABLE `tblzrnt_3pme_141_iu_profiling_final` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzrnt_3pme_141_iu_profiling_final` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzrnt_3pme_141_model` -- DROP TABLE IF EXISTS `tblzrnt_3pme_141_model`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzrnt_3pme_141_model` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` varchar(300) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `Col_10` int(11) DEFAULT NULL, `Col_11` int(11) DEFAULT NULL, `Col_12` int(11) DEFAULT NULL, `Col_13` int(11) DEFAULT NULL, `Col_14` int(11) DEFAULT NULL, `Col_15` int(11) DEFAULT NULL, `Col_16` int(11) DEFAULT NULL, `Col_17` int(11) DEFAULT NULL, `Col_18` int(11) DEFAULT NULL, `Col_19` int(11) DEFAULT NULL, `Col_20` int(11) DEFAULT NULL, `Col_21` int(11) DEFAULT NULL, `Col_22` int(11) DEFAULT NULL, `Col_23` int(11) DEFAULT NULL, `Col_24` int(11) DEFAULT NULL, `Col_25` int(11) DEFAULT NULL, `Col_26` int(11) DEFAULT NULL, `Col_27` int(11) DEFAULT NULL, `Col_28` int(11) DEFAULT NULL, `Col_29` int(11) DEFAULT NULL, `Col_30` int(11) DEFAULT NULL, `Col_31` int(11) DEFAULT NULL, `Col_32` int(11) DEFAULT NULL, `Col_33` int(11) DEFAULT NULL, `Col_34` int(11) DEFAULT NULL, `Col_35` int(11) DEFAULT NULL, `Col_36` int(11) DEFAULT NULL, `Col_37` int(11) DEFAULT NULL, `Col_38` int(11) DEFAULT NULL, `Col_39` int(11) DEFAULT NULL, `Col_40` int(11) DEFAULT NULL, `Col_41` int(11) DEFAULT NULL, `Col_42` int(11) DEFAULT NULL, `Col_43` int(11) DEFAULT NULL, `Col_44` int(11) DEFAULT NULL, `Col_45` int(11) DEFAULT NULL, `Col_46` int(11) DEFAULT NULL, `Col_47` int(11) DEFAULT NULL, `Col_48` int(11) DEFAULT NULL, `Col_49` int(11) DEFAULT NULL, `Col_50` int(11) DEFAULT NULL, `Col_51` int(11) DEFAULT NULL, `Col_52` int(11) DEFAULT NULL, `Col_53` int(11) DEFAULT NULL, `Col_54` int(11) DEFAULT NULL, `Col_55` int(11) DEFAULT NULL, `Col_56` int(11) DEFAULT NULL, `Col_57` int(11) DEFAULT NULL, `Col_58` int(11) DEFAULT NULL, `Col_59` int(11) DEFAULT NULL, `Col_60` int(11) DEFAULT NULL, `Col_61` int(11) DEFAULT NULL, `Col_62` int(11) DEFAULT NULL, `Col_63` int(11) DEFAULT NULL, `Col_64` int(11) DEFAULT NULL, `Col_65` int(11) DEFAULT NULL, `Col_66` int(11) DEFAULT NULL, `Col_67` int(11) DEFAULT NULL, `Col_68` int(11) DEFAULT NULL, `Col_69` int(11) DEFAULT NULL, `Col_70` int(11) DEFAULT NULL, `Col_71` int(11) DEFAULT NULL, `Col_72` int(11) DEFAULT NULL, `Col_73` int(11) DEFAULT NULL, `Col_74` int(11) DEFAULT NULL, `Col_75` int(11) DEFAULT NULL, `Col_76` int(11) DEFAULT NULL, `Col_77` int(11) DEFAULT NULL, `Col_78` int(11) DEFAULT NULL, `Col_79` int(11) DEFAULT NULL, `Col_80` int(11) DEFAULT NULL, `Col_81` int(11) DEFAULT NULL, `Col_82` int(11) DEFAULT NULL, `Col_83` int(11) DEFAULT NULL, `Col_84` int(11) DEFAULT NULL, `Col_85` int(11) DEFAULT NULL, `Col_86` int(11) DEFAULT NULL, `Col_87` int(11) DEFAULT NULL, `Col_88` int(11) DEFAULT NULL, `Col_89` int(11) DEFAULT NULL, `Col_90` int(11) DEFAULT NULL, `Col_91` int(11) DEFAULT NULL, `Col_92` int(11) DEFAULT NULL, `Col_93` int(11) DEFAULT NULL, `Col_94` int(11) DEFAULT NULL, `Col_95` int(11) DEFAULT NULL, `Col_96` int(11) DEFAULT NULL, `Col_97` int(11) DEFAULT NULL, `Col_98` int(11) DEFAULT NULL, `Col_99` int(11) DEFAULT NULL, `Col_100` int(11) DEFAULT NULL, `Col_101` int(11) DEFAULT NULL, `Col_102` int(11) DEFAULT NULL, `Col_103` int(11) DEFAULT NULL, `Col_104` int(11) DEFAULT NULL, `Col_105` int(11) DEFAULT NULL, `Col_106` int(11) DEFAULT NULL, `Col_107` varchar(300) DEFAULT NULL, `Col_108` varchar(300) DEFAULT NULL, `Col_109` int(11) DEFAULT NULL, `Col_110` int(11) DEFAULT NULL, `Col_111` int(11) DEFAULT NULL, `Col_112` int(11) DEFAULT NULL, `Col_113` int(11) DEFAULT NULL, `Col_114` int(11) DEFAULT NULL, `Col_115` int(11) DEFAULT NULL, `Col_116` int(11) DEFAULT NULL, `Col_117` int(11) DEFAULT NULL, `Col_118` int(11) DEFAULT NULL, `Col_119` int(11) DEFAULT NULL, `Col_120` int(11) DEFAULT NULL, `Col_121` int(11) DEFAULT NULL, `Col_122` int(11) DEFAULT NULL, `Col_123` int(11) DEFAULT NULL, `Col_124` int(11) DEFAULT NULL, `Col_125` varchar(300) DEFAULT NULL, `Col_126` varchar(300) DEFAULT NULL, `Col_127` int(11) DEFAULT NULL, `Col_128` int(11) DEFAULT NULL, `Col_129` int(11) DEFAULT NULL, `Col_130` int(11) DEFAULT NULL, `Col_131` int(11) DEFAULT NULL, `Col_132` int(11) DEFAULT NULL, `Col_133` int(11) DEFAULT NULL, `Col_134` int(11) DEFAULT NULL, `Col_135` int(11) DEFAULT NULL, `Col_136` int(11) DEFAULT NULL, `Col_137` int(11) DEFAULT NULL, `Col_138` int(11) DEFAULT NULL, `Col_139` int(11) DEFAULT NULL, `Col_140` int(11) DEFAULT NULL, `Col_141` int(11) DEFAULT NULL, `Col_142` int(11) DEFAULT NULL, `Col_143` int(11) DEFAULT NULL, `Col_144` int(11) DEFAULT NULL, `Col_145` int(11) DEFAULT NULL, `Col_146` int(11) DEFAULT NULL, `Col_147` int(11) DEFAULT NULL, `Col_148` int(11) DEFAULT NULL, `Col_149` int(11) DEFAULT NULL, `Col_150` int(11) DEFAULT NULL, `Col_151` int(11) DEFAULT NULL, `Col_152` int(11) DEFAULT NULL, `Col_153` int(11) DEFAULT NULL, `Col_154` int(11) DEFAULT NULL, `Col_155` int(11) DEFAULT NULL, `Col_156` int(11) DEFAULT NULL, `Col_157` int(11) DEFAULT NULL, `Col_158` int(11) DEFAULT NULL, `Col_159` int(11) DEFAULT NULL, `Col_160` int(11) DEFAULT NULL, `Col_161` int(11) DEFAULT NULL, `Col_162` int(11) DEFAULT NULL, `Col_163` int(11) DEFAULT NULL, `Col_164` int(11) DEFAULT NULL, `Col_165` int(11) DEFAULT NULL, `Col_166` int(11) DEFAULT NULL, `Col_167` int(11) DEFAULT NULL, `Col_168` int(11) DEFAULT NULL, `Col_169` int(11) DEFAULT NULL, `Col_170` int(11) DEFAULT NULL, `Col_171` int(11) DEFAULT NULL, `Col_172` int(11) DEFAULT NULL, `Col_173` int(11) DEFAULT NULL, `Col_174` int(11) DEFAULT NULL, `Col_175` int(11) DEFAULT NULL, `Col_176` int(11) DEFAULT NULL, `Col_177` int(11) DEFAULT NULL, `Col_178` int(11) DEFAULT NULL, `Col_179` int(11) DEFAULT NULL, `Col_180` int(11) DEFAULT NULL, `Col_181` int(11) DEFAULT NULL, `Col_182` int(11) DEFAULT NULL, `Col_183` int(11) DEFAULT NULL, `Col_184` int(11) DEFAULT NULL, `Col_185` int(11) DEFAULT NULL, `Col_186` int(11) DEFAULT NULL, `Col_187` int(11) DEFAULT NULL, `Col_188` int(11) DEFAULT NULL, `Col_189` int(11) DEFAULT NULL, `Col_190` int(11) DEFAULT NULL, `Col_191` int(11) DEFAULT NULL, `Col_192` int(11) DEFAULT NULL, `Col_193` int(11) DEFAULT NULL, `Col_194` int(11) DEFAULT NULL, `Col_195` int(11) DEFAULT NULL, `Col_196` int(11) DEFAULT NULL, `Col_197` int(11) DEFAULT NULL, `Col_198` int(11) DEFAULT NULL, `Col_199` int(11) DEFAULT NULL, `Col_200` int(11) DEFAULT NULL, `Col_201` int(11) DEFAULT NULL, `Col_202` int(11) DEFAULT NULL, `Col_203` int(11) DEFAULT NULL, `Col_204` int(11) DEFAULT NULL, `Col_205` int(11) DEFAULT NULL, `Col_206` int(11) DEFAULT NULL, `Col_207` int(11) DEFAULT NULL, `Col_208` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table28_fktblzrnt_3pme_141_model` (`Key_0`), KEY `fk_zbf7_3pkj_223_Table15_fktblzrnt_3pme_141_model` (`Key_1`), KEY `fk_zbf7_3pkj_223_TableV8_fktblzrnt_3pme_141_model` (`Key_2`), CONSTRAINT `fk_zbf7_3pkj_223_TableV8_fktblzrnt_3pme_141_model` FOREIGN KEY (`Key_2`) REFERENCES `tblzbf7_3pkj_223_TableV8` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table28_fktblzrnt_3pme_141_model` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table28` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_Table15_fktblzrnt_3pme_141_model` FOREIGN KEY (`Key_1`) REFERENCES `tblzbf7_3pkj_223_Table15` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzrnt_3pme_141_model` -- LOCK TABLES `tblzrnt_3pme_141_model` WRITE; /*!40000 ALTER TABLE `tblzrnt_3pme_141_model` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzrnt_3pme_141_model` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzrnt_3pme_141_ui` -- DROP TABLE IF EXISTS `tblzrnt_3pme_141_ui`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzrnt_3pme_141_ui` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` int(11) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` float DEFAULT NULL, `Col_10` float DEFAULT NULL, `Col_11` int(11) DEFAULT NULL, `Col_12` int(11) DEFAULT NULL, `Col_13` int(11) DEFAULT NULL, `Col_14` int(11) DEFAULT NULL, `Col_15` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, `Key_2` bigint(20) DEFAULT NULL, `Key_3` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_zbf7_3pkj_223_TableV2_fktblzrnt_3pme_141_ui` (`Key_0`), KEY `fk_zrnt_3pme_141_economy_final_fktblzrnt_3pme_141_ui` (`Key_1`), KEY `fk_y4in_r4sy_222_Table19_fktblzrnt_3pme_141_ui` (`Key_2`), KEY `fk_zbf7_3pkj_223_TableV9_fktblzrnt_3pme_141_ui` (`Key_3`), CONSTRAINT `fk_zbf7_3pkj_223_TableV9_fktblzrnt_3pme_141_ui` FOREIGN KEY (`Key_3`) REFERENCES `tblzbf7_3pkj_223_TableV9` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table19_fktblzrnt_3pme_141_ui` FOREIGN KEY (`Key_2`) REFERENCES `tbly4in_r4sy_222_Table19` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zbf7_3pkj_223_TableV2_fktblzrnt_3pme_141_ui` FOREIGN KEY (`Key_0`) REFERENCES `tblzbf7_3pkj_223_TableV2` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_zrnt_3pme_141_economy_final_fktblzrnt_3pme_141_ui` FOREIGN KEY (`Key_1`) REFERENCES `tblzrnt_3pme_141_economy_final` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzrnt_3pme_141_ui` -- LOCK TABLES `tblzrnt_3pme_141_ui` WRITE; /*!40000 ALTER TABLE `tblzrnt_3pme_141_ui` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzrnt_3pme_141_ui` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblzrnt_3pme_141_wia_adult` -- DROP TABLE IF EXISTS `tblzrnt_3pme_141_wia_adult`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblzrnt_3pme_141_wia_adult` ( `Col_0` varchar(300) DEFAULT NULL, `Col_1` varchar(300) DEFAULT NULL, `Col_2` int(11) DEFAULT NULL, `Col_3` int(11) DEFAULT NULL, `Col_4` int(11) DEFAULT NULL, `Col_5` int(11) DEFAULT NULL, `Col_6` int(11) DEFAULT NULL, `Col_7` int(11) DEFAULT NULL, `Col_8` int(11) DEFAULT NULL, `Col_9` int(11) DEFAULT NULL, `Col_10` int(11) DEFAULT NULL, `Col_11` int(11) DEFAULT NULL, `Col_12` int(11) DEFAULT NULL, `Col_13` int(11) DEFAULT NULL, `Col_14` int(11) DEFAULT NULL, `Col_15` int(11) DEFAULT NULL, `Col_16` int(11) DEFAULT NULL, `Col_17` int(11) DEFAULT NULL, `Col_18` int(11) DEFAULT NULL, `Col_19` int(11) DEFAULT NULL, `Col_20` int(11) DEFAULT NULL, `Col_21` int(11) DEFAULT NULL, `Col_22` int(11) DEFAULT NULL, `Col_23` int(11) DEFAULT NULL, `Col_24` int(11) DEFAULT NULL, `Col_25` int(11) DEFAULT NULL, `Col_26` int(11) DEFAULT NULL, `Col_27` int(11) DEFAULT NULL, `Col_28` int(11) DEFAULT NULL, `Col_29` int(11) DEFAULT NULL, `Col_30` int(11) DEFAULT NULL, `Col_31` int(11) DEFAULT NULL, `Col_32` int(11) DEFAULT NULL, `Col_33` int(11) DEFAULT NULL, `Col_34` int(11) DEFAULT NULL, `Col_35` int(11) DEFAULT NULL, `Col_36` int(11) DEFAULT NULL, `Col_37` int(11) DEFAULT NULL, `Col_38` int(11) DEFAULT NULL, `Col_39` int(11) DEFAULT NULL, `Col_40` int(11) DEFAULT NULL, `Col_41` int(11) DEFAULT NULL, `Col_42` int(11) DEFAULT NULL, `Col_43` int(11) DEFAULT NULL, `Col_44` int(11) DEFAULT NULL, `Col_45` int(11) DEFAULT NULL, `Col_46` int(11) DEFAULT NULL, `Col_47` int(11) DEFAULT NULL, `Col_48` int(11) DEFAULT NULL, `Col_49` int(11) DEFAULT NULL, `Col_50` int(11) DEFAULT NULL, `Col_51` int(11) DEFAULT NULL, `Col_52` int(11) DEFAULT NULL, `Col_53` int(11) DEFAULT NULL, `Col_54` int(11) DEFAULT NULL, `Col_55` int(11) DEFAULT NULL, `Col_56` int(11) DEFAULT NULL, `Col_57` int(11) DEFAULT NULL, `Col_58` int(11) DEFAULT NULL, `Col_59` int(11) DEFAULT NULL, `Col_60` int(11) DEFAULT NULL, `Col_61` int(11) DEFAULT NULL, `Col_62` int(11) DEFAULT NULL, `Col_63` int(11) DEFAULT NULL, `Col_64` int(11) DEFAULT NULL, `Col_65` int(11) DEFAULT NULL, `Col_66` int(11) DEFAULT NULL, `Col_67` int(11) DEFAULT NULL, `Col_68` int(11) DEFAULT NULL, `Col_69` int(11) DEFAULT NULL, `Col_70` int(11) DEFAULT NULL, `Col_71` int(11) DEFAULT NULL, `Col_72` int(11) DEFAULT NULL, `Col_73` int(11) DEFAULT NULL, `Col_74` int(11) DEFAULT NULL, `Col_75` int(11) DEFAULT NULL, `Col_76` int(11) DEFAULT NULL, `Col_77` int(11) DEFAULT NULL, `Col_78` int(11) DEFAULT NULL, `Col_79` int(11) DEFAULT NULL, `Col_80` int(11) DEFAULT NULL, `Col_81` int(11) DEFAULT NULL, `P_id` bigint(20) NOT NULL AUTO_INCREMENT, `Key_0` bigint(20) DEFAULT NULL, `Key_1` bigint(20) DEFAULT NULL, PRIMARY KEY (`P_id`), KEY `fk_y4in_r4sy_222_Table27_fktblzrnt_3pme_141_wia_adult` (`Key_0`), KEY `fk_zrnt_3pme_141_ui_fktblzrnt_3pme_141_wia_adult` (`Key_1`), CONSTRAINT `fk_zrnt_3pme_141_ui_fktblzrnt_3pme_141_wia_adult` FOREIGN KEY (`Key_1`) REFERENCES `tblzrnt_3pme_141_ui` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_y4in_r4sy_222_Table27_fktblzrnt_3pme_141_wia_adult` FOREIGN KEY (`Key_0`) REFERENCES `tbly4in_r4sy_222_Table27` (`P_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblzrnt_3pme_141_wia_adult` -- LOCK TABLES `tblzrnt_3pme_141_wia_adult` WRITE; /*!40000 ALTER TABLE `tblzrnt_3pme_141_wia_adult` DISABLE KEYS */; /*!40000 ALTER TABLE `tblzrnt_3pme_141_wia_adult` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2012-05-21 11:02:53