Rg4qJsGU

1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3CREATE TABLE IF NOT EXISTS `exam_classes` (
4  `id` int(11) NOT NULL AUTO_INCREMENT,
5  `name` varchar(255) NOT NULL,
6  `school_id` int(11) NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
9
10
11CREATE TABLE IF NOT EXISTS `exam_definitions` (
12  `id` int(11) NOT NULL AUTO_INCREMENT,
13  `name` varchar(255) NOT NULL,
14  PRIMARY KEY (`id`)
15) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
16
17INSERT INTO `exam_definitions` (`id`, `name`) VALUES
18(1, 'ÖSS'),
19(2, 'KPSS');
20
21CREATE TABLE IF NOT EXISTS `exam_definition_fields` (
22  `id` int(11) NOT NULL AUTO_INCREMENT,
23  `name` varchar(255) NOT NULL,
24  `start_char` int(10) unsigned NOT NULL,
25  `end_char` int(10) unsigned NOT NULL,
26  `definition_id` int(11) NOT NULL,
27  PRIMARY KEY (`id`)
28) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
29
30INSERT INTO `exam_definition_fields` (`id`, `name`, `start_char`, `end_char`, `definition_id`) VALUES
31(1, 'ADI SOYADI', 1, 22, 1),
32(2, 'TCKIMLIK', 25, 36, 1);
33
34CREATE TABLE IF NOT EXISTS `exam_exams` (
35  `id` int(11) NOT NULL AUTO_INCREMENT,
36  `definition_id` int(11) NOT NULL,
37  `name` varchar(255) NOT NULL,
38  `date` datetime NOT NULL,
39  PRIMARY KEY (`id`)
40) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
41
42
43CREATE TABLE IF NOT EXISTS `exam_results` (
44  `id` int(11) NOT NULL AUTO_INCREMENT,
45  `student_id` int(11) NOT NULL,
46  `definition_id` int(11) NOT NULL,
47  `exam_id` int(11) NOT NULL,
48  PRIMARY KEY (`id`)
49) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
50
51
52CREATE TABLE IF NOT EXISTS `exam_schools` (
53  `id` int(11) NOT NULL AUTO_INCREMENT,
54  `name` varchar(255) NOT NULL,
55  PRIMARY KEY (`id`)
56) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
57
58
59CREATE TABLE IF NOT EXISTS `exam_students` (
60  `id` int(11) NOT NULL AUTO_INCREMENT,
61  `name` varchar(255) NOT NULL,
62  `surname` varchar(255) NOT NULL,
63  `class_id` int(11) NOT NULL,
64  PRIMARY KEY (`id`)
65) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;