-
Notifications
You must be signed in to change notification settings - Fork 0
/
INSERT.sql
71 lines (53 loc) · 3.79 KB
/
INSERT.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
INSERT INTO Profiles (email, password, role, ip, active)
VALUES ('agnieszka.lasota2@vp.pl', '12c44a927ee9fc12f97ee80c55353780', 'attendee', INET_ATON('10.1.220.76'), 1);
INSERT INTO Profiles (email, password, role, ip, active)
VALUES ('kamil.cecherz@gmail.com', 'ef21dbe084b394c9a8cd1a65fd7e54ee', 'admin', INET_ATON('15.10.221.16'), 1);
INSERT INTO Profiles (email, password, role, ip, active)
VALUES ('bed46@wp.pl', '36d9349a9c3b70184b209f3acf69ed03', 'attendee', INET_ATON('10.1.220.77'), 1);
INSERT INTO Profiles (email, password, role, ip, active)
VALUES ('wolnygosc@interia.pl', '3bfa575c4e2bd3e3470defa718dca2ed', 'trainer', INET_ATON('10.19.220.76'), 1);
INSERT INTO Profiles (email, password, role, ip, active)
VALUES ('a.kowal16@tlen.pl', '7ffe7df02ac3ce14e7ad6c6048df1352', 'attendee', INET_ATON('100.10.220.76'), 1);
INSERT INTO Profiles (email, password, role, ip, active)
VALUES ('radekignasiak13@onet.pl', '6e1cb029e0e57561a190af445d8287f7', 'attendee', INET_ATON('108.19.30.76'), 1);
INSERT INTO Profiles (email, password, role, ip, active)
VALUES ('m.wlazlak@wsparciespoleczne.pl', '967133b87c245338e5652eae9e33e838', 'attendee', INET_ATON('34.22.22.1'), 1);
INSERT INTO Attendees (idprof, name, surname, phone, city, postcode, street)
VALUES (1, 'Agnieszka', 'Lasota', '+48 609 383 855', 'Ksawerów', '95-054', 'Wschodnia 26');
INSERT INTO Attendees (idprof, name, surname, phone, city, postcode, street)
VALUES (2, 'Kamil', 'Cecherz', '+48 798 996 422', 'Łódź', '96-018', 'Powstańców Wielkopolskich 24/17');
INSERT INTO Attendees (idprof, name, surname, phone, city, postcode, street)
VALUES (3, 'Łukasz', 'Bednarski', '+48 786 207 883', 'Łęczyca', '99-100', 'Ozorkowska 9');
INSERT INTO Attendees (idprof, name, surname, phone, city, postcode, street)
VALUES (4, 'Adam', 'Wolniewicz', '+48 693 044 971', 'Łódź', '90-001', 'Komandorska 3/2');
INSERT INTO Attendees (idprof, name, surname, phone, city, postcode, street)
VALUES (5, 'Adam', 'Kowalewski', '+48 602 732 532', 'Tomaszów Mazowiecki', '97-200', 'Głowackiego 19a/55');
INSERT INTO Attendees (idprof, name, surname, phone, city, postcode, street)
VALUES (6, 'Radosław', 'Ignasiak', '+48 506 601 295', 'Łódź', '90-001', 'Leopolda Tyrmanda 104/22');
INSERT INTO Attendees (idprof, name, surname, phone, city, postcode, street)
VALUES (7, 'Małgorzata', 'Wlaźlak', '+48 796 141 420', 'Warszawa', '02-321', 'Aleje Jerozolimskie 107a/3');
INSERT INTO Courses (title, start_date, end_date, description, max_attende)
VALUES ('Nowoczesne aplikacje w Java EE',
'2019-05-20 14:30:00',
'2019-07-20 16:00:00',
'Tworzenie aplikacji z wykorzystaniem JDBC, Servletów, MYSQL, JSP',
12);
INSERT INTO Courses (title, start_date, end_date, description, max_attende)
VALUES ('Podstawy HTML I CSS',
'2019-05-20 18:30:00',
'2019-05-25 18:30:00',
'Nauka tworzenia stron WWW od podstaw, FTP',
30);
INSERT INTO Courses (title, start_date, end_date, description, max_attende)
VALUES ('Analiza danych tekstowych i języka naturalnego (Python)',
'2019-07-10 12:30:00',
'2019-07-13 17:00:00',
'Nauczenie szeregu narzędzi do pracy z danymi tekstowymi, przedstawienie szeregu
przykładów użycia pokrywających większość tematów tej dziedziny.',
10);
INSERT INTO Workplaces (name, city, street, floor, room) VALUES ('Urbanica', 'Łódź', 'Wróblewskiego 18',8, 302);
INSERT INTO Workplaces (name, city, street, floor, room) VALUES ('Sages sp. z.o.o', 'Warszawa', 'Nowogródzka 62c',null, null);
INSERT INTO Subscriptions(idcour, idworkpl, idattend) VALUES (1, 1, 2);
INSERT INTO Subscriptions(idcour, idworkpl, idattend) VALUES (2, 2, 1);
INSERT INTO Subscriptions(idcour, idworkpl, idattend) VALUES (2, 2, 5);
INSERT INTO Subscriptions(idcour, idworkpl, idattend) VALUES (2, 2, 6);