· 6 years ago · Nov 07, 2019, 10:52 AM
1-- phpMyAdmin SQL Dump
2-- version 4.8.5
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Nov 07, 2019 at 10:46 AM
7-- Server version: 5.7.26
8-- PHP Version: 7.2.18
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `izglitibas_iestade_isilins`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `audzekni`
29--
30
31DROP TABLE IF EXISTS `audzekni`;
32CREATE TABLE IF NOT EXISTS `audzekni` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `vards` char(30) DEFAULT NULL,
35 `uzvards` char(50) DEFAULT NULL,
36 `dzimdiena` date DEFAULT NULL,
37 `grupa` int(11) DEFAULT NULL,
38 PRIMARY KEY (`id`),
39 KEY `grupa` (`grupa`)
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42-- --------------------------------------------------------
43
44--
45-- Table structure for table `grupas`
46--
47
48DROP TABLE IF EXISTS `grupas`;
49CREATE TABLE IF NOT EXISTS `grupas` (
50 `id` int(11) NOT NULL AUTO_INCREMENT,
51 `nosaukums` char(5) DEFAULT NULL,
52 `kvalifikacija` int(11) DEFAULT NULL,
53 PRIMARY KEY (`id`),
54 KEY `kvalifikacija` (`kvalifikacija`)
55) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
56
57--
58-- Dumping data for table `grupas`
59--
60
61INSERT INTO `grupas` (`id`, `nosaukums`, `kvalifikacija`) VALUES
62(8, 'D4-1', 1),
63(9, 'D4-2', 1),
64(10, 'D4-3', 2),
65(11, 'D4-4', 2);
66
67-- --------------------------------------------------------
68
69--
70-- Table structure for table `komisijas`
71--
72
73DROP TABLE IF EXISTS `komisijas`;
74CREATE TABLE IF NOT EXISTS `komisijas` (
75 `id` int(11) NOT NULL AUTO_INCREMENT,
76 `nosaukums` char(100) DEFAULT NULL,
77 PRIMARY KEY (`id`)
78) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
79
80--
81-- Dumping data for table `komisijas`
82--
83
84INSERT INTO `komisijas` (`id`, `nosaukums`) VALUES
85(1, 'JKT');
86
87-- --------------------------------------------------------
88
89--
90-- Table structure for table `kvalifikacijas`
91--
92
93DROP TABLE IF EXISTS `kvalifikacijas`;
94CREATE TABLE IF NOT EXISTS `kvalifikacijas` (
95 `id` int(11) NOT NULL AUTO_INCREMENT,
96 `nosaukums` char(50) DEFAULT NULL,
97 PRIMARY KEY (`id`)
98) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
99
100--
101-- Dumping data for table `kvalifikacijas`
102--
103
104INSERT INTO `kvalifikacijas` (`id`, `nosaukums`) VALUES
105(1, NULL),
106(2, NULL),
107(3, NULL),
108(4, NULL),
109(5, 'programmesanas tehnikis'),
110(6, 'datorsistemu tehnikis');
111
112-- --------------------------------------------------------
113
114--
115-- Table structure for table `maca`
116--
117
118DROP TABLE IF EXISTS `maca`;
119CREATE TABLE IF NOT EXISTS `maca` (
120 `semestris` int(11) DEFAULT NULL,
121 `p_stundas` int(11) DEFAULT NULL,
122 `t_stundas` int(11) DEFAULT NULL,
123 `grupa` int(11) NOT NULL,
124 `skolotajs` char(10) NOT NULL,
125 `prieksmets` int(11) NOT NULL,
126 PRIMARY KEY (`grupa`,`skolotajs`,`prieksmets`),
127 KEY `prieksmets` (`prieksmets`),
128 KEY `skolotajs` (`skolotajs`)
129) ENGINE=InnoDB DEFAULT CHARSET=latin1;
130
131-- --------------------------------------------------------
132
133--
134-- Table structure for table `macas`
135--
136
137DROP TABLE IF EXISTS `macas`;
138CREATE TABLE IF NOT EXISTS `macas` (
139 `vertejums` int(11) DEFAULT NULL,
140 `skolens` int(11) NOT NULL,
141 `prieksmets` int(11) NOT NULL,
142 PRIMARY KEY (`skolens`,`prieksmets`),
143 KEY `prieksmets` (`prieksmets`)
144) ENGINE=InnoDB DEFAULT CHARSET=latin1;
145
146-- --------------------------------------------------------
147
148--
149-- Table structure for table `pasniedz`
150--
151
152DROP TABLE IF EXISTS `pasniedz`;
153CREATE TABLE IF NOT EXISTS `pasniedz` (
154 `prieksmets` int(11) NOT NULL,
155 `skolotajs` char(10) NOT NULL,
156 PRIMARY KEY (`prieksmets`,`skolotajs`),
157 KEY `skolotajs` (`skolotajs`)
158) ENGINE=InnoDB DEFAULT CHARSET=latin1;
159
160--
161-- Dumping data for table `pasniedz`
162--
163
164INSERT INTO `pasniedz` (`prieksmets`, `skolotajs`) VALUES
165(1, '11 111 111'),
166(1, '22 222 222'),
167(2, '22 222 222'),
168(3, '33 333 333'),
169(4, '33 333 333');
170
171-- --------------------------------------------------------
172
173--
174-- Table structure for table `prieksmeti`
175--
176
177DROP TABLE IF EXISTS `prieksmeti`;
178CREATE TABLE IF NOT EXISTS `prieksmeti` (
179 `id` int(11) NOT NULL AUTO_INCREMENT,
180 `nosaukums` char(50) DEFAULT NULL,
181 PRIMARY KEY (`id`)
182) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
183
184--
185-- Dumping data for table `prieksmeti`
186--
187
188INSERT INTO `prieksmeti` (`id`, `nosaukums`) VALUES
189(1, 'Datu bazes'),
190(2, 'Operetajsistemas'),
191(3, 'Datorsistemu uzbuve'),
192(4, 'Datortikli');
193
194-- --------------------------------------------------------
195
196--
197-- Table structure for table `skolotaji`
198--
199
200DROP TABLE IF EXISTS `skolotaji`;
201CREATE TABLE IF NOT EXISTS `skolotaji` (
202 `talrunis` char(10) NOT NULL,
203 `vards` char(30) DEFAULT NULL,
204 `uzvards` char(50) DEFAULT NULL,
205 `stazs` int(11) DEFAULT NULL,
206 `komisija` int(11) DEFAULT NULL,
207 PRIMARY KEY (`talrunis`),
208 KEY `komisija` (`komisija`)
209) ENGINE=InnoDB DEFAULT CHARSET=latin1;
210
211--
212-- Dumping data for table `skolotaji`
213--
214
215INSERT INTO `skolotaji` (`talrunis`, `vards`, `uzvards`, `stazs`, `komisija`) VALUES
216('11 111 111', 'Jelena', 'Matvejeva', 15, 1),
217('22 222 222', 'Jurijs', 'Kurdrins', 25, 1),
218('33 333 333', 'Vitalijs', 'Sabanskis', 10, 1);
219
220--
221-- Constraints for dumped tables
222--
223
224--
225-- Constraints for table `audzekni`
226--
227ALTER TABLE `audzekni`
228 ADD CONSTRAINT `audzekni_ibfk_1` FOREIGN KEY (`grupa`) REFERENCES `grupas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
229
230--
231-- Constraints for table `grupas`
232--
233ALTER TABLE `grupas`
234 ADD CONSTRAINT `grupas_ibfk_1` FOREIGN KEY (`kvalifikacija`) REFERENCES `kvalifikacijas` (`id`);
235
236--
237-- Constraints for table `maca`
238--
239ALTER TABLE `maca`
240 ADD CONSTRAINT `maca_ibfk_1` FOREIGN KEY (`prieksmets`) REFERENCES `prieksmeti` (`id`),
241 ADD CONSTRAINT `maca_ibfk_2` FOREIGN KEY (`grupa`) REFERENCES `grupas` (`id`),
242 ADD CONSTRAINT `maca_ibfk_3` FOREIGN KEY (`skolotajs`) REFERENCES `skolotaji` (`talrunis`);
243
244--
245-- Constraints for table `macas`
246--
247ALTER TABLE `macas`
248 ADD CONSTRAINT `macas_ibfk_1` FOREIGN KEY (`prieksmets`) REFERENCES `prieksmeti` (`id`),
249 ADD CONSTRAINT `macas_ibfk_2` FOREIGN KEY (`skolens`) REFERENCES `audzekni` (`id`);
250
251--
252-- Constraints for table `pasniedz`
253--
254ALTER TABLE `pasniedz`
255 ADD CONSTRAINT `pasniedz_ibfk_1` FOREIGN KEY (`prieksmets`) REFERENCES `prieksmeti` (`id`),
256 ADD CONSTRAINT `pasniedz_ibfk_2` FOREIGN KEY (`skolotajs`) REFERENCES `skolotaji` (`talrunis`);
257
258--
259-- Constraints for table `skolotaji`
260--
261ALTER TABLE `skolotaji`
262 ADD CONSTRAINT `skolotaji_ibfk_1` FOREIGN KEY (`komisija`) REFERENCES `komisijas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
263COMMIT;
264
265/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
266/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
267/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;