Closed gencmucitler closed 5 months ago
Merhaba @gencmucitler,
Veri tabanı yapısına ulaşmak için aşağıdaki sql sorgusunu çalıştırabilir veya ekte dosyaları import edebilirsiniz.
odev_takip_otomasyonu.json odev_takip_otomasyonu.csv odev_takip_otomasyonu-forMSExcel.csv
CREATE DATABASE IF NOT EXISTS odev_takip_otomasyonu CHARACTER SET utf8 COLLATE utf8_turkish_ci;
USE odev_takip_otomasyonu;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
CREATE TABLE `bolumler` (
`bolum_id` int(11) NOT NULL,
`adi` varchar(100) COLLATE utf8_turkish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
INSERT INTO `bolumler` (`bolum_id`, `adi`) VALUES
(1, 'Tüm Bölümler'),
(2, 'Bilgisayar Mühendisliği'),
(3, 'Elektrik-Elektronik Mühendisliği'),
(4, 'Makine Mühendisliği'),
(5, 'Biyomedikal Mühendisliği'),
(6, 'Mekatronik Mühendisliği'),
(7, 'Metalurji ve Malzeme Mühendisliği');
CREATE TABLE `dersler` (
`ders_id` int(11) NOT NULL,
`adi` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
`aciklama` text COLLATE utf8_turkish_ci,
`bolum_id` int(11) NOT NULL,
`ogrt_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
CREATE TABLE `haberler` (
`haber_id` int(11) NOT NULL,
`baslik` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
`icerik` text COLLATE utf8_turkish_ci NOT NULL,
`tarih` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`bolum_id` int(11) NOT NULL,
`uye_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
CREATE TABLE `odevler` (
`odev_id` int(11) NOT NULL,
`odev_adi` varchar(50) COLLATE utf8_turkish_ci NOT NULL,
`aciklama` text COLLATE utf8_turkish_ci,
`baslangic_tarihi` datetime NOT NULL,
`bitis_tarihi` datetime NOT NULL,
`ders_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
CREATE TABLE `ogrenci` (
`ogr_id` int(11) NOT NULL,
`adi` varchar(30) COLLATE utf8_turkish_ci NOT NULL,
`soyadi` varchar(30) COLLATE utf8_turkish_ci NOT NULL,
`kullanici_adi` varchar(30) COLLATE utf8_turkish_ci NOT NULL,
`sifre` char(32) COLLATE utf8_turkish_ci NOT NULL,
`e_posta` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
`sehir_id` int(11) NOT NULL,
`telno` varchar(12) COLLATE utf8_turkish_ci NOT NULL,
`adres` text COLLATE utf8_turkish_ci,
`web_sayfasi` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
`aciklama` text COLLATE utf8_turkish_ci,
`ilgi_alanlari` text COLLATE utf8_turkish_ci,
`uye_id` int(11) NOT NULL,
`bolum_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
INSERT INTO `ogrenci` (`ogr_id`, `adi`, `soyadi`, `kullanici_adi`, `sifre`, `e_posta`, `sehir_id`, `telno`, `adres`, `web_sayfasi`, `aciklama`, `ilgi_alanlari`, `uye_id`, `bolum_id`) VALUES
(18, 'Deneme', 'Öğrenci', 'ogrenci', '827ccb0eea8a706c4c34a16891f84e7b', 'deneme@site.com', 42, '111-222-3333', NULL, NULL, NULL, NULL, 3, 2);
CREATE TABLE `ogretmen` (
`ogrt_id` int(11) NOT NULL,
`adi` varchar(30) COLLATE utf8_turkish_ci NOT NULL,
`soyadi` varchar(30) COLLATE utf8_turkish_ci NOT NULL,
`kullanici_adi` varchar(30) COLLATE utf8_turkish_ci NOT NULL,
`sifre` char(32) COLLATE utf8_turkish_ci NOT NULL,
`e_posta` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
`sehir_id` int(11) NOT NULL,
`telno` varchar(12) COLLATE utf8_turkish_ci DEFAULT NULL,
`adres` text COLLATE utf8_turkish_ci,
`web_sayfasi` varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,
`aciklama` text COLLATE utf8_turkish_ci,
`ilgi_alanlari` text COLLATE utf8_turkish_ci,
`uye_id` int(11) NOT NULL,
`bolum_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
INSERT INTO `ogretmen` (`ogrt_id`, `adi`, `soyadi`, `kullanici_adi`, `sifre`, `e_posta`, `sehir_id`, `telno`, `adres`, `web_sayfasi`, `aciklama`, `ilgi_alanlari`, `uye_id`, `bolum_id`) VALUES
(25, 'Deneme', 'ÖĞRETMEN', 'ogretmen', '827ccb0eea8a706c4c34a16891f84e7b', 'ogretmen@site.com', 42, '111-222-3333', NULL, NULL, NULL, NULL, 2, 2);
CREATE TABLE `ogr_ders` (
`ders_id` int(11) NOT NULL,
`ogr_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
CREATE TABLE `ogr_odev` (
`odev_id` int(11) NOT NULL,
`ogr_id` int(11) NOT NULL,
`odev_gonderildi` int(11) DEFAULT NULL,
`gonderme_tarihi` datetime DEFAULT NULL,
`odev_not` tinyint(3) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
CREATE TABLE `sehirler` (
`sehir_id` int(11) NOT NULL,
`sehir_adi` varchar(30) COLLATE utf8_turkish_ci NOT NULL,
`plaka_kodu` smallint(2) UNSIGNED ZEROFILL NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
INSERT INTO `sehirler` (`sehir_id`, `sehir_adi`, `plaka_kodu`) VALUES
(1, 'ADANA', 01),
(2, 'ADIYAMAN', 02),
(3, 'AFYON', 03),
(4, 'AĞRI', 04),
(5, 'AMASYA', 05),
(6, 'ANKARA', 06),
(7, 'ANTALYA', 07),
(8, 'ARTVİN', 08),
(9, 'AYDIN', 09),
(10, 'BALIKESİR', 10),
(11, 'BİLECİK', 11),
(12, 'BİNGÖL', 12),
(13, 'BİTLİS', 13),
(14, 'BOLU', 14),
(15, 'BURDUR', 15),
(16, 'BURSA', 16),
(17, 'ÇANAKKALE', 17),
(18, 'ÇANKIRI', 18),
(19, 'ÇORUM', 19),
(20, 'DENİZLİ', 20),
(21, 'DİYARBAKIR', 21),
(22, 'EDİRNE', 22),
(23, 'ELAZIĞ', 23),
(24, 'ERZİNCAN', 24),
(25, 'ERZURUM', 25),
(26, 'ESKİŞEHİR', 26),
(27, 'GAZİANTEP', 27),
(28, 'GİRESUN', 28),
(29, 'GÜMÜŞHANE', 29),
(30, 'HAKKARİ', 30),
(31, 'HATAY', 31),
(32, 'ISPARTA', 32),
(33, 'İÇEL', 33),
(34, 'İSTANBUL', 34),
(35, 'İZMİR', 35),
(36, 'KARS', 36),
(37, 'KASTAMONU', 37),
(38, 'KAYSERİ', 38),
(39, 'KIRKLARELİ', 39),
(40, 'KIRŞEHİR', 40),
(41, 'KOCAELİ', 41),
(42, 'KONYA', 42),
(43, 'KÜTAHYA', 43),
(44, 'MALATYA', 44),
(45, 'MANİSA', 45),
(46, 'KAHRAMANMARAŞ', 46),
(47, 'MARDİN', 47),
(48, 'MUĞLA', 48),
(49, 'MUŞ', 49),
(50, 'NEVŞEHİR', 50),
(51, 'NİĞDE', 51),
(52, 'ORDU', 52),
(53, 'RİZE', 53),
(54, 'SAKARYA', 54),
(55, 'SAMSUN', 55),
(56, 'SİİRT', 56),
(57, 'SİNOP', 57),
(58, 'SİVAS', 58),
(59, 'TEKİRDAĞ', 59),
(60, 'TOKAT', 60),
(61, 'TRABZON', 61),
(62, 'TUNCELİ', 62),
(63, 'ŞANLIURFA', 63),
(64, 'UŞAK', 64),
(65, 'VAN', 65),
(66, 'YOZGAT', 66),
(67, 'ZONGULDAK', 67),
(68, 'AKSARAY', 68),
(69, 'BAYBURT', 69),
(70, 'KARAMAN', 70),
(71, 'KIRIKKALE', 71),
(72, 'BATMAN', 72),
(73, 'ŞIRNAK', 73),
(74, 'BARTIN', 74),
(75, 'ARDAHAN', 75),
(76, 'IĞDIR', 76),
(77, 'YALOVA', 77),
(78, 'KARABÜK', 78),
(79, 'KİLİS', 79),
(80, 'OSMANİYE', 80),
(81, 'DÜZCE', 81);
CREATE TABLE `uyelik_durumu` (
`uye_id` int(11) NOT NULL,
`uyelik_adi` varchar(30) COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
INSERT INTO `uyelik_durumu` (`uye_id`, `uyelik_adi`) VALUES
(3, 'ogrenci'),
(2, 'ogretmen'),
(1, 'yonetici');
CREATE TABLE `yonetici` (
`admin_id` int(11) NOT NULL,
`adi` varchar(75) COLLATE utf8_turkish_ci NOT NULL,
`kullanici_adi` varchar(30) COLLATE utf8_turkish_ci NOT NULL,
`sifre` char(32) COLLATE utf8_turkish_ci NOT NULL,
`uye_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
INSERT INTO `yonetici` (`admin_id`, `adi`, `kullanici_adi`, `sifre`, `uye_id`) VALUES
(1, 'Yönetici', 'admin', '827ccb0eea8a706c4c34a16891f84e7b', 1);
ALTER TABLE `bolumler`
ADD PRIMARY KEY (`bolum_id`),
ADD UNIQUE KEY `bolum_id` (`bolum_id`),
ADD UNIQUE KEY `adi` (`adi`);
ALTER TABLE `dersler`
ADD PRIMARY KEY (`ders_id`),
ADD UNIQUE KEY `ders_id` (`ders_id`),
ADD UNIQUE KEY `adi` (`adi`),
ADD KEY `bolum_id` (`bolum_id`),
ADD KEY `ogrt_id` (`ogrt_id`);
ALTER TABLE `haberler`
ADD PRIMARY KEY (`haber_id`),
ADD UNIQUE KEY `haber_id` (`haber_id`),
ADD KEY `bolum_id` (`bolum_id`),
ADD KEY `uye_id` (`uye_id`);
ALTER TABLE `odevler`
ADD PRIMARY KEY (`odev_id`),
ADD UNIQUE KEY `odev_id` (`odev_id`),
ADD KEY `ders_id` (`ders_id`);
ALTER TABLE `ogrenci`
ADD PRIMARY KEY (`ogr_id`),
ADD UNIQUE KEY `ogr_id` (`ogr_id`),
ADD UNIQUE KEY `kullanici_adi` (`kullanici_adi`),
ADD UNIQUE KEY `e_posta` (`e_posta`),
ADD UNIQUE KEY `cep_tel` (`telno`),
ADD KEY `uye_id` (`uye_id`),
ADD KEY `bolum_id` (`bolum_id`),
ADD KEY `sehir_id` (`sehir_id`);
ALTER TABLE `ogretmen`
ADD PRIMARY KEY (`ogrt_id`),
ADD UNIQUE KEY `ogrt_id` (`ogrt_id`),
ADD UNIQUE KEY `kullanici_adi` (`kullanici_adi`),
ADD UNIQUE KEY `e_posta` (`e_posta`),
ADD KEY `uye_id` (`uye_id`),
ADD KEY `bolum_id` (`bolum_id`),
ADD KEY `sehir_id` (`sehir_id`);
ALTER TABLE `ogr_ders`
ADD KEY `ders_id` (`ders_id`),
ADD KEY `ogr_id` (`ogr_id`);
ALTER TABLE `ogr_odev`
ADD KEY `odev_id` (`odev_id`),
ADD KEY `ogr_id` (`ogr_id`);
ALTER TABLE `sehirler`
ADD PRIMARY KEY (`sehir_id`),
ADD UNIQUE KEY `sehir_adi` (`sehir_adi`),
ADD UNIQUE KEY `plaka_kodu` (`plaka_kodu`),
ADD UNIQUE KEY `sehir_id` (`sehir_id`);
ALTER TABLE `uyelik_durumu`
ADD PRIMARY KEY (`uye_id`),
ADD UNIQUE KEY `uye_id` (`uye_id`),
ADD UNIQUE KEY `unvan` (`uyelik_adi`);
ALTER TABLE `yonetici`
ADD PRIMARY KEY (`admin_id`),
ADD UNIQUE KEY `admin_id` (`admin_id`),
ADD UNIQUE KEY `kullanici_adi` (`kullanici_adi`),
ADD KEY `uye_id` (`uye_id`);
ALTER TABLE `bolumler`
MODIFY `bolum_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
ALTER TABLE `dersler`
MODIFY `ders_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
ALTER TABLE `haberler`
MODIFY `haber_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
ALTER TABLE `odevler`
MODIFY `odev_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
ALTER TABLE `ogrenci`
MODIFY `ogr_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
ALTER TABLE `ogretmen`
MODIFY `ogrt_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
ALTER TABLE `sehirler`
MODIFY `sehir_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;
ALTER TABLE `uyelik_durumu`
MODIFY `uye_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
ALTER TABLE `yonetici`
MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
ALTER TABLE `dersler`
ADD CONSTRAINT `dersler_ibfk_1` FOREIGN KEY (`bolum_id`) REFERENCES `bolumler` (`bolum_id`) ON UPDATE CASCADE,
ADD CONSTRAINT `dersler_ibfk_2` FOREIGN KEY (`ogrt_id`) REFERENCES `ogretmen` (`ogrt_id`) ON DELETE SET NULL ON UPDATE CASCADE;
ALTER TABLE `haberler`
ADD CONSTRAINT `haberler_ibfk_1` FOREIGN KEY (`bolum_id`) REFERENCES `bolumler` (`bolum_id`) ON UPDATE CASCADE,
ADD CONSTRAINT `haberler_ibfk_2` FOREIGN KEY (`uye_id`) REFERENCES `yonetici` (`uye_id`) ON UPDATE CASCADE;
ALTER TABLE `odevler`
ADD CONSTRAINT `odevler_ibfk_1` FOREIGN KEY (`ders_id`) REFERENCES `dersler` (`ders_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `ogrenci`
ADD CONSTRAINT `ogrenci_ibfk_1` FOREIGN KEY (`uye_id`) REFERENCES `uyelik_durumu` (`uye_id`) ON UPDATE CASCADE,
ADD CONSTRAINT `ogrenci_ibfk_2` FOREIGN KEY (`bolum_id`) REFERENCES `bolumler` (`bolum_id`) ON UPDATE CASCADE,
ADD CONSTRAINT `ogrenci_ibfk_4` FOREIGN KEY (`sehir_id`) REFERENCES `sehirler` (`sehir_id`) ON UPDATE CASCADE;
ALTER TABLE `ogretmen`
ADD CONSTRAINT `ogretmen_ibfk_1` FOREIGN KEY (`uye_id`) REFERENCES `uyelik_durumu` (`uye_id`) ON UPDATE CASCADE,
ADD CONSTRAINT `ogretmen_ibfk_2` FOREIGN KEY (`bolum_id`) REFERENCES `bolumler` (`bolum_id`) ON UPDATE CASCADE,
ADD CONSTRAINT `ogretmen_ibfk_3` FOREIGN KEY (`sehir_id`) REFERENCES `sehirler` (`sehir_id`) ON UPDATE CASCADE;
ALTER TABLE `ogr_ders`
ADD CONSTRAINT `ogr_ders_ibfk_1` FOREIGN KEY (`ders_id`) REFERENCES `dersler` (`ders_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `ogr_ders_ibfk_2` FOREIGN KEY (`ogr_id`) REFERENCES `ogrenci` (`ogr_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `ogr_odev`
ADD CONSTRAINT `ogr_odev_ibfk_1` FOREIGN KEY (`odev_id`) REFERENCES `odevler` (`odev_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `ogr_odev_ibfk_2` FOREIGN KEY (`ogr_id`) REFERENCES `ogrenci` (`ogr_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `yonetici`
ADD CONSTRAINT `yonetici_ibfk_1` FOREIGN KEY (`uye_id`) REFERENCES `uyelik_durumu` (`uye_id`) ON UPDATE CASCADE;
COMMIT;
Teşekkür ederim. Bir şekilde kendim tabloları oluşturdum fakat eksiklikler vardı.
30 Nis 2024 Sal 17:25 tarihinde Berkan Ümütlü @.***> şunu yazdı:
Merhaba @gencmucitler https://github.com/gencmucitler,
Veri tabanı yapısına ulaşmak için aşağıdaki sql sorgusunu çalıştırabilir veya ekte dosyaları import edebilirsiniz.
odev_takip_otomasyonu.json https://github.com/berkanumutlu/Odev-Takip-Otomasyonu/files/15165805/odev_takip_otomasyonu.json odev_takip_otomasyonu.csv https://github.com/berkanumutlu/Odev-Takip-Otomasyonu/files/15165804/odev_takip_otomasyonu.csv odev_takip_otomasyonu-forMSExcel.csv https://github.com/berkanumutlu/Odev-Takip-Otomasyonu/files/15165806/odev_takip_otomasyonu-forMSExcel.csv
CREATE DATABASE IF NOT EXISTS odev_takip_otomasyonu CHARACTER SET utf8 COLLATE utf8_turkish_ci; USE odev_takip_otomasyonu;SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";START TRANSACTION;SET time_zone = "+00:00";CREATE TABLE
bolumler
(bolum_id
int(11) NOT NULL,adi
varchar(100) COLLATE utf8_turkish_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;INSERT INTObolumler
(bolum_id
,adi
) VALUES (1, 'Tüm Bölümler'), (2, 'Bilgisayar Mühendisliği'), (3, 'Elektrik-Elektronik Mühendisliği'), (4, 'Makine Mühendisliği'), (5, 'Biyomedikal Mühendisliği'), (6, 'Mekatronik Mühendisliği'), (7, 'Metalurji ve Malzeme Mühendisliği');CREATE TABLEdersler
(ders_id
int(11) NOT NULL,adi
varchar(100) COLLATE utf8_turkish_ci NOT NULL,aciklama
text COLLATE utf8_turkish_ci,bolum_id
int(11) NOT NULL,ogrt_id
int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;CREATE TABLEhaberler
(haber_id
int(11) NOT NULL,baslik
varchar(100) COLLATE utf8_turkish_ci NOT NULL,icerik
text COLLATE utf8_turkish_ci NOT NULL,tarih
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,bolum_id
int(11) NOT NULL,uye_id
int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;CREATE TABLEodevler
(odev_id
int(11) NOT NULL,odev_adi
varchar(50) COLLATE utf8_turkish_ci NOT NULL,aciklama
text COLLATE utf8_turkish_ci,baslangic_tarihi
datetime NOT NULL,bitis_tarihi
datetime NOT NULL,ders_id
int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;CREATE TABLEogrenci
(ogr_id
int(11) NOT NULL,adi
varchar(30) COLLATE utf8_turkish_ci NOT NULL,soyadi
varchar(30) COLLATE utf8_turkish_ci NOT NULL,kullanici_adi
varchar(30) COLLATE utf8_turkish_ci NOT NULL,sifre
char(32) COLLATE utf8_turkish_ci NOT NULL,e_posta
varchar(100) COLLATE utf8_turkish_ci NOT NULL,sehir_id
int(11) NOT NULL,telno
varchar(12) COLLATE utf8_turkish_ci NOT NULL,adres
text COLLATE utf8_turkish_ci,web_sayfasi
varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,aciklama
text COLLATE utf8_turkish_ci,ilgi_alanlari
text COLLATE utf8_turkish_ci,uye_id
int(11) NOT NULL,bolum_id
int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;INSERT INTOogrenci
(ogr_id
,adi
,soyadi
,kullanici_adi
,sifre
,e_posta
,sehir_id
,telno
,adres
,web_sayfasi
,aciklama
,ilgi_alanlari
,uye_id
,bolum_id
) VALUES (18, 'Deneme', 'Öğrenci', 'ogrenci', '827ccb0eea8a706c4c34a16891f84e7b', @.', 42, '111-222-3333', NULL, NULL, NULL, NULL, 3, 2);CREATE TABLEogretmen
(ogrt_id
int(11) NOT NULL,adi
varchar(30) COLLATE utf8_turkish_ci NOT NULL,soyadi
varchar(30) COLLATE utf8_turkish_ci NOT NULL,kullanici_adi
varchar(30) COLLATE utf8_turkish_ci NOT NULL,sifre
char(32) COLLATE utf8_turkish_ci NOT NULL,e_posta
varchar(100) COLLATE utf8_turkish_ci NOT NULL,sehir_id
int(11) NOT NULL,telno
varchar(12) COLLATE utf8_turkish_ci DEFAULT NULL,adres
text COLLATE utf8_turkish_ci,web_sayfasi
varchar(100) COLLATE utf8_turkish_ci DEFAULT NULL,aciklama
text COLLATE utf8_turkish_ci,ilgi_alanlari
text COLLATE utf8_turkish_ci,uye_id
int(11) NOT NULL,bolum_id
int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;INSERT INTOogretmen
(ogrt_id
,adi
,soyadi
,kullanici_adi
,sifre
,e_posta
,sehir_id
,telno
,adres
,web_sayfasi
,aciklama
,ilgi_alanlari
,uye_id
,bolum_id
) VALUES (25, 'Deneme', 'ÖĞRETMEN', 'ogretmen', '827ccb0eea8a706c4c34a16891f84e7b', @.', 42, '111-222-3333', NULL, NULL, NULL, NULL, 2, 2);CREATE TABLEogr_ders
(ders_id
int(11) NOT NULL,ogr_id
int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;CREATE TABLEogr_odev
(odev_id
int(11) NOT NULL,ogr_id
int(11) NOT NULL,odev_gonderildi
int(11) DEFAULT NULL,gonderme_tarihi
datetime DEFAULT NULL,odev_not
tinyint(3) UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;CREATE TABLEsehirler
(sehir_id
int(11) NOT NULL,sehir_adi
varchar(30) COLLATE utf8_turkish_ci NOT NULL,plaka_kodu
smallint(2) UNSIGNED ZEROFILL NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;INSERT INTOsehirler
(sehir_id
,sehir_adi
,plaka_kodu
) VALUES (1, 'ADANA', 01), (2, 'ADIYAMAN', 02), (3, 'AFYON', 03), (4, 'AĞRI', 04), (5, 'AMASYA', 05), (6, 'ANKARA', 06), (7, 'ANTALYA', 07), (8, 'ARTVİN', 08), (9, 'AYDIN', 09), (10, 'BALIKESİR', 10), (11, 'BİLECİK', 11), (12, 'BİNGÖL', 12), (13, 'BİTLİS', 13), (14, 'BOLU', 14), (15, 'BURDUR', 15), (16, 'BURSA', 16), (17, 'ÇANAKKALE', 17), (18, 'ÇANKIRI', 18), (19, 'ÇORUM', 19), (20, 'DENİZLİ', 20), (21, 'DİYARBAKIR', 21), (22, 'EDİRNE', 22), (23, 'ELAZIĞ', 23), (24, 'ERZİNCAN', 24), (25, 'ERZURUM', 25), (26, 'ESKİŞEHİR', 26), (27, 'GAZİANTEP', 27), (28, 'GİRESUN', 28), (29, 'GÜMÜŞHANE', 29), (30, 'HAKKARİ', 30), (31, 'HATAY', 31), (32, 'ISPARTA', 32), (33, 'İÇEL', 33), (34, 'İSTANBUL', 34), (35, 'İZMİR', 35), (36, 'KARS', 36), (37, 'KASTAMONU', 37), (38, 'KAYSERİ', 38), (39, 'KIRKLARELİ', 39), (40, 'KIRŞEHİR', 40), (41, 'KOCAELİ', 41), (42, 'KONYA', 42), (43, 'KÜTAHYA', 43), (44, 'MALATYA', 44), (45, 'MANİSA', 45), (46, 'KAHRAMANMARAŞ', 46), (47, 'MARDİN', 47), (48, 'MUĞLA', 48), (49, 'MUŞ', 49), (50, 'NEVŞEHİR', 50), (51, 'NİĞDE', 51), (52, 'ORDU', 52), (53, 'RİZE', 53), (54, 'SAKARYA', 54), (55, 'SAMSUN', 55), (56, 'SİİRT', 56), (57, 'SİNOP', 57), (58, 'SİVAS', 58), (59, 'TEKİRDAĞ', 59), (60, 'TOKAT', 60), (61, 'TRABZON', 61), (62, 'TUNCELİ', 62), (63, 'ŞANLIURFA', 63), (64, 'UŞAK', 64), (65, 'VAN', 65), (66, 'YOZGAT', 66), (67, 'ZONGULDAK', 67), (68, 'AKSARAY', 68), (69, 'BAYBURT', 69), (70, 'KARAMAN', 70), (71, 'KIRIKKALE', 71), (72, 'BATMAN', 72), (73, 'ŞIRNAK', 73), (74, 'BARTIN', 74), (75, 'ARDAHAN', 75), (76, 'IĞDIR', 76), (77, 'YALOVA', 77), (78, 'KARABÜK', 78), (79, 'KİLİS', 79), (80, 'OSMANİYE', 80), (81, 'DÜZCE', 81);CREATE TABLEuyelik_durumu
(uye_id
int(11) NOT NULL,uyelik_adi
varchar(30) COLLATE utf8_turkish_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;INSERT INTOuyelik_durumu
(uye_id
,uyelik_adi
) VALUES (3, 'ogrenci'), (2, 'ogretmen'), (1, 'yonetici');CREATE TABLEyonetici
(admin_id
int(11) NOT NULL,adi
varchar(75) COLLATE utf8_turkish_ci NOT NULL,kullanici_adi
varchar(30) COLLATE utf8_turkish_ci NOT NULL,sifre
char(32) COLLATE utf8_turkish_ci NOT NULL,uye_id
int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;INSERT INTOyonetici
(admin_id
,adi
,kullanici_adi
,sifre
,uye_id
) VALUES (1, 'Yönetici', 'admin', '827ccb0eea8a706c4c34a16891f84e7b', 1);ALTER TABLEbolumler
ADD PRIMARY KEY (bolum_id
), ADD UNIQUE KEYbolum_id
(bolum_id
), ADD UNIQUE KEYadi
(adi
);ALTER TABLEdersler
ADD PRIMARY KEY (ders_id
), ADD UNIQUE KEYders_id
(ders_id
), ADD UNIQUE KEYadi
(adi
), ADD KEYbolum_id
(bolum_id
), ADD KEYogrt_id
(ogrt_id
);ALTER TABLEhaberler
ADD PRIMARY KEY (haber_id
), ADD UNIQUE KEYhaber_id
(haber_id
), ADD KEYbolum_id
(bolum_id
), ADD KEYuye_id
(uye_id
);ALTER TABLEodevler
ADD PRIMARY KEY (odev_id
), ADD UNIQUE KEYodev_id
(odev_id
), ADD KEYders_id
(ders_id
);ALTER TABLEogrenci
ADD PRIMARY KEY (ogr_id
), ADD UNIQUE KEYogr_id
(ogr_id
), ADD UNIQUE KEYkullanici_adi
(kullanici_adi
), ADD UNIQUE KEYe_posta
(e_posta
), ADD UNIQUE KEYcep_tel
(telno
), ADD KEYuye_id
(uye_id
), ADD KEYbolum_id
(bolum_id
), ADD KEYsehir_id
(sehir_id
);ALTER TABLEogretmen
ADD PRIMARY KEY (ogrt_id
), ADD UNIQUE KEYogrt_id
(ogrt_id
), ADD UNIQUE KEYkullanici_adi
(kullanici_adi
), ADD UNIQUE KEYe_posta
(e_posta
), ADD KEYuye_id
(uye_id
), ADD KEYbolum_id
(bolum_id
), ADD KEYsehir_id
(sehir_id
);ALTER TABLEogr_ders
ADD KEYders_id
(ders_id
), ADD KEYogr_id
(ogr_id
);ALTER TABLEogr_odev
ADD KEYodev_id
(odev_id
), ADD KEYogr_id
(ogr_id
);ALTER TABLEsehirler
ADD PRIMARY KEY (sehir_id
), ADD UNIQUE KEYsehir_adi
(sehir_adi
), ADD UNIQUE KEYplaka_kodu
(plaka_kodu
), ADD UNIQUE KEYsehir_id
(sehir_id
);ALTER TABLEuyelik_durumu
ADD PRIMARY KEY (uye_id
), ADD UNIQUE KEYuye_id
(uye_id
), ADD UNIQUE KEYunvan
(uyelik_adi
);ALTER TABLEyonetici
ADD PRIMARY KEY (admin_id
), ADD UNIQUE KEYadmin_id
(admin_id
), ADD UNIQUE KEYkullanici_adi
(kullanici_adi
), ADD KEYuye_id
(uye_id
);ALTER TABLEbolumler
MODIFYbolum_id
int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;ALTER TABLEdersler
MODIFYders_id
int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;ALTER TABLEhaberler
MODIFYhaber_id
int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;ALTER TABLEodevler
MODIFYodev_id
int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;ALTER TABLEogrenci
MODIFYogr_id
int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;ALTER TABLEogretmen
MODIFYogrt_id
int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;ALTER TABLEsehirler
MODIFYsehir_id
int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;ALTER TABLEuyelik_durumu
MODIFYuye_id
int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;ALTER TABLEyonetici
MODIFYadmin_id
int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;ALTER TABLEdersler
ADD CONSTRAINTdersler_ibfk_1
FOREIGN KEY (bolum_id
) REFERENCESbolumler
(bolum_id
) ON UPDATE CASCADE, ADD CONSTRAINTdersler_ibfk_2
FOREIGN KEY (ogrt_id
) REFERENCESogretmen
(ogrt_id
) ON DELETE SET NULL ON UPDATE CASCADE;ALTER TABLEhaberler
ADD CONSTRAINThaberler_ibfk_1
FOREIGN KEY (bolum_id
) REFERENCESbolumler
(bolum_id
) ON UPDATE CASCADE, ADD CONSTRAINThaberler_ibfk_2
FOREIGN KEY (uye_id
) REFERENCESyonetici
(uye_id
) ON UPDATE CASCADE;ALTER TABLEodevler
ADD CONSTRAINTodevler_ibfk_1
FOREIGN KEY (ders_id
) REFERENCESdersler
(ders_id
) ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLEogrenci
ADD CONSTRAINTogrenci_ibfk_1
FOREIGN KEY (uye_id
) REFERENCESuyelik_durumu
(uye_id
) ON UPDATE CASCADE, ADD CONSTRAINTogrenci_ibfk_2
FOREIGN KEY (bolum_id
) REFERENCESbolumler
(bolum_id
) ON UPDATE CASCADE, ADD CONSTRAINTogrenci_ibfk_4
FOREIGN KEY (sehir_id
) REFERENCESsehirler
(sehir_id
) ON UPDATE CASCADE;ALTER TABLEogretmen
ADD CONSTRAINTogretmen_ibfk_1
FOREIGN KEY (uye_id
) REFERENCESuyelik_durumu
(uye_id
) ON UPDATE CASCADE, ADD CONSTRAINTogretmen_ibfk_2
FOREIGN KEY (bolum_id
) REFERENCESbolumler
(bolum_id
) ON UPDATE CASCADE, ADD CONSTRAINTogretmen_ibfk_3
FOREIGN KEY (sehir_id
) REFERENCESsehirler
(sehir_id
) ON UPDATE CASCADE;ALTER TABLEogr_ders
ADD CONSTRAINTogr_ders_ibfk_1
FOREIGN KEY (ders_id
) REFERENCESdersler
(ders_id
) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINTogr_ders_ibfk_2
FOREIGN KEY (ogr_id
) REFERENCESogrenci
(ogr_id
) ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLEogr_odev
ADD CONSTRAINTogr_odev_ibfk_1
FOREIGN KEY (odev_id
) REFERENCESodevler
(odev_id
) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINTogr_odev_ibfk_2
FOREIGN KEY (ogr_id
) REFERENCESogrenci
(ogr_id
) ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLEyonetici
ADD CONSTRAINTyonetici_ibfk_1
FOREIGN KEY (uye_id
) REFERENCESuyelik_durumu
(uye_id
) ON UPDATE CASCADE;COMMIT;— Reply to this email directly, view it on GitHub https://github.com/berkanumutlu/Odev-Takip-Otomasyonu/issues/1#issuecomment-2085472142, or unsubscribe https://github.com/notifications/unsubscribe-auth/AG3C37ULN7C5RPQ3BGKQC7DY76SWZAVCNFSM6AAAAAAXSFNDS6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAOBVGQ3TEMJUGI . You are receiving this because you were mentioned.Message ID: @.***>
Yapmış olduğunuz çalışma çok güzel bir projeye benziyor. Denemek için bilgisayarıma kurmak istediğimde gerekli veritabanı dosyasının olmadığını fark ettim. Bu konuda yardımcı olabilir misiniz? Teşekkür ederim.