DROP DATABASE IF EXISTS `devamNet`;
CREATE DATABASE IF NOT EXISTS `devamnet` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci */;
USE `devamNet`;


-- Dumping structure for table devamNet.ayarlar
DROP TABLE IF EXISTS `ayarlar`;
CREATE TABLE IF NOT EXISTS `ayarlar` (
  `ServerIp` varchar(20) DEFAULT NULL,
  `MySqlPort` varchar(10) DEFAULT NULL,
  `MetinGoster` int(11) DEFAULT NULL,
  `MetinIcerik` varchar(50) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `OtoBaslat` int(11) DEFAULT NULL,
  `Versiyon` varchar(50) DEFAULT NULL,
  `DevamAlan` varchar(50) DEFAULT NULL,
  `DevamKapat` int(11) DEFAULT NULL COMMENT 'devamsizlik kapat butonu gorunumu',
  `DevamListe` int(11) DEFAULT NULL,
  `DevamKod` varchar(5) DEFAULT NULL,
  `SubeSecim` int(11) DEFAULT NULL COMMENT 'vt, sube secimi',
  `DownSabit` int(11) DEFAULT NULL,
  `DownServerPath` varchar(100) DEFAULT NULL,
  `DownLocalPath` varchar(100) DEFAULT NULL,
  `Programs` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin5;

-- Dumping data for table devamNet.ayarlar: 1 rows
/*!40000 ALTER TABLE `ayarlar` DISABLE KEYS */;
INSERT INTO `ayarlar` (`ServerIp`, `MySqlPort`, `MetinGoster`, `MetinIcerik`, `OtoBaslat`, `Versiyon`, `DevamAlan`, `DevamKapat`, `DevamListe`, `DevamKod`, `SubeSecim`, `DownSabit`, `DownServerPath`, `DownLocalPath`, `Programs`) VALUES
	('192.168.2.184', '3306', 0, '', 0, '0', 'Devre;Kurs;Zaman;Bolum;Sinif;', 0, 1, 'Y', 1, 1, 'C:\\Konular\\', 'C:\\Konular\\', 's;r;');
/*!40000 ALTER TABLE `ayarlar` ENABLE KEYS */;


-- Dumping structure for table devamNet.kontrol
DROP TABLE IF EXISTS `kontrol`;
CREATE TABLE IF NOT EXISTS `kontrol` (
  `KontrolId` int(11) NOT NULL AUTO_INCREMENT,
  `Keygen` varchar(50) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `DbName` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `Sube` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `Danisman` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `BransId` int(11) DEFAULT NULL,
  `BransAdi` varchar(50) DEFAULT NULL,
  `Durum` int(11) DEFAULT NULL,
  `Tip` int(11) DEFAULT '1' COMMENT '0 : genel / 1 : ogretmen',
  PRIMARY KEY (`KontrolId`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin5;

-- Dumping structure for table devamNet.kullanici
DROP TABLE IF EXISTS `kullanici`;
CREATE TABLE IF NOT EXISTS `kullanici` (
  `KullaniciId` int(11) NOT NULL AUTO_INCREMENT,
  `User` varchar(25) CHARACTER SET latin5 NOT NULL,
  `Pass` varchar(255) CHARACTER SET latin5 DEFAULT NULL,
  `Adi` varchar(50) CHARACTER SET latin5 DEFAULT NULL,
  `Soyadi` varchar(50) CHARACTER SET latin5 DEFAULT NULL,
  PRIMARY KEY (`KullaniciId`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table devamNet.kullanici: 1 rows
/*!40000 ALTER TABLE `kullanici` DISABLE KEYS */;
INSERT INTO `kullanici` (`KullaniciId`, `User`, `Pass`, `Adi`, `Soyadi`) VALUES
	(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '', '');
/*!40000 ALTER TABLE `kullanici` ENABLE KEYS */;


-- Dumping structure for table devamNet.kullaniciekran
DROP TABLE IF EXISTS `kullaniciekran`;
CREATE TABLE IF NOT EXISTS `kullaniciekran` (
  `EkranId` int(11) NOT NULL,
  `EkranNo` int(11) NOT NULL,
  `EkranAdi` varchar(50) NOT NULL,
  PRIMARY KEY (`EkranId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table devamNet.kullaniciekran: 14 rows
/*!40000 ALTER TABLE `kullaniciekran` DISABLE KEYS */;
INSERT INTO `kullaniciekran` (`EkranId`, `EkranNo`, `EkranAdi`) VALUES
	(11, 11, 'Program Ayarlarý'),
	(12, 12, 'Terminal'),
	(13, 13, 'Key Üreteç'),
	(14, 14, 'Key Kontrol'),
	(31, 31, 'Seviye Tanýmlama'),
	(32, 32, 'Ders Tanýmlama'),
	(33, 33, 'Konu Tanýmlama'),
	(34, 34, 'Þube - Danýþman Tanýmlama'),
	(35, 35, 'Þube - Seviye Tanýmlama'),
	(51, 51, 'Danýþman Log'),
	(52, 52, 'Devamsýzlýk Log'),
	(53, 53, 'Keygen Log'),
	(54, 54, 'Konu Takip Log'),
	(101, 101, 'Kullanýcý');
/*!40000 ALTER TABLE `kullaniciekran` ENABLE KEYS */;


-- Dumping structure for table devamNet.kullaniciyetki
DROP TABLE IF EXISTS `kullaniciyetki`;
CREATE TABLE IF NOT EXISTS `kullaniciyetki` (
  `yetkiId` int(11) NOT NULL AUTO_INCREMENT,
  `KullaniciId` int(11) NOT NULL,
  `EkranId` int(11) NOT NULL,
  `Okuma` int(11) NOT NULL DEFAULT '1',
  `Yazma` int(11) NOT NULL DEFAULT '1',
  `Silme` int(11) NOT NULL DEFAULT '1',
  `Rapor` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`yetkiId`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- Dumping data for table devamNet.kullaniciyetki: 14 rows
/*!40000 ALTER TABLE `kullaniciyetki` DISABLE KEYS */;
INSERT INTO `kullaniciyetki` (`yetkiId`, `KullaniciId`, `EkranId`, `Okuma`, `Yazma`, `Silme`, `Rapor`) VALUES
	(1, 1, 11, 1, 1, 1, 1),
	(2, 1, 12, 1, 1, 1, 1),
	(3, 1, 13, 1, 1, 1, 1),
	(4, 1, 14, 1, 1, 1, 1),
	(5, 1, 31, 1, 1, 1, 1),
	(6, 1, 32, 1, 1, 1, 1),
	(7, 1, 33, 1, 1, 1, 1),
	(8, 1, 34, 1, 1, 1, 1),
	(9, 1, 35, 1, 1, 1, 1),
	(10, 1, 51, 1, 1, 1, 1),
	(11, 1, 52, 1, 1, 1, 1),
	(12, 1, 53, 1, 1, 1, 1),
	(13, 1, 54, 1, 1, 1, 1),
	(14, 1, 101, 1, 1, 1, 1);
/*!40000 ALTER TABLE `kullaniciyetki` ENABLE KEYS */;


-- Dumping structure for table devamNet.logdanisman
DROP TABLE IF EXISTS `logdanisman`;
CREATE TABLE IF NOT EXISTS `logdanisman` (
  `LogDanismanId` int(11) NOT NULL AUTO_INCREMENT,
  `LogTarih` datetime DEFAULT NULL,
  `Tarih` datetime DEFAULT NULL,
  `Danisman` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `DbName` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `Sube` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `SinifKodu` varchar(100) DEFAULT NULL,
  `SinifAdi` varchar(100) DEFAULT NULL,
  `Ders` int(11) DEFAULT NULL,
  `Durum` int(11) DEFAULT NULL,
  `Aciklama` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`LogDanismanId`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin5;

-- Dumping structure for table devamNet.logdevamsizlik
DROP TABLE IF EXISTS `logdevamsizlik`;
CREATE TABLE IF NOT EXISTS `logdevamsizlik` (
  `LogDevamsizlikId` int(11) NOT NULL AUTO_INCREMENT,
  `LogTarih` datetime DEFAULT NULL,
  `Tarih` datetime DEFAULT NULL,
  `DbName` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `Sube` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `SinifKodu` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `SinifAdi` varchar(100) DEFAULT NULL,
  `Danisman` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `OgrNo` varchar(25) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `OgrAdi` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `DersNo` int(11) DEFAULT NULL,
  `Durum` varchar(25) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`LogDevamsizlikId`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin5;

-- Dumping structure for table devamNet.logkeygen
DROP TABLE IF EXISTS `logkeygen`;
CREATE TABLE IF NOT EXISTS `logkeygen` (
  `LogKeygenId` int(11) NOT NULL AUTO_INCREMENT,
  `Keygen` varchar(50) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `DbName` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `Sube` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `Danisman` varchar(100) CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `Brans` varchar(50) DEFAULT NULL,
  `Durum` int(11) DEFAULT NULL,
  `Tip` int(11) DEFAULT '1' COMMENT '0 : genel / 1 : ogretmen',
  PRIMARY KEY (`LogKeygenId`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin5;


-- Dumping structure for table devamNet.logkonutakip
DROP TABLE IF EXISTS `logkonutakip`;
CREATE TABLE IF NOT EXISTS `logkonutakip` (
  `KonuTakipId` int(11) NOT NULL AUTO_INCREMENT,
  `KonuTanimAdi` varchar(255) COLLATE utf8_turkish_ci DEFAULT NULL,
  `LogTarih` datetime DEFAULT NULL,
  `Tarih` datetime DEFAULT NULL,
  `DbName` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  `Sube` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  `SinifKodu` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  `SinifAdi` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  `DersNo` int(11) DEFAULT NULL,
  `Danisman` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  `Durum` varchar(25) COLLATE utf8_turkish_ci DEFAULT NULL,
  `Aciklama` varchar(255) COLLATE utf8_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`KonuTakipId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

-- Dumping structure for table devamNet.tanimgenel
DROP TABLE IF EXISTS `tanimgenel`;
CREATE TABLE IF NOT EXISTS `tanimgenel` (
  `TanimId` int(11) NOT NULL AUTO_INCREMENT,
  `TanimAdi` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
  `Tip` tinyint(4) DEFAULT NULL COMMENT '0 : Seviye / 1 : Ders',
  PRIMARY KEY (`TanimId`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

-- Dumping data for table devamNet.tanimgenel: 13 rows
/*!40000 ALTER TABLE `tanimgenel` DISABLE KEYS */;
INSERT INTO `tanimgenel` (`TanimId`, `TanimAdi`, `Tip`) VALUES
	(1, '6.Sýnýf', 0),
	(2, '7.Sýnýf', 0),
	(3, '8.Sýnýf', 0),
	(4, '9.Sýnýf', 0),
	(5, '10.Sýnýf', 0),
	(6, '11.Sýnýf', 0),
	(7, '12.Sýnýf', 0),
	(8, 'Mezun', 0),
	(9, 'Türkçe', 1),
	(10, 'Matematik', 1),
	(11, 'Fen Bilimleri', 1),
	(12, 'Fizik', 1),
	(13, 'Kimya', 1),
	(14, 'Biyoloji', 1);
/*!40000 ALTER TABLE `tanimgenel` ENABLE KEYS */;


-- Dumping structure for table devamNet.tanimkonu
DROP TABLE IF EXISTS `tanimkonu`;
CREATE TABLE IF NOT EXISTS `tanimkonu` (
  `TanimKonuId` int(11) NOT NULL AUTO_INCREMENT,
  `SeviyeId` int(11) DEFAULT NULL,
  `DersId` int(11) DEFAULT NULL,
  `KonuAdi` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`TanimKonuId`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

-- Dumping structure for table devamNet.tanimsubedanisman
DROP TABLE IF EXISTS `tanimsubedanisman`;
CREATE TABLE IF NOT EXISTS `tanimsubedanisman` (
  `SubeDanismanId` int(11) NOT NULL AUTO_INCREMENT,
  `DbName` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  `SubeKodu` varchar(10) COLLATE utf8_turkish_ci DEFAULT NULL,
  `SubeAdi` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  `Danisman` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  `SinifId` int(11) DEFAULT NULL,
  `SinifKodu` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
  `SinifAdi` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`SubeDanismanId`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;


-- Dumping structure for table devamNet.tanimsubeseviye
DROP TABLE IF EXISTS `tanimsubeseviye`;
CREATE TABLE IF NOT EXISTS `tanimsubeseviye` (
  `SubeSeviyeId` int(11) NOT NULL AUTO_INCREMENT,
  `DbName` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  `SubeKodu` varchar(10) COLLATE utf8_turkish_ci DEFAULT NULL,
  `SubeAdi` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  `SinifId` int(11) DEFAULT NULL,
  `SinifKodu` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
  `SinifAdi` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
  `SeviyeId` int(11) DEFAULT NULL,
  `SeviyeAdi` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`SubeSeviyeId`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

-- Dumping structure for table devamNet.terminal
DROP TABLE IF EXISTS `terminal`;
CREATE TABLE IF NOT EXISTS `terminal` (
  `TerminalIp` varchar(20) COLLATE utf8_turkish_ci NOT NULL DEFAULT '',
  `TerminalAdi` varchar(20) COLLATE utf8_turkish_ci DEFAULT NULL,
  `Durum` tinyint(4) DEFAULT NULL COMMENT '0:closed; 1 : disable; 2:enable',
  `Saat` datetime DEFAULT NULL,
  `Tanimlama` tinyint(4) DEFAULT NULL COMMENT '0 : otomatik; 1 : elle',
  PRIMARY KEY (`TerminalIp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
