giUJpNYY

1CREATE DATABASE IF NOT EXISTS `UPI`;
2USE `UPI`;
3
4CREATE TABLE IF NOT EXISTS `classes` (
5  `class_id` int(5) NOT NULL AUTO_INCREMENT,
6  `title` varchar(200) NOT NULL,
7  PRIMARY KEY (`class_id`)
8) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
9INSERT INTO `classes` (`class_id`, `title`) VALUES
10	(1, 'Programowanie w C++'),
11	(2, 'Grafika komputerowa'),
12	(3, 'Aplikacje sieciowe');
13
14CREATE TABLE IF NOT EXISTS `users` (
15  `username` varchar(50) NOT NULL,
16  `password` varchar(100) NOT NULL,
17  `full_name` varchar(100) NOT NULL,
18  `role` varchar(50) NOT NULL,
19  `enabled` tinyint(1) NOT NULL,
20  PRIMARY KEY (`username`)
21) ENGINE=InnoDB DEFAULT CHARSET=latin1;
22INSERT INTO `users` (`username`, `password`, `full_name`, `role`, `enabled`) VALUES
23	('adminKarol', '$2a$10$N0eqNiuikWCy9ETQ1rdau.XEELcyEO7kukkfoiNISk/9F7gw6eB0W', ' Karol Kowalski', 'ROLE_ADMIN', 1),
24	('pracownikLeon', '$2a$10$N0eqNiuikWCy9ETQ1rdau.XEELcyEO7kukkfoiNISk/9F7gw6eB0W', 'Leon Lewandowski', 'ROLE_STUFF', 1),
25	('studentPiotr', '$2a$10$QifQnP.XqXDW0Lc4hSqEg.GhTqZHoN2Y52/hoWr4I5ePxK7D2Pi8q', 'Piotr Paciorek', 'ROLE_USER', 1);