· 7 years ago · Nov 29, 2018, 12:58 AM
1--
2-- Table structure for table `film`
3--
4
5DROP TABLE IF EXISTS `film`;
6/*!40101 SET @saved_cs_client = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `film` (
9 `idfilm` int(11) NOT NULL AUTO_INCREMENT,
10 `filmadi` varchar(200) DEFAULT NULL,
11 `salonadi` varchar(45) DEFAULT NULL,
12 PRIMARY KEY (`idfilm`)
13) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
14/*!40101 SET character_set_client = @saved_cs_client */;
15
16--
17-- Dumping data for table `film`
18--
19
20LOCK TABLES `film` WRITE;
21/*!40000 ALTER TABLE `film` DISABLE KEYS */;
22INSERT INTO `film` VALUES (1,'Wonder Woman','Salon 1'),(2,'Transformers: The Last Knight','Salon 2'),(3,'All Eyez on Me','Salon 3'),(4,'Cars 3','Salon 4'),(5,'Power Rangers','Salon 5'),(6,'Spider-Man: Homecoming','Salon 6');
23/*!40000 ALTER TABLE `film` ENABLE KEYS */;
24UNLOCK TABLES;
25
26--
27-- Table structure for table `filmlistesi`
28--
29
30DROP TABLE IF EXISTS `filmlistesi`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `filmlistesi` (
34 `idfilmlistesi` int(11) NOT NULL AUTO_INCREMENT,
35 `idfilm` int(11) DEFAULT NULL,
36 `idsalon` varchar(50) DEFAULT NULL,
37 `idsaat` varchar(50) DEFAULT NULL,
38 `idkoltuk` varchar(50) DEFAULT NULL,
39 `tutar` int(11) DEFAULT NULL,
40 PRIMARY KEY (`idfilmlistesi`)
41) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;
42/*!40101 SET character_set_client = @saved_cs_client */;
43
44--
45-- Dumping data for table `filmlistesi`
46--
47
48LOCK TABLES `filmlistesi` WRITE;
49/*!40000 ALTER TABLE `filmlistesi` DISABLE KEYS */;
50INSERT INTO `filmlistesi` VALUES (11,3,'Salon 3','09:45','A6',20),(12,3,'Salon 3','09:45','A12',20),(13,1,'Salon 1','12:45','A7',20),(16,1,'Salon 1','12:45','A2',20),(18,1,'Salon 1','12:45 ','B2',20),(19,1,'Salon 1','12:45 ','A5',20),(20,2,'Salon 2','15:45 ','A5',20),(21,1,'Salon 1','09:45','A6',20),(22,1,'Salon 1','15:45 ','A5',20),(23,1,'Salon 1','24:45 ','B4',20),(24,1,'Salon 1','24:45 ','B5',20),(25,5,'Salon 5','09:45 ','B5',20),(26,5,'Salon 5','09:45 ','B6',20),(27,5,'Salon 5','09:45 ','B7',20),(28,5,'Salon 5','09:45 ','B8',20),(29,4,'Salon 4','18:45 ','C5',20),(30,4,'Salon 4','18:45 ','C6',20),(31,4,'Salon 4','18:45 ','C7',20),(32,4,'Salon 4','18:45 ','C8',20),(34,4,'Salon 4','18:45 ','A7',20),(35,4,'Salon 4','18:45 ','A8',20),(36,6,'Salon 6','21:45 ','C6',20),(37,6,'Salon 6','21:45 ','C7',20),(38,4,'Salon 4','18:45 ','A10',20);
51/*!40000 ALTER TABLE `filmlistesi` ENABLE KEYS */;
52UNLOCK TABLES;
53
54--
55-- Table structure for table `koltuk`
56--
57
58DROP TABLE IF EXISTS `koltuk`;
59/*!40101 SET @saved_cs_client = @@character_set_client */;
60/*!40101 SET character_set_client = utf8 */;
61CREATE TABLE `koltuk` (
62 `idkoltuk` int(11) NOT NULL AUTO_INCREMENT,
63 `koltukadi` varchar(45) DEFAULT NULL,
64 PRIMARY KEY (`idkoltuk`)
65) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Dumping data for table `koltuk`
70--
71
72LOCK TABLES `koltuk` WRITE;
73/*!40000 ALTER TABLE `koltuk` DISABLE KEYS */;
74INSERT INTO `koltuk` VALUES (1,'A1'),(2,'A2'),(3,'A3'),(4,'A4'),(5,'A5'),(6,'A6'),(7,'A7'),(8,'A8'),(9,'A9'),(10,'A10'),(11,'A11'),(12,'A12'),(13,'A13'),(14,'A14'),(15,'B1'),(16,'B2'),(17,'B3'),(18,'B4'),(19,'B5'),(20,'B6'),(21,'B7'),(22,'B8'),(23,'B9'),(24,'B10'),(25,'B11'),(26,'B12'),(27,'B13'),(28,'B14'),(29,'C1'),(30,'C2'),(31,'C3'),(32,'C4'),(33,'C5'),(34,'C6'),(35,'C7'),(36,'C8'),(37,'C9'),(38,'C10'),(39,'C11'),(40,'C12'),(41,'C13'),(42,'C14'),(43,'D1'),(44,'D2'),(45,'D3'),(46,'D4'),(47,'D5'),(48,'D6'),(49,'D7'),(50,'D8'),(51,'D9'),(52,'D10'),(53,'D11'),(54,'D12'),(55,'D13'),(56,'D14');
75/*!40000 ALTER TABLE `koltuk` ENABLE KEYS */;
76UNLOCK TABLES;
77
78--
79-- Table structure for table `saat`
80--
81
82DROP TABLE IF EXISTS `saat`;
83/*!40101 SET @saved_cs_client = @@character_set_client */;
84/*!40101 SET character_set_client = utf8 */;
85CREATE TABLE `saat` (
86 `idsaat` int(11) NOT NULL AUTO_INCREMENT,
87 `saatadi` float DEFAULT NULL,
88 PRIMARY KEY (`idsaat`)
89) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
90/*!40101 SET character_set_client = @saved_cs_client */;
91
92--
93-- Dumping data for table `saat`
94--
95
96LOCK TABLES `saat` WRITE;
97/*!40000 ALTER TABLE `saat` DISABLE KEYS */;
98INSERT INTO `saat` VALUES (7,9.45),(8,12.45),(9,15.45),(10,18.45),(11,21.45),(12,24.45);
99/*!40000 ALTER TABLE `saat` ENABLE KEYS */;
100UNLOCK TABLES;
101
102--
103-- Table structure for table `salon`
104--
105
106DROP TABLE IF EXISTS `salon`;
107/*!40101 SET @saved_cs_client = @@character_set_client */;
108/*!40101 SET character_set_client = utf8 */;
109CREATE TABLE `salon` (
110 `idsalon` int(11) NOT NULL AUTO_INCREMENT,
111 `salonid` varchar(100) DEFAULT NULL,
112 PRIMARY KEY (`idsalon`)
113) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
114/*!40101 SET character_set_client = @saved_cs_client */;
115
116--
117-- Dumping data for table `salon`
118--
119
120LOCK TABLES `salon` WRITE;
121/*!40000 ALTER TABLE `salon` DISABLE KEYS */;
122INSERT INTO `salon` VALUES (1,'Salon 1'),(2,'Salon 2'),(3,'Salon 3'),(4,'Salon 4'),(5,'Salon 5'),(6,'Salon 6');
123/*!40000 ALTER TABLE `salon` ENABLE KEYS */;
124UNLOCK TABLES;
125
126--
127-- Table structure for table `yonetici`
128--
129
130DROP TABLE IF EXISTS `yonetici`;
131/*!40101 SET @saved_cs_client = @@character_set_client */;
132/*!40101 SET character_set_client = utf8 */;
133CREATE TABLE `yonetici` (
134 `idyonetici` int(11) NOT NULL AUTO_INCREMENT,
135 `kullaniciy` varchar(45) DEFAULT NULL,
136 `sifrey` varchar(45) DEFAULT NULL,
137 PRIMARY KEY (`idyonetici`)
138) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
139/*!40101 SET character_set_client = @saved_cs_client */;
140
141--
142-- Dumping data for table `yonetici`
143--
144
145LOCK TABLES `yonetici` WRITE;
146/*!40000 ALTER TABLE `yonetici` DISABLE KEYS */;
147INSERT INTO `yonetici` VALUES (1,'x','123');
148UNLOCK TABLES;