· 6 years ago · Nov 02, 2019, 02:42 PM
1-- phpMyAdmin SQL Dump
2-- version 4.9.0.1
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Czas generowania: 02 Lis 2019, 15:33
7-- Wersja serwera: 10.4.6-MariaDB
8-- Wersja PHP: 7.3.9
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-- Baza danych: `matur`
23--
24CREATE DATABASE IF NOT EXISTS `matur` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `matur`;
26--
27-- Baza danych: `phpmyadmin`
28--
29CREATE DATABASE IF NOT EXISTS `phpmyadmin` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
30USE `phpmyadmin`;
31
32-- --------------------------------------------------------
33
34--
35-- Struktura tabeli dla tabeli `pma__bookmark`
36--
37
38CREATE TABLE `pma__bookmark` (
39 `id` int(10) UNSIGNED NOT NULL,
40 `dbase` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
41 `user` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
42 `label` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
43 `query` text COLLATE utf8_bin NOT NULL
44) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Bookmarks';
45
46-- --------------------------------------------------------
47
48--
49-- Struktura tabeli dla tabeli `pma__central_columns`
50--
51
52CREATE TABLE `pma__central_columns` (
53 `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
54 `col_name` varchar(64) COLLATE utf8_bin NOT NULL,
55 `col_type` varchar(64) COLLATE utf8_bin NOT NULL,
56 `col_length` text COLLATE utf8_bin DEFAULT NULL,
57 `col_collation` varchar(64) COLLATE utf8_bin NOT NULL,
58 `col_isNull` tinyint(1) NOT NULL,
59 `col_extra` varchar(255) COLLATE utf8_bin DEFAULT '',
60 `col_default` text COLLATE utf8_bin DEFAULT NULL
61) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Central list of columns';
62
63-- --------------------------------------------------------
64
65--
66-- Struktura tabeli dla tabeli `pma__column_info`
67--
68
69CREATE TABLE `pma__column_info` (
70 `id` int(5) UNSIGNED NOT NULL,
71 `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
72 `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
73 `column_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
74 `comment` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
75 `mimetype` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
76 `transformation` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
77 `transformation_options` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
78 `input_transformation` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
79 `input_transformation_options` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
80) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column information for phpMyAdmin';
81
82-- --------------------------------------------------------
83
84--
85-- Struktura tabeli dla tabeli `pma__designer_settings`
86--
87
88CREATE TABLE `pma__designer_settings` (
89 `username` varchar(64) COLLATE utf8_bin NOT NULL,
90 `settings_data` text COLLATE utf8_bin NOT NULL
91) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Settings related to Designer';
92
93-- --------------------------------------------------------
94
95--
96-- Struktura tabeli dla tabeli `pma__export_templates`
97--
98
99CREATE TABLE `pma__export_templates` (
100 `id` int(5) UNSIGNED NOT NULL,
101 `username` varchar(64) COLLATE utf8_bin NOT NULL,
102 `export_type` varchar(10) COLLATE utf8_bin NOT NULL,
103 `template_name` varchar(64) COLLATE utf8_bin NOT NULL,
104 `template_data` text COLLATE utf8_bin NOT NULL
105) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved export templates';
106
107-- --------------------------------------------------------
108
109--
110-- Struktura tabeli dla tabeli `pma__favorite`
111--
112
113CREATE TABLE `pma__favorite` (
114 `username` varchar(64) COLLATE utf8_bin NOT NULL,
115 `tables` text COLLATE utf8_bin NOT NULL
116) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Favorite tables';
117
118-- --------------------------------------------------------
119
120--
121-- Struktura tabeli dla tabeli `pma__history`
122--
123
124CREATE TABLE `pma__history` (
125 `id` bigint(20) UNSIGNED NOT NULL,
126 `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
127 `db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
128 `table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
129 `timevalue` timestamp NOT NULL DEFAULT current_timestamp(),
130 `sqlquery` text COLLATE utf8_bin NOT NULL
131) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='SQL history for phpMyAdmin';
132
133-- --------------------------------------------------------
134
135--
136-- Struktura tabeli dla tabeli `pma__navigationhiding`
137--
138
139CREATE TABLE `pma__navigationhiding` (
140 `username` varchar(64) COLLATE utf8_bin NOT NULL,
141 `item_name` varchar(64) COLLATE utf8_bin NOT NULL,
142 `item_type` varchar(64) COLLATE utf8_bin NOT NULL,
143 `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
144 `table_name` varchar(64) COLLATE utf8_bin NOT NULL
145) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Hidden items of navigation tree';
146
147--
148-- Zrzut danych tabeli `pma__navigationhiding`
149--
150
151INSERT INTO `pma__navigationhiding` (`username`, `item_name`, `item_type`, `db_name`, `table_name`) VALUES
152('root', 'nau', 'table', 'test', '');
153
154-- --------------------------------------------------------
155
156--
157-- Struktura tabeli dla tabeli `pma__pdf_pages`
158--
159
160CREATE TABLE `pma__pdf_pages` (
161 `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
162 `page_nr` int(10) UNSIGNED NOT NULL,
163 `page_descr` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT ''
164) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='PDF relation pages for phpMyAdmin';
165
166-- --------------------------------------------------------
167
168--
169-- Struktura tabeli dla tabeli `pma__recent`
170--
171
172CREATE TABLE `pma__recent` (
173 `username` varchar(64) COLLATE utf8_bin NOT NULL,
174 `tables` text COLLATE utf8_bin NOT NULL
175) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Recently accessed tables';
176
177--
178-- Zrzut danych tabeli `pma__recent`
179--
180
181INSERT INTO `pma__recent` (`username`, `tables`) VALUES
182('root', '[{\"db\":\"test\",\"table\":\"lekcje\"},{\"db\":\"test\",\"table\":\"planlekcji\"},{\"db\":\"test\",\"table\":\"wychowawcy\"},{\"db\":\"test\",\"table\":\"uwagi\"},{\"db\":\"test\",\"table\":\"obeconsc\"},{\"db\":\"test\",\"table\":\"nau\"},{\"db\":\"test\",\"table\":\"oceny\"},{\"db\":\"test\",\"table\":\"tematy\"},{\"db\":\"test\",\"table\":\"dyrektorzy\"}]');
183
184-- --------------------------------------------------------
185
186--
187-- Struktura tabeli dla tabeli `pma__relation`
188--
189
190CREATE TABLE `pma__relation` (
191 `master_db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
192 `master_table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
193 `master_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
194 `foreign_db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
195 `foreign_table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
196 `foreign_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT ''
197) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Relation table';
198
199-- --------------------------------------------------------
200
201--
202-- Struktura tabeli dla tabeli `pma__savedsearches`
203--
204
205CREATE TABLE `pma__savedsearches` (
206 `id` int(5) UNSIGNED NOT NULL,
207 `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
208 `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
209 `search_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
210 `search_data` text COLLATE utf8_bin NOT NULL
211) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved searches';
212
213-- --------------------------------------------------------
214
215--
216-- Struktura tabeli dla tabeli `pma__table_coords`
217--
218
219CREATE TABLE `pma__table_coords` (
220 `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
221 `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
222 `pdf_page_number` int(11) NOT NULL DEFAULT 0,
223 `x` float UNSIGNED NOT NULL DEFAULT 0,
224 `y` float UNSIGNED NOT NULL DEFAULT 0
225) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table coordinates for phpMyAdmin PDF output';
226
227-- --------------------------------------------------------
228
229--
230-- Struktura tabeli dla tabeli `pma__table_info`
231--
232
233CREATE TABLE `pma__table_info` (
234 `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
235 `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
236 `display_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT ''
237) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table information for phpMyAdmin';
238
239-- --------------------------------------------------------
240
241--
242-- Struktura tabeli dla tabeli `pma__table_uiprefs`
243--
244
245CREATE TABLE `pma__table_uiprefs` (
246 `username` varchar(64) COLLATE utf8_bin NOT NULL,
247 `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
248 `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
249 `prefs` text COLLATE utf8_bin NOT NULL,
250 `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
251) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Tables'' UI preferences';
252
253-- --------------------------------------------------------
254
255--
256-- Struktura tabeli dla tabeli `pma__tracking`
257--
258
259CREATE TABLE `pma__tracking` (
260 `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
261 `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
262 `version` int(10) UNSIGNED NOT NULL,
263 `date_created` datetime NOT NULL,
264 `date_updated` datetime NOT NULL,
265 `schema_snapshot` text COLLATE utf8_bin NOT NULL,
266 `schema_sql` text COLLATE utf8_bin DEFAULT NULL,
267 `data_sql` longtext COLLATE utf8_bin DEFAULT NULL,
268 `tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') COLLATE utf8_bin DEFAULT NULL,
269 `tracking_active` int(1) UNSIGNED NOT NULL DEFAULT 1
270) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database changes tracking for phpMyAdmin';
271
272-- --------------------------------------------------------
273
274--
275-- Struktura tabeli dla tabeli `pma__userconfig`
276--
277
278CREATE TABLE `pma__userconfig` (
279 `username` varchar(64) COLLATE utf8_bin NOT NULL,
280 `timevalue` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
281 `config_data` text COLLATE utf8_bin NOT NULL
282) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User preferences storage for phpMyAdmin';
283
284--
285-- Zrzut danych tabeli `pma__userconfig`
286--
287
288INSERT INTO `pma__userconfig` (`username`, `timevalue`, `config_data`) VALUES
289('root', '2019-11-02 14:28:44', '{\"lang\":\"pl\",\"Console\\/Mode\":\"collapse\",\"ThemeDefault\":\"pmahomme\"}');
290
291-- --------------------------------------------------------
292
293--
294-- Struktura tabeli dla tabeli `pma__usergroups`
295--
296
297CREATE TABLE `pma__usergroups` (
298 `usergroup` varchar(64) COLLATE utf8_bin NOT NULL,
299 `tab` varchar(64) COLLATE utf8_bin NOT NULL,
300 `allowed` enum('Y','N') COLLATE utf8_bin NOT NULL DEFAULT 'N'
301) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User groups with configured menu items';
302
303-- --------------------------------------------------------
304
305--
306-- Struktura tabeli dla tabeli `pma__users`
307--
308
309CREATE TABLE `pma__users` (
310 `username` varchar(64) COLLATE utf8_bin NOT NULL,
311 `usergroup` varchar(64) COLLATE utf8_bin NOT NULL
312) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and their assignments to user groups';
313
314--
315-- Indeksy dla zrzutów tabel
316--
317
318--
319-- Indeksy dla tabeli `pma__bookmark`
320--
321ALTER TABLE `pma__bookmark`
322 ADD PRIMARY KEY (`id`);
323
324--
325-- Indeksy dla tabeli `pma__central_columns`
326--
327ALTER TABLE `pma__central_columns`
328 ADD PRIMARY KEY (`db_name`,`col_name`);
329
330--
331-- Indeksy dla tabeli `pma__column_info`
332--
333ALTER TABLE `pma__column_info`
334 ADD PRIMARY KEY (`id`),
335 ADD UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`);
336
337--
338-- Indeksy dla tabeli `pma__designer_settings`
339--
340ALTER TABLE `pma__designer_settings`
341 ADD PRIMARY KEY (`username`);
342
343--
344-- Indeksy dla tabeli `pma__export_templates`
345--
346ALTER TABLE `pma__export_templates`
347 ADD PRIMARY KEY (`id`),
348 ADD UNIQUE KEY `u_user_type_template` (`username`,`export_type`,`template_name`);
349
350--
351-- Indeksy dla tabeli `pma__favorite`
352--
353ALTER TABLE `pma__favorite`
354 ADD PRIMARY KEY (`username`);
355
356--
357-- Indeksy dla tabeli `pma__history`
358--
359ALTER TABLE `pma__history`
360 ADD PRIMARY KEY (`id`),
361 ADD KEY `username` (`username`,`db`,`table`,`timevalue`);
362
363--
364-- Indeksy dla tabeli `pma__navigationhiding`
365--
366ALTER TABLE `pma__navigationhiding`
367 ADD PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`);
368
369--
370-- Indeksy dla tabeli `pma__pdf_pages`
371--
372ALTER TABLE `pma__pdf_pages`
373 ADD PRIMARY KEY (`page_nr`),
374 ADD KEY `db_name` (`db_name`);
375
376--
377-- Indeksy dla tabeli `pma__recent`
378--
379ALTER TABLE `pma__recent`
380 ADD PRIMARY KEY (`username`);
381
382--
383-- Indeksy dla tabeli `pma__relation`
384--
385ALTER TABLE `pma__relation`
386 ADD PRIMARY KEY (`master_db`,`master_table`,`master_field`),
387 ADD KEY `foreign_field` (`foreign_db`,`foreign_table`);
388
389--
390-- Indeksy dla tabeli `pma__savedsearches`
391--
392ALTER TABLE `pma__savedsearches`
393 ADD PRIMARY KEY (`id`),
394 ADD UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`);
395
396--
397-- Indeksy dla tabeli `pma__table_coords`
398--
399ALTER TABLE `pma__table_coords`
400 ADD PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`);
401
402--
403-- Indeksy dla tabeli `pma__table_info`
404--
405ALTER TABLE `pma__table_info`
406 ADD PRIMARY KEY (`db_name`,`table_name`);
407
408--
409-- Indeksy dla tabeli `pma__table_uiprefs`
410--
411ALTER TABLE `pma__table_uiprefs`
412 ADD PRIMARY KEY (`username`,`db_name`,`table_name`);
413
414--
415-- Indeksy dla tabeli `pma__tracking`
416--
417ALTER TABLE `pma__tracking`
418 ADD PRIMARY KEY (`db_name`,`table_name`,`version`);
419
420--
421-- Indeksy dla tabeli `pma__userconfig`
422--
423ALTER TABLE `pma__userconfig`
424 ADD PRIMARY KEY (`username`);
425
426--
427-- Indeksy dla tabeli `pma__usergroups`
428--
429ALTER TABLE `pma__usergroups`
430 ADD PRIMARY KEY (`usergroup`,`tab`,`allowed`);
431
432--
433-- Indeksy dla tabeli `pma__users`
434--
435ALTER TABLE `pma__users`
436 ADD PRIMARY KEY (`username`,`usergroup`);
437
438--
439-- AUTO_INCREMENT for dumped tables
440--
441
442--
443-- AUTO_INCREMENT dla tabeli `pma__bookmark`
444--
445ALTER TABLE `pma__bookmark`
446 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
447
448--
449-- AUTO_INCREMENT dla tabeli `pma__column_info`
450--
451ALTER TABLE `pma__column_info`
452 MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
453
454--
455-- AUTO_INCREMENT dla tabeli `pma__export_templates`
456--
457ALTER TABLE `pma__export_templates`
458 MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
459
460--
461-- AUTO_INCREMENT dla tabeli `pma__history`
462--
463ALTER TABLE `pma__history`
464 MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
465
466--
467-- AUTO_INCREMENT dla tabeli `pma__pdf_pages`
468--
469ALTER TABLE `pma__pdf_pages`
470 MODIFY `page_nr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
471
472--
473-- AUTO_INCREMENT dla tabeli `pma__savedsearches`
474--
475ALTER TABLE `pma__savedsearches`
476 MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
477--
478-- Baza danych: `test`
479--
480CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
481USE `test`;
482
483-- --------------------------------------------------------
484
485--
486-- Struktura tabeli dla tabeli `dyrektorzy`
487--
488
489CREATE TABLE `dyrektorzy` (
490 `id` int(11) NOT NULL,
491 `nauczyciel` int(11) NOT NULL,
492 `pozycja` int(11) NOT NULL
493) ENGINE=InnoDB DEFAULT CHARSET=latin1;
494
495--
496-- Zrzut danych tabeli `dyrektorzy`
497--
498
499INSERT INTO `dyrektorzy` (`id`, `nauczyciel`, `pozycja`) VALUES
500(1, 31, 0),
501(3, 25, 1);
502
503-- --------------------------------------------------------
504
505--
506-- Struktura tabeli dla tabeli `klasy`
507--
508
509CREATE TABLE `klasy` (
510 `id` int(11) NOT NULL,
511 `numer` int(11) NOT NULL,
512 `nazwa` text NOT NULL
513) ENGINE=InnoDB DEFAULT CHARSET=latin1;
514
515--
516-- Zrzut danych tabeli `klasy`
517--
518
519INSERT INTO `klasy` (`id`, `numer`, `nazwa`) VALUES
520(4, 1, 'TL'),
521(5, 1, 'TI'),
522(6, 1, 'TM'),
523(7, 1, 'TOR'),
524(8, 1, 'TH'),
525(9, 1, 'TE'),
526(10, 1, 'TR');
527
528-- --------------------------------------------------------
529
530--
531-- Struktura tabeli dla tabeli `lekcje`
532--
533
534CREATE TABLE `lekcje` (
535 `id` int(11) NOT NULL,
536 `lekcja` text NOT NULL
537) ENGINE=InnoDB DEFAULT CHARSET=latin1;
538
539--
540-- Zrzut danych tabeli `lekcje`
541--
542
543INSERT INTO `lekcje` (`id`, `lekcja`) VALUES
544(0, 'nic'),
545(1, 'Polski'),
546(2, 'Matma'),
547(3, 'W-f'),
548(4, 'Filozofia'),
549(18, 'Nazwa'),
550(19, 'hejakj'),
551(20, '3b'),
552(21, 'polaczek');
553
554-- --------------------------------------------------------
555
556--
557-- Struktura tabeli dla tabeli `loginy`
558--
559
560CREATE TABLE `loginy` (
561 `id` int(11) NOT NULL,
562 `login` text NOT NULL,
563 `imie` text NOT NULL,
564 `nazwisko` text NOT NULL,
565 `haslo` text NOT NULL,
566 `email` text NOT NULL,
567 `typ` text NOT NULL,
568 `Klasa` int(11) DEFAULT NULL
569) ENGINE=InnoDB DEFAULT CHARSET=latin1;
570
571--
572-- Zrzut danych tabeli `loginy`
573--
574
575INSERT INTO `loginy` (`id`, `login`, `imie`, `nazwisko`, `haslo`, `email`, `typ`, `Klasa`) VALUES
576(1, 'admin', '', '', 'admin', 'admin', 'admin', NULL),
577(25, 'maner', 'Maner', 'JA', 'jamanewr', 'sasa@wp.pl', 'teacher', NULL),
578(30, 'monika', '', '', 'kuba10', 'bogusiam74@wp.pl', 'teacher', NULL),
579(31, 'twojstary', '', '', 'jamanewr', 'nwm@wp.pl', 'teacher', NULL),
580(32, 'uczenkl1', '', '', 'jamanewr', 'uczenkl1@wp.pl', 'uczen', 9),
581(33, 'uczenkl12', '', '', '', 'uczenkl1@wp.pl', 'uczen', 9),
582(34, 'uczenkl2', '', '', 'jamanewr', 'uczenkl1@wp.pl', 'uczen', 9),
583(35, 'uczenkl2id2', '', '', 'jamanewr', 'uczenkl1@wp.pl', 'uczen', 10),
584(36, 'uczenkl3', '', '', 'jamanewr', 'uczenkl1@wp.pl', 'uczen', 10),
585(37, 'uczenkl3id1', '', '', 'jamanewr', 'bogusiam74@wp.pl', 'uczen', 10),
586(39, 'ania', 'ania', 'ania', 'ania', 'ania@wp.pl', 'uczen', 4),
587(40, 'arek', 'arek', 'aaaa', 'arek', 'arek@wp.pl', 'uczen', 4),
588(41, 'ada', 'ada', 'aqa', 'ada', 'ada@wp.pl', 'uczen', 4);
589
590-- --------------------------------------------------------
591
592--
593-- Struktura tabeli dla tabeli `nau`
594--
595
596CREATE TABLE `nau` (
597 `id` int(11) NOT NULL,
598 `nau` text DEFAULT NULL,
599 `przedmiot1` text DEFAULT NULL
600) ENGINE=InnoDB DEFAULT CHARSET=latin1;
601
602--
603-- Zrzut danych tabeli `nau`
604--
605
606INSERT INTO `nau` (`id`, `nau`, `przedmiot1`) VALUES
607(50, '30', '3'),
608(51, '30', '18'),
609(52, '25', '19'),
610(53, '30', '1'),
611(54, '30', '19'),
612(55, '25', '3'),
613(56, '30', '21');
614
615-- --------------------------------------------------------
616
617--
618-- Struktura tabeli dla tabeli `obeconsc`
619--
620
621CREATE TABLE `obeconsc` (
622 `id` int(11) NOT NULL,
623 `data` date NOT NULL,
624 `obecnosc` int(11) NOT NULL,
625 `numer_lekcji` text NOT NULL,
626 `uczen` int(11) NOT NULL,
627 `klasa` int(11) NOT NULL,
628 `dzienTygodnia` text NOT NULL
629) ENGINE=InnoDB DEFAULT CHARSET=latin1;
630
631--
632-- Zrzut danych tabeli `obeconsc`
633--
634
635INSERT INTO `obeconsc` (`id`, `data`, `obecnosc`, `numer_lekcji`, `uczen`, `klasa`, `dzienTygodnia`) VALUES
636(313, '2018-01-03', 1, '1', 32, 9, '18'),
637(314, '2018-01-03', 1, '1', 33, 9, '18'),
638(315, '2018-01-03', 1, '1', 34, 9, '18'),
639(316, '2018-01-03', 1, '2', 32, 9, '18'),
640(317, '2018-01-03', 1, '2', 33, 9, '18'),
641(318, '2018-01-03', 1, '2', 34, 9, '18'),
642(319, '2018-01-03', 1, '3', 32, 9, '18'),
643(320, '2018-01-03', 1, '3', 33, 9, '18'),
644(321, '2018-01-03', 1, '3', 34, 9, '18'),
645(322, '2018-01-03', 1, '4', 32, 9, '18'),
646(323, '2018-01-03', 1, '4', 33, 9, '18'),
647(324, '2018-01-03', 1, '4', 34, 9, '18'),
648(325, '2018-01-03', 1, '5', 32, 9, '18'),
649(326, '2018-01-03', 1, '5', 33, 9, '18'),
650(327, '2018-01-03', 1, '5', 34, 9, '18'),
651(328, '2018-01-03', 1, '6', 32, 9, '18'),
652(329, '2018-01-03', 1, '6', 33, 9, '18'),
653(330, '2018-01-03', 1, '6', 34, 9, '18'),
654(331, '2018-01-03', 1, '7', 32, 9, '18'),
655(332, '2018-01-03', 1, '7', 33, 9, '18'),
656(333, '2018-01-03', 1, '7', 34, 9, '18'),
657(334, '2018-01-03', 1, '8', 32, 9, '18'),
658(335, '2018-01-03', 1, '8', 33, 9, '18'),
659(336, '2018-01-03', 1, '8', 34, 9, '18'),
660(337, '2018-01-03', 1, '9', 32, 9, '18'),
661(338, '2018-01-03', 1, '9', 33, 9, '18'),
662(339, '2018-01-03', 1, '9', 34, 9, '18'),
663(340, '2018-01-03', 1, '1', 35, 10, '23'),
664(341, '2018-01-03', 1, '1', 36, 10, '23'),
665(342, '2018-01-03', 1, '1', 37, 10, '23'),
666(343, '2018-01-03', 1, '2', 35, 10, '23'),
667(344, '2018-01-03', 1, '2', 36, 10, '23'),
668(345, '2018-01-03', 1, '2', 37, 10, '23'),
669(346, '2018-01-03', 1, '3', 35, 10, '23'),
670(347, '2018-01-03', 1, '3', 36, 10, '23'),
671(348, '2018-01-03', 1, '3', 37, 10, '23'),
672(349, '2018-01-03', 2, '4', 35, 10, '23'),
673(350, '2018-01-03', 2, '4', 36, 10, '23'),
674(351, '2018-01-03', 1, '4', 37, 10, '23'),
675(352, '2018-01-03', 2, '5', 35, 10, '23'),
676(353, '2018-01-03', 2, '5', 36, 10, '23'),
677(354, '2018-01-03', 1, '5', 37, 10, '23'),
678(355, '2018-01-03', 2, '6', 35, 10, '23'),
679(356, '2018-01-03', 1, '6', 36, 10, '23'),
680(357, '2018-01-03', 3, '6', 37, 10, '23'),
681(358, '2018-01-03', 3, '7', 35, 10, '23'),
682(359, '2018-01-03', 2, '7', 36, 10, '23'),
683(360, '2018-01-03', 1, '7', 37, 10, '23'),
684(361, '2018-01-03', 1, '8', 35, 10, '23'),
685(362, '2018-01-03', 3, '8', 36, 10, '23'),
686(363, '2018-01-03', 3, '8', 37, 10, '23'),
687(364, '2018-01-06', 1, '1', 35, 10, '23'),
688(365, '2018-01-06', 1, '1', 36, 10, '23'),
689(366, '2018-01-06', 1, '1', 37, 10, '23'),
690(367, '2018-01-06', 1, '2', 35, 10, '23'),
691(368, '2018-01-06', 1, '2', 36, 10, '23'),
692(369, '2018-01-06', 1, '2', 37, 10, '23'),
693(370, '2018-01-06', 1, '3', 35, 10, '23'),
694(371, '2018-01-06', 1, '3', 36, 10, '23'),
695(372, '2018-01-06', 1, '3', 37, 10, '23'),
696(373, '2018-01-06', 1, '4', 35, 10, '23'),
697(374, '2018-01-06', 1, '4', 36, 10, '23'),
698(375, '2018-01-06', 1, '4', 37, 10, '23'),
699(376, '2018-01-06', 1, '5', 35, 10, '23'),
700(377, '2018-01-06', 1, '5', 36, 10, '23'),
701(378, '2018-01-06', 1, '5', 37, 10, '23'),
702(379, '2018-01-06', 1, '6', 35, 10, '23'),
703(380, '2018-01-06', 1, '6', 36, 10, '23'),
704(381, '2018-01-06', 1, '6', 37, 10, '23'),
705(382, '2018-01-06', 1, '7', 35, 10, '23'),
706(383, '2018-01-06', 1, '7', 36, 10, '23'),
707(384, '2018-01-06', 1, '7', 37, 10, '23'),
708(385, '2018-01-06', 1, '8', 35, 10, '23'),
709(386, '2018-01-06', 1, '8', 36, 10, '23'),
710(387, '2018-01-06', 1, '8', 37, 10, '23'),
711(388, '2018-01-06', 1, '9', 35, 10, '23'),
712(389, '2018-01-06', 1, '9', 36, 10, '23'),
713(390, '2018-01-06', 1, '9', 37, 10, '23'),
714(391, '2018-01-07', 1, '1', 35, 10, '23'),
715(392, '2018-01-07', 1, '1', 36, 10, '23'),
716(393, '2018-01-07', 1, '1', 37, 10, '23'),
717(394, '2018-01-15', 1, '2', 39, 4, ''),
718(395, '2018-01-15', 1, '2', 39, 4, ''),
719(396, '2018-01-15', 2, '2', 40, 4, ''),
720(397, '2018-01-15', 3, '2', 41, 4, ''),
721(398, '2018-01-15', 3, '3', 39, 4, ''),
722(399, '2018-01-15', 1, '3', 40, 4, ''),
723(400, '2018-01-15', 1, '3', 41, 4, ''),
724(401, '2018-01-15', 1, '1', 39, 4, ''),
725(402, '2018-01-15', 1, '1', 40, 4, ''),
726(403, '2018-01-15', 1, '1', 41, 4, ''),
727(404, '2018-01-15', 1, '2', 39, 4, ''),
728(405, '2018-01-15', 3, '2', 40, 4, ''),
729(406, '2018-01-15', 2, '2', 41, 4, ''),
730(407, '2018-01-15', 1, '3', 39, 4, ''),
731(408, '2018-01-15', 2, '3', 40, 4, ''),
732(409, '2018-01-15', 1, '3', 41, 4, ''),
733(410, '2018-01-15', 1, '3', 39, 4, ''),
734(411, '2018-01-15', 1, '3', 40, 4, ''),
735(412, '2018-01-15', 3, '3', 41, 4, ''),
736(413, '2018-01-15', 3, '2', 39, 4, ''),
737(414, '2018-01-15', 2, '2', 40, 4, ''),
738(415, '2018-01-15', 1, '2', 41, 4, '');
739
740-- --------------------------------------------------------
741
742--
743-- Struktura tabeli dla tabeli `oceny`
744--
745
746CREATE TABLE `oceny` (
747 `id` int(11) NOT NULL,
748 `oceny` int(11) NOT NULL,
749 `idlekcja` int(11) NOT NULL,
750 `idlogin` int(11) NOT NULL,
751 `zaco` text NOT NULL,
752 `idklasa` int(11) NOT NULL,
753 `Data` date NOT NULL,
754 `idnauczyciel` int(11) NOT NULL
755) ENGINE=InnoDB DEFAULT CHARSET=latin1;
756
757--
758-- Zrzut danych tabeli `oceny`
759--
760
761INSERT INTO `oceny` (`id`, `oceny`, `idlekcja`, `idlogin`, `zaco`, `idklasa`, `Data`, `idnauczyciel`) VALUES
762(204, 5, 3, 35, '', 10, '2018-01-06', 30),
763(205, 6, 3, 36, '', 10, '2018-01-06', 30),
764(206, 5, 3, 37, '', 10, '2018-01-06', 30),
765(207, 1, 3, 36, '', 10, '2018-01-06', 30),
766(208, 2, 3, 35, '', 10, '2018-01-06', 30),
767(209, 3, 3, 37, '', 10, '2018-01-06', 30),
768(210, 2, 3, 36, '', 10, '2018-01-06', 30),
769(211, 1, 3, 37, '', 10, '2018-01-06', 30),
770(212, 1, 3, 35, '', 10, '2018-01-06', 30),
771(213, 2, 3, 36, '', 10, '2018-01-06', 30),
772(214, 3, 3, 37, '', 10, '2018-01-06', 30),
773(215, 2, 21, 36, '', 10, '2018-01-07', 30),
774(216, 3, 21, 36, '', 10, '2018-01-07', 30);
775
776-- --------------------------------------------------------
777
778--
779-- Struktura tabeli dla tabeli `ocenys2`
780--
781
782CREATE TABLE `ocenys2` (
783 `id` int(11) NOT NULL,
784 `oceny` int(11) NOT NULL,
785 `idlekcja` int(11) NOT NULL,
786 `idlogin` int(11) NOT NULL,
787 `zaco` text NOT NULL,
788 `idklasa` int(11) NOT NULL,
789 `Data` date NOT NULL,
790 `idnauczyciel` int(11) NOT NULL
791) ENGINE=InnoDB DEFAULT CHARSET=latin1;
792
793--
794-- Zrzut danych tabeli `ocenys2`
795--
796
797INSERT INTO `ocenys2` (`id`, `oceny`, `idlekcja`, `idlogin`, `zaco`, `idklasa`, `Data`, `idnauczyciel`) VALUES
798(12, 1, 3, 35, '', 10, '2018-01-06', 30),
799(13, 2, 3, 36, '', 10, '2018-01-06', 30),
800(14, 3, 3, 37, '', 10, '2018-01-06', 30),
801(15, 1, 3, 35, '', 10, '2018-01-06', 30),
802(16, 2, 3, 36, '', 10, '2018-01-06', 30),
803(17, 3, 3, 37, '', 10, '2018-01-06', 30),
804(18, 5, 3, 35, 'semestr2', 10, '2018-01-06', 30),
805(19, 6, 3, 36, 'semestr2', 10, '2018-01-06', 30),
806(20, 5, 3, 37, 'semestr2', 10, '2018-01-06', 30);
807
808-- --------------------------------------------------------
809
810--
811-- Struktura tabeli dla tabeli `planlekcji`
812--
813
814CREATE TABLE `planlekcji` (
815 `id` int(11) NOT NULL,
816 `klasa` int(11) NOT NULL,
817 `lekcja1` text NOT NULL,
818 `lekcja2` text NOT NULL,
819 `lekcja3` text NOT NULL,
820 `lekcja4` text NOT NULL,
821 `lekcja5` text NOT NULL,
822 `lekcja6` text NOT NULL,
823 `lekcja7` text NOT NULL,
824 `lekcja8` text NOT NULL,
825 `lekcja9` text NOT NULL,
826 `dzien` int(11) NOT NULL
827) ENGINE=InnoDB DEFAULT CHARSET=latin1;
828
829--
830-- Zrzut danych tabeli `planlekcji`
831--
832
833INSERT INTO `planlekcji` (`id`, `klasa`, `lekcja1`, `lekcja2`, `lekcja3`, `lekcja4`, `lekcja5`, `lekcja6`, `lekcja7`, `lekcja8`, `lekcja9`, `dzien`) VALUES
834(16, 9, 'Matma', 'Polski', 'Nazwa', 'Filozofia', 'Matma', 'nic', 'nic', 'nic', 'nic', 1),
835(17, 9, 'Filozofia', 'Filozofia', 'Filozofia', 'Filozofia', 'Filozofia', 'nic', 'nic', 'nic', 'nic', 2),
836(18, 9, 'W-f', 'W-f', 'W-f', 'W-f', 'nic', 'nic', 'nic', 'nic', 'nic', 3),
837(19, 9, 'Nazwa', 'Matma', 'Polski', 'W-f', 'Matma', 'nic', 'nic', 'nic', 'nic', 4),
838(20, 9, 'Filozofia', 'W-f', 'W-f', 'W-f', 'Filozofia', 'nic', 'nic', 'nic', 'nic', 5),
839(21, 10, 'Filozofia', 'W-f', 'Nazwa', 'Matma', 'Matma', 'Matma', 'Nazwa', 'polaczek', 'Nazwa', 1),
840(22, 10, 'nic', 'nic', 'nic', 'nic', 'nic', 'nic', 'nic', 'nic', 'nic', 2),
841(23, 10, 'Matma', 'W-f', 'hejakj', 'nic', 'Matma', 'nic', 'W-f', 'Filozofia', 'Nazwa', 3),
842(24, 10, 'nic', 'nic', 'nic', 'nic', 'nic', 'nic', 'nic', 'nic', 'nic', 4),
843(25, 10, 'nic', 'nic', 'nic', 'nic', 'nic', 'nic', 'nic', 'nic', 'nic', 5);
844
845-- --------------------------------------------------------
846
847--
848-- Struktura tabeli dla tabeli `tematy`
849--
850
851CREATE TABLE `tematy` (
852 `id` int(11) NOT NULL,
853 `idklasa` int(11) NOT NULL,
854 `idlekcja` int(11) NOT NULL,
855 `data` date NOT NULL,
856 `temat` text NOT NULL
857) ENGINE=InnoDB DEFAULT CHARSET=latin1;
858
859--
860-- Zrzut danych tabeli `tematy`
861--
862
863INSERT INTO `tematy` (`id`, `idklasa`, `idlekcja`, `data`, `temat`) VALUES
864(1, 4, 3, '2018-01-15', 'temat lekcji 1'),
865(2, 4, 3, '2018-01-15', 'temat lekcji 1'),
866(3, 4, 3, '2018-01-15', 'temat lekcji 1'),
867(4, 4, 2, '2018-01-15', 'temat nr 1');
868
869-- --------------------------------------------------------
870
871--
872-- Struktura tabeli dla tabeli `uwagi`
873--
874
875CREATE TABLE `uwagi` (
876 `id` int(11) NOT NULL,
877 `id_login` int(11) NOT NULL,
878 `id_nau` int(11) NOT NULL,
879 `tytul` text NOT NULL,
880 `tresc` text NOT NULL
881) ENGINE=InnoDB DEFAULT CHARSET=latin1;
882
883--
884-- Zrzut danych tabeli `uwagi`
885--
886
887INSERT INTO `uwagi` (`id`, `id_login`, `id_nau`, `tytul`, `tresc`) VALUES
888(3, 33, 30, 'assa', 'assa'),
889(4, 31, 30, 'sa', 'saas'),
890(5, 33, 30, 'hejka', 'stulejka'),
891(6, 33, 30, 'pong', 'foty'),
892(7, 35, 30, 'palenie', 'jest w gronie palaczy');
893
894-- --------------------------------------------------------
895
896--
897-- Struktura tabeli dla tabeli `wiadomosci`
898--
899
900CREATE TABLE `wiadomosci` (
901 `ID` int(11) NOT NULL,
902 `ID_nauczyciela` int(11) NOT NULL,
903 `Autor` text NOT NULL,
904 `nazwa` text NOT NULL,
905 `tresc` text NOT NULL
906) ENGINE=InnoDB DEFAULT CHARSET=latin1;
907
908--
909-- Zrzut danych tabeli `wiadomosci`
910--
911
912INSERT INTO `wiadomosci` (`ID`, `ID_nauczyciela`, `Autor`, `nazwa`, `tresc`) VALUES
913(1, 25, 'uczenkl12', 'tes', 'tseteset'),
914(2, 30, 'uczenkl12', 'rfgr', 'trtegdgf');
915
916-- --------------------------------------------------------
917
918--
919-- Struktura tabeli dla tabeli `wizyty_wicedyrektorow`
920--
921
922CREATE TABLE `wizyty_wicedyrektorow` (
923 `id` int(11) NOT NULL,
924 `klasa` int(11) NOT NULL,
925 `lekcja` int(11) NOT NULL,
926 `data` date NOT NULL,
927 `opis` text NOT NULL,
928 `wicedyrektor` int(11) NOT NULL
929) ENGINE=InnoDB DEFAULT CHARSET=latin1;
930
931--
932-- Zrzut danych tabeli `wizyty_wicedyrektorow`
933--
934
935INSERT INTO `wizyty_wicedyrektorow` (`id`, `klasa`, `lekcja`, `data`, `opis`, `wicedyrektor`) VALUES
936(4, 5, 7, '0000-00-00', 'opinia o klasie 1TI', 25),
937(9, 9, 3, '0000-00-00', '1TE opinia', 25),
938(10, 8, 6, '0000-00-00', '1TH', 25),
939(11, 7, 7, '0000-00-00', 'opinia na temat klasy 1TOR', 25),
940(12, 9, 3, '0000-00-00', 'ddd', 25),
941(13, 0, 0, '0000-00-00', '', 25),
942(14, 9, 4, '0000-00-00', 'sss', 25),
943(15, 10, 3, '2018-01-30', 'sss', 25),
944(16, 10, 3, '2018-01-30', 'sss', 25);
945
946-- --------------------------------------------------------
947
948--
949-- Struktura tabeli dla tabeli `wychowawcy`
950--
951
952CREATE TABLE `wychowawcy` (
953 `id` int(11) NOT NULL,
954 `nauczyciel` int(11) NOT NULL,
955 `klasa` int(11) NOT NULL
956) ENGINE=InnoDB DEFAULT CHARSET=latin1;
957
958--
959-- Zrzut danych tabeli `wychowawcy`
960--
961
962INSERT INTO `wychowawcy` (`id`, `nauczyciel`, `klasa`) VALUES
963(2, 25, 4);
964
965-- --------------------------------------------------------
966
967--
968-- Struktura tabeli dla tabeli `wywiadowka`
969--
970
971CREATE TABLE `wywiadowka` (
972 `ID` int(11) NOT NULL,
973 `klasa` text NOT NULL,
974 `tytul` text NOT NULL,
975 `data` date NOT NULL,
976 `sala` int(11) NOT NULL,
977 `aktywna` tinyint(4) NOT NULL
978) ENGINE=InnoDB DEFAULT CHARSET=latin1;
979
980--
981-- Zrzut danych tabeli `wywiadowka`
982--
983
984INSERT INTO `wywiadowka` (`ID`, `klasa`, `tytul`, `data`, `sala`, `aktywna`) VALUES
985(1, '', 'test', '2018-01-12', 15, 0),
986(2, '', 'cvx', '2017-12-29', 3, 0),
987(3, '', 'gds', '2017-12-27', 0, 0),
988(4, '', 'gds', '2017-12-27', 0, 0),
989(5, '9', 'fgfgn', '2018-01-18', 3, 1);
990
991--
992-- Indeksy dla zrzutów tabel
993--
994
995--
996-- Indeksy dla tabeli `dyrektorzy`
997--
998ALTER TABLE `dyrektorzy`
999 ADD PRIMARY KEY (`id`);
1000
1001--
1002-- Indeksy dla tabeli `klasy`
1003--
1004ALTER TABLE `klasy`
1005 ADD PRIMARY KEY (`id`);
1006
1007--
1008-- Indeksy dla tabeli `lekcje`
1009--
1010ALTER TABLE `lekcje`
1011 ADD PRIMARY KEY (`id`);
1012
1013--
1014-- Indeksy dla tabeli `loginy`
1015--
1016ALTER TABLE `loginy`
1017 ADD PRIMARY KEY (`id`);
1018
1019--
1020-- Indeksy dla tabeli `nau`
1021--
1022ALTER TABLE `nau`
1023 ADD PRIMARY KEY (`id`);
1024
1025--
1026-- Indeksy dla tabeli `obeconsc`
1027--
1028ALTER TABLE `obeconsc`
1029 ADD PRIMARY KEY (`id`);
1030
1031--
1032-- Indeksy dla tabeli `oceny`
1033--
1034ALTER TABLE `oceny`
1035 ADD PRIMARY KEY (`id`);
1036
1037--
1038-- Indeksy dla tabeli `ocenys2`
1039--
1040ALTER TABLE `ocenys2`
1041 ADD PRIMARY KEY (`id`);
1042
1043--
1044-- Indeksy dla tabeli `planlekcji`
1045--
1046ALTER TABLE `planlekcji`
1047 ADD PRIMARY KEY (`id`);
1048
1049--
1050-- Indeksy dla tabeli `tematy`
1051--
1052ALTER TABLE `tematy`
1053 ADD PRIMARY KEY (`id`);
1054
1055--
1056-- Indeksy dla tabeli `uwagi`
1057--
1058ALTER TABLE `uwagi`
1059 ADD PRIMARY KEY (`id`);
1060
1061--
1062-- Indeksy dla tabeli `wiadomosci`
1063--
1064ALTER TABLE `wiadomosci`
1065 ADD PRIMARY KEY (`ID`);
1066
1067--
1068-- Indeksy dla tabeli `wizyty_wicedyrektorow`
1069--
1070ALTER TABLE `wizyty_wicedyrektorow`
1071 ADD PRIMARY KEY (`id`);
1072
1073--
1074-- Indeksy dla tabeli `wychowawcy`
1075--
1076ALTER TABLE `wychowawcy`
1077 ADD PRIMARY KEY (`id`);
1078
1079--
1080-- Indeksy dla tabeli `wywiadowka`
1081--
1082ALTER TABLE `wywiadowka`
1083 ADD PRIMARY KEY (`ID`);
1084
1085--
1086-- AUTO_INCREMENT for dumped tables
1087--
1088
1089--
1090-- AUTO_INCREMENT dla tabeli `dyrektorzy`
1091--
1092ALTER TABLE `dyrektorzy`
1093 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
1094
1095--
1096-- AUTO_INCREMENT dla tabeli `klasy`
1097--
1098ALTER TABLE `klasy`
1099 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
1100
1101--
1102-- AUTO_INCREMENT dla tabeli `lekcje`
1103--
1104ALTER TABLE `lekcje`
1105 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
1106
1107--
1108-- AUTO_INCREMENT dla tabeli `loginy`
1109--
1110ALTER TABLE `loginy`
1111 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;
1112
1113--
1114-- AUTO_INCREMENT dla tabeli `nau`
1115--
1116ALTER TABLE `nau`
1117 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;
1118
1119--
1120-- AUTO_INCREMENT dla tabeli `obeconsc`
1121--
1122ALTER TABLE `obeconsc`
1123 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=416;
1124
1125--
1126-- AUTO_INCREMENT dla tabeli `oceny`
1127--
1128ALTER TABLE `oceny`
1129 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=217;
1130
1131--
1132-- AUTO_INCREMENT dla tabeli `ocenys2`
1133--
1134ALTER TABLE `ocenys2`
1135 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
1136
1137--
1138-- AUTO_INCREMENT dla tabeli `planlekcji`
1139--
1140ALTER TABLE `planlekcji`
1141 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
1142
1143--
1144-- AUTO_INCREMENT dla tabeli `tematy`
1145--
1146ALTER TABLE `tematy`
1147 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
1148
1149--
1150-- AUTO_INCREMENT dla tabeli `uwagi`
1151--
1152ALTER TABLE `uwagi`
1153 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
1154
1155--
1156-- AUTO_INCREMENT dla tabeli `wiadomosci`
1157--
1158ALTER TABLE `wiadomosci`
1159 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
1160
1161--
1162-- AUTO_INCREMENT dla tabeli `wizyty_wicedyrektorow`
1163--
1164ALTER TABLE `wizyty_wicedyrektorow`
1165 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
1166
1167--
1168-- AUTO_INCREMENT dla tabeli `wychowawcy`
1169--
1170ALTER TABLE `wychowawcy`
1171 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
1172
1173--
1174-- AUTO_INCREMENT dla tabeli `wywiadowka`
1175--
1176ALTER TABLE `wywiadowka`
1177 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
1178COMMIT;
1179
1180/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1181/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1182/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;