Source

SQLerg / tainies.sql

-- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)
--
-- Host: localhost    Database: tainies_1550
-- ------------------------------------------------------
-- Server version	5.5.16

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

--
-- Current Database: `tainies_1550`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `tainies_1550` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `tainies_1550`;

--
-- Table structure for table `eidikotita`
--

DROP TABLE IF EXISTS `eidikotita`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eidikotita` (
  `idEIDIKOTITA` int(11) NOT NULL AUTO_INCREMENT,
  `ONOMA` varchar(45) NOT NULL,
  PRIMARY KEY (`idEIDIKOTITA`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eidikotita`
--

LOCK TABLES `eidikotita` WRITE;
/*!40000 ALTER TABLE `eidikotita` DISABLE KEYS */;
/*!40000 ALTER TABLE `eidikotita` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eidos`
--

DROP TABLE IF EXISTS `eidos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eidos` (
  `ONOMA` varchar(50) NOT NULL,
  PRIMARY KEY (`ONOMA`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eidos`
--

LOCK TABLES `eidos` WRITE;
/*!40000 ALTER TABLE `eidos` DISABLE KEYS */;
/*!40000 ALTER TABLE `eidos` ENABLE KEYS */;
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`
--

DROP TABLE IF EXISTS `glwssa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `glwssa` (
  `ONOMA` varchar(50) NOT NULL,
  PRIMARY KEY (`ONOMA`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `glwssa`
--

LOCK TABLES `glwssa` WRITE;
/*!40000 ALTER TABLE `glwssa` DISABLE KEYS */;
/*!40000 ALTER TABLE `glwssa` ENABLE KEYS */;
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`
--

DROP TABLE IF EXISTS `syntelestis`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `syntelestis` (
  `idSYNTELESTIS` int(11) NOT NULL AUTO_INCREMENT,
  `ONOMA` varchar(45) NOT NULL,
  `EPONYMO` varchar(45) NOT NULL,
  `FOTOGRAFIA` blob,
  PRIMARY KEY (`idSYNTELESTIS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `syntelestis`
--

LOCK TABLES `syntelestis` WRITE;
/*!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 */;
/*!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-03-21  0:33:42
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.