#Uncomment lines with '#'
#Please create test accounts locally in following order

#teacher1 - id: 1 username: teacher1 password: teacher1 // CS teacher
#teacher2 - id: 2 username: teacher2 password: teacher2 // Language teacher
#teacher3 - id: 3 username: teacher3 password: teacher3 // Math teacher

#student1 - id: 4 username: student1 password: student1
#student2 - id: 5 username: student2 password: student2
#student3 - id: 6 username: student3 password: student3

INSERT INTO security.role(
	id, parent_id, role_name)
	VALUES
(1, null, 'Teacher'),
(2, null, 'Student'),
(3, null, 'Admin');

INSERT INTO security.account_role(
	account_id, role_id)
	VALUES
    (1, 1),
    (2, 1),
    (3, 1),
    (4, 2),
    (5, 2),
    (6, 2);

INSERT INTO site.currency(
	id, name, symbol)
	VALUES
    (1, 'PLN', 'ZL'),
    (2, 'Dollar', '$'),
    (3, 'Euro', '€');


INSERT INTO site.category(
	id, parent_id, name, description)
	VALUES
(1, null, 'Computer Science', 'Study of the theory, experimentation, and engineering that form the basis for the design and use of computers'),
(2, null, 'Languages', 'Systems that consists of the development, acquisition, maintenance and use of complex systems of communication, particularly the human ability to do so'),
(3, null, 'Mathematics', 'Study of objects and their relations');


INSERT INTO site.course(
	id, currency_id, teacher_id, name, description, participants, max_participants, price, mettings)
	VALUES
(1, 1, 1, 'Introduction to programming', 'This is the best programming course ever', 0, 4, 329.99, 3),
(2, 1, 1, 'Object-oriented programming', 'Programming paradigm used commonly in CS industry', 0, 3, 189.99, 2),
(3, 1, 1, 'C++ for beginners', 'Basics of C and C++', 0, 4, 229.99, 3),

(4, 1, 2, 'German', 'Basic of german language', 0, 6, 249.99, 2),
(5, 1, 2, 'French for dummies', 'French for non-french people', 0, 12, 499.99, 6),

(6, 1, 3, 'Mathematical analysis', 'Derivates, integrals and all that hard stuff', 0, 4, 329.99, 3);

INSERT INTO site.course_category(
	category_id, course_id)
	VALUES
	(1, 1),
	(1, 2),
	(1, 3),
	(2, 4),
	(2, 5),
	(3, 6);