Commits

Nick Raptis committed c8b5eb0 Draft

Add some starting rows on the tables

Comments (0)

Files changed (1)

   `idEIDIKOTITA` int(11) NOT NULL AUTO_INCREMENT,
   `ONOMA` varchar(45) NOT NULL,
   PRIMARY KEY (`idEIDIKOTITA`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 
 LOCK TABLES `eidikotita` WRITE;
 /*!40000 ALTER TABLE `eidikotita` DISABLE KEYS */;
+INSERT INTO `eidikotita` VALUES (1,'ITHOPOIOS'),(2,'SKHNOTHETHS'),(3,'SENARIOGRAFOS'),(4,'PARAGOGOS'),(5,'MOYSIKOSYNTHETIS');
 /*!40000 ALTER TABLE `eidikotita` ENABLE KEYS */;
 UNLOCK TABLES;
 
 
 LOCK TABLES `eidos` WRITE;
 /*!40000 ALTER TABLE `eidos` DISABLE KEYS */;
+INSERT INTO `eidos` VALUES ('DRASIS'),('EP. FANTASIAS'),('KOINONIKO'),('KOMODIA'),('PERIPETEIA'),('THRILLER');
 /*!40000 ALTER TABLE `eidos` ENABLE KEYS */;
 UNLOCK TABLES;
 
   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;
+) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 
 LOCK TABLES `eidos_tainia` WRITE;
 /*!40000 ALTER TABLE `eidos_tainia` DISABLE KEYS */;
+INSERT INTO `eidos_tainia` VALUES (1,'DRASIS','EN0003'),(2,'KOMODIA','EN0003'),(3,'PERIPETEIA','EN0002'),(4,'DRASIS','EN0002'),(5,'KOMODIA','EN0001'),(6,'PERIPETEIA','EN0001'),(7,'DRASIS','EN0001'),(8,'KOINONIKO','EN0004'),(9,'PERIPETEIA','EN0005'),(10,'DRASIS','EN0005'),(11,'EP. FANTASIAS','EN0005'),(12,'KOMODIA','EN0006');
 /*!40000 ALTER TABLE `eidos_tainia` ENABLE KEYS */;
 UNLOCK TABLES;
 
 
 LOCK TABLES `glwssa` WRITE;
 /*!40000 ALTER TABLE `glwssa` DISABLE KEYS */;
+INSERT INTO `glwssa` VALUES ('AGGLIKA'),('ELLINIKA'),('GALLIKA');
 /*!40000 ALTER TABLE `glwssa` ENABLE KEYS */;
 UNLOCK TABLES;
 
 
 LOCK TABLES `rolos` WRITE;
 /*!40000 ALTER TABLE `rolos` DISABLE KEYS */;
+INSERT INTO `rolos` VALUES (1,1,'EN0004'),(2,1,'EN0001'),(2,1,'EN0002'),(2,2,'EN0005'),(3,2,'EN0001'),(3,2,'EN0002'),(3,4,'EN0001'),(3,4,'EN0002'),(4,1,'EN0001'),(4,1,'EN0003'),(4,1,'EN0004'),(5,1,'EN0005');
 /*!40000 ALTER TABLE `rolos` ENABLE KEYS */;
 UNLOCK TABLES;
 
   `EPONYMO` varchar(45) NOT NULL,
   `FOTOGRAFIA` blob,
   PRIMARY KEY (`idSYNTELESTIS`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 
 LOCK TABLES `syntelestis` WRITE;
 /*!40000 ALTER TABLE `syntelestis` DISABLE KEYS */;
+INSERT INTO `syntelestis` VALUES (1,'TOM','CRUISE',NULL),(2,'HARRISON','FORD',NULL),(3,'STEVEN','SPIELBERG',NULL),(4,'SEAN','CONNERY',NULL),(5,'MEGAN','FOX',NULL);
 /*!40000 ALTER TABLE `syntelestis` ENABLE KEYS */;
 UNLOCK TABLES;
 
 
 LOCK TABLES `tainia` WRITE;
 /*!40000 ALTER TABLE `tainia` DISABLE KEYS */;
+INSERT INTO `tainia` VALUES ('EN0001','INDIANA JONES Last Crusade',135,1981,1,NULL,'AGGLIKA'),('EN0002','INDIANA JONES - Raiders of the Lost Ark',122,1981,1,NULL,'AGGLIKA'),('EN0003','The League of Extraordinary Gentlemen',145,1997,1,NULL,'AGGLIKA'),('EN0004','Finding Forester',119,1995,1,NULL,'AGGLIKA'),('EN0005','Transformers',132,2004,1,NULL,'AGGLIKA'),('EN0006','Ta kitrina Gantia',92,1961,0,NULL,'ELLINIKA');
 /*!40000 ALTER TABLE `tainia` ENABLE KEYS */;
 UNLOCK TABLES;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2012-03-21  0:33:42
+-- Dump completed on 2012-03-27 22:08:33
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.