-- http://www.phpmyadmin.net
--
-- Anamakine: localhost
-- Üretim Zamanı: 22 Nis 2017, 16:44:14
-- Sunucu sürümü: 5.5.20
-- PHP Sürümü: 5.3.9




--
-- Veritabanı: `mobile`
--
CREATE DATABASE `mobile` DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci;
USE `mobile`;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `alinandersler`
--

CREATE TABLE IF NOT EXISTS `alinandersler` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `OgrenciNo` varchar(9) NOT NULL,
  `DersKodu` varchar(10) NOT NULL,
  `Durum` varchar(1) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin5 AUTO_INCREMENT=161 ;

--
-- Tablo döküm verisi `alinandersler`
--

INSERT INTO `alinandersler` (`Id`, `OgrenciNo`, `DersKodu`, `Durum`) VALUES
(1, '091262034', 'FİZ - 101', '2'),
(2, '091262034', 'BM - 101', '2'),
(3, '091262034', 'TÜR - 101', '2'),
(4, '091262034', 'MAT - 101', '2'),
(5, '091262034', 'KİM - 101', '2'),
(6, '091262034', 'İNG - 101', '2'),
(7, '091262034', 'TAR - 101', '2'),
(8, '091262034', 'BM - 103', '2'),
(9, '091262039', 'FİZ - 101', '2'),
(10, '091262065', 'FİZ - 101', '2'),
(11, '091262035', 'FİZ - 101', '2'),
(12, '091262030', 'FİZ - 101', '2'),
(13, '091262060', 'FİZ - 101', '2'),
(14, '091262031', 'FİZ - 101', '2'),
(15, '091262038', 'FİZ - 101', '2'),
(16, '091262036', 'FİZ - 101', '2'),
(17, '091262044', 'FİZ - 101', '2'),
(18, '091262039', 'BM - 101', '2'),
(19, '091262065', 'BM - 101', '2'),
(20, '091262035', 'BM - 101', '2'),
(21, '091262030', 'BM - 101', '2'),
(22, '091262060', 'BM - 101', '2'),
(23, '091262031', 'BM - 101', '2'),
(24, '091262038', 'BM - 101', '2'),
(25, '091262036', 'BM - 101', '2'),
(26, '091262044', 'BM - 101', '2'),
(27, '091262039', 'TÜR - 101', '2'),
(28, '091262065', 'TÜR - 101', '2'),
(29, '091262035', 'TÜR - 101', '2'),
(30, '091262030', 'TÜR - 101', '2'),
(31, '091262060', 'TÜR - 101', '2'),
(32, '091262031', 'TÜR - 101', '2'),
(33, '091262038', 'TÜR - 101', '2'),
(34, '091262036', 'TÜR - 101', '2'),
(35, '091262044', 'TÜR - 101', '2'),
(36, '091262039', 'MAT - 101', '2'),
(37, '091262065', 'MAT - 101', '2'),
(38, '091262035', 'MAT - 101', '2'),
(39, '091262030', 'MAT - 101', '2'),
(40, '091262060', 'MAT - 101', '2'),
(41, '091262031', 'MAT - 101', '2'),
(42, '091262038', 'MAT - 101', '2'),
(43, '091262036', 'MAT - 101', '2'),
(44, '091262044', 'MAT - 101', '2'),
(45, '091262039', 'KİM - 101', '2'),
(46, '091262065', 'KİM - 101', '2'),
(47, '091262035', 'KİM - 101', '2'),
(48, '091262030', 'KİM - 101', '2'),
(49, '091262060', 'KİM - 101', '2'),
(50, '091262031', 'KİM - 101', '2'),
(51, '091262038', 'KİM - 101', '2'),
(52, '091262036', 'KİM - 101', '2'),
(53, '091262044', 'KİM - 101', '2'),
(54, '091262039', 'İNG - 101', '2'),
(55, '091262065', 'İNG - 101', '2'),
(56, '091262035', 'İNG - 101', '2'),
(57, '091262030', 'İNG - 101', '2'),
(58, '091262060', 'İNG - 101', '2'),
(59, '091262031', 'İNG - 101', '2'),
(60, '091262038', 'İNG - 101', '2'),
(61, '091262036', 'İNG - 101', '2'),
(62, '091262044', 'İNG - 101', '2'),
(63, '091262039', 'TAR - 101', '2'),
(64, '091262065', 'TAR - 101', '2'),
(65, '091262035', 'TAR - 101', '2'),
(66, '091262030', 'TAR - 101', '2'),
(67, '091262060', 'TAR - 101', '2'),
(68, '091262031', 'TAR - 101', '2'),
(69, '091262038', 'TAR - 101', '2'),
(70, '091262036', 'TAR - 101', '2'),
(71, '091262044', 'TAR - 101', '2'),
(72, '091262039', 'BM - 103', '2'),
(73, '091262065', 'BM - 103', '2'),
(74, '091262035', 'BM - 103', '2'),
(75, '091262030', 'BM - 103', '2'),
(76, '091262060', 'BM - 103', '2'),
(77, '091262031', 'BM - 103', '2'),
(78, '091262038', 'BM - 103', '2'),
(79, '091262036', 'BM - 103', '2'),
(80, '091262044', 'BM - 103', '2'),
(81, '091262034', 'MAT - 102', '1'),
(82, '091262034', 'TUR - 102', '1'),
(83, '091262034', 'İNG - 102', '1'),
(84, '091262034', 'TAR - 102', '1'),
(85, '091262034', 'BM - 106', '1'),
(86, '091262034', 'BM - 104', '1'),
(87, '091262034', 'MAT - 104', '1'),
(88, '091262034', 'FİZ - 104', '1'),
(89, '091262065', 'MAT - 102', '1'),
(90, '091262039', 'MAT - 102', '1'),
(91, '091262035', 'MAT - 102', '1'),
(92, '091262030', 'MAT - 102', '1'),
(93, '091262060', 'MAT - 102', '1'),
(94, '091262031', 'MAT - 102', '1'),
(95, '091262038', 'MAT - 102', '1'),
(96, '091262036', 'MAT - 102', '1'),
(97, '091262044', 'MAT - 102', '1'),
(98, '091262039', 'TUR - 102', '1'),
(99, '091262065', 'TUR - 102', '1'),
(100, '091262035', 'TUR - 102', '1'),
(101, '091262030', 'TUR - 102', '1'),
(102, '091262060', 'TUR - 102', '1'),
(103, '091262031', 'TUR - 102', '1'),
(104, '091262038', 'TUR - 102', '1'),
(105, '091262036', 'TUR - 102', '1'),
(106, '091262044', 'TUR - 102', '1'),
(107, '091262039', 'İNG - 102', '1'),
(108, '091262065', 'İNG - 102', '1'),
(109, '091262035', 'İNG - 102', '1'),
(110, '091262030', 'İNG - 102', '1'),
(111, '091262060', 'İNG - 102', '1'),
(112, '091262031', 'İNG - 102', '1'),
(113, '091262038', 'İNG - 102', '1'),
(114, '091262036', 'İNG - 102', '1'),
(115, '091262044', 'İNG - 102', '1'),
(116, '091262039', 'TAR - 102', '1'),
(117, '091262065', 'TAR - 102', '1'),
(118, '091262035', 'TAR - 102', '1'),
(119, '091262030', 'TAR - 102', '1'),
(120, '091262060', 'TAR - 102', '1'),
(121, '091262031', 'TAR - 102', '1'),
(122, '091262038', 'TAR - 102', '1'),
(123, '091262036', 'TAR - 102', '1'),
(124, '091262044', 'TAR - 102', '1'),
(125, '091262039', 'BM - 106', '1'),
(126, '091262065', 'BM - 106', '1'),
(127, '091262035', 'BM - 106', '1'),
(128, '091262030', 'BM - 106', '1'),
(129, '091262060', 'BM - 106', '1'),
(130, '091262031', 'BM - 106', '1'),
(131, '091262038', 'BM - 106', '1'),
(132, '091262036', 'BM - 106', '1'),
(133, '091262044', 'BM - 106', '1'),
(134, '091262039', 'BM - 104', '1'),
(135, '091262065', 'BM - 104', '1'),
(136, '091262035', 'BM - 104', '1'),
(137, '091262030', 'BM - 104', '1'),
(138, '091262060', 'BM - 104', '1'),
(139, '091262031', 'BM - 104', '1'),
(140, '091262038', 'BM - 104', '1'),
(141, '091262036', 'BM - 104', '1'),
(142, '091262044', 'BM - 104', '1'),
(143, '091262039', 'MAT - 104', '1'),
(144, '091262065', 'MAT - 104', '1'),
(145, '091262035', 'MAT - 104', '1'),
(146, '091262030', 'MAT - 104', '1'),
(147, '091262060', 'MAT - 104', '1'),
(148, '091262031', 'MAT - 104', '1'),
(149, '091262038', 'MAT - 104', '1'),
(150, '091262036', 'MAT - 104', '1'),
(151, '091262044', 'MAT - 104', '1'),
(152, '091262039', 'FİZ - 104', '1'),
(153, '091262065', 'FİZ - 104', '1'),
(154, '091262035', 'FİZ - 104', '1'),
(155, '091262030', 'FİZ - 104', '1'),
(156, '091262060', 'FİZ - 104', '1'),
(157, '091262031', 'FİZ - 104', '1'),
(158, '091262038', 'FİZ - 104', '1'),
(159, '091262036', 'FİZ - 104', '1'),
(160, '091262044', 'FİZ - 104', '1');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `dersgunu`
--

