Commits

Nick Raptis committed 1ff5a21

Finished Shema, changed engine to InnoDB

Comments (0)

Files changed (1)

   `idEIDIKOTITA` int(11) NOT NULL AUTO_INCREMENT,
   `ONOMA` varchar(45) NOT NULL,
   PRIMARY KEY (`idEIDIKOTITA`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 CREATE TABLE `eidos` (
   `ONOMA` varchar(50) NOT NULL,
   PRIMARY KEY (`ONOMA`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 UNLOCK TABLES;
 
 --
+-- Table structure for table `eidos_tainia`
+--
+
+DROP TABLE IF EXISTS `eidos_tainia`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `eidos_tainia` (
+  `idEIDOS_TAINIA` int(11) NOT NULL AUTO_INCREMENT,
+  `EIDOS_ONOMA` varchar(50) NOT NULL,
+  `TAINIA_idTAINIA` varchar(7) NOT NULL,
+  PRIMARY KEY (`idEIDOS_TAINIA`),
+  KEY `fk_EIDOS_TAINIA_EIDOS1` (`EIDOS_ONOMA`),
+  KEY `fk_EIDOS_TAINIA_TAINIA1` (`TAINIA_idTAINIA`),
+  CONSTRAINT `fk_EIDOS_TAINIA_EIDOS1` FOREIGN KEY (`EIDOS_ONOMA`) REFERENCES `eidos` (`ONOMA`) ON DELETE NO ACTION ON UPDATE CASCADE,
+  CONSTRAINT `fk_EIDOS_TAINIA_TAINIA1` FOREIGN KEY (`TAINIA_idTAINIA`) REFERENCES `tainia` (`idTAINIA`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `eidos_tainia`
+--
+
+LOCK TABLES `eidos_tainia` WRITE;
+/*!40000 ALTER TABLE `eidos_tainia` DISABLE KEYS */;
+/*!40000 ALTER TABLE `eidos_tainia` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `glwssa`
 --
 
 CREATE TABLE `glwssa` (
   `ONOMA` varchar(50) NOT NULL,
   PRIMARY KEY (`ONOMA`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 UNLOCK TABLES;
 
 --
+-- Table structure for table `rolos`
+--
+
+DROP TABLE IF EXISTS `rolos`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `rolos` (
+  `SYNTELESTIS_idSYNTELESTIS` int(11) NOT NULL,
+  `EIDIKOTITA_idEIDIKOTITA` int(11) NOT NULL,
+  `TAINIA_idTAINIA` varchar(7) NOT NULL,
+  PRIMARY KEY (`SYNTELESTIS_idSYNTELESTIS`,`EIDIKOTITA_idEIDIKOTITA`,`TAINIA_idTAINIA`),
+  KEY `fk_ROLOS_SYNTELESTIS1` (`SYNTELESTIS_idSYNTELESTIS`),
+  KEY `fk_ROLOS_EIDIKOTITA1` (`EIDIKOTITA_idEIDIKOTITA`),
+  KEY `fk_ROLOS_TAINIA1` (`TAINIA_idTAINIA`),
+  CONSTRAINT `fk_ROLOS_SYNTELESTIS1` FOREIGN KEY (`SYNTELESTIS_idSYNTELESTIS`) REFERENCES `syntelestis` (`idSYNTELESTIS`) ON DELETE NO ACTION ON UPDATE NO ACTION,
+  CONSTRAINT `fk_ROLOS_EIDIKOTITA1` FOREIGN KEY (`EIDIKOTITA_idEIDIKOTITA`) REFERENCES `eidikotita` (`idEIDIKOTITA`) ON DELETE NO ACTION ON UPDATE NO ACTION,
+  CONSTRAINT `fk_ROLOS_TAINIA1` FOREIGN KEY (`TAINIA_idTAINIA`) REFERENCES `tainia` (`idTAINIA`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `rolos`
+--
+
+LOCK TABLES `rolos` WRITE;
+/*!40000 ALTER TABLE `rolos` DISABLE KEYS */;
+/*!40000 ALTER TABLE `rolos` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `syntelestis`
 --
 
   `EPONYMO` varchar(45) NOT NULL,
   `FOTOGRAFIA` blob,
   PRIMARY KEY (`idSYNTELESTIS`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 /*!40000 ALTER TABLE `syntelestis` DISABLE KEYS */;
 /*!40000 ALTER TABLE `syntelestis` ENABLE KEYS */;
 UNLOCK TABLES;
+
+--
+-- Table structure for table `tainia`
+--
+
+DROP TABLE IF EXISTS `tainia`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `tainia` (
+  `idTAINIA` varchar(7) NOT NULL,
+  `TITLOS` varchar(45) DEFAULT NULL,
+  `DIARKEIA` int(11) DEFAULT NULL,
+  `ETOS` year(4) DEFAULT NULL,
+  `EGXROMH` tinyint(1) DEFAULT NULL,
+  `EXOFYLLO` blob,
+  `GLWSSA_ONOMA` varchar(50) NOT NULL,
+  PRIMARY KEY (`idTAINIA`),
+  KEY `fk_TAINIA_GLWSSA1` (`GLWSSA_ONOMA`),
+  KEY `ixTITLOS` (`TITLOS`),
+  CONSTRAINT `fk_TAINIA_GLWSSA1` FOREIGN KEY (`GLWSSA_ONOMA`) REFERENCES `glwssa` (`ONOMA`) ON DELETE NO ACTION ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `tainia`
+--
+
+LOCK TABLES `tainia` WRITE;
+/*!40000 ALTER TABLE `tainia` DISABLE KEYS */;
+/*!40000 ALTER TABLE `tainia` ENABLE KEYS */;
+UNLOCK TABLES;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2012-03-13 18:40:41
+-- Dump completed on 2012-03-21  0:33:42