6qmdx3eV

1--
2-- Table structure for table `blok`
3--
4
5DROP TABLE IF EXISTS `blok`;
6/*!40101 SET @saved_cs_client     = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `blok` (
9  `id_bl` int(11) NOT NULL AUTO_INCREMENT,
10  `blok_ad` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
11  `id_u` int(11) DEFAULT NULL,
12  PRIMARY KEY (`id_bl`)
13) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
14/*!40101 SET character_set_client = @saved_cs_client */;
15
16--
17-- Dumping data for table `blok`
18--
19
20LOCK TABLES `blok` WRITE;
21/*!40000 ALTER TABLE `blok` DISABLE KEYS */;
22INSERT INTO `blok` VALUES (1,'Yabanci Diller A Blok',1),(2,'Muhendislik Mimarlik B Blok',1),(3,'Turizm C Blok',1),(4,'Yabanci Diller A Blok',2),(5,'Muhendislik Mimarlik B Blok',2),(6,'Turizm C Blok',2),(7,'Yabanci Diller A Blok',3),(8,'Muhendislik Mimarlik B Blok',3),(9,'Turizm C Blok',3);
23/*!40000 ALTER TABLE `blok` ENABLE KEYS */;
24UNLOCK TABLES;
25
26--
27-- Table structure for table `bolum`
28--
29
30DROP TABLE IF EXISTS `bolum`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `bolum` (
34  `id_b` int(11) NOT NULL AUTO_INCREMENT,
35  `bolum` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
36  PRIMARY KEY (`id_b`)
37) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `bolum`
42--
43
44LOCK TABLES `bolum` WRITE;
45/*!40000 ALTER TABLE `bolum` DISABLE KEYS */;
46INSERT INTO `bolum` VALUES (1,'SOSYOLOJI'),(2,'LOJISTIK'),(3,'TARIH'),(9,'FELSEFE');
47/*!40000 ALTER TABLE `bolum` ENABLE KEYS */;
48UNLOCK TABLES;
49
50
51
52--
53-- Table structure for table `ders_hoca`
54--
55
56DROP TABLE IF EXISTS `ders_hoca`;
57/*!40101 SET @saved_cs_client     = @@character_set_client */;
58/*!40101 SET character_set_client = utf8 */;
59CREATE TABLE `ders_hoca` (
60  `id_hd` int(11) NOT NULL AUTO_INCREMENT,
61  `id_h` int(11) DEFAULT NULL,
62  `id_d` int(11) DEFAULT NULL,
63  PRIMARY KEY (`id_hd`)
64) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
65/*!40101 SET character_set_client = @saved_cs_client */;
66
67--
68-- Dumping data for table `ders_hoca`
69--
70
71LOCK TABLES `ders_hoca` WRITE;
72/*!40000 ALTER TABLE `ders_hoca` DISABLE KEYS */;
73INSERT INTO `ders_hoca` VALUES (7,2,2),(8,2,28),(9,1,21),(10,1,31);
74/*!40000 ALTER TABLE `ders_hoca` ENABLE KEYS */;
75UNLOCK TABLES;
76
77--
78-- Table structure for table `dersler`
79--
80
81DROP TABLE IF EXISTS `dersler`;
82/*!40101 SET @saved_cs_client     = @@character_set_client */;
83/*!40101 SET character_set_client = utf8 */;
84CREATE TABLE `dersler` (
85  `id_d` int(11) NOT NULL AUTO_INCREMENT,
86  `id_b` int(11) DEFAULT NULL,
87  `ders` varchar(120) COLLATE utf8_turkish_ci DEFAULT NULL,
88  `yariyil` int(11) DEFAULT NULL,
89  PRIMARY KEY (`id_d`)
90) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
91/*!40101 SET character_set_client = @saved_cs_client */;
92
93--
94-- Dumping data for table `dersler`
95--
96
97LOCK TABLES `dersler` WRITE;
98/*!40000 ALTER TABLE `dersler` DISABLE KEYS */;
99INSERT INTO `dersler` VALUES (1,1,'Sosyal Politika',1),(2,1,'Sosyolojiye Giris',1),(3,1,'Sosyal Bilimlerde Temel Kavramlar',1),(4,1,'Sembolik Tarih',1),(5,1,'Insan ve Toplum',1),(11,1,'Felsefe',2),(12,1,'Istatistik',2),(13,1,'Siyaset Bilimi',2),(14,1,'Antropoloji',2),(15,1,'Sosyoloji Tarihi',2),(21,3,'Eski Anadolu Tarihi',1),(22,3,'Tarih Metodu',1),(23,3,'Osmanlı Turkcesi',1),(24,3,'Orta Asya Turk Tarihi',1),(25,3,'Bizans Tarihi',1),(28,3,'Ataturk Ilke ve Inkilaplari',2),(29,3,'Orta Cag Tarihi',2),(30,3,'Selcuklu Tarihi',2),(31,3,'Rusya Tarihi',2),(32,3,'Tarihi Cografya',2),(35,2,'Almanca I',1),(36,2,'Fransizca I',1),(37,2,'Ingilizce I',1),(38,2,'Lojistik Ilkeleri',1),(39,2,'Hukukun Temel Kavramlari',1),(43,2,'Almanca II',2),(44,2,'Fransizca II',2),(45,2,'Ingilizce II',2),(46,2,'Lojistik Yonetimi',2),(47,2,'Uluslararasi Lojistik',2);
100/*!40000 ALTER TABLE `dersler` ENABLE KEYS */;
101UNLOCK TABLES;
102
103--
104-- Table structure for table `hoca`
105--
106
107DROP TABLE IF EXISTS `hoca`;
108/*!40101 SET @saved_cs_client     = @@character_set_client */;
109/*!40101 SET character_set_client = utf8 */;
110CREATE TABLE `hoca` (
111  `id_h` int(11) NOT NULL AUTO_INCREMENT,
112  `id_i` int(11) DEFAULT NULL,
113  `id_b` int(11) DEFAULT NULL,
114  `id_u` int(11) DEFAULT NULL,
115  `kullanici` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
116  `sifre` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
117  `isim` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
118  `soyisim` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
119  `mail` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
120  PRIMARY KEY (`id_h`),
121  UNIQUE KEY `kullanici_UNIQUE` (`kullanici`)
122) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
123/*!40101 SET character_set_client = @saved_cs_client */;
124
125--
126-- Dumping data for table `hoca`
127--
128
129LOCK TABLES `hoca` WRITE;
130/*!40000 ALTER TABLE `hoca` DISABLE KEYS */;
131INSERT INTO `hoca` VALUES (1,35,1,1,'xxx','123','x','xx','x@gmail.com'),(10,34,3,3,'hbh','jnj','jnj','jh','jnjnj');
132/*!40000 ALTER TABLE `hoca` ENABLE KEYS */;
133UNLOCK TABLES;
134
135--
136-- Table structure for table `iller`
137--
138
139DROP TABLE IF EXISTS `iller`;
140/*!40101 SET @saved_cs_client     = @@character_set_client */;
141/*!40101 SET character_set_client = utf8 */;
142CREATE TABLE `iller` (
143  `id_i` int(11) NOT NULL AUTO_INCREMENT,
144  `il` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
145  PRIMARY KEY (`id_i`),
146  UNIQUE KEY `il_UNIQUE` (`il`)
147) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
148/*!40101 SET character_set_client = @saved_cs_client */;
149
150--
151-- Dumping data for table `iller`
152--
153
154LOCK TABLES `iller` WRITE;
155/*!40000 ALTER TABLE `iller` DISABLE KEYS */;
156INSERT INTO `iller` VALUES (1,'Adana'),(2,'Adıyaman'),(3,'Afyonkarahisar'),(4,'Ağrı'),(68,'Aksaray'),(5,'Amasya'),(6,'Ankara'),(7,'Antalya'),(75,'Ardahan'),(8,'Artvin'),(9,'Aydın'),(10,'Balıkesir'),(74,'Bartın'),(72,'Batman'),(69,'Bayburt'),(11,'Bilecik'),(12,'Bingöl'),(13,'Bitlis'),(14,'Bolu'),(15,'Burdur'),(16,'Bursa'),(17,'Çanakkale'),(18,'Çankırı'),(19,'Çorum'),(20,'Denizli'),(21,'Diyarbakır'),(81,'Düzce'),(22,'Edirne'),(23,'Elâzığ'),(24,'Erzincan'),(25,'Erzurum'),(26,'Eskişehir'),(27,'Gaziantep'),(28,'Giresun'),(29,'Gümüşhane'),(30,'Hakkâri'),(31,'Hatay'),(76,'Iğdır'),(32,'Isparta'),(34,'İstanbul'),(35,'İzmir'),(46,'Kahramanmaraş'),(78,'Karabük'),(70,'Karaman'),(36,'Kars'),(37,'Kastamonu'),(38,'Kayseri'),(71,'Kırıkkale'),(39,'Kırklareli'),(40,'Kırşehir'),(79,'Kilis'),(41,'Kocaeli'),(42,'Konya'),(43,'Kütahya'),(44,'Malatya'),(45,'Manisa'),(47,'Mardin'),(33,'Mersin'),(48,'Muğla'),(49,'Muş'),(50,'Nevşehir'),(51,'Niğde'),(52,'Ordu'),(80,'Osmaniye'),(53,'Rize'),(54,'Sakarya'),(55,'Samsun'),(56,'Siirt'),(57,'Sinop'),(58,'Sivas'),(63,'Şanlıurfa'),(73,'Şırnak'),(59,'Tekirdağ'),(60,'Tokat'),(61,'Trabzon'),(62,'Tunceli'),(64,'Uşak'),(65,'Van'),(77,'Yalova'),(66,'Yozgat'),(67,'Zonguldak');
157/*!40000 ALTER TABLE `iller` ENABLE KEYS */;
158UNLOCK TABLES;
159
160--
161-- Table structure for table `ogrenci`
162--
163
164DROP TABLE IF EXISTS `ogrenci`;
165/*!40101 SET @saved_cs_client     = @@character_set_client */;
166/*!40101 SET character_set_client = utf8 */;
167CREATE TABLE `ogrenci` (
168  `idogrenci` int(11) NOT NULL AUTO_INCREMENT,
169  `ogrencinumarasi` varchar(45) COLLATE utf8_turkish_ci DEFAULT NULL,
170  `ogrencisifre` varchar(45) COLLATE utf8_turkish_ci DEFAULT NULL,
171  `id_b` int(11) DEFAULT NULL,
172  `yariyil` varchar(45) COLLATE utf8_turkish_ci DEFAULT NULL,
173  `id_i` int(11) DEFAULT NULL,
174  PRIMARY KEY (`idogrenci`)
175) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
176/*!40101 SET character_set_client = @saved_cs_client */;
177
178--
179-- Dumping data for table `ogrenci`
180--
181
182LOCK TABLES `ogrenci` WRITE;
183/*!40000 ALTER TABLE `ogrenci` DISABLE KEYS */;
184INSERT INTO `ogrenci` VALUES (1,'144410','123',1,'1',16),(2,'144411','123',2,'1',34);
185/*!40000 ALTER TABLE `ogrenci` ENABLE KEYS */;
186UNLOCK TABLES;
187
188--
189-- Table structure for table `sinav`
190--
191
192DROP TABLE IF EXISTS `sinav`;
193/*!40101 SET @saved_cs_client     = @@character_set_client */;
194/*!40101 SET character_set_client = utf8 */;
195CREATE TABLE `sinav` (
196  `id_sv` int(11) NOT NULL AUTO_INCREMENT,
197  `sinav_tarihi` date DEFAULT NULL,
198  `id_d` int(11) DEFAULT NULL,
199  `hoca_d` int(11) DEFAULT NULL,
200  `temsilci_d` int(11) DEFAULT NULL,
201  PRIMARY KEY (`id_sv`)
202) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
203/*!40101 SET character_set_client = @saved_cs_client */;
204
205--
206-- Dumping data for table `sinav`
207--
208
209LOCK TABLES `sinav` WRITE;
210/*!40000 ALTER TABLE `sinav` DISABLE KEYS */;
211INSERT INTO `sinav` VALUES (15,'2018-06-16',37,1,1),(20,'2018-06-28',1,NULL,NULL),(21,'2018-06-30',2,1,NULL);
212/*!40000 ALTER TABLE `sinav` ENABLE KEYS */;
213UNLOCK TABLES;
214
215--
216-- Table structure for table `sinav_hoca`
217--
218
219DROP TABLE IF EXISTS `sinav_hoca`;
220/*!40101 SET @saved_cs_client     = @@character_set_client */;
221/*!40101 SET character_set_client = utf8 */;
222CREATE TABLE `sinav_hoca` (
223  `id_sh` int(11) NOT NULL AUTO_INCREMENT,
224  `id_h` int(11) DEFAULT NULL,
225  `id_bl` int(11) DEFAULT NULL,
226  `id_sv` int(11) DEFAULT NULL,
227  `onay` int(11) DEFAULT NULL,
228  PRIMARY KEY (`id_sh`)
229) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
230/*!40101 SET character_set_client = @saved_cs_client */;
231
232--
233-- Dumping data for table `sinav_hoca`
234--
235
236LOCK TABLES `sinav_hoca` WRITE;
237/*!40000 ALTER TABLE `sinav_hoca` DISABLE KEYS */;
238INSERT INTO `sinav_hoca` VALUES (110,5,4,15,1),(111,9,5,15,0),(112,8,6,15,0),(113,7,7,15,0),(114,2,8,15,1),(115,3,9,15,0),(116,6,1,15,0),(117,1,2,15,2),(118,4,3,15,0),(119,8,4,21,0),(120,9,5,21,0),(121,5,6,21,0),(122,7,7,21,0),(123,2,8,21,0),(124,10,9,21,0),(125,1,1,21,0),(126,6,2,21,0),(127,4,3,21,0);
239/*!40000 ALTER TABLE `sinav_hoca` ENABLE KEYS */;
240UNLOCK TABLES;
241
242--
243-- Table structure for table `sinav_temsilci`
244--
245
246DROP TABLE IF EXISTS `sinav_temsilci`;
247/*!40101 SET @saved_cs_client     = @@character_set_client */;
248/*!40101 SET character_set_client = utf8 */;
249CREATE TABLE `sinav_temsilci` (
250  `id_st` int(11) NOT NULL AUTO_INCREMENT,
251  `id_sv` int(11) DEFAULT NULL,
252  `id_t` int(11) DEFAULT NULL,
253  `id_u` int(11) DEFAULT NULL,
254  PRIMARY KEY (`id_st`)
255) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
256/*!40101 SET character_set_client = @saved_cs_client */;
257
258--
259-- Dumping data for table `sinav_temsilci`
260--
261
262LOCK TABLES `sinav_temsilci` WRITE;
263/*!40000 ALTER TABLE `sinav_temsilci` DISABLE KEYS */;
264INSERT INTO `sinav_temsilci` VALUES (80,15,2,1),(81,15,1,2),(82,15,3,3);
265/*!40000 ALTER TABLE `sinav_temsilci` ENABLE KEYS */;
266UNLOCK TABLES;
267
268--
269-- Table structure for table `soru`
270--
271
272DROP TABLE IF EXISTS `soru`;
273/*!40101 SET @saved_cs_client     = @@character_set_client */;
274/*!40101 SET character_set_client = utf8 */;
275CREATE TABLE `soru` (
276  `id_so` int(11) NOT NULL AUTO_INCREMENT,
277  `id_hd` int(11) DEFAULT NULL,
278  `soru` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
279  `a` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
280  `b` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
281  `c` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
282  `d` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
283  `e` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
284  `cevap` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
285  PRIMARY KEY (`id_so`)
286) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
287/*!40101 SET character_set_client = @saved_cs_client */;
288
289--
290-- Dumping data for table `soru`
291--
292
293LOCK TABLES `soru` WRITE;
294/*!40000 ALTER TABLE `soru` DISABLE KEYS */;
295INSERT INTO `soru` VALUES (17,9,'Iskitlerin Ocak tanricasi kimdir?','Abi','Ares','Tabiti','Argimpasa','Papaios','Ares');
296/*!40000 ALTER TABLE `soru` ENABLE KEYS */;
297UNLOCK TABLES;
298
299--
300-- Table structure for table `temsilci`
301--
302
303DROP TABLE IF EXISTS `temsilci`;
304/*!40101 SET @saved_cs_client     = @@character_set_client */;
305/*!40101 SET character_set_client = utf8 */;
306CREATE TABLE `temsilci` (
307  `id_t` int(11) NOT NULL AUTO_INCREMENT,
308  `id_i` int(11) DEFAULT NULL,
309  `kullanici` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
310  `sifre` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
311  `isim` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
312  `soyisim` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
313  `img_url` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
314  `mail` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
315  `id_u` int(11) DEFAULT NULL,
316  PRIMARY KEY (`id_t`)
317) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
318/*!40101 SET character_set_client = @saved_cs_client */;
319
320--
321-- Dumping data for table `temsilci`
322--
323
324LOCK TABLES `temsilci` WRITE;
325/*!40000 ALTER TABLE `temsilci` DISABLE KEYS */;
326INSERT INTO `temsilci` VALUES (1,35,'melist','123','x','xx','img/kullanici.png','xxxxx@gmail.com',1);
327/*!40000 ALTER TABLE `temsilci` ENABLE KEYS */;
328UNLOCK TABLES;
329
330--
331-- Table structure for table `universite`
332--
333
334DROP TABLE IF EXISTS `universite`;
335/*!40101 SET @saved_cs_client     = @@character_set_client */;
336/*!40101 SET character_set_client = utf8 */;
337CREATE TABLE `universite` (
338  `id_u` int(11) NOT NULL AUTO_INCREMENT,
339  `okul_adi` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
340  `id_i` int(11) DEFAULT NULL,
341  PRIMARY KEY (`id_u`)
342) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
343/*!40101 SET character_set_client = @saved_cs_client */;
344
345--
346-- Dumping data for table `universite`
347--
348
349LOCK TABLES `universite` WRITE;
350/*!40000 ALTER TABLE `universite` DISABLE KEYS */;
351INSERT INTO `universite` VALUES (1,'Türk Alman Üniversitesi',35),(2,'Beykent Üniversitesi',16),(3,'İstanbul Üniversitesi',34);
352/*!40000 ALTER TABLE `universite` ENABLE KEYS */;
353UNLOCK TABLES;
354
355--
356-- Table structure for table `yonetici`
357--
358
359DROP TABLE IF EXISTS `yonetici`;
360/*!40101 SET @saved_cs_client     = @@character_set_client */;
361/*!40101 SET character_set_client = utf8 */;
362CREATE TABLE `yonetici` (
363  `id_y` int(11) NOT NULL AUTO_INCREMENT,
364  `kullanici` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
365  `sifre` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
366  PRIMARY KEY (`id_y`),
367  UNIQUE KEY `kullanici_UNIQUE` (`kullanici`)
368) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
369/*!40101 SET character_set_client = @saved_cs_client */;
370
371--
372-- Dumping data for table `yonetici`
373--
374
375LOCK TABLES `yonetici` WRITE;
376/*!40000 ALTER TABLE `yonetici` DISABLE KEYS */;
377INSERT INTO `yonetici` VALUES (1,'xx','123');
378/*!40000 ALTER TABLE `yonetici` ENABLE KEYS */;
379UNLOCK TABLES;
380
381--
382-- Dumping events for database 'acik_ogretim'
383--
384
385--
386-- Dumping routines for database 'acik_ogretim'
387--
388DELIMITER ;;
389CREATE DEFINER=`root`@`localhost` PROCEDURE `giris`(IN id INT, kullanici_adi varchar(100))
390BEGIN
391
392IF id=1 THEN
393    SELECT sifre,id_y FROM acik_ogretim.yonetici where kullanici=kullanici_adi;
394    
395ELSEIF id=2 THEN
396SELECT sifre,id_h FROM acik_ogretim.hoca where kullanici=kullanici_adi;
397END IF;
398
399END ;;
400DELIMITER ;