CREATE TABLE IF NOT EXISTS `dersgunu` (
  `GunId` int(11) NOT NULL AUTO_INCREMENT,
  `DersId` int(11) NOT NULL,
  `DersGunRakam` varchar(1) NOT NULL,
  `DersGunYazi` varchar(10) NOT NULL,
  `DersBasSaat` time NOT NULL,
  `DersBitSaat` time NOT NULL,
  PRIMARY KEY (`GunId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin5 AUTO_INCREMENT=17 ;

--
-- Tablo döküm verisi `dersgunu`
--

INSERT INTO `dersgunu` (`GunId`, `DersId`, `DersGunRakam`, `DersGunYazi`, `DersBasSaat`, `DersBitSaat`) VALUES
(1, 1, '1', 'PAZARTESİ', '09:20:00', '12:35:00'),
(2, 2, '1', 'PAZARTESİ', '13:30:00', '14:15:00'),
(3, 3, '2', 'SALI', '10:10:00', '11:45:00'),
(4, 4, '2', 'SALI', '13:30:00', '16:45:00'),
(5, 5, '3', 'ÇARŞAMBA', '08:30:00', '11:45:00'),
(6, 6, '3', 'ÇARŞAMBA', '13:30:00', '15:55:00'),
(7, 7, '4', 'PERŞEMBE', '09:20:00', '10:55:00'),
(8, 8, '5', 'CUMA', '10:10:00', '12:35:00'),
(9, 9, '1', 'PAZARTESİ', '09:20:00', '12:35:00'),
(10, 10, '1', 'PAZARTESİ', '13:30:00', '15:05:00'),
(11, 11, '1', 'PAZARTESİ', '16:00:00', '17:35:00'),
(12, 12, '2', 'SALI', '10:10:00', '11:45:00'),
(13, 13, '2', 'SALI', '13:30:00', '15:55:00'),
(14, 14, '3', 'ÇARŞAMBA', '09:20:00', '12:35:00'),
(15, 15, '4', 'PERŞEMBE', '10:10:00', '12:35:00'),
(16, 16, '4', 'PERŞEMBE', '13:30:00', '15:05:00');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `dersler`
--

CREATE TABLE IF NOT EXISTS `dersler` (
  `DersId` int(11) NOT NULL AUTO_INCREMENT,
  `DersKodu` varchar(10) NOT NULL,
  `DersAdi` varchar(100) NOT NULL,
  `Hoca` varchar(100) NOT NULL,
  `Kredi` int(1) NOT NULL,
  `Donem` varchar(1) NOT NULL,
  PRIMARY KEY (`DersId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin5 AUTO_INCREMENT=17 ;

--
-- Tablo döküm verisi `dersler`
--

INSERT INTO `dersler` (`DersId`, `DersKodu`, `DersAdi`, `Hoca`, `Kredi`, `Donem`) VALUES
(1, 'FİZ - 101', 'Fizik - 1', '1', 4, '1'),
(2, 'BM - 101', 'Bilgisayar Mühendisliğine Giriş', '2', 4, '1'),
(3, 'TÜR - 101', 'Türk Dili - 1', '3', 2, '1'),
(4, 'MAT - 101', 'Matematik - 1', '4', 4, '1'),
(5, 'KİM - 101', 'Kimya - 1', '5', 3, '1'),
(6, 'İNG - 101', 'İngilizce - 1', '6', 3, '1'),
(7, 'TAR - 101', 'Tarih - 1', '7', 3, '1'),
(8, 'BM - 103', 'Algoritma ve Programlama', '8', 3, '1'),
(9, 'MAT - 102', 'Matematik - II', '4', 3, '2'),
(10, 'TUR - 102', 'Türk Dili - 2', '9', 2, '2'),
(11, 'İNG - 102', 'İngilizce - II', '10', 3, '2'),
(12, 'TAR - 102', 'Tarih - II', '7', 2, '2'),
(13, 'BM - 106', 'Teknik Resim', '11', 3, '2'),
(14, 'BM - 104', 'Yapısal Programlama', '12', 3, '2'),
(15, 'MAT - 104', 'Lineer Cebir', '4', 4, '2'),
(16, 'FİZ - 104', 'Fizik - II', '13', 3, '2');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `final`
--

CREATE TABLE IF NOT EXISTS `final` (
  `FinalId` int(11) NOT NULL AUTO_INCREMENT,
  `DersId` int(11) NOT NULL,
  `OgrenciNo` varchar(9) NOT NULL,
  `FinalNotu` int(3) NOT NULL,
  PRIMARY KEY (`FinalId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin5 AUTO_INCREMENT=87 ;

--
-- Tablo döküm verisi `final`
--

INSERT INTO `final` (`FinalId`, `DersId`, `OgrenciNo`, `FinalNotu`) VALUES
(7, 1, '091262030', 65),
(8, 1, '091262031', 86),
(9, 1, '091262034', 84),
(10, 1, '091262035', 82),
(11, 1, '091262036', 75),
(12, 1, '091262038', 62),
(13, 1, '091262039', 85),
(14, 1, '091262044', 45),
(15, 1, '091262060', 62),
(16, 1, '091262065', 75),
(17, 2, '091262030', 75),
(18, 2, '091262031', 80),
(19, 2, '091262034', 75),
(20, 2, '091262035', 86),
(21, 2, '091262036', 48),
(22, 2, '091262038', 45),
(23, 2, '091262039', 62),
(24, 2, '091262044', 35),
(25, 2, '091262060', 37),
(26, 2, '091262065', 42),
(27, 3, '091262030', 45),
(28, 3, '091262031', 60),
(29, 3, '091262034', 85),
(30, 3, '091262035', 75),
(31, 3, '091262036', 40),
(32, 3, '091262038', 45),
(33, 3, '091262039', 95),
(34, 3, '091262044', 62),
(35, 3, '091262060', 35),
(36, 3, '091262065', 65),
(37, 4, '091262030', 45),
(38, 4, '091262031', 86),
(39, 4, '091262034', 85),
(40, 4, '091262035', 75),
(41, 4, '091262036', 42),
(42, 4, '091262038', 62),
(43, 4, '091262039', 85),
(44, 4, '091262044', 74),
(45, 4, '091262060', 95),
(46, 4, '091262065', 42),
(47, 5, '091262030', 68),
(48, 5, '091262031', 75),
(49, 5, '091262034', 74),
(50, 5, '091262035', 82),
(51, 5, '091262036', 63),
(52, 5, '091262038', 41),
(53, 5, '091262039', 43),
(54, 5, '091262044', 56),
(55, 5, '091262060', 49),
(56, 5, '091262065', 58),
(57, 6, '091262030', 48),
(58, 6, '091262031', 59),
(59, 6, '091262034', 65),
(60, 6, '091262035', 82),
(61, 6, '091262036', 45),
(62, 6, '091262038', 76),
(63, 6, '091262039', 91),
(64, 6, '091262044', 53),
(65, 6, '091262060', 62),
(66, 6, '091262065', 45),
(67, 7, '091262030', 85),
(68, 7, '091262031', 76),
(69, 7, '091262034', 42),
(70, 7, '091262035', 86),
(71, 7, '091262036', 94),
(72, 7, '091262038', 83),
(73, 7, '091262039', 75),
(74, 7, '091262044', 71),
(75, 7, '091262060', 72),
(76, 7, '091262065', 76),
(77, 8, '091262030', 76),
(78, 8, '091262031', 74),
(79, 8, '091262034', 75),
(80, 8, '091262035', 73),
(81, 8, '091262036', 82),
(82, 8, '091262038', 76),
(83, 8, '091262039', 92),
(84, 8, '091262044', 45),
(85, 8, '091262060', 68),
(86, 8, '091262065', 66);

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `vize`
--

CREATE TABLE IF NOT EXISTS `vize` (
  `VizeId` int(11) NOT NULL AUTO_INCREMENT,
  `DersId` int(11) NOT NULL,
  `OgrenciNo` varchar(9) NOT NULL,
  `VizeNotu` int(3) NOT NULL,
  PRIMARY KEY (`VizeId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin5 AUTO_INCREMENT=172 ;

--
-- Tablo döküm verisi `vize`
--

INSERT INTO `vize` (`VizeId`, `DersId`, `OgrenciNo`, `VizeNotu`) VALUES
(12, 1, '091262030', 80),
(13, 1, '091262031', 95),
(14, 1, '091262034', 80),
(15, 1, '091262035', 80),
(16, 1, '091262036', 60),
(17, 1, '091262038', 55),
(18, 1, '091262039', 35),
(19, 1, '091262044', 25),
(20, 1, '091262060', 55),
(21, 1, '091262065', 13),
(22, 2, '091262030', 52),
(23, 2, '091262031', 65),
(24, 2, '091262034', 84),
(25, 2, '091262035', 25),
(26, 2, '091262036', 42),
(27, 2, '091262038', 25),
(28, 2, '091262039', 18),
(29, 2, '091262044', 26),
(30, 2, '091262060', 85),
(31, 2, '091262065', 45),
(32, 3, '091262030', 60),
(33, 3, '091262031', 96),
(34, 3, '091262034', 45),
(35, 3, '091262035', 86),
(36, 3, '091262036', 36),
(37, 3, '091262038', 30),
(38, 3, '091262039', 75),
(39, 3, '091262044', 75),
(40, 3, '091262060', 85),
(41, 3, '091262065', 89),
(42, 4, '091262030', 74),
(43, 4, '091262031', 78),
(44, 4, '091262034', 35),
(45, 4, '091262035', 75),
(46, 4, '091262036', 89),
(47, 4, '091262038', 14),
(48, 4, '091262039', 82),
(49, 4, '091262044', 89),
(50, 4, '091262060', 35),
(51, 4, '091262065', 30),
(52, 9, '091262030', 54),
(53, 9, '091262031', 86),
(54, 9, '091262034', 95),
(55, 9, '091262035', 45),
(56, 9, '091262036', 62),
(57, 9, '091262038', 89),
(58, 9, '091262039', 82),
(59, 9, '091262044', 55),
(60, 9, '091262060', 26),
(61, 9, '091262065', 17),
(62, 15, '091262030', 75),
(63, 15, '091262031', 89),
(64, 15, '091262034', 62),
(65, 15, '091262035', 43),
(66, 15, '091262036', 58),
(67, 15, '091262038', 56),
(68, 15, '091262039', 43),
(69, 15, '091262044', 28),
(70, 15, '091262060', 85),
(71, 15, '091262065', 94),
(72, 5, '091262030', 84),
(73, 5, '091262031', 41),
(74, 5, '091262034', 70),
(75, 5, '091262035', 75),
(76, 5, '091262036', 89),
(77, 5, '091262038', 82),
(78, 5, '091262039', 65),
(79, 5, '091262044', 3),
(80, 5, '091262060', 14),
(81, 5, '091262065', 91),
(82, 6, '091262030', 74),
(83, 6, '091262031', 78),
(84, 6, '091262034', 35),
(85, 6, '091262035', 75),
(86, 6, '091262036', 89),
(87, 6, '091262038', 82),
(88, 6, '091262039', 89),
(89, 6, '091262044', 61),
(90, 6, '091262060', 75),
(91, 6, '091262065', 98),
(92, 7, '091262030', 85),
(93, 7, '091262031', 75),
(94, 7, '091262034', 86),
(95, 7, '091262035', 95),
(96, 7, '091262036', 80),
(97, 7, '091262038', 82),
(98, 7, '091262039', 84),
(99, 7, '091262044', 87),
(100, 7, '091262060', 65),
(101, 7, '091262065', 43),
(102, 12, '091262030', 62),
(103, 12, '091262031', 75),
(104, 12, '091262034', 84),
(105, 12, '091262035', 63),
(106, 12, '091262036', 56),
(107, 12, '091262038', 59),
(108, 12, '091262039', 85),
(109, 12, '091262044', 68),
(110, 12, '091262060', 74),
(111, 12, '091262065', 69),
(112, 8, '091262030', 65),
(113, 8, '091262031', 36),
(114, 8, '091262034', 42),
(115, 8, '091262035', 75),
(116, 8, '091262036', 96),
(117, 8, '091262038', 45),
(118, 8, '091262039', 36),
(119, 8, '091262044', 52),
(120, 8, '091262060', 45),
(121, 8, '091262065', 90),
(122, 10, '091262030', 75),
(123, 10, '091262031', 80),
(124, 10, '091262034', 95),
(125, 10, '091262035', 85),
(126, 10, '091262036', 60),
(127, 10, '091262038', 56),
(128, 10, '091262039', 78),
(129, 10, '091262044', 45),
(130, 10, '091262060', 90),
(131, 10, '091262065', 49),
(132, 11, '091262030', 85),
(133, 11, '091262031', 75),
(134, 11, '091262034', 80),
(135, 11, '091262035', 85),
(136, 11, '091262036', 85),
(137, 11, '091262038', 70),
(138, 11, '091262039', 75),
(139, 11, '091262044', 85),
(140, 11, '091262060', 70),
(141, 11, '091262065', 95),
(142, 13, '091262030', 85),
(143, 13, '091262031', 80),
(144, 13, '091262034', 89),
(145, 13, '091262035', 75),
(146, 13, '091262036', 60),
(147, 13, '091262038', 65),
(148, 13, '091262039', 70),
(149, 13, '091262044', 45),
(150, 13, '091262060', 60),
(151, 13, '091262065', 75),
(152, 14, '091262030', 70),
(153, 14, '091262031', 75),
(154, 14, '091262034', 70),
(155, 14, '091262035', 70),
(156, 14, '091262036', 65),
(157, 14, '091262038', 65),
(158, 14, '091262039', 70),
(159, 14, '091262044', 75),
(160, 14, '091262060', 75),
(161, 14, '091262065', 55),
(162, 16, '091262030', 45),
(163, 16, '091262031', 60),
(164, 16, '091262034', 55),
(165, 16, '091262035', 40),
(166, 16, '091262036', 30),
(167, 16, '091262038', 20),
(168, 16, '091262039', 25),
(169, 16, '091262044', 35),
(170, 16, '091262060', 45),
(171, 16, '091262065', 49);

