rXwwPFJV

1-- phpMyAdmin SQL Dump
2-- version 4.4.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Czas generowania: 30 Wrz 2015, 09:36
7-- Wersja serwera: 5.6.26
8-- Wersja PHP: 5.6.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Baza danych: `szkola`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabeli dla tabeli `ocena`
27--
28
29CREATE TABLE IF NOT EXISTS `ocena` (
30  `id` int(10) unsigned NOT NULL,
31  `przedmiot_id` int(10) unsigned NOT NULL,
32  `uczen_id` int(10) unsigned NOT NULL,
33  `ocena` int(10) unsigned DEFAULT NULL,
34  `dataWystawienia` date DEFAULT NULL
35) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
36
37--
38-- Zrzut danych tabeli `ocena`
39--
40
41INSERT INTO `ocena` (`id`, `przedmiot_id`, `uczen_id`, `ocena`, `dataWystawienia`) VALUES
42(1, 1, 2, 5, '2015-09-03'),
43(2, 1, 2, 6, '2015-09-03'),
44(3, 1, 1, 5, '2015-09-03'),
45(4, 1, 1, 6, '2015-09-03'),
46(5, 1, 2, 1, '2015-09-03'),
47(6, 1, 2, 1, '2015-09-03'),
48(7, 1, 2, 4, '2015-09-03'),
49(8, 4, 1, 3, '2015-09-10'),
50(9, 4, 1, 4, '2015-09-15'),
51(10, 4, 1, 3, '2015-09-10'),
52(11, 4, 1, 4, '2015-09-15'),
53(12, 4, 1, 5, '2015-09-10'),
54(13, 4, 1, 5, '2015-09-15'),
55(14, 4, 2, 3, '2015-09-22'),
56(15, 4, 2, 1, '2015-09-15'),
57(16, 4, 2, 3, '2015-09-22'),
58(17, 4, 2, 1, '2015-09-15');
59
60-- --------------------------------------------------------
61
62--
63-- Struktura tabeli dla tabeli `uczen`
64--
65
66CREATE TABLE IF NOT EXISTS `uczen` (
67  `id` int(10) unsigned NOT NULL,
68  `imie` text,
69  `nazwisko` text,
70  `PESEL` text,
71  `klasa` text
72) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
73
74--
75-- Zrzut danych tabeli `uczen`
76--
77
78INSERT INTO `uczen` (`id`, `imie`, `nazwisko`, `PESEL`, `klasa`) VALUES
79(1, 'Ewa', 'Kowalska', '00000000001', '1a'),
80(2, 'Jan', 'Kowalski', '00000000002', '1a');
81
82--
83-- Indeksy dla zrzutów tabel
84--
85
86--
87-- Indexes for table `ocena`
88--
89ALTER TABLE `ocena`
90  ADD PRIMARY KEY (`id`);
91
92--
93-- Indexes for table `uczen`
94--
95ALTER TABLE `uczen`
96  ADD PRIMARY KEY (`id`);
97
98--
99-- AUTO_INCREMENT for dumped tables
100--
101
102--
103-- AUTO_INCREMENT dla tabeli `ocena`
104--
105ALTER TABLE `ocena`
106  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
107--
108-- AUTO_INCREMENT dla tabeli `uczen`
109--
110ALTER TABLE `uczen`
111  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
112/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
113/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
114/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;