· 8 years ago · May 02, 2018, 01:38 PM
1BEGIN TRANSACTION;
2CREATE TABLE IF NOT EXISTS `ogrenciDers` (
3 `ogrenciNo` INTEGER NOT NULL,
4 `dersKodu` TEXT NOT NULL
5);
6CREATE TABLE IF NOT EXISTS `ogrenci` (
7 `ogrenciNo` INTEGER NOT NULL,
8 `ogrenciAdi` TEXT NOT NULL,
9 PRIMARY KEY(`ogrenciNo`)
10);
11CREATE TABLE IF NOT EXISTS `ders` (
12 `dersKodu` TEXT NOT NULL,
13 `dersAdi` TEXT NOT NULL,
14 PRIMARY KEY(`dersKodu`)
15);
16COMMIT;